+ Reply to Thread
Results 1 to 4 of 4

VBA no longer working - filters/arrays/lookups

  1. #1
    Forum Contributor
    Join Date
    03-10-2014
    Location
    Sheffield
    MS-Off Ver
    Excel 2010
    Posts
    180

    VBA no longer working - filters/arrays/lookups

    Hi,

    I can't attach the file as it is too big for the site. If someone is willing to contact me I can email it?

    The file has a front sheet called "Viewer". The filters at the top used to work. They would reduce the results in the table underneath. For some reason this is no longer working and I am tearing my hair out trying to figure out why. I am fairly basic with VBA so please bear with me

    It uses the lookup tables on the Lookup tab but then uses arrays I think.

    Help would be greatly appreciated as I have to get this to work by Monday ideally!

    MissDB

  2. #2
    Forum Expert judgeh59's Avatar
    Join Date
    02-07-2013
    Location
    Boise, Idaho
    MS-Off Ver
    Excel 2016
    Posts
    2,310

    Re: VBA no longer working - filters/arrays/lookups

    can you reduce the data set so you can upload it?...
    Ernest

    Please consider adding a * if I helped

    Nothing drives me crazy - I'm always close enough to walk....

  3. #3
    Registered User
    Join Date
    07-27-2014
    Location
    Saudi Arebia
    MS-Off Ver
    Microsoft 10
    Posts
    56

    Re: VBA no longer working - filters/arrays/lookups

    Dear Friend,
    Try to compress (Ziped) the file then you can upload

  4. #4
    Forum Contributor
    Join Date
    03-10-2014
    Location
    Sheffield
    MS-Off Ver
    Excel 2010
    Posts
    180

    Re: VBA no longer working - filters/arrays/lookups

    Hi,

    It appears ot have corrected itself! No idea how, but it has. I presume there was just a little bug in Excel or perhaps our systems.

    Thank you for your prompt responses

    Many thanks
    MissDB

+ 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. Replies: 3
    Last Post: 10-09-2012, 03:55 AM
  2. Lookups Using Multiple Arrays
    By jcy1011 in forum Excel General
    Replies: 1
    Last Post: 08-09-2010, 10:38 PM
  3. Working with lookups
    By Pickygame in forum Excel General
    Replies: 10
    Last Post: 04-16-2009, 07:49 AM
  4. Using filters and lookups but ignore cell format?
    By jvegastn in forum Excel General
    Replies: 0
    Last Post: 02-27-2009, 03:03 PM
  5. [SOLVED] Help with lookups and arrays
    By jg in forum Excel General
    Replies: 2
    Last Post: 03-20-2006, 11:55 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1