ExcelBanter - Select copy

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Select copy (https://www.excelbanter.com/excel-discussion-misc-queries/974-select-copy.html)

Jeff

Select copy

Hi,

With VBA, how can I do a selection.copy of a range ?
This is the range in question:
Dim myrng As Range
Set myrng = Workbooks("Invoices OCT-04.xls").Worksheets("B").Range("a1:b5")
Thanks,

Peo Sjoblom

myrng.Copy

Regards,

Peo Sjoblom

"Jeff" wrote:

Hi,

With VBA, how can I do a selection.copy of a range ?
This is the range in question:
Dim myrng As Range
Set myrng = Workbooks("Invoices OCT-04.xls").Worksheets("B").Range("a1:b5")
Thanks,

All times are GMT +1. The time now is 06:37 AM.