Macro to apply borders to all cells with text

This will put borders around each individual cell that has text. Is that what you are looking for?

Please Login or Register  to view this content.

HTH

Jason

Jason,

Thanks for the quick reply. When I ran the macro it formatted every cell from left to right that had text in that row.

Here is an example of the spreadsheet I have:

Text are in the following cells:

A1 B1 C1 D1
D2
B3 D3

I am just looking for those cells to receive the borders. I do not want borders in the others (i.e.A2, A3, B2)

Can you post up an example copy of your workbook so I can take a look at it?

Here is an example of the worksheet after I format it.

Ok, so in your example, what did you expect to accomplish? Do you want borders only in cells that have letters? Or only that have words? Please be more specific in exactly what you are looking for.

I need the macro to put borders around all cells with text inside. Just like how I have the borders formatted in the sample worksheet I sent you. If the cell does not have text, it does not get a border. If it has text it gets a border.

The issue is that several of the cells have spaces in them. So you first need to get rid of those, then apply the borders. Try:

Please Login or Register  to view this content.

HTH

Jason

Thanks for the help. You saved me a lot of time.

Hello Jason,

The macro provided by you is very good. I'm using it and it works really great.
The only thing I can't get it doing is to also put border around some cells that have a number in it.
I have some data that has at the end a total and to the right the amount (number). The
rest all get the border but it skips the cell with the number. Is there a way to make it also put it arround the number?
(I did add a comma and then xlNumbers, it does not do the trick).

Again thanks for the great MACRO ;-)

Hello Megatronixs, and welcome to the forum.

Unfortunately you have inadvertently broken one of the forum rules. Please read the following and make the necessary change. Thanks.

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread. It makes sense to have a new thread for your question because a thread with numerous replies can be off putting & difficult to pick out relevant replies.

Hello Cutter,

Thanks for informing me about this. I will avoid this in the future.

greetings.

Hi,

Can you please help me make a macro to add border.

See attached for example. Thanks