Results 1 to 5 of 5

Creating a loop with a small formula

Threaded View

  1. #1
    Registered User
    Join Date
    04-10-2013
    Location
    Belgium
    MS-Off Ver
    Excel 2010
    Posts
    76

    Creating a loop with a small formula

    Hi,

    Im trying to get the following thing started but my loop doesn't succeed. I've got 3 columns. I need to place a formula in column C if A is empty.

    Example:

    A2 contains data so do nothing.
    A3 is empty do: C3=B3+B4.
    A4 contains data so do nothing.
    A5 contains data so do nothing.
    A6 contains data so do nothing.
    A7 is empty do: C7=B7+B8.

    this is what I've got so far:

    Dim rCell As Range
    
        If IsEmpty(rCell) Then
            ActiveCell.Offset(0, 3).Select
            ActiveCell.FormulaR1C1 = "=R[-1]C[-1]-RC[-1]"
        Else
    
        End If
    If you need an examplefile, just say so : )
    Last edited by flunzy; 03-13-2014 at 09:39 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Can't stop small loop
    By flunzy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-04-2014, 06:43 AM
  2. Small Loop Problem
    By ericmax79 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-13-2013, 10:09 AM
  3. Replies: 0
    Last Post: 01-10-2012, 01:15 PM
  4. creating a small database
    By kamalthakur in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-01-2008, 09:31 AM
  5. creating a small array from spreadsheet values/counts
    By tigpup. in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-07-2006, 09:55 AM

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