XREPLACE is a powerful find/replace solution allowing for replacing by any or all of four categories, i.e. value and/or count and/or type and/or length; single or multiple elements within each category; and control over priorities of all categories
I developed XREPLACE in response to feedback I...
Hi all
I have been given a workbook to improve the functionality. The main issue is multi user access, the workbook is shared between about 10 users at any one time, all adding data to the same page.
However due to the nature of the running VBA this workbook can not shared in the normal way...
Is there a way to set priorities to macros; that is, can I set a priority on one macro to force it to finish before a command button will trigger another macro?
to further complicate things, I'm using the OnTime command to cause a program to loop itself until a flag gets set by a command...
Hello There,
I am trying to copy and paste conditional formatting from one excel 2007 workbook to another.
I have a line on a sheet where I have created 29 different rules, and have set the priorities accordingly.
I also want to use the same conditional formats on another workbook, but...
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.