View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David Fixemer David Fixemer is offline
external usenet poster
 
Posts: 21
Default Column Number/Letter

Ladies & Gentlemen,

Is there an easy way to get activecell.column to return a
letter(s) rather than a number?

The reason I'm asking is that I would like to do the
following:

activecell.value = "=sum(AA1,AB2,AC3)"

My problem is that I have the "AA", "AB", and "AC" as
numbers rather than letters.

What about converting "Cells(2,28)" into AB2?

Is there a better methond of summing a "broken range"?

Thanks in advance,

David Fixemer