+ Reply to Thread
Results 1 to 2 of 2

Selecting a worked upon area

  1. #1
    Registered User
    Join Date
    02-10-2013
    Location
    Frankfurt, Germany
    MS-Off Ver
    Excel 2003
    Posts
    57

    Selecting a worked upon area

    Hi,

    I've written this script which breaks down all text in square brackets and copies into neighbouring cells, one at a time. After it's finished, I want to select the entire range of which contains the tags (in this example, that would be B1:G10. Do you know how I can do this?

    Please Login or Register  to view this content.
    Attached Files Attached Files

  2. #2
    Forum Guru sktneer's Avatar
    Join Date
    04-30-2011
    Location
    Kanpur, India
    MS-Off Ver
    Office 365
    Posts
    9,649

    Re: Selecting a worked upon area

    Try adding these lines after the loop and just before the End Sub...
    Please Login or Register  to view this content.
    Regards
    sktneer


    Treat people the way you want to be treated. Talk to people the way you want to be talked to.
    Respect is earned NOT given.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Set a search area (without selecting it)
    By evertjvr in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-30-2013, 10:09 AM
  2. Help selecting Chart Area
    By Impartial Derivative in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-05-2011, 02:08 AM
  3. [SOLVED] Selecting active area of sheet
    By cfspahn24 in forum Excel General
    Replies: 4
    Last Post: 04-17-2006, 07:25 AM
  4. Selecting a growing area?
    By Terry Pinnell in forum Excel General
    Replies: 3
    Last Post: 02-26-2006, 07:20 PM

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