Hi
In this macro I have
rngA (Column A excluding Title)
rngC (Column C excluding Title)
rngOtherColumns (All columns to the right of C)
What should happen when run
Delete all values in rngC that = "Used", keep all other values
Loop through rngA
Where an exact match is found in rngOtherColumns on the same write "Used" rngC on the same row as the value searched for.
2 error scenarios
If rngC contains no values, the macro correctly writes "Used" to the correct cell - BUT, it deletes "used" Title
If rngC contains values anywhere in the column it writes "Used" to the cell below where it should be written - it does not delete the "used" title
Clearly some offset is occurring if data exists in Column C, I assume the same offset is protecting the title.
Any help would be appreciated. ColinK
Bookmarks