Copy range that includes formula and paste to another sheet

[humboldtguy]

This is a weird one. I have a table in one spreadsheet that is copied to another spreadsheet each time that other spreadsheet is opened. Their are formula's (sort of) in some of the cells to be copied. The formula's are useless in the spreadsheet that they are being copied from, but are needed in the spreadsheet they are copied to. In the table that is to be copied each formula has an apostrophe in front of the equal sign. I have code that removes the apostrophe after everything has been pasted to the new workbook, unfortunately, even with the apostrophe gone the formula's fail to calculate. I can double click on the cell with the uncalculated formula and hit enter, then it calculates properly. I don't understand why it isn't calculated automatically after the apostrophe's are removed, can anyone tell me what needs to be done so that the formula's will be recognized as formulas after having the apostrophe removed. Here is the code i am using to remove the apostrophes

Please Login or Register  to view this content.

I tried changing "s.text" to s.value but it was the same result. Any suggestions? Thanks guys

[humboldtguy]

Nevermind, I was referencing the wrong row in the formula. Thanks anyway guys

[humboldtguy]

i marked this as solved a bit prematurely. I realized that the formula only calculates if the sheet is activated before the loop in the code above. Not sure why, but it was an easy fix.