Hello All
any one can add below part in code.
when i run code i want one dialog box for pre number for column A, which number i will paste/write in that will become first digit of column A data for example i write 1 than 1 will be leading number of each cell if i leave blank than only column A data will copy as it is(only will remove dashes and spaces already in code) & total count of cell will be 11.
14311234560
14311234561
14311234562
second in column C sam file if there is only three letter than its will export with leading 0 only in sample like 0555, 0495
i am unable to post the code here having error please look off attached Sam file with code! please
Adeel
Reply With Quote