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
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