Hi, I try to copy column from a workbook to another one(The first one is not open, but can be opened if needed, and the second one is where my macro would be).
I get the path to my file from a function(Which return a String) bc the file is often updated(That part work with no problem). The problem I have is that no matter what I try, I can't find a way to make it work, I always end up with a "Out of Range" error...
I get the path to my file from a function(Which return a String) bc the file is often updated(That part work with no problem). The problem I have is that no matter what I try, I can't find a way to make it work, I always end up with a "Out of Range" error...