View Full Version : Excel Help
- [SOLVED:] For Loop does not seem to be working (8 replies)
- [SOLVED:] FileSystem Object, Folder.Files.Count Does Not Match Files.Item Count (10 replies)
- VBA code to delete rows based on value (7 replies)
- Getting Problems in Making a Query from SharePoint (0 replies)
- [SOLVED:] Shorten loop using boolean (3 replies)
- [SOLVED:] is it possible: If Me.Controls("CommandButton" & i).clicked (2 replies)
- VBA Help, to Pick first Column Data and its file name (1 replies)
- Trying to copy all sheets into one combined sheet (1 replies)
- [SOLVED:] sum of variable range stop working (2 replies)
- Quote Generator - Advice (3 replies)
- Subscript out of range and SaveAs Method error (14 replies)
- create and store pdf, attach to email and send, with loop (7 replies)
- [SOLVED:] Macro To copy and paste data from a list to corresponding worksheet and cells (2 replies)
- Cell Value Confusion. (2 replies)
- [SOLVED:] Delete zeros (2 replies)
- Sleeper: VBA If formula help (7 replies)
- Identify employees late login (3 replies)
- [SOLVED:] Can't call several subs in a macro (6 replies)
- RTF field in Excel by keeping formatting (5 replies)
- Timer + Stop Watch (3 replies)
- [SOLVED:] Loop thru all sheets and copy a value (2 replies)
- [SOLVED:] Copy and Paste Macro help please (2 replies)
- Change Sheet name (3 replies)
- Macro is not recording sheet protection password (3 replies)
- VBA getElementById doesn't work correctly (1 replies)
- If Formula not working as expected (5 replies)
- vba help to copy specific colulmn.. from a sheet (1 replies)
- adding selected rows into a sheet with a specific selection (4 replies)
- Control strings (7 replies)
- Advance Filter using VBA (9 replies)
- how to make CommandButton1.Rotation = 90 in office 2016 (4 replies)
- [SOLVED:] Move File to Folder if filename matches foldername (5 replies)
- [SOLVED:] Need help with Do While Loop or If this AND that then.... (6 replies)
- [SLEEPER:] VBA code in Cash Flow forecast (24 replies)
- Macro to convert from Paste Bottom-Up to Top-Down? (8 replies)
- Move cells to another worksheet (2 replies)
- [SOLVED:] Unzip files to a folder udf (3 replies)
- [SOLVED:] Searching with recursion (13 replies)
- [SOLVED:] VBA code mysteriously timing out (2 replies)
- VBA Macro - Use relative ranges to graph (7 replies)
- [SOLVED:] #Name? error for TextJoin UDF (9 replies)
- MSO File Picker Help (2 replies)
- VBA code for lookup table (7 replies)
- [SOLVED:] vba Double for each Loop combining task (1 replies)
- Vertical Column with possibility to filter (3 replies)
- modifying function cohort/matrix of ratings migration (0 replies)
- VBA Conditional Formating (2 replies)
- USER-FORM FILTER DATA EDIT (1 replies)
- [SOLVED:] Sort/ transfer data (6 replies)
- [SOLVED:] Procedure Too Large - Compile Error (14 replies)
- Search string in two columns in different excel sheets and copy the matching data (1 replies)
- [SOLVED:] VBA VLOOKUP ON Historic trades (6 replies)
- [SOLVED:] VBA FILTER (10 replies)
- [SOLVED:] Need help duplicating a row (if not already duplicated) (2 replies)
- [SOLVED:] vba help on vlookup (8 replies)
- Export all the sheets in excel to images individually files (4 replies)
- Add Data Field in Pivot Table (2 replies)
- Disable Overtype / Insert Ability in VB Editor for Excel 2016 … (2 replies)
- Empty a Module within Excel 2016 … (7 replies)
- [SOLVED:] Two rankings (8 replies)
- [SOLVED:] Populating colums based on cell value and conditions (21 replies)
- VBA Use hidden cell to run IF Statement (3 replies)
- [SOLVED:] Pivot Table Error with VBA Code (5 replies)
- [SOLVED:] Highlighting a cell if there is a match with another cell (9 replies)
- [SOLVED:] Looping through ActiveX checkboxes and adding items to ActiveX List Box (5 replies)
- Subscript out of range (4 replies)
- [SOLVED:] Auto Save excel workbook every 5 minutes (8 replies)
- Can you speed up my vba that copy and pastes the header amongst worksheets? (1 replies)
- Trying to copy a macro into another workbook (14 replies)
- [SOLVED:] Simple for each loop problem (3 replies)
- [SOLVED:] How to Send a HTML Email using Word Email Template using Excel Macro (3 replies)
- Compare two strings for similarity or highlight differences in Excel (12 replies)
- Run-Time error "7" out of memory (1 replies)
- VBA To Check That Value Appears In Single Cell Range Before Starting Macro (9 replies)
- Change marker size for all series in a plot (VBA) (2 replies)
- [SOLVED:] Copy and Move files to existing Sub-folders based on filename/Sub-folders's Name (9 replies)
- [SOLVED:] Convert to a number (3 replies)
- [SOLVED:] Take out space (22 replies)
- [SOLVED:] How to send email in excel using content in word as email body (7 replies)
- [SOLVED:] VBA code to cycle through sheets (9 replies)
- Reading and Writing to dat file via forms (6 replies)
- VBA: referencing cell in one worksheet and using it as range start for another sheet (6 replies)
- [SOLVED:] Running Macros from ComboBox with Items from a Range (3 replies)
- Function to update a cell in another worksheet giving #1004 error (5 replies)
- [SOLVED:] VBA Code assistance to separate a workbook into several different files. (10 replies)
- Autofilter failed (3 replies)
- [SOLVED:] VBA code attach an excel file to outlook with a variable file path (7 replies)
- VBA code running too slow in Excel 2013 (13 replies)
- [SOLVED:] Format Issue (6 replies)
- Find and Change Values (11 replies)
- [SOLVED:] Break up column A content between column A and B (6 replies)
- Help with filter by date (5 replies)
- [SOLVED:] VBA function to return MySQL Data (5 replies)
- vba adding image after clicking on the textbox (2 replies)
- [SOLVED:] Select working(Active) range with mouse (14 replies)
- [SOLVED:] Need help with Question, is it possible to Call modules to work or loop through? (32 replies)
- [SOLVED:] need macro added to current to automatically move to next row for next search and (6 replies)
- userform icon in taskbar problem in win10 office 2016 bit 32 (11 replies)
- excel vba macro to apply filter multiple column using header names (13 replies)
- [SOLVED:] Split function in vba (6 replies)
- Run macro on all files (1 replies)
- VBA to update a table from another table (2 replies)
- Subscript out of range (2 replies)
- [SOLVED:] Handling Formula Errors & Formula Length Limit (20 replies)
- [SOLVED:] Pull specific data based on If statements (3 replies)
- [SOLVED:] Save Outlook attachment into an Excel cell, as OLEObject in VBA (4 replies)
- [SOLVED:] Modified a function that is called in another function, now getting runtime error? (5 replies)
- [SOLVED:] Angles between 2 lines (6 replies)
- Get (some of) Excel Clipboard contents via Windows clipboard "XML Spreadsheet" format (1 replies)
- Vba Compile Error :( (15 replies)
- Find out row and column range (3 replies)
- [SOLVED:] Create 2 Dimensional Array from "For" Loop (8 replies)
- [SOLVED:] Extract part of a line and paste in another cell (3 replies)
- [SOLVED:] Remove symbol (2 replies)
- [SOLVED:] Copy range to blank cell (10 replies)
- Open all CSV files in folder, and merge to one master file. (7 replies)
- [SOLVED:] Array limits? (6 replies)
- Import data from different files and sheets into file with corresponding data cells (1 replies)
- VBA Macro to copy multiple charts from one excel file to a word bookmark locations (2 replies)
- Required Email generated with signature and attachments (5 replies)
- [SOLVED:] Alternatives to MINIFS (Minimum IF's) (7 replies)
- File size reduction (43 replies)
- [SOLVED:] How do I set passwords and how to save as a certain name for a file (9 replies)
- [SOLVED:] Sort by row based on column value (9 replies)
- [SOLVED:] Module Level Variable Loses Value (9 replies)
- [SOLVED:] MACRO: SaveAs Cell Value File Name (Pull Two Cells within Worksheet as File Name) (5 replies)
- [SOLVED:] IF, AND, OR Nesting - Part of it not working (4 replies)
- Help with pulling names from online database (0 replies)
- [SOLVED:] How to export and save each worksheet as new workbook in Excel? (4 replies)
- [SOLVED:] Project Planner Not Working (5 replies)
- Labor Tracking / Time Tracking (2 replies)
- [SOLVED:] Loop through column data and delete or copy based on value given (12 replies)
- Significance Testing Macro (8 replies)
- Code suggestions required. (5 replies)
- Macro to Copy certain WS's based on Key to a New WB and email (1 replies)
- [SOLVED:] VBA to fill up website form and upload file path via “Browse” buttton (4 replies)
- VBA - SAP 'Save As' dialogue box (2 replies)
- [SOLVED:] Progress Bar for macro (3 replies)
- Userform- Populating Dependent List Help (2 replies)
- [SOLVED:] Rename text file with new name (14 replies)
- Macro to copy excel recordset and insert in to Database based on a condition (3 replies)
- [SOLVED:] Text Size Issues in Text Box (2 replies)
- Need VBA to create inputbox for multiple values & filter multiple columns (4 replies)
- Formatting, Highlighting Travel Times Conflicts (3 replies)
- data transfer (3 replies)
- [SOLVED:] Macro to Set Page to Print in Particular Range & Adding a Company Logo (4 replies)
- [SOLVED:] Need VBA to arrange data Cell adress data please!! (2 replies)
- [SOLVED:] Adding a Scroll Option to The Text Boc Functionality (2 replies)
- [SOLVED:] Help with code on language translation file (21 replies)
- [SOLVED:] loading a variant array (7 replies)
- [SOLVED:] Help with updating formula's with VBA (22 replies)
- Auto Save excel file to another Computer on the network (2 replies)
- pivot table - sort items with different order for each parent item (4 replies)
- [SOLVED:] UserForm VLOOKUP to get Data and Change one Column (7 replies)
- Help in Pivot (5 replies)
- [SOLVED:] Summing of columns into specified cell loop (4 replies)
- Compare values inside the range (sheet1) and copy the row to new sheet (sheet2) (12 replies)
- How Do I Filter In Excel Using TextBox? (0 replies)
- Adding functionality to an existing Excel Workbook (example pictures included) (1 replies)
- VBA code for extracting report from Outlook Mails (0 replies)
- [SOLVED:] Message in Every Cell (2 replies)
- [SOLVED:] Unmerge cells across rows only not across columns (2 replies)
- Copy and combine files using VBA (1 replies)
- [SOLVED:] VBA: Chart with Combobox (4 replies)
- VBA: Match string and color substring (5 replies)
- Combine Multiple Worksheets w/ Different Headers Into One Worksheet (1 replies)
- [SOLVED:] need help gettng macro to run faster! please!!! (14 replies)
- [SOLVED:] ActiveSheet.Previous.Select (3 replies)
- Customised spell check in VBA (1 replies)
- [SOLVED:] Select from Cube Through VBA (12 replies)
- Excel Function -Address (3 replies)
- Populating PDF document with Excel vba (2 replies)
- [SOLVED:] Extract the formulas of each cell in range - VBA (17 replies)
- Get the heights related data in row D (6 replies)
- File folder to single spreadsheet (20 replies)
- Adding comboboxes in a loop (14 replies)
- [SOLVED:] When using open text file how to tell if the file existed, or a file was created? (2 replies)
- VBA Error - Missing 4 columns Data after copying (2 replies)
- Creating an xml file from each row in excel (3 replies)
- Save active sheet only as pdf + Increment the invoice number + print active sheet (7 replies)
- New to Macros - file naming issue (5 replies)
- [SOLVED:] Re allocate Named Range addresses (5 replies)
- [SOLVED:] code for copy and paste (5 replies)
- [SOLVED:] Store special cells in one range (14 replies)
- [SOLVED:] Autofilter latest event date (3 replies)
- insert six rows at specific points (9 replies)
- [SOLVED:] PivotTable.DrillDown and filtering the output (14 replies)
- [SOLVED:] Search for data highlighted in red return it and return the data in next two columns (2 replies)
- VBA to copy url from excel sheet and open in webpage and copy source to notepad (3 replies)
- [SOLVED:] Excel coordinate projection - distance and bearing (5 replies)
- Identifying file type in excel (2 replies)
- Values are not copying over as entered on one sheet to another. (4 replies)
- Convert from Text to Columns Doesn't Work if Source is Modified (7 replies)
- Help with copy paste code (3 replies)
- Sleeper: Adding a certain number of cells between sets of data based on a comparison (3 replies)
- If-statement with relative values (11 replies)
- Can you customise the results from comparing two worksheets? (1 replies)
- [SOLVED:] Unwanted selection change (2 replies)
- [SOLVED:] Combining Static Series and Dynamic Series in a Dynamic Chart Issues (7 replies)
- Date Variable Showing 12:00:00 AM, Why? (4 replies)
- [SOLVED:] Ctrl-C selection in memory - how work with it by VBA Excel code? (4 replies)
- Copy function from workbook to another in VBA (2 replies)
- [SOLVED:] Write an IF statement relating to 2 different worksheets (20 replies)
- [SOLVED:] How to write VBA code to auto insert the last row occupied into Master Sheet (22 replies)
- Last saved issue (1 replies)
- Every time i run the macro it has different values, need help please (3 replies)
- Accessing Hidden Sheets Via Hyperlink (1 replies)
- Custom XLAM ribbon question (2 replies)
- Custom Option Buttons VBA (9 replies)
- [SOLVED:] Deleting empty rows (6 replies)
- Complex Macros needed to Make and Save Workbooks (10 replies)
- Challenge to get huge Excel Workbook running online (8 replies)
- Copy row based on criteria to existing sheets & constant update (3 replies)
- Issues with pagination in a worksheet generated by a macro (1 replies)
- Help to create a file from the inputs in the input sheet (3 replies)
- Creating Folders from Excel into Outlook (attachment) (1 replies)
- [SOLVED:] Count all files with specific extension (16 replies)
- Copy from one workbook to another without opening the second workbook (3 replies)
- [SOLVED:] Code for copy and pasting in excel (18 replies)
- [SOLVED:] Help with making code run faster (16 replies)
- [SOLVED:] VBA formula with variables (6 replies)
- [SOLVED:] Separate Regions (1 replies)
- Wildcard with match index (10 replies)
- Vba far loop too slow (6 replies)
- [SOLVED:] How to call DblClick sub from code VBA Excel (2 replies)
- Application.EnableEvents (20 replies)
- [SOLVED:] VBA Count IF help (5 replies)
- [SOLVED:] Put Country Codes in Excel For SharePoint (37 replies)
- [SOLVED:] VBA to Auto Number (2 replies)
- Need help exporting row data in excel to their own individual powerpoint slide. (1 replies)
- [SOLVED:] VBA Auto Filter + Paste to New Sheets + Autofill (2 replies)
- [SOLVED:] Return Row - Column for cell addresses (24 replies)
- [SOLVED:] Copy ThisWorkbook Code with Copy Sheet to New Book (6 replies)
- [SOLVED:] Variable Vlookup vba (8 replies)
- [SOLVED:] Get last row in range that contains formulas (12 replies)
- [SOLVED:] Break all external links (7 replies)
- [SOLVED:] Use formula to grab data from sheets (11 replies)
- Cell evaluation (2 replies)
- Excel Billing Invoice with VBA and mdb (1 replies)
- Comparing Dates (12 replies)
- Excel help required: How to insert excel remarks in scanned pdf file. (1 replies)
- [SOLVED:] Move some cells to next records and delete some rows (2 replies)
- [SOLVED:] MSGBOX VBOKONY, Cancel exits sub. (7 replies)
- [SOLVED:] Need help restructuring macro to do opposite and adding to macro, please! (5 replies)
- [SOLVED:] Check if cell has custom format using UDF (14 replies)
- [SOLVED:] Sort each subset of n rows by specific column ranking (3 replies)
- [SOLVED:] Importing data in consecutive rows (3 replies)
- [SOLVED:] Macro to follow hyperlinks when a certain criteria is met (4 replies)
- Extract string from text file (1 replies)
- Select Folder and Break External Links of All Files (1 replies)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.