View Full Version : Excel Help
- Solved: CountIF to find Average using VBA (12 replies)
- Solved: Delete Row but store a value first!! (10 replies)
- How to draw a vertical and horizontal line on a line-plot (3 replies)
- Horrible Listview problem... (2 replies)
- Code Wants help (5 replies)
- Conditional formatting in vba (more than three) select values from a worksheet (2 replies)
- Solved: macro to list unique data in a column (2 replies)
- Help with Macro code (8 replies)
- Solved: Opening unknown File names in known Folder (4 replies)
- Solved: problem with resize and autofill (2 replies)
- User Def Function to only act on active workbook (3 replies)
- Code using date not saving the result of output (14 replies)
- [SOLVED:] Creating Pareto Chart (20 replies)
- [SOLVED:] Quick question about loops (3 replies)
- Caopying and Pasting While Retaining the Original Cell Reference (5 replies)
- Solved: Word bookmark Help (8 replies)
- FileCopy to Network Drive (13 replies)
- CSV Import Issues (3 replies)
- Paste Copy special Value (5 replies)
- Solved: Automatically change font size (2 replies)
- Solved: Accounting format (2 replies)
- Userform will not Show after being Hidden (3 replies)
- Solved: Create New Sheet Based on Value In Column (7 replies)
- Copy, Find and add offset cell values (0 replies)
- Trim cells in variable range (1 replies)
- Getting a range to work in my vba code (4 replies)
- Solved: If value not found go to next cell (5 replies)
- Solved: Label blinking in the UserForm (1 replies)
- How to create a message box depending on values of the cell? Toughie =/ (10 replies)
- Solved: Userform Quick Q (2 replies)
- Tracking Changes / Sharing a workbook (6 replies)
- Looping through Range Vs Ranges (15 replies)
- Extract data from columns [sum] (1 replies)
- Solved: Renaming folder files (2 replies)
- Solved: Find unique values (3 replies)
- Solved: NETWORKDAYS formula amendment (8 replies)
- Form, listbox and multilines problem (1 replies)
- Solved: Changing TreeView Node Detail with Userform TextBox (2 replies)
- Solved: Adding rows with preconditioned cells (9 replies)
- Solved: How to re-apply named ranges (24 replies)
- Solved: Re: Shared Workbooks (2 replies)
- Command button to Hide/Unhide tabs (4 replies)
- Navigation menu to only show visible tabs (4 replies)
- Solved: Populate list box from selection in another. (2 replies)
- Generate random numbers based on odds (1 replies)
- Solved: Spell Check Unlocked Cells on Protected Sheet (1 replies)
- Solved: data going to wrong cell (4 replies)
- Solved: Formula help (2 replies)
- Function returning Arrays (3 replies)
- Difficult: Sum of days in consecutive months based on multiple criteria (7 replies)
- Which control does this? (2 replies)
- Quicker way to write a bunch of formulas?? (1 replies)
- Solved: Help with Experimental Grade Sheet (9 replies)
- Seperating records with a blank line (3 replies)
- Manipulating Arrays Using VBA (2 replies)
- For Each.. loop decisions (3 replies)
- Solved: Copy from one xls to other avoiding highlighted cells (6 replies)
- Amend VBA Code (2 replies)
- combo box help (1 replies)
- Excel in neverending loop (2 replies)
- Copy and paste withi selected range (12 replies)
- Solved: Importing multiple space delimited text file (6 replies)
- arranging data redux (4 replies)
- saving a backup file (2 replies)
- Split Cells help (9 replies)
- Solved: "Pick and choose" series to display on embedded chart (5 replies)
- Complie if error (5 replies)
- looping code with if's (0 replies)
- Solved: Camera tool use with picture object (6 replies)
- Solved: modifying existing chart Sourch data (5 replies)
- Creating a User controlled pause in VBA (2 replies)
- Downloading many html web pages, converting to text, then parsing out (5 replies)
- Ref Edit Control Missing (1 replies)
- EXCEL USING IF THEN STATEMENT (3 replies)
- Listbox Limit!! (4 replies)
- Move over Picture (1 replies)
- Using VBA for conditional Formatting (2 replies)
- Solved: save and rename workbook everyday at a given time (1 replies)
- Solved: How to check the type of an array (2 replies)
- question about forcemacros (1 replies)
- Linked Picture to be centred on Screen (8 replies)
- change part of a string (1 replies)
- Prevent 1004 Error For Select Method (11 replies)
- Using Formula To Find Last Used Column? (9 replies)
- lookup and conditional formatting with VBA (17 replies)
- TextBox Help (1 replies)
- Access Filter Criteria from Excel (0 replies)
- Solved: help optimizing case select (4 replies)
- Solved: userform and function call (3 replies)
- Solved: Generate numbers 1 - 90 for bingo (10 replies)
- Writing Excel cells with VBA variables (13 replies)
- Solved: Show current users on userform (2 replies)
- vb and command button help (3 replies)
- storing value, making registration tool (4 replies)
- [SOLVED:] Application.match failing (4 replies)
- Solved: add data based upon created categories (10 replies)
- progress bar is frozen (9 replies)
- Function returns empty array (9 replies)
- Sorting a Range with VBA (13 replies)
- Import Txt and Parse (3 replies)
- Creating a "refresh data" macro (3 replies)
- Solved: Excel - Opening files in string or in cell (10 replies)
- Page Header: Loop based on values in a range (5 replies)
- Runtime Error 1004 - ODBC ERROR - BackgroundQuery (0 replies)
- Worksheet Cell Calculation Order (1 replies)
- Maybe a Null question? (4 replies)
- Need Help with the Easist Question Ever (4 replies)
- View Excel Charts from Forms (1 replies)
- Solved: Problem with Typename for Multipage/Page in recursive function (2 replies)
- Copy Extenal workbook help (6 replies)
- excel data manipulation and sorting (7 replies)
- Listbox Additem + ListFillRange (9 replies)
- Solved: CustomList Index (2 replies)
- Solved: Allowing macro beetwen 4 - 5 PM (17 replies)
- Task Scheduler via COM (2 replies)
- For Each loop: exits too early (7 replies)
- copy and paste active cell down a column (25 replies)
- multiple e-mail addresses in SendTo,Notes client (3 replies)
- What routine to use? (9 replies)
- Solved: looping backwards using steps (1 replies)
- copy range from different sheets (3 replies)
- Solved: Toggling Display gridlines: (8 replies)
- Solved: Help with calling out another sub within a sub (1 replies)
- Solved: sheet history before save (3 replies)
- problem with preventing "" spreading all over the Spreadsheet (3 replies)
- Stop / Pause a Macro using Pause button (4 replies)
- Solved: Problem with my delete loop (7 replies)
- Solved: Make textbox visable or not visable on Userform (3 replies)
- Solved: Transpose Horiz Values to Vertical (1 replies)
- code help (newbie) (12 replies)
- Passing Objects: ByRef / ByVal (2 replies)
- Breaking numbers and letters (9 replies)
- Solved: Create Multiple Text Files From Cells & Save As Name In Adjacent Cell (7 replies)
- Solved: Assigning a date variable for use in a file extension (8 replies)
- User Form Help (2 replies)
- Assistance with formula arrangement (1 replies)
- Solved: linking text data between sheets (4 replies)
- UserForm control for a background process (0 replies)
- Solved: VBA for sorting column with formulas (3 replies)
- Solved: Format trend line dialog box (3 replies)
- Solved: [Excel] Open files listed in varialble, extract data (1 replies)
- Solved: Need help creating macro to insert col (3 replies)
- 1024 character limit help (4 replies)
- Loop to extract data (3 replies)
- Form TxtBox (6 replies)
- test if Excel 2007 is in Compatibility Mode (0 replies)
- Solved: Finding Information in one spreadsheet to populate another spreadsheet (4 replies)
- Solved: Help speed up this code (2 FOR loops seem to be the problem) (6 replies)
- selecting last row / cell (9 replies)
- formatting vba to work on a protected sheet. (5 replies)
- Using another source (2 replies)
- Solved: subtract two formula (2 replies)
- Solved: List File Names (12 replies)
- understanding arrays (5 replies)
- txtboxes and cells. Updating editing userform (5 replies)
- Solved: change formula (11 replies)
- conditional formula (10 replies)
- monte carlo output: statistics in Excel (How?) (4 replies)
- Solved: 2 formulas required - Part 2 (7 replies)
- Solved: 2 formulas required - Part 1 (6 replies)
- Solved: Treeview nodes (7 replies)
- Benefit of making sheet object rather than directly manipulating sheet (2 replies)
- Solved: Find/Replace in One Column over Entire Workbook (13 replies)
- Copy or link data between sheets (8 replies)
- Activate range on a different sheet (10 replies)
- Solved: Select item in list if only one exists (2 replies)
- Solved: incorporating condition or math into sumproduct (2 replies)
- Solved: problem with a conditional average (23 replies)
- Solved: Automate msgbox cancel (4 replies)
- Solved: Macro to warning user of duplicate entry (4 replies)
- CODE CANT BE WORK (9 replies)
- Excel VBA Copy & Paste (7 replies)
- Number format to dispaly on a label from text box (3 replies)
- CommandButton &i.Elabled = False (2 replies)
- Transposition and rearrangement of data using VBA (2 replies)
- Want a Userform (4 replies)
- Solved: Userform and data validation (12 replies)
- Solved: What's wrong with this function? (6 replies)
- Rolling Reference number (11 replies)
- Worksheet activate code in Add-in (3 replies)
- Excel macros (if statements etc) how? (4 replies)
- Search certain column in all worksheets and paste rows to seperate worksheet. (2 replies)
- Treeview Losing Checked Checkboxes (2 replies)
- Date Stamping a Cell Modification (6 replies)
- Check or selected rows in array? (8 replies)
- refreshing data in excel (1 replies)
- Trim not working and moving through a range (1 replies)
- Solved: Best way to select these ranges w/ macro? (5 replies)
- Sleeper: Date Dif function (4 replies)
- A complex IF formula (5 replies)
- Solved: Delete function failing (10 replies)
- Connections in MS Excel 2007 (0 replies)
- Getting around Pivot Table 256 Col Limitation (4 replies)
- MACRO/VBA help!!! :S new line... etc (5 replies)
- Date Format (4 replies)
- Solved: Hours to be worked by Month (14 replies)
- Solved: Stop Them Deleting Rows (2 replies)
- worksheet is not picked up in Vba (4 replies)
- Macro Security (17 replies)
- Extracting certain data to another sheet (1 replies)
- loop + offset/resize problem (4 replies)
- From one sheet to another... (5 replies)
- Solved: Special Transpose (2 replies)
- Solved: make a dynamic if statment? (4 replies)
- Alternative to Eomonth formulae question (3 replies)
- Solved: Fast Compare using Filter (6 replies)
- copy range, skip empty cells (6 replies)
- Solved: problem of structure (4 replies)
- Solved: Userform buttons to enter numbers into textbox (7 replies)
- Solved: problems saveing two copies. (2 replies)
- Solved: From one array to another (3 replies)
- Solved: any value in a range = 0 then return 0 ? (3 replies)
- Solved: Sum and compile list of entries (4 replies)
- Solved: using a worksheet function in vba (2 replies)
- Easy! How to make a button that generates a random number? (6 replies)
- Solved: case yes-no, can the code be smaler? (5 replies)
- Solved: alpha-numeric 2 (3 replies)
- Split string into multiple parts no bigger than 240 chars? (9 replies)
- Solved: Create a worksheet for each value in Column A (6 replies)
- [SOLVED:] Variable Columns Lengths (3 replies)
- problem using a function from an external library in vba (3 replies)
- Excel Macro Help Please (1 replies)
- Execel, OLEObjects (buttons) sometimes not firing, triggering (5 replies)
- C&P all data of all the sheets/workbooks in a folder. (4 replies)
- If no dependents msgbox and resume loop (14 replies)
- [Help Please]Parsing parameters to event (2 replies)
- Help! I'm working with two spread sheets (1 replies)
- Combobox Visibility After Drop List Selection (5 replies)
- Formatting entire row based on text in first column (1 replies)
- Solved: Problem auto-installing VBA add-in (10 replies)
- How to find the last duplicate value (6 replies)
- Pass a named range into function issue (5 replies)
- Listview help (0 replies)
- Summing a column based on two criteria in other columns (11 replies)
- Random number generation (6 replies)
- Solved: move up (9 replies)
- Clipboard is full (1 replies)
- Controlling Internet Explorer's "Print pop-up" (4 replies)
- Check if a file on the web exists (0 replies)
- VBA for time display (7 replies)
- Solved: Saving As Text adds double quotes to some lines! (1 replies)
- rectangle question (0 replies)
- Excel Right Click Menu Always Up (13 replies)
- Group 2 cells like in a userform. (7 replies)
- Count coloured cells and display result in table. (3 replies)
- Solved: Add Border if Statement (4 replies)
- Getting Data from an Excel Spreadsheet object to a normal excel spreadsheet (3 replies)
- Solved: Feeling dumb today!!! (13 replies)
- CommendBox (18 replies)
- Solved: Loop through one column on any sheet in workbook.... (5 replies)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.