tonywatsonhelp
Well-known Member
- Joined
- Feb 24, 2014
- Messages
- 3,194
- Office Version
- 365
- 2019
- 2016
- Platform
- Windows
Hi Everyone,
Im wondering if its possible to copy a range, then delete data that feeds that range and still paste the data I copied.
if it worked heres what I would like to do:
Orders1 is formulas linked to Invoice, so when I clear it I get an error trying to paste. please help
Thanks
Thanks
Tony
Im wondering if its possible to copy a range, then delete data that feeds that range and still paste the data I copied.
if it worked heres what I would like to do:
Code:
Sub copytest1()
Sheets("Orders1").Range("AI24:AR38").SpecialCells(xlCellTypeVisible).Copy
Sheets("Invoice").Range("A2:N33").ClearContents
Sheets("Sheet3").Range("A4").PasteSpecial xlPasteValues
End Sub
Thanks
Thanks
Tony