For adding one column at the beginning of the sheet you simply typesomething like the code below:
ActiveSheet.Columns(1).EntireColumn.Insert
And after you have done that you simply type:
ActiveSheet.Columns(ActiveSheet.UsedRange.Columns.Count).EntireColumn.Delete
to delet the last used column.
Here is how you get the day of week:
http://msdn.microsoft.com/en-us/library/system.datetime.dayofweek.aspx[
^]
It should be easy for you to loop through the first date in a month, and simply count three Mondays.
This question here I dont actually get:
Quote:
Also, it is possible to defined multiple macros on a single button?
You can write as much code as you like in a single macro, you could also have several macros in one excel file, so I dont understand what you mean here...
I hope this helps :)