sub TotalSum()
dim wks as worksheet
for each wks in thisworkbook.worksheets
wks.range("A3") = "Total"
wks.range("B4") = "current"
next
end sub



--
When you lose your mind, you free your life.


"STEVEB" wrote:


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