View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
astockley2005[_2_] astockley2005[_2_] is offline
external usenet poster
 
Posts: 1
Default 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