snoopfan
05-10-2011, 02:55 AM
Dear all,
I am concerned how to read the address of the variable that has been assigned a cell, moreover let me show you by example...
Public dh_PS1 As Double
dh_PS1 = Worksheets(1).Range("PrCond_In").Cells(3, 4)
so after using the variable later on, I would like to automatically have access to the cell via dh_PS1, I tried dh_PS1.Address(); but that did not seem to function
Anyone could help?
I am concerned how to read the address of the variable that has been assigned a cell, moreover let me show you by example...
Public dh_PS1 As Double
dh_PS1 = Worksheets(1).Range("PrCond_In").Cells(3, 4)
so after using the variable later on, I would like to automatically have access to the cell via dh_PS1, I tried dh_PS1.Address(); but that did not seem to function
Anyone could help?