![]() |
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