Thread
:
Macro offset using the value in a cell
View Single Post
#
1
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Macro offset using the value in a cell
You didn't post your macro so far
Sub copydestbasedoncell()
Range("c13").Copy Range("c13").Offset(Range("a1"))
End Sub
--
Don Guillett
Microsoft MVP Excel
SalesAid Software
"StephenT" wrote in message
...
Hello,
I am looking to Copy a cell then paste n rows lower. I would like this
number n to be a value in a cell. i.e. If cell A1 = 2, then copy B1 two
rows
lower (i.e. to B3). If cell A1=4, then copy B1 four rows lower (i.e. to
B5).
I know offset ( , ) should be used for this, but as a novice I don't seem
to
be able to put the cell reference in i.e. offset (A1,0)
Any help would be appreciated!
thanks
Stephen, London
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett