Thread: Copy part of worksheet in VBA
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ruatha[_8_] Ruatha[_8_] is offline
external usenet poster
  
Posts: 1
Default Copy part of worksheet in VBA

Hi, I'm here to ask for even more.
Can I get the text in cell "I2" into the filenamne.

As in (approximation) :
Dim Newname as string
Set newname = ActiveWorkBook.Sheets("Jourer").range("I2").Value

and add that to the filename.

Everything I try it says "Object Required (Error 424)"..


--
Ruatha
------------------------------------------------------------------------
Ruatha's Profile: http://www.excelforum.com/member.php...o&userid=31083
View this thread: http://www.excelforum.com/showthread...hreadid=551749

Reply With QuoteReply With Quote