When you say that you want to devine a range do you mean like this:

1. Get the formula to go to a specific cell or range (ie. A1 or A1:F1)
2. then find where the information in that column ends (ie. go down the column(s) until you encouter a blank cell)
3. then pass this range to the next part of your script (ie. A1:A254 or A1:F254)?