Dynamic formula using >=<

[forrestgump1980]

Hi all,

I am trying to make a dynamic formula by using the >=< signs and referencing them from the spreadsheet i.e. I do not want to use them directly in the VBA code. I started writing this (code below just to show my attempt) but then I realised I did not know how to set up the forumla by referencing the >=< signs and the numbers in the spreadsheet (Spreadsheet attached).

Please Login or Register  to view this content.

P.s. I have recently attended introduction and intermediate courses so I am relatively new to VBA. Any help would be much appreciated.

Regards,

Forrestgump