- Solved: while loop (8 replies)
- Solved: Create access database from excel? (18 replies)
- Solved: Maths symbols (9 replies)
- Solved: SaveAs - Default Name (4 replies)
- Solved: Save before closing workbook. Close workbook, recalculates cells & prompt to save? (2 replies)
- copy line with 2 condition... (1 replies)
- Solved: checking worksheet name in macro (12 replies)
- [SOLVED:] Return contents of row ?4... (5 replies)
- Solved: Using Mid Question (6 replies)
- auto saving using macro (4 replies)
- Solved: Line Graphs Plotting Blanks & N/A (5 replies)
- Read Column B for dates and calculate averages (1 replies)
- Solved: concantonate cells using a loop (8 replies)
- Solved: Returning an Error Indicator in a Function (2 replies)
- [SOLVED:] Declaring Constants (5 replies)
- autofilter copy paste and lookup (11 replies)
- Solved: Force Enable Macros help (6 replies)
- Sample Data Maker (5 replies)
- Solved: Function similar to FACT() to SUM numbers, not multiply (9 replies)
- Solved: Sort range by active column (3 replies)
- Maximum number of characters in cell (5 replies)
- Solved: Send An Email (3 replies)
- Solved: Improve Find Function (7 replies)
- Solved: Automating Outlook 2003 calendar from Excel (7 replies)
- Highlighting alternate rows (4 replies)
- Solved: Find ALL Cell Fill Colors and Make them One Color (7 replies)
- Solved: Not recognizing variable or range? (2 replies)
- Solved: print contents of a list box? (4 replies)
- Changing the length of worksheets name (2 replies)
- Solved: Replace formula with vb event (5 replies)
- [SOLVED:] ******** Instead of Password (2 replies)
- Sleeper: VBA Error message (4 replies)
- Solved: creating a custom toolbar in VBA (3 replies)
- [SOLVED:] Find / Replace with Name Range References (2 replies)
- Solved: Auto-Name a Range (9 replies)
- Solved: Convertiing a Macro to Script (2 replies)
- Solved: What Are the General Rules for the End Property? (9 replies)
- Solved: userform controls (3 replies)
- Solved: Color Coding Specific Cell Value (8 replies)
- Solved: Selection to particular column and 1st avail row (7 replies)
- If Range is non-Existent Then... (3 replies)
- [SOLVED:] Find and Replace marco p Revisited (6 replies)
- Solved: Query a worksheet in excel (11 replies)
- USB Keys (0 replies)
- Calling Macro's (4 replies)
- Selective Deletion of ranges (3 replies)
- Solved: Problem Rewriting a Short Macro (5 replies)
- Solved: Do a Visible and Invisible Graph (6 replies)
- [SOLVED:] Texbox - Numbers ONLY - Date (12 replies)
- Find method problem (2 replies)
- Solved: display msgbox in R1C1 style of C12 (4 replies)
- [SOLVED:] Rename my range name (4 replies)
- Call Function not working... (13 replies)
- Form List box autopopulates doubles entry and wrong columns (3 replies)
- Populate Checkbox Based on Cell Content (7 replies)
- Setting active color of Fill Color and/or Font color tool (2 replies)
- Solved: First available row and clear row (7 replies)
- Lookup / Find / Search values and return same (6 replies)
- [SOLVED:] Open passworded sheet from other sheet in workbook (3 replies)
- [SLEEPER:] Updating Range with Visual FoxPro Array (3 replies)
- Solved: Formatting cell contents (10 replies)
- Moving Horizontal PageBreak (2 replies)
- Solved: Question About For Loop Execution (2 replies)
- Solved: String Concatenation to a cell (3 replies)
- Solved: A short search and copy function (10 replies)
- Solved: Save range to a text file (13 replies)
- [SOLVED:] Naming chart series from a cell value (4 replies)
- Corrupt document? (5 replies)
- Solved: 2 errors to rectify (11 replies)
- Grouping Data into Buckets (9 replies)
- [SOLVED:] Custom Button Maker (3 replies)
- Browse For File (4 replies)
- Run-time error '1004' using PasteSpecial (6 replies)
- On Error Resume Next ? (19 replies)
- [SOLVED:] Date Calculations (3 replies)
- Creating an addin and posting to other PCs (4 replies)
- [SOLVED:] can anyone help me resolve this error (2 replies)
- Best way to do an add/update button. (1 replies)
- Solved: Multi-Line into a cell (2 replies)
- Solved: Functions and formulas (1 replies)
- Solved: Chart-Moving Fails Sometime...Why?? (9 replies)
- [SOLVED:] Identify cells with color fill and borders (15 replies)
- Comparing multiple columns and copying cell (2 replies)
- Solved: "Out of memory" error while renaming module (3 replies)
- Solved: Save data to textfile with " in. (5 replies)
- [SOLVED:] Range with multiple conditions (5 replies)
- [SLEEPER:] Using a loop to set and copy a range (5 replies)
- Delete row on value of active cell and ac offset (1 replies)
- Solved: Extract Data From PDF Files to Excel (22 replies)
- COM add-in as a DLL in VBA (8 replies)
- [SOLVED:] Comments transfer to cells (2 replies)
- Solved: Data Validation Question (6 replies)
- [SOLVED:] Advanced Filter (3 replies)
- Copy Values (4 replies)
- [SOLVED:] Intersect method question (4 replies)
- Sleeper: Tagging a Cell (3 replies)
- Solved: Inserting '-' in cell items (3 replies)
- Collect data and send mail (1 replies)
- [SOLVED:] Could this possibly be a problem in Excel 2000 (3 replies)
- [SOLVED:] Using Union Method (2 replies)
- Solved: Mystery to SOLVED: Forced-in negative value (3 replies)
- [SOLVED:] Converting amounts to fixed-length (5 replies)
- [SOLVED:] Using ADO to copy form a closed WB to a new WB (3 replies)
- [SOLVED:] Cut and paste (8 replies)
- Sleeper: Code to add comment when value of cell is changed (5 replies)
- Solved: Conditional Formatting (12 replies)
- Solved: Refresh date fields on data form in Excel (4 replies)
- Draw Line arrow to Scale VBE (10 replies)
- [SOLVED:] Selecting named columns (5 replies)
- Sleeper: How to assign macros from workbook module to Option Buttons Automatically (7 replies)
- [SOLVED:] How to Construct a Column Variable for Range (4 replies)
- [SOLVED:] Modify Code to Unprotect Workbook Prior to Deleting Worksheet (2 replies)
- [SOLVED:] An Ify statment in macro module (3 replies)
- Sleeper: Match values on multiple sheets (0 replies)
- [SOLVED:] Problem with save (5 replies)
- [SOLVED:] Matching two sets of numbers with duplicates (4 replies)
- Sleeper: Check CC validation (in excel). (7 replies)
- [SOLVED:] Further to previous solved, deleing rows in AN (2 replies)
- Sleeper: Importing a worksheet (3 replies)
- Sleeper: Draw Lines & Arrows UserForm VBE (1 replies)
- [SOLVED:] List Files from target directory thru all subdirs (11 replies)
- Sleeper: Search cells for no Hyperlink (3 replies)
- [SOLVED:] Cannot delete worksheet from userform...Why? (5 replies)
- [SOLVED:] Deleting rows where value in column AN = certain value (5 replies)
- [SOLVED:] Find cell address (2 replies)
- [SOLVED:] Spelling out numbers (7 replies)
- Sleeper: Pivot table showing text values (0 replies)
- [SOLVED:] Using only names found in combo box (4 replies)
- [SOLVED:] Clearing shapes (5 replies)
- [SOLVED:] Translate to Named Range (2 replies)
- [SOLVED:] Can you call a Sub from a Function? (4 replies)
- [SOLVED:] Set multiple Print Areas (2 replies)
- Sleeper: Copy stock symbols from one sheet to another (18 replies)
- [SOLVED:] AutoRunning User Defined Formula (3 replies)
- [SOLVED:] Disallow workbook to be opened (3 replies)
- [SOLVED:] Count item in array (4 replies)
- Sleeper: "statistical" function to randomize.. (1 replies)
- Sleeper: Circular reference in a macro (9 replies)
- [SOLVED:] Separate 2 last digits of a number with comma. (3 replies)
- Sleeper: Printing very hidden sheet? (2 replies)
- Sleeper: Subtotal (6 replies)
- Sleeper: Adding code from XLA to workbook (Excel 2000) (11 replies)
- Sleeper: AutoFilter and criteria inarray (1 replies)
- Sleeper: Find values and copy areas to another sheet (2 replies)
- [SOLVED:] I fell off the truck (3 replies)
- Sleeper: Is there a Calculator user Form such as the Calendar (2 replies)
- [SOLVED:] Input Box text to display Asterisks (*) (11 replies)
- [SOLVED:] Problem with ActiveSheet.Shapes (3 replies)
- [SOLVED:] Array of Controls (3 replies)
- [SOLVED:] Selecting cells off a button (9 replies)
- Sleeper: Update macro (3 replies)
- Sleeper: Follow up question on "Solved" thread (10 replies)
- It's Official (41 replies)
- Sleeper: Recalc cells if macro code has changed? (0 replies)
- [SOLVED:] Web Query To Jpeg w/external VBA/VBScript Code (6 replies)
- [SOLVED:] Number to date (5 replies)
- [SOLVED:] Cannot open file (Error 53) for writing (2 replies)
- [SOLVED:] ExcelDiet (8 replies)
- [SOLVED:] Manipulating a string in the form 11:22:33 (3 replies)
- Sleeper: Display files being searched (1 replies)
- [SOLVED:] Can VBA force an Excel file to open as read/write? (3 replies)
- [SOLVED:] Passing arguments/variables to Forms (4 replies)
- [SOLVED:] Help with percentage formula (2 replies)
- [SOLVED:] Updating Menu (2 replies)
- [SOLVED:] Worksheet Delete event? (19 replies)
- [SOLVED:] Select records that meet criteria in column E (8 replies)
- [SOLVED:] Can VBA do what cannot be done with Advanced Filtering? (13 replies)
- [SOLVED:] Double Lookup Formula (4 replies)
- [SOLVED:] Something wrong with Microsoft Excel Community Newgroups? (3 replies)
- [SOLVED:] Reference to cells (13 replies)
- [SOLVED:] Hidding a row from a function (4 replies)
- [SOLVED:] Count Rows Error (11 replies)
- [SOLVED:] Building a Sickness Spreadsheet (5 replies)
- [SOLVED:] Forced-In negative value (9 replies)
- Sleeper: Conditionnal copying rows (2 replies)
- Sleeper: Treeview selection problem (0 replies)
- log into an internet site (1 replies)
- [SOLVED:] Select from userform listbox (3 replies)
- Sleeper: Input Box - Exit Sub on Cancel (7 replies)
- Sleeper: Pivot Tables (1 replies)
- Sleeper: Cant get this code to work (5 replies)
- Sleeper: On date account (0 replies)
- [SOLVED:] Divide and place remainder in separate cell (2 replies)
- [SOLVED:] Macro to write code INTO the VBE (7 replies)
- [SOLVED:] Play Movie in Excel (9 replies)
- Solved: select a cell and filter data automatically (15 replies)
- [SLEEPER:] Remove hyperlinks (5 replies)
- Sleeper: Exporting data from Excel into MS Project (3 replies)
- Sleeper: Address from global and contact list in text box (0 replies)
- Sleeper: Moving cotents of a cell (4 replies)
- Sleeper: Result a search in a list box function (4 replies)
- Sleeper: Excel Macros (3 replies)
- Sleeper: Cancelling a browse box. (1 replies)
- [SLEEPER:] Unchecked' references (9 replies)
- Sleeper: How to add a formula on one row directly below a pivot table? (5 replies)
- [SOLVED:] Sheet1(MyTab) (9 replies)
- [SOLVED:] Workbook Activate vs Select Revisited (3 replies)
- Advice: Tony Jollans' Clipboard Article (4 replies)
- [SOLVED:] Can you password protect the macros (4 replies)
- Sleeper: formula calculate time (3 replies)
- [SOLVED:] Pass Variables (3 replies)
- [SOLVED:] Retrieving old Target Value (1 replies)
- [SOLVED:] If data entered then prompt (2 replies)
- Sleeper: Troubleshooting Add Command (2 replies)
- [SOLVED:] Macro or conditional formatting??? (1 replies)
- [SOLVED:] Excel - XP - Ping (26 replies)
- [SOLVED:] Deleting from tree view (2 replies)
- [SOLVED:] MsgBox text...bold??? (3 replies)
- [SOLVED:] Dynamic Combo Box (5 replies)
- [SOLVED:] Conditional adding to a tree view (1 replies)
- Populating a LISTBOX based on sheet name (43 replies)
- Sleeper: VBA Function to total expense (4 replies)
- Sleeper: Macro to print area problem (3 replies)
- Sleeper: Selecting row through active cell (10 replies)
- [SOLVED:] I need Help with format date and data (11 replies)
- [SOLVED:] Help with required entry before copy macro works (3 replies)
- Sleeper: Checking for ColorIndex following Conditional Formatting (5 replies)
- Sleeper: InputBox Error (7 replies)
- [SLEEPER:] Probleme with the position of values (0 replies)
- Sleeper: Copy worksheet (0 replies)
- [SOLVED:] Move Cursor in Text Box (2 replies)
- [SOLVED:] Modified Move Files from one hard drive to another vba (8 replies)
- Sleeper: Using Userforms (5 replies)
- [SOLVED:] Listview (9 replies)
- [SOLVED:] Input Box problems (20 replies)
- [SOLVED:] Multiple Instances of Excel (7 replies)
- Sleeper: DateTimePicker Control not displaying (2 replies)
- [SOLVED:] Finding 1st NonBlank Char in String (3 replies)
- [SOLVED:] Copying merged cells (2 replies)
- Sleeper: Function Question (12 replies)
- [SOLVED:] Deleting a sheet without a prompt (2 replies)
- [SOLVED:] How to launch a procedure on one another sheet? (9 replies)
- Solved: Methods to update an add-in (28 replies)
- Sleeper: Deactivate workbook after 3 login attempts (7 replies)
- [SOLVED:] Exporting VBA Modules (3 replies)
- [SOLVED:] Writing to an xlveryhidden sheet (7 replies)
- [SOLVED:] Trim? (5 replies)
- [SOLVED:] etting VBE Options Programatically (9 replies)
- [SOLVED:] Protect Sheets But Allow Data Entry From UserForm (16 replies)
- [SOLVED:] Outbox Outlook (9 replies)
- Excel to Word Label Mail Merge (6 replies)
- Sleeper: Problem with changing filenames (2 replies)
- [SOLVED:] Importing Sheets (3 replies)
- [SOLVED:] Select listbox item on userform through vba (4 replies)
- Sleeper: Search Function Problem (5 replies)
- [SOLVED:] Delete a folder (1 replies)
- [SOLVED:] Add-in for stock price update (3 replies)
- [SOLVED:] Copy InputBox (5 replies)
- [SOLVED:] Populate Combobox with Named Range (6 replies)
- [SOLVED:] Copying a workbook to selected folder (8 replies)