Macro to Paste

[zaska]

Hi all

I need a macro to paste the following in Column A

Shar12
Ghar13
Bhar14
Lhar15

Thank you

 

[MrKowz]

I have a feeling that you are giving an oversimplified example, but to answer your question based off the information given:

Range("A1").Value = "Shar12"
Range("A2").Value = "Ghar13"
Range("A3").Value = "Bhar14"
Range("A4").Value = "Lhar15"

You can also try recording a macro using Excel's built in macro recorder.

 

[zaska]

Thank you

I tried using macro recorder too and it was fun to learn

Can we simply this code in single line?

Have a nice day

 

[VoG]

Or maybe

Sub test()
Range("A1:A4").Value = Application.Transpose(Array("Shar12", "Ghar13", "Bhar14", "Lhar15"))
End Sub

 

[zaska]

Thank you for the advanced code.

Have a nice day