Hi guys...
I'm sight impaired, and need to print a set of Avery labels.
Because of my disability, it would be great if I could create an Excel worksheet which I can import into the Avery software where the size of the text in each cell expands to fill the available space in that cell - so the fewer letters in the text, the larger the font size could be.
I've been hunting around, but can only find solutions which autosize at column level based on the largest text in columns, so one 'wide' cell determines the width of all text in that column.
Does any one know a way (probably using VBA) of adjusting the text size in each cell so that the text in that cell 'fills' the cell? I don't need to change the font in each cell (although that might also be a useful thing to do), just its size, but I need to keep the height and width of the finished text within the individual cell.
Any help will be greatly appreciated....