+ Reply to Thread
Results 1 to 3 of 3

How can I change "A" to "B" using a loop or operation?

  1. #1
    Registered User
    Join Date
    12-02-2014
    Location
    Philippines
    MS-Off Ver
    2003
    Posts
    12

    Question How can I change "A" to "B" using a loop or operation?

    How can I change "A" to "B" or "B" to "C" using a loop or operation in VB?

  2. #2
    Forum Expert
    Join Date
    10-09-2012
    Location
    Dallas, Texas
    MS-Off Ver
    MO 2010 & 2013
    Posts
    3,049

    Re: How can I change "A" to "B" using a loop or operation?

    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.

  3. #3
    Registered User
    Join Date
    12-02-2014
    Location
    Philippines
    MS-Off Ver
    2003
    Posts
    12

    Talking Re: How can I change "A" to "B" using a loop or operation?

    thank you for answering my question.
    i now know how to do it.
    the chrW() or chr() can be used.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 11-17-2013, 12:05 PM
  2. [SOLVED] How to USE """"" cells count """"" change font color
    By austin123456 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 10-09-2013, 06:14 AM
  3. Replies: 5
    Last Post: 10-12-2010, 06:46 AM
  4. Replies: 3
    Last Post: 07-27-2008, 06:31 AM
  5. Replies: 7
    Last Post: 05-13-2006, 05:02 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1