Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I turn excel columns from column number to column letter? | Setting up and Configuration of Excel | |||
column header changed from letter to number, how return to letter | Excel Discussion (Misc queries) | |||
Auto number w/ different letter-number combos in same column | Excel Worksheet Functions | |||
Column Number/Letter Substitute | Excel Programming | |||
Column Number to letter in Row Source | Excel Programming |