+ Reply to Thread
Results 1 to 2 of 2

How to I tell UsedRange to not include certains rows?

Hybrid View

Ejb123erok How to I tell UsedRange to... 07-26-2013, 05:59 AM
JosephP Re: How to I tell UsedRange... 07-26-2013, 06:15 AM
  1. #1
    Registered User
    Join Date
    04-29-2013
    Location
    Uppsala
    MS-Off Ver
    Excel 2010
    Posts
    24

    How to I tell UsedRange to not include certains rows?

    Hi,

    My issue is that I want to delete a range that can vary with respect to number of rows but the range will: always start at the same rownumber and will always have the same number of columns.

    How do I write the code so that it does not include my headlines (they are on row 5 and columns A to D)? Naturally I could make it delete everything below row 5 but I'm still learning this VBA-stuff so it would be nice do this with UsedRange instead.

    Thank you

    regards,
    E

  2. #2
    Forum Guru JosephP's Avatar
    Join Date
    03-27-2012
    Location
    Ut
    MS-Off Ver
    2003/10
    Posts
    7,328

    Re: How to I tell UsedRange to not include certains rows?

    perhaps
    range("A5", cells.specialcells(xlcelltypelastecell)).entirerow.clear
    Josie

    if at first you don't succeed try doing it the way your wife told you to

+ 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. UsedRange.Rows.Count Reaching Limit at r257
    By pisteuo in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-05-2012, 10:56 AM
  2. How can i use UsedRange.Rows.Count if any blank rows embeded into the sheet
    By amarendra19 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-20-2011, 11:52 AM
  3. ActiveSheet.UsedRange.Rows.Count
    By Kjaer in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-13-2007, 05:51 AM
  4. Problem with USEDRANGE.ROWS.COUNT reporting one row too many
    By Peter Rooney in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-18-2006, 11:55 AM
  5. Real Value of .UsedRange.Rows.Count
    By dazman in forum Excel Formulas & Functions
    Replies: 23
    Last Post: 09-06-2005, 09:05 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