Thread: Adding ws information to cell in new wb & saving with ws name
View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
Jodie Jodie is offline
external usenet poster
  
Posts: 72
Default Adding ws information to cell in new wb & saving with ws name
That works! Thank you Joel, for all of your help. I also figured out how to
get the sheet name in cell A1.
--
Thanks again, Jodie


"joel" wrote:


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