| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Copy down formula macro
Hi
I have this macro that doesn't work and I am not sure why: LastRow = Sheets("Sheet1").Range("D" & Rows.Count).End(xlUp).Row Sheets("Sheet1").Range("P2:q2").Copy _ Destination:=Sheets("Sheet1").Range("P3:Q" & LastRow) Calculate Macro should check how many rows are in column D and then copy the formula form P2:Q2 down to the last row. -- Greatly appreciated Eva |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Use Macro to Copy Formula from one Workbook to another | Excel Discussion (Misc queries) | |||
| Do I use a formula or a macro to copy cells? | Excel Discussion (Misc queries) | |||
| Formula/ Macro that will copy and paste | Excel Worksheet Functions | |||
| Copy a formula down in a macro | Excel Discussion (Misc queries) | |||
| Formula/Macro to copy into a cell | Excel Worksheet Functions | |||
Threaded Mode
