Autofill based on a cell reference
 

Is there a way to only fill equations in a specified number of rows? I
have many columns of equations that analyze anywhere from 5 data points
to several thousand depending on the user's desire for the current
report. While the wait time isn't extremely long, it is longer than I
prefer. Is there any way that I can have the user type in the number of
data points it wants to look at and fill the equations down that number
of rows? Removing the equations that are not needed for the specific
data analysis significantly speeds up the calculations, but I don't
want to have to have someone do drag the cells down manually anytime
the analysis is changed (especially because some people using the sheet
might not understand or know how to do that).


--
redstang423
------------------------------------------------------------------------
redstang423's Profile: http://www.excelforum.com/member.php...o&userid=37333
View this thread: http://www.excelforum.com/showthread...hreadid=570722

Autofill based on a cell reference
 

Sub Auto_Fill()
Dim lrow As Long
With ActiveSheet
lrow = InputBox("enter a number")
Range("C1:C" & lrow).FillDown
End With
End Sub

Assumes a formula in C1


Gord Dibben MS Excel MVP

On Fri, 11 Aug 2006 08:30:32 -0400, redstang423
wrote:


Is there a way to only fill equations in a specified number of rows? I
have many columns of equations that analyze anywhere from 5 data points
to several thousand depending on the user's desire for the current
report. While the wait time isn't extremely long, it is longer than I
prefer. Is there any way that I can have the user type in the number of
data points it wants to look at and fill the equations down that number
of rows? Removing the equations that are not needed for the specific
data analysis significantly speeds up the calculations, but I don't
want to have to have someone do drag the cells down manually anytime
the analysis is changed (especially because some people using the sheet
might not understand or know how to do that).