Selecting from point X to end, and sliding ActiveCell over or down

I'm really sorry to keep bothering this board, but I'm trying to get all my basics down and finish up this project! I have two last issues, and I'm sure they're both simple for those of you who knows this language well.

1) Is there a way I can easily select a range from the active cell until the end of that column or row. For instance, instead of:

Please Login or Register  to view this content.

which would select the entirety of columns B through H, can I select all of columns B through H only from the active cell's row and downward?

2) And lastly and this is really basic, I want to change the formatting of a cell two rows below the active cell, and then I want to change the text of a cell one column to the left of the new active cell. The problem? The exact location of these cells fluctuates with each time I run the script. How can I refer to a position that is two rows below the active cell, regardless of where that active cell might actually be? And in case it's not entirely intuitive, how can I refer to a position that is one row to the left of the new active cell?

Thanks again!