Problem in Bordering a Range

[vijay2482]

Hi all,
I would like to draw the border for the cells with in the usedrange from column A to BM.
I have the below code, that I was using to border the column D alone.
When i change the range from "A:BM", i dont get the intended output.
Can somebody tell, what modification, I should do to get the desired output?

Please Login or Register  to view this content.

Thanks in Advance

[royUK]

Try this

Please Login or Register  to view this content.

[vijay2482]

Roy,

Thanks for the code.
It does borders the entire excel.
But I dont want to disturb the last used range of the excel sheet.

Please Login or Register  to view this content.

I modified your code as above, but got error.
Any help on this will be helpfull.

[royUK]

I'm not clear which row you do not require borders on

[royUK]

This will add borders to all cells except the last row

Please Login or Register  to view this content.

[vijay2482]

Thanks a lot Roy,
The borders were drawn as expected.