Fill in cells with an array

dgh

Guest

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.

--
dgh

« Copy from form to worksheet | For each this, then that and that »

Thread Tools
Show Printable Version Email this Page
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 Forum Rules

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