Prev: Choose which cell to paste data
Next: WordMerge
From: MikeF on 8 May 2010 14:48

Have a subroutine that copies a sheet from one workbook to the other, then
copies values, formats, and column widths.

But need it also to copy the row heights/hidden rows.

Any assistance will be sincerely appreciated.
Thanx.
- Mike
From: CLR on 8 May 2010 15:32
Maybe someting in here will help.

Sub CopyRowHeights()
Rows("1:20").Select
Selection.Copy
Windows("Book2").Activate
Rows("1:20").Select
Selection.PasteSpecial Paste:=xlFormats, Operation:=xlNone, SkipBlanks:=
_
False, Transpose:=False
Application.CutCopyMode = False
End Sub

Vaya con Dios,
Chuck, CABGx3




"MikeF" <MikeF(a)discussions.microsoft.com> wrote in message
news:A13BA0DE-87B6-460C-814E-E46E2DC0CAA2(a)microsoft.com...
>
> Have a subroutine that copies a sheet from one workbook to the other, then
> copies values, formats, and column widths.
>
> But need it also to copy the row heights/hidden rows.
>
> Any assistance will be sincerely appreciated.
> Thanx.
> - Mike


From: GS on 9 May 2010 07:45
MikeF presented the following explanation :
> Have a subroutine that copies a sheet from one workbook to the other, then
> copies values, formats, and column widths.
>
> But need it also to copy the row heights/hidden rows.
>
> Any assistance will be sincerely appreciated.
> Thanx.
> - Mike

If you are copying a sheet, whether to another workbook OR within the
same workbook, everything copies. Are you saying that your copy
procedure strips some stuff away? It would help if you post your code.
AFAIK, the only thing you should lose is some content of cells with
more than 1024 characters. Otherwise, the copied sheet should be
identical to the original.

Garry


 | 
Pages: 1
Prev: Choose which cell to paste data
Next: WordMerge