in vVBA, How do you serach particular cell contains value or not?

for example B2 cell having some value .how to search in cell value??

Hi,

Could be somthing like this:

Sub test()
If Range("B2") <>"" then
 'cell has a value (or non numeric)
else
 'cell has no value
end if
End sub

Just a starter

Maurice