Copying data to the current cell pointer

[seymour]

I'm al old 1-2-3 user that's having a hard time figuring out how to use a macro to copy numeric values from a range of cells to the current cellpointer location. Excel XP program help is useless!

Can someone please help?

 

[acw]

Hi

Try using the macro recorder to do your action, then review the code produced. This will give you some idea of the syntax required.


Tony

 

[seymour]

I alraedy did that. What I need is the specific syntax that tells Excel to copy the data to the current cell. Any clue?

 

[acw]

Hi

Do you have a constant range that you are copying from?

Tony

 

[acw]

Hi

Something like

Range("a1:a5").Copy Destination:=Range(ActiveCell.Address)


Tony

 

[seymour]

Yes, I want to copy a constant two-cell range to the cellpointer location.

 

[acw]

OK

Range("a1:a2").Copy Destination:=Range(ActiveCell.Address)


Tony

 

[seymour]

I did this...
Range("J1:K1").Select
Selection.Copy
Range (ActiveCell.Address)
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

I got this...

Compile error: Invalid use of property

 

[acw]

If you want to copy the range J1:K1 and paste them where the current cursor resides (assuming that it is not in J1-K1 then use

Range("j1:k1").Copy Destination:=Range(ActiveCell.Address)

Are the numbers in J1-K1 the results of a formula? If so, then you will have to paste the values to the currently selected cell.

Range("j1:k1").Copy
ActiveCell.PasteSpecial xlPasteValues


Tony

 

[seymour]

I pasted your exact syntax into macro. Works great!

Thank you VERY much!!!