+ Reply to Thread
Results 1 to 2 of 2

macro to create a table. Number of columns/rows unknown

  1. #1
    Forum Contributor
    Join Date
    01-09-2016
    Location
    USA,USA
    MS-Off Ver
    2016
    Posts
    1,192

    macro to create a table. Number of columns/rows unknown

    Want to insert a table at "A3", my table has headers. Generally columns will always go to BF, but rows may vary.

    Tried searching online, but everything seems to be asking about a set number of columns/rows.

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: macro to create a table. Number of columns/rows unknown

    Hi,

    If you mean you want to convert existing data to a Table, you could use Range("A3").Currentregion to get the range- assuming there's nothing above that. If there is, you can just use that to get the number of rows and columns.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ 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. Macro to create a table of an unknown size of data
    By mtma in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-07-2015, 04:38 PM
  2. Macro to apply formatting to an unknown range of rows & columns
    By anya1 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-19-2013, 09:07 PM
  3. Sum 12 Rows Unknown Number Of Columns
    By goss in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-28-2012, 08:34 AM
  4. [SOLVED] Excel 2007 : Can Excell create adjustable table (number of columns and rows) ?
    By western_gunner in forum Excel General
    Replies: 5
    Last Post: 06-19-2012, 04:05 AM
  5. Replies: 3
    Last Post: 02-13-2012, 04:27 PM
  6. Replies: 4
    Last Post: 08-02-2010, 04:26 PM
  7. Macro to find the average of an unknown number of rows
    By CNN in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-05-2010, 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