Select AtiveCell column values

[22strider]

Hello,

Could someone please help with VBA code for selecting ActiveCell column values. The Column starts from row1 and upto the last cell with a value. I am using Excel 2007. I intend to use this code selecting cells in a column that may have some blank cells between first cell and last cell (with the value) for copying.

Regards,
Rajesh

 

[Rick Rothstein]

Assuming your values are constants and not formulas, this should work...

Columns("A").SpecialCells(xlConstants).Select

I assumed your column was Column A... if that is wrong, then change the "A" to the correct column letter.

 

[22strider]

Assuming your values are constants and not formulas, this should work...

Columns("A").SpecialCells(xlConstants).Select

I assumed your column was Column A... if that is wrong, then change the "A" to the correct column letter.

Hello Rick,

Thank you for your message. Is it possible to select column of the 'ActiveCell'?

 

[Rick Rothstein]

Is this what you mean...

ActiveCell.EntireColumn.Select

or this...

ActiveCell.EnitireColumn.SpecialCells(xlConstants).Select

 

[22strider]

Is this what you mean...

ActiveCell.EntireColumn.Select

or this...

ActiveCell.EnitireColumn.SpecialCells(xlConstants).Select

Hello Rick,

Thanks again. Yes I selecting column (with Active Cell) is my requirement.

Regards,
Rajesh