PaulCruice
New Member
- Joined
- Aug 18, 2006
- Messages
- 15
Am relatively new to VBA so will probably need some real help. The best I can do is describe what I want to do.
I have a vertical list of individual words with any punctuation also occupying its own cell. I want to begin at the top of the sheet and test if A1=any punctuation is true, then select range B1 to C1 and move all these cells in the range and those below down one cell. If B1 does not equal any punctuation then go to A2 and repeat the process through to the end of the document.
Really appreciate some help. Thanks.
I have a vertical list of individual words with any punctuation also occupying its own cell. I want to begin at the top of the sheet and test if A1=any punctuation is true, then select range B1 to C1 and move all these cells in the range and those below down one cell. If B1 does not equal any punctuation then go to A2 and repeat the process through to the end of the document.
Really appreciate some help. Thanks.