+ Reply to Thread
Results 1 to 3 of 3

find cell in particular column

  1. #1
    R.VENKATARAMAN
    Guest

    find cell in particular column

    i have the same string(or number) in all the columns.
    I want to find and activate the string or number in a particular column for
    e.g only in column B.
    ideas please







  2. #2
    Tom Ogilvy
    Guest

    Re: find cell in particular column

    Dim rng as Range, rng1 as Range
    Dim fAddr as String
    with columns(2).Cells
    set rng = .find("number")
    if not rng is nothing then
    fAddr = rng1.Address
    Do
    if rng1 is nothing then
    set rng1 = rng
    else
    set rng1 = union(rng1,rng)
    end if
    set rng = .FindNext(rng)
    Loop until rng.Address = fAddr
    End with
    if nt rng1 is nothing then
    rng1.Select
    End if

    --
    Regards,
    Tom Ogilvy


    "R.VENKATARAMAN" <vram26@vsnl$$$.net> wrote in message
    news:eKXNRNeIFHA.3588@TK2MSFTNGP14.phx.gbl...
    > i have the same string(or number) in all the columns.
    > I want to find and activate the string or number in a particular column

    for
    > e.g only in column B.
    > ideas please
    >
    >
    >
    >
    >
    >




  3. #3
    R.VENKATARAMAN
    Guest

    Re: find cell in particular column

    than you very much. shall use the sub

    Tom Ogilvy <twogilvy@msn.com> wrote in message
    news:ONwaKYeIFHA.1476@TK2MSFTNGP09.phx.gbl...
    > Dim rng as Range, rng1 as Range
    > Dim fAddr as String
    > with columns(2).Cells
    > set rng = .find("number")
    > if not rng is nothing then
    > fAddr = rng1.Address
    > Do
    > if rng1 is nothing then
    > set rng1 = rng
    > else
    > set rng1 = union(rng1,rng)
    > end if
    > set rng = .FindNext(rng)
    > Loop until rng.Address = fAddr
    > End with
    > if nt rng1 is nothing then
    > rng1.Select
    > End if
    >
    > --
    > Regards,
    > Tom Ogilvy
    >
    >
    > "R.VENKATARAMAN" <vram26@vsnl$$$.net> wrote in message
    > news:eKXNRNeIFHA.3588@TK2MSFTNGP14.phx.gbl...
    > > i have the same string(or number) in all the columns.
    > > I want to find and activate the string or number in a particular column

    > for
    > > e.g only in column B.
    > > ideas please
    > >
    > >
    > >
    > >
    > >
    > >

    >
    >




+ Reply to Thread

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