Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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). |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Maintaining cell reference after sorting | Excel Discussion (Misc queries) | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
How do I set a cell value based on a formula in another cell? | Excel Discussion (Misc queries) | |||
how do I format a cell reference to move as source changes | Excel Worksheet Functions | |||
More- AutoFill with Non-Seqeuntial Cell References ? | Excel Worksheet Functions |