VBA Excel 2007 - Convert column alpha to numeric value

I know this should be simple, but ... I have not been able to do it.

In Excel 2007:
Click on the Office Button at the left top
Excel Options at the bottom
Popular in the left window
Working with formulas in the middle
Check R1C1 Reference Style.

HTH
John

BTW, if you want to toggle between the two references, you can use this.

Please Login or Register  to view this content.

Thank you very much. I am new to the forum saw where repiles had been received but I was unable to get to it. Will give this a try. Thanks again.

Bob

You're welcome Bob.
The code is if you want to toggle between the two reference styles for instance when you have a formula you want to use in code.
At least that is what I use it for.