Macro question

M

Michaelt721

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
(e-mail address removed)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top