need some help with selecting a sheet in a loop again
bob:
this doesn't seem to work. could be 2 reasons:
1. i have the tabs renamed, doesn't that make a difference when using the
worksheet function?
2. also, isn't there a space or something in the number that c represents?
if i combine them and use a msgbox to display. it shows sheet 2
--
Gary
"Bob Phillips" wrote in message
...
For c = 2 To 13
Worksheet("Sheet" & c).Range("C5:E5").Copy
Range("C5:E5").PasteSpecial xlPasteValues, xlPasteSpecialOperationAdd '
(this range is on sheet1)
Next c
--
HTH
Bob Phillips
"Gary Keramidas" wrote in message
...
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
|