Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
column letters and numbers
All,
Can someone please optimize this code? If UBound(arrLeanConc) = 1 Then strdummy = "A" ElseIf UBound(arrLeanConc) = 2 Then strdummy = "B" ElseIf UBound(arrLeanConc) = 3 Then strdummy = "C" ElseIf UBound(arrLeanConc) = 4 Then strdummy = "D" Else End If ActiveCell.Offset(12, 2).Range("A1:" & strdummy & LastRow - 12).Value = Application.Transpose(arrLeanConc) my upperbound on the array arrLeanConc changes based on the number of Lean gases I have specified. I also have to use the reference style and not absolute. I would like to post the results of the arrLeanConc in my excel file. There must be a better way to do this. Any help would be appreciated! Thanks! Matt S |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
no row numbers or column letters DISPLAYED | Excel Discussion (Misc queries) | |||
How can I change column numbers back to column letters? | Excel Worksheet Functions | |||
Covert Column Numbers to Column Letters in Excel VB | Excel Programming | |||
row numbers & column letters | Excel Discussion (Misc queries) | |||
Row/Column letters/numbers - how do you hide? | Excel Programming |