Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Specifying Full Column Range

Status
Not open for further replies.

vincej

Technical User
Nov 13, 2002
7
US
I am trying to write into vb code the following command but am unable to figure out how to phrase it in code:
"Is in Column C"
This will be inputted into an "If - Then" statement. Any suggestions will help. Thanks.[noevil]
 
What sort of columns are you talking about?
Check faq222-2244 as I don't understand your requirements at present


________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'
 
I'm just trying to single out a column in Excel
 
Is this VB6 or VBA?

Show us the code you've got, and show us what you want out of it.

To select a whole column in VBA(Excel) use:
Columns("F:F").Select


________________________________________________________________
If you want to get the best response to a question, please check out FAQ222-2244 first

'People who live in windowed environments shouldn't cast pointers.'
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top