redspanna
Well-known Member
- Joined
- Jul 27, 2005
- Messages
- 1,602
- Office Version
- 365
- Platform
- Windows
Hi all
I'm using this bit of code found online to copy/paste a certain filtered row into another sheet.
How to change the code so thaat it pastes the copied VALUES?
Thanks in advance
I'm using this bit of code found online to copy/paste a certain filtered row into another sheet.
How to change the code so thaat it pastes the copied VALUES?
VBA Code:
[/B]
Set copyRange = src.Range("G2:G" & lastRow)
copyRange.SpecialCells(xlCellTypeVisible).Copy tgt.Range("S3")
[B]
Thanks in advance