VBA to remove formulas from specific number columns (number changes each week)

I am automating the updating of a spreadsheet. Part of this process requires the removing of formulas (copy then paste special values) from specific number of columns. Number of columns which will need to have formulas removed increases by 1 each week from column AD. The number of columns from column AD is stored in cell A1. Does anyone know of VBA code that will look at cell A1 and remove formulas for that number of columns from column AD onwards?

How about:

Please Login or Register  to view this content.

thanks,

works perfectly