Thread: Fill Down based on count in another sheet
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
LostInNY LostInNY is offline
external usenet poster
  
Posts: 20
Default Fill Down based on count in another sheet
I am using the following in Excel to copy a formula:

ThisWorkbook.Worksheets("Results 4").Range("3:2000").FillDown

I need to only copy the formula for a certain number of rows up to 2000.
The number of rows I need is based on the number of rows I have in worksheet
"Results Data" in column A. So, if "Results Data" has data in column A2:A16,
I will need to copy down the formula for all columns in worksheet "Results 4"
to column 17.
Reply With QuoteReply With Quote