View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Marco Marco is offline
external usenet poster
 
Posts: 69
Default Storing column() to use later

In a spreadsheet, I have the years 2007 to 2050 along the top of a table and
I have the months of the year down the left most column (with the week number
below each month). I want to find a year along the top, identify the column
number associated to that year, and store that column number to use later in
the macro. What would be the code?

Thanks.