thisworkbook.sheetsmenu

  1. D

    Copy paste in VBA only copying last set of data

    Here is my code I am simply trying to copy data from worksheets whose page name must initially be looked up (VLOOKUP). I have a total of 42 dropdown boxes that link to sheet names that are to be added to the list. I am fairly new to VBA and I can only get the last .copy to work. below is my...
    • DylanMa
    • Thread
    • a.endxlup.row range set thisworkbook.sheetsmenu wksdst.cellslastrow
    • Replies: 2
    • Forum: Excel Questions

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top