View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default More Efficient code than this

It implicitly declares i as an integer.

for example, from the immediate window:

? typename(j%)
Integer
? typename(m$)
String
? typename(n&)
Long
? typename(o!)
Single

--
Regards,
Tom Ogilvy



"Ketan" wrote in message
ups.com...
Hi Alok,
Your code contains a variable as i%. Is "% allowed in a variable name?
or it is some kind of accelarator since you have used only i?

sometimes copied the entire range into memory at one go and then

checked
values etc in that array<<

Can you pl tell me how to do this?
Thanks
Ketan