I have in my sheet the below formula:
To generate an automatic sequence number, depend on the cell in H column if it is not blank
I have a problem in above formula; when delete one row the sequence number following that deleted row gives errors
I think to change it to VBA
May I have VBA code doing the same job? But without any problem when deleting any row and the autonumber should remain constant once it has been assigned.
I hope it is clear