micro-blades
Board Regular
- Joined
- Feb 20, 2007
- Messages
- 91
Hi,
I am copying cell values from one column to another using VBA. I can do the copy/paste fine I just need to determine if what I am pasting contains a letter so I can determine what column to copy to. The cells all contain numbers so I will only need to seperate numbers combined with letters.
I need to do the opposite for another column but I need to determine if cells containing letters have any numbers and place them in the proper column.
Any ideas?
Thanks,
Brian
I am copying cell values from one column to another using VBA. I can do the copy/paste fine I just need to determine if what I am pasting contains a letter so I can determine what column to copy to. The cells all contain numbers so I will only need to seperate numbers combined with letters.
I need to do the opposite for another column but I need to determine if cells containing letters have any numbers and place them in the proper column.
Any ideas?
Thanks,
Brian