+ Reply to Thread
Results 1 to 2 of 2

Auto Fill cells in a Column. Fill down from preceeding cell, using a formula.

  1. #1
    Registered User
    Join Date
    09-07-2011
    Location
    Alabama
    MS-Off Ver
    Excel 2010
    Posts
    14

    Auto Fill cells in a Column. Fill down from preceeding cell, using a formula.

    Consulting the Experts!

    Scratching my head on this one; guess that's better than the alternative!

    Here is what I'm needing assistance with:

    Need to Auto FIll cells in a Column. Fill down from preceeding cell, using a formula within that cell.

    The number of rows containing data varies from one dataset to another (i.e., Dataset A has 200 rows and Dataset B has 500 rows). No matter the number of row, the cell will need to be poulate with the formula and 'not' populate cells beyound the number of rows containing data.

    Here is some code where I can start from (feel free to jump in and add additional code to this to completed the actions as mentioned above.

    Range ("T2").Select
    ActiveCell.FOrmulaR1C1 = "=RC[-2]*180


    Truely appreciate anyone's assistance!!

    Tim

  2. #2
    Forum Expert dangelor's Avatar
    Join Date
    09-06-2011
    Location
    Indiana, USA
    MS-Off Ver
    365 Pro Plus
    Posts
    1,509

    Re: Auto Fill cells in a Column. Fill down from preceeding cell, using a formula.

    You could try...

    Please Login or Register  to view this content.
    assuming there is data in Column A.


    HTH -Rich
    Last edited by dangelor; 09-07-2011 at 08:24 PM.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1