VBA macro Copy Paste formula instead of Values only

[Chris van der Berg]

>>> use code - tags <<<

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

 

[vletm]

Chris van der Berg
Have You checked .PasteSpecial ?
... with that, You could select - what do You would like to paste.

 

[Chris van der Berg]

Hi Vietm,
No I have not tried that, will certainly implement your advice.
Thank you

Regards
Chris

 

[Chris van der Berg]

Do I use it instead of "Copy Range"

 

[vletm]

Chris van der Berg
Check eg from here

Best Way To Copy & Paste Special Values Only With VBA

The following two examples of VBA code show you how you can automate copy and pasting values only with an Excel range.

www.thespreadsheetguru.com

 

[Chris van der Berg]

Hi vietm
Thanks for the advice. I followed your suggestion, change my code and it now works 100%

Regards

Chris

 

[Chris van der Berg]

Hi vietm
I need your help again, PLEASE !
I refer to my attached file, sheet Audit_Trail.
I am looking for a VBA code that will only Print the data in my Audit_Trail sheet (Column A:G) and/or ( Column I:M) for the last date or for the period between two dates.
Can you please help or direct me to a article covering this.
Regards

Chris