Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need your help in "for" function.
I have this macro does find all available worksheets, and copies the
used range, and paste into newly created worksheet. It works fine, but I need a couple of modifications. I will appreciate your time to read this. 1. I have multiple worksheets named, 1,2,3,4,5,6,1a,2a,3a,4a,5a,..... Now the macro reads everything, but I need the macro to read every numbered worksheets (i.e. 1,2,3,4,5,6), and stop when it hits 1a. I don't need any data from 1a,2a,3a,.....on new worksheet. 2. When new worksheet is generated, a default name is given to this new worksheet (i.e. sheetX) other than this, I need to assign a name like "report" Thank you for taking your time to read this. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
I need your help in "for" function.
"Steven" wrote in message oups.com... 1. I have multiple worksheets named, 1,2,3,4,5,6,1a,2a,3a,4a,5a,..... Now the macro reads everything, but I need the macro to read every numbered worksheets (i.e. 1,2,3,4,5,6), and stop when it hits 1a. I don't need any data from 1a,2a,3a,.....on new worksheet. When you loop through the worksheets, add an IsNumeric test to the loop For Each sh In Activeworkbool.Worksheets If Isnumeric(sh.Name) Then ... 2. When new worksheet is generated, a default name is given to this new worksheet (i.e. sheetX) other than this, I need to assign a name like "report" Worksheets.Add.Name = "report" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text "comparison" operator for "contains" used in an "IF" Function | Excel Worksheet Functions | |||
Excel 2003: Conditional Formatting using "MIN" & "MAX" function | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
function to return day in the form "Monday", "Tuesday" etc given . | Excel Worksheet Functions | |||
inserting a conditional "go to" command on a excel "if" function | Excel Worksheet Functions |