ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Macro (https://www.excelbanter.com/excel-discussion-misc-queries/31001-macro.html)

nc

Macro
 
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.

David McRitchie

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.





All times are GMT +1. The time now is 07:13 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com