Results 1 to 3 of 3

Thread: Solved: Tweeking formula

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 09-12-2011, 12:13 PM #1
    Klartigue
    Klartigue is offline
    VBAX Mentor
    Joined
    Aug 2011
    Posts
    353
    Location

    Solved: Tweeking formula

    [VBA]Sub Maturity()
    '
    ' Lookup Maturity

    Windows("sunrise.csv").Activate
    Application.Run "BLPLinkReset"

    Range("AB7").Resize(Range("A2").End(xlDown).Row - 1).FormulaR1C1 = _
    "=VLOOKUP(RC[-27],'[Sunrise Perform Input 8.31.2011.xls]Sheet1'!R1:R65536,10,FALSE)"


    End Sub[/VBA]

    how do i get this formula to fill down all AB cells that are present? Could be AB2 to AB20, could be AB2 to AB100. etc..
    Last edited by Bob Phillips; 09-13-2011 at 01:57 AM.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

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