LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 12
Default 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!


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Custom Validation starting with 2 char & total less than 8 charact carusso Excel Worksheet Functions 4 January 26th 09 10:51 PM
auto row height a cell with wrap text enabled and a lot of charact RichAll-68 New Users to Excel 0 January 20th 09 04:15 PM
Macro deleted ALL data!! Angel the Secretary Excel Discussion (Misc queries) 4 August 6th 08 09:23 PM
shading alternate rows, but losing format when one row is deleted Candice Excel Discussion (Misc queries) 8 May 11th 06 04:01 AM
How do I delete checkboxes from rows I deleted in a macro? Jazzi-D Excel Discussion (Misc queries) 1 January 18th 06 12:49 AM


All times are GMT +1. The time now is 08:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"