Selecting Ranges Using VBA

Afternoon all

I have a macro that has automated 95% of a task but one thing is still evading me! If I use the keys then this is what I do:

Select cell C192
Select Shift and R-Arrow so that C192 and D192 are selected
Select Ctrl, Shift and Up Arrow so that C1:D192 are selected
Select Shift and Down Arrow so that C2:D192 are selected

I am sure this is really easy but I just don't know how!! Can anybody help?

Thanks in advance

Matt