[dba-Tech] Moving in an Excel worksheet, programmatically

Will you know what row and column the focus is currently on?  If so you can do something like

Worksheets("Sheet1").Cells(lngRow + 1,lngCol).select

where lngRow= the number of the current row and lngCol is the current column number.

If you are wanting to grab the value of the cell:

x=Worksheets("Sheet1").Cells(lngRow + 1,lngCol).value


HTH


----- Original Message ----
From: Susan Harkins <ssharkins at gmail.com>
To: DBA Tech List <dba-tech at databaseadvisors.com>
Sent: Friday, July 25, 2008 11:33:04 AM
Subject: [dba-Tech] Moving in an Excel worksheet, programmatically

I'm trying to move around in an Excel worksheet from inside Outlook. It's a simple look and all I want to do is move down one row, but I can't figure it out. I tried everything that seemed obvious and I've checked the language reference for an appropriate method, but I'm just not finding it. Surely I don't have to use Offset! It should be as simple as GoTo NextRow, but I'm not finding anything like that. 

Susan H. 
_______________________________________________
dba-Tech mailing list
dba-Tech at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/dba-tech
Website: http://www.databaseadvisors.com