Select large non-contiguous range

**kellywa** · 11-22-2008, 04:41 PM

I have two non-adjacent columns with 7620 items in each. How can I select columns this long faster than scrolling down 7620 rows while holding the shift key? Is there a way to just specify the range of each column, using

Code:

(a1:a7620, g1:g7620)

for example to do a scatter plot?

**shg** · 11-22-2008, 05:17 PM

Select A1, Ctrl+Shift+Down, hold down the Ctrl key, select G1, Ctrl+Shift+Down

I've edited your thread title. Please take a few minutes to read the Forum Rules about thread titles before starting your next thread.

**kellywa** · 11-22-2008, 09:55 PM

shg,

Thank you very much! I just registered today and that was my very first thread. I was very excited to get a reply back so soon. I can see why the thread title is better with your editing. I had read the rules on titles but I'm sure will learn a lot from those who have done this more.

Best regards,

kellywa

**solnajeff** · 11-22-2008, 11:27 PM

HI

You could code it in VBA with something like the following

Code:

Sub select_noncontig()

Range("a1:a7620,g1:g7620").Select

End Sub

To use the code it must be placed in A module in the VBE, press Alt + F11 to bring up the Visual Basic Editor , right click anywhere in the VBAProject for the relevant workbook and select Insert/Module. The code can now be pasted into the module.

To simplify things you could assign a shortcut key

Press Alt + F8 to bring up the macro dialog
Select the macro
Click on options
Then enter whatever letter suits you and click OK
Close the macro dialog and press Ctrl + the designated letter, the macro should now execute.

If this is a bit unclear I will explain in more detail.

Regards

Jeff

**shg** · 11-23-2008, 01:11 AM

You're welcome.

Would you please mark the thread as solved?

------------------------------------------------

To mark a thread as solved:

Click the Edit button on your first post in the thread

Click Go Advanced, select [SOLVED] from the Prefix dropdown, then click Save Changes

If more than two days have elapsed since your first post, ask a moderator to mark it.

Thread: Select large non-contiguous range

Thread Tools

Display

Select large non-contiguous range

Selecting Non contiguous range

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions