I apologise for having to ask this but my VBA knowledge is non-existent. I have inherited a workbook which uses the below code to convert numbers from text to numbers in all sheets however the workbook is so large it is taking ages to run and it only actually needs to run on one sheet named Data. How can I edit it to only run on the one sheet?
Many thanks
Please Login or Register to view this content.
Last edited by Legs; 05-22-2016 at 03:15 AM. Reason: Code tag
Hi Legs
Please wrap any Code you post in Code Tags...it's a Forum requirement.
Try this...
Please Login or Register to view this content.
John
If you have issues with Code I've provided, I appreciate your feedback.
In the event Code provided resolves your issue, please mark your Thread as SOLVED.
If you're satisfied by any members response to your issue please use the star icon at the lower left of their post.
Many thanks but I am getting runtime error 13 onPlease Login or Register to view this content.
Hi Legs
Make the following change (drop the s)...sorry about that...
Please Login or Register to view this content.Please Login or Register to view this content.
Perfect. Thank you!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks