Axolot Data

I found my solution.. I had two issues... I was using a dynamic array of TXLSCellType to save me time when checking if the items in the rows were formulas or not, so not doing the same thing over and over.. However it was causing a memory issue, and corrupting a small string function I had where the...

Hi, I am doing some evaluation at present to see if I can an automate an excel workbook. In one workbook I have values that are being populated from another sheet using =INDIRECT("kpitrend!D"&COLUMN()) (Where kpitrend contains values...) I have been able to use copy column to achieve w...