include = in formula

Good afternoon!
I have a macro that pulls all the formulas in a workbook and pastes them into a separate worksheet. I'm running a macro on that worksheet to get a materials pick list.
The macro to pull all the formulas is something I found on the web and it works great except for the fact that it doesn't include the = at the beginning of the formula. I'm a long way from a VBA expert (A Really long way!) and I am not sure just how to modify this macro to show the = in the formulas. I'm hoping someone can tell me what I have to change to do this. I'm guessing it is in the statement

Please Login or Register  to view this content.

in the macro. I would appreciate any input or suggestions.
Thanks much
Bill
Macro attached

Please Login or Register  to view this content.

Thank you Tsjallie! I do want the formula to execute so this is perfect!
Thanks
Bill