Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range doesn't fill
I have the following line in my code:
Worksheets("Sheet5").Range(Cells(2, 1), Cells(fnshcnt + 1, 16)) = reslist where fnshcnt=46 and reslist is an (46,16) array, both are correct in a watch window when the code is paused immediately before this line. The code works in a workbook from yesterday, filling the correct cells, A2:P47. I started a new workbook today, attempting to strip out some bloat built up over the years. No protection is enabled on any sheet. File size is reduced almost 50% ~600K to ~300K. On the new workbook using the same data as the original, fnshcnt and reslist show the same values immediately before the line in question. The rest of the code functions properly. Only cells A2:K2 get filled. Any clues as to what is happening? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Range doesn't fill
Ignore previous. Somehow a date literal got into the array, wouldn't
transfer. JWolf wrote: I have the following line in my code: Worksheets("Sheet5").Range(Cells(2, 1), Cells(fnshcnt + 1, 16)) = reslist where fnshcnt=46 and reslist is an (46,16) array, both are correct in a watch window when the code is paused immediately before this line. The code works in a workbook from yesterday, filling the correct cells, A2:P47. I started a new workbook today, attempting to strip out some bloat built up over the years. No protection is enabled on any sheet. File size is reduced almost 50% ~600K to ~300K. On the new workbook using the same data as the original, fnshcnt and reslist show the same values immediately before the line in question. The rest of the code functions properly. Only cells A2:K2 get filled. Any clues as to what is happening? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SumIf - when I fill down the Range, Criteria & sum range changes | Excel Worksheet Functions | |||
Fill Range With A Value | Excel Worksheet Functions | |||
How to fill a range with data from another range? | Excel Discussion (Misc queries) | |||
Fill a Range with VB SafeArray | Excel Programming | |||
Fill down range | Excel Programming |