loop worksheets

Hi all I have the following code which works well in part but Private Sub COPYTEAM() Application.Calculation = xlManual Application.ScreenUpdating = False Dim LastRow As Long Dim ws As Worksheet Sheets("Template").Visible = False Sheets("Team").Visible = True Call ClearTeam...

First of all, good morning and thanks to all of you who come on here and help us out and never asking much in return. You've inspired me to go to other forums where I actually do something about the subject and help out. :) I seem to have a sick dog now that is wanting attention so I've broken...

Hi all, I'm trying so detect the existence of a column of data by checking to see if the first cell in all possible columns contains data. If so, I want to copy the data from all ranges found this way into a single master column in a separate sheet. Currently the code appears to loop, detect...

Hello. I have a code that checks for data in all the worksheets of a workbook, but i want one specific (based on its name) excluded from the search. This is what i wrote but it's not working: For Each ws In Worksheets 'Loop Info worksheet If ws.Name = "Info" Then...

Hello All, I have a workbook that will have some raw data on about 40 worksheets. I want to clean the data up and make it look presentable. Sheet1 is unique, Sheet2 is unique, Sheet3-40 are all the same (format-wise). I've been trying to create a loop that uses a Select Case statement to...