Using a macro to format data: deleted rows with a certain charact
 

Hi,

I want to create a macro to re-format data that comes in the same format.
For one step, I want to delete all rows that have a certain characteristic -
i.e., a value of "1" in column A. The number of rows is not constant by data
table, however. Is this possible?

Thank you for your help!

Using a macro to format data: deleted rows with a certain charact
 

Hi
see:
http://www.xldynamic.com/source/xld.Deleting.html

--
Regards
Frank Kabel
Frankfurt, Germany


stilllearning wrote:
Hi,

I want to create a macro to re-format data that comes in the same
format. For one step, I want to delete all rows that have a certain
characteristic - i.e., a value of "1" in column A. The number of
rows is not constant by data table, however. Is this possible?

Thank you for your help!