How do I copy one cell into a range of cells?

[aaron_brown99]

I know this sounds almost absurd, but how do I code the macro correctly to take B2 and copy it into A3:A50?

Thanks,

Aaron

[Ivan F Moala]

On 2002-05-21 05:59, aaron_brown99 wrote:
I know this sounds almost absurd, but how do I code the macro correctly to take B2 and copy it into A3:A50?

Thanks,

Aaron

Untested;
Range("B2").copy [A3:A50]

[aaron_brown99]

Nope, tried that. It generates the "cut area and the paste area are not the same size and shape" message.

Any other thoughts? This will save a lot of manual work, and I appreciate it!

Aaron

[Ivan F Moala]

On 2002-05-21 06:10, aaron_brown99 wrote:
Nope, tried that. It generates the "cut area and the paste area are not the same size and shape" message.

Any other thoughts? This will save a lot of manual work, and I appreciate it!

Aaron

Turn your macro recorder on and do the steps
manually....see what you get ?

[jkpd2000]

Range("E7").Select
Selection.Copy
Range("F15:F23").Select
ActiveSheet.Paste

[aaron_brown99]

You, sir, are a scholar and a gentleman, and have made my day.

Thanks!!