| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Fixed and Relative Macro References
I am trying to learn about what macros can and can't do.
Essentially, I want to copy data from a fixed location and paste it in a relative location. It seems like this should be possible, but no matter what I try, it fails. Most recently, I have tried to use two separate macros. Macro 1 selects and copies the fixed data. Selection.Copy Macro 2 should paste two spaces to the right of where the cursor is. ActiveCell.Offset(0, 2).Range("A1").Select ActiveSheet.Paste I have recorded these macros, but when I try to run Macro 2, I get an error (either 1004 or 438 if that is relevant) Is what I am trying to do possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro using relative references | Excel Worksheet Functions | |||
| Relative references and macro programming | Excel Programming | |||
| macro vba relative references | Excel Worksheet Functions | |||
| relative cell references in vba macro | Excel Programming | |||
| Making a macro references relative | Excel Programming | |||
Threaded Mode
