View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
MArcus MArcus is offline
external usenet poster
 
Posts: 22
Default Starting with command

Dear all

Is it possible to write an if statement which is
a "starting with command".

For example if cell (r,1) begins "SAM" then
range(A1:d1").select
with selction
Font.bold
end slection

I would want it to pick up a range of data for example

SAM 1
SAM 2
But Not
FAM 1

MAny thanks