Save Selection with VBA?

S

Summer

Hi, can someone tell me if there is a Save Selection VBA (whatever is highlighted) and Save As give doc name way to do this? One can print selection but can one save selection with VBA? Many thanks...
 
T

Tony Jollans

Something like this perhaps (untried) ..

Selectin.copy
with documents.add
.Range.Paste
.Save
.Close false
End With
 
Top