Hello - I have a data entry spreadsheet (Excel 2010) where several users collaborate to enter safety awards data for their corporate divisions. Despite voluminous instructions to the contrary, somebody always wants to copy & paste.
In this particular spreadsheet, half the columns are hidden, because they have formulas that calculate values that are reported in charts & pivot tables. So the copying & pasting stomps on these formulas.
This causes problems with charting , and before each quarter, somebody has to go in and clean up the spreadsheet to make sure everything gets reported.
Is there a VBA routine that can run to detect blanks and #Error values in cells, where the cells above and below contain formulas?