Copy and paste row height from one sheet to another.

[Wolfieee]

I'm totally stumped on this one.

I have a worksheet that is broken up into 4 parts. I so far can copy the separate parts to a new sheet but the issues are they all have different row heights. I have searched google and I haven't found anyone trying to do this.

I have 3 buttons on the sheet to add the different parts in whatever order I need them. That part works fine

so far I have got this

Please Login or Register  to view this content.

I know I probably have it all wrong but I just can't work out how to get this to go.

Any help would be great.

I've added the excel file if that helps.

[AlphaFrog]

This is reversed. It's copying the row height from sheet Flight Plan to sheet Data.

Please Login or Register  to view this content.

I think you want this...

Please Login or Register  to view this content.

[Wolfieee]

Now it's throwing a runtime error with

Please Login or Register  to view this content.

the error says "run-time error'1004': Copy Method of range class failed.

I think I messed something up but I can't see it.

[Wolfieee]

I think I fixed the error but it still doesn't work for me.

Please Login or Register  to view this content.

It copies the data and looks like it adjusting some of the rows but not others. I'm not sure if it's the name range I have highlighted or not. Will have a play around with it a bit more and see. I'm sure it's something I've missed somewhere

[bakerman2]

Try this.

Please Login or Register  to view this content.

The other 2 are the same, only named range changes.

[Wolfieee]

That is exactly what I was looking for!!

Thank you, Thank you Thanks you

I have so much to learn when it comes to VBA.

Only started messing around with it 4 months ago.

[bakerman2]

Glad to help and thanks for rep+.

Update:
Since the code is only repeating we could do like this to avoid that.

Please Login or Register  to view this content.