Hello Guessed/
Andrew Lockton
You've asked if ==> Is it possible that the last cell in the table contains the search term? I can reproduce that error if I set the table up that way.
Yes most of our tables have a $ on top and $ on the last row, so it's possible that it created the error.
But see my reply to Greg Maxey, that macro worked!!!!!! I'm still in shock, wow. And so fast
That will save me tons of time. Cause, 5 pages of tables are on an average. At times I have 20 pages of tables, where % and $ is on tons of rows and columns, I had time to go to washroom or get a coffee
Anyway, I'm grateful even to you to have tried. It's a lesson to all of us
Have a great evening everyone