Repeat A Value In A Predefined Number Of Rows Using Formula

Required
1 re-repeating number 100 in column A
Without pulling down cell
ineed that by formula , no code
I think I reached resolve in the sheet (AA 2)

=IF($B$2>=(ROW($A$2:$A$380)-1),$C$2,"") would be a much simpler approach

Ingenious solution and beauty of simplicity

If I want the solution by code?

Code:

---

Sub RepeatValue()

    Range("A2:A" & Range("A" & Rows.Count).End(xlUp).Row).ClearContents
    Range("A2").Resize(Range("B2").Value).Value = Range("C2").Value
   
End Sub

---

you are very kind thanks a lot