how i can do copy table from sheet1 to sheet2 but row.height same as like source..example in sheet1 row(a1).rowheight =33 after copy to sheet2 rowheight in a1 also = 33..how excel can do it ?
how i can do copy table from sheet1 to sheet2 but row.height same as like source..example in sheet1 row(a1).rowheight =33 after copy to sheet2 rowheight in a1 also = 33..how excel can do it ?
Select the range to copy.
Press Shift and Space together.
Copy.
Paste to new range.
step 1 : copy step 2 press shift + space step 3 paste
i can not do jason
IF i press shift + space together cut copy mode become false
Try reading my suggestion again, it's not working for you because you are doing things in the wrong order.
Copy after Shift Space, NOT before
ok thankyou jason its sukses thankyou very match
Last edited by daboho; 01-02-2016 at 07:05 AM.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks