ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Copy and Paste hidden cells? (https://www.excelbanter.com/excel-programming/296079-copy-paste-hidden-cells.html)

Richard[_28_]

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


All times are GMT +1. The time now is 05:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com