Search results
-
C
Running a subroutine periodically
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")... -
C
Selection based on a variable
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... -
C
Compose an email automatically
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... -
C
Running a macro in the Excel Objects part
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... -
C
Complex search problem using arrays
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... -
C
Copy filtered data from column to a fixed location
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 =...