Results 1 to 7 of 7

Removing Haning Blank Rows

Threaded View

willhh3 Removing Haning Blank Rows 12-08-2015, 04:13 PM
LJMetzger Re: Removing Haning Blank Rows 12-08-2015, 05:11 PM
willhh3 Re: Removing Haning Blank Rows 12-09-2015, 09:05 AM
LJMetzger Re: Removing Haning Blank Rows 12-09-2015, 12:23 PM
willhh3 Re: Removing Haning Blank Rows 12-09-2015, 04:56 PM
LJMetzger Re: Removing Haning Blank Rows 12-09-2015, 05:40 PM
willhh3 Re: Removing Haning Blank Rows 12-10-2015, 02:07 PM
  1. #1
    Registered User
    Join Date
    11-09-2015
    Location
    Florida
    MS-Off Ver
    O365
    Posts
    61

    Removing Haning Blank Rows

    Lets say you get a report with 30 rows of data, you delete the last two and then go to cell A1. If you hit Ctrl+Shft+End the cells are all highlight including the blank cells that were deleted. I know that you can delete the blank rows, save/exit the workbook and then reopen it to correct this problem. What I'm wondering is there an easy snippet of code that can be used to select the data but ignore the deleted areas.

    In other words, and perhaps more clearly stated, If I have data in cells A1:B30 and use Ctrl+Shft+End cells A1:B30 are selected. If I then delete the data in A29:B30, return my cursor to A1, and hit Ctrl+Shft+End, the data selection is still A1:B30. Is there an easy way with code to make it select A1:B28? This is just a sample, the original report could have any number of rows and or columns and some times I get a report that already has blank rows at the end. I want to be able to select data only, no blank rows that may be lingering.

    If it helps, I often use the Ctrl+Shft+End in conjunction with something like this to format my data:

    ActiveSheet.ListObjects.Add(xlSrcRange, Range("$A$1").CurrentRegion, , xlYes).Name = "Table1"

    I'm attaching a simple test file that had data in A1:B30, and I've already deleted A29:B30. With the A1 selected you should see that Ctrl+Shft+End highlight all the way down to B30. Even Ctrl+End will take you to B30.

    As always, thanks in advance for any assistance.

    Whh3
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Removing blank rows after importing
    By manny1975 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-08-2007, 12:50 PM
  2. Removing Blank Rows from a Spreadsheet
    By kdeal in forum Excel General
    Replies: 1
    Last Post: 07-17-2007, 09:25 AM
  3. [SOLVED] Removing blank rows
    By Bob in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-20-2006, 07:55 PM
  4. Removing Blank Rows
    By inveni0 in forum Excel General
    Replies: 4
    Last Post: 02-05-2006, 06:15 AM
  5. Removing blank rows in a worksheet
    By Louise in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 09-06-2005, 03:05 AM
  6. removing rows that have a blank column B only
    By savbci in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-27-2005, 01:06 PM
  7. [SOLVED] Removing blank rows
    By Carlton Patterson in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-17-2005, 07:05 AM
  8. Removing blank rows
    By in forum Excel General
    Replies: 2
    Last Post: 03-15-2005, 11:51 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