Recent content by kylegjordan

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...

Didn't work. My pagebreaks aren't being set and excel still insists on adding it's own pagebreaks. Thanks though. kj

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...

if the vlookup formula is in the actual cell then you can change that formula to read: =if(vlookup(arguments)="#N/A",0) no need for the "otherwise" comma

i think you have to have certain add-ins, which i can't locate. vbcomponent object; codemodule object; vbproject object are add-ins that are probably necessary. if anyone knows how to access these, please let me know. kj

thanks segmentationfault. i will definitely test this out.

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...