Is it possible to take a range from one worksheet and place it in
another in the same spreadsheet (without copying and pasting)?

For example something similar to this:

-----
Sub test()
Dim rng As Range
Set rng = Worksheets(1).Range("A1", "C4")

Worksheets(2).Range("B1", "D4") = rng
End Sub
-----

I was also wondering how to make 'onKey' work for both Mac and PC.
I've got code running on my Mac in a Personal Macro Workbook as so
(which uses the keystroke Command-Option-Shift-j):

-----
Sub Auto_Open()
Application.OnKey "+%*j", "test"
End Sub
-----

I haven't tested it on a PC but was wondering what the best approach
was if I still want to use the 'Command' button on a Mac. I'm using
Mac OS 10.3 and 10.4 with Excel 98 and Excel 2004.

Thanks.

Jay


--
jayy
------------------------------------------------------------------------
jayy's Profile: http://www.excelforum.com/member.php...o&userid=33975
View this thread: http://www.excelforum.com/showthread...hreadid=537494