Can you post the rest of the code... It is a little tought to comment without
seeing what is failing...
--
HTH...
Jim Thomlinson
"x taol" wrote:
1.
set rng=[a1:a9]
rng.select
with selection
~~~~abuout formatcondition
end with
2.
set rng=[a1:a9]
with rng
~~~~abuout formatcondition
end with
curiously, number 1 is work out... but, number 2 is not work... why?????
*** Sent via Developersdex http://www.developersdex.com ***