Thread: Adding ws information to cell in new wb & saving with ws name
View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
joel[_899_] joel[_899_] is offline
external usenet poster
  
Posts: 1
Default Adding ws information to cell in new wb & saving with ws name

Oops. The workbooks were backwards


Range("A1") = sht.Range("C79")
Range("A2") = sht.Range("C80")
Range("A3") = sht.Range("C81")
Range("A4") = sht.Range("C88")
Range("A5") = sht.Range("C89")
Range("A6") = sht.Range("C91")
Range("A7") = sht.Range("C95")

The dot in front of range is the UDF workbook and sht is the workbook
where the macro is located.


--
joel
------------------------------------------------------------------------
joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=195354

http://www.thecodecage.com/forumz

Reply With QuoteReply With Quote