Europa MacDonald
asked on
Excel multiple selection problem
I am trying to copy data from a spreadsheet
I keep getting the error message
"the command you chose cannot be performed with multiple selections. Select a single range and click the command again"
Can anyone explain why this is happening and how to get around it ?
the data is composed of some text formatted cells and some number formatted cells
I keep getting the error message
"the command you chose cannot be performed with multiple selections. Select a single range and click the command again"
Can anyone explain why this is happening and how to get around it ?
the data is composed of some text formatted cells and some number formatted cells
Can you show the relevant code?
ASKER
I have attached a file
data1.xls
data1.xls
ASKER
this is the error
data1.JPG
data1.JPG
You should not get this message if you select the data in a single rectangular block. Multiple selections do not work for some situations.
ASKER
I know that it works for single blocks, but I am trying to pick data out of a list
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
What do ou want to copy and where do you want to copy it to?