PDA

View Full Version : what does ^ mean in the formula



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))

Bob Phillips
07-06-2008, 05:23 AM
Hard to say, because as usual what you post is not making any sense, it doesn't even compile.

In general ^ means to the power of.

Pete
07-06-2008, 05:25 AM
thanks for the feedback..........

i'll take another look

mdmackillop
07-06-2008, 01:56 PM
and please use linebreaks when you post code.