| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy formula to the last used row
Hi,
I have a worksheet (based on a template) that has data imported into it in columns A to E. Columns F to J Row 2 have formulaes that I want to copy down to the last row that was used. I have found the last row used by: LastUsedRow = ActiveSheet.UsedRange.Row + ActiveSheet.UsedRange.Rows.Count - 1 How can I copy the formulas in col F to J into all rows down to the LastUsedRow |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel formula to copy/paste formula needed please. | Excel Discussion (Misc queries) | |||
| copy formula result (text) only - without copying formula | Excel Discussion (Misc queries) | |||
| I copy a formula and the results copy from the original cell | Excel Discussion (Misc queries) | |||
| copy formula down a column and have cell references change within formula | New Users to Excel | |||
| Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Threaded Mode
