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
VBA Code:
Sub Select_logic()
Dim myRng As Range
Set myRng = Range("C4", Range("c" & Rows.Count).End(4)).SpecialCells(xlCellTypeFormulas, 2)
myRng.Select
End Sub