Simple question

[kiltubber]

I am trying to get a little macro to select a 4 X 4 range of cells just below the active cell. I am trying to use activecell.offset but I am just missing somthing, I am not doing it right.
Please advise,
Thanks,
John.

 

[Richie(UK)]

Hi John,

Try this:

Sub offsettest()
Range(ActiveCell.Offset(1, 0), ActiveCell.Offset(4, 3)).Select
End Sub

Remember that often you don't actually need to select a range when performing an action on it (and it is quicker not to).

HTH

 

[kiltubber]

Thanks rich, got it to work for me.

Best regards,
John