+ Reply to Thread
Results 1 to 5 of 5

Inserting a List into a Macro

Hybrid View

  1. 01-09-2009, 03:09 PM #1
    mbrady1973
    mbrady1973 is offline
    Registered User
    Join Date
    12-06-2008
    Location
    Syracuse
    Posts
    64
    Thanks for the reply,

    By list I mean ctrl+L.

    I wish I could upload the wb, but it contains some very sensitive info.

    I am using Excel 2003

    Thx again
    Reply With QuoteRegister To Reply
  2. 01-09-2009, 03:21 PM #2
    royUK
    royUK is offline
    Forum Expert royUK's Avatar
    Join Date
    11-18-2003
    Location
    Derbyshire,UK
    MS-Off Ver
    Xp; 2007; 2010
    Posts
    26,200
    To convert the range to a list
     ActiveSheet.ListObjects.Add(xlSrcRange, Range("$A$1").CurrentRegion, , xlYes).Name = _
        "List1"
    Add totals
     ActiveSheet.ListObjects("List1").ShowTotals = True
    Remove List

    ActiveSheet.ListObjects("List1").Unlist
    Hope that helps.

    RoyUK
    --------
    For Excel Tips & Solutions, free examples and tutorials why not check out my web site

    Free DataBaseForm example
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1