Hi Steph,
Are you trying to have "ok" automatically entered into a cell
merely by landing (activating) a cell in Column 3. If so you
would use an Event macro.
http://www.mvps.org/dmcritchie/excel/event.htm
If might be safer to use a doubleclick to trigger your event
macro.
---
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
"Steph" wrote...
Based upon the active cell, how can I type the word "ok" into column 3?
So basically, I need to determine the row the active cell is in, and then
use that row and column 3 as the target for the "ok" text. Thanks!