Autofill based on a cell reference

  • Thread starter Thread starter redstang423
  • Start date Start date
R

redstang423

Is there a way to only fill equations in a specified number of rows?
have many columns of equations that analyze anywhere from 5 data point
to several thousand depending on the user's desire for the curren
report. While the wait time isn't extremely long, it is longer than
prefer. Is there any way that I can have the user type in the number o
data points it wants to look at and fill the equations down that numbe
of rows? Removing the equations that are not needed for the specifi
data analysis significantly speeds up the calculations, but I don'
want to have to have someone do drag the cells down manually anytim
the analysis is changed (especially because some people using the shee
might not understand or know how to do that)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Can trendline equations be automatically entered into cells? 1
Evaluating Equations Based on Selection !! 3
Autofill equations 4
Reference the same cell based on tab name 1
autofill down won't work!!!! 3
Function writing help 2
when setting a cell to equal a blank cell it displays 0 2
Using Add-in = Fourier Analysis 9

Back
Top