Autosize Rows in Named range

[Chewyhairball]

Hi

I have a named range called "Summary Table" that I would like to Autofit the row height to the data that is typed in.
Sometimes its just a few words and other times might be a few sentences.

any ides?

thanks

Rory

 

[NoSparks]

try

Range("SummaryTable").Rows.AutoFit

 

[Chewyhairball]

Hi No Sparks

Where would I put that for it to trigger when I type into one of the cells in the range. Worksheet Change event?

Thanks

Rory

 

[Joe4]

Where would I put that for it to trigger when I type into one of the cells in the range. Worksheet Change event?

Yes.

 

[Chewyhairball]

Hi

I already have a worksheet change event and I added it to the beginning of that, however I am getting this error now!?

 

[Joe4]

Post your code for us to see.

 

[Chewyhairball]

Post your code for us to see.

It works in the first column of the range so Im pretty sure it is today with the other columns being merged cells...is it possible to do it on merged cells?

 

[Joe4]

It works in the first column of the range so Im pretty sure it is today with the other columns being merged cells...is it possible to do it on merged cells?

Get rid of the merged cells, if at all possible!!!
Merged cells cause all sorts of problems with VBA and other things, like sorting (it may be possibly the worst feature ever designed in Excel).
So most people will avoid them like the plague!

If you are just trying to align multiple cells across single rows, you can accomplish the same visual effect by using the "Center Across Selection" formatting option instead.
See: Tom’s Tutorials For Excel: Using Center Across Selection Instead of Merging Cells – Tom Urtis

 

[Chewyhairball]

Get rid of the merged cells, if at all possible!!!
Merged cells cause all sorts of problems with VBA and other things, like sorting (it may be possibly the worst feature ever designed in Excel).
So most people will avoid them like the plague!

If you are just trying to align multiple cells across single rows, you can accomplish the same visual effect by using the "Center Across Selection" formatting option instead.
See: Tom’s Tutorials For Excel: Using Center Across Selection Instead of Merging Cells – Tom Urtis

All I can say is wow! Centre across selection!!

Works perfectly!

thank you

 

[Joe4]

You are welcome.
Glad that worked for you.