Range is returning a nothing value

Viewed 42

I wrote a code to find date in a column. It worked initially. After I made a few adjustments, it started returning a "nothing" value in the watch window

Sub test()
  Dim strDate as string
  Dim rcell as range

StrDate = date

Set rcell= range("A:A").Find(Cdate(strDate))

End sub
0 Answers
Related