User Profile

Collapse

Profile Sidebar

Collapse
polyglot717
polyglot717
Last Activity: May 29 '14, 08:43 PM
Joined: May 29 '14
Location:
  •  
  • Time
  • Show
  • Source
Clear All
new posts
  • polyglot717
    replied to For Loop Not Catching All Sheets
    in Visual Basic
    Thank you! After posting - I dug in deeper and realized that it was skipping every other. Then the fix was apparent. When I posted it seemed like it was random sheets.
    See more | Go to post

      Leave a comment:

    • polyglot717
      started a topic For Loop Not Catching All Sheets
      in Visual Basic

      For Loop Not Catching All Sheets

      This code is meant to iterate over all of my sheets, but it is skipping some. Can anyone help me figure out why?

      Code:
      Sub BuildIntegration()

'Setup Variables
    
    Dim NextRow As Integer
    Dim intSheet As Integer
    Dim WkshCount As Integer
    
    WkshCount = ActiveWorkbook.Worksheets.Count
        
'Turn off screen refresh
    
    'Application.ScreenUpdating
      ...
      See more | Go to post
      Last edited by polyglot717; May 29 '14, 07:37 PM. Reason: Add code tags
      No activity results to display
      Show More
      Working...