Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-13-2018, 12:29 PM
kevinbradley57 kevinbradley57 is offline Font, borders, alignment all cells with content Windows 7 64bit Font, borders, alignment all cells with content Office 2010 64bit
Advanced Beginner
Font, borders, alignment all cells with content
 
Join Date: Jul 2017
Posts: 88
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
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Font, borders, alignment all cells with content 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
Font, borders, alignment all cells with content 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

Other Forums: Access Forums

All times are GMT -7. The time now is 07:28 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft