Pete
07-06-2008, 05:17 AM
Hi
Can someone explain the syntax involving ^ and what it means?
Replace("=(('Pricing Demand'!^1" & startrow + 1 & "*'Modelling (Vol)'!^1" & startrow + 1 & ")", "^1", Mid(Cells(1, curCol).Address, 2, InStr(2, Cells(1, curCol).Address, "$") - 2))
Can someone explain the syntax involving ^ and what it means?
Replace("=(('Pricing Demand'!^1" & startrow + 1 & "*'Modelling (Vol)'!^1" & startrow + 1 & ")", "^1", Mid(Cells(1, curCol).Address, 2, InStr(2, Cells(1, curCol).Address, "$") - 2))