Range for a single cell

[michal]

if I have the column number as variable x and the row as variable y
how can I select a cell in column x line y?

I thought : range (x & y).select

but it doesn't work

Thanks

[anilsolipuram]

Cells(2, 3).Select


selects 2nd row and 3rd column

[Trevor Shuttleworth]

Michal

Cells(row, column).Select

Cells(y, x).Select

Regards

Trevor


"michal" <michal.1qsbef_1119035109.9169@excelforum-nospam.com> wrote in
message news:michal.1qsbef_1119035109.9169@excelforum-nospam.com...
>
> if I have the column number as variable x and the row as variable y
> how can I select a cell in column x line y?
>
> I thought : range (x & y).select
>
> but it doesn't work
>
> Thanks
>
>
> --
> michal
> ------------------------------------------------------------------------
> michal's Profile:
> http://www.excelforum.com/member.php...o&userid=24404
> View this thread: http://www.excelforum.com/showthread...hreadid=380193
>