LinkBack URL
About LinkBacks
I have macro that runs OK when run by continually pressing F8 key and imports about 100 rows
However when I run with command button, it only imports 2 lines and then stops imemdiately without any error.
Please Login or Register to view this content.
I have macro that runs OK when run by continually pressing F8 key and imports about 100 rows
However when I run with command button, it only imports 2 lines and then stops imemdiately without any error.
Please Login or Register to view this content.
Last edited by caabdul; 03-10-2018 at 11:34 AM.
You are using select and active sheet and when you run the code, it picks the sheet names wherever the cursor happens to be, not necessarily the correct sheet name. You need to properly reference your sheet names and range.
It is also faster to use a filter function than a loop.
Please Login or Register to view this content.
Hi !
Better & faster execution just using a filter or an advanced filter …
Hi AB33
I did this;
and also putPlease Login or Register to view this content.but it doesn't help. Even when I run macro from Visual Basic window's Run button, it works.Please Login or Register to view this content.
ah, I forgot to remove "ws.Activate", in "With ws" section. It works Now. Thanks
Same problem happening to another code. Code won't run using button in sheet. What is issue in it now?
Please Login or Register to view this content.
In the application.Sum part you have to specify which sheet you want this to be executed.
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.
It worked, Thanks
I changed all 4 instances of .Sum to ....Sum(.Sheets("Shifts").Range......
Last edited by caabdul; 03-10-2018 at 11:34 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks