+ Reply to Thread
Results 1 to 3 of 3

Macro to incriment cell

  1. 03-04-2010, 05:54 AM #1
    freud1
    freud1 is offline
    Forum Contributor
    Join Date
    06-13-2008
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    277

    Macro to incriment cell

    Hi Guys,

    I need a simple macro to do the following.

    Look in cell A1

    Add 1 to number value in A1

    insert answer into cell A1

    any helpers?
    Last edited by freud1; 03-04-2010 at 06:12 AM.
    Reply With QuoteRegister To Reply
  2. 03-04-2010, 06:07 AM #2
    JeanRage
    JeanRage is offline
    Valued Forum Contributor JeanRage's Avatar
    Join Date
    03-02-2009
    Location
    Nice, France
    MS-Off Ver
    Excel 2003
    Posts
    705

    Re: Macro to incriment cell

    Hi,

    ActiveCell.Value = ActiveCell.Value + 1
    HTH
    Reply With QuoteRegister To Reply
  3. 03-04-2010, 06:12 AM #3
    freud1
    freud1 is offline
    Forum Contributor
    Join Date
    06-13-2008
    Location
    London, England
    MS-Off Ver
    2010
    Posts
    277

    Re: Macro to incriment cell

    wonderful! thank you!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1