need to set cell value at certain intervals

[flashbbeb]

Hi all,

I'm not sure if a macro or a formula would work best for this, but every 17 rows, I need the cell in the A column to be set as "Part".

Thanks,
eb

 

[SkipVought]

Hi,

That seems to be a peculiar requirement.

What is the reason for this?

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[flashbbeb]

Well...I found and tweaked something I found via Google to mark the rows every 17th row.

I'm doing this to get a random sample of employees that will eventually be asked to complete a job satisfaction survey. I figured this would be a quick way to do it - and it was.

Sub markRow()

Dim i As Integer

For i = 10 To 7200 Step 17

Range("A" & i).Select
Range("A" & i).Value = "participant"
Next i

End Sub

 

[SkipVought]

What about using the RAND() function?

Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}