Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hello
I'm just having a really bad day I guess. I was wondering if some kind soul could help. I have created 12 macros called pastejanuary, pastefebruary, pastemarch etc etc etc. These are pastespecial operations. What I would like to do is if the cell $g$1 changes from january to february, run the macro called pastefebruary. Any ideas would be greatly appreciated. I created private sub worksheet_change(by val target as excel range and then asked for the range $g$1 and range value of February but thats where I ran into trouble. I cannot for the life of me get it to run the pastefebruary macro. I really would appreciate any help you could give me Cheers |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
run a macro in a locked cell | Excel Discussion (Misc queries) | |||
Can a macro be made to run on entering or leaving a cell? | Excel Discussion (Misc queries) | |||
Macro code for dropping to next empty cell | Excel Discussion (Misc queries) | |||
Keyboard Macro Just Copies Content of Previous Cell | Excel Discussion (Misc queries) | |||
Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions |