Right-click on your tab. Assuming the tab name is Sheet1:

For I = 2 to whatever
Worksheets("Sheet1").Cells(1,i).Value = "SPFL00"&i
Next I

should get it.

"jmcclain" wrote:

I have "SPFL001" in A1.

I need to have "SPFL002" in A2, "SPFL003" in A3, etc.

Is there a way to accomplish this with a formula vs typing each value in?

Any help is appreciated.

Jon