Couple of Simple questions - I hope


Posted by Thxs for taking the time on February 09, 2002 12:10 PM

Question A) Using Replace like to change the "*" to "+"

I have a large spreadsheet with lots of linked formulas
for example. Cells on the other tabs are not relative
=[FileA.xls]A!$E$31*[FileB.xls]B!$D$30/[FileC.xls]C!$X$100
Issue : Each time I try to do it, Excel treats the * as a
wildcard & the formula turns into "=+" . Any tricks to use ?

Question B)
I've seen posting here where folks use the Dim stmt, but
they don't use the "as xxxx" - Just Dim variable.
Does anyone know how Excel intreprets the variable
string, book, etc...

Thxs for help


Posted by Mark W. on February 09, 2002 12:29 PM

Question A: Use ~* instead of * [nt]


Posted by Gary Bailey on February 09, 2002 12:32 PM

A) Use find "~*" instead of "*" if you actually want to find an asterix not a wildcard.

B) Dim without the as bit creates a variant - not very efficient and rarely necessary.

Gary




Posted by Thxs for taking the time on February 09, 2002 4:30 PM

Thxs for the Tips !!!!!!!!!!!!!