Corey, this is out of the VBA Help file:

Worksheets("Sheet1").Activate
ActiveCell.Offset(rowOffset:=3, columnOffset:=3).Activate

This is the same thing in a tighter form:

Worksheets(1).Activate
ActiveCell.Offset(3, 3).Activate

You can find more info in the VBA Help file by typing Offset in the search
boxEnter and select "Offset Property".


"Corey" wrote:

I have posted a few times without response, abut am in need of a method using the offset(x, x) code.
I have never delt with this type of code before and so cannot workout how to start it.
Do i need to set a target cell somehow, to start with so i can offset cells from it ?

Can anyone assist me in this please?

Corey....