Recent content by camylarde

NickHa, thank you very much, your advice was correct. Making the variables public and putting them to module header solved the problem. Altough I now was able to turn the periodic recalculate on and off based on teh user presence in teh workbook, still excel had various issues when user...

Hello, I have a problem to have a sheet periodically recalculated every minute. I have a simple procedure that calls itself every minute that goes basically like this: Public Sub Recalculate(ByVal IDcko As Integer) Calculate RecalculateTime = Now + TimeValue("00:01:00")...

Hello fellow programmers, I am fighting with the following problem, that is testing my knowledge onto how to select various cells beyond limits... I have an excessive macro code that tries to reestablish formatting in a sheet in case users will change it (and they will unforutnately do as...

Trevor, i couldn't reply earlier, didn't have access to the linked data for reference for some reason. The code I'm using is as follows: How to send Lotus Notes mail messages with Microsoft Visual Basic The following Visual Basic code will send a Notes e-mail message. The code...

Hello Trevor, thank you for the code, it seems friendly enough for me to work with the attachments. I have a major problem, and two minor questions. 1) If i want to structure the body text, can I use multiple Call Body.APPENDTEXT("Body text here") lines to form the paragraphs? Will...

Hello, I have a macro that combines 4 different workbooks and produces two workbooks as a result. They need to be send to fixed recipients in an email as an attachment. Can somebody tip me onto how to create an email in LOTUS Notes using VBA macro that would contain these files? I need...

Hello, I have a macro that runs when a certain cells change, I was wondering how to run this macro from my other macros in the modules as well, if i need it. How would a syntax look like if i need to pass over some variables to it? Also, is there a type of variables that acts globally...

Youre quite right, altough i felt the block is just a part of the range occupied by the entire list, it still is a range. Anyway, I've solved the problem yesterday and the final formula should look like this: {=AND(IF(SOURCE!C11=OFFSET(SOURCE!$C$1,RESULTS!B11-1,0,RESULTS!C11-RESULTS!B11+1,1)...

Hello, I have a dynamic list of data that contains dynamically sized blocks that i need to search within. Its a list of orders, and comprises of all the items purchased within the orders. I am able to find the start of each particular block, and also the end of it. In an order, it is...

I am not sure exactly what you ment, but I've tried to add set into the command line, with no results. I've narrowed the problem rather to something more fundamental than the syntax itself. Instead of my selection code, i simulated only a portion of it, and still got error after...

Hello, I've been battling with following problem: How to copy filtered data from a column into a different sheet using excel vba macro? The in depth problem is this: Column D is fed with a formula, the formula is then copypasted as values. Range("A1").Select ActiveSheetRowCount =...