+ Reply to Thread
Results 1 to 3 of 3

VBA 2010 / VBA 2011 search/find function won't work in 2011 (MAC)

  1. #1
    Registered User
    Join Date
    03-21-2013
    Location
    denmark
    MS-Off Ver
    Excel 2010
    Posts
    40

    VBA 2010 / VBA 2011 search/find function won't work in 2011 (MAC)

    Hi guys hope someone can give me a workaround on this problem when running the following vba on 2011 mac version I get an error does anyone know what code I should use instead. just to explain the code it takes the value from H7 on sheet program search on the sheet Priotering Domæne for the same value and count +.01 in the cell to the left of the found value

    Please Login or Register  to view this content.
    Hope you can help thanks

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: VBA 2010 / VBA 2011 search/find function won't work in 2011 (MAC)

    Hello lafanker,

    Since you have already cleared Formats, you really don't need to set the SearchFormats argument to False. You can simply not include it.
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    03-21-2013
    Location
    denmark
    MS-Off Ver
    Excel 2010
    Posts
    40

    Re: VBA 2010 / VBA 2011 search/find function won't work in 2011 (MAC)

    ok thanks for your answer I will try to see if this clear the problem or I will run in to mere after this thx mate for your support

+ 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. Validation list from Mac Excel 2011 fails to function on Windows 7 Excel 2010
    By lhlevasseur in forum For Other Platforms(Mac, Google Docs, Mobile OS etc)
    Replies: 3
    Last Post: 12-17-2012, 07:08 PM
  2. [SOLVED] Macro/vba to change date format from 01.01.2011 to 01/01/2011
    By Darrenh1238 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-20-2012, 07:42 PM
  3. Convert Date - 8/29/2011 to 2011.08.29
    By artiststevens in forum Excel General
    Replies: 4
    Last Post: 08-29-2011, 06:10 AM
  4. Help with Date Macros - eg. Change Values From Jun 5, 2011 to 05/06/2011
    By Red2Black in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 06-14-2011, 08:44 AM
  5. Thanks for 2010 and looking forward to 2011
    By sanlen in forum The Water Cooler
    Replies: 0
    Last Post: 12-30-2010, 09:53 PM

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