Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
A problem with cells name in a copy/paste process
I need to copy a range of data from one book (A) to other (B). Both books
have cells with the same name and the range of data is referenced to these cells in book A. When I copy and paste the range of data in book B appears a Dialog Box that ask me if I want to use the version of the name in book B and I have to say yes. The problem is that I do the copy / paste process with macros but the dialog box always appears and I would like to €śsay yes in the dialog box€ť automatically but I cant. Someone can to help my? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
A problem with cells name in a copy/paste process
Try something like this:
Workbooks("BookA").Sheets(1).Range("test").Copy _ Workbooks("BookB").Sheets(1).Range("test") RBS "LRAF" wrote in message ... I need to copy a range of data from one book (A) to other (B). Both books have cells with the same name and the range of data is referenced to these cells in book A. When I copy and paste the range of data in book B appears a Dialog Box that ask me if I want to use the version of the name in book B and I have to say yes. The problem is that I do the copy / paste process with macros but the dialog box always appears and I would like to €śsay yes in the dialog box€ť automatically but I cant. Someone can to help my? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How can I copy big ranges of cells without drag or copy/paste? | Excel Discussion (Misc queries) | |||
Copy and paste versus copy and insert copied cells | New Users to Excel | |||
Copy and Paste Problem | Excel Discussion (Misc queries) | |||
Copy/Paste how to avoid the copy of formula cells w/o calc values | Excel Discussion (Misc queries) | |||
Excel cut/Paste Problem: Year changes after data is copy and paste | Excel Discussion (Misc queries) |