Correct VBA syntax

What is the correct vba syntax to use to make a particular cell the active
cell when the row number and column number are known?

One way:

ActiveSheet.Cells(rownum, colnum).Activate



In article <4B2CDF46-FE67-495A-970A-E42327464249@microsoft.com>,
Ken G. <KenG@discussions.microsoft.com> wrote:

> What is the correct vba syntax to use to make a particular cell the active
> cell when the row number and column number are known?

If the current cell is known (even if you do not know where that is) and you
want to know the value of a cell 2 columns over and 5 rows down then

activecell.offset(0,0).select

msgbox activecell.offset(5,2) .value,vbinformation, "Offset Manager"


- - Mark


"Ken G." wrote:

> What is the correct vba syntax to use to make a particular cell the active
> cell when the row number and column number are known?

Thanks for this. I'm trying to get the active cell to remain the same when
enter is pressed, but in a protected sheet it jumps to the next unprotected
cell. I thought I may have been able to do it with your response below but I
can't get it to work. Can you help with a macro to do this?

"JE McGimpsey" wrote:

> One way:
>
> ActiveSheet.Cells(rownum, colnum).Activate
>
>
>
> In article <4B2CDF46-FE67-495A-970A-E42327464249@microsoft.com>,
> Ken G. <KenG@discussions.microsoft.com> wrote:
>
> > What is the correct vba syntax to use to make a particular cell the active
> > cell when the row number and column number are known?
>