Copy??

G

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
 
M

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.

[email protected]

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

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
 
Top