I have a macro that will change the font size of any cell that is longer than 12 characters but I need it to ignore every 8 rows. i.e. I need it to activate on row 10,19,28,37,etc but not 11,12,13,etc. I believe Mod Row would work but I can't figure out how to properly write it in. Any advice would be greatly appreciated.
Here is what I have so far:
Thank you
Please Login or Register to view this content.
Last edited by mikeymeteora; 08-28-2019 at 10:28 AM.
Please wrap VBA code into CODE tag (or use # icon on menu).
If you want to check each 8th row, maybe instead of:
do loop like below:Please Login or Register to view this content.
(btw, it looks like each 9th not 8th)Please Login or Register to view this content.
Last edited by KOKOSEK; 08-28-2019 at 10:28 AM.
Happy with my answer * Add Reputation.
If You are happy with solution, please use Thread tools and mark thread as SOLVED.
Hi Kokosek thank you for the suggestion I'm very unsure how to implement that into my code. Could you post a complete version of what that would look like?
Try like this:
EDIT: misunderstanding, new code pasted.Please Login or Register to view this content.
Last edited by KOKOSEK; 08-28-2019 at 11:46 AM.
Thank you but I can't get this to run, I have no idea what I doing wrong but it . I don't fully understand your code but it looks like it will only activate for Column A when I need it to work across the range A:AN.
Check post above yours after 'repost'.
Thank you. This does solve my issue, although Row 198 and Row 388 aren't being affected. -10 they are 21*9 and 42*9. But I can't figure out why that matters.
Also I realise now that my cells are actually long formulas that draw in the text and the length function seems to be measuring the length of the formula instead of the displayed text. Is there a simple solution to make the macro read the displayed text instead of the formula?
I have figured out a solution by taking the mod line from your code and putting it into mine.
Thank you for the help.Please Login or Register to view this content.
Try:
instead of:Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks