maryam
May 17th, 2004, 05:37 PM
Hellooooo every one
I am trying to write a macro that reads an array of characters from a Cell within an excel worksheet, which have the form
"EM12"
I want to make the program to seprate the alphabetic part ( Which allways come fist) from the numeric part. It could easily be done in C++ by comparing the values of array[i], but I am not as familir with VBA and I get error
Thanks so much please tell me how to do it!:afrog:
I am trying to write a macro that reads an array of characters from a Cell within an excel worksheet, which have the form
"EM12"
I want to make the program to seprate the alphabetic part ( Which allways come fist) from the numeric part. It could easily be done in C++ by comparing the values of array[i], but I am not as familir with VBA and I get error
Thanks so much please tell me how to do it!:afrog: