retrieve column for a range

[zentex]

Hi,
In VBA, I would like to retrieve the column number of a range and have not been successful after trying several variations.

The range is actually a single cell. I think I can get it by selecting the range and using ActiveCell.Column, however I do not wish to select the cell, I just want to refer to it.

This is one variation I have tried.
startpointcol = Range(startpoint).Column
startpointrow = Range(startpoint).Row

I am using it in a function and it returns me the message #VALUE!

Thanks in advance.

 

[Norie]

What's the name of your range?

Is it startpoint? Or is that the address of the range?

 

[zentex]

Yes, the name of my range is startpoint

 

[Norie]

Then just use Column.

startcol = startpoint.Column

 

[zentex]

Thanks!!