Prev: Array computation in vba
Next: How to Run a Macro From WB1 in WB2 Against WB2
From: Jodie on 14 Apr 2010 14:12
Sorry again... I meant to say Sorry for the confunsion guys. I did have just
one leading dot in front of Range and it was not bringing over the cell
information. Would either of you know why?
--
Thank you, Jodie


"Jodie" wrote:

> Sorry for the confunsion guys. I did have just one leading zero and it was
> not bringing over the cell information. Would either of you know why?
> --
> Thank you, Jodie
>
>
> "joel" wrote:
>
> >
> > Rick had two dots in front of RANGE. There should only be one dot.
> >
> >
> >
>
> > VBA Code:
> > --------------------
> >
> >
>
> > .Range("C79") = sht.Range("A1")
> > .Range("C80") = sht.Range("A2")
> > .Range("C81") = sht.Range("A3")
> > .Range("C88") = sht.Range("A4")
> > .Range("C89") = sht.Range("A5")
> > .Range("C91") = sht.Range("A6")
> > .Range("C95") = sht.Range("A7")
>
> > --------------------
> >
> >
> >
> >
> > The code I posted had the single dot but the dot for some reason didn't
> > display in the posting.
> >
> >
> > --
> > joel
> > ------------------------------------------------------------------------
> > joel's Profile: http://www.thecodecage.com/forumz/member.php?u=229
> > View this thread: http://www.thecodecage.com/forumz/showthread.php?t=195354
> >
> > http://www.thecodecage.com/forumz
> >
> > .
> >
From: Jodie on 14 Apr 2010 14:41
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/showthread.php?t=195354
>
> http://www.thecodecage.com/forumz
>
> .
>
First  |  Prev  | 
Pages: 1 2 3
Prev: Array computation in vba
Next: How to Run a Macro From WB1 in WB2 Against WB2