cant figure out copying

[DSTRU1]

Howdy,

I am using this from Access to select cells
xlSh.Range(Selection, Selection.End(xlDown)).Select

but how do I copy that please?

access excel 2010

thank you in advance


Also posted in Excel forum here: http://www.mrexcel.com/forum/excel-questions/979383-cant-get-copy-figured-out.html

 

[HackSlash]

selection.copy

I recommend using the macro recorder.

Turn the recorder on with the red button
perform the action
press the stop button
look at the code it generated

You can learn a lot this way.

 

[DSTRU1]

Thanks

 

[welshgasman]

I believe you could just .Copy and not have to select?

Range("C1:T" & lLastRow).SpecialCells(xlCellTypeVisible).Copy
    Workbooks.Add
    strNewName = ActiveWorkbook.Name
    With Selection
           .PasteSpecial Paste:=xlPasteValuesAndNumberFormats, Operation:= _
        xlNone, SkipBlanks:=False, Transpose:=False
    End With