[VBA]
If Left(sh.name,3) = "Adj" then
[/VBA]
[VBA]
If Left(sh.name,3) = "Adj" then
[/VBA]
MVP (Excel 2008-2010)
Post a workbook with sample data and layout if you want a quicker solution.
To help indent your macros try Smart Indent
Please remember to mark threads 'Solved'
That wouldn't work because there is an "else" statement in the IF.
But I just got rid of the Else.
Thanks
All you had to do was add to the statement that ignored certain sheets, as for any other sheet it would have worked fine, why supply a workbook or make requests that do not meet your needs, it would have been so much easier to actually supply or ask for what you really needed!
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)
If you have the solution you wanted from this post please mark it Solved by using the thread tools at the top of this page.
Regards,
Simon
Please read this before cross posting!
In the unlikely event you didn't get your answer here try Microsoft Office Discussion @ The Code Cage
If I have seen further it is by standing on the shoulders of giants.
Isaac Newton, Letter to Robert Hooke, February 5, 1675 English mathematician & physicist (1642 - 1727)