Deleting rows

drag-driver · Mar 7th, 2002, 06:57 AM

I need a funtion that works fuch that: IF a condition is true then delete the row else do nothing.Ie tryin to filter the data. I now you could record a macro to do this but i tought thir may be a funstion? Please let me knoe if you have any ideas.

Barrie Davidson · Mar 7th, 2002, 07:42 AM

Quote:

On 2002-03-07 05:57, drag-driver wrote:
I need a funtion that works fuch that: IF a condition is true then delete the row else do nothing.Ie tryin to filter the data. I now you could record a macro to do this but i tought thir may be a funstion? Please let me knoe if you have any ideas.

Sorry, there's no function that will delete a row (that's an action and, as you stated, can only be done using VBA).

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 7th, 2002, 06:57 AM	#1
drag-driver Board Regular Join Date: Feb 2002 Posts: 91	I need a funtion that works fuch that: IF a condition is true then delete the row else do nothing.Ie tryin to filter the data. I now you could record a macro to do this but i tought thir may be a funstion? Please let me knoe if you have any ideas.