View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
OssieMac OssieMac is offline
external usenet poster
 
Posts: 2,510
Default 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