Afternoon all,
I am trying to copy cells from a specified sheet from a specified workbook.
In order to do so, the file directory and sheet name are being saved as the variables File and MON respectively.
This is how the code would work without the variables;
however when I try and put variables in, it won't work;![]()
"=TRIM('[filedirectory]sheetname'!A1)"
Anyone have any ideas??![]()
"=TRIM('[" & File & MON & "'!RC)"
Bookmarks