Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 136
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 136
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
SumIf - when I fill down the Range, Criteria & sum range changes markholt Excel Worksheet Functions 3 October 28th 08 12:37 AM
Fill Range With A Value Derek Hart Excel Worksheet Functions 1 December 24th 07 12:55 AM
How to fill a range with data from another range? Themis Excel Discussion (Misc queries) 4 September 15th 05 07:29 PM
Fill a Range with VB SafeArray Rob[_17_] Excel Programming 3 April 9th 04 09:41 AM
Fill down range Nancy[_4_] Excel Programming 2 December 17th 03 04:39 PM


All times are GMT +1. The time now is 10:40 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"