D
Dennis Allen
Hi. I have a workbook with 400 sheets. Each sheet contains an area for log entries (A11510). (B11:B510) has the log dates. In
one cell I want to display the latest log entry date. I was thinking B4=LatestFix(), as in:
Public Function LastFix()
LastFix = 0
i = 11
Do While i <= 510 And Cells(i, "B") > 0
LastFix = Cells(i, "B")
i = i + 1
Loop
End Function
Problem. Suppose the user adds a new entry. How can I get B4 to recalulate LatestFix()? What's the best way? I was thinking
Worksheet_Change(), but I have 400 sheets. Unless you can somehow select all sheets and edit all their Worksheet_Change() at once,
that's a lot of work. Any advice would be helpful...Dennis
one cell I want to display the latest log entry date. I was thinking B4=LatestFix(), as in:
Public Function LastFix()
LastFix = 0
i = 11
Do While i <= 510 And Cells(i, "B") > 0
LastFix = Cells(i, "B")
i = i + 1
Loop
End Function
Problem. Suppose the user adds a new entry. How can I get B4 to recalulate LatestFix()? What's the best way? I was thinking
Worksheet_Change(), but I have 400 sheets. Unless you can somehow select all sheets and edit all their Worksheet_Change() at once,
that's a lot of work. Any advice would be helpful...Dennis