I have cell address that user can input like $A$2:$E$73. How can I get range object from this. I have tried looking at the interface definitions but cannot find anything. I'm using excel interop dll but not VSTO. I can parse that text, but...On a side note, I had to move out of VSTO because our customers did not want to install VSTO runtime. can't help and so, I'm moving on with shared addin and the shim approach.Thanks
Forrrest's suggest should fix the problem you are facing. If you have any further question how to get the worksheet object, please feel free to let us know.
It seems that you are working with a Shared Add-in. This forum is not the proper place for a issue about Shared Add-in. For Shared Add-in, the best place for this is office.developer.com.add_ins newsgroup: http://www.microsoft.com/office/community/en-us/default.mspx?dg=microsoft.public.office.developer.com.add_ins&lang=en&cr=US. You also could refer to this forum's PLEASE READ FIRST to learn more about VSTO technology.
Please remember to mark the replies as answers if they help and unmark them if they provide no help.
Welcome to the All-In-One Code Framework! If you have any feedback, please tell us.
Thanks. I'll look at the shared addin forum from next time.I understand worksheet.Range[...] will work, but I was looking for some function which can replace the range function in VBA. the Range.Address returns a string and there is no function in Range which can take that address. It only works using individual cell address.-Chandra.