Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I just discovered something weird. I hope I can explain it clearly.
I have a Worksheet_Change event that, among other things, incrememts the last check number in column J: Range("I3").End(xlDown)(1, 2) = Application.Max(Range("J:J")) + 1 Occasionally I have reason to manually type in a check number in that column. If I do, the next time I trigger the Worksheet_Change event, the check number is NOT incremeted. Can anyone explain this, and hopefully point me to a fix? -- David |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy Paste Wierdness | Excel Discussion (Misc queries) | |||
Application Look | Excel Discussion (Misc queries) | |||
macro to close excel application other than application.quit | Excel Programming | |||
application. ... | Excel Programming | |||
application.quit will not shut off application | Excel Programming |