Dates?

  • Thread starter Thread starter lightbulb
  • Start date Start date
L

lightbulb

In column J I have dates in the format mm/dd/yy ... then across row 5 I have
monthes in the form month/yy (i.e. Apr-09). If a date in column J reads
05/16/09 , I want to place the certain text in the column corresponding with
May-09 (in the row that reads 05/16/09). Does that make sense? Any help?
 
I'm sure this macro will not do exactly what you want, but try it and come
back with corrections you want. Otto
Sub PlaceCertainText()
Dim rColJ As Range
Dim i As Range
Set rColJ = Range("J6", Range("J" & Rows.Count).End(xlUp))
For Each i In rColJ
Cells(i.Row, Month(i)) = "Certain text"
Next i
End Sub
 
Back
Top