After I opened a textfile with a macro I place a formula in row 2 of a colunm
then do an autofill down the column. The "isref" error appear however where
ever a group of data change. I tried numerous formulas [IF(,,)] but the
"isref" appears at the same rows everytime.

That could be because the cell is formatted as text, first change the cell to
general and then key in your formula, you may want to do a Replace of the =
sign for another = just to get the cells to refresh the formulas.

Michael Arch.
Please rate this posting if helpful



"Brian Jones @ Belhar SA" wrote:

After I opened a textfile with a macro I place a formula in row 2 of a colunm
then do an autofill down the column. The "isref" error appear however where
ever a group of data change. I tried numerous formulas [IF(,,)] but the
"isref" appears at the same rows everytime.