i want delete cell blank in loop sheet
But still error
Any idea ????
This is my picture and myfile Screenshot_127.png
Please Login or Register to view this content.
i want delete cell blank in loop sheet
But still error
Any idea ????
This is my picture and myfile Screenshot_127.png
Please Login or Register to view this content.
Last edited by daboho; 09-28-2018 at 08:06 AM.
Please Login or Register to view this content.
Surround your VBA code with CODE tags e.g.;
[CODE]your VBA code here[/CODE]
The # button in the forum editor will apply CODE tags around your selected text.
my data is so very big,so coding is very hard
after copy any data is blank ,i am delete blank cell in other sheet but error
can you help me
MY FILE HAS UPLOAD IN post #1
Please Login or Register to view this content.
Last edited by daboho; 09-28-2018 at 05:26 AM.
"Presh Star Who has help you *For Add Reputation!! And mark case as Solve"
It errors only when the sheet does not have blanks and nothing to delete.
This will ignore the error
Please Login or Register to view this content.
Any idea with other coding
I want to using array but i dont know
How to delete key(i) in array
After loop
Example
If key(1) has sucses export data ti sheets("A")
Then delete data in array
Sn="" if key (1) has executed
Then looping again key(2)
Then delete again in array
Any idea my friend
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks