+ Reply to Thread
Results 1 to 3 of 3

Increasing a cells value

Hybrid View

faltu780 Increasing a cells value 10-11-2009, 09:40 PM
protonLeah Re: Increasing a cells value 10-11-2009, 09:55 PM
D_Rennie Re: Increasing a cells value 10-11-2009, 09:59 PM
  1. #1
    Registered User
    Join Date
    10-11-2009
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    1

    Increasing a cells value

    Hi, just wanted to ask how I could increase a cells value with code.

    Let me tell you what I mean.

    Cell D4 has the value 4

    in cell C4 I want to code it like so (C++ reference) D4 = D4 + 1

    that code should be in C4 and it should take the value currently in D4 and then add 1 to it and thus D4 should now read 5

    Thanks in advance

  2. #2
    Forum Guru
    Join Date
    03-02-2006
    Location
    Los Angeles, Ca
    MS-Off Ver
    WinXP/MSO2007;Win10/MSO2016
    Posts
    12,953

    Re: Increasing a cells value

    You must choose between a either formula or a value in a cell, not both. You will probably have to use a helper cell; where are these values coming from?
    Ben Van Johnson

  3. #3
    Valued Forum Contributor
    Join Date
    05-14-2009
    Location
    gold coast
    MS-Off Ver
    Excel 2007
    Posts
    843

    Re: Increasing a cells value

    hello faltu780
    using .range
    Range("D5").Value = Range("D4").Value + 1
    using .cells
    Cells(5, 4).Value = Cells(4, 4).Value + 1
    hope this helps

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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