I'm sure you'll have questions, 'cause I anticipated cells with formulas and didn't include any macro to deal with them.
I don't think I did a very good job of asking my second question a couple of posts back.
I know cell C8 on the job sheets contains a formula to calculate a percentage and was trying to ask
if any of the other cells on the job sheet that need their value transferred to the summary sheet have formulas as well.
Concern here is that cells with formulas will not fire the Worksheet_Change event, which is what's being used, and will need to be dealt with in another manner.
Currently looking into this.
|