View Full Version : Excel Help
- [SOLVED:] Help with For..Next Loop (4 replies)
- Hide rows based on results of a drop down box on another sheet. (4 replies)
- Excel Macro Code Crashing (10 replies)
- [SOLVED:] Some explanation requested on converting string to double. (3 replies)
- Automatic graph generation macro (5 replies)
- Copy/Paste Recolored Picture with VBA (1 replies)
- [SOLVED:] Suddenly can't do anything in VBA ?? "Access is denied" ?? (8 replies)
- Update workbook (5 replies)
- Extract Specific Text From Middle of a String (4 replies)
- [SOLVED:] Chage default program to open a filetype? (16 replies)
- [SOLVED:] Counting conditional format colours, column by column (5 replies)
- [SOLVED:] How to Extract Row reference from chart series (2 replies)
- [SOLVED:] VBA code for tracking tracking updates in a column (2 replies)
- [SOLVED:] Inspecting dates of a Policy period (14 replies)
- Convert PDF data to Excel (5 replies)
- [SOLVED:] Find, copy & paste (14 replies)
- Adapt Colorpicker to limit selection to a few chosen colours (2 replies)
- Game in excell that I found. Where is the code that makes this game work (3 replies)
- [SOLVED:] Calculator buttons repeat very slowly (3 replies)
- [SOLVED:] Macro not working for partial date format conversion (3 replies)
- Need help with inspecting elements from website (3 replies)
- Are these multiple range objects or multiple names (8 replies)
- Lookup multiple values and compare different scenarios to get a specific result (4 replies)
- Need help with four basic VBA functions (10 replies)
- Unhide Entire Rows based on numeric value in cell (1 replies)
- Code duration inconsistent (4 replies)
- [SOLVED:] Wildcards with Replace in VBA (2 replies)
- [SOLVED:] Counting specific figures based on pivot table data (17 replies)
- [SOLVED:] Ratio being force formatted into Time (2 replies)
- [SOLVED:] Small Delay when showing Form (9 replies)
- Input date into input box on website not working correctly (3 replies)
- Login into intenet website not recognizing password via VBA code from excel (1 replies)
- PowerPoint crashes while copypasting diagrams from Excel (0 replies)
- [SOLVED:] Headings in formulas (4 replies)
- file exists or not (15 replies)
- Latest file name in the folder path (1 replies)
- Sleeper: Issues getting text into a text box on a website form (15 replies)
- [SOLVED:] How to use the AddComment method of the range object (4 replies)
- Export / Print all Charts in Workbook to PDF (3 replies)
- Possible to have a macro "Rewrite" another macro? (3 replies)
- [SOLVED:] What does it mean to click on a cell? (6 replies)
- macro to find modified date of file (1 replies)
- Need Macro to Copy and Ignore Duplicate (3 replies)
- [SOLVED:] Is this efficient? (4 replies)
- Excel functions (10 replies)
- 2013 Slicer Events (2 replies)
- [SOLVED:] Close workbook without save prompt? (3 replies)
- Copy cells from an open workbook to a closed workbook (1 replies)
- Help with code (3 replies)
- Macro for inserting new rows conditionally. (7 replies)
- Import Sharepoint list into Excel (0 replies)
- Setting a timeout for Excel workbook (10 replies)
- [SOLVED:] Lookup up formula (4 replies)
- Check If Files In A Folder Are Open Without Knowing Name/File Type (6 replies)
- Replace All fires WS_Change for every cell (27 replies)
- [SOLVED:] Calling custom class method through variable (6 replies)
- [SOLVED:] Formula Q: referencing first column number that meets specific criteria (6 replies)
- Sleeper: Create VBA Function from VBA Macro - Inverse of Matrix in Excel VBA (7 replies)
- To obtain the coordinates (2 replies)
- IE.navigate not working on VPN (2 replies)
- Copy and Paste if Value changes (7 replies)
- [SOLVED:] Rank/ Sequence of Repetition (1 replies)
- Problem with ProgressBar (15 replies)
- count numbers that are in two sets of numbers (3 replies)
- VBA / Excel / Formula / Examples (1 replies)
- Annual Time Sheet (including flexi/TOIL) - Enter Negative Time/hours (6 replies)
- Utilizing Stored procedure parameters in VBA (20 replies)
- VBA Help Needed with Dynamic Sum Formula (14 replies)
- [SOLVED:] FileSearch Macro error (11 replies)
- [SOLVED:] Excel Crashes when Saving workbook (14 replies)
- [SOLVED:] VBA MsgBox Width in WIN7 (9 replies)
- [SOLVED:] Delete duplicate rows Excel 2003 (3 replies)
- VBA Help please (Novice) (7 replies)
- [SOLVED:] De-Duplication & Merge with multiple criteria (4 replies)
- Help jump Columns (3 replies)
- One rate sheet - multiple customers/multiple rates based on the one sheet (1 replies)
- Finding duplicates and replacing. (3 replies)
- Complex Filtering & Copying With VBA (Need Help) (3 replies)
- EXCEL/Quickbooks HELP!!! (7 replies)
- [SOLVED:] Find and Match Formula (15 replies)
- Delete Powerpoint slide which contains zero values (3 replies)
- [SOLVED:] Userform doesn't open unless Excel is the active application (3 replies)
- [SOLVED:] Help with a msgbox :) (4 replies)
- Adding Item to Reference Library (5 replies)
- [SOLVED:] Calculate sub shift hours (22 replies)
- [SOLVED:] Help With Worksheet Change event (3 replies)
- [SOLVED:] Correct Row/Column Numbers with INDEX and MATCH (4 replies)
- [SOLVED:] Find every instance of a word, then find previous instance of another word (14 replies)
- [SOLVED:] Clearing contents of all worksheets in a excel workbook (3 replies)
- [SOLVED:] Help me improve some old code (13 replies)
- Help with VBA Events - some work and some don't (34 replies)
- Automatically Inserting Rows with Date, Each Worksheet (1 replies)
- [SOLVED:] Runtime Error 1004 on 2nd run (9 replies)
- [SOLVED:] Problem deleting a legendEntry (5 replies)
- Help Require in VBA (16 replies)
- creating Parameters in Excel using VBA (13 replies)
- [SOLVED:] Code works in Macro, but not in Function (7 replies)
- Update workbook data from another workbook (2 replies)
- [SOLVED:] Worksheet not updating with data from VBA (4 replies)
- Searching information in different bases (7 replies)
- VBA Code - Novice Here, Sorry! (7 replies)
- [SOLVED:] Remove Text (2 replies)
- trouble selecting sheet (1 replies)
- Merge Single Worksheets from Different Files into One Workbook AND Replace Formulas (2 replies)
- Excel 2003, worksheet_change to insert current date when a cell is colored yellow (3 replies)
- Merged mulitple sheets of existing workbook into one sheet (1 replies)
- [SOLVED:] Need Help Removing quotes and double quotes from my Excel Spreadsheet (11 replies)
- multiple word files tables to excel vba (5 replies)
- remove an item from a combobox. (21 replies)
- I Can't change <SELECT> html tag using VBA (6 replies)
- VBA - Rounding Goal Seek result (2 replies)
- Userform submitting a date in format "mmm-yy", but a small problem arises. (6 replies)
- [SOLVED:] When does a Chart object become a ChartObject object (8 replies)
- VBA combo boxes (6 replies)
- [SOLVED:] Trying to add variables into Worksheet statements and can't get the right syntax (6 replies)
- Runtime error copying value from one worksheet to another in same workbook (4 replies)
- Iterate values through calculation using VBA and record results (16 replies)
- [SOLVED:] Iterate values through cell using VBA and record result (3 replies)
- Issues getting data in PowerPivot from Access (3 replies)
- [SOLVED:] Download file, how do I know when the file is downloaded? (13 replies)
- How to send email from excel using VBA with Cell Range (Including Images) as Email Bo (3 replies)
- [SOLVED:] Writing and Reading the Same Set of Ranges (3 replies)
- Autofilter based on content in cells (6 replies)
- [SLEEPER:] Run-time error when using OraOLEDB.Oracle Provider (0 replies)
- [SOLVED:] ListView Run-time erro "13"; Type mismatch (9 replies)
- [SOLVED:] Put data from userform into specific place. (6 replies)
- [SOLVED:] Print a changing range based on date values (6 replies)
- How modal forms work (4 replies)
- Slow Import from Web (5 replies)
- [SOLVED:] Userform for Entering Data in Excel VBA (7 replies)
- Lookup column value and find value (7 replies)
- VBA Userform (for Entering Data) (3 replies)
- Automating the use of translation.babylon.com (5 replies)
- How to Avoid Formatting Cells When Protected? (7 replies)
- Multiple Column Listbox (with headers) = the bain of my existence (5 replies)
- How to add row into another worksheet based on multiple cell values? (10 replies)
- Printing an Selected Sheets (2 replies)
- Excel VBA to Unhide rows with a specific value in a Range (5 replies)
- How to compare text in 2 cells and highlight incorrect text (3 replies)
- [SOLVED:] Directly Copy A Range from One Sheet to Another (2 replies)
- [SOLVED:] macro button for copying excel data into multiple word docs (8 replies)
- [SOLVED:] Increase number every nth year (2 replies)
- [SOLVED:] Trying to find the next empty cell in a range Using With and Set method - Help (7 replies)
- Array for ActiveX Controls (7 replies)
- [SOLVED:] Case Senerio and Offset That Creates A Data Validation Box (4 replies)
- Compiling and Exporting Information (2 replies)
- automation error (3 replies)
- Hiding Cols With VBA (3 replies)
- [SOLVED:] Acceptable to use Goto (27 replies)
- [SOLVED:] Creating an Array from a Table with only one row in it (15 replies)
- Optimize a VBA loop (3 replies)
- VBA - Change Decimal Separator (10 replies)
- String length mismatch (3 replies)
- [SOLVED:] Adding New Chart Series with Loop (3 replies)
- [SOLVED:] Date range (6 replies)
- Format search results in a Multicolumn Listbox With Headings (3 replies)
- [SOLVED:] Automatic Generate random unique time From 8 AM till 21 PM in range (8 replies)
- [SOLVED:] Kill Files that Begin With Something (7 replies)
- Sales Returns for FIFO (8 replies)
- Question regarding loops sum and average (2 replies)
- [SOLVED:] Increment Column Selection with InputBox (12 replies)
- Mathematical Excel Optimisation Challenge (production of units) (5 replies)
- [SOLVED:] VBA Scientific Format. Can I reduce a digit? (6 replies)
- Runtime error 445, need help (3 replies)
- Excel record aggregation with VBA macro (2 replies)
- New to VBA Coding (3 replies)
- Merging Word Documents From VBA (4 replies)
- Trouble setting pivot page filter using VBA (3 replies)
- VBA Auto generate numbering (4 replies)
- [SOLVED:] Subscript out of Range (5 replies)
- SaveasUI - Save as .xls not XLSM (2 replies)
- Hidden worksheet codes not working (6 replies)
- Help in VBA (3 replies)
- [SOLVED:] Changing formatting by writing all cells to an array (25 replies)
- Importing data from Header and table in Word to Excel. (6 replies)
- Check whether numbers are sequential? (1 replies)
- [SOLVED:] Allow only choose 4 colors (2 replies)
- [SOLVED:] Parse Text And Read Into Cells (12 replies)
- [SOLVED:] Error: Overflow (8 replies)
- [SOLVED:] VBA Auto SAVE - need help! (5 replies)
- Loop through subfolders (1 replies)
- [SOLVED:] fill months following (3 replies)
- import txt. file to excel with vba (0 replies)
- Copy Paste from multiple worksheets into one based on multiple criteria (20 replies)
- FORCE TO POPULATE CELL (2 replies)
- [SOLVED:] Need a little help with "totals" (4 replies)
- Create Sheet if Workbook name contain some text (1 replies)
- Create a simple chart in a sheet where a pivot table already exists (6 replies)
- Edit VBA to prevent paste but allow copy and save the file with a file name derived (0 replies)
- [SOLVED:] Help to Improve Double Loop Code (8 replies)
- Excel as Notify Icon (1 replies)
- find matching entry, then copy and paste (2 replies)
- [SOLVED:] Range, Columns, and Copy (12 replies)
- Help with code (2 replies)
- [SOLVED:] struggling with excel combo boxes macro (0 replies)
- Sumifs and dates (1 replies)
- [SOLVED:] Sum from previous sum formula in a column to active cell (9 replies)
- Exel Crashes with Form Control (14 replies)
- Code to Group Worksheets when Printing and Print Preview - 2003 vs 2010 (6 replies)
- XML Data I/O (0 replies)
- [SOLVED:] RunTime Error 53 : File Not Found error (10 replies)
- Bill of Material (2 replies)
- Fill a combobox with data found in a range based on worksheet chosen in another cbx (3 replies)
- Copy data from different workbook and consolidate into one masterfile workbook (0 replies)
- [SOLVED:] Help with Loops (4 replies)
- [SOLVED:] User input to delete value in named range: (8 replies)
- VLOOKUP returns #N/A (2 replies)
- Find a "zero" of an implicit function (1 replies)
- [SOLVED:] Date overlap (9 replies)
- [SOLVED:] copy not contiguous cells via VBA (3 replies)
- Barcode fonts (3 replies)
- blank row (2 replies)
- trasfer data from Lotus macro to Excal VBA macro (2 replies)
- Change Cell Color on Sheet "Statistic" if value is negative (2 replies)
- PivotFields class returns an error when .Function property is set (2 replies)
- [SOLVED:] 2013 CalcPad.xlsm in XLStart folder. Open Excel - "CalcPad.xlsm is already open." (1 replies)
- Total data if salary each month is the same - VBA (0 replies)
- How to copy format of a column using spin button (0 replies)
- Extract values of a certain format (10 replies)
- Rename Code Modules Programmatically (17 replies)
- VBA Calendar (5 replies)
- Search for a string on all excel files inside a ZIp folder (6 replies)
- help with copy range (4 replies)
- [SOLVED:] Creating a unique id (13 replies)
- [SOLVED:] Populating Listbox (8 replies)
- [SOLVED:] Ie Automation (3 replies)
- Unable to set FormulaArray Property of the Range Class - Using Replace Function (3 replies)
- [SOLVED:] RTE Error (6 replies)
- Rename buttons using loop and "i + 1" (6 replies)
- Call previous dictionary entry (3 replies)
- [SOLVED:] Change the macro to search for a specific word (as written) and not close to it (8 replies)
- Information sheet or message in xlam? (2 replies)
- VBA Script to Average Amplitude Values in Each Bin Range of a Frequency Histogram (4 replies)
- Have Macro run when cell is updated (13 replies)
- Percentage Difference for Two Percentage (1 replies)
- [SOLVED:] Copy sheet into another workbook and put in alphabetical order (7 replies)
- Excel slideshow and data query help (5 replies)
- Help to use an array for this little section of code (2 replies)
- Worksheet change clears selection(s) on MultiSelect type listbox. (4 replies)
- vba code move cell to next cell (9 replies)
- if find string copy that cell to right column (3 replies)
- Copy & Pasting Overwrites My Data Validation (4 replies)
- [SOLVED:] Need: VB code to get values from different closed workbooks (4 replies)
- html problem with vba (1 replies)
- [SOLVED:] Adjust error calculation in VBA (2 replies)
- Wrong line in the macro. (5 replies)
- Workbook -macros query (1 replies)
- [SOLVED:] GetElementsByClassName With IE8 (3 replies)
- [SOLVED:] Consolidate spreadhseets (1 replies)
- Filtercopy does not return records listed with criteria value below 7 characters (7 replies)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.