Right now I have code setup so if a 1 is entered into a cell in Column
the active cell is made then made Cell C2. I want to change it so tha
it is a specific cell (A50) instead of the entire column.
Here is the code that does it now:
If avoidloop And Trim(Target) < "" Then
If Target = "1" Then
Range("C2").Select
Application.SendKeys "{F2}"
Else
--
Lil Pu
-----------------------------------------------------------------------
Lil Pun's Profile:
http://www.excelforum.com/member.php...fo&userid=3384
View this thread:
http://www.excelforum.com/showthread.php?threadid=55252