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

 

Not to be obnoxious...
but did you notice the "Subject Line" of these emails?
and the group you posted in?
Subject: [ExcelVBA]...
group email: ExcelVBA@yahoogroups.com

it's not surprising that the solutions suggested were VBA solutions, since this
IS a VBA group!

Then again, I guess I skipped over the first line of your question:
"This is not a VBA-question"

I guess because that's just "crazy talk"... gibberish... does.not.compute...
 
So...
you SAID you want to "Select" the cells from B1 to B(nnnn) where (nnnn) is the
last row with data.
What do you want to do when you "select" it?
The way (*) would do it is similar to the way Lisa and Ashok described:

I would first "Freeze Panes" so that row #1 is always displayed at the top,
then:

Lisa: "End down in column A"
Ashok: Select cell in column A, press "End" and "Down"(arrow)

this will take you to the last cell in column "A" with data.
then:
Lisa: "move over a colum to B"
that means, hit the right arrow ->
Now you're in Column B.
If there are blank cells above your position, the "End" key followed by the "up"
arrow will
take you to the last cell with data in column B.

Next, hold the shift key down and select cell B1

What LISA said was to hit "shift" "ctrl" and "home"
which will select everything from the last cell in B to A1 (selecting both
columns A and B)
then (while still holding the shift key) "move back a col" means hit the right
arrow->

This will select all cells in column B from B1 to the last cell in column B that
contains data.

So.. basically, the answers seem to be saying the same thing,  (just in
programmer-speak).
But to a group of VBA programmers,
there is still an unanswered question:  "why?"

Paul
-----------------------------------------
"Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can." - John Wesley
-----------------------------------------

________________________________
From: Torstein Johnsen <sejohnse@yahoo.no>
To: "ExcelVBA@yahoogroups.com" <ExcelVBA@yahoogroups.com>
Sent: Wed, June 27, 2012 9:45:41 AM
Subject: Vedr: [ExcelVBA] Select range in column with non-continuous data

 
Thanks for your answers.
 
I'm not looking for a VBA-solution - so thats why I think Ashoks solution is the
nearest but............
 
I don't want to select remaining columns, just the middle (non-continous) one.
 
And to Lisa - I can't follow you - "End down in col A and move over (?)  a col
to B and then shft ctrl home and move back a col."
 
Torstein

________________________________
Fra: ashok kumar.s.v <ashokkumarsv@yahoo.com>
Til: "ExcelVBA@yahoogroups.com" <ExcelVBA@yahoogroups.com>
Sendt: Onsdag, 27. juni 2012 12.06
Emne: Re: [ExcelVBA] Select range in column with non-continuous data

 

Hi,
 
    Step 1 :     Select a cell in A column
    Step 2 :      Press End - Down
    Step 3 :      Press Right Arrow to select remaining columns.
 
    Hold Shift Key throughtout the process
 
Regards,
Ashok kumar.S.V

________________________________
From: Torstein Johnsen <mailto:sejohnse%40yahoo.no>
To: "mailto:ExcelVBA%40yahoogroups.com" <mailto:ExcelVBA%40yahoogroups.com>
Sent: Wednesday, June 27, 2012 3:02 PM
Subject: [ExcelVBA] Select range in column with non-continuous data

 
This is not a VBA-question.
 
I hope I can explain it and get some good advice anyway.
 
in a worksheet - 3 columns, about 10000 rows of data.
In column A and C the data are continuous - all cells are filled with data
In column B - some cells are empty.
 
I want to select the range B1.BNNNN (where NNNN is the last row with data), but
it's not possible to use END-DOWN because of the empty cells in that column.

 
Is there any way around?
 
Thanks in advance!
 
Torstein

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

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

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

[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 (9)

Recent Activity:

• New Members 4

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

.

__,_._,___