+ Reply to Thread
Results 1 to 2 of 2

Databody range from table from 2 column

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,946

    Databody range from table from 2 column

    Hi,

    my code looks like:

        Set lst = NamedRanges.ListObjects("tblNamedRanges")
        ColumnLstCount = lst.ListColumns.Count
        lst.DataBodyRange(lst.Cells(1, 1), lst.Cells(1, ColumnLstCount )).Copy
    The second line is not working.
    How to refer to range in dynamic table from first row from second column to the end.
    So Row1, Column2 to Last Column...

    Best,
    Jacek

  2. #2
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,946

    Re: Databody range from table from 2 column

    Anyone?

    Jacek

+ 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: 6
    Last Post: 09-12-2017, 07:37 AM
  2. [SOLVED] Get Range last row and column for Pivot Table Range
    By Simone Fick in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-10-2017, 05:27 PM
  3. Column Range to Table Row Paste
    By crowmagnus in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-25-2017, 12:52 PM
  4. [SOLVED] How to resize table range according to Column A last row
    By HaroonSid in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-03-2017, 11:09 AM
  5. [SOLVED] Copy All But the First Row of a Table Databody and Append to the End of Another Table
    By TheScott in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 06-21-2015, 02:43 AM
  6. Replies: 11
    Last Post: 07-18-2013, 05:14 PM
  7. Replies: 5
    Last Post: 08-30-2012, 06:50 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