Hi,

I have this macro that obtains values from different sheets and pastes in one sheet called "Lägg in och sök ärende". These values gets copied based on som indata that you insert in a user form, see picture below:

Excel1.PNG

The macro is correct programmed so far but I want it to skip one sheet called "Frågor - sammanställning". How can I write this in the code so that it ships this sheet specific.

And also how can I in Sheet("Lägg in och sök ärende").cell("H15") paste the name of that sheet that it obtains these values from?

Code:

Please Login or Register  to view this content.