How do I enter values into a range from an active cell.

[111StepsAhead]

I have the following code.

Please Login or Register  to view this content.

Is it possible to do something like

Please Login or Register  to view this content.

But not by making an array? I think it involves relative positions but I am not sure.

[Kafrin]

Question: Why can't you use an array?

Personally, from what you've shown, I'd do something like...

Please Login or Register  to view this content.

If you really really can't use an array then I'm happy to try to think of another way around, but this would seem to be the more straight-forward solution.

[jeffreybrown]

How about something like...

Please Login or Register  to view this content.

Just like Kafrin, understand it is an array but seems to be the right way to go.

[111StepsAhead]

I appreciate the effort but I am still not sure if what you have will work for my situation. I am
replacing a lot of code while trying to cut down on the number of lines.

I have the same code in other sections of my worksheet but with different variables. I was
planning on defining D somewhere and then using the universal definition throughout the
code so if I had to change all the D's to C's I could do this by changing one line.

I'd rather not define a unique array every time I have to use this code.

My apologies for the disorganized thought process but for example purposes lets just say I have the following.

Please Login or Register  to view this content.

So what it comes down to is doing it your way doesn't appear to save me any time or cut down on lines of code. Yes, I am lazy but efficient.

[111StepsAhead]

How about something like...

Please Login or Register  to view this content.

Just like Kafrin, understand it is an array but seems to be the right way to go.

I like your code better because it is shorter which is part of the reason I am working on this project. To make things shorter. However, the range "A1" isn't relative to the active cell which is the other part of my problem currently. Any ideas?

[Kafrin]

OK, so you need a sub that you send variables to, something like...

Please Login or Register  to view this content.

[111StepsAhead]

Thank a lot Kafrin.
The final code I will use is this.

Please Login or Register  to view this content.

This will save me a huge amount of work in the future

[Kafrin]

Excellent, glad I could help.