PDA

View Full Version : Solved: how to find charecters in texts?



maryam
06-11-2007, 05:42 AM
how can I check if there is a charecter in a cell's text? I mean if there is "# " charecter in the text or for example "%".
I want to say that if sheet1.cell(1,1).text has "#" charecter then delete the cell for example.

Bob Phillips
06-11-2007, 05:45 AM
If Instr(Sheet1.Cells(1,1).Text,"#") > 0 Then

maryam
06-11-2007, 07:42 AM
thank you for your fast reply.