Consulting

Results 1 to 3 of 3

Thread: Solved: extract row from multi row range

  1. 04-18-2013, 02:42 AM #1
    dgs2001
    dgs2001 is offline
    VBAX Regular
    Joined
    Dec 2008
    Posts
    13
    Location

    Solved: extract row from multi row range

    Hi

    I know 
    Set v2 = Application.Index(r2, , 19)
    will extract a column (19) from a multi column range, but I cant seem to get the right syntax for doing this with a row.

    Please help Thanks
    Reply With Quote Reply With Quote
  2. 04-18-2013, 03:12 AM #2
    p45cal
    p45cal is offline
    Knowledge Base Approver VBAX Wizard p45cal's Avatar
    Joined
    Oct 2005
    Location
    Surrey UK
    Posts
    5,876
    [VBA]Set v3 = Application.Index(r2, 3, 0)
    [/VBA]
    p45cal
    Everyone: If I've helped and you can't be bothered to acknowledge it, I can't be bothered to look at further posts from you.
    Reply With Quote Reply With Quote
  3. 04-19-2013, 01:50 AM #3
    dgs2001
    dgs2001 is offline
    VBAX Regular
    Joined
    Dec 2008
    Posts
    13
    Location
    Thank You
    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