how to copy a portion of a sheet?

[sumesh56]

I want to copy a portion of a sheet to another part of the same sheet. pls see the attached file. I want to copy and paste from A1:G11. When I select A1:G11 and paste the format is lost,the row height is lost and the shape is lost. When i select row A1:A11 and paste I do get all . But this is not accetable since there may be some data after the G column and I don't want to copy these cols. kindly help

[FDibbins]

If you select the range down 1 row further (to row 12), then copy, it pulls in the shapes, but still does not set the row heights

[Alf]

Just to see if I could solve this problem I've written a macro that do copy everything, row height and arrows. To test run macro "CopyRow"

The good: It works

The bad: As the copy to is specified to range A14 the usfullness of this macro is rather limited.

Alf

[Alf]

Made some modefication to the code and you can now run it a number of times. Each time the macro is run it will copy the range "A1:G11" to an A range two rows below the last row in the A range and then adjust the row hight to correspond with the one found in range A1 to A11.

I.e. first run place table in range "A14:G24", next time macro is run it places table in range "A26:G37" and so forth.

Please Login or Register  to view this content.

Alf

[sumesh56]

thanks for the response. but I don't want to use the macro. somethingelse pls to solve the issue. (the range to copy is not permanent.)

Made some modefication to the code and you can now run it a number of times. Each time the macro is run it will copy the range "A1:G11" to an A range two rows below the last row in the A range and then adjust the row hight to correspond with the one found in range A1 to A11.

I.e. first run place table in range "A14:G24", next time macro is run it places table in range "A26:G37" and so forth.

Please Login or Register  to view this content.

Alf

[Alf]

Well if you copy range "A1:G11" and selct say cell A14 and just use the "Paste" command you get immages and everything else except for row hight, to fix this you select the rows in the pasted range and go to home tab -> Cell -> Formate and manually set the propper row hight.

Or you can set the particular row hight as a default value for all sheets, or a specified number of rows on a sheet then you don't need to adjust row height after pasting.

Alf

[sumesh56]

thanks for the response.but nothing new in this suggestion. pls see my initial post.

Well if you copy range "A1:G11" and selct say cell A14 and just use the "Paste" command you get immages and everything else except for row hight, to fix this you select the rows in the pasted range and go to home tab -> Cell -> Formate and manually set the propper row hight.

Or you can set the particular row hight as a default value for all sheets, or a specified number of rows on a sheet then you don't need to adjust row height after pasting.

Alf