If Statement in vba to Delete a Line

		Microsoft Office Forums > Microsoft Excel > Excel Programming
If Statement in vba to Delete a Line

FAQ

Thread Tools

Display Modes

04-01-2014, 10:05 AM

mbesspiata mbesspiata is offline

Windows 7 64bit If Statement in vba to Delete a Line

Office 2010 64bit

Advanced Beginner

Join Date: Mar 2011

Location: Virginia

Posts: 57

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

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Why cant I delete the black line at the side of my orginisational chart?	Gabby1991	Drawing and Graphics	1	01-07-2014 09:14 PM
unable to delete a horizontal line	jerryny	Word	2	03-31-2013 05:59 PM
Search for text then delete line	konopca	Word VBA	2	06-07-2012 02:44 AM
Very Urgent - Not able to delete Line	krishnaoptif	Drawing and Graphics	11	05-29-2012 11:25 AM
Cannot delete line	adkr	Office	1	04-07-2010 09:26 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:18 PM.