Results 1 to 11 of 11

Fill down to last cell containing data

Threaded View

  1. #1
    Registered User
    Join Date
    11-03-2011
    Location
    Northants, England
    MS-Off Ver
    Excel 2007
    Posts
    6

    Smile Fill down to last cell containing data

    Hi
    I am sure this is probably a quick fix but I can't get my head around the solution.

    I have the following code:
        Sheets("Export").Select
        Range("A3").Select
        ActiveCell.FormulaR1C1 = "=Import!R[7]C" ' = Date
        Range("B3").Select
        ActiveCell.FormulaR1C1 = "=Import!R[7]C&"" - ""&Import!R[4]C[1]" ' = Concatenate type & description
        Range("C3").Select
        ActiveCell.FormulaR1C1 = "=Import!R[7]C[1]" ' Debit
        Range("D3").Select
        ActiveCell.FormulaR1C1 = "=Import!R[4]C[1]" ' Credit
    ' Fill down to next row
        Range("A3:D3").Select
        Selection.AutoFill Destination:=Range("A3:C4"), Type:=xlFillDefault
        Range("A3:D4").Select
    What I need to do is to continue to fill down until " " (or a null value) is found within A*:D*


    Please can anyone help me ?
    Last edited by Courtneydog; 11-09-2011 at 02:48 PM. Reason: Mark as solved

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