Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
How can I Copy and Paste hidden cells? I have had problems with the following code not pasting
hidden cells: With Worksheets(intSheet) ' copy the template field .Range(strCopyRange).Copy ' paste it on all sheets .Paste Destination:=Worksheets(intSheet).Cells(lastRow + intField, "A") .Cells(lastRow + intField, 1).Value = Me.Controls("Textbox" & intField).Text End With Should I use a ".Range(strCopyRange).Hidden = False before the copy, and return it to Hidden after copying it? Thanks, Richard |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Disabling copy/paste hidden cells | Excel Worksheet Functions | |||
Copy and Paste with hidden columns remaining hidden | Excel Discussion (Misc queries) | |||
copy and paste range of cells excluding hidden data in excel | Excel Discussion (Misc queries) | |||
copy/paste with hidden rows don't want hidden parts to paste | Excel Discussion (Misc queries) | |||
Excel: copy and paste only shown not hidden cells into new sheet | Excel Discussion (Misc queries) |