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
Please Login or Register to view this content.
Please Login or Register to view this content.
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:
Please Login or Register to view this content.
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.Please Login or Register to view this content.
has the same effect as clicking on Cell2 , and then pressing the "End" key followed by the cursor "down" key.Please Login or Register to view this content.
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 Cell1Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks