Bob,

You are so correct. I've worked with one engineer, that
did all of his "programming" in Excel with formulas. I
tried to get him to switch to VBA programming, but with
his analytical mind, he was very happy to just stick with
formulas.

By the way, if you get a chance to read this, I want to
thank you so much in helping me develop my VBA programming
with VB6 (last year or so). Over the past year part time,
I've gone a lot further...with other people's help too.
I've got the form to stay on top with an API call. I
developed a lot of neat things here that many others
really don't know about. Again, I can't thank you
enough. Now, I don't have any of my VBA code on my
computer at work anymore...just my compilied executable
VB6 programs that interface with Excel. I'm still making
improvements. It works perfect, for what I need it to do.

Thanks, Rick

-----Original Message-----
Morning,

You don't need a loop, a single statement will do it

range("F8:F300").Formula = "=IF(D8$D$4,D8-$D$4,0)"

Not sure what the second part meant, but looking at
Rick's reply, if he
interprets it correctly, it can be done with

range("F8:F300").Formula = "=IF(AND(C8=DATE
(2004,1,15),E8=""AVE
US""),IF(D8$D$4,D8-$D$4,0),"""")"


--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"japorms " wrote
in message
...
Hello guys and guru's

I need help in creating a macro. I am a newbie and
browsing the help
file but reallly I cant get it.

I need a macro that will put this formula =IF
(D8$D$4,D8-$D$4,0)
at F8 to F300

if it satisfy this condition that will look in column
E8 to E300 is
equal to "AVE US" And column C8 to C300 is equal
to "1/15/2004"

Its giving me a headache coz it has too many condition
for a beginner.
If anybody can help please....


---
Message posted from http://www.ExcelForum.com/



.