Hi group. I'm calling on the programming wizards in Excel to help me out...
I need to know how to read a cell in Excel using Visual Basic.
For example..
the content of cell A1 is
123456ABCD
I'm trying to extract just the number part of the cell (123456) and discard the non-numeric characters (ABCD)
I think I have the logic down but I don't even know how to read the contents of a cell, so any help is appreciated. TIA
I need to know how to read a cell in Excel using Visual Basic.
For example..
the content of cell A1 is
123456ABCD
I'm trying to extract just the number part of the cell (123456) and discard the non-numeric characters (ABCD)
I think I have the logic down but I don't even know how to read the contents of a cell, so any help is appreciated. TIA