Select specific worksheets & copy - code problem
Thanks Paul - that solved part of my problem...
i.e. worksheets that have "planned" entered into A1 were copied....
but they copied into separate workbooks??
How do I get them to all copy into one new workbook?
FYI
The second part of the code "clears out" functionality that is not required
in the new workbook
e.g.
- Formulas that lookup named ranges in the original workbook
(i.e. copy / paste values into same cells to clear the formula)
- Macro buttons where the macro lives in the original workbook
(i.e. delete specific buttons)
- Named ranges that live in the original workbook & cause "link" errors
(i.e. delete named ranges that are not "local" to this worksheet)
--
Thank for your help
BeSmart
|