Hello!

I would like to create macro which is doing following. Selects for example C3 cell then does shift+cntrl+down (xlDown, if i understand right) and then counts off last 3 rows.
So I get whole rows in C column except last 3 ones. And i can format them further.

as I understand i have to make some kind of variable and use something like
Set x = C3.End(xlDown)
but i have not a single idea about syntax and such things, I am newbie in VB code.

Any help would be realy appreciated.
Thank You!