Post NOW() in column that has header of todays month

[surkdidat]

In Row/Column B5:b16 I have months, Apr, May, June, July, August...... etc

What I need is when my VBA Code is run, for whatever row I am in (say row D) , I want it to look at the correct column header for that month (so today is June) and then place a timestamp

Many thanks

 

[kweaver]

Are the month names in Rows or Columns? There is no "(say row D)" as the rows are labeled with numbers.
What are the column headers? The month names? Are the headers in row 5 or row 1?

 

[surkdidat]

Hi

The months are in Row 2, from column 5 onwards (b5). and are all in row 2.

Column Headers are month names in full, starting APRIL (B5), MAY (B6), JUNE (B7), JULY (B8) , AUGUST (B9), SEPTEMBER (B10), OCTOBER (B11) , NOVEMBER (B12), DECEMBER (B13) , JANUARY (B14) , FEBRUARY (B15) , MARCH (B16)

Are the month names in Rows or Columns? There is no "(say row D)" as the rows are labeled with numbers.
What are the column headers? The month names? Are the headers in row 5 or row 1?

 

[kweaver]

If the column headers are in ROW 2 starting in COLUMN B, then APRIL would be in B2, MAY would be in C2, etc. Is that what you mean?

 

[surkdidat]

*** PLEASE IGNORE, CANNOT DELETE, INCORRECT POSTING ***
Hi, no, April is in B5, May is in B6 etc.
In C4, D4, E4 will be the references. When I am in a cell (say D4) and I run the macro, I want it to carry on along that row until it finds the correct cheader (June would be B7), so it puts todays date in D7

 

[surkdidat]

Sorry, please ignore my previous post, this is correct

If the column headers are in ROW 2 starting in COLUMN B, then APRIL would be in B2, MAY would be in C2, etc. Is that what you mean?