Results 1 to 5 of 5

VBA Macro to find specified range depending on cell contents

Threaded View

  1. #1
    Registered User
    Join Date
    10-23-2007
    Posts
    80

    VBA Macro to find specified range depending on cell contents

    Hello,

    This might be a bit of a tricky one to explain but here goes...

    In column A I will have a cell that says, for example "01AStart", and then another (further down the sheet) that will say "01AEnd". I want a macro that will find "01AStart" and then select that row through to "01AEnd" (including those rows).

    The number of rows between those two cells will vary at any time and there may be several rows between the two that contain no data at all, but the range that needs selecting must be 01AStart through to 01AEnd.

    Can anybody help? Hope it makes sense!!

    Thanks
    Last edited by lealea1982; 08-24-2011 at 07:40 AM.

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