Use macro to add 1 to a cell
Power Query Course in Spanish
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: Use macro to add 1 to a cell

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    England
    Posts
    10
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hi, just wanna know how to add one to a cell within excel using a macro.

    This cell is the order number, so once the order is processed i want it to add one to the order number.

    Anyone help me out? pleaze

  2. #2
    MrExcel MVP Jay Petrulis's Avatar
    Join Date
    Mar 2002
    Location
    Chicago, IL USA
    Posts
    2,040
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-04-09 10:45, Jazzmanstereo wrote:
    Hi, just wanna know how to add one to a cell within excel using a macro.

    This cell is the order number, so once the order is processed i want it to add one to the order number.

    Anyone help me out? pleaze
    Hi,

    After your order processing routine is complete, insert the following

    Range(your cell) = Range(your cell) + 1

    example:
    A1 is the order cell
    Range("A1") = Range("A1") + 1

    Bye,
    Jay

  3. #3
    Board Regular
    Join Date
    Jan 2009
    Posts
    120
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Use macro to add 1 to a cell

    wg

  4. #4
    New Member
    Join Date
    May 2011
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Use macro to add 1 to a cell

      
    Similar but Different question: I am trying to add a 1 before each number of a column of telephone numbers using a macro. i.e. the numbers are 5555551212 and I need them formatted as 15555551212.
    When the numbers end in the column (it changes constantly), the macro should end.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com