View Full Version : Excel Help
- Solved: Non-Contiguous Reference Clear Contents (4 replies)
- Solved: Formula or vba required for most frequent text in an array. (6 replies)
- Centering Text in a Message Box (9 replies)
- Solved: Replace tilde character fails (9 replies)
- Presenting two datas in a graph (3 replies)
- Solved: Multidimensional Array (8 replies)
- Solved: DISPLAY "0" INSTEAD of #NUM! (7 replies)
- Solved: Clear white space off each column of each sheet of a workbook (4 replies)
- Weird runtime errors (1 replies)
- Code for a find sort and copy. (1 replies)
- Solved: How to add an Accelerator to a Caption? (2 replies)
- Solved: Putting String Array to cells directly (5 replies)
- MultiPage manipulation (6 replies)
- Named Range issue using file online (0 replies)
- Solved: Adding Sheets By Day Order (5 replies)
- Creating a Pivot Table using VBA (7 replies)
- VBA to grab data from other .XLS file (4 replies)
- How to show Form abobe selected cell? (1 replies)
- [SOLVED:] How do I force recalulation of custom function on Workbook_Open? (19 replies)
- Solved: How to tell if no value is selected in a listbox (10 replies)
- [SLEEPER:] Save a copy solution (11 replies)
- users access (2 replies)
- Solved: DisplayFullScreen Question (6 replies)
- adding image to vba loaded userform sourced in sheet (5 replies)
- freeze pan (1 replies)
- Solved: Range object Id property (10 replies)
- Solved: Passing & Returning array to/from Property Get and Let (4 replies)
- Solved: For Each Loop through Worksheets Collection (3 replies)
- Solved: referencing different cells for calculations (7 replies)
- pivot tables and (15 replies)
- Calling UserForms: FormName.Show or Dim Object/Set New? (6 replies)
- Values and formats of only visible sheets and ranges copied to a new book (1 replies)
- Test if Current Dir is Read Only (12 replies)
- Excel and Notepad: how avoid additional inverted commas after copy and paste? (1 replies)
- Forms, textboxes & labels (3 replies)
- Solved: Simple Floating Toolbar - enhancement (2 replies)
- Help with deleteing row conataining #VALUE! (1 replies)
- Solved: Pivot Table Formatting (3 replies)
- Listbox Count (2 replies)
- Store Value of Last Row even after the procedure ends and Excel Closes? (14 replies)
- Getting to know what element of ComboBox has been selected (13 replies)
- Creating the user GUi forms the right way (3 replies)
- Solved: Understanding VBA minutes (3 replies)
- How to position a chart? (2 replies)
- Check if workbook exists (10 replies)
- Scrollbars for a Frame? (1 replies)
- [SLEEPER:] The "BEST" formula function in Excel: (3 replies)
- Linking Problem (0 replies)
- stop clock help needed!!! (7 replies)
- code to tell excel which folders to look into. (4 replies)
- import worksheets from changing workbooks name (2 replies)
- SECURING VBA CODE (29 replies)
- insert pagebreak if chart is not fully displayed (4 replies)
- Help: HOw many color is there in Excel (5 replies)
- problem with paste to active workbook (1 replies)
- Leave out blank items in combobox (5 replies)
- Find Range & Fill Down (9 replies)
- how to get: Index function keep value? (1 replies)
- Self filling combo boxes (1 replies)
- Cell contents become ### (5 replies)
- Stop User from Entering Formulas (4 replies)
- Solved: Expiration Date (3 replies)
- Import Txt and Parse (9 replies)
- Solved: Value Added Tax conversion problem (2 replies)
- To Compare 2 Sets Of Data And Change The Values Accordingly (5 replies)
- Sharing: What VBAx Is All About- Give It Up & Smile (3 replies)
- Macro help.. (11 replies)
- Can't get a result of formula (6 replies)
- Solved: Hyperlink on menu button (14 replies)
- Return named range with vba (2 replies)
- Solved: Procedure Too large to complete message. (21 replies)
- Option choices - how do I export results? (1 replies)
- Solved: VBA Combo Box Coding (3 replies)
- Solved: VBE column references (4 replies)
- excel formaula (1 replies)
- Paste Special Bitmap Excel VBA to Word (11 replies)
- Solved: Formula - Runtime 1004 Error (6 replies)
- Backgrounf formatting in Text Control (10 replies)
- Forcing .xls to open in 2007 (1 replies)
- Solved: Copy/paste from all worksheets, except sheet1 (5 replies)
- Coloring of the tab of a worksheet (4 replies)
- Forms/windows or whatever it's called (10 replies)
- search data from other worksheet (1 replies)
- Challenging macro (6 replies)
- [SOLVED:] Excel data organization nightmare (13 replies)
- Highlight cells on combobox selection (3 replies)
- Excel Hyperlink (1 replies)
- Sumif with multiple criteria?s from another worksheet (7 replies)
- Adaptive Database/Table (1 replies)
- Solved: Change Cell Colors By CF (4 replies)
- How to find the Last Used Row on Each Sheet (2 replies)
- UnprotectGreenCells (3 replies)
- Help: How to make list value change with the source (5 replies)
- Excel procedure to run Access Query using ADO (2 replies)
- Problem with .PasteSpecial (xlPasteValues) (6 replies)
- Solved: any way to delete & refresh contents in a dropdownbox? (25 replies)
- Formula - (4 replies)
- List box from columns? (9 replies)
- Problem with Code (Inserting New Row) (16 replies)
- Solved: Two input variables at vlookup (13 replies)
- Solved: input data to post in worksheet (8 replies)
- [SOLVED:] Speeding up the processes (2 replies)
- Invalid forward reference error (6 replies)
- Solved: Delete duplicated, tally to make report (2 replies)
- hide textbox (3 replies)
- countif forumla (3 replies)
- EXCEL COMPATIBILITY DRAMA (10 replies)
- Placement of a method (2 replies)
- Automation Help (3 replies)
- Do While question (2 replies)
- [SOLVED:] Copy, cut, paste: on a hidden sheet, possible? (21 replies)
- Unload userforms (2 replies)
- Solved: Help with case statement (5 replies)
- Solved: VBE and continue (2 replies)
- [SLEEPER:] Crashing on closing (8 replies)
- Solved: Select Case Construct Help (0 replies)
- Solved: naming a dynamic array with 7 columns, fluctuating rows (3 replies)
- Solved: Check if user has selected more than one cell (3 replies)
- Solved: find last row and add border to bottom > Resize selection? (3 replies)
- Copying data from one sheet to another (12 replies)
- Drop down lists problem (2 replies)
- Solved: Pivot Table Creation: Error 438 (2 replies)
- Select issue (9 replies)
- Solved: Display Animation While Random Numbers procedure (10 replies)
- Copy data fields macro (2 replies)
- Solved: UserForm Show Input error Message before proceeding (7 replies)
- Solved: Entering only values that are different to a list box (4 replies)
- VBA Objects (getting a combobox) (2 replies)
- Automatic open, save, close problem. (3 replies)
- Sleeper: Macro to unsort data back to its original format - exact copy (3 replies)
- Changing/retaining format of cells (8 replies)
- Running FTP commands from Excel Macro (2 replies)
- Solved: Clearing a multi column listbox (2 replies)
- array (14 replies)
- Solved: Join 2 formulas to work as 1 (17 replies)
- Solved: Loop: IF Condition is getting skipped (17 replies)
- How to print 1st page of several excell workbooks (2 replies)
- UserForm has Color but when print must only print in Black (4 replies)
- running slow (2 replies)
- [SLEEPER:] what type of sheet (15 replies)
- Investigating the selection (5 replies)
- [SOLVED:] What happened to this sheet (4 replies)
- Auto adjust (0 replies)
- Magnify /Zoom sellectecd cell (4 replies)
- Solved: Find last filled row IN PARAGRAPH (13 replies)
- ActiveCell not working the way i'd expect (2 replies)
- Naming a selected range (1 replies)
- Highlighting changed cells (11 replies)
- Automatic Opening, Saving Closing a Workbook... (0 replies)
- Delete data starting from specific row (4 replies)
- get min and max from array... (3 replies)
- Solved: Inserting Day of the week on a userform TextBox (14 replies)
- Solved: Your Opinion, Please (4 replies)
- Formula to find last significant value in string (3 replies)
- Relate 2 Tables in Excel Database (3 replies)
- Pivot Table with ADO (2 replies)
- [SOLVED:] Pivot Table Calculated Field (2 replies)
- Formatting issues (15 replies)
- Solved: auto copy and sort on change 2 columns (6 replies)
- Solved: How to maintain control as nested subs exit? (10 replies)
- Sending Info from Excel to Word (1 replies)
- Solved: Write a Small Procedure for me please? (7 replies)
- Copy and paste based on two criteria (3 replies)
- Solved: Generating numbers in excel (4 replies)
- finding merged cells (8 replies)
- Solved: Macros wont run even with security set to low (1 replies)
- [SOLVED:] formatting macro in VBA (7 replies)
- Solved: Run-Time Error 5 Invalid proc. call or argument (3 replies)
- [SOLVED:] Check Outlook version (1 replies)
- Solved: Subscript out of range on .Find (2 replies)
- [SOLVED:] Macro Record: What Module does it store it in (5 replies)
- Mkdir (9 replies)
- Solved: Apportioning Query (4 replies)
- Finding correct blank cell (10 replies)
- import data to update charts (5 replies)
- Solved: Sheet names (2 replies)
- [SOLVED:] List Box Selection To Text Box (12 replies)
- Any help to tweak the following code much appreciated (3 replies)
- Solved: Run macro in other sheets. (1 replies)
- Solved: Run Time Error 91 (9 replies)
- Performing an operation on several cells at once (8 replies)
- Nested Loops? (8 replies)
- Solved: Copy Certain Rows into Master Workbook (8 replies)
- how to parse through pivot filtered items (0 replies)
- Cutting up a table (3 replies)
- How to Prevent Insertion / Deletion of Worksheet (4 replies)
- Coordinates for my shape and placing the cursor (12 replies)
- Finding the sum value of permutations... (21 replies)
- Solved: Does sumproduct work with OR (25 replies)
- cleaning a cell (6 replies)
- Getting the value that WAS in the cell just deleted (6 replies)
- Solved: Update Userform after changes have been made on another useform (14 replies)
- Userform Validation Issues (25 replies)
- Help with CreateObject function (0 replies)
- [SOLVED:] Row count of non-Active worksheet (6 replies)
- Excel behave like a multi-user database? (11 replies)
- Solved: Relative range for advanced filter (5 replies)
- Solved: Read 'live' LOG file (23 replies)
- [SLEEPER:] List Controls on Worksheet (6 replies)
- Solved: WINAPI problem:project:control any sw from vba(with sendkey+mouseclicks) (5 replies)
- Solved: Deactivate workbook close button (15 replies)
- Reversing the process (11 replies)
- Solved: Filling a simple array (4 replies)
- loop that copy sheets in the same workbook (13 replies)
- Autonumbering (6 replies)
- importing data from other spreadheet (3 replies)
- VB How far backwards compatible? (1 replies)
- Format Specific Rows (2 replies)
- New VBA Code needed (1 replies)
- code for all possible cases (3 replies)
- Deleting row when a condition is met (7 replies)
- Excel Sheets Opens Itself Again After ADO Query ! (8 replies)
- Conditional autofilter based on form (27 replies)
- Amending VBA Script (3 replies)
- Solved: Extremely Slow Performance (5 replies)
- Solved: Row copy (6 replies)
- Solved: Delete specific word from rows, add specific words to others (9 replies)
- Solved: auto sort 2 columns after second column input (3 replies)
- Generating data using a loop (4 replies)
- Solved: save user selected sheets into new workbook (10 replies)
- how to run when print is cancelled (3 replies)
- [SOLVED:] Remove last two characters from string (2 replies)
- Solved: ayto formatting (3 replies)
- Replace #DIV/0! ERROR as blank cell (3 replies)
- Solved: Method of 'Range' failed error (3 replies)
- Convert Formula from R1C1 to A1 (5 replies)
- Delete Data if Less then Yesterday (6 replies)
- Auto Sort Entries (5 replies)
- Locking a module rather than the whole project (3 replies)
- Find Last Used Cell of Visible Cells (9 replies)
- Cell comparison (3 replies)
- Solved: help for selective highlight of rows (8 replies)
- [SOLVED:] Left loop (3 replies)
- master detail filtering (2 replies)
- Solved: macro to format cells (4 replies)
- List of all open workbooks (17 replies)
- chart with vba (17 replies)
- How: to check whether an element in chart is exist or not (8 replies)
- Solved: countif query & more... (5 replies)
- Solved: Percentage in VBA (7 replies)
- Solved: Copy Filtered list from Sheet 1 to Sheet 2 (7 replies)
- Unlocking the Pasword Protected File (4 replies)
- Solved: www.youtube.com (2 replies)
- VBA code for Vlookup in 2 wkbooks and import to master (1 replies)
- Help: Set Chart Source (2 replies)
- [SOLVED:] Automation Error - Object has diconnected from Clients (5 replies)
- Userforms (6 replies)
- Solved: What's wrong with this picture (5 replies)
- Copy/Paste macro (7 replies)
- [SOLVED:] List of Worksheet Tab Names (11 replies)
Powered by vBulletin® Version 4.2.5 Copyright © 2025 vBulletin Solutions Inc. All rights reserved.