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
If you just want to find the last used row in a column
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
Select the whole table and drag it any where in the sheet and the code will still work.
Hope this helps
Bookmarks