View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Richard[_28_] Richard[_28_] is offline
external usenet poster
 
Posts: 6
Default 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