Goto a specific Cell

  • Thread starter Thread starter Sanjay
  • Start date Start date
S

Sanjay

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.
 
If ? I understand your request

cells(activecell.row,"d").select
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Executing Part Of Macro Only On Cells Meeting A Condition 2
Error 13 Type Mismatch 4
Selection.AutoFilter Issue 1
Find and loop help-multiple columns 3
Dynamic Offset from an Application.Goto cell = Date or Time 10
Query then pivot table 6
Modules not being deleted 10
Code to Concat a row in loop 2

Back
Top