Thank you. This solved the problem.
Much appreciated !
On Friday, May 30, 2014 5:27:09 PM UTC-4, Bill Q wrote:
> Hi,
>
> I am using Excel 2010. I have a macro web query that downloads various
> information. It works fine. No issue there. The only issue that I have is
> that it will stop i
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
Hi,
Please find macro below.
Thanks.
Sub Button1_Click()
Dim i As Integer, j As Integer, k As Integer, s As String
i = 1
j = 1
Do
s = Cells(i, 4).Value
If s = "" Then Exit Do
Worksheets("DATA").Select
Cells(j, 1) = Worksheets("URL").Cells(i, 1).Value
Cells(j, 2) = Worksheets("URL").C
