Getting run-time error 424 object require

Trouble is, I don't know what values (cell ranges) you are putting in for each of the Input Boxes so I can't step through.

I also don't know what you expect to see for a given range of cells based on what you enter.

Hi TMS,
Don't mind. Please see the file attached for your kind perusal to understand the requirement.

I want to start outer border from cell ‘P2’
I want to have a inner border from cell ‘P5’
I don’t want inner border in range row 2:4 because there is a name of institution and other information merged columns.
In row 5 there are the titles of the table.


In outer border input box I enter cell range P2
In inner border input box I enter cell range P5

Hope this will help you to find the solution.