Copy variably sized range and paste values in another sheet

Hi there,

I have had great help here before and got the code to copy a varibly sized range in one sheet ("Indata") and then to paste it in another sheet("GrundData") on the first empty row. The code for this is:

Please Login or Register  to view this content.

I have a problem though, if there are formulas in sheet "Indata", they are pasted in like formulas in sheet "GrundData". I need it to be pasted like values.

Hope someone can help me to change my code so there only will be values in sheet "GrundData".

/Masun

Hi Norie,

Thank so much for trying to help me!

Something strange happens when I run your code. I dont know why but columns H:P gets empty.

Hope you can take the time to help me here, if so... I assume its easier if you can see the file so I´ve uploaded it.

Masun

Hi again,

I probably expressed my self poorly. My bad. I did it so you could see the entire process.

If you copy sheet "Data with formulas" and paste it in "Indata" you will see.

/Masun

Hi again,

Eith the influence from your code, Norie, I added .PasteSpecial xlPasteValues to my original code and that worked.

Thanks.


/Masun