If - Then synthax
 

Dim cell As Range
For *Each cell In Range("B:B")*(...)
Next


I need to modify this call so the cycle goes from B10 to the last ro
containing info.

Any ideas

--
Turquoise_da
-----------------------------------------------------------------------
Turquoise_dax's Profile: http://www.excelforum.com/member.php...fo&userid=3518
View this thread: http://www.excelforum.com/showthread.php?threadid=55466

If - Then synthax
 

Hi Turquiise_dax,

See Debra Dalgeish's suggestions for resetting the used range at:

http://www.contextures.com/xlfaqApp.html#Unused


---
Regards,
Norman


"Turquoise_dax"
wrote in message
news:Turquoise_dax.29tdfn_1150997103.7202@excelfor um-nospam.com...

Dim cell As Range
For *Each cell In Range("B:B")*(...)
Next


I need to modify this call so the cycle goes from B10 to the last row
containing info.

Any ideas?


--
Turquoise_dax
------------------------------------------------------------------------
Turquoise_dax's Profile:
http://www.excelforum.com/member.php...o&userid=35185
View this thread: http://www.excelforum.com/showthread...hreadid=554668

If - Then synthax
 

On Thu, 22 Jun 2006 12:20:26 -0500, Turquoise_dax wrote:

Dim cell As Range
For *Each cell In Range("B:B")*(...)
Next


I need to modify this call so the cycle goes from B10 to the last row
containing info.

dim rng as excel.range
set rng=range("b10")
do while rng.value<""
' put your code here...
' use rng.<some property to access the current cell
set rng=rng.offset(1,0)
loop

--
PL

If - Then synthax
 

Hi Turquoise_Dax,

Please ignore my reponse - it was intended as a reply to another post!


---
Regards,
Norman