selecting a range-, I want it to select I3: to the end of the column.

[jhahes]

I am trying to do the following.

With a macro, I want it to select I3: to the end of the column.

[astockley2005]

This is simple...

the macro should look like this


Sub selectcolumn_I_from3rdcell ()

Sheets("Sheet1").Activate
Range("I3:I65536").Select

End Sub


You can change the number 65536 to any number smaller than that. for example to select from I3 to I300 the second line of the macro should look like

Range("I3:I300").Select

Hope this helps!

Regards

Aaron Stockley