Thread: need some help with selecting a sheet in a loop again
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gary Keramidas[_2_] Gary Keramidas[_2_] is offline
external usenet poster
  
Posts: 364
Default need some help with selecting a sheet in a loop again
i have tabs renamed, so i am using this

For c = 2 To 13

Sheet2.Range("C5:E5").Copy
Range("C5:E5").PasteSpecial xlPasteValues, xlPasteSpecialOperationAdd '
(this range is on sheet1)
Next c


i want to replace the 2 with the c so it selects the range of sheets from 2
to 13.


any help appreciated
--


Gary



Reply With QuoteReply With Quote