Find Date Option

[rksample]

Hi,

I have an issue. I am trying to write a module, which makes a search in B:B for a date which is passed using sDate variable (which is a public variable).

I want to search the range and get the row number to the variable SPRow.

I tried many different ways, but still I am getting error. Please help me.

Thanks in advance,
Ravi.

 

[Andrew Poulsom]

What ways have you tried exactly? Find can be temperamental with dates:

http://www.cpearson.com/Excel/DateTimeVBA.htm#Finding