Hi,

Using VBA, I need to take the value of one cell, find it in a range of cells
and return the row number it is found on. Is there a function that will do
this? I thought if might be Match but it is erroring out as a type mismatch.
Isn't the row number treated as a number?

Dim PoolChoice as Long

PoolChoice = Application.Match(Tablespg.Cells(Choice, 24),
Tablespg.Range("CAMPoolTypes"), 0)
--
Thanks for your help.
Karen53