Results 1 to 6 of 6

Clear range of cells 'to the bottom of the spreadsheet'

Threaded View

  1. #1
    Registered User
    Join Date
    08-29-2010
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    3

    Clear range of cells 'to the bottom of the spreadsheet'

    Hi

    Have some varying number of results displayed that could be all the way to the bottom of the spreadsheet, but starting at a certain point down the column already (just below a cell I've named 'wienerOutputT' and need to first clear the entire area.

    If always had N rows, this is what I'd do (in fact, that range is where the output goes):

        Dim wienerOutputRange As Range
        Set wienerOutputTopLeft = Range("wienerOutputT").Offset(1, 0)
        Set wienerOutputBottomRight = Range("wienerOutputT").Offset(N, 1)
        Set wienerOutputRange = Range(wienerOutputTopLeft, wienerOutputBottomRight)
        wienerOutputRange.ClearContents
    How can I first clear 'all the way down' where N is the bottom (or max row perhaps) please? This is literally my first day with Excel so apologies if easy one.

    Thanks in advance,

    Color
    Last edited by colorrider; 08-29-2010 at 09:53 AM.

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1