Re: why>?

aaron.kempf@xxxxxxxxx wrote...
....
you are missing the point.

what choices do you have to update formulas?? find and replace?
what if you need a subquery in order to find out what the formula
should be?

Unlike you, I recognize the advantage of using VBA at least for
building and using development tools. I have a search & replace macro
that uses WSH regular expressions, which means I can tokenize formulas
OR text constants with no ambiguity to whatever detail I need. Using
regular expressions, I don't need 'subqueries', whatever they'd be in a
spread*** context.

You'd need to be familiar with either EMACS or vi to understand what I
mean.

TSQL is just flat out more powerful.
....

For editing formulas?

with databases; you dont need to have duplicate copies of the whole
data in order to sort in 2 different directions

You don't *need* them in any language, even Excel, *IF* you know what
you're doing. But that excludes you.

i can right-click anything in the db world and go 'sort' or 'sort
descending'
....

Fine. And when would this be useful in spreadsheets not being misused
as databases?

.

Loading