Thread: Export values range to new spreadsheet

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:

Sub IssueRegister_Rectangle6_Click()
  '
     ' export Macro
     
    Range("C9:L60").Select
    Selection.Copy
    Workbooks.Add
    ActiveSheet.Paste
    ActiveWorkbook.SaveAs Filename:= _
    "C:\Documents and Settings\Issue Register.csv" _
    , FileFormat:=xlCSV, CreateBackup:=False
    Application.DisplayAlerts = False
    ActiveWorkbook.Close
    Application.DisplayAlerts = True
End Sub

Thank you so long,

Jakes

Use a paste special values instead of a paste.

Use

 Activesheet.Pastespecial paste:=xlvalues

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

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

 Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
        :=False, Transpose:=False

it works fine from beginning to end.