Justifying data of varying row numbers

[Fiat77]

I have a formula below that works great to justify a group of data if it is exactly 5 rows high. I needed to adjust this formula to say however many rows my mouse has highlighted justify out 23 columns like the rest of the formula says. How can I adjust this so that the rows are not a fixed length but based upon however many I have highlighted? thanks

Application.ActiveCell.Resize(5, 23).Justify

 

[xlbo]

Application.ActiveCell.Resize(selection.rows.count, 23).Justify

Rgds, Geoff

Three things are certain. Death, taxes and lost data. DPlank is to blame

Please read FAQ222-2244 before you ask a question