Putting borders around cells

[molesy]

Hi
I am trying to put borders around some cells using vba, i will post the code, can someone please have a look, this code only puts it around the rows.

Please Login or Register  to view this content.

[haripopuri]

add this.

Please Login or Register  to view this content.

[Norie]

That seems to work fine for me, it puts a box like border round the specified range.

Is that not what you want?

[molesy]

I want vertical between columns as well

[molesy]

sorry doesnt work properly

[alansidman]

Try adding this to your code at the end

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Works for me?

[molesy]

the first code worked well but the line on last row was missing

[haripopuri]

You have to add the code at the end of the code you already have, still last row border missing..?

[Norie]

Is this what you want?

Please Login or Register  to view this content.

[JOHN H. DAVIS]

Maybe?

Please Login or Register  to view this content.

[molesy]

Thanks, its all working

[haripopuri]

Please update the thread as solved, and if we helped you, please add to rep by clicking on star below the post.