I have created a VBA by reading the article to calculate the sample size. After writing VBA Now I am trying to run VBA its is not responding. It taking time but no response.
Please have a look attached VBA and base article.
Note: After downloading the excel file change extension xlsx into xltm.
Last edited by Montecarlo1; 06-03-2021 at 10:24 PM.
In the following instruction
B6 is a variable declared but with no value assigned, VBA sets its value to 0, and the loop never ends. Just replace it with b and everything should work.
Please Login or Register to view this content.
HTH,
Francesco
Last edited by Hydraulics; 06-04-2021 at 02:28 AM.
Aim high or don't even try.
---------------------------------
If your question has been answered, don't forget to mark the thread as SOLVED.
If you find an answer helpful, click on the star icon at the bottom of the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks