Results 1 to 8 of 8

Use VBA to create & name table

Threaded View

  1. #1
    Registered User
    Join Date
    10-06-2020
    Location
    West Midlands
    MS-Off Ver
    16
    Posts
    9

    Use VBA to create & name table

    I get run time error 438 object doesnt support this property or method. I dont inderstand why it wont work. I have this running with command button. If I run it romally (using green play button) it works perfectly.
    Please help thank you

    '''Region address for table'''
    n = ws.Cells(Rows.Count, 1).End(xlUp).Offset(0, 1).CurrentRegion.Address
    '''Format Table +m if month added to table name''''
    ws.ListObject.Add(xlSrcRange, Range(n), , xlYes).Name = "Totals"
    (ws is set as sheet 1)
    Last edited by alansidman; 10-19-2020 at 03:55 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Trying to create a dynamic table so I can create a updating drop down list.
    By sbobster15 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-16-2019, 11:43 AM
  2. VBA to create dynamic table/pivot table to auto refresh charts on other sheets
    By jamesbutler2021 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-12-2019, 09:27 AM
  3. Replies: 1
    Last Post: 11-12-2018, 02:46 PM
  4. Replies: 6
    Last Post: 01-24-2017, 06:56 PM
  5. How to create a dynamic macro that will create pivot table
    By thlee1122 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-08-2015, 11:49 PM
  6. How to create a macro to create a pivot table on a new sheet
    By thlee1122 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-19-2015, 11:14 AM
  7. Create a macro to create a pivot table in a worksheet
    By Triscia in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-15-2015, 10:53 AM

Tags for this Thread

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