Prev: Array computation in vba
Next: How to Run a Macro From WB1 in WB2 Against WB2
From: Jodie on 14 Apr 2010 11:41
Joel, I switched them as you indicated and it is still not populating the
cells in the UDF files with the information from the Trollie workbook. I
don't get an error, it just doesn't do anything.

Rick, I tried with the second leading dot and I get an error.
--
Thank you, Jodie


"joel" wrote:

>
> I moved the data in the wrong direction
>
> from
> sht.Range("A1") = .Range("C79")
> sht.Range("A2") = .Range("C80")
> sht.Range("A3") = .Range("C81")
> sht.Range("A4") = .Range("C88")
> sht.Range("A5") = .Range("C89")
> sht.Range("A6") = .Range("C91")
> sht.Range("A7") = .Range("C95")
>
> to
> .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")
>
>
> --
> 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: Rick Rothstein on 14 Apr 2010 11:48
> Rick, I tried with the second leading dot and I get an error.

**Second** leading dot??? In the "To" section that Joel posted, he omitted
the leading dot altogether... all I was doing was noting that. If you put
the leading dot in on your own, then you were not suppose to put another one
in as a result of my posting... as I said, I was just correcting an omission
in Joel's message that I thought might possibly have given you a problem.

--
Rick (MVP - Excel)



"Jodie" <Jodie(a)discussions.microsoft.com> wrote in message
news:6035EE58-AAA3-42FB-BF4D-DFA4E59B41D1(a)microsoft.com...
> Joel, I switched them as you indicated and it is still not populating the
> cells in the UDF files with the information from the Trollie workbook. I
> don't get an error, it just doesn't do anything.
>
> Rick, I tried with the second leading dot and I get an error.
> --
> Thank you, Jodie
>
>
> "joel" wrote:
>
>>
>> I moved the data in the wrong direction
>>
>> from
>> sht.Range("A1") = .Range("C79")
>> sht.Range("A2") = .Range("C80")
>> sht.Range("A3") = .Range("C81")
>> sht.Range("A4") = .Range("C88")
>> sht.Range("A5") = .Range("C89")
>> sht.Range("A6") = .Range("C91")
>> sht.Range("A7") = .Range("C95")
>>
>> to
>> .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")
>>
>>
>> --
>> 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: joel on 14 Apr 2010 11:55

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 13:33
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: joel on 14 Apr 2010 13:49

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  |  Next  |  Last
Pages: 1 2 3
Prev: Array computation in vba
Next: How to Run a Macro From WB1 in WB2 Against WB2