Using a function to delete blank cells
Hi,
I hope I ask this in the right way: I have 4 column, 2,000 row sprdsht. I want to instruct Excel to look in column B, and if any column is blank, then delete it. In other words, out of all the records, I only want to see the ones that have text in col B. Does anyone know of a formula/function that can do that, or can you point me in the right direction? Thanks, Brian |
Using a function to delete blank cells
a Function can't but a Macro can
so if u realy mean that every Row's where column B is empty is deleted then try this: Sub CleanUp() Range("B1:B2000").SpecialCells(xlCellTypeBlanks).E ntireRow.Delete End Sub "Carter Devereaux" skrev: Hi, I hope I ask this in the right way: I have 4 column, 2,000 row sprdsht. I want to instruct Excel to look in column B, and if any column is blank, then delete it. In other words, out of all the records, I only want to see the ones that have text in col B. Does anyone know of a formula/function that can do that, or can you point me in the right direction? Thanks, Brian |
Using a function to delete blank cells
No worksheet function can delete things, only return results.
I would try this............. Select column B and F5SpecialBlanksOK. EditDeleteEntire Row. Gord Dibben MS Excel MVP On Fri, 31 Aug 2007 09:16:00 -0700, Carter Devereaux <Carter wrote: Hi, I hope I ask this in the right way: I have 4 column, 2,000 row sprdsht. I want to instruct Excel to look in column B, and if any column is blank, then delete it. In other words, out of all the records, I only want to see the ones that have text in col B. Does anyone know of a formula/function that can do that, or can you point me in the right direction? Thanks, Brian |
All times are GMT +1. The time now is 12:42 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com