resize used range

[sacwgar]

I am trying to merge multiple worksheets within the same workbook. I need to exclude to top 5 rows as well as the bottom 2 rows from the used range. how do i modify the code below to resize the used range?

Please Login or Register  to view this content.

Thanks for your help!

[shg]

Welcome to the board.

Please take a few minutes to read the forum rules, and then edit your post to add CODE tags.

Thanks.

[shg]

Thanks for that.

Maybe (untested):

Please Login or Register  to view this content.