range selection address

[Guest]

If I have this code in the Macro

selectionAdd = ActiveWindow.RangeSelection.Addres

Say "selectionAdd" returns cell address "B17", if I want to copy something to "B22", how do I set the variable "selectionAdd" ?? My guess is "selectionAdd +5", but it doesn't work. If "selectionAdd" returns address "C17", copy to "C22"....etc..

If anybody know how to do this, please help me

Thank you

emm

 

[Bob Phillips]

Emma,

Try

Range(selectAdd).Offset(5,0).Value = etc.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

If I have this code in the Macro:

selectionAdd = ActiveWindow.RangeSelection.Address

Say "selectionAdd" returns cell address "B17", if I want to copy something

to "B22", how do I set the variable "selectionAdd" ?? My guess is
"selectionAdd +5", but it doesn't work. If "selectionAdd" returns address
"C17", copy to "C22"....etc...

 

[JE McGimpsey]

One way:

Assuming that the cell you want to copy from is the cell referenced by
"rCopy":

rCopy.Copy Range(SelectionAdd).Offset(5, 0)


or, if you just want to copy the values:

Range(selectionAdd).Offset(5, 0).Value = rCopy.Value