BTW your clock is 3 days ahead, please reset as it distorts the posts in the
NG.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Maddoktor" wrote in message
...
So Sorry Bob,

I sent the wrong e-mail. This e-mail was supposed to be:

Column B - to be automatically updated with every date for the month
that I enter into B1. i.e. B1 = Feb, then B2=1-Feb, B3=2-Feb, etc ...

Column C - to be automatically updated with the serial numbers for each
particular date. i.e. B2=1-Feb then C2=4, B3=2-Feb then C3=5, etc ...

and finally ...

Column A - to be automatically updated with only the dates for which the
serial number is greater than 1 and less than 7, i.e. week days.

Is this possible.

Thanx



P.S. Thanx again. It worked great :-)









Bob Phillips wrote:
You could set a flag in the hidden sheet when a change is made there

Private Sub Worksheet_Change(ByVal Target As Range)
Thisworkbook.fHidden = True
End Sub

'This is worksheet event code, which means that it needs to be
'placed in the appropriate worksheet code module, not a standard
'code module. To do this, right-click on the sheet tab, select
'the View Code option from the menu, and paste the code in.
Public fHidden As Boolean


and then trap that flag on exit

Private Sub Workbook_BeforeClose(Cancel As Boolean)
If fHidden Then
ThisWorkbook.Save
End If
End Sub

Private Sub Workbook_Open()
End Sub

'This is workbook event code.
'To input this code, right click on the Excel icon on the worksheet
'(or next to the File menu if you maximise your workbooks),
'select View Code from the menu, and paste the code