Hi everyone,
I'm a novice user in Excel Macros... still a lot more to be learn.
I need to write a code to clear cell contents under from column H if the
cell contains "("
I used:
Range = H:H
For each cell in range
If substring of cell.value=")" then
cells.ClearContents
next
In advance, thank you for your help.
Bookmarks