Hi, hope somebody can help. I have the following code, attached to a macro button but it only seems to work in one worksheet. can somebody help and suggest what I need, so that it works on the active sheet and not throw up an error. thank you.
Please Login or Register to view this content.
The code is working for any active sheet .. But the error may be occurs because of not finding the text that you are searching for
You can add a line to avoid errors at the start of the code
Please Login or Register to view this content.
< ----- Please click the little star * next to add reputation if my post helps you
Visit Forum : From Here
What's the error you are getting?
How about this ?
Please Login or Register to view this content.
Avoid using Select, Selection and Activate in your code. Use With ... End With instead.
You can show your appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks