c.column returns a number - I need an "A" or "B" or...
Hi'
I write:
top_of_area = 2
for each c in range("C9:L9")
name_of_column = c.column 'HERE I NEED AN ALFABET ANSWER NOT NUMBER
row_number = c.row -1
c.value = "=sum(" & name_of_column & top_of_area & name_of_column &
row_number & ")"
next
This only gives me the number which I cant use when I'm trying to make
at "=sum..." in the cell for later work.
Is there an easyer way?
....or just a working way? :)
|