Recent content by asa

Thanks Narayan! This is a great community... I'm not doing a lot with Excel right now.. I hope to be around more in the future. Wish you the best and I'll pop in from time to time :) Asa

Hi MerryBerry, A couple unclear points from your question: 1) worksheets don't really have variables 2) the closest thing to a null on a worksheet is a totally blank cell; not even containing a formula, or the cell error value #NULL! which is very rare (I don't think it's returned by any...

Congratulation Narayan. It's what you've learned integrated in your own way, plus your skill at understanding people's problems. And you're very generous. Bravo! Asa

Hi Tom and Luke; Luke I see is providing very thorough help, but would this code snippet be of any value to incorporate? Luke, you said Outlook ignores duplicate email addresses, but if there might be any reason to eliminate duplicates, you can use the following code to do so. One minor...

Hi SirJB7! Happy holidays and new year! Regarding defined names, looking in Name Manager I see you have already defined named for several tables. The Names "TablaClientesProveedores" and "TablaClientesProveedoresNombre", for example, refer to all or part of the data area on the...

Hi Sekhar, Happy holidays and new year! What I was getting at, is that you could use a macro to copy the files based on their filename. As you've indicated, the files are all coded according to their vendor unique ID, so the macro could copy the files into folders according to vendor ID...

Hi, Mark! Happy holidays & new year. Revisiting the prior limitation regarding number of assignments per pay period: The simplest workaround that comes to mind, without making deeper design changes to the workbook, would be to use an INDIRECT formula in the conditional format that would rely...

Hi, smc - Happy holidays & new year! I have some pressing matters consuming my time this season, so I hope you have been able to get any needed assistance from others. You may want to start a new topic if you still need help. You can try to reframe your question if needed, and you can link...

@sirjb7 :) Named ranges can have a workbook-wide context and be valid from any sheet, and they can even refer to other workbooks. The main thing is to pass as parameters all ranges that your function depends on. It would be acceptable without using named ranges, although I see you keep a...

Hi Sekhar, Why not just copy the files to appropriate folders? And why do you need to involve hyperlinks? Asa

The problem with switching workbooks is probably your use of Activeworkbook. In a udf, to refer to the workbook containing the udf, use Application.Caller.Parent.Parent (Application.Caller refers to the cell calling your function and you work your way up the object tree from there).

Hi SirJB7, It seems possible that your code is generating an error & terminating early. Try setting a breakpoint in your error handler to check for that, and if so, use other debugging methods to pinpoint where the error is occurring. re:Application.Volatile, it's required anytime your...

Hi Mark, Hmm... Well, conditional formats override manual formats. So, no. Not without changing the way we format the weekend colors. I've avoided suggesting macros thus far for your requests because they are a more advanced topic and I'm particularly interested in telling you about ways...

Hi Mark, Sorry I haven't been able to get back to you sooner. I'm still pretty busy.. Do you mean you don't understand why the change to C2 was in order? Well, in a conditional format rule, the formula must be written as it should be evaluated for the top-left cell in the Applies To range...

Hi smc, The problem with your problem, as I understand it, is that it requires associating purchase order items with financial accounts... usually a job for accountants, not spreadsheet formulas. If these expenses have already occurred in the past, .. you mentioned in your first post "last...