VBA code to create a border around used cells in all worksheets

[Milos]

Hello excel champions,

I'm recording a macro and would like some VBA code help. I'm trying to make a border around all used cells in all worksheets (I have around 50 worksheets open at one time). When I use the macro there will be a variable number of used cells.

I would love help designing a code to cater to my three needs:

• If cell A1 has text then format cells A2:G2 with an outline border

• Repeat for each row in the sheet until there is no more text in column A.
• Do this for all worksheets in this workbook

I have managed to complete my macro to cater to the first two bullet points, but not quite the third bullet point.

Thanks so much for your help!

Milos

 

[MARK858]

@DushiPunda, I stand corrected, teach me for not reading/testing correctly but I still wouldn't use usedrange in general for the reasons stated although it doesn't affect this code because of the check in column A (and I would declare all variables as there isn't much point declaring any if they all aren't declared).