Is there a way to chnage cell formulas to VBA module?

hello every body
I have an excel sheet with hundreds of functions in cells I was thinking if there is away to change them all to vba as modules
can that be accomplished?

Thanks Bryan Hessey

It may seem strange , you are wright

but it's an old spreadsheet with thousands of cells full of hundreds of formulas I tried to get use of them but it's very hard, so I thought there must be a tool to do this job around instead of reinventing the wheel !

Getting them in a module or more will ease the process

do you think there is a tool around for this ?

I seriously doubt you are going to find a utility that will:

1) Study a complex spreadsheet with hundreds of formulas and decipher the logic that went into the spreadsheet and then
2) Create a series of VBA Sub and/or Function procedures that will recreate that same logic.

You can get a VBA macro that will copy a spreadsheet, but it sounds to me like you want something a lot more involved than that.

but it's an old spreadsheet with thousands of cells full of hundreds of formulas I tried to get use of them but it's very hard, so I thought there must be a tool to do this job around instead of reinventing the wheel !

I don't know what your spreadsheet is supposed to do. Sometimes I will get in a project similar to a project that I did a few years previous. Even using spreadsheets I created, a lot of times I find it easier to start from scratch (aka reinvent the wheel) than try to figure out what I was thinking back then and adapt it to what I need to do now.

good luck.