| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Deleting rows
I have a question, I have a spreadsheet which contains two columns of text
which are b and c and 7 columns of numbers and formulas which are d-j, there are some rows on which I will have nothing but zeros and blank cells, I would like to make a macro which would delete all the rows if there are any empty/zeros within columns d-j. Thank you. Joe Diaz Wrote |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Deleting rows
Clarification please. Do you want to delete the row even if there is only
one empty/zero cell in the row... or do you want to delete the row only when all seven cells for the row in D through J are empty/zero? -- Rick (MVP - Excel) "Pepe Saldana" wrote in message ... I have a question, I have a spreadsheet which contains two columns of text which are b and c and 7 columns of numbers and formulas which are d-j, there are some rows on which I will have nothing but zeros and blank cells, I would like to make a macro which would delete all the rows if there are any empty/zeros within columns d-j. Thank you. Joe Diaz Wrote |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro for deleting rows and serialising the remaing rows | Links and Linking in Excel | |||
| Macro for deleting rows and serialising the remaing rows | Setting up and Configuration of Excel | |||
| Macro for deleting rows and serialising the remaing rows | Excel Worksheet Functions | |||
| Help!! I have problem deleting 2500 rows of filtered rows!!!! | Excel Discussion (Misc queries) | |||
| deleting hidden rows so i can print only the rows showing?????? | Excel Worksheet Functions | |||
Linear Mode
