In excel, I have a page that has a table with some billing values entered into it. I am trying to create a macro that will copy certain values in a specific row in this table (not the entire row), then switch to another page, create a new row at the end of the table that is currently on that page, and paste these values into this new row.
I used the "record macro" option in the developer tab to try to simulate what I want to do, as I am completely clueless in using VBA or coding for excel. When I tried the macro after I completed the recording, here is the message I got:
"Run-time error '1004':
PasteSpecial method of Range class failed"
I clicked debug, and here is the code that my macro recording had created: The " Selection.PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _xlNone, SkipBlanks:=False, Transpose:=False" line was highlighted in yellow.
I have no clue what any of this code means (which is why i prefer to just record a macro instead of actually typing up the code).
I'm using Excel 2010. Please any help is appreciated! Thanks!
-James
Bookmarks