vba select same cell across all worksheets
 

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

vba select same cell across all worksheets
 

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


--
Regards Ron de Bruin
http://www.rondebruin.nl


"tcnolan" wrote in message om...
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

vba select same cell across all worksheets
 

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!