![]() |
|
#1
|
|||
|
|||
|
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 |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Remove borders from cells
|
otuatail | Excel | 1 | 08-12-2016 05:25 AM |
| Using alternating borders in adjacent cells | jrevard | Word | 0 | 10-15-2015 09:07 AM |
Shorter VBA for creating borders for cells
|
mbesspiata | Excel | 2 | 07-28-2014 12:37 PM |
| borders disappear from merged cells when pasting from excel | joba | Word | 0 | 09-10-2012 11:35 AM |
| Default Font/Alignment | FrankU66 | Word | 1 | 12-18-2011 09:37 AM |