- Solved: pull excel workbook into excel template (9 replies)
- Solved: Place Date stamp on Chart (2 replies)
- Check Box Formula (2 replies)
- Solved: case to line 1 locks up (9 replies)
- Formatting numbers within formulas (2 replies)
- Solved: Can't loop through worksheets (4 replies)
- Solved: Find column with a value and replace it with another column (5 replies)
- Executing an external application with Excel (1 replies)
- Manipulating Data for Graph creation (3 replies)
- Solved: Odd behaviour of UserForms (1 replies)
- Directory Listing doesn't get ZIP files (1 replies)
- Solved: Proper syntax for writing a user defined function? (6 replies)
- Solved: auto-open and populate (4 replies)
- Filtering and copying (8 replies)
- Currency format from VBA (1 replies)
- Worksheets.Calculate not updating worksheet! (8 replies)
- Colour cell dependent on condition (7 replies)
- Excel - Date formula and Row Highlighting (7 replies)
- [SLEEPER:] Question in logic (2 replies)
- Solved: Enter Formula on Multiple Locations using Macros (4 replies)
- Solved: Teacher needs help in evaluating some simple math text equations (2 replies)
- Button to import cells from another spreadsheet (5 replies)
- Solved: macro to convert all txt files in a folder to excel files (11 replies)
- Solved: Moving Data (12 replies)
- Solved: Teacher needs help in randomizing an answer into one of 4 multiple choice columns (12 replies)
- Modify default size of insert comment (4 replies)
- Solved: My Userform loading takes time (4 replies)
- Solved: Need to remove duplicates based on date in an input box (25 replies)
- Solved: Macro to Sum 2 cells of the Lastrow on another sheet (4 replies)
- Solved: can anyone see what's wrong with this? (2 replies)
- Solved: VBA to Delete Column based on Header (3 replies)
- Sum amounts of field on multiple records (1 replies)
- Macro only sorts 1 column (4 replies)
- Solved: Merging Sheets of Data (20 replies)
- Worksheet Change - Target Range & changes to more than one other cell (5 replies)
- Solved: Script with cells.find returns wrong values compared to VLOOKUP (4 replies)
- Disable a Checkbox with VBA depending on linked cell (2 replies)
- Macro to run at change of cell value without hitting enter key (5 replies)
- Subtotal, Find Max and apply rules using Macro (3 replies)
- VB code for cell linked to multiple selection list box (1 replies)
- Solved: Sorting a non-active sheet (3 replies)
- Create Workspace issues (1 replies)
- File Details - Need correct syntax (7 replies)
- Solved: Absolute Row, Relative Column Refernce VBA (4 replies)
- Solved: Macro not selecting correct sheet (4 replies)
- Collections Overflow (4 replies)
- Solved: Next without For error (2 replies)
- Solved: Look for word then copy and paste row (4 replies)
- Help needed - Memory leak in VBA script (7 replies)
- Manipulating Plots in Macro (3 replies)
- Solved: Create folder structure (4 replies)
- Allocated Day Off (ADO) coding- VBA HELP (2 replies)
- Solved: Concatention Problem (4 replies)
- Solved: Macro to Insert Entire Rows (20 replies)
- Solved: VBA SQL statement (xl '97) (2 replies)
- Use data in txt file in Case Select statement (5 replies)
- Solved: Loop through worksheet and delete rows inbetween 2 search criteria (13 replies)
- Solved: Removing duplicates from filter (2 replies)
- Solved: Macro to create a Table using individual sheets totals as the input (2 replies)
- Counting business days (4 replies)
- Solved: Toggle:Hide/Unhide Columns on 2 separate sheets (5 replies)
- Solved: VBA -Clearing the dropdown cells (2 replies)
- Solved: function to extract chars from string using VBA (4 replies)
- Solved: Code that runs automatically when a dropdown object selection changes (2 replies)
- Retrieve the Path of MouseIcon Picture (3 replies)
- [SOLVED:] Highlight cells which have no dependents (1 replies)
- Solved: Copy Macro that Won't Copy :( (3 replies)
- [SOLVED:] Colour of multipage headers (6 replies)
- Showing a userform, but not stopping code (3 replies)
- List of Files in Directory - Almost works (7 replies)
- Solved: Insert formulas macro (4 replies)
- Insert multiple rows-Delete Rows with formulas (1 replies)
- accessing outlook global address book (2 replies)
- Multiple GoalSeek macro: Runtime error '1004': Reference not valid. (3 replies)
- Solved: Assistance with email SendTo (xl '97) (7 replies)
- Solved: Combining workbooks then selective worksheets (12 replies)
- Solved: Deleting name ranges (xl '97) (2 replies)
- Solved: Dynamically Expand Validation Dropdown List (6 replies)
- VBA Tab Reference (2 replies)
- Solved: search for string, write coordinate to variable (2 replies)
- [SOLVED:] Conditional statement in a macro (3 replies)
- Importing Recordset to Access? (2 replies)
- Solved: Consolidating & Cleaning Data - Is there a better way to Do it? (7 replies)
- Solved: Compile Error - Variable Not Defined (6 replies)
- Solved: A way to avoid charting blank cells? (2 replies)
- Solved: CopyToRange then delete duplicate (3 replies)
- Data storage problem (4 replies)
- Start Excel 2007 with an empty worksheet (7 replies)
- [SOLVED:] Option Button in a Protected Worksheet (3 replies)
- Solved: Copy paste special different worksheet to Summary (2 replies)
- Solved: Pick email address from cell in workbook (8 replies)
- A Macro to replace a matching row in a block of cells (13 replies)
- Howto repeat/cycle code through all populated cells in column (10 replies)
- Solved: VBA and FTP (2 replies)
- Solved: Insert a column based on columns header (3 replies)
- Validation On Columns (5 replies)
- Business day only (5 replies)
- New worksheet ...help pls (2 replies)
- Solved: Unable to set the property of the Series Class (3 replies)
- Solved: Macro with a Formula to rename sheets (7 replies)
- Email macro failing (1 replies)
- vba cursor in textbox (3 replies)
- find unknown values which adds up to some values (4 replies)
- Solved: Autoconstruct Forecast Formula from Linest function based on number of variables (6 replies)
- Add blank row after each record (7 replies)
- Solved: Unable to delete custom toolbar created in excel 2003. (5 replies)
- Edit Work Sheet Whilst Msg Box Remains Open (1 replies)
- Solved: unload userform before worksheet deactivate (4 replies)
- Excel Advanced Filter (9 replies)
- Solved: VBA to import files to sheets (4 replies)
- Modify Email macro to check cells for entry prior to emailing. (1 replies)
- Macro Idea for find and edit (3 replies)
- Add formula dynamically to different sheets (0 replies)
- [SOLVED:] Transpose data in columns into rows using a primary key (8 replies)
- Solved: Insert-Delete Rows with formulas (16 replies)
- Controlling web checkbox and buttons FORM type POST (1 replies)
- ListBox Objects? (6 replies)
- Solved: Multiple messages boxes (9 replies)
- Solved: format cells based on 2 criteria (4 replies)
- Solved: Run Macro Whilst Editing (8 replies)
- Find certain criteria delete that row and the next 5 rows as well (7 replies)
- Solved: Arrange/Lag Data in columns By Specfied Lags (4 replies)
- [SOLVED:] Select multiple rows based on cell value (7 replies)
- Solved: Merge the Data (2 replies)
- Solved: Auto Update Links on a Mapped Drive (4 replies)
- Solved: Text to Rows (5 replies)
- Solved: Max 2 decimals allowed in cell (15 replies)
- CheckBox code repetition (8 replies)
- Remove or Bypass the 'File Reservation' Dialogue? (27 replies)
- Delete all files in a directory (0 replies)
- Solved: Spreadsheet control 2007 (2 replies)
- Format selected cells within filtered range (2 replies)
- [SLEEPER:] Code Optimization: Running too slow (3 replies)
- Controlling child web pages of pages opened w/ Excel (0 replies)
- Solved: Pivot Table Formulas (0 replies)
- Solved: Excel - Text to rows (7 replies)
- Solved: Execute multiple subs or one large sub (14 replies)
- Subtotal Macro Formula Help (5 replies)
- Solved: footer code error (4 replies)
- Solved: A kind of Back button in sheet for other sheets (8 replies)
- TreeView node images (2 replies)
- Solved: Same cell address on different sheet comparison problems (8 replies)
- RegEx Split String (7 replies)
- Solved: Creating main folder and sub directories (6 replies)
- [SOLVED:] Track Changes in Comment (7 replies)
- Inventory Examples. (5 replies)
- Error handling odd problem (2 replies)
- Compressing VBA Code length (21 replies)
- macro code to switch worksheets? (4 replies)
- Excel error ---------- please help (6 replies)
- problem replacing string by another one (5 replies)
- Checkboxes (1 replies)
- problem writing after last used row (2 replies)
- Solved: Login Screen / Password Call & Validation Issue (15 replies)
- Solved: Can I use a different (closed) workbook for a listbox rowsource? (excel '97) (3 replies)
- calling python from VBA, excel (0 replies)
- finder (9 replies)
- return to textbox (6 replies)
- Solved: Sumif/Sumproduct Across Columns & Rows (7 replies)
- Data validation with dynamic range (3 replies)
- Solved: User Form question (3 replies)
- Solved: Date formatting (5 replies)
- Solved: vlookup and dates (2 replies)
- Modules vanishing - bug? (2 replies)
- Open hyperlink to PDF on website and save file (1 replies)
- avoid "error 400" (3 replies)
- Solved: Stop buttons from printing (3 replies)
- Solved: Create copy of worksheet plus code in the same workbook (4 replies)
- Next Record / Previous Record (12 replies)
- Can this basic code be refined? (4 replies)
- Dropdown Box Loop (4 replies)
- Text strip send (5 replies)
- Multiple files imported to specified tabs script (5 replies)
- Autofilter change (2 replies)
- Solved: enter current time in a current cell (14 replies)
- Solved: object variable coming in lower case (2 replies)
- VBA for MORE Conditional Formating Excel 2003 (27 replies)
- Solved: runtime error 9 when decomposing cells (7 replies)
- Solved: Determine if Userform is Loaded (3 replies)
- Solved: check range of numbers conditionnaly (5 replies)
- Is it possible to store calculation results in VBA Memory? (13 replies)
- creating shared workbooks (excel 2007) (1 replies)
- Solved: Printing Selected xlVeryHiddenSheets (2 replies)
- Solved: Vlookup From Userform (17 replies)
- Complex Lookup (1 replies)
- Solved: working with multiple open workbooks (5 replies)
- sending mails only to filtered persons (2 replies)
- [SLEEPER:] Format Datalabel (1 replies)
- Selecting all sheets but.... (5 replies)
- help in entry in excel access (4 replies)
- Solved: Unprotect Work sheet to allow Macro to run (2 replies)
- Solved: countifs in excel 2003 (6 replies)
- Deleting Rows - Defined Names (2 replies)
- Solved: Delete Spaces in text but not numbers. (5 replies)
- Solved: It sounds simple yet I can not overcome. (3 replies)
- Find Text then insert formula in same row (1 replies)
- Solved: Switching between Multipage tabs (2 replies)
- Solved: open file with a date variable (6 replies)
- Highlighting rows inside first empty cell loop (6 replies)
- Understanding a Function (2 replies)
- Solved: Excel to Word Number Formatting (3 replies)
- Percentile (2 replies)
- HEX file (".bmp") into EXCEL (1 replies)
- userform listbox query (1 replies)
- Autoselect relevant range for Sumproduct function (5 replies)
- Solved: Copy Error creating 35mb file...:( (2 replies)
- Solved: Convert csv file to xls format (3 replies)
- Solved: Generating an email in Excel- adding signature (6 replies)
- Solved: Custom Function to Calculate Response Time (5 replies)
- Send "Enter" to mainframe (2 replies)
- multiple text to excel + filename (7 replies)
- Solved: Pop up message removal (3 replies)
- Relist Column (7 replies)
- Optimization with for each (6 replies)
- Array takes out the parentheses (3 replies)
- Solved: problem filling empty cells (6 replies)
- Solved: InputBox Help needed (13 replies)
- auto addition of gridlines (5 replies)
- [SLEEPER:] Error in Excel 2007 (7 replies)
- Solved: VBA VLookup Problem (Excel '97) (4 replies)
- Solved: Interesting... (2 replies)
- Solved: Perform action based on conditional formatted colour? (43 replies)
- Issues with Hyperlinks (0 replies)
- Pivot Table Count ? (2 replies)
- Excel adds wrong pathname to macro name (4 replies)
- Need Help on Userform (4 replies)
- gsm table (2 replies)
- Worksheet_BeforeDoubleClick question (2 replies)
- Solved: Macro coding help. (2 replies)
- Solved: conflicting vba Button and select change event (5 replies)
- Solved: Aggregate records entered for 2008 (11 replies)
- Solved: Conditionally changing a cell's font colour with a function (7 replies)
- Subtotal Error (5 replies)
- Format output (4 replies)
- Solved: Trapping a FillDown event (3 replies)
- Macros & Input Boxes (8 replies)
- Summarizing from multiple sheets in same workbook (8 replies)
- Delete character in cell (1 replies)
- blank page problem (3 replies)
- macro (2 replies)
- compiled error of "method or data member not found excel". (1 replies)
- Solved: Modifying regex to accept comma's? (4 replies)
- Find Text in a Woksheet (4 replies)
- Copying multiple sheets (2 replies)
- [SOLVED:] Force user to go only to next row in a spreadsheet (11 replies)
- Solved: Dependents and Precedents (12 replies)
- *** Compare range heading and then values in the columns (1 replies)
- How to build a command string to execute (6 replies)
- Userform Contacts. (2 replies)
- Want to create a button at menubar (2 replies)