VBA newbie here. I'm starting with a single workbook that has 2 sheets. With this, I'm trying to figure out code that would accomplish the following on execution:
Create an Array with n elements, where n is the number of Unique Strings found within the Cells in Column B (excluding B1 and...
Hi All,
So to give some background, i have a large data set (60k plus rows and 90 plus columns) that i need to filter and create a new workbook using specific columns.
The size of the file changes daily, and columns are taken out and added. So i had to keep updating the previous macro i had...
Hi
I have this save button, that saves:
3 sheets into pdf
4 sheets into a new workbook (xlsm)
1 sheet into a new copy inside the workbook
My problem is if i want to save the sheets again it dosn't overwrite the old one.
So my question is how to change the code so it overwrite existing files...
Hi Guys,
I have some code that copies some columns of data based on the text typed into an input box. Code below is working great.
What I would like to achieve if possible is 2 more input boxes asking for the destination workbook name and also the sheet name within the destination workbook...
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.