| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Want macro to select & copy cells from a different worksheet
I have a spreadsheet with "Sheet 1" and "Sheet 2"
Both have some data I want a command button on Sheet 1 with code that will copy & move some data on Sheet 1 elsewhere on Sheet 1, then on Sheet 2 copy & move some other data on Sheet 2 elsewhere on Sheet 2 then return active cell to Sheet 1 If I record a macro and run it it works perfectly If I copy that code into the Command Button code it has an error when it selects the data on Sheet 2 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Need macro to copy a list of named cells between worksheets | Excel Worksheet Functions | |||
| Macro to open workbook and copy and paste values in to orig workbo | Excel Worksheet Functions | |||
| copy formatted (red font) cells from one worksheet to another | Excel Discussion (Misc queries) | |||
| How to copy subtotalled cells to a new worksheet (in a macro), wi. | Excel Discussion (Misc queries) | |||
| select worksheet to run macro | Excel Discussion (Misc queries) | |||
Threaded Mode
