See

http://xldynamic.com/source/xld.Deleting.html

--
Kind regards,

Niek Otten

"Duncan" wrote in message
oups.com...
Hi all,

Wonder if anyone could help me, I am struggling to find a way of
getting a macro to (upon change to a range) check the number that has
been put in across all of the tabs in the worksheet and remove that
number and its row (hopefully not leaving a blank row behind) from all
of its instances in all tabs.

It is a unique number and the key to the whole sheet (it is a barcode
number read in through a scanner) and I want (to keep my figures
correct) a way of determining that this record no longer wants to be
counted in with the figures.

or i could do it another way, I suppose i dont really need it to be
deleted, I could just do with it marking a cell on that row that is
used for the 'count' so its not counted but then that would involve
changing all of my code thus far to populate a 'count' cell as well.

so i have a seperate tab at the end which would be used to scan in all
the numbers that are 'finalised' and upon change to this tab i need it
to check the number put in and make the changes to stop it being
counted in.

Could anyone help?

Many thanks in advance

Duncan