Thanks for the reply, that's close to what I need, but I already know the active cell as I have just clicked on it. What I need to know is after doing this what is the column to the left of the screen.
I could scroll some place in the W/S and then click on a random cell say "AD10", that's not in the left most visible column, but I need to know what the left most column is. It could be AA1, BB1...