AlexMason
11-04-2009, 05:06 AM
Im trying to use offset to change the column im in
ie. i find some info using a search in A2 but then want to go 2 columns along (to C2 for instance) to put in a string "checked"
however, just testing this offset thing out give me a complie error: sub or function not defined.
all i was doing is this
CELL = "A2"
CELL = Offset(CELL, 2, 3, 1, 1)
so according to the help file this should make that A2 now C5
am i doing this right? i have a feeling that this is actually a formula that goes into a cell. if so how do i do this move in VBA?
thanks
alex
ie. i find some info using a search in A2 but then want to go 2 columns along (to C2 for instance) to put in a string "checked"
however, just testing this offset thing out give me a complie error: sub or function not defined.
all i was doing is this
CELL = "A2"
CELL = Offset(CELL, 2, 3, 1, 1)
so according to the help file this should make that A2 now C5
am i doing this right? i have a feeling that this is actually a formula that goes into a cell. if so how do i do this move in VBA?
thanks
alex