+ Reply to Thread
Results 1 to 5 of 5

Macro to hide rows containing #N/A

  1. 02-17-2014, 08:04 AM #1
    arkharova.s
    arkharova.s is offline
    Registered User
    Join Date
    02-17-2014
    Location
    almaty
    MS-Off Ver
    Excel 2003
    Posts
    13

    Macro to hide rows containing #N/A

    Hi! need ur help, please!!

    I have #N/A in B27:F36
    i need a macro that will hide rows containing #N/A

    plsss!!! thank u!!!!
    Last edited by arkharova.s; 02-18-2014 at 04:18 AM.
    Reply With QuoteRegister To Reply
  2. 02-17-2014, 08:12 AM #2
    nilem
    nilem is offline
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Macro to hide rows containing #N/A

    Hi arkharova.s
    try it
    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  3. 02-17-2014, 08:15 AM #3
    Olly
    Olly is offline
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Macro to hide rows containing #N/A

    Or to just hide NA errors:
    Please Login or Register  to view this content.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...
    Reply With QuoteRegister To Reply
  4. 02-17-2014, 08:29 AM #4
    JOHN H. DAVIS
    JOHN H. DAVIS is offline
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Macro to hide rows containing #N/A

    Duplicate post:

    http://www.excelforum.com/excel-prog...ining-n-a.html
    Reply With QuoteRegister To Reply
  5. 02-17-2014, 11:58 PM #5
    arkharova.s
    arkharova.s is offline
    Registered User
    Join Date
    02-17-2014
    Location
    almaty
    MS-Off Ver
    Excel 2003
    Posts
    13

    Re: Macro to hide rows containing #N/A

    Dears!! thank you!! both options are working - great! thanks a lot!!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« 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. Need help creating macro to hide rows based upon whether 1 of 3 rows have data
    By BigEdJr in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-17-2014, 02:58 PM
  2. Macro: Copy 3 Rows & Insert below with Format....Also hide last two rows inserted
    By AWiT in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-10-2013, 12:04 PM
  3. [SOLVED] Macro to hide Zero Rows
    By Mile029 in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 11-19-2012, 02:44 PM
  4. Using check boxes to hide and un-hide rows with drop down lists within rows
    By Sparky_Chris in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-24-2012, 07:22 AM
  5. Macro to Hide and Unhide Rows but still be able to insert rows
    By majasmi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 03-01-2011, 09:25 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1