Merged Cell column width vs single cell column width

[ratdogexcel]

what ive got on my spreadsheet is
J1:Q1 as merged cells with text in it
in T1 i have the exact same text

I have set the column width of Col T with the below code

Please Login or Register  to view this content.

The physical size on the screen and when printed is different between the cells.

This matters to me as I am running out of space on the page when printing.

Any tips that might help me solve this?

[jmac1947]

Hi Ratdogexcel,

I see from the forum that VBA and merged cells don't always work well together so....

Have you (in manual mode) tried to see what the size of the merged "J" column is and simply use that for "T"

I haven't got an example to work with (tip, always post a sample spreadsheet) so this is just guesswork, as I say the forum posts seem to indicate difficulty with merged cells unless you are really sure what you are doing

jmac1947

[Izandol]

Perhaps iteration will be more accurate - you may try:

Please Login or Register  to view this content.

[ratdogexcel]

Thanks Izandol

Your code worked perfectly as long as the original size of Row T is less than the cumulative size of the other rows.


Im not too sure why the other one didnt work but im happy with this result.

Test Col T.xlsm