- Item way of thinking as alternative to conventional row column looping. (8 replies)
- Position that light grey Boarder line anywhere in the VB Editor (0 replies)
- Recursion Procedures in Excel VBA. Recursion technique in coding (8 replies)
- VBA Range.Sort with arrays. Alternative for simple use. (23 replies)
- "What’s in a String"- VBA break down Loop through character contents of a string (26 replies)
- ExtendingInsensibility into Code modules. Copy table contents to VBIDE VB Editor code modules. .. (8 replies)
- UDF that can change values in cells other than the cell in which the UDF is used (10 replies)
- WithEvents of Excel.Application Events (8 replies)
- Class Stuff: VBA Custom Classes & Objects, Class Modules (29 replies)
- How to Use the AutoSum Function in Microsoft Excel (0 replies)
- Excel VBA comma point thousand decimal separator number problem. (2 replies)
- Showing progress bar in a status bar :) (0 replies)
- Unpivot Columns in Excel (4 replies)
- BBCode Table (61 replies)
- Remove a particular legend from a Chart using VBA (1 replies)
- A Blinking Christmas Tree (0 replies)
- Summary Of Maximum Rows Used Across Each Sheet In A Workbook (9 replies)
- Date Format Issue When Regional Language Setting Changes And You've Used TEXT Formula (0 replies)
- Function Code for getting Column Letter from Column Number (0 replies)
- Create Or Update A Hyperlink Index Of Visible Sheets (1 replies)
- Backup all modules, class modules and userforms to a selectable folder (1 replies)
- Upgrade to LookUpConcat UDF: Search Multiple Criteria and concatenate. (3 replies)
- Status Bar Progress Meter (2 replies)
- Finding Selected Criteria in AutoFilter (0 replies)
- Dynamic Chart That Expands As More Data Is Added (0 replies)
- Office Version Independent Non-Activex Date Time Picker Using Form Controls (0 replies)
- Reverse a string by using array method (2 replies)
- Filter Pivot Table Based On Selected Value And Show All Results Though VBA (4 replies)
- Change Pivot Table Data Source Using A Drop Down List (0 replies)
- Extract Selected Data from Excel - Advanced Filter (2 replies)
- Remove Special Characters From Text Or Remove Numbers From Text (5 replies)
- Retain Conditional Format Color When Copying A Range To Another Sheet Or Workbook (0 replies)
- Loop Through And Delete Multiple File Types In A Folder (0 replies)
- Freeze Time Using Excel Formula To Freeze Date (1 replies)
- Replace Incorrect Date In Cell To Another Valid Date (2 replies)
- List File Names Using Formula (0 replies)
- VLookup Any Matching Word From A Sentence (0 replies)
- Random Unique Number Generator Excel VBA (5 replies)
- Consolidate multiple workbooks from a folder into one master file VBA (4 replies)
- Copy/Paste Excel Range/Chart into Powerpoint VBA (1 replies)
- Remove Unused Custom Styles VBA (0 replies)
- Delete worksheets without loop (5 replies)
- Date & Time Formats in Different Languages (1 replies)
- Number validation in Text Boxes VBA (2 replies)
- Validating PAN (Indian Format) (20 replies)
- Default Cell Format Changed to Date (0 replies)
- Replace Pivot Table Source Range with New Address VBA (1 replies)
- Find Quarter Month From Date In Excel (15 replies)
- VBA Function to Search in Array (0 replies)
- Excel to Excel Data transfer without opening any of the files(source or target) (14 replies)
- Range Difference VBA (2 replies)
- Excel Dynamic Waterfall Chart (2 replies)
- Find Merged Cells VBA (4 replies)
- Spell a Date out in Words (4 replies)
- Week Of The Month (2 replies)
- Split Range into Multiple Columns VBA (3 replies)
- Delete Name Ranges by Scope VBA (0 replies)
- Nth Largest Unique Value in an Array (UDF) (4 replies)
- IIF Function in VBA (1 replies)
- Create Random Number Generator VBA (1 replies)
- Minimum Value Excluding Zero In Excel Range (3 replies)
- Highlighting All the Cells of Active sheet which contains a particular String: (6 replies)
- Get Chart's Source Data VBA (2 replies)
- Checking Table Exist in Access Database or Not (1 replies)
- Upload Excel Data to SQL Table (3 replies)
- Saving Embedded Picture From Excel Workbook Sheet To Folder Hard Drive (0 replies)
- Sort data sheet by right_click of mouse (3 replies)
- Sort Worksheet by Color VBA (0 replies)
- Extract Number From Alphanumeric Text (10 replies)
- Highlight Current Row in Excel (VBA) (16 replies)
- Export data from Excel to Access Table (ADO) using VBA (4 replies)
- On Error Statement (Visual Basic) (0 replies)
- Minimize/Maximize Ribbon using VBA (10 replies)
- Unique Large Values From Duplicate List (0 replies)
- Count words having more than one character in a cell (3 replies)
- List Unique/Common Values From Two Ranges (0 replies)
- Trim all Cells in a Worksheet - VBA (6 replies)
- FindAll Function In VBA (4 replies)
- Learn Excel and VBA - Useful Links (0 replies)
- VBA to Return the UNC(Universal Naming Convention) Path of a Mapped Network Drive (0 replies)
- Lock Cells After Data Entered (4 replies)
- VBA Code to Clear the Immediate Window. (0 replies)
- Rename Filename Through VBA (0 replies)
- Class Objects Created Using the CreateObject Method That Employs Late Binding (0 replies)
- Unique Count on a Filtered Range (0 replies)
- List all Worksheet Names Using Formula (6 replies)
- Delete Names In A Specific Worksheet (0 replies)
- Change Case of Text in Excel (0 replies)
- Add Shape With Hyperlink To Another Sheet (0 replies)
- Pass Values Between Multiple Userforms (0 replies)
- Replace Currency Format From One to Another at One go !! (VBA) (0 replies)
- Count Alpha In AlphaNumeric Text (1 replies)
- Lookup Multi-Column For Unique String Combination For Numeric Value Output (0 replies)
- Formula To Identify A Cell Has Duplicate Words (0 replies)
- Last Filled Cell Having Text (5 replies)
- Open Folder Using VBA (0 replies)
- Search Directories to List Files VBA (3 replies)
- Find Parent Folder From Given Folder / File Path (1 replies)
- VLOOKUP with Multiple Results (2 replies)
- Excel Macro Functions (GET.DOCUMENT) (2 replies)
- Excel Macro Functions (GET.CELL) (1 replies)
- Convert Text In YYYYMMDD Format To Date Format (1 replies)
- FreezePane In A Userform SpreadSheet Control 11.0 (0 replies)
- Number of Days In A Month (0 replies)
- Save Chart As A Picture VBA (0 replies)
- Execute SQL From Excel (VBA) (8 replies)
- Find The Last Entry Row In A Column That Contains Only Numbers (0 replies)
- Count Files In A Folder VBA (0 replies)
- Changing Hyperlink To Another Sheet By Changing Value Of Cell (0 replies)
- COUNTIF on Non-contiguous Range (0 replies)
- Hide Ribbon and Formula Bar (0 replies)
- Add Control to List On Right-Click (0 replies)
- Average Of The X Largest Numbers (0 replies)
- Find Last Used Row In Column (2 replies)
- Finding Last Used Row or Column In Excel Sheet (0 replies)
- Deleting blank rows (0 replies)
- Converting a Column Number to a Column Letter (6 replies)
- Remove Zero / Zeroes From Alphanumeric Text (0 replies)