Select Range of cells when rows are known, current column is not.

Lets say cell c12 is the active cell. How would one select Range("C2:C7") in VBA if one did not know the column letter, only the row numbers.


Something like:

Range(activecell.column + "2:" + activecell.column + "7").select

I know that activecell.column for column C = 3 and the code above does not work (big surprise). I'm pretty sure there must be a simple, straightforward way to get the column letter out of the activecell.

How would one reference the column?

Thanks,

BB

Welcome to a can of worms.

Please Login or Register  to view this content.

Originally Posted by captbluefin

Unfortunately, the column letter is unknown. We know which rows of cells need to be selected. It is the letter for the column that is unknown. If we knew which column letter to use, a simple select statement would suffice. The only unknown is the column letter.

If you were to use....

Please Login or Register  to view this content.

It would work, but only if the active cell were not on row10 or up.

That is why I said, "welcome to a can of worms".