To Select Cells and format them, when there are uneven number of rows and columns

[sankavi]

Hi,

I have a file with data in both rows and columns.
There are some empty cells.
the cells contain numbers or strings.

I need to format this sheet.
Bold all the strings
Draw a table border
and centre all the contents in each cell.

I don't know how to generalise the range and make it the selection.

[Dreambringer]

Welcome to the Excel Forum!

I think this is what you are looking for. Please back up your excel workbook before running this macro!

Please Login or Register  to view this content.

[sankavi]

thank you for the code! but it is not formating the text. it only formats the number columns. I would like it to even format the text columns. how can i do that?