View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ben E Ben E is offline
external usenet poster
 
Posts: 3
Default Finding the first few characters in a cell

Can anybody help?

What I would like to do is run a macro that will hide
certain rows within a workbook, the position of the rows
is variable, however all of the row I would like to keep
all have the same first 5 Character, (SubTL) I can make it
run through the data and remove lines. The problem is I
can't make it identify which rows contain (SubTL) as the
first 5 Character. Any Ideas?

Thank for you help.

Ben