+ Reply to Thread
Results 1 to 4 of 4

Get Column and Row of a Specified Iteration of a String Within a Specified Range.

  1. #1
    Registered User
    Join Date
    09-16-2014
    Location
    California
    MS-Off Ver
    2007
    Posts
    5

    Question Get Column and Row of a Specified Iteration of a String Within a Specified Range.

    Hi friends! I'd appreciate your help:

    I'm looking for a way to get back, in two cells (one for column, one for row), the location of the first iteration of a string within a specified range (Like inside the rectangle formed by A20 and L40)of my excel sheet.

    Thanks a lot! I look forward to seeing the responses.
    PS I'm using Excel 2007

  2. #2
    Valued Forum Contributor
    Join Date
    07-07-2014
    Location
    Washington DC
    MS-Off Ver
    2007
    Posts
    1,047

    Re: Get Column and Row of a Specified Iteration of a String Within a Specified Range.

    Can you upload a sample file?

  3. #3
    Registered User
    Join Date
    09-16-2014
    Location
    California
    MS-Off Ver
    2007
    Posts
    5

    Re: Get Column and Row of a Specified Iteration of a String Within a Specified Range.

    Quote Originally Posted by hoyasaxa215 View Post
    Can you upload a sample file?
    http://1drv.ms/1sjk5MM

    Uploaded a sample to my OneDrive

  4. #4
    Registered User
    Join Date
    09-16-2014
    Location
    California
    MS-Off Ver
    2007
    Posts
    5

    Re: Get Column and Row of a Specified Iteration of a String Within a Specified Range.

    Help please! Also, I don't know if this will make a difference, but it'd be nice for the result to spit out in some place like BA1 and BA2 and not A1,A2

+ 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. Find a string in certain column and replace with range of cells
    By joker25 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-28-2014, 09:25 AM
  2. [SOLVED] Help with setting Column Range to remove string with VBA
    By isritter in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 04-20-2014, 01:19 PM
  3. [SOLVED] Insert a different named range into VBA loop with each iteration
    By Dr_Gzus in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-28-2013, 04:57 PM
  4. CountIf applied to range that increases by one element for each iteration
    By RowanB in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-11-2012, 04:31 AM
  5. [SOLVED] [SOLVED] Loop: Copy and paste range that changes with every iteration
    By Allen Geddes in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-15-2005, 09:10 AM

Tags for this Thread

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