Check values in each column
Hi Martin,
Try one of the following
If WorksheetFunction.IsNA(Cells(2, iColumn).Value) Then
or
If WorksheetFunction.IsError(Cells(2, iColumn).Value) Then
Check Help under Is functions on the worksheet (Not in VBA editor) for more
info on these functions.
Don't know if you know this but you need to actually click on Help while in
the worksheet to see the help relating to the worksheet and the same if in
VBA you need to click on help while in the VBA editor otherwise you will not
be seeing the correct help. I included this because a lot of people have help
open and when they change between the worksheet and VBA they do not refresh
help and of course they cannot find what they are after.
--
Regards,
OssieMac
|