View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
kc-mass kc-mass is offline
external usenet poster
 
Posts: 12
Default How can I get the row number Based on cell value

I am good with access new with Excel

What I want to do, in VBA, is search Column B and get the row number
for the first occurence of a value. Let's say I am searching for a value of
"Fish" and "Fish" is in B1207. I would just like the Function to give back
the row number 1207.

Something Like:

Function FindRow ( Column, TextToFind)

Code
Code
Findrow = X
End Function

A. Is it possible.

B. Could you give me an idea of what I am looking for and where I
should look.

Thx

Kevin C