View Single Post
 
Old 03-13-2018, 12:29 PM
kevinbradley57 kevinbradley57 is offline Windows 7 64bit Office 2010 64bit
Advanced Beginner
 
Join Date: Jul 2017
Posts: 89
kevinbradley57 is on a distinguished road
Default 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
Reply With Quote