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