Is there a easier way of refreshing formula data of a macro in a
column. I can do this manually, but does take a great length of time in
doing so. Is there a VB code of doing this macro, which would make life
easier.

many thanks