Hi all

i am having row number and column number (for example row = 4 and column =
20), pls tell me the method or syntax to select the cell (row = 4 and column
= 20)
I have used Range("row:col").select, but it is not working.

second one is how to store the Activecell content
I have used the follwing code for the same
Dim Ac1 As Application
Ac1.Activecell = Activecell.Offset(0,10).Range("A1")

But it is also not working
Pls help me

Cells(4, 20).Select
--
Gary''s Student - gsnu200797

Try this

rRow = 4
rColumn = 20
Cells(rRow, rColumn).Select

or
Cells(4, 20).Select

I'm not entirely sure by what you mean for the second part of the question
but maybe this

myvalue = ActiveCell.Value
myvalue1 = ActiveCell.Offset(1, 2).Value

Mike

"Nesara" wrote:

> Hi all
>
> i am having row number and column number (for example row = 4 and column =
> 20), pls tell me the method or syntax to select the cell (row = 4 and column
> = 20)
> I have used Range("row:col").select, but it is not working.
>
> second one is how to store the Activecell content
> I have used the follwing code for the same
> Dim Ac1 As Application
> Ac1.Activecell = Activecell.Offset(0,10).Range("A1")
>
> But it is also not working
> Pls help me

Thank you .

"Gary''s Student" wrote:

> Cells(4, 20).Select
> --
> Gary''s Student - gsnu200797

Thank you for the solution.

"Mike H" wrote:

> Try this
>
> rRow = 4
> rColumn = 20
> Cells(rRow, rColumn).Select
>
> or
> Cells(4, 20).Select
>
> I'm not entirely sure by what you mean for the second part of the question
> but maybe this
>
> myvalue = ActiveCell.Value
> myvalue1 = ActiveCell.Offset(1, 2).Value
>
> Mike
>
> "Nesara" wrote:
>
> > Hi all
> >
> > i am having row number and column number (for example row = 4 and column =
> > 20), pls tell me the method or syntax to select the cell (row = 4 and column
> > = 20)
> > I have used Range("row:col").select, but it is not working.
> >
> > second one is how to store the Activecell content
> > I have used the follwing code for the same
> > Dim Ac1 As Application
> > Ac1.Activecell = Activecell.Offset(0,10).Range("A1")
> >
> > But it is also not working
> > Pls help me