MS Excel VBA Code Range Setting Error

[OilEconomist]

Thanks in advance for your assistance. I have just excerpted the part of the code that causes issues. Why am I getting a "Run Time error '1004': Application-defined or object-defined error" for this line of code:

Set LoopRng = Range(Cells(8, ColNoStart), Cells(8, CoNoEnd))

in the following code:

Sub RngError()

Dim ColNoStart As Long
Dim ColNoEnd As Long
Dim LoopRng As Range


ColNoStart = 1
ColNoEnd = 12
Set LoopRng = Range(Cells(8, ColNoStart), Cells(8, CoNoEnd))

End Sub

When I replace that line with the following, it works:

Set LoopRng = Range("B8:L8")

 

[OilEconomist]

Thanks in advance for your assistance. I have just excerpted the part of the code that causes issues. Why am I getting a "Run Time error '1004': Application-defined or object-defined error" for this line of code:

Set LoopRng = Range(Cells(8, ColNoStart), Cells(8, CoNoEnd))

in the following code:

Sub RngError()

Dim ColNoStart As Long
Dim ColNoEnd As Long
Dim LoopRng As Range


ColNoStart = 1
ColNoEnd = 12
Set LoopRng = Range(Cells(8, ColNoStart), Cells(8, CoNoEnd))

End Sub

When I replace that line with the following, it works:

Set LoopRng = Range("B8:L8")

It was a typo. Apologies as I finally figured it out:
Set LoopRng = Range(Cells(8, ColNoStart), Cells(8, ColNoEnd))

Changed CoNoEnd to ColNoEnd