retrieve Active cell "Name" vbscript
 

I'm not sure if this is the right group or not,

I have a vbscript that opens and excel spreadsheet and does some work on it.

I need to be able to add a formula to a cell like "=A1+A2" , but I need to
know which cell I am in in order to add the formula

I know objXL.activeSheet.Range("A1").activate will point me to cell "A1".
then I move down through the sheet. using
objXL.activecell.offset(1,0).activate which moves me down a row,

what I really need is a way to find out "where I am" after the script moves.

is there a function that will return "B1" when I'm on the second row?

retrieve Active cell "Name" vbscript
 

"Lee" wrote in message
...
I'm not sure if this is the right group or not,

I have a vbscript that opens and excel spreadsheet and does some work on
it.

I need to be able to add a formula to a cell like "=A1+A2" , but I need to
know which cell I am in in order to add the formula

I know objXL.activeSheet.Range("A1").activate will point me to cell
"A1".
then I move down through the sheet. using
objXL.activecell.offset(1,0).activate which moves me down a row,

what I really need is a way to find out "where I am" after the script
moves.

is there a function that will return "B1" when I'm on the second row?


If I recall correctly then objExcel.ActiveCell.Address will return the
current cell address.

retrieve Active cell "Name" vbscript
 

ActiveCell refers to the current active cell, wherever it might be.
ActiveCell.Address returns a string containing the address of the
ActiveCell.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

On Thu, 19 Feb 2009 10:24:17 -0500, "Lee"
wrote:

I'm not sure if this is the right group or not,

I have a vbscript that opens and excel spreadsheet and does some work on it.

I need to be able to add a formula to a cell like "=A1+A2" , but I need to
know which cell I am in in order to add the formula

I know objXL.activeSheet.Range("A1").activate will point me to cell "A1".
then I move down through the sheet. using
objXL.activecell.offset(1,0).activate which moves me down a row,

what I really need is a way to find out "where I am" after the script moves.

is there a function that will return "B1" when I'm on the second row?

retrieve Active cell "Name" vbscript
 

perfect.
thanks..

I

"Pegasus (MVP)" wrote in message
...

"Lee" wrote in message
...
I'm not sure if this is the right group or not,

I have a vbscript that opens and excel spreadsheet and does some work on
it.

I need to be able to add a formula to a cell like "=A1+A2" , but I need
to know which cell I am in in order to add the formula

I know objXL.activeSheet.Range("A1").activate will point me to cell
"A1".
then I move down through the sheet. using
objXL.activecell.offset(1,0).activate which moves me down a row,

what I really need is a way to find out "where I am" after the script
moves.

is there a function that will return "B1" when I'm on the second row?


If I recall correctly then objExcel.ActiveCell.Address will return the
current cell address.