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

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
 
R

Rowan

one way:

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

sets counter to be the value of cell B5

Hope this helps
Rowan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trying to run excel vba code when cell value changes from empty to entered value. 1
how to assign cell value which the users has filtered by? 2
referring to formula in a non active cell from active cell 1
Changing a cell value from another cell. 2
VBA to find difference in cell locations 2
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Excel [VBA] Check from a cell into another sheet and bring back result in MsgBox 0
Using a cell's "color" to place a value in a cell 1

Top