Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Excel 2000 - Select

  Asked By: Egidius    Date: Oct 02    Category: MS Office    Views: 702
  

This is a bit related to my other 2 recent questions here but
I'm leaving those up in case anyone gives a direct answer.

Can someone tell me the best VBA way to .Select a cell in a sheet if I
have a row *number* and column *number* please?

Share: 

 

2 Answers Found

 
Answer #1    Answered By: Kanchan Ap     Answered On: Oct 02

Cells(r,c).select

r being the row number and c the column number.

and to select  a range use:
Range(cells(r1,c1),cells(r2,c2)).select

 
Answer #2    Answered By: Haya Yoshida     Answered On: Oct 02

--------------------
cells(i,j).select
--------------------
i= row number
j= column number

 
Didn't find what you were looking for? Find more on Excel 2000 - Select Or get search suggestion and latest updates.




Tagged: