View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Juan Correa Juan Correa is offline
external usenet poster
 
Posts: 29
Default Check if value does not exist in range.

Hello

I have a small question for the gurus he

I have a spreadsheet with Data. The data is stored in columns A through P
with column labels in row 1. So my column lables are A1:P1

I know how to use:
Cells.Find(What:="SomeColumnLable").Column
To determine which column any particular bit of information is located at.

My question is:
Is there a way that I can use the Cells.Find to check if a column label does
not exist in the range?

Thanks
JC