Hi

Can a macro be written so that when a cell with a specific row reference in
a column is selected manually the macro runs and automatically select a cell
of the next column on the right with a specific row reference.

Certainly a Selection Event macro is what you are looking for,
but your question is extremely vague.
http://www.mvps.org/dmcritchie/excel/event.htm

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"nc" wrote in message ...
Hi

Can a macro be written so that when a cell with a specific row reference in
a column is selected manually the macro runs and automatically select a cell
of the next column on the right with a specific row reference.