<div>
you can use something like this...<br />
<br />
LastRow = ActiveSheet.UsedRange.Rows<wbr />.Count<br />
<br />
then feed the LastRow variable in loop. something like..<br />
<br />
while currentRow is less than LastRow<br />
do your macro<br />
<br />
For added reference on determining last row visit <a href="http://www.mrexcel.com/td0058.html" rel="ugc">http://www.mrexcel.com/td0058.html</a>
</div>


you can use something like this...

LastRow = ActiveSheet.UsedRange.Rows.Count

then feed the LastRow variable in loop. something like..

while currentRow is less than LastRow
do your macro

For added reference on determining last row visit http://www.mrexcel.com/td0058.html [http://www.mrexcel.com/td0058.html]

<div>
Thanks,<br />
How do I go down one line ?<br />
<br />
zmau<br />

</div>


Thanks,
How do I go down one line ?

zmau


<div>
<div class="content wysiwyg-content">
Hi!<br />
<br />
I have a macro (it does some work on the current line), and I want to run it &nbsp;&quot;until there are no more lines&quot;.<br />
<br />
Basically I wany to have a macro that :<br />

<div class="indent">
loop<br />
1) Runs macro_A<br />
2) Go down one line<br />
until the current line is empty.
</div>
Thanks<br />
zmau<br />

</div>
</div>


Hi!

I have a macro (it does some work on the current line), and I want to run it  "until there are no more lines".

Basically I wany to have a macro that :
loop
1) Runs macro_A
2) Go down one line
until the current line is empty.
Thanks
zmau


vbScript  in Excel - How to run a macro until there are no more lines ?

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.