Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am having the below Macro code for moving the cursor E11,F11,E12,G11 & G12
and these cells are not protected and rest all other cells are locked (Other than M11 cell). I got this code in google web search. Now I want to add a small condition which is if a person enter any value in G12 cell then the Macro should automatically do copy the M11 cell. Thats all. M11 cell is not having any lock! Note:- The Cursor should move in this order only that is E11,F11,E12,G11 & G12. So please dont change the cursor movement. The cursor should not move to M11 cell and all. Private Sub Worksheet_Change(ByVal Target As Range) Select Case Target.Address Case "$E$11" Range("F11").Select Case "$F$11" Range("E12").Select Case "$E$12" Range("G11").Select Case "$G$11" Range("G12").Select End Select End Sub The above coding pasted in Sheet Tab. I am not having any knowledge in creating the macro. So, please help me. -------------------- (Ms-Exl-Learner) -------------------- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Splitting out Content in 1 cell (which is currently separated by"ALT-ENTER") into multiple cells | Excel Discussion (Misc queries) | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
How to format a cell to make it blank if it's content is "N/A" | Excel Worksheet Functions | |||
When I type "BVE" in a cell, it automatically chanegs to"BE"..Why | Excel Discussion (Misc queries) | |||
Cond Format & helper-cell based "duplicate rec" tricked by content | Excel Discussion (Misc queries) |