| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change from Column Selection to Cell Selection
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Change formulas in a column based on a selection. | Excel Worksheet Functions | |||
| Limiting selection in a cell AND linking that selection to a list | Excel Discussion (Misc queries) | |||
| Copy Selection - Transpose Selection - Delete Selection | Excel Discussion (Misc queries) | |||
| Insert row on change of field - with input selection - not whole column | Excel Programming | |||
| excel change default column sort to current selection | Excel Worksheet Functions | |||
![Lil Pun[_16_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
