Set the specific column range instead of entirerow

Hi members,

I have below code which borders entire row of the selected cell temporary. I want small change -instead of entirerow border, I want border from a column to R column-

Please Login or Register  to view this content.

I want change something like this.
replace

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

Regards,
Nandkumar S.

Please Login or Register  to view this content.

you code was using the contents of those cells as the default property is Value. You needed to use the Address property

Please Login or Register  to view this content.

Dear millz,

Thanks for quick reply. I have tried this but not working............

Yes!!! That's it i was looking for

Thanks Andy Pope, added rep to you

Regards,
Nandkumar S.