Move to the last cell in a specific column

[sofas]

Hi I have a column with formulas that fetch data from another sheet . What is required is to move to the last cell with a fetched value I tried to put this code but it specifies all cells for me I want to move to the last cell only

Sub Select_logic()
Dim myRng As Range
Set myRng = Range("C4", Range("c" & Rows.Count).End(4)).SpecialCells(xlCellTypeFormulas, 2)
myRng.Select
End Sub

 

[Peter_SSs]

Try

Sub select_Last()
  Columns("C").Find(What:="*", LookIn:=xlValues, SearchDirection:=xlPrevious).Select
End Sub

 

[sofas]

I found this code but it only works when I find text, how can I modify it to work with both numbers and texts?

Sub Select_logic()
Dim myRng As Range
Set myRng = ActiveSheet.Range("C4", Range("c" & Rows.Count).End(4)).SpecialCells(xlCellTypeFormulas, 2)
With myRng
myRng.Cells(myRng.Rows.Count, 1).Select
End With