Get Cell A10 as Cells[x, y]

Nov 11, 2011 at 7:48 PM

Hello

I have an AddIn in which the user chooses the start cell eg A10 or whatever as well as lots of other settings.

Using these settings I then want to write values to cells starting  at A10 or whatever start cell they chose.  I think in order to do this I need to convert into Cells[1, 10] on the ActiveWorksheet and set:

ActiveWorksheet.Cells[1, 10].Value = "Blah"

How do you go from A10 ->Cells[1, 10] and vice versa?

Kind Regards
Jon 

Coordinator
Nov 11, 2011 at 8:57 PM

Perhaps

xlApp.ActiveSheet.Range("A10").Value = "Blah"

-Govert

Nov 24, 2011 at 8:42 AM

Hi Govert

I don't think that I phrased this one very well.  I was looking for a way to get from A1 notation to R1C1 notation and vice versa.

I found that the ConvertFormula() method did what I needed.

Thanks
Jon