+ Reply to Thread
Results 1 to 2 of 2

need code to add table to activecell current region

Hybrid View

  1. #1
    Registered User
    Join Date
    04-20-2015
    Location
    cairo,egypt
    MS-Off Ver
    Office 365
    Posts
    70

    need code to add table to activecell current region

    need code to add table to activecell current region

    can any body help me in this ???

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,892

    Re: need code to add table to activecell current region

    Hello
    What about this code
    Sub Test()
        With Sheets("Sheet1")
            .ListObjects.Add(xlSrcRange, .Range(ActiveCell.CurrentRegion.Address), , xlYes).Name = "YourTableName"
        End With
    End Sub
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

+ 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] Column D Current Region
    By sl729 in forum Excel General
    Replies: 7
    Last Post: 09-13-2016, 01:35 PM
  2. [SOLVED] Using current region
    By ammartino44 in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-10-2015, 04:39 PM
  3. Replies: 2
    Last Post: 06-01-2015, 06:23 PM
  4. Using current.region less 1 column
    By duugg in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-31-2009, 04:54 PM
  5. Replies: 1
    Last Post: 10-04-2007, 12:04 PM
  6. current region = name
    By by1612 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-27-2007, 06:58 PM
  7. Assigning name to current region
    By KDJ in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-21-2005, 12:05 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