Tom hopefuly last questions on this f41 and f44 are relative. How do i figure
for that? 2nd will this work to replace this line in my code?
Range("F41:F" & lRow).FormulaR1C1 = "=RC[-3]*RC[-1]/360"

Tom Ogilvy wrote:
In G1 as an example:
=if(day(d1)=1,F41*30,ROUND(F44*(30-(DAY(D44-1))),2)

I don't know if your 41 and 44 are meant to be absolute or relative, but I
am sure you can work that out.

OK what i have is a dates in column D. in column G i have formuals
If the date in column D is = first day of the month then use =F41*30
if date in column D is greater then first day of month then use =ROUND(F44*
(30-(DAY(D44-1))),2)

Help i need to add code that will do is to a macro that im running.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200611/1