View Full Version : Excel Help
- VBA Macro Sort Range (10 replies)
- Range Address Variables (2 replies)
- [SOLVED:] How to assign a worksheet change codes to a button to refresh the values (2 replies)
- Add some cell values as notes (5 replies)
- Removing leading letters in a text using VBA (4 replies)
- Help to fine tune the codes | transform data, delete blank rows and then autofill (4 replies)
- help with the debug (2 replies)
- VBA - Prompt To Save Excel File In Variable Location (2 replies)
- Editable listview items (0 replies)
- [SOLVED:] Impossible to insert (8 replies)
- [SOLVED:] How to add row in second Sheet using ActiveCell in first sheet? (1 replies)
- Insertion range depends on meeting conditions (3 replies)
- Reformat found data and count equal 'strings' (1 replies)
- Creating a VBA to find and delete duplicate values within Excel workbook (0 replies)
- [SOLVED:] Lookup values from a range with partial non-ordered keyword strings (15 replies)
- Insert Row & copy and paste formulas in new row (5 replies)
- [SOLVED:] Can't loop a macro (11 replies)
- Break record row into multiple rows (7 replies)
- Macro called from Menu no longer responding (2 replies)
- [SOLVED:] Problem in concatenate (10 replies)
- Modeless Form Closing (1 replies)
- Help duplicating from one cell onto multiple rows (1 replies)
- How to make a macro work in selected worksheets and how to fix a macro error from CF (8 replies)
- Dynamic update for each userform textbox through looping (1 replies)
- Haven't encountered this before, what does it mean? (5 replies)
- Precedents arrows state (4 replies)
- [SOLVED:] Can a Header (8 replies)
- [SOLVED:] Code only doing it for cell not entire column (2 replies)
- VBA code (11 replies)
- [SOLVED:] Pin Folder to Windows Explorers Quick Access in VBA (5 replies)
- [SOLVED:] IF Else statement not executing properly (2 replies)
- Extract a number from text in cell using VBA (3 replies)
- [SOLVED:] Msg error: "Exception from HRESULT:0x800401A8" when refreshing reports automatically (2 replies)
- Sorting and cutting part of the sort into a new tab (2 replies)
- Sleeper: Linear interpolation in Excel (6 replies)
- Sorting two way pivot table with VBA? (3 replies)
- Sleeper: VBA using Loop (5 replies)
- Transferring data workbook to workbook (2 replies)
- [SOLVED:] Help with simplifying my background substraction (data analysis) (4 replies)
- How can we use VBA/Macros Excel for solving this interesting simulation question? (3 replies)
- errors on Macro code for consolidation (1 replies)
- Compare the selected item of a listbox with a table (1 replies)
- Unrecognized text on different computer (5 replies)
- After user clicks 'Notify', do this (2 replies)
- Macro not working for fetching data from Active Directory (7 replies)
- Reference a cell. (2 replies)
- [SOLVED:] Formula to format the cell? (so text gets enough space) (4 replies)
- [SOLVED:] Repeat Search Function (3 replies)
- [SOLVED:] Sort range from one empty row to the next empty row Custom (3 replies)
- Simple code that refreshes link to another excel file with Password (2 replies)
- [SOLVED:] Making a function based on Find having IF (3 replies)
- [SOLVED:] Conditional Formatting borders around cells with formulas (4 replies)
- [SOLVED:] Keycode 13 only for textbox input on userform (1 replies)
- Method 'SaveAs' of object'_Workbook failed (10 replies)
- VBA Code for PDF of Vibile Sheets in array (6 replies)
- Create a Userform with a Textbox and link it to a Cell or Table (1 replies)
- VBA Code for Highlighting Cells based on If then Rules (6 replies)
- Using VBA Set for workbook and worksheet (26 replies)
- Linear interpolation with lookup of two values (0 replies)
- Item number with current month (3 replies)
- [SOLVED:] Move data around in workbook (9 replies)
- how to create a portfolio Optimimizer using VBA (2 replies)
- [SOLVED:] Formula to FIND specific TEXT within a worksheet (7 replies)
- Log Scale graph in excel (1 replies)
- VBA - Problem in .range (2 replies)
- [SLEEPER:] Loop between two tables to sum their matches (4 replies)
- Retrieve formulas and autocomplete (0 replies)
- [SOLVED:] show multiple separate information (0 replies)
- [SOLVED:] Fastest way to transform data (9 replies)
- Picture shows in userform with search (14 replies)
- Does anyone else have this error 1004? (5 replies)
- code to setup crop dimension (2 replies)
- Lookup to add Products from one table to another VBA (9 replies)
- Help : Error on saving workbook to dektop synced with OneDrive (1 replies)
- VBA - Range of object _ Global failed (3 replies)
- Can I add cell info into a comment box via a formula? (1 replies)
- VBA - function Vlookup (3 replies)
- Copying values from one column in a sheet to another column in another sheet once. (3 replies)
- How to Solve using CurrentRegion if cells in Table is Protected (2 replies)
- Using the TEXT function and Concatenate function in one formula (2 replies)
- Copy data from user selected source file to current open workbook (0 replies)
- [SOLVED:] Putting Values with Leading Zeros Into CSV file (7 replies)
- Why do macros work once and then stop? Example is included (3 replies)
- How do I get one cell color to change based on another cell color that changes? (7 replies)
- Finding Shape types WITHOUT selecting the shape ? (2 replies)
- VBA Help to change Form of Smart Art Nodes (0 replies)
- [SOLVED:] Saving is not creating a new record line, but saving over it (9 replies)
- Vlookup to ListObject "Table copy, paste" (1 replies)
- [SLEEPER:] VBA Email TO Cell that contains IF formula (4 replies)
- VBA Code for pasting today's date into a text box (4 replies)
- [SOLVED:] Pivot table (1 replies)
- Making code more concise - VBA scrape information (4 replies)
- [SOLVED:] How to save multiple selected information from a LISTBOX? (1 replies)
- A search code with three possible results (5 replies)
- Filter By Multiple Criteria then match results to different workbook & paste new data (19 replies)
- Price List Comparator (2 replies)
- Filter values from a table and display them in different textboxes (0 replies)
- [SOLVED:] Cross section by matching column and row headings (4 replies)
- Excel counts a blank as zero. Why not leave it as a blank? (2 replies)
- Automatically delete rows after time period using time stamp (have partial code) (2 replies)
- Worksheet Change Referencing Cell in Another Sheet (4 replies)
- insert selected row from listbox to excel table (5 replies)
- HLEP!! I need help modifying this code. (0 replies)
- VBA Help on drop down list (10 replies)
- Need vba to code to split data depends upon col I:I and col J:J (4 replies)
- Help needed- Analysis of splitting of orders (28 replies)
- [SOLVED:] How to pull information from different columns of data from the same row? (1 replies)
- [SOLVED:] Help for viable registration solution and code improvement (1 replies)
- [SOLVED:] IF Countif and Textjoin - Help required (14 replies)
- [SOLVED:] how to force users to enable macros (4 replies)
- How to convert number of color to RGB? (14 replies)
- [SOLVED:] How to range table "t" from ActiveSheet "Charts"? (3 replies)
- Doppelte Einträge zusammenfassen (14 replies)
- Can someone recommand an obfuscator for xlsm? (10 replies)
- check if serial number is repeated (7 replies)
- [SOLVED:] AutoComplete doesn't recognize Cell A1, it starts getting information from the second (14 replies)
- Image embed (0 replies)
- [SOLVED:] Every time you open the UseForm, it generates a new code (3 replies)
- Return latest result for work schedule (1 replies)
- Search for a match files using value from selected cell in Folder or Subfolders (10 replies)
- [SOLVED:] Search for name and letter matches and split equally (28 replies)
- [SOLVED:] VBA Userform macro help for range dates (2 replies)
- [SOLVED:] Copy Data from one workbook to another - based on tab name (0 replies)
- Checkboxes and filters (2 replies)
- [SOLVED:] create Summary report from information on the DATA Tab. (2 replies)
- Copy and paste specific ranges (5 replies)
- [SOLVED:] VBA Excel - reduction of lines (2 replies)
- Copy and paste styles of diagram (14 replies)
- Insert Multiple Image and name image in Userform (0 replies)
- Instant change between one textbox to another. (1 replies)
- Criteria based lookup (3 replies)
- [SOLVED:] MkDir and "Path Not Found" Run-time error 76 (2 replies)
- [SOLVED:] need Code to select value from dropdown list using numeric values (13 replies)
- [SOLVED:] Expanding the range (5 replies)
- [SOLVED:] 3 questions regarding VBA Excel (1 replies)
- Sleeper: Find a Partial Match from Location Sheet (4 replies)
- [SOLVED:] HOW TO CONCATENATE: IF(condition;result string;result string) result string? (8 replies)
- Make a declared variable equal to values from multiple cells (2 replies)
- Array loop values (2 replies)
- How to close all the hyperlinked files automatically? (21 replies)
- [SOLVED:] Formula with OR condition does not return expected result (5 replies)
- VBA script updating values other sheet (3 replies)
- Help to remove duplicate strings from table (12 replies)
- search and copy the line (0 replies)
- Helper columns to solve problem (14 replies)
- [SOLVED:] looping through functions (5 replies)
- [SOLVED:] Textbox within a Frame in UDF unable to take focus. Why not? (13 replies)
- [SOLVED:] storing processed data (9 replies)
- [SOLVED:] insert auto serial number in user form (2 replies)
- Copy text from text file between keyword in rows. (4 replies)
- wrap broken lines in one line in a given text or log file (9 replies)
- [SOLVED:] Conditional Format:Need to compare 2 cells with any other 2 cells for the same number (1 replies)
- How to split a big text file (with more than 500000 lines) in to smaller files (8 replies)
- File Selection- if user cancels- End Sub Then call macro1 (3 replies)
- SUMIFS on multiple rows and columns, based on a mapping (0 replies)
- [SOLVED:] Delete Rows if Cost Code Bucket is Zero (10 replies)
- strAddress = .ActiveCell.Address Run-time error 438 when switching sheets (21 replies)
- [SOLVED:] Compile Error Private WithEvents oCbarEvents As CommandBars and Private Sub Worksheet (6 replies)
- [SOLVED:] Check if within multiple ranges check problem (8 replies)
- Data validation and manipulating input (12 replies)
- Macro Or Command To Change Photo In Excel - Urgent Weekend Help Needed (29 replies)
- Setting tab order, adding ability to stop/start code and refine functionality (40 replies)
- Pull SQL Data into Excel by Date Range (3 replies)
- [SOLVED:] Deleting Worksheet Stops Script (6 replies)
- copy information with vba (2 replies)
- [SOLVED:] VBA code to pull in data from SQL table (7 replies)
- [SOLVED:] clear dependant drop down boxes (5 replies)
- [SOLVED:] Is it possible to store range objects in an variant array? (5 replies)
- [SOLVED:] Re-Arrange Columns after Import (6 replies)
- Loop Through Data Validation List and Copy Values Given By Each Item (7 replies)
- Add the value taken from the user to my range for ActiveX ComboBox (7 replies)
- New to VBA: Compile Error Syntax Error (5 replies)
- [SOLVED:] Countif in VBA Module (4 replies)
- Shell Command results in Runtime Error 5 - but path appears to exist (5 replies)
- How to prevent duplicate value (1 replies)
- [SOLVED:] Create Summary (3 replies)
- [SOLVED:] Zero Out Column if another column has a certain qualifier (11 replies)
- [SOLVED:] How to Change the Value of a Cell based on the values of two other cells (3 replies)
- [SOLVED:] Multi-sheet procedure (2 replies)
- Macro for inserting rows if value (7 replies)
- [SOLVED:] Date Help (16 replies)
- copy with loop double variable (3 replies)
- Market data and charts (0 replies)
- expenses compared to the budget (1 replies)
- Not Getting Sum Result From All Sheets (2 replies)
- HELP!! can't figure out details for a file-combining macro (13 replies)
- Opened Workbooks are still opened after executing Macro (Workbook.Close doesn't work) (28 replies)
- [SOLVED:] Cumulative based of criteria (6 replies)
- [SOLVED:] mismatch when sum values in multiple textboxes (8 replies)
- Application Visible with more than 1 workbook (7 replies)
- Excel VBA folder-search-tool (24 replies)
- [SOLVED:] How to create a values only copy of WB while keeping formatting and filters in tact? (20 replies)
- Excel file always opens in read-only mode when opening from sharepoint (0 replies)
- Open and Close Workbooks | best Practices (5 replies)
- Column getting truncated (7 replies)
- [SOLVED:] Help: Capture file location on the first opening of a workbook/workbook open event (2 replies)
- Script not working after moving data to SharePoint (4 replies)
- [SOLVED:] Worksheet SelectionChange Error - Target.Address - if statement (5 replies)
- [SOLVED:] Userform is not displaying anything when i change a "box" to visible or not visible (8 replies)
- [SOLVED:] Lookup formula not returning the correct result (4 replies)
- Show graph in userform but via sharepoint (1 replies)
- Variant-type object array element is deallocated by With statement (6 replies)
- Userform error (2 replies)
- [SOLVED:] Depending on the marked radio button, the text in the cell changes (2 replies)
- [SOLVED:] Variable look up fields based on Value from different cell. (6 replies)
- Nasty spreadsheet (16 replies)
- [SOLVED:] Macro to split data based on the value from specific column (23 replies)
- [SOLVED:] Adding Conditional Formatting using AND (5 replies)
- [SOLVED:] VBA Autofilter Loop (27 replies)
- I'm trying to perform two validations on a range of cells at the same time (3 replies)
- Join two pieces of code (2 replies)
- [SOLVED:] IIF function in Excel 365 (3 replies)
- [SOLVED:] How to maintain a consolidated checklist for preparing dashboard (17 replies)
- [SOLVED:] Dependant dropdown error (6 replies)
- Find Text Within A Row, Then Copy Information Below That Cell To Second Worksheet (6 replies)
- Making Program work with different number formats (1 replies)
- Please help me to update array between 2 sheets (7 replies)
- List Box, runtime error (4 replies)
- [SOLVED:] Writing trig equations in Excel (10 replies)
- [SOLVED:] Lookup Values from List and Copy data unde headings VBA (7 replies)
- using application.getopenfilename keeps opening new app (9 replies)
- [SOLVED:] Sending emails with attachments (3 replies)
- Excel VBA and arrays (1 replies)
- [SOLVED:] ComboBox display incorrect text (9 replies)
- Connection to cloud based SQL Server database using VBA (1 replies)
- Excel on Android (0 replies)
- [SOLVED:] Merging TXT files in a current worksheet using VBA (15 replies)
- VBA script works when stepped through, but not when run in realtime (13 replies)
- [SOLVED:] Copy Heading number in condition (9 replies)
- VBA error (2 replies)
- [SOLVED:] userform indirect alternative (14 replies)
- Macro that updates values in a function (4 replies)
- [SOLVED:] Please Help! Code For Multiple Checkbox Returning to One cell in Excel VBA User Form (3 replies)
- [SOLVED:] Adding VBA Conditional Formatting (4 replies)
- General VBA Inquiry (3 replies)
- [SOLVED:] Application.Caller return value (13 replies)
- EXCEL VBA VLookUp (4 replies)
- [SOLVED:] Please Help! Code For Option Buttons in Excel VBA User Form (4 replies)
- Extending the data range of a scatter chart by dragging. (0 replies)
- [SOLVED:] VBA - Clean up a table with returning values (6 replies)
- VBA - Convert data table into a long list (multiple columns) (3 replies)
- [SOLVED:] Filter function to pull results based on drop down non VBA solution (1 replies)
- VBA Code to copy data from two sheet ,paste into corresponding sheet (4 replies)
- Import image from path in adjacent cell (7 replies)
- [SOLVED:] clear last but one line to a userform (12 replies)
- MoveLast ERROR (9 replies)
- VBA to make 1st column of a text to columns operation "CLEAN" (2 replies)
- Simplifying Code (7 replies)
- [SOLVED:] clear last line (2 replies)
- VBA - Copy and Paste Data Base into an existing Sheet (1 replies)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.