Results 1 to 10 of 10

Macro stops when encounters #VALUE!

Threaded View

  1. 02-12-2015, 02:57 AM #1
    mark888
    mark888 is offline
    Forum Contributor
    Join Date
    01-02-2015
    Location
    Kuala Lumpur, Malaysia
    MS-Off Ver
    2007
    Posts
    272

    Macro stops when encounters #VALUE!

    Hi Guys,

    Need some help on a macro here. I have a macro called CREATE when i run it it should automate some columns with values. The problem im having is when the macro encounters column with a value as #VALUE!, it will stop running. Appreciate if someone can help to look into tthis.

    Blank CI Report Macro.xlsm
    Test file.xls


    Kind Regards,
    Mark.
    Last edited by mark888; 02-12-2015 at 03:02 AM.
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Macro that runs when ran from Macro menu, but stops when using short cut keys...
    By Joven76 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 09-12-2014, 02:29 PM
  2. [SOLVED] Macro which clears contents below X text until it encounters Y text
    By SF1eagles in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 02-04-2014, 04:16 PM
  3. [SOLVED] row copy to other sheet in first empty row it encounters based on cell value
    By thealian in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-08-2012, 09:04 AM
  4. excel encounters an error when editing comments
    By AnnieJ in forum Excel General
    Replies: 2
    Last Post: 09-18-2005, 02:05 PM
  5. 'Encounters serious error' on opening with user-defined add-in
    By Bandicoot in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-30-2005, 01:05 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1