View Full Version : Excel Help
- listBox Issues (2 replies)
- Solved: Subsciprt out of Range Error with Mulitple Workbooks (3 replies)
- ReadOnly Column (7 replies)
- Copy to closed wbk (3 replies)
- Solved: Need help with Click Event of OptionButton / CheckBox (3 replies)
- [SOLVED:] More efective sumproduct (2 replies)
- Solved: VBA code to copy rows from one sheet to another based on 2 criteria? (15 replies)
- Apply only the Font part of a Style (3 replies)
- Solved: find blanks= 0 (10 replies)
- Inserting, Renaming and Moving/Sorting Worksheets (2 replies)
- Solved: paste from multi sheets to 1 (3 replies)
- Change the Background Color of button added to worksheet using vba (2 replies)
- Solved: Selecting subtotal and grand total cells only(not entire row) (13 replies)
- Solved: Copying Formula Results (11 replies)
- open/activate book and edit without readonly -query (26 replies)
- Word frm to Excel (8 replies)
- Solved: Unusual Error Trap (7 replies)
- Macros match / Lookup (3 replies)
- Need help clearing (removing) buttons (2 replies)
- Apply macros on filtered columns (2 replies)
- Solved: Where to put additional code (11 replies)
- Loop into Excel (6 replies)
- Error when Export data into Excel (1 replies)
- Solved: Get values from cell with VBA (3 replies)
- Lookup Nth occurrence: cells formats (6 replies)
- Solved: Code Select Sheet & Range single step (2 replies)
- Help with macro to copy and paste based on formula result (5 replies)
- Insert Photo in Cell, using Userform (3 replies)
- Solved: Command Button Naming (3 replies)
- Solved: calculation (2 replies)
- [SOLVED:] Opening another file with title equal to a cell entry (2 replies)
- Solved: Loop through sheets (6 replies)
- Solved: Moving data to a Word document (22 replies)
- Transferring data from an array to a range - strange error (8 replies)
- Solved: Updating an access record from an excel userform (excel '97) (24 replies)
- top 5 and top 10 (4 replies)
- Solved: disable calculation (2 replies)
- Solved: Shifting rows to the right. (1 replies)
- Trouble Looping to eliminate multiple data (5 replies)
- Solved: Validating entry on a userform (Excel '97) (6 replies)
- Replace fonction vba (1 replies)
- Solved: How do I copy and insert rows (2 replies)
- How to find an error in my VBA !! (6 replies)
- counting data (4 replies)
- Formatting of data from text file into Excel File. (10 replies)
- days of the week (7 replies)
- code does work at home but not at work >< (1 replies)
- Error Checking for EOF / BOF Debug (1 replies)
- Solved: Show asterisk(****) in password VBA code (1 replies)
- Find function (7 replies)
- Solved: Only save with a Macro Button (2 replies)
- how to use vara function in vba (7 replies)
- Solved: Clearing Clip Art (8 replies)
- Solved: Naming a File (5 replies)
- Solved: Count Files in folder & cell.value=NewFile.Name (8 replies)
- Solved: Error '1004' pops up randomly (3 replies)
- Hide / Unhide toolbars for a particular worksheet (8 replies)
- check for the values in the sheet 2 and count the values (11 replies)
- Solved: Merge Workbooks (6 replies)
- How to automaticlly disable a spreadsheet after a period of time (3 replies)
- Export Problem (2 replies)
- Error: 1004 (4 replies)
- [SOLVED:] Code added by VBA ends up on wrong sheet? (2 replies)
- Solved: Macro will not save (31 replies)
- Deleting all rows of named merged range (5 replies)
- Solved: Convert number to letter (16 replies)
- Last non-blank cell in a row or column (2 replies)
- Pop Messag Box required if value is different (2 replies)
- Updating external reference of a picture (0 replies)
- Hide/Uhide rows without macro (2 replies)
- Dynamic Group by, with Subtotal and Grandtotal (6 replies)
- UserForm;ListBox Select show Picture (7 replies)
- User Form Looping Problem (18 replies)
- Solved: should work but doesn't - application.inputbox problem? (3 replies)
- Unhide based on Calculate event (7 replies)
- Worksheet_Calculate() Multiple Ranges (2 replies)
- Create a working CommandButton in a Userformusing VBA Code (23 replies)
- Macro Help (11 replies)
- force enable macros (9 replies)
- Solved: DAYS360 function within VB (3 replies)
- Basic FTP upload problems please help, kinda urgent? (11 replies)
- Merging text from selected range of cell (16 replies)
- Solved: substitute "." with "" and give format (21 replies)
- Solved: Checkbox with userform (3 replies)
- Solved: Problems with GetOpenFileName (4 replies)
- Solved: But it was working 5 minutes ago.... (8 replies)
- Phantom MsgBox (12 replies)
- Solved: Pagesetup.PaperSize (2 replies)
- side by side stack charts (10 replies)
- Sleeper: Sum rows based on column criteria (1 replies)
- Solved: Excel ShapeRange.Align (1 replies)
- Open all files in a directory and merge to one file (10 replies)
- CASE Statement type mismatch (2 replies)
- Passing a value to another sub routine (4 replies)
- VBA can not use Mshflexgrid.ocx SP6 (1 replies)
- Next With out for error (4 replies)
- Get a value from a cell (3 replies)
- Values used for multiple button clicks (3 replies)
- Solved: copying comments (9 replies)
- Solved: Finding local maximums in same cells on many sheets (21 replies)
- Conditional colouring (6 replies)
- userform toolbox (11 replies)
- row selection (18 replies)
- SUMIF or Vlookup - How to use in with Range Offset (5 replies)
- Solved: UserForm;ComboBox;FilterData (5 replies)
- Solved: Help Matching String Patterns (5 replies)
- Solved: default macro (9 replies)
- Solved: Compare Cells within same row for whole sheet (11 replies)
- Addin References (2 replies)
- value for a specific zip code (4 replies)
- Solved: Linestyle constant values (3 replies)
- excel failed to access some objects. (8 replies)
- macros on web (1 replies)
- [SLEEPER:] The code works, but the address is "WEIRD" (6 replies)
- Select Case with multiple dependencies (2 replies)
- Solved: Unwanted Events firing (3 replies)
- Qty and Time based lookup (2 replies)
- Fit Table content (1 replies)
- Solved: Selecting last row of an active column using a single macro (4 replies)
- Solved: Date Formula (2 replies)
- Solved: Excel generate calendar appointments in Outlook. (26 replies)
- Speeding Up HTML Table Import (2 replies)
- highlighting minimum and maximum values (6 replies)
- Solved: Reversing the order of rows??? (1 replies)
- 'Update Values: datasheet.xls' problem (2 replies)
- Inserting Hyperlink Diagbox Value to Text Box (6 replies)
- select column by referencing column title (2 replies)
- Unable to register/reference DLL (3 replies)
- Solved: User Form question (4 replies)
- Solved: Help with formula please (2 replies)
- [SOLVED:] Shortcut assign (2 replies)
- Set the Workbook_SheetChange to False ?? (12 replies)
- Slow Save, and the File Size Kid. (4 replies)
- On Key events (3 replies)
- Restrict Cell entry to minutes and seconds only (9 replies)
- Automatic alphabetic scrolling in a listbox (5 replies)
- Inserting image to Cell from User Form (1 replies)
- Staff planner- Got more ideas from my employer (6 replies)
- Lock OLE Excel object (VB6) (4 replies)
- Controlling where cursor goes to next after using Enter key (2 replies)
- Updating graphs based on choice in drop-down menu: (2 replies)
- Use SQL to fill Data Valadation list box (5 replies)
- Solved: Active cell highlights row (16 replies)
- "For Each" an endless loop, any better ideas? (3 replies)
- Help to Fix Program in Iraq for Troops (3 replies)
- protecting multi shts with separate pwrds (10 replies)
- UserForm:ComboBox1 select show and change data ListBox and ComboBox2 (6 replies)
- Solved: Emergency...gross margin algorithm! (9 replies)
- Skip Confirmation Prompt while saving Excel file as htm through VBA code (1 replies)
- activeworkbook.name space (1 replies)
- loop through visible pivotfields , copy to new sheet (5 replies)
- Solved: Custom Function for Dups (2 replies)
- [SOLVED:] Blank Cells and Filling Down R[-1]C (9 replies)
- Using LOOKUP in VBA (4 replies)
- Solved: Different Functions In Same Subtotal Row (17 replies)
- Solved: If command (2 replies)
- Count occurrences in specific column (9 replies)
- Solved: Excel 2003 - VBA Userform help (7 replies)
- Challenge manipulate Pivot-table from cell ranges (12 replies)
- How to increase the speed (3 replies)
- copy contents of each Workbooks with Different data ranges from a Single Folder (3 replies)
- Rich Text (3 replies)
- Transfert fron cell with condition (2 replies)
- Solved: Subtotal Method of Range Class Failed (7 replies)
- Rename multiple files (add datestamp)? (7 replies)
- MsgBox and Input Box Macro (6 replies)
- Vlookup result into a textbox - Help!! (3 replies)
- objIE.Document.all("btnEmailConfirmation").Click , 1 (2 replies)
- Combining IF criteria in DO LOOP (3 replies)
- Solved: VBA VLookup Help (Excel '97) (16 replies)
- sh.Name (4 replies)
- sheet and workbook called "ii????.tmp" (8 replies)
- Sleeper: Timeout (3 replies)
- Solved: too many buttons (2 replies)
- Using VBA to sort data (1 replies)
- Command Button to extract data from UserForm (7 replies)
- Put code WS modules not a General module?? (5 replies)
- Solved: VBA Sort using the Left 7 Charaters (3 replies)
- Variable Filename in Macro to SaveAs (3 replies)
- Solved: charts (2 replies)
- Arrays, searches, and replacement (4 replies)
- combobox in an addin (1 replies)
- i have a problem with my user defined class (3 replies)
- Solved: working with Dates (3 replies)
- Adding and removing Excel menu buttons (2 replies)
- Solved: Startup template not used after 2007 Install (2 replies)
- Pivot Table Drilldown (2 replies)
- Solved: IF...Then...Else (5 replies)
- looking up text and cell fomat? (1 replies)
- Vlookup or Match? Copying data from one sheet to another. (5 replies)
- Customising Comments (3 replies)
- Keeping data the way it should be... (23 replies)
- Solved: Indirect using row numbers. (2 replies)
- [SOLVED:] How to hide the sub popup menu (13 replies)
- 1000 row filter (5 replies)
- userform (7 replies)
- Error when file to save is already opened. (3 replies)
- Select a record from a combobox and add data to to the selected record row. (5 replies)
- Solved: Finish Data update before rest of macro runs (6 replies)
- Paste Screenhots (2 replies)
- Please help - writing simple formula in VBA (3 replies)
- Align shapes within cells and fix their position (1 replies)
- Solved: Summary using VBA (3 replies)
- Solved: Help with For Each...Next please (3 replies)
- cell within range reference (4 replies)
- Very Beginner Question Excel 2003 or 2007 (21 replies)
- UserForm ComboBox (4 replies)
- UserForm within procedure - help (1 replies)
- Worksheet macro (10 replies)
- Solved: UserForm Entry Cell to Change Colour (2 replies)
- Multipage Control in UserForm (4 replies)
- Solved: Format Cell Question (1 replies)
- Solved: VLOOKUP Problem formula not vba (10 replies)
- Count rows which meet three conditions ??? (7 replies)
- PDF Printing (0 replies)
- Error 2147417848 (80010108) (3 replies)
- SOLVED: simultaneous searching (26 replies)
- Substitute Macro using a lookup column (7 replies)
- Convert Cols into Rows (9 replies)
- refedit range comparison (7 replies)
- Solved: create multiple folders from worksheet (4 replies)
- New Instance of InternetExplorer (1 replies)
- Solved: If formula result is Zero then Blank (3 replies)
- Copy and paste after looping (7 replies)
- Simple date validation (7 replies)
- Solved: Macro Help (20 replies)
- Button Extraordinaire (0 replies)
- Using a Range name as part of a function (7 replies)
- Big IF Loop Question (8 replies)
- Solved: Saving single page from multiple workbook (4 replies)
- conditional formatting by text colour (8 replies)
- personal.xls (9 replies)
- Solved: Group Data to another Cell (5 replies)
- Copying from one sheet to another and choose samples (10 replies)
- Solved: How do I run a macro in a form module from a class module (23 replies)
- Solved: Why does this not add borders to the textbox added on the active chart? (7 replies)
- Copying data from a series of Excel files. (8 replies)
- sound with vba (6 replies)
- Copy Code from Module2 to Module1 (8 replies)
- Using refedit in named range (6 replies)
- Solved: 12 month Update Code (21 replies)
- Solved: Use named range with combobox (3 replies)
- Solved: Error Handling Question (3 replies)
- Solved: Faster way to Trim() ??? (18 replies)
- Solved: rand numbers (3 replies)
- Delete formulas when unprotect (7 replies)
- Trying to write to embedded OLE Excel sheet in VB6 (1 replies)
- Solved: Copy/Paste cells into new sheet based on value list in 3rd sheet (4 replies)
- Adding checkboxes to forms at runtime (2 replies)
- Conditional Formatting (11 replies)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.