+ Reply to Thread
Results 1 to 2 of 2

VBA Code to list all activesheet shapes in excel

  1. 03-23-2011, 10:34 AM #1
    baisty182
    baisty182 is offline
    Registered User
    Join Date
    08-04-2010
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    34

    VBA Code to list all activesheet shapes in excel

    Hi,

    I have about 30 shapes, in order to use them for coding i want to be able to have vba list the names in say bk1:end...

    Not sure if possible?!

    Thanks!!

    ie...

    autoshape_1
    autoshape_2
    etc...
    Last edited by baisty182; 03-23-2011 at 10:43 AM.
    Reply With QuoteRegister To Reply
  2. 03-23-2011, 10:43 AM #2
    baisty182
    baisty182 is offline
    Registered User
    Join Date
    08-04-2010
    Location
    England
    MS-Off Ver
    Excel 2003
    Posts
    34

    Re: VBA Code to list all activesheet shapes in excel

    Nevermind found it on ozgrid!!

    http://www.ozgrid.com/VBA/shapes.htm
    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