+ Reply to Thread
Results 1 to 2 of 2

Code to build and fill a table

  1. #1
    Forum Contributor
    Join Date
    03-04-2014
    Location
    Birmingham, England
    MS-Off Ver
    Excel 2019
    Posts
    756

    Code to build and fill a table

    Hi all,

    I have the code shown below, which creates a table from another worksheet. In the sheet there are three columns, Date, URN and Location (Eastings and Northings).

    The code creates a table, then fills in the table with the date to match a URN to a location, based on a date - essentially so we can see where someone was on a specific date.


    Please Login or Register  to view this content.

    The code is currently failing on the following line:
    Please Login or Register  to view this content.
    where i get the following error "run time error 91 object variable not set" with this row highlighted yellow.

    This line looks at the date down column A, looks at the number in column B to see if there is a match - i.e. 4490 active on 25/10/19. If so a "P" is placed in the corresponding column, to place a green tick in the box.

    However, this error keeps occurring and I really dont know why. Variables are declared at the start etc, but it cant seem to find the match, despite it being there.


    Any help much appreciated.
    Last edited by chrisellis250; 08-26-2020 at 05:20 AM.

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

    Re: Code to build and fill a table

    And...Drumroll...Sample File?
    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!!!

+ 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. [SOLVED] Can't build correct formulae to fill in an order form drawing from another tab
    By ZMAFC94 in forum Excel Formulas & Functions
    Replies: 42
    Last Post: 01-17-2020, 09:18 AM
  2. [SOLVED] How to build auto-fill calendar on Excel?
    By RazedC in forum Excel General
    Replies: 12
    Last Post: 11-04-2019, 06:29 PM
  3. [SOLVED] Build a ‘customer details’ list as I go - and have it used to auto-fill new entries (CRM)
    By Dan Mation in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-16-2018, 01:08 PM
  4. [SOLVED] VBA code to fill rows with subttoal in pivot table .
    By Ishwarind in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-03-2016, 10:15 AM
  5. Help with VBA code to find bottom row in pivot table and fill table cell borders
    By Eric111 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-28-2014, 07:15 PM
  6. code the following - down list to automatically fill table
    By blue_sky_70 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2008, 09:21 PM
  7. [SOLVED] Can you build a dialog box to fill a column
    By Don Kline in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-07-2005, 03:06 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