View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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