View Full Version : Excel Help
- Solved: Excel insert rows based on value of previous row (2 replies)
- Solved: How to format columns on 'Workbook Open' (4 replies)
- Cant Shift date problem! (1 replies)
- Solved: Colouring ranges based on data being entered by User (7 replies)
- Replacement of IF function (1 replies)
- Solved: VBA , min of 2 nox , >0 (2 replies)
- Solved: how to sum rows in columns with Sun (21 replies)
- Solved: Drop-down for each cell under a column (5 replies)
- Time Stamp VBA - Need help please! (1 replies)
- Sleeper: Identifying the optimal solution in an array (0 replies)
- Solved: Worksheet_Change and .PasteSpecial (7 replies)
- Solved: Select Date Range (11 replies)
- [SOLVED:] Referencing User Selected Workbooks (6 replies)
- macros language help ? (3 replies)
- Solved: VBA- Smallest non-negative number in a range (12 replies)
- Solved: Controlling Dialog Boxes (7 replies)
- Solved: Which column is the calling button (mostly) in? (6 replies)
- Matching variable formats (0 replies)
- Solved: how to detect when the mouse leaves a control on a userform (22 replies)
- Solved: Adapt code by Tom Ogilvy (0 replies)
- Color Backgrounds for Independant Cells (4 replies)
- Solved: Capturing Error Message (4 replies)
- Implements Keyword in VBA (2 replies)
- Implied Volatility (3 replies)
- Solved: Store values meeting certain criteria and paste them into other area (12 replies)
- Voltage Ramp (6 replies)
- Using Find to Search for a Date (1 replies)
- macro deleting important data in column F:EC (2 replies)
- How to protect Excel Program more seriously? (1 replies)
- Auto shut down of spreadsheet if inactive. (2 replies)
- [SOLVED:] Separate every 3 entries into 2 arrays? (or other solution) (9 replies)
- Solved: runtime error '1004' unable to set the formula property of the series class. (18 replies)
- run time erro 424 (3 replies)
- Solved: Compare two workbooks and count matches (0 replies)
- Populating sheets with data from another sheet (0 replies)
- Solved: formula not changing the row values accorrdingly (2 replies)
- Import data file (3 replies)
- Solved: Excel to Word: A few issues on the Excel part of things (2 replies)
- How to combine 6 different file(but same format) become one (13 replies)
- Solved: Copy Paste Cell Value To Word as Text Only (3 replies)
- Search as You Type ~~ Narrow down List (18 replies)
- Setting checkboxes with Boolean effect (7 replies)
- Disable Copy Paste (7 replies)
- Solved: search for multiple characters in a cell (2 replies)
- For/IF problem (5 replies)
- vb help (7 replies)
- check my code pls (5 replies)
- Need help on loop (4 replies)
- Userforms and Other Excel Application (5 replies)
- Robin Hammond's Progress Bar? (2 replies)
- Solved: Check if 2 Values Exist in 2 Columns (4 replies)
- Sleeper: Do copy macro (5 replies)
- Solved: Ask for values and save as (6 replies)
- Ask for values and delete row (4 replies)
- Solved: Confused about Workbooks object (6 replies)
- Solved: (12 replies)
- Solved: dynamic named ranges (2 replies)
- Copy non blank rows from each workbook in a folder to current workbook under eachotha (1 replies)
- CheckIn, CheckOut API's - general question (3 replies)
- how to run a sumif after formula (5 replies)
- [SOLVED:] Moving rows up and down a table with VBA (9 replies)
- Worksheet Formulas and VBA (2 replies)
- Solved: Scheduling suggestions (13 replies)
- Solved: vba copy function (6 replies)
- Solved: Multipage and combo box (3 replies)
- Solved: Ignore error without converting to number (8 replies)
- Copy 2 sheets to Network and rename (5 replies)
- Solved: Clean up of Custom Menu items (2 replies)
- Solved: OnClick event (2 replies)
- Solved: Merge Data between worksheet (3 replies)
- Solved: Can text be copied out of a cell to another cell? (6 replies)
- [SOLVED:] Help with Case statement (16 replies)
- Solved: Enter today's date based on another cell (4 replies)
- Lock cell after entry (10 replies)
- [SLEEPER:] sum to the last column with data (11 replies)
- Solved: Need help easy formula (5 replies)
- Solved: Looping through a shapes listbox (2 replies)
- Unmerge cells & copy line from above (13 replies)
- Set default save path (6 replies)
- Solved: Find Multiple Entries Then Delete Row (3 replies)
- Solved: duplicate file & strip code from workbook (4 replies)
- Solved: Save and encrypt sheets (1 replies)
- Solved: sort will not sort - why? (7 replies)
- disable print screen (5 replies)
- compile error (4 replies)
- amend formula (2 replies)
- [SOLVED:] Sort Multidimensional Array (13 replies)
- Solved: need to add a macro on save (2 replies)
- Read and Write Binary Registry Keys (3 replies)
- Solved: Using arrow keys to navigate through userform fields (9 replies)
- Solved: Do Loop until rowHeight is between two numbers (2 replies)
- Solved: Copy Paste from workbook to workbook (4 replies)
- Solved: add differenet worksheet names to current macro (3 replies)
- Solved: Workbook_Before Close problem (2 replies)
- OWC Spreadsheet Scrolling (1 replies)
- chart update problem help!! (31 replies)
- How do I "install" custom functions (7 replies)
- automatically scale pivot chart from highest to smallest (0 replies)
- Listboxes - automatically unselecting themselves?! (4 replies)
- Solved: Writing data to a table in word from excel vba (2 replies)
- Help With MsgBox if duplicate range (10 replies)
- Function for of sum of square of mean deviation (7 replies)
- Solved: Delete a specific record from an Excel VBA array? (6 replies)
- Solved: OnExit (4 replies)
- Solved: Set cell value from one workshee equal to found cell in another workbook (3 replies)
- Solved: How to Concatenate Text (4 replies)
- Sleeper: Implied do loop in excel write # statement (3 replies)
- Solved: Filling comboboxes with filtered data (2 replies)
- Solved: Workbooks(NewFN).Close SaveChanges:=False Index Issue (3 replies)
- Solved: Share a workbook without a prompt (1 replies)
- Solved: Unable to connect to Oracle (1 replies)
- CSV Files & Userform Problem (0 replies)
- Solved: HELP with TRIM !! (4 replies)
- Solved: running macro runs the wrong macro (2 replies)
- Solved: Select Checkboxes in Internet Explorer (9 replies)
- Solved: Calculation not working (3 replies)
- VBA Code to pull selected data from a huge database (2 replies)
- Solved: How do I delete code from a sheet module under program control? (6 replies)
- Solved: How to write VBA code to copy data from Word to Excel? (14 replies)
- TextBox to Cell Freeze (2 replies)
- Solved: Is Insert > Name > Create evil? (7 replies)
- Delete Rows Based on Current Date (7 replies)
- Can I edit a source cell from the linked cell? (3 replies)
- CombineFiles - Move instead of Copy (8 replies)
- A 'floating' rounded rectangle (12 replies)
- Solved: VLOOKUP on multiple criteria (3 replies)
- Copy cell from multiple sheets, into one row in one sheet (5 replies)
- Using a worksheet as a database (2 replies)
- Importing tables from multiple HTML files, into one spreadsheet. Please Help (8 replies)
- count shapes (8 replies)
- select multiple areas in a textbox (0 replies)
- Solved: Filling empty cells across workbooks with zero (3 replies)
- Solved: Calculating Height of a range (12 replies)
- Spreadsheet vlookup help. (15 replies)
- Solved: passing data from a list box to a spreadsheet (11 replies)
- Solved: Whats the value of y given X (6 replies)
- If 3 times greater than delete row (3 replies)
- Solved: Referencing using a number for column (5 replies)
- elimanate zero while taking minimum value (11 replies)
- populating a cell with value from another (2 replies)
- Solved: Urgent: Application File Search (11 replies)
- Solved: Iterate through columns (1 replies)
- Solved: Re-start the value if reached a value (2 replies)
- ReDim Question (4 replies)
- ctrl c and ctrl v breaks a merge cell (1 replies)
- Copy Worksheet (3 replies)
- Solved: Open file path (7 replies)
- Solved: IF AND PROBLEM (8 replies)
- Self defined date format [$-130000] (3 replies)
- Solved: Variable Data with Date (11 replies)
- Solved: Month and Day swap places when OK cmd button is pressed (10 replies)
- Solved: Close all but Activesheet (3 replies)
- Solved: Compare date before event execution? (11 replies)
- Solved: An N-by-1 variant array throws runtime error when N gets down to 1 (3 replies)
- Solved: Sort adds an extra line (3 replies)
- Maddening, non-repeatable bug (3 replies)
- Solved: Exporting data to another Workbook (4 replies)
- Copy Files in a folder into a single Master file. (3 replies)
- Error Importing XLS sheet into Access via VBA (1 replies)
- Suppressing display of CUM line chart for future periods (3 replies)
- Internet Explorer controls error (4 replies)
- Find Names and copy to a new sheet (3 replies)
- Solved: Inputbox method to pick a range in another workbook (2 replies)
- Solved: VBA Speech References Library (2 replies)
- Solved: Showing IP Address (5 replies)
- Solved: simplifying formulae (10 replies)
- Solved: HELP Worksheet.CodeName is not consistent when copying a worksheet into a workbook (3 replies)
- Solved: Find, Copy Text from Word and paste in excel (5 replies)
- auto print (5 replies)
- HELP macro to Delete Row based on two cells (5 replies)
- Decimal value of characters in cell (14 replies)
- Solved: edit macro cancel step (5 replies)
- Drill Down (1 replies)
- VBA Macro Code to Enter Intranet's Login/Pass? (1 replies)
- Processing Time (3 replies)
- Solved: reduce size of macro (6 replies)
- Stop skipping rows!! (3 replies)
- Solved: User Defined Function not giving fresh results (8 replies)
- Changing the time zone (1 replies)
- printarea with rectangles (6 replies)
- Excel VBA website content copy (0 replies)
- Hyperlinks as result in Random Sample (1 replies)
- Solved: how to swap firstname lastname in cell? (3 replies)
- required fields based on IF statement (2 replies)
- form fields in excel (2 replies)
- Store ordered list in string. (15 replies)
- Solved: Error in Workbook Code (13 replies)
- Modify a macros (1 replies)
- Solved: Sort specific workbook (2 replies)
- Solved: Trim formula needed in condiational formatting (10 replies)
- Dynamic Scatterplot (2 replies)
- Concatenate From within formula (4 replies)
- Parse .txt file (5 replies)
- Solved: Trim the fat (4 replies)
- Solved: Msg box - if password is wrong (3 replies)
- help with a message box on error (2 replies)
- How to make a range reaonly or locked or non editable??? (2 replies)
- Assign Macro Shortcut (1 replies)
- Copy range in new sheet by criteria (2 replies)
- Solved: Help on how VBA could attach file to Lotus Notes Email template and save to drafts (3 replies)
- Sub or Function not defined - switch off (20 replies)
- Tricky worksheet Problem.... (9 replies)
- Solved: Check if cell begins with number (5 replies)
- Help with Find program (2 replies)
- Formatting issues: copy/paste & Ctr-F (8 replies)
- VBA script to copy workbook contents (3 replies)
- Solved: Dates Screwing up! (16 replies)
- Solved: Sort by two criteria (7 replies)
- Simple Question, Hopefully (10 replies)
- Solved: Function to Return Offsetted Values (2 replies)
- Solved: Filtering issue (3 replies)
- Solved: How to detect multiple cell selection (4 replies)
- VBA script to download data from a url (2 replies)
- Help With - For Next Loop & Possible Inclusion of If Statement (2 replies)
- VBA Script to open macro dialog box (7 replies)
- Useing a variable to control a combobox (2 replies)
- Solved: Matching Multiple Cells (8 replies)
- Solved: Double Click, Insert Character (10 replies)
- Compile Error (4 replies)
- Solved: Two arrays and one set of code (4 replies)
- Help - Range Values Selection (3 replies)
- Check for a particular value and formatting the cell in another sheet (6 replies)
- Solved: Consolodating totals for duplicate rows (5 replies)
- Color column A if another column equals 2 (1 replies)
- Solved: clear data in data based upon a condition (4 replies)
- Solved: Stop user accessing worksheet "Administartor" (7 replies)
- Cut Paste macro (2 replies)
- Page Header: Always 1st Row of ColB of that particular page should appear (2 replies)
- Solved: Easiest way to check/uncheck all checkboxes? (5 replies)
- easy vb help (6 replies)
- Change line color for new series programatically (9 replies)
- Look up and sum across sheets? (6 replies)
- WorkBook Log-in Access (2 replies)
- Solved: Insert a new row after finding text "total" in a cell (17 replies)
- Polynomal trend line (1 replies)
- Solved: Trouble with Inserting Rows (22 replies)
- User function to solve Polynomal equation (0 replies)
- Solved: Combobox - Dynamic Named Range (10 replies)
- Help with wierd way of doing things (4 replies)
- Iterating through an array, and omitting results (4 replies)
- Solved: get the name of the selected file. (7 replies)
- speed macro using array (4 replies)
- Solved: How do I get excel to change the colour of cells dependant on values in other cells? (6 replies)
- auto fill (1 replies)
- How do I keep a Custom Menu attached to a sheet? (2 replies)
- Problems with FileCopy and Wb(name).close (11 replies)
- Solved: insert code to show progress (3 replies)
- add extra step to macro (4 replies)
- Appends the contents to the respective columns (6 replies)
- auto print (2 replies)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.