Hello!
What is the quickest way to select non-adjacent cells?
Lets say I want to select A2,B2,C2,D2 and then A4,B4,C4,D4 and then A6,B6,C6,D6. The adjacent cells in row 2 can be easily selected with "Shift", but then I have to manually select the remaining cells with "Ctrl". Is there a quicker way to employ the keyboard and the mouse to select the mentioned cells?
Thank you for your time,
excelactuary
Don't think so.
But why do you have to select them?
Using Macro code you can.......
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
I want to do this, so that I can copy data in a certain range to a another worksheet. Or to delete custom entries.Originally Posted by Pepe Le Mokko
Maybe if you provide some more details, we can help you better. You can even attach a sample file. You will get much faster responses.
If I have helped, Don't forget to add to my reputation (click on the star below the post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Use code tags when posting your VBA code: [code] Your code here [/code]
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks