Entering Cells using a Macro

[David_UK]

Hi guys,

I need help with a macro, I have a sheet with 12000 lines of data, what I need to is at every 38th line I need to put a number 1 for eg...

Or if you have any other suggestions, please feel free.

David.

 

[Glaswegian]

David

Can you be a bit more explicit? What exactly are you trying to do? How is your data laid out? How many columns etc? What number do you want to insert?

 

[David_UK]

Sorry,

I have 12000 rows, and at intervals of every 38 rows I needed to place a marker, i.e. a number this needs to be in column A. so

Rows 1-37 are blank, then A38 = 1 then A76 = 1 and so on

Hope this helps.

David.

 

[Glaswegian]

Rows 1-37 are blank, then A38 = 1 then A76 = 1 and so on

David

Sorry - what is in Column A - data or all blank cells or just some blank cells?

 

[Legacy 12630]

Dim x%
For x = 38 To 12000 Step 38
    Cells(x, 1) = 1
Next

 

[David_UK]

Yes the column is blank.

 

[Glaswegian]

Ponsy got in first.

I was just asking the questions in case there was anything that might have influenced the method of solving your problem.