View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ian Ian is offline
external usenet poster
 
Posts: 238
Default Find specific string in range of cells

I am trying to "future-proof" some code.

I currently have some code which returns the first and last dates in a
specific column. This is fine, except that the column may change (was A, is
now B, may change again).

I have to modify the code as it is currently specific to column A.

What is the easiest way to fing the column with Date in row 1? I know I can
specify a range (eg A1:G1) then loop through to match the string, but is
there a better way?

--
Ian
--