How can I change "A" to "B" or "B" to "C" using a loop or operation in VB?
How can I change "A" to "B" or "B" to "C" using a loop or operation in VB?
What are you trying to change?
If I want to loop through columns, which I am guessing you are doing, I usually make alist of columns to look through on some very hidden tab in the background. then loop through each column explicitly called out. You can even use formulas to automatically pull in the column letters if you want so its all dynamic AND easy (for me) to audit.
Please ensure you mark your thread as Solved once it is. Click here to see how.
If a post helps, please don't forget to add to our reputation by clicking the star icon in the bottom left-hand corner of a post.
thank you for answering my question.
i now know how to do it.
the chrW() or chr() can be used.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks