Copy and Paste hidden cells?

R

Richard

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
 
Top