Hi,

Simple question.

Say my ActiveCell is "D5", and I want to pull the value of same row but column B. Now I know I could do 'ActiveCell.Offset(0, -2).Value'. But how do I reference column B regardless of where my ActiveCell is??

For instance I will be in "D5", then maybe "S6", and so on. I always want to get the value of the same row as ActiveCell but in Column B.

Any ideas??

Thanks,
Matt