GMayor,
It works. Omigosh! I can understand what it is doing, but I never could have written it.
It steps through the entire table looking for "Deleted:"
But it only loads sName when there is a match.
I did not know VBA could do a FOR - I have been using FOR in PowerShell, so I recognize it. It is just a loop.
This saves a lot of time. And I will be able to use this in other ways.
I will experiment because I want to test for the condition when there are only spaces in that cell too. They might put spaces in the cell too.
Many Thanks.
|