Results 1 to 12 of 12

Thread: Solved: Resizing a range based on matching values.

Threaded View

Previous Post Previous Post   Next Post Next Post
  1. 01-23-2013, 08:13 AM #1
    pcarmour
    pcarmour is offline
    VBAX Contributor
    Joined
    Nov 2012
    Location
    Billericay, Essex
    Posts
    145
    Location

    Solved: Resizing a range based on matching values.

    Hi,
    I have 3 columns of data and I am trying to find a way of resizing a selection based on matching cells in column A ie when cell A3 is selected I then need to resize the selection down to A24 (all 1117) and across to C24 giving me A3:C24 selected. Or if A31 is selected It resizes to A31:C61.
    Please see attached.
    Any help is very much appreciated.


    I am working with Windows Home Premium version 6.1.7601 SP 1 Build 7601and Excel version 14.0.6123.5001 (32 bit)
    Attached Files Attached Files
    Regards, Peter.
    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