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