looking for selected rows or cells

[meridian2000]

Hi everyone, I'm trying to find a way of finding selected cell or rows in my vb2008 code, I can loop through and read all the cells using my code, but I can't seem to find out if it's selected or not. The senario is, I want to go down the sheet manually and holding the CTRL key down click on each cell of interest, highlighting it, then using my VB code work out which cell was highlighted and store it's location in an array something like :-


for x = 1 to xlapp.rowcount
if xlapp.range(x) = selected then ......
next x

[patel45]

Please Login or Register  to view this content.

[meridian2000]

Many thanks patel45, it works a dream