Merged fields in Excel don't stretch to fit the text

Anonymous

I have an excel 2010 spreadsheet that I use to Macro out certain sheets into its own file and within that sheet I have 3 columns but some of the rows are merged across those 3 columns. When I macro out the row does not auto fit the text because it is merged. Is there anything I can add within my macro to automatically get the row to fit the text?

Thanks

Micheemoo

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous

What I posted is worksheet event code.

Right-click on the sheettab and select "View Code"

Paste the code as is into that module.

Return to the sheet and make sure merged cells are formatted to wrap text.

When you type text into a merged cell then hit Enter the autofit will take place.

If you already have text in a cell you can F2>Enter to trigger the code.

Gord

0 comments

10 additional answers

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more
Anonymous

2015-01-12T17:10:28+00:00

To autofit row (assume that you have set wrap text)

Rows("5:5").EntireRow.AutoFit

To autofit column

Columns("D:D").EntireColumn.AutoFit
Was this answer helpful?

0 comments No comments