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
Microsoft Excel
Last Comment
Norie
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
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
What do ou want to copy and where do you want to copy it to?