cell references absolute/relative (I think ...)

[kasparov]

I'm sure this is a very elementary question but Im struggling to find the answer probably because I'm not familiar with the terms. (I'm fairly new to VB).

I'm writing a macro in Excel. I'm working down a column & moving the value in a cell to a cell in a different column. Once I've moved the value I want to focus to go back to where I picked up the value from.

To help illustrate this - I get to B3, find the value I expect & cut & paste to A4. Then I want to go back to B3 & continue moving down the B column.

When I find the value I do this:

Curr_Cell_Val = ActiveCell.Address

which I know works because when I print it in MsgBox it gives me $B$3 - but how can I subsequently use this to take me back to B3?

This must be simple but I just can't figure it out.

Hope this makes sense. Thanks, Chris

 

[xlbo]

Range(Activecell.address).activate

but please post VBA questions in the VBA forum in future: Forum707

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[SkipVought]

Please post VBA code question in Forum707.

Skip,

_{When a diminutive clarvoyant had disappeared from detention, headlines read...
Small Medium at Large}

 

[GlennUK]

Please post VBA questions in the forum for that ... forum707

You'd also be better telling us what you are aiming for. Like, why are you moving down column B? What's your criteria for cutting and pasting? Or, even better, post your code so that people can see what you've written.

Cheers, Glenn.

Did you hear about the literalist show-jumper? He broke his nose jumping against the clock.

 

[kasparov]

Sorry - will do. & thanks for the reply Geoff.

Chris