Killer Posted June 9, 2006 Share Posted June 9, 2006 Can anyone help me how to create a script to check for the address of a cell in excel example how to know if the cell is A14 or J80? Link to comment Share on other sites More sharing options...
GioVit Posted June 9, 2006 Share Posted June 9, 2006 Try this: $Application = ObjCreate("Excel.Application") ; open the workbook etc, etc ;Get the Active Cell Address $Address = $Application.ActiveCell.Address() MsgBox(64,"Info", "Current Address = " & $Address) Link to comment Share on other sites More sharing options...
Killer Posted June 10, 2006 Author Share Posted June 10, 2006 Thanks for the info. I will try it. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now