Selection of Column

[Rachanab]

Hello

I want to Select the data from the column, where i am using a code which select first last cell value from down and then i want to select the data from that cell value, but i dont want to select the first row(header of table)

for that I am using following code

Range("C1048576").Select
ActiveCell.End(xlUp).Select
Range(ActiveCell, ActiveCell.End(xlUp).Rows - 1).Select

It is showing an error message.

Please provide me the code for the same

Thanks and Regrads
Rachana

 

[Joe4]

You should be able to do that with this single line:
Range("C2:C" & Cells(Rows.Count, "C").End(xlUp).Row).Select

 

[Rick Rothstein]

You should be able to do that with this single line:
Range("C2:C" & Cells(Rows.Count, "C").End(xlUp).Row).Select

Up until recently, that is how I coded the argument to the Range property, but I have started using this shorter method which, besides being short, I like because it eliminates the concatentation as well...

Range("C2", Cells(Rows.Count, "C").End(xlUp)).Select

 

[Rachanab]

Dear Rick

Thanks for your help
As i am very new to programming i required your help very frequently.

Regards
Rachana