View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Newbie Newbie is offline
external usenet poster
 
Posts: 40
Default 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