View Full Version : Excel Help
- I want 'sum', not 'count'... (11 replies)
- Sleeper: Pivot table Refresh (1 replies)
- Solved: re-using macros and pivotTables (3 replies)
- Solved: Generating Payslip (11 replies)
- Solved: (c) copyright - anyway to stop this (3 replies)
- Problem launching Excel using code (14 replies)
- Import data from selected sheets of other wb (0 replies)
- Protection - Trial Version (5 replies)
- find, copy, delete, paste (13 replies)
- Copy Named Range (5 replies)
- [SOLVED:] Structure Suggestions? (13 replies)
- Closing Excel (2 replies)
- Solved: Skip Missing Worksheets (6 replies)
- Clear protected cells (4 replies)
- Overcome Excel "Save as" (2 replies)
- Excel Outlook Files (1 replies)
- shift on copy or paste (3 replies)
- Solved: Group rows (12 replies)
- Use of Randomize statement (3 replies)
- Help needed with excel macro problem! (17 replies)
- Solved: Fill Color issues (6 replies)
- file rename in vba (2 replies)
- code for inserting & Copying rows (12 replies)
- Continually check for next row, or check once & increment? (1 replies)
- Calculation based on 2 different columns and 3 different rows (15 replies)
- how to copy 2 sheets from a ws to another ws (3 replies)
- Losing last line when readig ASCII file into Array (6 replies)
- Solved: Loop to check numeric in userform textbox (4 replies)
- Solved: How To Find Text In Excel 2007 Binary Saved Workbooks... (6 replies)
- Compile Error in MS Excel 2007 (1 replies)
- Excel VBA (9 replies)
- Adding a menu to 2007 (3 replies)
- Solved: optionbutton to set commandbutton focus (2 replies)
- VBA Converters for Excel 95 (2 replies)
- macro & vlookup (0 replies)
- Formating range of cells (2 replies)
- [SOLVED:] Finding date in a range (4 replies)
- Solved: Multiple Users input updating Master (3 replies)
- Email and Font and color issue (0 replies)
- Why my Excel program doesn't work on other computer? Why? (2 replies)
- Solved: Runtime Error 9 - Subscript Out of Range - I must be missing something... (13 replies)
- Solved: Version control woes (10 replies)
- Solved: Opening a file via macro (9 replies)
- Solved: Add extra characters in all cells in column (5 replies)
- Solved: Do not paste information on hidden row (8 replies)
- Open Print Properties using VBA (43 replies)
- Reading data from a database without putting the value to any cell (13 replies)
- Solved: Find by cell format (5 replies)
- force excel to autosave (1 replies)
- Draw a line (0 replies)
- Userform auto-size (17 replies)
- MSFlexgrid merge cells (2 replies)
- Is it possible to create linked cells/aliases for cells? (5 replies)
- Can AutoFilter work with Colour based selection in Excel 2002? (2 replies)
- Solved: Formula in whole column (3 replies)
- Create on the fly goto sheet form (10 replies)
- Solved: Excel Range for Chart (3 replies)
- Word doc embedded object (3 replies)
- Solved: Error on opening workbook on another computer. (2 replies)
- Solved: Date/time format change with macro... (4 replies)
- Solved: Trying to set a cell color from a UDF _not_ a sub() (8 replies)
- NEWBIE TO EXCEL FORMATTING (2 replies)
- How to tell when the 'Notify' option is selected? (1 replies)
- sever all ties & links (1 replies)
- Solved: Lookup in VBA creating Errors (3 replies)
- Comboboxes and VBA i excel (3 replies)
- How to specify a formula for a cell? (3 replies)
- Select duplicates rows in a new sheet (1 replies)
- Passing a Parameter from Word to Excel (0 replies)
- Solved: Error Message (8 replies)
- Solved: Run-time error 1004 ... What am I missing? (4 replies)
- Solved: User Id And Time Of Data Entry (11 replies)
- Solved: Code location issues (31 replies)
- Solved: Transparent Toggle Button (15 replies)
- select issue (3 replies)
- Delete duplicates and sum values macro (1 replies)
- Trouble Closing File (9 replies)
- Count Values in List, Display Top x (9 replies)
- Solved: Range autofill (2 replies)
- VBA Code for Excel sheet access denied (4 replies)
- Solved: Another userform problem - frames (2 replies)
- Solved: User Form (9 replies)
- Solved: User form problem (9 replies)
- Transforming a doc content to Excel Table??!!Help! (1 replies)
- Solved: File Property (2 replies)
- Solved: Put cell values into array (6 replies)
- Solved: Delete row if object NOT found (18 replies)
- Options for triggering macro? (5 replies)
- make the characters in password entry "*" (1 replies)
- How make ?hint? to every picture (as button) on Sheet? (1 replies)
- Solved: Input box - force certain no of characters? (5 replies)
- Grocery lists (9 replies)
- User Form HELP (2 replies)
- Solved: User form numeric value (6 replies)
- Copy / Paste down (16 replies)
- Need macro to delete module content (2 replies)
- Open a file (2 replies)
- If Loop to paste (4 replies)
- how to change column width (4 replies)
- Solved: Vlookup returning all but one value?? (2 replies)
- Solved: Compare multple value (2 replies)
- Solved: Make range dynamic?! (3 replies)
- Sum (9 replies)
- Solved:Error when no comments found (3 replies)
- How to separate words in a cell (2 replies)
- Install addin through code (18 replies)
- Solved: MsgBox appears only once (2 replies)
- Fill Column According to 2 Criteria (6 replies)
- [SLEEPER:] Translating languages with vba (1 replies)
- Solved: How to select top three visible results? (7 replies)
- Macro to tel user new data has been added (6 replies)
- Solved: Create short name (2 replies)
- Solved: Open pdf file into Excel (2 replies)
- Solved: Convert with INDIRECT function (4 replies)
- Solved: Get functions list in Worksheet (5 replies)
- How to enter a formula in Excel via VBA .Formula properity? (1 replies)
- Arrays, one works one doesnt. (0 replies)
- Solved: Solved - Help to build a function to detect Captial Letters in a Cell (4 replies)
- Formula / Memory Limitations? (4 replies)
- mail a workbook (4 replies)
- activate original window at end of macro? (4 replies)
- Solved: Preserve sheets before Macros Runs (6 replies)
- Solved: Zoom and Setting Column Sizes (23 replies)
- Excel select data from mess (6 replies)
- Solved: hide/unhide rows based on value of target cell (2 replies)
- Solved: Delete information in a cell which also exist in another cell (5 replies)
- [SOLVED:] Factorial Subroutine (7 replies)
- Arrays and Accessing Elements by Index (4 replies)
- Select first Item in Listbox (19 replies)
- check credit cards (4 replies)
- Solved: a "Sorting" Macro (16 replies)
- Solved: repeat macro set number of times (4 replies)
- fill down code help (4 replies)
- Worksheet with alternative calculation methods (7 replies)
- Sleeper: US UK Date format issue (1 replies)
- Solved: send email from Excel with cells as body (2 replies)
- Text box/userform - 2DP? (2 replies)
- Quirk with Cond Formatting? (9 replies)
- Not able to enter a formula in a cell (3 replies)
- Custom validation (2 replies)
- Solved: Copy worksheets with msg box (3 replies)
- Solved: How to unprotect sheet in Excel in other program? (2 replies)
- [SOLVED:] Scroll Sheet Whilst Userform Active (7 replies)
- Solved: SELECT CERTAIN COLUMN BASED ON IF DATE BETWEEN (1 replies)
- For Each / Next Problem (4 replies)
- Solved: How to find the same numbers between two numbers (10 replies)
- Save some sheets with name (7 replies)
- How to add items to a combo box upon start? (6 replies)
- Text to column with line breaks (3 replies)
- find a way to copy link (0 replies)
- Solved: Counting colors (9 replies)
- Eliminate noise in data points (1 replies)
- Accessing a control in another (non-Office) application (13 replies)
- Solved: VBA formatting (5 replies)
- Solved: Highlight Row Based on Column Criteria (2 replies)
- Using XMLHTTPRequest within Firefox (4 replies)
- Solved: Problem with macro containing Vlookup - error handling?? (9 replies)
- Urgent help in VBA for averaging data (9 replies)
- Solved: Menu maker (32 replies)
- Changing Printers and page sizes in Excel (2 replies)
- Solved: .Find for empty string (2 replies)
- Solved: User form- Need grayed-out options (24 replies)
- Find "-n-t" in a string and skip it! (4 replies)
- Alter colour of cell text based on value of cell next to it? (5 replies)
- Solved: Selection of columns and clearing values (3 replies)
- Help programing an Excel Document (26 replies)
- prompt (2 replies)
- Data Extract from CSV File with date filter (3 replies)
- Solved: Is there a faster way to move these cells (5 replies)
- Solved: Split large data in various sheets (1 replies)
- Using option button properties (6 replies)
- Solved: Searching for multiple values within cell (9 replies)
- Accessing a macro in a locked project in another book. (1 replies)
- Delete Hidden Name Ranges (5 replies)
- Solved: Date Difference YY-MM-WW-DD-HH-MM-SS (4 replies)
- Solved: [Solved]Copying contents of textbox to clipboard (3 replies)
- Solved: Variant List (5 replies)
- Solved: Userform With Dropdown Selection (23 replies)
- Solved: Range Select from Found Cell (3 replies)
- Solved: Use Offset to return a value (6 replies)
- Solved: Force characters in text box (6 replies)
- macro - pivot table (0 replies)
- Solved: Extract Excel Files from Outlook (14 replies)
- Confusion about giving a chart a title (7 replies)
- Autofitting columns with a condition (2 replies)
- Defining constants (11 replies)
- Limiting the no of times a macro can run (3 replies)
- Cleaner VBA? - Building Array of Months (Fiscal Year) (1 replies)
- default sort behavior? (10 replies)
- Sleeper: Date Format (8 replies)
- list all excel files in a folder (1 replies)
- Solved: Re-use Automation Object Variables vs. release and re-Create (4 replies)
- Solved: Check Value of Array (20 replies)
- Creating a Master Spreadsheet (10 replies)
- Solved: Protect columnn widths (5 replies)
- CountIF (2 replies)
- Solved: Using Offset w/ rng variable (6 replies)
- code to copy the contents (8 replies)
- Using variable to define a range (8 replies)
- for....next (4 replies)
- wipe up MACRO code when WorkBooks Expire (5 replies)
- forms & multipage forms (3 replies)
- Solved: With-End With problem (9 replies)
- Solved: deleting rows again (3 replies)
- Auto SAve (2 replies)
- Copy & Paste ranges from multiple worksheets (3 replies)
- How to select & open latest time stamp workbook (1 replies)
- Formula from VBA doesn't work (8 replies)
- Option Buttons (2 replies)
- [SOLVED:] forms and modules (18 replies)
- Looping a macro to run at each change in variable (4 replies)
- Excel can't find path (2 replies)
- 2nd persistant messagebox occuring (4 replies)
- [SLEEPER:] Filldown a vlookup with no fixed start point (11 replies)
- Subscript out of range (4 replies)
- Solved: Class Modules?? (7 replies)
- Error Msg: vba code execution has been interrupted (1 replies)
- Solved: finding last row w/ (xldown) (6 replies)
- MsgBox (16 replies)
- Code in IE's Close event (5 replies)
- Pivot Table Group Months Year (1 replies)
- Solved: Extracting cell addresses from a formula (4 replies)
- Copy Data from Excel to Access, via Excel VBA (8 replies)
- formatting & updating a group textboxes (24 replies)
- Solved: Quickie- Explanation Properties/Objects (6 replies)
- Solved: Format(i, "00") works in 2003, bad in '07 (4 replies)
- Data Distribution (1 replies)
- Solved: Trigger a Macro with a hyperlink (2 replies)
- sum visible cells (10 replies)
- Solved: I can?t copy formula as text from one sheet to another. (9 replies)
- Percentages (3 replies)
- Solved: Copy column "A" to column "Q" (3 replies)
- Code Change (5 replies)
- Solved: What data type is this? (7 replies)
- Solved: Complicated calculations (9 replies)
- Solved: line continuation on formula? (11 replies)
- Row Delete (3 replies)
- formatting cell or using functions to remove text from cell A into cell B (7 replies)
- Show and Hide Label (2 replies)
- Learning VBA - is this a good starter project? (6 replies)
- Find last row, Offset (9 replies)
- Error Handler (4 replies)
- Solved: Delete same row from multiple sheets (7 replies)
- set range conditional on the numbers of rows (1 replies)
- Memory issues (#7) (27 replies)
- OptionButton madness... (5 replies)
- Solved: MisMatch error on joining two statements (2 replies)
- Problems using if-then in direct window (15 replies)
- Exit Sub w/out Error when Cancelling Routine (3 replies)
- Solved: Sum Function (6 replies)
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.