Export values range to new spreadsheet

[Jakes]

Hi there,

I want a certain range to be exported to a new spreadheet with a macro (the range can be fixed range OR can be selected)

I have the following,and does work, but the problem is many of the values I am exporting are vlookup values, and then when exporting, it export the vlookup string instead of the value in the cell.
How can I export only the values to a new spreadsheet?

Here is what I have:

Please Login or Register  to view this content.

Thank you so long,

Jakes

[arlu1201]

Use a paste special values instead of a paste.

[Jakes]

Thank you for the reply,
I have changed ActiveSheet.Paste to ActiveSheet.PasteSpecial, and it does the same as before, except now I also get an error "Cannot access read-only document Issue Register.csv"

[Jakes]

Thank you for the reply,
I have changed ActiveSheet.Paste to ActiveSheet.PasteSpecial, and it does the same as before, except now I also get an error "Cannot access read-only document Issue Register.csv"

[arlu1201]

Use

Please Login or Register  to view this content.

I fail to understand why its saving your file as read-only.

[Jakes]

Hi Arlu,

Thank you, I have replaced the ActiveSheet.PasteSpecial with your code, and get the error Application defined or object defined error. When debugging, it takes me to your code. Any idea why?

[arlu1201]

I tried your code and changed my earlier code line to this -

Please Login or Register  to view this content.

it works fine from beginning to end.

[Jakes]

Thank you that did the trick!