Copy and Paste hidden cells?
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
|