Hi Andrew, thanks for your input. Yes, the v-numbers is always in brackets from the source. I tried what you suggested but it creates a compile error stating "A1" variable cannot be defined. Is your suggestion a function for the spreadsheet side of things? I'll be completely honest, I am not very well versed with the spreadsheet side, I've taken on Excel programmatically, not the other way around. Anyhow, here is the code I am trying to apply this to:

For Each Cell In Application.Workbooks("IndustryPriceIndexCopy.xls").Worksheets("Mthly").Range("Cansim")
    For iCount = 1 To Windows(fName).Application.Sheets.Count
        Set CansimCell = Application.Workbooks(fName).Sheets(iCount).Cells.Find(Cell)
        If CansimCell Is Nothing Then
            Set CansimCell = Application.Workbooks(fName).Sheets(iCount).Cells.Find(Cell.Offset(0, -2))
            If Not CansimCell Is Nothing Then
                Cell.Value =       :confused:'''''''This is where the value needs to change, if need be!'''''':confused:
                MsgBox Cell.Value
            End If
        End If
    Next iCount
Next Cell