VBA - Putting a border around cells that arent empty

[Chris424]

Hello all,

I am stuck on a project. I am trying to Put a border around cells that arent empty. Is this possible?

I have tried playing with this code but got stuck.

Please Login or Register  to view this content.

Can anyone help? I would be really grateful.

[royUK]

You don't need a Loop

Please Login or Register  to view this content.

[Chris424]

Thank you, This gives me an error? Does it work for you?

The error 91 is on line

Please Login or Register  to view this content.

[royUK]

Works fine for me. Check the Border Format by using the Macro Recorder

[Andy Pope]

Roy your code dows empty cells. Think the OP want's non empty cells.
In which case a different argument is requried for the SpecialCells method.

[VBA Noob]

Try this

Please Login or Register  to view this content.

VBA Noob

[royUK]

Roy your code dows empty cells. Think the OP want's non empty cells.
In which case a different argument is requried for the SpecialCells method.

I misread that Andy

Use

Please Login or Register  to view this content.

[Chris424]

I tried all these ideas but still get various errors.
I have attached a spreadsheet would someone mind taking a look? Thankyou for all ur help

[Andy Pope]

You have no formula cells so this quick change will give you a border around the first column.

Please Login or Register  to view this content.

Is that what you want?

[Chris424]

That is what I was after! Is it possible to have each cell seperated? like the ones in yellow on my attachment?

[Andy Pope]

Please Login or Register  to view this content.

[Chris424]

That works perfectly! Thankyou very much!