Help with dates
Closed
dspringwater
-
Aug 14, 2009 at 01:13 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 14, 2009 at 08:44 PM
venkat1926 Posts 1864 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 - Aug 14, 2009 at 08:44 PM
Related:
- Help with dates
- If statement with dates - Guide
- How to format dates in excel - Guide
- Convert dates with dots excel ✓ - Office Software Forum
- Change file dates - Guide
- Numbers, text, dates, or times of day that you type into a cell. ✓ - Excel Forum
1 reply
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
810
Aug 14, 2009 at 08:44 PM
Aug 14, 2009 at 08:44 PM
try this modify to suit you
Sub test() Dim ddate, j As Integer, k As Integer With Worksheets("sheet1") ddate = .Range("a1").Value j = Worksheets.Count For k = 2 To j With Worksheets("sheet" & k) ddate = ddate + 1 .Range("a1") = ddate End With Next k End With End Sub