Results 1 to 1 of 1

Deleting Portions of VBA Code

Threaded View

  1. #1
    Registered User
    Join Date
    02-16-2011
    Location
    Pittsburgh, PA
    MS-Off Ver
    Excel 2003
    Posts
    13

    Deleting Portions of VBA Code

    Hi there. I have sheet code that I commented out. However, now that I have 50 sheets in my workbook - I've found that I want to remove those comments and reenact the code. The comments exist in the exact same place in every sheet. For example

    'For x = 1 to 10

    'Do something here

    'Next x

    I want to remove that comment and make the code work again. The ' exists in the same three spots in every sheet. Is there a way to do this programmatically?

    I should also note that I only need this to work on sheets that have numeric sheet names. For example, 1, 2, 3, etc....

    Thanks,
    Patrick
    Last edited by poleary2000; 05-17-2012 at 03:12 PM.

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1