I created a user form with a list box and two command buttons a few months back. I recently have decided to resize it. When I do so in the user form window, the new size dimensions work when the form is called.... up until the point where I save the file. After saving it goes back to the...
When a range object is created and it refers to cells on a worksheet, can it be used as the values for a data series in a chart that is its own separate sheet?
Below is a section of a sub I'm trying to debug. The purpose is to add a new data series to the chart entitled...
I'm trying to add page breaks above rows meeting a certain condition and are identified by a for-next loop with an if-then statement that confirms the. This means that the "worksheets.rows().pagebreak = xlpagebreakmanual" uses a variable for the rows argument (code below). Not only...
Is it possible to write a procedure that removes specific code/other procedures within the same project when called or run?
I'm designing a tool in Excel for my sales team that has functionality for use by our reps, but won't be used by the client to whom it is sent. Before it is emailed to...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.