formula writen as vba

Would it be possible to write this formula as vba code?

=IF(AND(C$4>=Sheet2!$C1,Sheet1!C$4<=Sheet2!$D1),Sheet2!$B1,"")

I have used this formula and copied it from C5 across and down to BC1004

which as made the spreadsheet quite large. If it was writen as vba code

would this reduce the size of the spreadsheet, if so, would anyone know how

to do it?

Many thanks

You can try with this code:

Please Login or Register  to view this content.

The file size will be less but you need to remember to run macro each time you change data on sheet2.

To avoid to remember you can use this code on sheet2 to automatically call Macro1 each time you change data on Sheet2:

Please Login or Register  to view this content.

Regards,
Antonio

Antonio thats brilliant, thank you very much

Glad to know it helped.

Regards,
Antonio