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
Clean the Cells if cell does not start with (
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
This should give you some ideas
For each Cel in Range("B:AX") If not Left(Cel.Text, 1) = "(" Then Cel.ClearContents Next
I expect the student to do their homework and find all the errrors I leeve in.
Please take the time to read the Forum FAQ
yes......Originally Posted by SamT
But it doesn't help me find the right fish
Remember To Do the Following....
Use [Code].... [/Code] tags when posting code to the thread.
Mark your thread as Solved if satisfied by using the Thread Tools options.
If posting the same issue to another forum please show the link
Posting Permissions
Reply With Quote
