Forum Discussion
Need help about UserForm
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 reso...
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.