View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] jtan@alum.mit.edu is offline
external usenet poster
 
Posts: 1
Default How to get reference to a range as string?

I can get a reference to a cell as string with function CELL("address",
A1), which will return the string $A$1. How do I get a reference to a
range, for instance, A1:A5?

Thanks.