Depends what you mean by "physically change the worksheet"

If, by that phrase, you mean your example of inserting a row, then, yes, you
would need VBA.

It's hard to give you a better answer than that without you giving us a
specific example of what you're trying to accomplish.

Dave
--
Brevity is the soul of wit.


"WRM" wrote:

I know how to use IF statements to have do calculations or insert text or
numbers based on whether the IF statement is true or not. Is it possible to
construct an IF statement that would physically change the spreadsheet? For
example, IF <something is true insert a row? Or do you have to get into VBA
to do things like that?