View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Arne Hegefors Arne Hegefors is offline
external usenet poster
 
Posts: 244
Default Search parts on a spreadsheet

Is there any way to search parts of a spreadsheet? As it is now I search a
spreadsheet for certain words like this:

Set rng5 = Worksheets("Beräkning").Cells.Find("Market value RC",
LookIn:=xlValues)

Is it possible to search etc. only the five first rows, the third column
etc? I have to do this variably so I cannot record a macro for this. Please
help me! Thanks!