Hi, YasserKhalil,
good effort but you must remember to fully qualify the ranes you work on.
will always refer to the ActiveSheet, you would need to alter this code line to
to refer to each of the worksheets independently.
If iI use the prefix i to any variable that would be of Type Integer, I would expect a small L for Long there. But thatīs minor as you correctly declared the Variable (in case you have more data than 32.767).
My version of the code:
As you may see the code is basicly identical to the one you posted.
Ciao,
Holger
Ciao,
Holger
Bookmarks