| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
VBA: how to assign or pick a value in other Cell
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
Thanks Rowan,
It seems to be the answer. I'll try it later. SUNAN "Rowan" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I Pick a cell with highest value from a range of cells? | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| up to 7 functions? | Excel Worksheet Functions | |||
| Calculate Value of Cell From Pick List Choice | Excel Discussion (Misc queries) | |||
| VLookup resulting in a blank cell... | Excel Worksheet Functions | |||
Linear Mode
