hdman
Last Activity: Dec 9 '13, 07:56 PM
Joined: Sep 5 '13
Location:
-
That's it, Thanks a bunch!!!!!! -
Actually, with reference to the spreadsheet that I am copying data from; the point where I check to see when I have reached the last row of data is line 45.
in line 30, i defined the variables startRow and endRow. the spreadsheet that i am copying from actually has several tables (same number of columns and rows).
I use the LookupString variable to help identify the row number at which a new table begins. Thats what...Leave a comment:
-
There is also an End Sub at the end, sorry....Leave a comment:
-
Here is my code. I am copying data from one spreadsheet to a new spreadsheet (the code is run from the new spreadsheet). I am trying to format the text in the new spreadsheet so that there is some space between tables and so that the column header text is wrapped. I am trying to increment i to do the formatting but it only seems to work the first time:
...Code:Sub findRanges() On Error Resume NextLeave a comment:
-
Having some trouble using increments in While...Wend loop
hi,
I'm having trouble incrementing inside a While...Wend loop.
i = 0
While <condition>
<statement>
i = i + 2
<statement>
Wend
I am able to execute my While statement properly but I am only able to do the first increment of i with this piece of code and then it stops after. Any help would be much appreciated. Thanks.
No activity results to display
Leave a comment: