I have a number of excel sheets set up as forms which have been issued to staff to fill in and return, which I then upload to Access.
Due to an oversight, there are a large number (300ish!) of lines with redundant formulas resulting in the #REF error.
I want to build a macro that will search ther sheet, identify the rows, select them and delete them.
Unfortunately I don't have the first idea of where to start!
Help?
Kindest
Frank
Due to an oversight, there are a large number (300ish!) of lines with redundant formulas resulting in the #REF error.
I want to build a macro that will search ther sheet, identify the rows, select them and delete them.
Unfortunately I don't have the first idea of where to start!
Help?
Kindest
Frank