Is there a way to write a macro that will go throught a worksheet and add 1 to each cell's font size used in that worksheet? I have different fonts and sizes on the worksheet so i cant just select all and change it globally.
my guess is it will looksmilar to this but i am not sure how to do it:
Please Login or Register to view this content.
Last edited by PY_; 02-28-2011 at 09:06 AM.
I would suggest to set defined size and font type you need to make it all identical, example
Please Login or Register to view this content.
Thanks for the response.
I believe i have it figured out.
Please Login or Register to view this content.
You don't need Selection & I would limit the code to the UsedRange
Please Login or Register to view this content.
Hope that helps.
RoyUK
--------
For Excel Tips & Solutions, free examples and tutorials why not check out my web site
Free DataBaseForm example
Thank you Roy for the input.
Along the same question, any idea why this doesnt this work?
Please Login or Register to view this content.
I know i have something typed incorrectly because it bypasses all the IF statements as soon as it gets to them (as if each one was false).
no object to apply, no Sheet indicated
it should be for example:Please Login or Register to view this content.
Please Login or Register to view this content.
This is driving me nuts that i can't get this little thing to run right. I attached my sample file.
Try this
Please Login or Register to view this content.
Thank you roy! I did change it by adding my original question to the code (i missed the +1 portion when trying to make the code do more)
I think i understand what i was missing: I basically didnt set an object to apply it to still (like waterserv mentioned) correct?
Please Login or Register to view this content.
You were applying to the range, it seems to work best in individual cells
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks