Hi!

The short answer is yes, but how to do it depends on what the formula is
doing.

Post your formula for a more specific suggestion.

Biff

"Ed" wrote in message
...
Hello, Is it possible to have a formula that has a Range for example:
$A$1:
A100, but that I can type the number 100 in a special cell and the formula
takes the value from that cell?

,thank you