Assigning a variable a value from a Cell in VBA
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 |
Assigning a variable a value from a Cell in VBA
Dim pack as variant
pack = worksheets("package").range("B4").value or pack = worksheets("package").cells(4,2).value wrote: 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 |
Assigning a variable a value from a Cell in VBA
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 |
Assigning a variable a value from a Cell in VBA
I think you're going to have to post the code you used--include the DIM
statements, too. " wrote: 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 |
All times are GMT +1. The time now is 04:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com