Relative cell reference selecting enitre row and entire column?

Hi all,

I literally started learning VBA 3 hrs ago, using one of the links from the sticky thread, but as I'm trying to be thorough I started to make a "dictionary" and I'm writing up the different selections that are possible.

Attached a picture of them, as I couldn't insert the code here. I kept being blocked by the website fire wall (??)

I have tested them 1 by 1 by just removing the ' from the start, and they all work so far as their description, but I can't do the code for the last one. Is it even possible or does excel get confused by it?

Could someone send me a working code for: Select entire Row AND entire Column, 1 Row down AND 1 Column to the right from the reference cell A1 , and explain a bit, why

---ActiveCell.Offset(1, 1).Range("1:1, A:A").Select--- doesn't work (application defined or object defined error), and how does their code work?

Thank you very much for the help!!