Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ignore Missing Worksheets
Hello - I've created a workbook that functions as a purchase order. It allows
a user to select anywhere from 1 to 12 styles for their purchase order - the macro creates that number of worksheets based on what the user selects. The worksheets created have no formulas in them. I have a "master" sheet that does contain the formulas but to put formulas in each of the sheets as they're created would take too long to calculate. Is there a way to create a macro that basically says "If Style 1 exists, paste the formulas from the Master worksheet. If Style 2 exists, paste the formulas from the Master worksheet. - etc... I tried creating a macro that pastes the formulas for the maximum number of styles (12), but I get errors when the worksheet doesn't exist (of course). Thank you for whatever help you can give me. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Ignore Missing Worksheets
Hiya,
Use Error handling to skip over where your sheets don't exist. On Error Resume Next switches the error handling off On Error Goto 0 switches it back on ---------------------------------------------------- Sub HandleSheets() On Error Resume Next Sheets("NotThere").Select On Error GoTo 0 End Sub ------------------------------------------------------ http://www.excel-ant.co.uk |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find missing numbers in list, ignore duplicates | Excel Discussion (Misc queries) | |||
Compare two worksheets for missing information | Excel Worksheet Functions | |||
ignore missing values while ploting graph | Excel Discussion (Misc queries) | |||
On Error? Creates 1 missing worksheet then never detects any other missing worksheets | Excel Programming | |||
how can i get the slope function to ignore missing data? | Excel Discussion (Misc queries) |