Results 1 to 10 of 10

Add formula thru VBA

Threaded View

rizmomin Add formula thru VBA 03-12-2013, 09:15 AM
JOHN H. DAVIS Re: Add formula thru VBA 03-12-2013, 09:30 AM
rizmomin Re: Add formula thru VBA 03-12-2013, 09:52 AM
JOHN H. DAVIS Re: Add formula thru VBA 03-12-2013, 09:56 AM
arlu1201 Re: Add formula thru VBA 03-12-2013, 10:26 AM
rizmomin Re: Add formula thru VBA 03-12-2013, 10:31 AM
rizmomin Re: Add formula thru VBA 03-12-2013, 10:33 AM
JOHN H. DAVIS Re: Add formula thru VBA 03-12-2013, 10:54 AM
rizmomin Re: Add formula thru VBA 03-12-2013, 11:38 AM
JOHN H. DAVIS Re: Add formula thru VBA 03-12-2013, 11:58 AM
  1. #1
    Valued Forum Contributor
    Join Date
    01-18-2007
    Location
    Georgia
    MS-Off Ver
    2010
    Posts
    4,434

    Add formula thru VBA

    Hello:

    I am using below VBA code successfully.

    Sub CurrentMonth_CopyPaste_Sales()
    
    Dim i As Long
    i = Range("B112").Value
    Range("F" & i).Copy
    Range("F" & i).PasteSpecial xlPasteValues
    'NumberFormat = "0.00"
        
    End Sub
    I want to add the formula in the next row : =IF($Ax=$K$40,$L$19,0)
    where x in $Ax would be 1 + the value in cell B112
    Example if Cell value in B112 = 50, then the formula would be =IF($A51=$K$40,$L$19,0)

    I hope this is clear and let me know if you have any questions.

    Thanks

    Riz
    Last edited by arlu1201; 03-12-2013 at 01:20 PM. Reason: Code tags should be put for the 1st post.

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