VBA: how to assign or pick a value in other Cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
one way:

Counter = sheets("Sheet1").cells(5,2).value

sets counter to be the value of cell B5

Hope this helps
Rowan
 
Back
Top