Dim xSheet as worksheet
For Each xSheet in Thisworkbook
xSheet.range("A3").value="Total"
xSheet.range("C4").value="Current"
Next

or something similar....


"STEVEB" wrote in
message ...

Hi All,

Does anyone have any suggestions for entering the text "Total" in Cell
A3 and "current" in Cell B4 on on each sheet in a workbook?

Any help would be greatly appreciated!


--
STEVEB
------------------------------------------------------------------------
STEVEB's Profile:
http://www.excelforum.com/member.php...fo&userid=1872
View this thread: http://www.excelforum.com/showthread...hreadid=489111