Thanks in advance for any help...
I am trying to use VBA to cut and paste an entire worksheets information into a new workbook. The problem is, when this happens, all of my equations break, even if they're 'ok'.
For instance:
Workbook1 has two worksheets; 'budget' and 'rates'.
Workbook2 has two worksheets; 'budget' and 'Master_rates'.(enter joke here)
I have a vba macro which copies the contents of 'Master_rates', and replaces the contents of 'rates'. 'Master_rates' contains equations that reference 'budget'. How come when I cut and paste the new equations to 'rates' the 'budget' equations do not work.
ex: ='Budget Template'!C6 gives me "#REF!", which I understand, but as soon as I click in the cell it works fine.
How can I make it so the equation works? I am pushing the master_rates to hundreds of spreadsheets, so to have to go into each and update this is a pain in the ass.
::NEVERMIND PROBLEM SOLVED::
Problem was solved by adding code into the macro to write the equations in rather than copying them over.
I am trying to use VBA to cut and paste an entire worksheets information into a new workbook. The problem is, when this happens, all of my equations break, even if they're 'ok'.
For instance:
Workbook1 has two worksheets; 'budget' and 'rates'.
Workbook2 has two worksheets; 'budget' and 'Master_rates'.(enter joke here)
I have a vba macro which copies the contents of 'Master_rates', and replaces the contents of 'rates'. 'Master_rates' contains equations that reference 'budget'. How come when I cut and paste the new equations to 'rates' the 'budget' equations do not work.
ex: ='Budget Template'!C6 gives me "#REF!", which I understand, but as soon as I click in the cell it works fine.
How can I make it so the equation works? I am pushing the master_rates to hundreds of spreadsheets, so to have to go into each and update this is a pain in the ass.
::NEVERMIND PROBLEM SOLVED::
Problem was solved by adding code into the macro to write the equations in rather than copying them over.
Facebook
Twitter