Insert formula into multiple rows in excel from cell

See more:

MS-Excel

VBA

Hello everyone, currently I am working on an excel project.

I have created a button with the macro named resetRow. Upon typing in a row number in the cell C10 and clicking the button, the column and user-defined row will have a formula inserted into the spreadsheet.

What I want to achieve is to be able to type multiple numbers in the input cell (C10) instead of just one number. For example if I type "15,16,18, 20-29" the rows 15, 16, 18 and rows 20 to 29 will have formulas inserted into their cells. Does anyone have any idea how I should go about doing that?

Dim resetRow As Integer
resetRow = Range("C10").Value

Range("F" & (resetRow) & ":I" & (resetRow)).Formula = "=G10_Anchor+short_end_increment*(base_year-F$57)"
Range("K" & (resetRow) & ":L" & (resetRow)).Formula = "=G10_Anchor+short_end_increment*(base_year-F$57)"
Range("G10_anchor_range").Formula = "=G10_Anchor"
Range("CEE_anchor_range").Formula = "=CEE_Anchor"
Range("CEE_anchor_range").Formula = "=CM_Anchor"
End Sub