Assigning a variable a value from a Cell in VBA

[jefflck]

I'm having a little difficulty assigning a variable the value of a cell
in a different worksheet. I hope that makes sense. Here is what I'm
trying to accomplish.

pack = "=Package!R[4]C[2]"

I want the value that is in the cell referenced to be stored in the
variable pack. Whenever I run this it stores "=Package!R[4]C[2]" as
what is in pack. I'm new to writing Macro's in VBA so if this seems
trivial please forgive me.

Thanks,
Jeff

 

[Dave Peterson]

Dim pack as variant

pack = worksheets("package").range("B4").value
or
pack = worksheets("package").cells(4,2).value

I'm having a little difficulty assigning a variable the value of a cell
in a different worksheet. I hope that makes sense. Here is what I'm
trying to accomplish.

pack = "=Package!R[4]C[2]"

I want the value that is in the cell referenced to be stored in the
variable pack. Whenever I run this it stores "=Package!R[4]C[2]" as
what is in pack. I'm new to writing Macro's in VBA so if this seems
trivial please forgive me.

Thanks,
Jeff

 

[jefflck]

Thanks for the reply Dave,
I tried the command you gave me and I get the following error when
running.

Run-time error '438':

Object doesn't support this property or method.

I think that Package is the object correct. Just as an fyi I'm using
Excel 2000 and VBA 6.0.

Any other ideas?

Thanks,
Jeff

 

[Dave Peterson]

I think you're going to have to post the code you used--include the DIM
statements, too.