| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming,microsoft.public.scripting.vbscript
|
|||
|
|||
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? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Highlighting the active cell during "Find" | Excel Discussion (Misc queries) | |||
| Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
| how do I change color of "active" cell to differentiate from rest | Excel Discussion (Misc queries) | |||
| VBA statement "scroll active cell to center"??? | Excel Programming | |||
| "outline active cell differently than other cells" | Excel Discussion (Misc queries) | |||
Threaded Mode
