PC Review

Thread Tools Rate Thread

Fill in cells with an array

Posts: n/a
      15th May 2009
I have a row of numbers that I want to fill into a row only if a variable
cell increments by 1. For instance:

Array = 200 10 5 6 8

Variables 0 1 1 2 2 3

Row 1 200 10 5 6 8
Row 2 200 10 5 6 8
Row 3 200 10 5 6 8

I want to be able to change the variables so the array can stat at different
cells within the row.

Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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

Similar Threads
Thread Thread Starter Forum Replies Last Post
Fill/Copy Up to fill blank cells. J.W. Aldridge Microsoft Excel Programming 3 26th Sep 2008 05:01 PM
Redimming an array dynamically assigned from range (how to redim first dimension of a 2-D array? /or/ reverse the original array order) Keith R Microsoft Excel Programming 3 13th Nov 2007 05:08 PM
meaning of : IF(Switch; Average(array A, array B); array A) =?Utf-8?B?RFhBVA==?= Microsoft Excel Worksheet Functions 1 24th Oct 2006 06:11 PM
create a fill in template to tab to fill in cells =?Utf-8?B?RXhjZWwtZXJhdG9y?= Microsoft Excel Misc 2 6th Jul 2005 09:57 PM
Function to automatically fill in an array of cells =?Utf-8?B?TWFhcnRlbg==?= Microsoft Excel Programming 5 1st May 2005 10:13 PM




All times are GMT +1. The time now is 06:38 AM.