• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1307
  • Last Modified:

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
0
Europa MacDonald
Asked:
Europa MacDonald
1 Solution
 
Martin LissOlder than dirtCommented:
Can you show the relevant code?
0
 
Europa MacDonaldChief slayer of dragonsAuthor Commented:
I have attached a file
data1.xls
0
 
Europa MacDonaldChief slayer of dragonsAuthor Commented:
this is the error
data1.JPG
0
Cloud Class® Course: Amazon Web Services - Basic

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

 
Saqib Husain, SyedEngineerCommented:
You should not get this message if you select the data in a single rectangular block. Multiple selections do not work for some situations.
0
 
Europa MacDonaldChief slayer of dragonsAuthor Commented:
I know that it works for single blocks, but I am trying to pick data out of a list
0
 
Saqib Husain, SyedEngineerCommented:
In that case you ought to go one-by-one.
0
 
NorieVBA ExpertCommented:
What do ou want to copy and where do you want to copy it to?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now