I receive "isref" when i do an autofill in a column in Excel
 

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.

I receive "isref" when i do an autofill in a column in Excel
 

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.