Forum Discussion
Taking reference of the sheet name (from another workbook) based on the inputbox
How do i reference my inputbox as part of the worksheet name of the destination workbook? Below is the code.. Sub copyandpasteTCA()
Dim ws As Worksheet
Dim Destwb As Wo...
Does the code fail? If so, what is the problem exactly?
, now the code works perfectly. Apologies for the false alarm again. I think unknowingly i could have entered an additional character into the input box. Appreciate the response.