How to delete the even rows?
Hi 天方,
A possible downside to my suggestion, but not to Tom's solution, is that it
requires that the Analysis ToolPak be installed.
It is preferable, and much simpler, therefore, to use the natively available
Mod function!
---
Regards,
Norman
"Norman Jones" wrote in message
...
Hi 天方,
I am not familiar with the VBA
For a non-programmatic solution, in the first cell of a helper column
insert the formula:
=ISODD(ROW())
Drag this formula down as far as required.
Autofilter the helper column using FALSE as the filter criterion
Delete the filtered even rows.
If you want a re-usable programmatic solution, turn on the macro recorder
and then run the above manual procedure. This will provide base code which
can be adapted for general application.
If you require assistance with such adaptation, post back.
---
Regards,
Norman
"天方" wrote in message
...
I am a newbie.
I am not familiar with the VBA
Any one can tell me how to do that?
|