Resolving '1004' Application - defined error: Applying the formula to whole column

[kundterra]

I am running a macro which applies the formula G2=IF((F2="8/31/2013"+0),D2,""). Here, Column G is populated based on column F and G. Now I am running a macro to apply this to the whole G column. Here is the relevant code snippet:

Please Login or Register  to view this content.

I am getting the 1004 error in the line starting with ActiveSheet.Range. I cannot figure out why. Any help please?

[buran]

Hi try this

Please Login or Register  to view this content.

or this

Please Login or Register  to view this content.

[kundterra]

Buran, Thanks a lot. Worked like a charm. Only problem is that the column is not being populated (uses "" option instead of D2 value) even if the date matches, I suppose this is a formatting issue. Will work around it. Will buy you a beer on going home, but the link is not working for me (maybe work blocks it).

[buran]

Glad that it worked. Let me know if you have further issue with the match :-)