+ Reply to Thread
Results 1 to 3 of 3

Shift Cells to eliminate gaps

Hybrid View

  1. 08-26-2009, 07:02 AM #1
    jasocke2
    jasocke2 is offline
    Registered User
    Join Date
    08-20-2009
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    45

    Re: Shift Cells to eliminate gaps

    Hi,

    Have a read on here:

    http://www.cpearson.com/excel/deleting.htm

    May point you in the right direction.

    Thanks
    Reply With QuoteRegister To Reply
  2. 08-26-2009, 07:23 AM #2
    StephenR
    StephenR is offline
    Forum Guru
    Join Date
    08-26-2007
    Location
    London
    Posts
    4,606

    Re: Shift Cells to eliminate gaps

    With little to go on, this might work:

    ActiveSheet.UsedRange.SpecialCells(xlCellTypeBlanks).Delete shift:=xlUp
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

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


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1