Thread: If Statement in vba to Delete a Line
View Single Post
 
Old 04-01-2014, 10:05 AM
mbesspiata mbesspiata is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
  
Join Date: Mar 2011
Location: Virginia
Posts: 57
mbesspiata is on a distinguished road
Default If Statement in vba to Delete a Line
I run a report weekly that sometimes exports a blank line in the pivot table and therefore the last line of the table in column A has this (blank). I would like to create something in vba to look in column A for a cell that contains (blank) and then delete that line from the sheet.

Is that possible?

Mike
Reply With Quote