with workbooks("Maker.xls")
for each sh in .worksheets
sh.cells.formula = sh.cells.value
next
.SaveAs Thisworkbook.path & "\Maker II.xls"
end with
--
Regards,
Tom Ogilvy
"sungen99" wrote:
I believe this is simple I just dont know how to do it. Lets say I have
a file called €śMaker€ť that gets its data for various places. I want to
SAVE this as €śMaker II€ť but only now with the values of the cells not
the actual links.
Thank you for your help.
--
sungen99
------------------------------------------------------------------------
sungen99's Profile: http://www.excelforum.com/member.php...fo&userid=9144
View this thread: http://www.excelforum.com/showthread...hreadid=564808