Change formulas to variable row in range

gmunro

Guest

Posts: n/a

5th Jun 2007

Hello,

I have a range that contains formula's like the one below
=SUMPRODUCT((LEFT($A$4:$A41,1)="1")*H$4:H41)
pulling results from a list

The problem I have is that after the macro runs, I want to change the
bottom row in the range from 41 to the new bottom which is variable.

Is there an easy way to update my formulas with the new bottom number?

Your help is appreciated

Glen

« Categories | Data Entry Restriction »

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
how to copy formulas from one range to another range in other work	=?Utf-8?B?TWlyaQ==?=	Microsoft Excel Programming	1	6th Jun 2007 03:52 PM
change range of relative formulas to absolute	=?Utf-8?B?TWFyaw==?=	Microsoft Excel Misc	1	10th Sep 2004 03:17 AM
setting a range variable equal to the value of a string variable	Pilgrim	Microsoft Excel Programming	2	1st Jul 2004 11:32 PM
Excel VBA-Change chart range to variable	waveracerr	Microsoft Excel Programming	1	11th Feb 2004 04:39 PM
Problem trying to us a range variable as an array variable	TBA	Microsoft Excel Programming	4	27th Sep 2003 02:56 PM