Hi guys.
I have stucked on below thing. I believe it's pretty easy, but so far not for me :-)

Below Procedure just adds to column B info based on info in column C. Nothing more and it works OK. Please, is possible to replace For Next cycle I have there with calling another Procedure ? My problem is: if I create new procedure, should I again define all variables there as I did in this procedure below ? Because my For Next cycle works with variable called "range_count". And this variable I got after all another variables were created. My purpose is just shorten below code.
Thanks a lot for any ideas.
--------------------------------------
Sub Makro3()

Dim last_cell As Range
Set last_cell = Range("C99999").End(xlUp)
Dim my_range As Range
Set my_range = Range("C2", last_cell)
range_count = my_range.Count

For i = 1 To range_count
Select Case Cells(i + 1, 3)
Case 678, 702, 806, 846
Cells(i + 1, 2).Value = "NFR"
Case 866, 754
Cells(i + 1, 2).Value = "UKI"
Case 838
Cells(i + 1, 2).Value = "SPGI"
Case 758
Cells(i + 1, 2).Value = "ITY"
Case 693
Cells(i + 1, 2).Value = "CEE"
Case 724
Cells(i + 1, 2).Value = "DACH"
Case Else
Cells(i + 1, 2).Value = "dalsia IMT"

End Select
Next i

End Sub