Thread: Macro to delete rows
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Melanie Breden Melanie Breden is offline
external usenet poster
  
Posts: 88
Default Macro to delete rows
Hi Kirk,

Kirk P. wrote:
I was hoping to create a VBA function that would identify empty or blank cells within a range, and then delete the row
associated with that empty or blank cell.

try this:

Range("A1:A50").SpecialCells(xlCellTypeBlanks).Ent ireRow.Delete

--
Regards
Melanie Breden
- Microsoft MVP für Excel -

http://excel.codebooks.de (Das Excel-VBA Codebook)

Reply With QuoteReply With Quote