|
-
Jul 23rd, 2004, 03:56 PM
#1
Thread Starter
Hyperactive Member
 [RESOLVED] This isnt working all of a sudden
ActiveSheet.UsedRange.Columns(3). _
SpecialCells(xlCellTypeBlanks).EntireRow.Delete
I have been using this for a while now to remove empty rows from crystal report that have been exported to excel. Today the report was altered so I needed to alter my code and now that above line deletes everything.
Anyideas?
Swoozie 
Somedays you just should not get out of bed.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote