Activecell is the currenlty active cell. to make a cell the activecell

Range("B9").Active - this does not change the selection if B9 is within the
current selection - it just activates B9 within the select. Otherwise, it
selects B9

Range("B9").Select - B9 is now both the activecell and the current
selection.

This is done on that activesheet. If you want to go to another sheet,
activate that sheet first

Worksheets("Sheet2").Activate

Range("B9").Select

--
Regards,
Tom Ogilvy


"Christian Blackburn" wrote:

Hi Gang,

I would like to programmatically advance to a specific cell. Can
someone reply with an example?

Thanks,
Christian Blackburn