Re: Vedr: [ExcelVBA] Select range in column with non-continuous data

 

Hey Torstein,

LOL!!!

Apols if I wasn't too clear... here's another go.

Ctrl + Home to go to A1.... or select start of data cell in A.
End, then Down Arrow to go to the end of the data in A
Right Arrow to go to the correct column.. B?
Ctrl + Shift + Home to select everything from that cell to A1
While keeping the Shift held down to keep selecting "mode"... Right arrow to unselect columns you don't want... A?

HTH
Lisa

Sent: Wed, Jun 27, 2012 3:45 pm
Subject: Vedr: [ExcelVBA] Select range in column with non-continuous data

Thanks for your answers.

'm not looking for a VBA-solution - so thats why I think Ashoks solution is the
earest but............

don't want to select remaining columns, just the middle (non-continous) one.

nd to Lisa - I can't follow you - "End down in col A and move over (?) a col
o B and then shft ctrl home and move back a col."

orstein

[Non-text portions of this message have been removed]

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (10)

Recent Activity:

• New Members 5

Visit Your Group

----------------------------------
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.

----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA

----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com

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

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___