PDA

View Full Version : Clean the Cells if cell does not start with (



parscon
10-02-2014, 06:37 AM
I need a VBA code that check columns B to AX and if the cell is not started with ( clean the cell .
Really it will be very big help for me .
Thank you

SamT
10-02-2014, 09:51 AM
This should give you some ideas

For each Cel in Range("B:AX")
If not Left(Cel.Text, 1) = "(" Then Cel.ClearContents
Next

Aussiebear
10-02-2014, 03:29 PM
This should give you some ideas


yes......:devil2: But it doesn't help me find the right fish