Thread: strange range access
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
tom taol tom taol is offline
external usenet poster
  
Posts: 52
Default strange range access

Set r = Union([a2], [a4], [a9])
r.FormulaR1C1 = "=r[-1]c"
r.Value = r.Value

i want to chang result value of function of non continuous cells to
value....

*** Sent via Developersdex http://www.developersdex.com ***
Reply With QuoteReply With Quote