View Full Version : Excel Help
- [SOLVED:] Userform unload issue (1 replies)
- VBA codeperforming two functions, check column then count all columns & create tables (6 replies)
- Advance Filter : Not showing Particular Filtered Items. (1 replies)
- VBA Coding Related to Data Entry Form (1 replies)
- [SOLVED:] Application.Caller error for AutoShapeType 152 (4 replies)
- Printing excel sheet to pdf (20 replies)
- [SOLVED:] How to change non-tabular data into tabular data with VBA (16 replies)
- Same details load on multiple orders (2 replies)
- [SOLVED:] How to add a single letter to the end of an growing number (3 replies)
- Excel Questions on using "Switch" formula (1 replies)
- using VBA sendkeys with vmware horizon client (2 replies)
- [SOLVED:] Combine rows of data in to one cell (6 replies)
- CALLING MACROS FROM SINGLE USERFORM (3 replies)
- [SOLVED:] Split Function - Allow for variances (2 replies)
- [SOLVED:] Define Worksheet As Public Variable (4 replies)
- A VBA Code which sort values, remove duplicate and vlookup (1 replies)
- [SOLVED:] Copy Down Formulae Row (range of cells) Down to Last Row. (26 replies)
- Cannot pass object to sub-procedure located in worksheet? (2 replies)
- VBA for Date Expiry does not close WorkBook (1 replies)
- Single Column Arrays or Vectors (3 replies)
- [SOLVED:] join models (14 replies)
- Workbook Partial Name Match (7 replies)
- [SOLVED:] Compare rows of two sheets based on multiple columns (5 replies)
- VBA with index + match with 2 criterion issue (0 replies)
- Getting values from specific cells in a dynamic range (0 replies)
- Using VBA To Conditionally Format (0 replies)
- Allocating amount with invoices based on FIFO method (1 replies)
- VBA - Split/Extract data into specific worksheet with formatting (0 replies)
- [SOLVED:] Colon as part of string in Userform Label (4 replies)
- help (1 replies)
- Active Directory Bulk Check (2 replies)
- [SOLVED:] rename sheet and first row. (4 replies)
- [SOLVED:] Referencing a range into formula: explanation (2 replies)
- Room reservation in sort of calendar (3 replies)
- Code to unprotect worksheet in 2016 (3 replies)
- auto draw triangle from cell values in worksheet (2 replies)
- VBA is Stubbornly Interpreting 10/12 as Date (2 replies)
- [VBA-excel 2007] How to check if variable exist on userform (2 replies)
- Extract data from a table using two criteria variables (6 replies)
- [SOLVED:] VBA Matrix Operations Help Needed. (26 replies)
- [SOLVED:] Fisher Yates Shufflein Excel with VBA (3 replies)
- Search function using VBA (3 replies)
- [SOLVED:] Use cell ref in table formula (3 replies)
- [SOLVED:] PAUSE AND WAIT EXCEL VBA (6 replies)
- [SOLVED:] Problems with vlookup on another sheet (2 replies)
- [SOLVED:] Obtain text between words and populate to different cell in another sheet (1 replies)
- [SOLVED:] VBA code to unhide Unhide multiple columns based on multiple values in row (18 replies)
- [SOLVED:] formula (1 replies)
- Select Rows which has specific value (but now Entire Row selection) (2 replies)
- [SOLVED:] Excel, switching between worksheets is "jumpy" (0 replies)
- [SOLVED:] Renaming multiple worksheets from list (2 replies)
- Extracting directly from a text file into excel with specific conditions in theheader (3 replies)
- extracting object browser information (1 replies)
- [SOLVED:] Match, Find, Offset & Sum in loop not working (2 replies)
- [SOLVED:] VBA Sumif in R1C1 style not working (3 replies)
- Comparing two cell range (1 replies)
- [SOLVED:] Extracting Letters from the String (2 replies)
- [SOLVED:] Wildcard Filter Not Working For Dates (2 replies)
- Sum Variable types (3 replies)
- VBA Help (0 replies)
- Unable to View XLS File Created in Office 365 (10 replies)
- [SOLVED:] Trouble with CountIF Function in VBA, I think (5 replies)
- [SOLVED:] Worksheet/Workbook properties (7 replies)
- ByRef Array Button Click (2 replies)
- [SOLVED:] VBA Code for Worst Month from Daily Data (1 replies)
- [SOLVED:] Filling Empty Cells with Data based on Averages (2 replies)
- [SOLVED:] How to make a search filter in Excel Userform that displays the output in the ListBox (2 replies)
- [SOLVED:] VBA cannot resolve type mismatch error with vlookup (4 replies)
- Copy worksheets (names, data and format) from saved data file to open active workbook (4 replies)
- how to make exception when I get message of “if could not find the specified object” (3 replies)
- [SOLVED:] Unable to resolve type mismatch with userform entry (1 replies)
- Daily Cash-flow Forecast Planning (9 replies)
- Returning a Value (10 replies)
- Split range based on total (4 replies)
- coverting if formula to macro (1 replies)
- Sleeper: Macro to populate all the macros to the ribbon (0 replies)
- [SOLVED:] VBA Investment Returns - How to find last day of a month? (2 replies)
- [SOLVED:] Explanation about a specific function (2 replies)
- [SOLVED:] Type Mismatch (4 replies)
- Hide current Roll based on Cell value (1 replies)
- [SOLVED:] Need Help in VBA (4 replies)
- Why can't I UPDATE the SELECTED value from the ListBox? (13 replies)
- Need copied web workbook to overwrite to the same worksheet (1 replies)
- Chart generation loop issue (1 replies)
- [SOLVED:] Find and collate rows with repeated partial text in one column (16 replies)
- [SOLVED:] Run-Time error 9 Subscript out of range (7 replies)
- Filter multiple sheets with same headers in one sheet (0 replies)
- [SOLVED:] Excel VBA events only working on last element of Collection (6 replies)
- Simple Loop For Selecting a Range and Replacing Values (2 replies)
- VBA/macro to filter Pivot Table Filter Field (16 replies)
- Cell reference changes to make a change in URL (4 replies)
- [SOLVED:] Chartobjectsd and SeriesCollection (9 replies)
- Userform & scanner, won't go to the next field (5 replies)
- How to speed up a Change Event Loop (1 replies)
- Help next sheet macro (2 replies)
- [SOLVED:] Crashing UDF - debug tips needed (6 replies)
- Ribbon Toggle Buttons Issue (6 replies)
- [SOLVED:] If find any data on column P add CHECKED word on Column O (0 replies)
- [SOLVED:] How to draw out the WorkSheet properties? (8 replies)
- [SOLVED:] Extracting groups of Options button (5 replies)
- Pop up a help text on userform after hovering the mouse for 1 sec (5 replies)
- [SOLVED:] Worksheet formula Offset 1 Column Left & another Cell (7 replies)
- Change code to search multiple terms across columns (8 replies)
- compare pictures (4 replies)
- Need Help : How to do convert 1 table to another format (7 replies)
- [SOLVED:] Convert negative to positive numbers in range being copied (21 replies)
- VBA Query (7 replies)
- Saving files using Relative Filepath Location (5 replies)
- Conditionally copy content of adjacent cells to different worksheet (6 replies)
- VBA Formula with dynamic range. Please help (2 replies)
- Repeat Bottom Rows on every printed page of a worksheet (2 replies)
- Copy .CSV to .XLS and Formatting (1 replies)
- VBA API Macro Inconsistent (4 replies)
- [SOLVED:] Showing & Hiding Rows based on values (3 replies)
- [SOLVED:] Sum two dynamic totals (0 replies)
- [SOLVED:] Extracting Four Specific Data for each Row. Complex and Disorganized Raw Data. (11 replies)
- [SOLVED:] filter sublist from list in another column then filter that with another criterion (2 replies)
- [SOLVED:] Copy cell range onto new tabs sorted in groups (11 replies)
- need help in macro to select a column (2 replies)
- [SOLVED:] Workbook_Open operates inconsistenly (11 replies)
- How to run macro for multiple worksheets (3 replies)
- [SOLVED:] Pivot Table Name Changed Every time when Macro Runs (0 replies)
- [SOLVED:] VBA Copy Value Method not working (13 replies)
- VBA: Loop a simple calculation through a 2 dimensional array (1 replies)
- [SOLVED:] Properties Window - Won't display (Not a Docking issue) (3 replies)
- [SOLVED:] Vba to save range with formulas as values if date is less than today. (4 replies)
- Pasting and editing data formats in excel (2 replies)
- Get row number from a closed workbook (7 replies)
- [SOLVED:] Copy data based on pivot table (3 replies)
- [SOLVED:] Auto close userform when video ends (5 replies)
- [SOLVED:] Remove Duplicates keeping most recent change (6 replies)
- Update Data of Charts (4 replies)
- [SOLVED:] Commission Percent based on Gross Margin Percent Formula (1 replies)
- VBA File/Path Error (5 replies)
- [SOLVED:] 2 change events on 1 worksheet (6 replies)
- Allow Auto Data Entry into a locked cell. (3 replies)
- [SOLVED:] Excel VBA: Copy cell values to next empty row in table when row contains formulas. (1 replies)
- vba chart series formula property (2 replies)
- Work Books Sheets copy to Multiple WorkBooks and Rename and Save (1 replies)
- Mac Office 2019 - Any different than Office 2016? (1 replies)
- Extract FIlename (including dots) without extension (1 replies)
- Change Color Of Labels As Mouse Moves (Using MouseOver event) (4 replies)
- [SOLVED:] Locking Cells If Certain Values Is Selected (1 replies)
- [SOLVED:] UNable to get vlookup property of worksheet function class (6 replies)
- Copy Worksheet to a New Excel Document and SaveAs... (4 replies)
- [SOLVED:] Copy/Paste files into new folders based on condition (36 replies)
- [SOLVED:] Search multiple ranges for two specific above values and modify an offset (8 replies)
- Search Characters Within String (6 replies)
- [SOLVED:] Hide Rows (2 replies)
- VBA Lag/Delay Issue on Import Command Button (2 replies)
- [SOLVED:] vba Personal workbook - I dont get it (2 replies)
- VBA dependent drop down list (1 replies)
- Adding Percentages to a Pivot Table with Calculated Item (0 replies)
- Adjust VBA-Excel split code to combine similar tab names (4 replies)
- VBA to loop through an array (4 replies)
- [SOLVED:] Save file to a different folder, add to file name & change from .xlsm to .xlsx (4 replies)
- Populate single listbox merging different ranges from different sheets (7 replies)
- Data Entry VBA Form (3 replies)
- Dynamically Added Checkbox Is Not Shown While Clicked (1 replies)
- VBA/Macro. Hashtag Generator. (0 replies)
- What's the difference between the dims of Array ? (1 replies)
- VBA: Match row data with below cells and fill cell with data condition (0 replies)
- [SOLVED:] Stop user from pressing CTRL + BREAK (16 replies)
- vba property in lcase (2 replies)
- [SOLVED:] How to reduce file open time and screen flicker (with custom RibbonXML) (2 replies)
- Anyone have any idea on this code to speed up macros (5 replies)
- Simple VBA: Copy cell data from the top row in below cells (in the respective column) (0 replies)
- link pivot tables to existing slicer(s) - error "invalid procedure call or argument" (1 replies)
- Concatenating two ranges in MATCH function (6 replies)
- loop (4 replies)
- VBA Copy Last Row into Last Row on Another Workbook (7 replies)
- [SOLVED:] excel vba permission denied run time error 70 (5 replies)
- [SOLVED:] RUN ADD-IN AS PART OF MACRO (3 replies)
- [SOLVED:] A working macro that I need to change the search range and write location (12 replies)
- [SOLVED:] Select Cells Excel VBA (7 replies)
- VBA: Cross-match first two sheets and save result sheet as excel workbook. (7 replies)
- Pivot table changing from tabular view to compact view automatically (1 replies)
- Copy Data till Last Row and Column (2 replies)
- advance filter (7 replies)
- Scatter Plot with Filter option (0 replies)
- Lock Black Colored Cells (Revised) (3 replies)
- Remove Duplicates By Making Them Unique (3 replies)
- VBA for Slicer & Table Formatting (0 replies)
- Best way to create dynamic named ranges (6 replies)
- [SOLVED:] Remove Duplicate Data by Specify Columns and Their Date (2 replies)
- [SOLVED:] If Formula with Year Function (2 replies)
- vba for shifting or arranging certain column with respect to Data1 sheet (1 replies)
- Extract rows of data based on a criteria (4 replies)
- [SOLVED:] How To Show A System Tray Notification Balloon (5 replies)
- Code addition of rows (3 replies)
- [SOLVED:] VBA code copy and paste (3 replies)
- VBA - help optimise/clean up the code (2 replies)
- [SOLVED:] Possible Combination (12 replies)
- List box error 308 (13 replies)
- Reading the XML of a workbook (3 replies)
- Replacement for PLX-DAQ Add-In (0 replies)
- [SOLVED:] VBA myFSO GetFolder path problem (2 replies)
- [SOLVED:] Excell userform requiring boxes to be populated with filenames (5 replies)
- How to create and manage user access (8 replies)
- 64 bit excel question (2 replies)
- [SOLVED:] VBA: USE InStrRev to get file Name (3 replies)
- [SLEEPER:] Merge few files with few sheets to one sheet (0 replies)
- [SOLVED:] ADDING INDICATOR ICONS TO EXCEL USERFORM (3 replies)
- How to use arrays to filter and find information (29 replies)
- Bluezone 7.1 and Excel VBA (2 replies)
- Runtime 50290 error When trying to enter Time value in a Range (19 replies)
- [SOLVED:] Please need some help to edit my macro (Copy colored words) (3 replies)
- [SOLVED:] Help for interpretation of the code (4 replies)
- [SOLVED:] How to find the top5 and bottom5 values without using large or small (7 replies)
- [SOLVED:] Userform with File Selector Process not working (4 replies)
- [SOLVED:] How to set up spreadsheet for regression analysis in Excel 2016 (32 replies)
- [SOLVED:] Any way to make this apply to a larger selection instead of just 1 cell ? (7 replies)
- Required VBA code to change Color of chart & also formatting (9 replies)
- VBA - Lock the cell based on Conditional Formatting (3 replies)
- ACTIVE X CONTROL MOVES POSITION WHEN MACRO IS RUN (4 replies)
- [SOLVED:] CANNOT PLACE BUTTON IN SPECIFIED LOCATION (5 replies)
- Find and Replace Multiple values in Excel (16 replies)
- VBA: GetObject / Copy and Past is bringing only 255 characters (2 replies)
- Learning VBA (1 replies)
- Automation Error when trying to run stored procedure on SQL server (0 replies)
- [SOLVED:] Modifying VBA code in multiple files (2 replies)
- Run time Error 438 (4 replies)
- Lock pictures so immovable (but do not want to lock objects) (3 replies)
- [SOLVED:] vba cell event change & call macro combination (2 replies)
- Legend Issue (0 replies)
- Array Formula - More than one wildcard in lookup (2 replies)
- To set Date filter on pivot via input box when opening a file (1 replies)
- VBA to check column I and if find data and match the same ID in column A Put Data in. (4 replies)
- LISTFILLRANGE COMBOBOX PROPERTY NOT WORKING (1 replies)
- [SOLVED:] COMBO BOX MISSING, BUT PROPERTIES EXIST (2 replies)
- VBA Counting instances of journeys (6 replies)
- [SOLVED:] Insert progressive numbers in a column but every n rows (3 replies)
- Lock and unlock lines in worksheet based on usrname (6 replies)
- Password protect and unprotect a worksheet/workbook (5 replies)
- Array loop (3 replies)
- [SOLVED:] .AdvancedFilter using an array as the criteria (2 replies)
- INSERT TEXT AND FORMAT AUTOSHAPE (1 replies)
- excel stops working and crashes when working with excel user form (2 replies)
- Timer/StopWatch - How do I make button turn to red and flash when I click Start? (4 replies)
- Display CopyFromRecordset result vertically (2 replies)
- Help to separate two codes and place one in a Userform Function (0 replies)
- Need Help Re-writing Recorded Macro (3 replies)
- [SOLVED:] VBA creating new folders and files (10 replies)
- [SOLVED:] Remove excess cells (5 replies)
- [SOLVED:] Msg Box Problem (4 replies)
- Lookup formula Corresponding value in anywhere in array (0 replies)
- Long if statements with numbers. (1 replies)
- [SOLVED:] macro or VBA code "is it possible?" (13 replies)
- Extract Unique List That Meets Criteria (3 replies)
- [SOLVED:] Set Worksheet to variable name (3 replies)
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.