Chris van der Berg
Member
>>> use code - tags <<<
My problem is that when I run the macro it copy paste the formula's to AA1 aswell. I only need it to copy the values.
Thanks
Chris
Code:
Sub CopyPaste()
'Declares Varibles
Dim copyRange As Range, pasteRange As Range
'Sets where were are coping from
Sheets("Product").Select
Set copyRange = Range("A1:H51").CurrentRegion
'Filter for anything over 0
Range("G1:G51").AutoFilter field:=1, Criteria1:=">0"
'Copy only filtered rows and paste in AA1
copyRange.SpecialCells(xlCellTypeVisible).Copy Range("AA1")
'Turn off filter
ActiveSheet.AutoFilterMode = False
End Sub
My problem is that when I run the macro it copy paste the formula's to AA1 aswell. I only need it to copy the values.
Thanks
Chris
Attachments
Last edited by a moderator: