Can you explain a little better. We can't tell from your posting where any
of the data is located.

"Tony" wrote:


I have the following spreadsheet where I have to VBA code the cell with the
first day of the month with the corresponding day of the first week in row 3
using the recorded month as a reference point. For example April 1st of this
year fell on the Weds in the first Week.

April
A B C D E F G 1 M T W TH F M T 2 1

Can someone help out with some code? I am learning how to code VBA through
this site, but this one seems to be more difficult than I can do.