| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to modify a copy macro
I am running the following macro to add an additional sheet.
Sheets("ICS 214").Select Sheets("ICS 214").Copy Befo=Sheets(2) ' End Sub The problem I have is it copies over some information from unlocked cells that I would like to have blank on the new sheet. What can i add to the macro to have it copy the original sheet and automatically clear a group of cells such as d29-d46? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy from WORD to EXCEL using a macro..... | Excel Discussion (Misc queries) | |||
| Want macro to select & copy cells from a different worksheet | Excel Discussion (Misc queries) | |||
| Recorded Macro to Copy Format | Excel Worksheet Functions | |||
| Closing File Error | Excel Discussion (Misc queries) | |||
| Activate a macro to insert a row and copy the formuals from the rows above to the blank row | Excel Discussion (Misc queries) | |||
Threaded Mode
