The following is just part of my code. i am getting an Error 9: Subscript out of range. I've tried a few things in order to correct this but nothing seems to change it.
r = 2 c = 2
i = 2
LastRowNumber = xlLastRow(Sheets("Data"))
Do While...
I built a function that will pull options from the imported data. Cell B2 will always have the first option box and if there are 25 options they will continue down to B26. The next set of options will be from F2 to F26 then columns J and N depending on how many options there are.
First: How do...
Hi There
I am new to writing macros and having a prolem getting excel to activate a window.
Background: - Excel 2007, Windows XP
I have one file called NEW PB SPREADSHEET 10-11.xlsm with multiple tabs. I want the user to click a button that will invoke the macro. The macro presents the user...
What would be the code in order Excel asks to every user if he wants to activate macros ?
I still know it is possible to configure it un Tools, Security, but more than 50 users in all over the world will use my file. It's impossible the 50 users have the macros activated and I cannot ask to...
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.