Working code on my machine is returning out of range error on another machine.

Hello all,

I have written a piece of code which opens a number of txt files and extracts information from them.

My code works like a treat on my machine but when a number of my collegues use it, it returns a subscript out of range error (Error 9) when attempting to assign a string (found in a cell) to a defined variable. The peculiar thing is that all the machines are running Excel (2007) off a Citrix server.

Below is the line of code which shows the error:

Please Login or Register  to view this content.

I am writing code with option explicit on, so all variables are defined.

I have also tried referencing the cell absolutely (ommiting .Range("A2") and changing it to .Cells(TxtCycle +1, 1) ) but it still returns the same error.

The only differences I've found between computers is:
My machine - Windows 7 64bit
Collegues machine(s) - Windows XP 64 bit (error), Windows 7 64 bit (error) and Windows XP 32 bit (worked).
But since Excel is being run off citrix I don't see how the machine opp system could effect the way the code runs.

Thanks