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