Loop in excel - beginner

[svetlinsem]

Hello,

I have two sheets (raw and template). In sheet raw there are two important cells A1 and A2 with values 5 and 12000. I need to to set values in trmplate for cells H1 to H5 values 12001, 12002 to 12005


Thanks in advance.

 

[davesexcel]

Cross posted.
https://stackoverflow.com/questions/53090105/loop-in-excel-begiiner

More information may be required.

 

[Norie]

You could do it without a loop.

With Sheets("Template")
    .Range("H1").Value = Sheets("Raw").Range("A1").Value
     .Range("H1").Resize(Sheets("Raw").Range("A2").Value).DataSeries Date:=xlDay, Step:=1
End With

 

[Fluff]

@svetlinsem

Cross-Posting
While we do not prohibit Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules).
This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.

 

[svetlinsem]

Sorry about Cross-Posting.
​I delete the stackoverflow post.

 

[svetlinsem]

Thanks, but not work Invalid outside procedure.

 

[mrshl9898]

You need to put it in a procedure.

Sub Macro1 ()

code goes here

End Sub