worksheet_change deleting row triggers deleting worksheet not working properly

Hello,

I'm trying to get the worksheet_change to capture user deleting rows. In the worksheet column A and column B combined forms worksheet names. I'd like to have the event deleting the corresponding worksheet when user deletes that row. for example:

on this sheet I have
colA colB
1 Header Header
2 L0001 RFSP
3 L0002 RFSP
4 L0003 SSGP

then I also have worksheets with names "RFSPL0001", "RFSPL0002", "SSGPL0003"

I need the code to delete the worksheet when user deletes a row/rows - i.e. when user deletes row 2, the code deletes worksheet "RFSPL0001". the problem with the below codes is that it always delete the next worksheet, i.e. when user deletes row2, the codes deletes worksheet "RFSPL0002". the undo and redo didn't help either. can someone please help? thanks so much in advance

Please Login or Register  to view this content.

Thanks very much maniacb, I decided to use a user form instead because the routine also needs to handle if user wants to delete multiple rows as well, very much appreciated the idea though, can use it somewhere else definitely!