Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I am very new to writing macros and very green.
I have the following macro to copy and paste a column of cells. Sub copypaste() ' ' copypaste Macro ' Macro recorded 6/22/2005 by ' ' Keyboard Shortcut: Ctrl+q ' Range("AD3:BF3").Select Selection.Copy Range("AD19:BF19").Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Sub In the line [Range("AD19:BF19").Select] is there any way I can get it paste it in the Active Cell of choice. Thanks, Cesar. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Saving Excel using Macro | Excel Discussion (Misc queries) | |||
How do I find a Macro in Excel when I don't know its name? | Excel Discussion (Misc queries) | |||
How can I edit cell contents with a macro in Excel? | Excel Discussion (Misc queries) | |||
Problem Editing Macro in Shared Excel File | Excel Discussion (Misc queries) | |||
Open Access Database under and Excel window using a Macro | Excel Worksheet Functions |