Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 208
Default Fill Down to variable row

I tried some of the suggestions in other posts, but none seemed to work for
me.

How can I fill down formulas I've entered (via macro) in R3C23 and R3C24 to
the last row of my sheet that has data. The columns will stay constant, but
the rows will vary.

So far I have this:
Application.Goto Reference:="R3C23"
ActiveCell.FormulaR1C1 = "=IF(RC[-13]<RC[-15],""expedite"")"
Application.Goto Reference:="R3C24"
ActiveCell.FormulaR1C1 = "=IF((RC[-14]/RC[-16])*100<50,""fast"")"

Filling down those two formulas is where I'm lost.

Thanks for any help,

Sean
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default Fill Down to variable row

You can use "Do While" Loop, but you can only enter one formula

intLOOP is a local variable, serves as a row counter until row
"c+intLOOP" = blank

' Loop to copy formula to every Row in column "D"
intLOOP = 1
Do While Range("c" & intLOOP).Value < ""
Range("d" & intLOOP).Formula =
"=IF(RC[-13]<RC[-15],""expedit*e"")"
intLOOP = intLOOP + 1
Loop

Let me know if you need any additional assistance.
Roberto

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How fill series containing one variable and one fixed value in XL nomad Excel Discussion (Misc queries) 2 September 18th 09 09:25 PM
"Type mismatch" when I try to fill an Array variable with "+" [email protected] Excel Discussion (Misc queries) 1 April 17th 07 01:28 PM
why is it saying sheetcnt is "variable not defined" how to do a global variable to share over multiple functions in vba for excel? Daniel Excel Worksheet Functions 1 July 9th 05 03:05 AM
Fill a listbox with data from variable range Al Excel Programming 2 August 10th 04 07:05 AM
Passing Row variable to row Auto fill logic ExcelMonkey[_148_] Excel Programming 4 June 11th 04 10:48 PM


All times are GMT +1. The time now is 05:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"