Highlight from given cell to end of list

[adam2308]

How do i highlight from given cell (A3) to end the of the list in that column without giving a specific range?

[sweep]

Hi,

One way is:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

[adam2308]

thank you - could you also tell how i write the code to find the next empty cell in column?

[sweep]

Yup,

you could do it like this:

Please Login or Register  to view this content.

[excelkeechak]

by the way what does the code actually mean.
.Range(Range("A3"), Range("A3").End(xlDown)).Select

[sweep]

Please Login or Register  to view this content.

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.

So,

Please Login or Register  to view this content.

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 Cell1