Results 1 to 12 of 12

Thread: [RESOLVED] Rewrite worksheet formula to VBA function

Threaded View

  1. Feb 21st, 2006, 05:53 AM #1
    Tobian
    Tobian is offline

    Thread Starter
    Member
    Join Date
    Feb 2006
    Location
    Holland
    Posts
    34

    Resolved [RESOLVED] Rewrite worksheet formula to VBA function

    I recorded following Macro:
    VB Code:
    1. Range("B11").Select

    2.     ActiveCell.FormulaR1C1 = _

    3.         "=CELL(""contents"",R2C)"
    I want to make a function in VBA called Function ValueRowTwo() which does the same thing like the markro above. Eg. when I insert ValueRowTwo in cel B7 it should return the value of cell B2, or when I insert it in cell C5 it should return the value of cell C2.
    Can somebody rewrite this worksheet formula to VBA function for me?
    Last edited by Tobian; Feb 22nd, 2006 at 09:27 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


Click Here to Expand Forum to Full Width