May 16 2022 04:10 AM - edited May 16 2022 03:07 PM
Hi Community
Could you help me please ?
I think that i have an issue in the userform when i click on the first choosenSheet to update variable from 2 another files, no need i think to share to resolve the issue because the error appears when i click on ... No Error appears when i click on the other scripts. the main target of this macro is to update variables from 2 another excel files than generate to .TXT files with updated variables (final updated script for 2 sites A and B).
May 16 2022 04:32 AM
The code fails at the line
Range(Range(chosenSheet), Range(chosenSheet).End(xlDown)).Copy Cells(1, 1)
This line requires that there is a named range whose name is the value of chosenSheet.
There is no named range called FO_18G_R20 (although there is one called FO_18G_320), nor one called FO_32G_R20.
That's why the line fails.