How do I do the following?
I want to convert text to a number but skip the blanks in a range
this is what I have, but it debugs because I have blanks
Range("C2").select
Do
activecell.value = clng(activecell.value)
activecell.offset(1,0).select
Loop Until activecell.row = 500
How do I skip the empty or blank cells but still loop the code to cel
500.
Thank you for any help
Jos
--
jhahe
-----------------------------------------------------------------------
jhahes's Profile:
http://www.excelforum.com/member.php...fo&userid=2359
View this thread:
http://www.excelforum.com/showthread.php?threadid=52498