Posts by ant_sutton

Re: VBA: Delete row using ID number and input box????

Hi again.

Is there any way to delete the row except from the ID number in column A?

Thanks alot

Anthony

Thanks

Thankyou so much, your a life saver. You have no idea how long i've been messing around with this.

Thansk again

Ant

thanks

Thanks alot but when I run the macro nothing happens. Does the ID have to be an autonumber? Any idea how I can make the ID column (columnA) an auto number. OR why this isnt working

Thanks alot

Anthony

Hi guys. I'd appreciate any help on this.

I have a basic spreadsheet with the first column being 'ID'. I want to be able to delete any row with data in by using VBA to code a macro that when ran by a button will open an input box - "Enter ID number of row you want to delete". The ID number will be entered and all data from that row will be deleted and the rest of the rows will move up to fill the space.

Any ideas.

Thanks

Anthony