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 |
All times are GMT +1. The time now is 09:34 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com