Cell not working with 2 tasks

Greetings to all,

I have an excel sheet where i have 1 collumn where i import data from external txt file.

I have a button with a macro assigned to do it and a graph linked to that column.

The problem is that i what to get max,min and avg of all values from that column but i get an error.

And if i create the formulas first and create the macro to import after it doesnt let me import to that column.

Cant i use that column to do both tasks ?

Hello Rjc,

Welcome to the Forum!

We can answer your question more quickly if you show the formulas you are using, and which cells you have them in.

Thanks,
Leith Ross