View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
saziz[_58_] saziz[_58_] is offline
external usenet poster
 
Posts: 1
Default syntax for range selection


Hi folks,
I have a range say from A2:B11 on a sheet
range ("A2:B11").select
with selection I am formating a bunch of things
then I like to select an identical range below that
range ("A12:B21")
What would be the syntax for this increment in range?
Then I am going to repeat the formating steps on this range.
It would do this untill the end of data.
Appreciate your help please.
Thanks
Syed


--
saziz
------------------------------------------------------------------------
saziz's Profile: http://www.excelforum.com/member.php...fo&userid=6350
View this thread: http://www.excelforum.com/showthread...hreadid=498394