Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding Cell Address of All Errors
We produce building cost estimates for architectural clients. We have a
quality control macro that checks and corrects pagination, adjusts column widths, rezooms each page, and positions the cursor to cell A1 on each sheet, and checks for #VALUE# and #REF# errors. The number of errors for each sheet is written to an integer array and later displayed: ' Assign errors array aintErrors(ActiveSheet.Index) = _ Application.Evaluate("SUM(--(ISERROR(" & ActiveSheet.UsedRange.Address & ")))") Users are now requesting that the cell addresses of each error be obtained to simplify tracking them down. Can anyone help me do this? Thank you. Sprinks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Finding Cell address by value | Excel Discussion (Misc queries) | |||
Finding Cell address by value | Excel Discussion (Misc queries) | |||
Finding the Address of a Cell | Excel Worksheet Functions | |||
finding the address of a specific cell? | Excel Programming | |||
Finding cell address... | Excel Programming |