Goto a specific Cell
 

Hi,

I have the row number of the activecell, and also the column number from a
range

via:

Activecell.row
range("myrange").column 'may be moved

what I would like to do is goto that corresponding cell i.e.

if the user is on row 40 and myrange is D then goto D40


Any help appreciated!

Thanks.

Goto a specific Cell
 

If ? I understand your request

cells(activecell.row,"d").select


--
Don Guillett
SalesAid Software

"Sanjay" wrote in message
...
Hi,

I have the row number of the activecell, and also the column number from a
range

via:

Activecell.row
range("myrange").column 'may be moved

what I would like to do is goto that corresponding cell i.e.

if the user is on row 40 and myrange is D then goto D40


Any help appreciated!

Thanks.

Goto a specific Cell
 

Cells(activecell.row,myrange.column).Select

--
Regards,
Tom Ogilvy


"Sanjay" wrote:

Hi,

I have the row number of the activecell, and also the column number from a
range

via:

Activecell.row
range("myrange").column 'may be moved

what I would like to do is goto that corresponding cell i.e.

if the user is on row 40 and myrange is D then goto D40


Any help appreciated!

Thanks.