Find Date In Row and Paste Value Under The Date

[benntw]

I have a sheet with a date range to put the current progress under it everyday. What I am trying to do is run a macro to take my current percent complete in A2 and look for date in range K2:BS2 that matches the date in cell A4 and place the percent complete as a value in the cell.

 

[benntw]

I get true in all cells.

 

[MARK858]

One last question, are the column widths wide enough to display the full cell contents?

 

[benntw]

Yes. If I tried to use a formula to count the columns it did not work. But if I entered the numbers from K to BS it worked. I used A1 as an Hlookup to put the number that was in the same column as the date I was looking for.