cell reference, relative rows, absolute column

my code is:

Please Login or Register  to view this content.

I want to test the value of the cell in column in the row where the current active cell is. for example if a2 is the active cell then test the value of a1, and when the active cell changes to B2 the value of a2 is tested. the row needs to be able to change without the column changing. the data set i am working with is 7,000 + records so it would be to much to out right program for designating each cell by hand. also i cant always know what column the active cell is going to be in so a relative reference to the wanted column could prove to be problematic. what is the syntax to do this?


lconner

maybe with ActiveCell.Row or Activecell.Column ?

Please Login or Register  to view this content.

Kind regards
Leo