selecting a range
 

I am trying to do the following.

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


--
jhahes
------------------------------------------------------------------------
jhahes's Profile: http://www.excelforum.com/member.php...o&userid=23596
View this thread: http://www.excelforum.com/showthread...hreadid=384644

selecting a range
 

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. fo
example to select from I3 to I300 the second line of the macro shoul
look like

Range("I3:I300").Select

Hope this helps!

Regards

Aaron Stockle

--
astockley200
-----------------------------------------------------------------------
astockley2005's Profile: http://www.excelforum.com/member.php...fo&userid=2492
View this thread: http://www.excelforum.com/showthread.php?threadid=38464