Excel saving excel formula

[pulsecoding]

Dear all,
I have vba code to save formula in cells. this formula is link to another cell in another file on network.
I takes some time to save the formula in cell.
Is there any way to fasten this process?

thanks

 

[Sifou]

Hi,

I guess this depends on how you wrote your macro; you may want to use the debugger to see which part(s) of your VBA code run(s) faster.

another thing is try to see if you have a way to write code achieving the same as your current VBA block.

not sure what is your level in VBA (mine is not advanced, I practice for fun only) but if you are struggling let me know how I can contact you (email) and i will do my best to help.

Sifou