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

Hi colorrider, welcome to the forum.

Be sure to read through the Forum Rules so you can use and follow them effectively. For instance, you'll need to EDIT that post above and put code tags around that code you used. (Like shown in my signature)

...or just remove the code. Your question is really a simple "how do you reference the last row of the worksheet in a variable" and we don't need your code to answer that.

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code. Posting code without them makes your code hard to read and difficult to be copied for testing. Highlight your code and click the # at the top of your post window. For more information about these and other tags, found here

Do you mean that you want to clear the contents of a named range from a certain row in that range to the end of the range?

I assume Range("wienerOutputT") is a named range

If so try this

Sub ClearRangeContents()
    Dim rng As Range
    Dim n As Long
    
    Set rng = Range("wienerOutputT")
    n = 10
    With rng
        If n >= .Rows.Count Then Exit Sub
        If n = 0 Then n = 1
        Range(Cells(.Row + n, .Column), Cells(.Row + .Rows.Count - 1, .Column + .Columns.Count - 1)).ClearContents
    End With
    Set rng = Nothing
    
End Sub

If you just want to find the last used row in a column

LastRow = Range("A" & Rows.Count).End(xlUp).Row

Perhaps if you were to post a sample workbook showing before and after we might give a clearer answer.

[EDIT]
I have added a demo workbook
Change n in the code as you wish

I have used .Select in the example to show how it works
You should use .ClearContents in your final code

or perhaps use this line instead

Range(Cells(.Row + n, .Column), Cells(.Row + .Rows.Count - 1, .Column + .Columns.Count - 1)) = ""

Select the whole table and drag it any where in the sheet and the code will still work.

Hope this helps