Font, borders, alignment all cells with content
I have a daily report exported as an Excel file that is always ten columns wide but has a varying number of rows. I need to set Arial 8pt font, borders, and top horizontal alignment to all cells of those columns/rows. I've seem some code using the activesheet.usedrange property, but the documentation indicates it works only on cells with content. There may be several adjacent cells without content on a given day. Am I using the right property?
Last edited by kevinbradley57; 03-13-2018 at 12:41 PM.
Reason: Fixed typos
|