Results 1 to 3 of 3

Sequential numbers and letters across cells

Threaded View

  1. #1
    Registered User
    Join Date
    03-24-2022
    Location
    World
    MS-Off Ver
    360
    Posts
    1

    Sequential numbers and letters across cells

    I'm trying to write a script that will do the following:

    It clears the content of each cell in a column and sets the value to A01, A02, A03... all the way to A12. When it reaches A12 it switches to B01 for the next cell in the column and continues this pattern until it reaches G12.

    Example for clarity. Imagining each line is a cell:
    A01
    A02
    A03
    ...
    A12
    B01
    B02
    B03
    ...
    G12

    I know this should be pretty easy but I think I'm struggling with the logic. If anyone could give me a shove in the write direction, that would help my learning of VBA tremendously. Thank you so much for you time.
    Last edited by Caustic Base; 03-24-2022 at 04:33 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Sum cells containing numbers and letters
    By Texas10 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 07-09-2014, 07:59 PM
  2. Are sum cells possible with letters instead of numbers?
    By Zesty in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-06-2013, 06:13 AM
  3. Replies: 4
    Last Post: 02-04-2012, 01:46 PM
  4. Sum cells that have numbers and letters in them!
    By anthgav in forum Excel General
    Replies: 4
    Last Post: 01-11-2010, 12:40 PM
  5. How to add cells with letters and numbers
    By spud in forum Excel General
    Replies: 2
    Last Post: 06-10-2008, 05:21 PM
  6. sum: cells that contain numbers and letters
    By rdawnh in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 07-19-2007, 03:32 PM
  7. Replies: 5
    Last Post: 07-15-2006, 08:30 PM

Tags for this Thread

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