LinkBack URL
About LinkBacks
How do i highlight from given cell (A3) to end the of the list in that column without giving a specific range?
How do i highlight from given cell (A3) to end the of the list in that column without giving a specific range?
Last edited by adam2308; 04-28-2009 at 07:21 AM.
Hi,
One way is:
or
Range(Range("A3"), Range("A3").End(xlDown)).Select
Range(Cells(3,1), Cells(3,1).End(xlDown)).Select
Last edited by sweep; 04-28-2009 at 06:26 AM. Reason: Added code tags
Rule 1: Never merge cells
Rule 2: See rule 1
"Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".
thank you - could you also tell how i write the code to find the next empty cell in column?
Yup,
you could do it like this:
Cells(1,1).End(xlDown).Offset(1, 0).Select
by the way what does the code actually mean.
.Range(Range("A3"), Range("A3").End(xlDown)).Select
has the same effect as clicking on Cell1, and dragging to Cell2 so that all cells between are selected.Range(Cell1, Cell2).Select
has the same effect as clicking on Cell2 , and then pressing the "End" key followed by the cursor "down" key.Cell2.End(xlDown)
So,
Is the same as selecting cell 1, holding shift, and then pressing the "End" key followed by the cursor "down" key, therefore selecting all the continuous populated cells below Cell1Range(Cell1, Cell1.End(xlDown)).Select
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks