Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro question
Hi,
I am familiar with macros but can't figure out how to do this one. I want to create a macro that will enter specific data into 4 different cells. The problem is that the starting cell will be different each time. Example When I run the macro, I want to click on cell A1 to start in, and have it put 10 in each of the following cells: A B C D 1 10 10 10 10 2 So now, if I click on cell A17, I want the macro to put 10 in A17, B17, C17 and D17. I don't even know what terminology to use to describe this situation. Any help would be great! Thanks, mike |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro question
Activecell.Resize(1,4).Value=10 Tim "Michaelt721" wrote in message ... Hi, I am familiar with macros but can't figure out how to do this one. I want to create a macro that will enter specific data into 4 different cells. The problem is that the starting cell will be different each time. Example When I run the macro, I want to click on cell A1 to start in, and have it put 10 in each of the following cells: A B C D 1 10 10 10 10 2 So now, if I click on cell A17, I want the macro to put 10 in A17, B17, C17 and D17. I don't even know what terminology to use to describe this situation. Any help would be great! Thanks, mike |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 Macro/VB Question DDE Question | Excel Worksheet Functions | |||
Macro question | Excel Discussion (Misc queries) | |||
Macro Question | Excel Worksheet Functions | |||
new macro question | Excel Programming | |||
Macro Question | Excel Programming |