one way:
Counter = sheets("Sheet1").cells(5,2).value
sets counter to be the value of cell B5
Hope this helps
Rowan
Sunantoro wrote:
I'm new in VB.
To pick up a value from other Cell, what I currently know is by using
'Offset (Row,Colum)' to go to that Cell and then assigning the the Active
Cell's Value in a Counter. This way is rather awkward if many cells are
involved.
What is the easier way to do such, ie not by "Moving Around"?
Thanks,
SUNAN