How can I get the row number Based on cell value
Use Excel.Worksheet's UsedRange.Rows.Count to iterate through all the
rows.
Also, check for empty cells like so:
If Len(.Cells(iRow, iCol).Value) Then
' check to see whether the value is what you're looking for
End If
"""Kc-Mass ΠΙΣΑΜ(Α):
"""
Thanks for all the help!
I have it now.
You folks are great!
Kevin C
"Kc-Mass" <connearney_AT_comcast_PERIOD_net wrote in message
. ..
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
|