Closed Thread
Results 1 to 11 of 11

Hide columns with errors?

  1. #1
    Registered User
    Join Date
    04-06-2020
    Location
    South africa, Pretoria
    MS-Off Ver
    2013
    Posts
    22

    Hide columns with errors?

    This was also posted on
    https://www.mrexcel.com/board/thread...rrors.1130744/

    Good day.

    I have been helped to continue if subscript out of range error appears which is working 100%

    My next question is how do I now hide the culumn if it has a error on it?
    So i am importing data, but the number of rows keep changing, I have done some coding on them but when they are not imported i get errors because they dont exist, that is
    why i added "On Error Resume Next" , so my next logical step will be to hide all of them that has no data pulled in,
    Cannot delete them as i have columns at end that sums to the right that include them, so i just need to hide the columns.

    Regards

    Please Login or Register  to view this content.
    Last edited by paulqsource; 04-15-2020 at 02:47 AM. Reason: cros posting

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    9,266

    Re: Good afternoon - Hide columns with errors?

    Hi there Paul...To get accurate results, please see above yellow banner...
    Also give a detailed explanation of what your requirement is...
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere.....
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember......Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Registered User
    Join Date
    04-06-2020
    Location
    South africa, Pretoria
    MS-Off Ver
    2013
    Posts
    22

    Re: Good afternoon - Hide columns with errors?

    Hi sintek - so i am importing data, but the number of rows keep changing, I have done some coding on them but when they are not imported i get errors because they dont exist, thats why i added "On Error Resume Next" , so my next logical step will be to hide all of them that has no data pulled in, Cannot delete them as i have columns at ende that sums to the right that include them, so i just need to hide the columns.

    Regards

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    9,266

    Re: Hide columns with errors?

    Explanation on its own unfortunately means nothing...See post 2 requirement...
    To get accurate results, please see above yellow banner...

  5. #5
    Registered User
    Join Date
    04-06-2020
    Location
    South africa, Pretoria
    MS-Off Ver
    2013
    Posts
    22

    Re: Hide columns with errors?

    Its ok sintak, I feel if you cannot answer with code provided you would not be able to help -Thanks for the effort. will wait for someone with vba knowledge. as its simmple - i calculate columns, when column has no data i get error, i ignor, but in sted of just ignoring the error i want to hide column with no data as well.

    Julle kapenaars weer stadig vandag?
    Last edited by paulqsource; 04-15-2020 at 03:32 AM.

  6. #6
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    9,266

    Re: Hide columns with errors?

    will wait for someone with vba knowledge
    Julle kapenaars weer stadig vandag?
    Really...That's the way you want to start a relationship on this Forum...

    We are not mind readers...Your file setup could be anything...Your code means absolutely nothing!!!!
    Edit...
    Also...Please do not edit previous posts after Members have posted...This just causes confusion...
    Last edited by sintek; 04-15-2020 at 03:37 AM.

  7. #7
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,566

    Re: Hide columns with errors?

    Quote Originally Posted by paulqsource View Post
    Julle kapenaars weer stadig vandag?
    Google Translate:

    Your hijackers slow again today?
    I hope you remember what I said would happen if you were rude to any of our members again.

    10-day suspension issued.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  8. #8
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    12,050

    Re: Hide columns with errors?

    @paulqsource

    Administrative Note
    After being a member for less than a fortnight and only 22 posts, you have already succeeded in insulting a moderator and now insulting one of our prominent members!
    Remember that YOU are the one asking for free help here, and Sintek is doing the best he can to help you on his/her spare time.
    If you think you cannot answer politely , you are free to search for forums where you can insult members/mods as you wish ( I wish you good luck)

  9. #9
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,926

    Re: Hide columns with errors?

    Quote Originally Posted by AliGW View Post
    Google Translate:



    I hope you remember what I said would happen if you were rude to any of our members again.

    10-day suspension issued.
    Ali, fwiw, kapennars is the afrikaans version of cape tonians - ie someone from Cape Town. We would call someone from Pretoria a P'towner or vaalie. I grew up in Port Elizabeth, so I would have been called a baaienaar
    I have no problem with your actions regarding the actual rude comments
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    47,566

    Re: Hide columns with errors?

    Thanks, Ford - I had to rely on Mr Google, so the accuracy of the translation (or lack of it) does not surprise me. However, as you have agreed (and for the benefit of the OP and anyone else reading this), the INTENT of the comment was rude and derogatory, no doubt about it, hence the suspension.

  11. #11
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    50,926

    Re: Hide columns with errors?

    The full comment...
    Julle kapenaars weer stadig vandag?
    translates to "you people from Cape Town are slow again today"

    On it's own, it might be considered teasing/slightly sarcastic (like making a comment about someone from Brighton lol), but in this context, I agree it could be considered insulting.

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Good Afternoon Everybody
    By Dontay in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 01-28-2017, 04:11 PM
  2. good afternoon
    By DexterX in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 09-01-2016, 09:06 AM
  3. Good Afternoon Everybody..
    By guharoy_abhishek1 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 04-03-2015, 07:28 AM
  4. Good afternoon from the UK!
    By Uylear in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 02-18-2015, 08:24 AM
  5. Good afternoon everyone...
    By Noextent in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 01-28-2014, 07:48 PM
  6. Good afternoon
    By Janis Rainis in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 01-05-2014, 08:03 PM
  7. Good Afternoon
    By kraszac in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 05-22-2013, 02:52 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