Help with a VBA code to paste only values from a Web Query

Hello guys!

I am new to Excel and this forum. I have been reading a lot and trying my best to write a code but I honestly have no clue at all of what I am doing.

By reading this forum and others, I used a posted code to help me out copying web query data from sheet2 to sheet1. Then a friend help me out to modified the code in order to Copy it to a new row in Sheet1 instead of a new column. The code works perfectly but I really wish that when the data is copied from Sheet2 to Sheet1 it will be only Values in order to keep my formulas and formats.

I read about .PasteSpecial xlPasteValues but I don't seem to find where exactly I should write it within the code. Here is my code:

Please Login or Register  to view this content.

I really appreciate your help. I have been working on this for days now. I know it is something simple if I knew how to code.

Thanks!

hello guys

It's been a while and I still haven't been able to make it work. Any help is very appreciate.