Results 1 to 3 of 3

FindFormat Accounting Error

Threaded View

yusunghee FindFormat Accounting Error 08-14-2013, 11:13 AM
Leon V (AW) Re: FindFormat Accounting... 08-14-2013, 11:47 AM
yusunghee Re: FindFormat Accounting... 08-14-2013, 12:02 PM
  1. #1
    Registered User
    Join Date
    04-15-2011
    Location
    Dallas,TX
    MS-Off Ver
    Excel 2010
    Posts
    21

    FindFormat Accounting Error

    I'm trying to find a certain value in Accounting format within a particular range.

    When I try to set the numberformat, it gives me an "Application defined or object defined error"

    Here is the code:

        With Range("p10:p380")
            With Application.FindFormat
            .NumberFormat = "_(* #,##0.00_);_(* (#,##0.00);_(* "" - ""??_);_(@_)"
     
            .VerticalAlignment = xlTop
        End With
    Thank you
    Last edited by yusunghee; 08-14-2013 at 12:02 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. accounting
    By Abuali in forum Access Programming / VBA / Macros
    Replies: 1
    Last Post: 05-24-2010, 11:16 AM
  2. Looping FindFormat with relative cell update
    By adamspain in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 10-23-2009, 09:29 AM
  3. Accounting
    By Offedoruife in forum Excel General
    Replies: 1
    Last Post: 06-24-2007, 05:32 AM
  4. [SOLVED] FindFormat with Borders not Working
    By xenovah@gmail.com in forum Excel General
    Replies: 0
    Last Post: 06-06-2006, 12:10 PM
  5. FindFormat w/ multiple spreadsheets
    By BarryQ in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-28-2005, 03:13 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