| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Copy formula down variable rows based on (lastrow) from another sh
I have a variable number of rows in Sheet1, starting on row 2 ( Row 1
contains a column header ). Lets say for example this time it is 500 rows. ( lastrow = 501 ). On Sheet 2 I have a column header in cell a1 and an existing formula in A2. How do I copy the formula down based on the lastrow value from Sheet 1. In this example, the macro would copy the formula down to A501. Thanks in advance for your help, Joe |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to hide rows in an Excel worksheet based on a variable | Excel Discussion (Misc queries) | |||
| Copy&Paste variable range based on cell value | Excel Programming | |||
| Copy rows to new sheet based on variable cell reference | Excel Programming | |||
| Copy Formula loop based on number of rows w/ data in a col B. | Excel Programming | |||
| Using the Lastrow variable in a Count/Countif formula | Excel Programming | |||
Threaded Mode
