View Full Version : Excel Help
- VBA Transpose Paste Loop (looping recorded Macro) (2 replies)
- "You've entered too many arguments for this function" (8 replies)
- Removing all non-numbers from the last portion of string (2 replies)
- [SOLVED:] Transpose multiple rows, varied length, to a single column? (5 replies)
- Copy range in worksheet into new workbook - input box (1 replies)
- [SOLVED:] UDF returning multiple values (4 replies)
- Help needed to edit CSV files (3 replies)
- Removing Conditional Formatting When Printing to PDF (5 replies)
- [SOLVED:] problems with copying the values of one cell to another (4 replies)
- [SOLVED:] Multicolum list box displays incorrect format (3 replies)
- Switching from one tab to another VBA (1 replies)
- [SOLVED:] How to turn off "activate when cell changed" while other macros change cells? (4 replies)
- Delete columns based on current month (0 replies)
- VBA - How to select range of cells based on value of 2 cells in each row (3 replies)
- [SOLVED:] Set Focus To A Particular Cells with OptionButton (2 replies)
- return only values from one column which have different values in another column (8 replies)
- [SOLVED:] VBA Copy Clear Paste (8 replies)
- Consolidate datas from workbooks to masterfile (0 replies)
- [SOLVED:] have cell take value of another cell when a thir cell's value is changed (0 replies)
- [SOLVED:] Creating consistent charts and layouts (6 replies)
- Run-time Error 438 (7 replies)
- Import CSV files in a Loop (2 replies)
- [SOLVED:] Compare and replace- Long Sentences (14 replies)
- DTPicker - select date, then continue automatically (2 replies)
- Ways to optimize VBA loop (17 replies)
- [SOLVED:] Error 1004 with method "Columns" - only when opening the file (2 replies)
- Save file to folder with variable (3 replies)
- [SOLVED:] How to disable "traditional" Save and Save As functionality (4 replies)
- [SOLVED:] Hiding Rows (3 replies)
- errore (1 replies)
- [SOLVED:] VBA - Moving files (2 replies)
- Custome Date Picker! Duplicate value (3 replies)
- Copy from worksheet to worksheet in different workbooks with IF condition (6 replies)
- Connect via ODBC to Access FE on remote server from Excel (0 replies)
- cant figure out compile error: do without loop (2 replies)
- [SOLVED:] Forms, Formulas and Dropdowns. Difficult (16 replies)
- Sum for a certain criteria (9 replies)
- Code for Vlook up (0 replies)
- [SOLVED:] Code is dropped when sheet is copied and emailed (3 replies)
- [SOLVED:] Open Window in 64 Bit Excel VBA 7 using Windows API (1 replies)
- [SOLVED:] Delete Rows in Table (2 replies)
- Merge two pdf files with partly same name in 2 different flders (0 replies)
- Add a row below an activebutton, keeping the format without resizing the button (2 replies)
- [SOLVED:] Random Select Rows and Copy to Next Sheet based on user input value (2 replies)
- Change Direction (1 replies)
- Copy paste with VBA (1 replies)
- code for the filerting and copy n pasting in another sheet (0 replies)
- [SOLVED:] Overflow Error in Array Assignment (20 replies)
- [SOLVED:] CDO Email, specific cells in the body (6 replies)
- [SOLVED:] Chart Title and Axis Title positioning (2 replies)
- Storing Previous Cell Value in Historic List (7 replies)
- Addins and CustomUI, OnAction to only run Subs in book? (4 replies)
- Text stretched in inserted word object (1 replies)
- [SOLVED:] Range(Cells()) and the 1004 Error (6 replies)
- Looping Macro (7 replies)
- [SOLVED:] Generate Text Files (4 replies)
- [SOLVED:] Array Indexing - Please help, at a loss for words... (3 replies)
- Attemping to loop data/extract/compare (4 replies)
- How to avoid hardcoding a filepath (7 replies)
- [SOLVED:] HTML href cutting off URL at first space (1 replies)
- SSL connection to external source (0 replies)
- Run-time error 438: Object doesn't support this property or method (2 replies)
- I want to make change in data model in manage data model of powerpivot by vba code (2 replies)
- Finding out leaves and exits (2 replies)
- [SOLVED:] Excel MACRO that make variable sheets with conditional information (3 replies)
- [SOLVED:] Setting the width of an inserted word document (1 replies)
- Userform on Mac (2 replies)
- Hiding Quick Access Toolbar (QAT) (0 replies)
- VBA in Excel to search for PDF's and report if exist yes/No (4 replies)
- Results changing from a drop down selection - understanding VBA code (1 replies)
- Deleting rows which consists cell value PM and CM and remain cell value intact. (1 replies)
- function with paramarray help (1 replies)
- [SOLVED:] Code that opens a file and uses data from that file to replace data in another (13 replies)
- Automatic Hyperlink documents in excel workbook using a command button (6 replies)
- [SOLVED:] Force opening a file as a .XML (2 replies)
- [SOLVED:] Auto copy range data and paste on last empty row (4 replies)
- [SOLVED:] Help with vlookup in VBA (2 replies)
- Huge working excel document (3 replies)
- [SOLVED:] Find row index where max value is located (8 replies)
- [SOLVED:] Removing end elements of an array (they are all 0) (8 replies)
- CommandButton button in Excel 2016 does not work (1 replies)
- comparing elements of 2 arrays (3 replies)
- [SOLVED:] Set value to variable in vba to use different sub (3 replies)
- [SOLVED:] Take absolute value of all array elements - Please Help! (3 replies)
- [SOLVED:] Match Overlap Date Range and multiple criterias (2 replies)
- Smart View - Connect to a Shared Database (1 replies)
- [SOLVED:] Ribbon customization issures (2 replies)
- Print Charts to pdf (2 replies)
- Every possible combination (0 replies)
- Parsen/Scripting web-pages with Excel-VBA - no refresh data (2 replies)
- [SOLVED:] Vba Code for sorting date (8 replies)
- [SLEEPER:] I like to find next small value.. (2 replies)
- Ribbon Control not displayed at file open (2 replies)
- [SOLVED:] Adding batches of serial numbers (6 replies)
- TextToColumns FieldInfo ignored (4 replies)
- [SOLVED:] VBA - uppercase of the first letter in each word, while the rest remains intact (9 replies)
- VBA Cells update vica-versa using VBA code - Level 100 Can somebody solve this? (5 replies)
- How can I find next small value(look up value) in a range? (2 replies)
- VBA Code->copying sheet from mutiple sheets excel into single excel with diff sheets (2 replies)
- macro save as (8 replies)
- Transferring Excel data into Word (3 replies)
- VBA - inserting picture on from clipboard to userform image (0 replies)
- [SOLVED:] UDF to count colored cell pairs fails with #VALUE! (3 replies)
- Copy partial rows with criteria to new workbook identified sheet (8 replies)
- Catching fatal VBA errors (1 replies)
- [SOLVED:] Retain excel cell format when copying to word bookmark (2 replies)
- Excel Macro pulling data from Word 2013 form - formatting question (0 replies)
- [SOLVED:] Limiting Window Size to the used Column range (5 replies)
- Macro - Mail every worksheet using A1 as address (4 replies)
- Splitting data into other worksheets based on data in ROW (1 replies)
- compare dynamic arrays and copy data from another array into a cell in WS (2 replies)
- Slicer vba code (3 replies)
- [SOLVED:] Dashboard prepration (2 replies)
- Import Multiple txt files (0 replies)
- [SOLVED:] ForEach Loop Trouble (7 replies)
- VBA for Setting Min and Max Axis for Scatter Plot Graph (0 replies)
- Vba view active ie window and mouse over text and pull to text box (0 replies)
- [SOLVED:] Arrays using MMULT Function (3 replies)
- Upon exit excel woorkbook save charts as picture (4 replies)
- Split to Files - adjustment (2 replies)
- Compare cells (4 replies)
- VBA help solving assignment (2 replies)
- [SOLVED:] VBA- how can i have a userform behaviours just like controltiptext? (17 replies)
- Copy from RDP (remote desktop) to local desktop (2 replies)
- [SOLVED:] Need help w/formula to show just some amounts (3 replies)
- [SOLVED:] Select data down to next empty cell in column (4 replies)
- VBA Table of Contents (0 replies)
- Add double quotes to cells that contain spaces (8 replies)
- [SOLVED:] Select range till last empty row (2 replies)
- [SOLVED:] Value & Formula - Export Sheet from xlsx to CSV (2 replies)
- [SOLVED:] VBA Coding Help (3 replies)
- Message when you try to open the file (1 replies)
- [SOLVED:] Can you Format as fraction in VBA -- Format(123.456, "# ??/16") (1 replies)
- [SOLVED:] Changing Multiple ranges to Dynamic ones (5 replies)
- VBA: website scraping in general and specific problem (0 replies)
- Download and open Excel file (3 replies)
- Senders Email Address: Outlook 2013 to Excel 2013 Not Working (0 replies)
- urldownloadtofile-is-downloading-files-to-inetcache (1 replies)
- Select data through 2 slider bars (0 replies)
- [SOLVED:] How to keep Inserting Rows Command from moving other cells in a sheet (29 replies)
- 2 selection critria in a WorkSheet form (1 replies)
- Mirroring of sheets to a single summary sheet (0 replies)
- [SOLVED:] Microsoft Object Library Reference Missing - Outlook to Excel (3 replies)
- VBA format Word (0 replies)
- Excel VBA: resizing a pasted image in word using excel VBA (0 replies)
- Yes/No Optionbuttons (0 replies)
- X-Y Scatter plot using VBA (3 replies)
- VBA to read text file and import specific data from it to excel columns (6 replies)
- How to run macro only selected rows (4 replies)
- Salary Structure Calculations (3 replies)
- Sum adjacent columns based on criteria (3 replies)
- Copy Paste VBA code Required with some additional requirements Button (2 replies)
- Compare list of values to rows in another sheet, copy row on first match (1 replies)
- [SOLVED:] Hide and Unhide Columns based on Cell Value (10 replies)
- Extract value from HTM file (1 replies)
- [SOLVED:] Deciphering VBA Code (4 replies)
- Help removing encryption from an excel template using VBA (4 replies)
- Function to list file names in a folder (0 replies)
- Two dropdown lists (0 replies)
- VBA Newbie question (0 replies)
- Help Looping through array (22 replies)
- Run-time error; Invalid procedure or arguement (2 replies)
- Macro listing files in folder, used to list all now only first (3 replies)
- Compile error argument not optional (7 replies)
- [SOLVED:] Help with renaming files (Name "xxxxxxx" As "yyyyyyyy" wont work) (2 replies)
- [SOLVED:] How to fix Compile error: Else without if (5 replies)
- Distance between 2 locations 2D array (3 replies)
- [SOLVED:] Find specific words in a worksheet and change the font color of those words (5 replies)
- [SOLVED:] Find zero (3 replies)
- [SOLVED:] Need help parsing subtext in cell (5 replies)
- [SOLVED:] Extracting intersecting values from two or more ranges (2 replies)
- Make Cell Blink 3 times (1 replies)
- [SOLVED:] Switching worksheets unexpectedly after exiting UserForm (6 replies)
- Run-time error "438" (11 replies)
- Checking for MULTIPLE duplicates on save_click (2 replies)
- [SOLVED:] Changing code from copy entire row to copy specific cells (2 replies)
- Auto update Form Text box with form editor name (0 replies)
- [SOLVED:] Filter between two dates on multiple ranges (2 replies)
- [SOLVED:] VBA to Copy / Paste into New Workbook With Different Layout by Column & Row Headings (9 replies)
- [SOLVED:] YTD SUM (4 replies)
- Search for Specific Text within a Cell (1 replies)
- Help with time diffrences (3 replies)
- [SOLVED:] Search using two ranges (4 replies)
- Change Check Box character to text (3 replies)
- Different Phone Number Formats from list of numbers (2 replies)
- Copying charts from all Excel worksheets onto Powerpoint slides (2 replies)
- data transfer through loop (3 replies)
- Aligning Columns and rows (3 replies)
- Turning Multiple Optionbuttons subs into one sub (2 replies)
- Eliminating Pop-up when using RemoveDuplicates (3 replies)
- VBA msgbox help (2 replies)
- Copy Data from one sheet to another IF cells are specific text colour (0 replies)
- excel help (3 replies)
- Excel VBA game help (0 replies)
- Force User to Enter Date but in UK format (10 replies)
- VBA variable url webquery (0 replies)
- Need help : fill listbox with search result (2 replies)
- VBA - Outlook to Excel (1 replies)
- How to change code for sheet to work whole book (2 replies)
- Code for Slicer (5 replies)
- Export specific sheet from a file to a specific sheet in many closed files (5 replies)
- [SOLVED:] Run time error -2147417848 (80010108) Method "_range" of object "_worksheet" failed. (6 replies)
- vba - vlookup on data stored in array (3 replies)
- Barcode Asterisks Around Date Formula (1 replies)
- Show column headings and corresponding values/text based on dropdown selection (39 replies)
- Numbers update as per Pivot table (2 replies)
- Moving data between sheets based on headers (2 replies)
- Data lookup formulas (4 replies)
- Else without IF error !!! (2 replies)
- Test to determine workload (3 replies)
- golf 4somes (22 replies)
- [Help] VBA for scheduling (1 replies)
- In work materials vs delivery date (2 replies)
- [SLEEPER:] Time formula (2 replies)
- Reading value from another application (1 replies)
- Hiding ribbon commands (3 replies)
- Extracting data from a variable length string (4 replies)
- Customized Footers with VBA (0 replies)
- [SOLVED:] Concatenate Transpose - Multiple with Multiple (2 replies)
- [SOLVED:] Hide/Unhide Rows Based on Cell Value (2 replies)
- automatically hide/unhide the row based another sheet cell value. (4 replies)
- [SOLVED:] Average and addtional conditions (4 replies)
- [SOLVED:] Import most recent xml file (3 replies)
- VBA breaks when it comes to deleting command button and selecting A1 cell (1 replies)
- [SOLVED:] Textjoin help needed (5 replies)
- [SLEEPER:] Help with Merge in Excel (2 replies)
- [SOLVED:] For Loop for 2 Range (3 replies)
- VBA: Internet Explorer zoom level (0 replies)
- Filtering data on multiple creterias (8 replies)
- [SOLVED:] Multiple Frames on A Excel UserForm and switch the visibility (6 replies)
- [SOLVED:] could not set the list property. Invalid property value error (8 replies)
- [SOLVED:] Saving worksheet range without formula to array (2 replies)
- Dynamic vlookup refering different workbooks through VBA (3 replies)
- Macro to recover an excel encrypted workbook (4 replies)
- [SOLVED:] Trim and LCase values in an array (3 replies)
- VBA Userform (Excel 2016) - Textbox date calculations: Date + No. of days=Expiry Date (2 replies)
- Is there a cleaner way to write this formula? (3 replies)
- Spell check stopped working (2 replies)
- How can you use a variable to reference a worksheet object? (8 replies)
- Assign exact dates of material availability to each production order (0 replies)
- VBA Script locks the excel sheet (2 replies)
- Looping through combo box (1 replies)
- Copy Cell Values Using If Statements through VBA Code (8 replies)
- [SOLVED:] How Do I Change The Date Format in VBA Code (11 replies)
- Copy rows with specific values and paste within the same worksheet (1 replies)
- Code for selecting data and paste in another tab (7 replies)
- Auto Updating Row for Sum Grand Total (1 replies)
- [SOLVED:] syntax problem with a While nested into a Loop (for an Array) (17 replies)
- Call data from another sheet based on multi critiria (7 replies)
- Copy Values if name of sheets in two different workbooks are equal (1 replies)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.