Hi Mike

do you mean how do you assign the value of row 1 of the activecolumn to a
variable?
if so, here's an example

Sub mymacro2()
Dim i As Long
i = Cells(1, ActiveCell.Column)
MsgBox i
End Sub


hope this helps
Cheers
JulieD


"Michael Smith" wrote in message
...
How would I Dim whatever number is in row 1 of the ActiveColumn
..what I have is a formula that I want to react based on the cell in
row 1 of the column the formula is in.

TIA - mike



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!