Well, Use of variant is not required here.
As Paul already suggested, use Long instead of integer. If you use variant,
the working will go slow and will acquire more space.
Replace
*Dim i As Integer, j As Integer, k As Integer, s As String *with below one
at very begining
*Dim i As Long, j As Long,
Hi,
Since you are declaring your variable as integer you are getting this
error..
check this line.. *Dim i As Integer, j As Integer, k As Integer, s As
String*
since integer can hold max value upto 32,767, post which you will get
overflow error & your macro will get stopped..
Instead of integ
