Paste Special CSV

[ShelleyBelly]

Hello all,

I have the following bit of code which was recorded in the macro recorder and which works fine.

Range("M36").Select
ActiveSheet.PasteSpecial Format:="Csv", Link:=False, DisplayAsIcon:=False

I would like to reduce it to the below however i get "Compile error: Named arugument not found" when i do this, does anyone have any suggestions?

Range("M36").PasteSpecial Format:="Csv", Link:=False, DisplayAsIcon:=False

Many Thanks

Tom

 

[Anthony47]

PasteSpecial has a behaviour different if applied to a Worksheet or a to Range; check vba help on line.
The syntax you wish to use is wrong and cannot be used.
Bye

 

[mole999]

FLUFFs answer here > https://www.mrexcel.com/forum/excel...select-here-columns-not-filling-expected.html in post 9 might explain

 

[Anthony47]

Hummm... I miss the relevance of the linked post in this context...