[Q.] How in a Macro to select range to paste in.
Posted by Carl Benker on November 16, 2000 3:53 PM
I am trying to use a macro to paste a formula in a
group of cells. I want to paste the formula in
Column A in Rows 1 through the row of the currently
select cell. How do I do this?? It seems like I
should be able to use "R1C1" references to do this
like:
Range("RC1:R1C1").Select
ActiveSheet.Paste
but it won't work. Help doesn't give much assistance
except to desribe R1C1 references.
Please help.
Carl
carl.h.benker@ucm.com