View Single Post
 
Old 06-01-2015, 11:59 AM
NoSparks NoSparks is offline Windows 7 64bit Office 2010 32bit
Excel Hobbyist
 
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 842
NoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of lightNoSparks is a glorious beacon of light
Default

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.
Reply With Quote