PDA

View Full Version : Solved: Passing row height properties to array



Digita
09-20-2007, 09:07 PM
Hi guys,

I need your help please. I have a range say A10:A150 with different row heights. I need to copy the same row height properties in this range to various locations on the same sheet. The target locations have data on them so if I do a normal entire row copy this would overwrite the data in the target ranges. To get around this is to copy the data in each target range to somewhere else first, then copy entire rows from A10:A150 and paste back the data.

Would there be a better VBA way in doing this? Load the range’s row height property in an array perhaps?

Thanks for your thought and input in this.

Regards


KP

Digita
09-20-2007, 11:57 PM
Hi again,

Just found a non VBA solution - highlight the entire row area, use the format painter and apply it onto another range.

Have a great weekend.

Regards


KP

Bob Phillips
09-21-2007, 01:19 AM
A little aside, if you double-click the format painter, it stayd active until you Esc out, that is you can apply that format to many ranges.

Digita
09-24-2007, 04:13 PM
Brilliant. Thanks XLD for the handy tip.