vba select same cell across all worksheets

[tcnolan]

Hi...

I am trying, in vba, to select one cell across all the sheets in a
workbook and Copy/Paste Special values.

Can anyone help with the code to select the same cell in all the
worksheets? The sheetnames will not always be the same.

Thank you,

Terry

 

[Ron de Bruin]

One way

Sub test()
Dim sh As Worksheet
For Each sh In ThisWorkbook.Worksheets
sh.Range("B1").Value = sh.Range("B1").Value
Next
End Sub

 

[Terry Nolan]

Hi Ron,

Thanks so much...that worked perfectly.

Terry



*** Sent via Devdex http://www.devdex.com ***
Don't just participate in USENET...get rewarded for it!