View Full Version : Excel Help
- Solved: Saving worksheets as separate workbooks (3 replies)
- Named Ranges (4 replies)
- Solved: Import HTML Query Named range issue (8 replies)
- Return text in cell based on match of multiple criteria (0 replies)
- Building a data base from Real-Time Data (5 replies)
- Solved: VBA to delete all "unused" formulas (5 replies)
- Close Workbook and Show Userform (3 replies)
- intra portfolio correlation formula in vba (9 replies)
- Solved: Computing Average Using Offset (1 replies)
- Range that increments column number (3 replies)
- Moving Charts in Excel Worksheet (4 replies)
- Solved: Excel Pasting doesn't align to Word Bookmark (4 replies)
- Solved: Excel in-formula macro help! (8 replies)
- Solved: Close workbook (2 replies)
- help with code for conditional summary sheet (1 replies)
- Sumproduct help (2 replies)
- Default Value in Combobox (3 replies)
- Solved: Error when referencing 3 ranges with a variable (5 replies)
- Solved: Download with UserForm (5 replies)
- usinig netdays in an "if then" code (3 replies)
- Get all cells in a column (4 replies)
- Solved: password recover? (5 replies)
- array sum (4 replies)
- Macro to Protect formula cells (24 replies)
- Solved: Paste on grouped sheets in VB for Excel (33 replies)
- Solved: Blanks and bad characters (3 replies)
- How do I change ?i? as an integer (ie 1,2,3,4?) to ?i? (1-10) with intervals of 0.1? (1 replies)
- Copy data from one workbook to another! (6 replies)
- Solved: Changing the printer designation for each user (6 replies)
- Solved: Creating a data tree in the worksheet (23 replies)
- Scripting dictionary (3 replies)
- Copy & Paste (7 replies)
- Vlookup help (7 replies)
- Provide option to disable macros (7 replies)
- Workbook_BeforeClose and Workbook_Deactivate (1 replies)
- Notepad to xls (3 replies)
- Solved: Workbook Event CODE (5 replies)
- Quick question about Application.GetOpenFilename() (0 replies)
- Solved: assigning values to variable using loops (3 replies)
- Trouble with vlookup (15 replies)
- Excel 2007 Removing a Custom Tab and Ribbon (3 replies)
- Update a cell with another cell (7 replies)
- Create Summary Sheet then export that to a Master Workbook (5 replies)
- Solved: Button Command Challenging (4 replies)
- Template and SaveAsUI (1 replies)
- Macro stops when criteria not met (3 replies)
- Solved: scrollbar.width property problem on other computers (1 replies)
- Solved: count rows excluding header row (7 replies)
- charts and data table (2 replies)
- Any workaround for assigning values to multiple cells by excel formula or function (6 replies)
- Solved: need help with command button (2 replies)
- Calculating Averages (22 replies)
- Excel Custom Properties (5 replies)
- Align a picture in the center of the screen using VBA (4 replies)
- Need help with Button command (23 replies)
- Sharing a Variable (4 replies)
- Urgent - aligning text to the right (1 replies)
- Filter validation list (2 replies)
- Managing large numbers of buttons (23 replies)
- Macro not pasting to correct place (2 replies)
- align email body from excel (3 replies)
- Auto compress pictures (2 replies)
- Consolidating multiple series in worksheet by Date field (8 replies)
- Excel-Access Question (4 replies)
- Code to delete all modules (1 replies)
- Solved: Userform combobox macro to make autosort (7 replies)
- [SOLVED:] VBA function to return hyperlink (11 replies)
- Solved: Alter code to clear contents not delete row. (2 replies)
- Solved: referencing a sheet and cell (2 replies)
- Macro fills in blank cells with formula stops at endrow (4 replies)
- Solved: date and time score as text (2 replies)
- Passing variable to UserForm textbox effort (1 replies)
- Exit sub issues (4 replies)
- Dealing with worksheet insert error (5 replies)
- export excel to outlook (3 replies)
- Addin wants password when exiting Excel (0 replies)
- Transfer Listbox Rowsource to Worksheet Range (9 replies)
- VBA Web query newbie problem (3 replies)
- Solved: N Dimension Arrays (4 replies)
- Please help with the simple loop (4 replies)
- Solved: Error With Code (Compile Error) ~Excel 97~ (2 replies)
- Solved: Passing a variable (1 replies)
- Macro to open workbook read only (5 replies)
- add multiple array to combobx (8 replies)
- Solved: Turning an m*n matrices into m*n rows (10 replies)
- Solved: Extracting Data Based on Date Range (11 replies)
- Solved: Adding only certain values within a cell (6 replies)
- VBA: Insert cells without affecting formulas (1 replies)
- Solved: VBA for Concatenate (7 replies)
- Prevent Save, enable SaveAs with default file name (1 replies)
- Dragging Listbox Items within same listbox up/down (7 replies)
- Moving an Entire Line using ActiveCell.Row (7 replies)
- Solved: Combining macros to open and run on multiple protected worksheets (24 replies)
- Solved: Quit Application if filename is renamed (2 replies)
- VBA Set PivotItem to Not Visible (2 replies)
- Import data (5 replies)
- VBA - Changing SeriesCollection.Values for Line Chart (8 replies)
- Problems running macro from another workbook (2 replies)
- Userform/sheet selection again (5 replies)
- [SOLVED:] Change Data for Chart via dropdown (2 replies)
- Solved: Use Command button to e-mail from userform (9 replies)
- Between --- in excel? (8 replies)
- Solved: Save dates for weekly figures (7 replies)
- Solved: for loop (3 replies)
- pasting range .offset (1 replies)
- limited period (4 replies)
- UserForm (4 replies)
- Working With Multiple Workbooks (12 replies)
- Solved: adding a Month (7 replies)
- [SOLVED:] Wildcards for not contain (4 replies)
- Solved: vba code for adding same row next column if condition met (5 replies)
- Solved: Alter code to only copy values without formulas (4 replies)
- How to identify workbook?s name? (9 replies)
- Solved: Code to find match & remove data from 5 sheets (3 replies)
- [SOLVED:] Use of File Array in Excel VBA (4 replies)
- Need help deciphering code (5 replies)
- Solved: Userform/sheet selection (4 replies)
- Cell Contains Word (5 replies)
- Finding VBA and Function code (3 replies)
- Right mouse click on user form (2 replies)
- Remove Tool Bar in Chart Sheet (1 replies)
- Solved: Writing UserForm data to a Specific cell (3 replies)
- XLS size restriction? (2 replies)
- Solved: How to resolve out of subscript range error? (4 replies)
- Sleeper: Date format and filtering (0 replies)
- How many characters can countif handle? (5 replies)
- scheduling a macro a once a week (1 replies)
- Solved: No warning when overwriting file (3 replies)
- Sleeper: Copy a file (0 replies)
- Shopping Basket Analysis (0 replies)
- Solved: using outlook dialog boxes in excel (5 replies)
- Alternative To ActiveCell.Row (7 replies)
- VBA Coding for function that has multiple Integer Value (1 replies)
- Solved: Applying a countif formula to each section of data in excel worksheet (8 replies)
- Retreiving tab name (4 replies)
- ok (0 replies)
- Solved: Call a Userform when "Esc" key is press (2 replies)
- VBA coding to run macro on multiple files (6 replies)
- DisableAutoMacros when opening Word in Excel VBA (3 replies)
- Solved: save combobox selection to worksheet (7 replies)
- File Save User Form (1 replies)
- Solved: Sorting Cells with Empty Strings (2 replies)
- Solved: printing worksheet (4 replies)
- Solved: Trying to compare two columns (5 replies)
- Create a single .csv from multiple worksheets (9 replies)
- vba excel code to find current dll running (5 replies)
- [SOLVED:] Find row number and pass it to a variable (7 replies)
- Converting XLS file into CSV file (1 replies)
- pivot tables (3 replies)
- Adding Continuous Check Boxes (13 replies)
- Solved: User name (3 replies)
- Solved: CAPS LOCK Balloon Message (8 replies)
- Solved: How do I activate an Outlook dialog box, make selection, then return to Excel? (2 replies)
- Compare and delele cells with equal value (2 replies)
- Solved: Formula for Conditional Formatting (1 replies)
- Solved: Protecting Custom Properties (5 replies)
- Solved: Move rows to new work book based on a cell value. (1 replies)
- Select and copy every second row (1 replies)
- Solved: Passing a module as a parameter (7 replies)
- Paste into a comment box directly from clipboard? (2 replies)
- Solved: Find text & Mark findings (5 replies)
- How to group all sheets by default (2 replies)
- Solved: Copy worksheer to all workbooks in specified folder (2 replies)
- why i am having run time error with this code (3 replies)
- Solved: Hello all, a little help needed if possible... (3 replies)
- Solved: SUMIF "CELL IS NOT NULL" (2 replies)
- Solved: How to capture cell changes (2 replies)
- Solved: Sumproduct problem in table (2 replies)
- Solved: Vlookup Question (2 replies)
- Solved: Adding to values together within a cell programatically (4 replies)
- manipulating userform objects from a code module (4 replies)
- Solved: Chart. Very different value. SpinButton (6 replies)
- Solved: Generating Unique Number ID's (12 replies)
- VBA Excel Project (2 replies)
- match variable with list (2 replies)
- Hide 2 of 3 Pivot Chart Buttons? (0 replies)
- how to eliminate Ist column (0 replies)
- Calender Control (1 replies)
- Solved: Shape colour (6 replies)
- Solved: worksheet buttons (6 replies)
- Solved: Default file (8 replies)
- Solved: fso.GetFile not working! (3 replies)
- Solved: SumProduct (6 replies)
- Solved: Retrieve Outlook Contact Data (6 replies)
- [SOLVED:] Coding alternating blank lines w emails (6 replies)
- Solved: Copy cell range, paste into Outlook Contact Notes (8 replies)
- Solved: Pivot table (XLD) (2 replies)
- Quick Subtotal Question (1 replies)
- Web Toolbar (0 replies)
- need help with coding (6 replies)
- Solved: Macro to close all windows but one (5 replies)
- Solved: erase blanks (5 replies)
- Recommend Books for VBA, Excel, and Access. (7 replies)
- Solved: Copying worksheet formula results to a new workbook. (4 replies)
- How to Format a TextBox bound to a ControlSource? (4 replies)
- Solved: Questions about calling procedures to shorten code (5 replies)
- read only (4 replies)
- Solved: pivot tables (2 replies)
- Need Help sorting Ratings with or without VBA (9 replies)
- Solved: Union Range Error for Pop Up Calendar (4 replies)
- Use a dynamic range in a formula (1 replies)
- Copy Rows from External Data Query (1 replies)
- Cell Format (5 replies)
- Solved: Delete all code after save (3 replies)
- Problem with multiple users accessing same workbook. (3 replies)
- Solved: worksheets function (2 replies)
- Chart (1 replies)
- Solved: copy data from one userform to another (16 replies)
- Running SQL Stored Proc through VBA (1 replies)
- Solved: Edit VBA Code using VBA? (11 replies)
- Solved: Disable Space Bar & Delete button (4 replies)
- Solved: Password Message Box (2 replies)
- Solved: Country Name to stay fixed always in a cell (3 replies)
- Count non empty cells on sheet with hidden cols (3 replies)
- Solved: How do you remove all text after the last \ in a string (2 replies)
- Solved: Application.GetSaveAsFilename question (5 replies)
- process array of excel files not working (1 replies)
- Solved: Sorting Multiple Rows Horizontally (6 replies)
- Solved: None of my buttons work anymore (8 replies)
- Solved: Open Directory Macro (6 replies)
- Issue with deleting adding (2 replies)
- Solved: add to combobox if not already present (8 replies)
- Cell value dependency (2 replies)
- Test if more than one instance of excel is open (8 replies)
- Solved: Criteria needing to match several items (10 replies)
- Replace Cell values (vba) (6 replies)
- Solved: Tricky situation:-Delete readonly folder in vba (4 replies)
- Extra Workbook called Sheet2 has appeared (4 replies)
- color cell depending on input (28 replies)
- Solved: Help for Turning Off Alerts for Missing Addin (8 replies)
- Importing data from visio to excel (0 replies)
- Update Question (5 replies)
- VBA cannot open excel sheet if another excel is open!! (3 replies)
- VLookup macro and variables (7 replies)
- macros can't find macros in personal.xls (8 replies)
- Solved: Update Excel Query Programatically (5 replies)
- Active Cell = Bolding (2 replies)
- Solved: Excel query from foxpro with variables (5 replies)
- Solved: countif (3 replies)
- Solved: Transferring data from one workbook to another (5 replies)
- delete all charts in workbook (2 replies)
- Solved: Removing text from a field (4 replies)
- Solved: changeing background colour of a certain cell (2 replies)
- Solved: IF statements in excel (3 replies)
- Solved: Form Control vs. Control Box control (5 replies)
- Stats in a variable location (16 replies)
- Solved: Number format issue in multicolumn listbox (2 replies)
- Solved: Inserting Picture in charts thru VBA (2 replies)
- Solved: Check box prompt (8 replies)
- copy specific columns from one excel file to already opened excel file (3 replies)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.