My code analyzes the active sheet and vba will make a sheet named "analysis sheet" and put all the data there. The problem is when a sheet named "analysis sheet" already exists, it gives an error. How do i make excel detect (using an if then statement im guessing) if there is a sheet already named "analysis sheet"?
Hi,
Here's a way to do it :
or with a function :
Please Login or Register to view this content.
Please Login or Register to view this content.
GC Excel
If this post helps, then click the star icon (*) in the bottom left-hand corner of my post to Add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks