Never tried this location in excel
 

Curt

If what you mean by "calling location" is the address of the active
cell when the procedure is called and the "preceding column" is the
column to the immediate left of that active cell, it should be pretty
easy. Something like


sub test()
activecell.offset(0,-1).value="data"
end sub


Good luck

Ken
Norfolk, Va



Curt wrote:
Is it possible to call a procedure and have excel put in cell address of
calling location. Have a procedure that must be called from many locations
and return data to location in precedding column.
Never tried this.