View Full Version : [SOLVED:] Remove numbers of a 1st column founded in a 2nd one
RIC63
04-13-2017, 09:01 AM
I neeed to remove Every number present in column A from the column B, someone can show me a short code to acomplish this 'apparently for me' simple problem ?
see attached sample
Thank you in advance
mdmackillop
04-13-2017, 11:57 AM
Sub Test()
For Each cel In Columns(1).SpecialCells(xlCellTypeConstants)
Set c = Columns(2).Find(cel, lookat:=xlWhole)
If Not c Is Nothing Then c.ClearContents
Next
End Sub
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.