+ Reply to Thread
Results 1 to 3 of 3

Offset Entire Row

  1. #1
    Registered User
    Join Date
    05-08-2008
    Posts
    35

    Offset Entire Row

    Afternoon all

    I have a macro in an Excel file and I am struggling with one bit:

    I have used the Selection x1Down code to select all rows to the next one with data in but now need some code to deselect the final row (I want to delete all of the blank rows above)

    Can anybody help?

    Thanks in advance

    Matt
    Last edited by mattydalton; 10-09-2008 at 12:05 PM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,419
    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    05-08-2008
    Posts
    35
    Cheers Andy

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Charting Offset Functions
    By thule125 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-04-2008, 04:24 PM
  2. Using offset in series values of chart
    By Dutchbeer in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-16-2007, 09:05 AM
  3. Copying and pasting entire rows
    By jclu in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2007, 03:04 PM
  4. Replace Entire cell content
    By srinia123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-14-2007, 02:38 AM
  5. Highlight/Move Entire Row If...
    By LittleRainCloud in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 10-20-2006, 12:29 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1