How to delete specific row from sheet?

[Sirritys]

Hi,

How this differs from all other posts like this is that I want a
function that deletes certain row, like "1" or "100", by given row
number. Not with specific criteria.

Something like this. =IF(something;deleteRow(3);0)

So what I want, is that deleteRow(3) =)

Thanks for help,

-Sirritys

 

[Ardus Petus]

No worksheet function can delete a row.
You will have to use a VBA Sub fort that.

HTH

 

[Sirritys]

Can I call VBA sub from sheet, without running it with alt+f8?

-Sirritys


Ardus Petus kirjoitti:

 

[Ardus Petus]

No, but you can have VBA ran by a Worksheet event procedure, like
Worksheet_Change
That proc can check wheter a condition is met, and then delete a row.

HTH

 

[Otto Moehrbach]

As Ardus says, you need VBA to do what you want. So when do you want this
to happen. Maybe when you enter something in some column or some row or
some area? Or maybe when you click on a button? When you decide, post back
with more info about the layout of your data. HTH Otto

 

[Sirritys]

Thanks for help, this question was part of bigger problem, and it
already got answered here:

http://groups.google.fi/group/microsoft.public.excel/browse_thread/thread/29e53b051850a472?

-Sirritys