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
Bookmarks