using the cell worksheet function

[pwl2706]

Hi all,

In my worksheet the user will type a column letter or letters (such as 'GD')

In another cell I want to calculate teh difference between the column number of the cell letter given by the user and start column (F, whcih will be 6)

I tried this:

=CELL("col",cell("contents",G23))

but get an error

in cell G23, I have this:

=CELL("contents",toColumn) & 1

and this works fine, as the range toColumn has the value GD, and the formula returns GD1

but what am I doing wrong? And is there a better way to do this?

The reasoning is that I need to determine how many columns across my macro will have to autofill formulas

thanks for any help
Philip

 

[Andrew Poulsom]

I don't know why you can't return the column number in VBA, but try:

=CELL("col",INDIRECT(G23))

 

[pwl2706]

thanks that was it, it's to give the user a visual clue how many days calculation will be done if they type in a certain column letter