Results 1 to 19 of 19

Thread: [RESOLVED]VBA-EXCEL How to work with R1C1

Threaded View

  1. #1

    Thread Starter
    Member
    Join Date
    Feb 2006
    Location
    Holland
    Posts
    34

    Resolved [RESOLVED]VBA-EXCEL How to work with R1C1

    My function matches the variable in cel R[1]C[-1] with variables in a matrix IsEen and gives back variable 2 when match is true and zero when match is wrong. But it gives me SyntaxError. Can somebody help me fix this function?

    VB Code:
    1. Function LookColumnBackAndRowFuther()
    2.  
    3.   If(16<>Type(MATCH(R[1]C[-1],IsEen,0)),2,0)
    4.  
    5. End Function
    Last edited by Tobian; Feb 21st, 2006 at 06:32 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width