Copy??

[G Lam]

Hi, I want to copy a range, named "OrigRng" in a spread sheet in another
workbook to the currect worksheet in VBA or Macro. How can I do it?
Thank you.
GL

 

[Mark]

Hi,
Select the range to copy from the source workbook and
click Copy Button. select the workbook target CELL (not
range of cells) and the click paste.

If you need a macro done, let me know.

(e-mail address removed)

i will need to know the source workbook name and the
target workbook name. If I am feeling clever, I'd really
only need to know the range name ...which is "OrigRng" as
it will only exist in one workbook, possibly....


- - Mark

http://www.geocities.com/excelmarksway

 

[G Lam]

Mark,
Thank you for your reply. Yes, I want to do this by Marco or vba. The
workbook name is LookUpMstr and the range name OrigRng is a unique name.
What I want to do is to copy this range from LookUpMstr!MstrSheet (in
server) to the workstations using macro or VBA. So, users can just use CTRL
+ (key) to copy. The target workbook/worksheet name is SoEnt!Sheet1.
It would be nice, if they don't even need to open the LookUpMstr workbook to
do so.
Thank you.
GL