LinkBack URL
About LinkBacks
Hello!
In this code, column B is checked entirelly, but how to check only 100 rows not 1048576 of it? Code is slow.
Please Login or Register to view this content.
Hello!
In this code, column B is checked entirelly, but how to check only 100 rows not 1048576 of it? Code is slow.Please Login or Register to view this content.
You have a loop here to delete empty rows:-
This does the same without looping:-Please Login or Register to view this content.
Please Login or Register to view this content.
You use this form of code often:-
Please Login or Register to view this content.
Last edited by mehmetcik; 10-04-2017 at 01:08 PM.
My General Rules if you want my help. Not aimed at any person in particular:
1. Please Make Requests not demands, none of us get paid here.
2. Check back on your post regularly. I will not return to a post after 4 days.
If it is not important to you then it definitely is not important to me.
You use this form of code often:=
This form achieves the same purpose without moving between sheets:-Please Login or Register to view this content.
Please Login or Register to view this content.
Because i'm f* novice. Three years, i still don't get VBA
I think it is the same, it will delete all empty space below, let's say last populated cell B100, B100:B1046576, it's slow no mather how.Originally Posted by mehmetcik
You have a loop here to delete empty rows:-
This does the same without looping:-Please Login or Register to view this content.
Please Login or Register to view this content.
Avoid using Select, Selection.
Please Login or Register to view this content.
Last edited by bakerman2; 10-06-2017 at 12:22 PM.
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.
Not working at all, Sheets("...IZVJEŠTAJ").Range("B30:J51").Value will be cleared, so...It's sheet called "...IZVJEŠTAJ" Report, sheet "...._SVE" is sort of backup.You use this form of code often:=
This form achieves the same purpose without moving between sheets:-Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks