Adding Text to Cell using VBA

[kinglue]

I need help with adding text to row.

I want First Name to Cell A4 and Last Name and Cell B4 through F4. How I could I build this? I would like to loop through 218 worksheets.

[GaidenFocus]

First you need an input method. Are you uploading this from a text file or do you want a prompt for you to input the info?

[kinglue]

I want the macro to run and automatically insert text in cell a4 -f4. Then loop for all sheets. Sorry I am new to all this.

[Norie]

Where does the data come from?

[kinglue]

Sub text()
Application.Worksheets("Sheet1").Range("A4") = "County"
Application.Worksheets("Sheet1").Range("B4") = "name 3"
Application.Worksheets("Sheet1").Range("C4") = "name 4"
Application.Worksheets("Sheet1").Range("D4") = "nam A"
Application.Worksheets("Sheet1").Range("E4") = "nam B"
Application.Worksheets("Sheet1").Range("F4") = "nam C"
End Sub


I want this loop onto over 200 sheets

[Norie]

Something like this perhaps.

Please Login or Register  to view this content.