Hi,
THe "Location" grid starts in column "F" thru "U". The way I had the code set was to go
"F to "U" and if you added another column say "V" then the code will not work properly because I
pre set the range to "U". In this copy I changed the code so that if you added more columns the code will see it
and not fail. In column "F" you have the "Alpha" characters. If you add more to this the code should still work.
It was the matter of extending the "Columns".
I did not test for this, but you can and let me know.




Reply With Quote
Bookmarks