+ Reply to Thread
Results 1 to 4 of 4

Range.Find searchformat:=true Excel 2007 vs. 97

  1. #1
    Registered User
    Join Date
    05-17-2009
    Location
    Bremen
    MS-Off Ver
    Excel 97
    Posts
    3

    Range.Find searchformat:=true Excel 2007 vs. 97

    Hi all out there,

    I'm a little confused while testing an Subroutine on both the Excel 2007 (my Developer Version on my home Computer) and Version 97 (installed on all the workstations in the company).
    Version 2007 will NOT find my Border Formattings, as opposed the 97 Versions does the job pretty well. Ofcourse the Testroutine is the exact same on all the Computers (4 to be exact) I tested the code. Here's the Code which resides in a WorkBoook Module:

    Please Login or Register  to view this content.
    If I test / search for a FONT format, Version 2007 DOES find it though.
    Does anyone have any idea what could course this.

    Thanks a lot

  2. #2
    Registered User
    Join Date
    05-17-2009
    Location
    Bremen
    MS-Off Ver
    Excel 97
    Posts
    3

    looking for someone who could run this piece of code

    Hi all again,
    it actually would already help a lot, if someone could run this code in his Excel 2007 environment and post his results here.
    This way I could exclude the fact that it is an installation or setup problem on my computers side

    Thanks
    Axel

  3. #3
    Valued Forum Contributor Richard Schollar's Avatar
    Join Date
    05-23-2006
    Location
    Hampshire UK
    MS-Off Ver
    Excel 2002
    Posts
    1,264

    Re: looking for someone who could run this piece of code

    Hi Axel

    Doesn't work for me either in 2007 (using SP2). Does work in 2003. So it looks like 2007 is 'broken' in this regard.

    Richard
    Richard Schollar
    Microsoft MVP - Excel

  4. #4
    Registered User
    Join Date
    05-17-2009
    Location
    Bremen
    MS-Off Ver
    Excel 97
    Posts
    3

    Red face Re: Range.Find searchformat:=true Excel 2007 vs. 97

    Hi Richard,
    you really helped me a lot, thanks

    Axel

+ 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