VBA if statement only on cells that contain a formula starting with "c:\"

[mountainman88]

I have some code that appears to be running pretty well, part of the code loops through every cell in a usedrange and replaces the formula in the cell based on an IF statement. I need the IF statement to be true when the formula text of the cells in the usedrange starts with C:\

I have seen some approaches where a custom function is created and called, and if your solution has this and it's the only option that's fine, but I was wondering if the is a solution that doesn't call a function?

Thanks

 

[6StringJazzer]

It would be helpful to show the code you are using. It is not really clear what is in the cells but I took your description completely literally:

Dim Cell As Range
For Each Cell In UsedRange

   If Left(Cell.Formula,3) = "=C:\" Then
      ' Do what you want to do
   End If

Next Cell