Looping through worksheet cells running same function

[mqhopewell]

Hi,

I have data in a cell (say A1) and say for example cells b1-e1 each have =HighorLow(A1), hence each cell runs a function passing A1 as an argument once A1 is changed. However, is there a piece of code that I can insert into this HighorLow function to see which cell is being updated (calling the macro) automatically after I update A1?

Any help is appreciated.

Many thanks,

Michael

 

[SkipVought]

hi mqhopewell,
I think that we need to see your function or get more info. If the only value being passed is from A1, then wouldn't the function yield the same value regardless of the column it was in (unless you have included an implicit argument that is context sensative) Skip,
SkipAndMary1017@mindspring.com