passing arguments to subs

How do I pass a variable from one sub to another, I thought the 'ByRef' definition was meant to do this, but it hasn't worked. The CONVERTPATH Sub converts a UNC path to a local drive number and vice versa when it is called from another sub. How do you get the variable 'Path' to be passed...

Hi there, I am trying to make a program which filters out selections based on inputs and in the end, will come back with a list of possibilities (specifically it is for motors so they enter in whatever they would like, RPM or Frame etc.., and then it gets a price). I have 4 comboboxes that are...

Hi There. I have found a sub that will dynamically update named ranges in worksheets. There are two things that I would like to know if possible. First, I would like to know if there is a way to disregard blank cells in that range (starting at A3 that goes to the last row). I am using that range...

Hello All, I am new to Excel VBA and have been trying to code a merge sort algorithm. I actually have two questions. The following code has been adapted from online examples, but whenever I try to run the code I get a compile error. I believe that the way in which I either try to Call the other...