Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Next Function in Array
I have a macro that I am running in Excel which is (1) retrieving data from a
database, (2) making a copy of the worksheet (3), copy and pasting the values, (4) and then repeating the same process over and over again. At the beginning of the macro I am declaring an Array of 43 items and then I am using a "Next" statement to cycle through the each item. It is working just fine until it gets to the last item in the array. At that point it will not make a copy of the worksheet and even if you cancel the macro and try to do it manually it will not copy the worksheet. You can create a new blank worksheet, but you can' copy one. Any idea what would be causing this. The number or worksheets in the workbook at the time of the error is 48, which I don't believe is the problem because I'm sure I've had files with more worksheets than 48. Your help would be greatly appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
OR function in array-entered IF function | Excel Worksheet Functions | |||
AND in an array function? | Excel Worksheet Functions | |||
Is there an array function or something like it? | Excel Worksheet Functions | |||
Help with an array function | New Users to Excel | |||
UDF Array function | Excel Programming |