Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello and TIA. Users input a string into a InputBox in
the #,# format. For example: SheetsToPrint = "1,3,8,14" This indicates which sheets (index #) they want to print. The macro is printing but I'm having issues determing the total elements in my array, and thus all sheets selected won't print: SheetsToPrintSplit = Split(SheetsToPrint, ",") For iCounter = 0 To UBound(SheetsToPrintSplit) Sheets(CInt(SheetsToPrintSplit(iCounter))).PrintOu t iCounter = iCounter + 1 Next |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Maximum number of elements in array | Excel Discussion (Misc queries) | |||
Use formulas for array elements | Excel Discussion (Misc queries) | |||
Reference Elements w/in an Array | Excel Discussion (Misc queries) | |||
Non-unique elements in an array | Excel Discussion (Misc queries) | |||
conditionally delete some elements from an array | Excel Programming |