Profile
Achievement
 
    
                BDOGG32's Recent Snippets
- All /
 « Prev 1 Next »
Calculates the center moving average for a time period.  The vA requires a range or an array of numbers and the iSteps takes the number of periods in the timeframe (4 for quarters, 7 for weekly, ect)
        
        
        
            1 
        
        
            3819 
        
                    posted 10 years ago by BDOGG32
            Two functions that can extract text from a string.  Must have the Option Compare Text at the top of the module.
        
        
        
            2 
        
        
            3536 
        
                    posted 10 years ago by BDOGG32
            Uses regular expressions to do string manipulation.  Enter a regular expression into the required parameter and what you want the manipulation to do and it will process the string manipulation.  For example if A1 contains John Doe1, Jane Doe2, John W...
        
        
        
            2 
        
        
            3568 
        
                    posted 10 years ago by BDOGG32
            Code to turn certain feature off and on for faster running of code in Excel
        
        
        
            1 
        
        
            3871 
        
                    posted 10 years ago by BDOGG32