ExcelBanter - To copy from a range in another sheet to the active cell

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - To copy from a range in another sheet to the active cell (https://www.excelbanter.com/excel-programming/339476-copy-range-another-sheet-active-cell.html)

Raja

To copy from a range in another sheet to the active cell

Sheets("sheet3").Range("A1:A3").Copy Destination:=ActiveCell

is not working

William Benson[_2_]

To copy from a range in another sheet to the active cell

works for me, unless my activecell is row 65534.

"raja" wrote in message
...
Sheets("sheet3").Range("A1:A3").Copy Destination:=ActiveCell

is not working

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