View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
John A Grandy John A Grandy is offline
external usenet poster
 
Posts: 22
Default Range.BorderAround(xlLineStyleNone)

Huh? What does that have to do with anything?

The "With" statement has absolutely no affect on the functionality of the
methods invoked on its operand (or sub-classes of its operand) ...

.... it's just a presentational shorthand which can be used for those a
stylistic prefererence for coding in that manner ....

in fact in this particular case, using a "With" has no value whatsoever
because only one method is invoked for each iteration of the "For Each" loop


"Richard Choate" wrote in message
...
Wat is the Call statement for? Why don't you use a With statement for a
defined range?
Richard Choate

"John A Grandy" wrote in message
...
for me, the following code does not remove any borders for any cells in

the
range .....

For Each rCell In rTarget
Call rCell.BorderAround(xlLineStyleNone)
Next rCell

according to the xl2000 docs, this should work ...