How to select all of specified column?

[ks100]

1. Select column with header "Units" in Row 1
2. Select the ENTIRE column

I am assuming it is something like:

Please Login or Register  to view this content.

But I don't know what goes after that

[ks100]

Nevermind, figured it out.

Please Login or Register  to view this content.

[Kaper]

"following your way":

Please Login or Register  to view this content.

but I'd rather do

Please Login or Register  to view this content.

[ks100]

rows(1).find seems a lot more elegant. I have a LOT of scripts that require matching stuff in the header column. How would I use the rows(1).find? Can you show me an example?

Is there a way using this command to deal with spreadsheets where the header row may be as far down as row 10? Some of the sheets I work with have headers that far down.

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.

[ks100]

rows(1).find seems a lot more elegant. I have a LOT of scripts that require matching stuff in the header column. How would I use the rows(1).find? Can you show me an example?

Is there a way using this command to deal with spreadsheets where the header row may be as far down as row 10? Some of the sheets I work with have headers that far down.

Would this work:

Please Login or Register  to view this content.

or this?

Please Login or Register  to view this content.

[ks100]

This seems to work for when the header might be in any row 1-10. SEEMS to work. Does it look ok? It worked on the one I tested it with.

Please Login or Register  to view this content.

[Kaper]

You earlier said just about row1. Has it changed? And about the column (with end(xldown) you may select only part of it). keeping early description as binding I'd do:

Please Login or Register  to view this content.

[ks100]

You earlier said just about row1. Has it changed? And about the column (with end(xldown) you may select only part of it). keeping early description as binding I'd do:

Please Login or Register  to view this content.

I added the rngaddress.entirecolumn.select. What does your code do that mine above doesn't? Just curious since yours is longer and mine seemed to work.