If...then...else Statement

[Smurfit-Stone]

Hello Board,
I recorded a macro and now I need to tweek it to include a If statement.
I have a summary sheet and various other sheets that the information on the summary sheet pulls from. I want to use a If, Then, Else statement to look at the value in A2, (month). If its August then select cells B4:G4 and insert a formula {(=Smith!AugustSales)} else if its September insert formula {(Smith!SeptemberSales)}, else if its October insert ({Smith!OctoberSales)} and so on till next July. Can anyone help, I'm running out of time....Thanks!

 

[Jonmo1]

The only other thing I can think of that may be causeing your problem is if the range A3 does NOT contain simple TEXT January/February etc.. But if A3 is a DATE Formatted to show just the month, this would cause a problem.

To adjust for that try

Range("B6:G6").FormulaArray = "='Forecast August 2007.xls'!" & Format(Range("A3").Value,"mmmm")