ive merged the 2 formulas togeather as i liked the offset idea in th
first formula, and have now changed it to operate 2 columns, onl
problem this has caused is the i need to offset to a peticular column
as in i am using the macro on columns D & E, when i click a cell i
each of these the tick appears (great) but i want the cell to shift t
the cell in column G (same row). if i change the offset number to (o
3) it is fine for column D but when i click on column E the cell jump
across to column H, any ideas? cheer

--
Dan
-----------------------------------------------------------------------
Danz's Profile: http://www.excelforum.com/member.php...fo&userid=1644
View this thread: http://www.excelforum.com/showthread.php?threadid=27808