Excel Help [Archive] - Page 159

How to use arrays to filter and find information
[SOLVED:] ADDING INDICATOR ICONS TO EXCEL USERFORM
[SLEEPER:] Merge few files with few sheets to one sheet
[SOLVED:] VBA: USE InStrRev to get file Name
64 bit excel question
How to create and manage user access
[SOLVED:] Excell userform requiring boxes to be populated with filenames
[SOLVED:] VBA myFSO GetFolder path problem
Replacement for PLX-DAQ Add-In
Reading the XML of a workbook
List box error 308
[SOLVED:] Possible Combination
VBA - help optimise/clean up the code
[SOLVED:] VBA code copy and paste
Code addition of rows
[SOLVED:] How To Show A System Tray Notification Balloon
Extract rows of data based on a criteria
vba for shifting or arranging certain column with respect to Data1 sheet
[SOLVED:] If Formula with Year Function
[SOLVED:] Remove Duplicate Data by Specify Columns and Their Date
Best way to create dynamic named ranges
[SLEEPER:] VBA for Slicer & Table Formatting
Remove Duplicates By Making Them Unique
Lock Black Colored Cells (Revised)
Scatter Plot with Filter option
advance filter
Copy Data till Last Row and Column
Pivot table changing from tabular view to compact view automatically
VBA: Cross-match first two sheets and save result sheet as excel workbook.
[SOLVED:] Select Cells Excel VBA
[SOLVED:] A working macro that I need to change the search range and write location
[SOLVED:] RUN ADD-IN AS PART OF MACRO
[SOLVED:] excel vba permission denied run time error 70
VBA Copy Last Row into Last Row on Another Workbook
loop
Concatenating two ranges in MATCH function
link pivot tables to existing slicer(s) - error "invalid procedure call or argument"
Simple VBA: Copy cell data from the top row in below cells (in the respective column)
Anyone have any idea on this code to speed up macros
[SOLVED:] How to reduce file open time and screen flicker (with custom RibbonXML)
vba property in lcase
[SOLVED:] Stop user from pressing CTRL + BREAK
VBA: Match row data with below cells and fill cell with data condition
What's the difference between the dims of Array ?
VBA/Macro. Hashtag Generator.
Dynamically Added Checkbox Is Not Shown While Clicked
Data Entry VBA Form
Populate single listbox merging different ranges from different sheets
[SOLVED:] Save file to a different folder, add to file name & change from .xlsm to .xlsx
VBA to loop through an array
Adjust VBA-Excel split code to combine similar tab names
Adding Percentages to a Pivot Table with Calculated Item
VBA dependent drop down list
[SOLVED:] vba Personal workbook - I dont get it
VBA Lag/Delay Issue on Import Command Button
[SOLVED:] Hide Rows
[SLEEPER:] Search Characters Within String
[SOLVED:] Search multiple ranges for two specific above values and modify an offset
[SOLVED:] Copy/Paste files into new folders based on condition
Copy Worksheet to a New Excel Document and SaveAs...
[SOLVED:] UNable to get vlookup property of worksheet function class
[SOLVED:] Locking Cells If Certain Values Is Selected
Change Color Of Labels As Mouse Moves (Using MouseOver event)
Extract FIlename (including dots) without extension
Mac Office 2019 - Any different than Office 2016?
Work Books Sheets copy to Multiple WorkBooks and Rename and Save
vba chart series formula property
[SOLVED:] Excel VBA: Copy cell values to next empty row in table when row contains formulas.
Allow Auto Data Entry into a locked cell.
[SOLVED:] 2 change events on 1 worksheet
VBA File/Path Error
[SOLVED:] Commission Percent based on Gross Margin Percent Formula
Update Data of Charts
[SOLVED:] Remove Duplicates keeping most recent change
[SOLVED:] Auto close userform when video ends
[SOLVED:] Copy data based on pivot table
[SLEEPER:] Get row number from a closed workbook
Pasting and editing data formats in excel
[SOLVED:] Vba to save range with formulas as values if date is less than today.
[SOLVED:] Properties Window - Won't display (Not a Docking issue)
VBA: Loop a simple calculation through a 2 dimensional array
[SOLVED:] VBA Copy Value Method not working
[SOLVED:] Pivot Table Name Changed Every time when Macro Runs
How to run macro for multiple worksheets
[SOLVED:] Workbook_Open operates inconsistenly
need help in macro to select a column
[SOLVED:] Copy cell range onto new tabs sorted in groups
[SOLVED:] filter sublist from list in another column then filter that with another criterion
[SOLVED:] Extracting Four Specific Data for each Row. Complex and Disorganized Raw Data.
[SOLVED:] Sum two dynamic totals
[SOLVED:] Showing & Hiding Rows based on values
VBA API Macro Inconsistent
Copy .CSV to .XLS and Formatting
Repeat Bottom Rows on every printed page of a worksheet
VBA Formula with dynamic range. Please help
Conditionally copy content of adjacent cells to different worksheet
Saving files using Relative Filepath Location
VBA Query
[SOLVED:] Convert negative to positive numbers in range being copied
Need Help : How to do convert 1 table to another format
compare pictures
Change code to search multiple terms across columns
[SOLVED:] Worksheet formula Offset 1 Column Left & another Cell
Pop up a help text on userform after hovering the mouse for 1 sec
[SOLVED:] Extracting groups of Options button
[SOLVED:] How to draw out the WorkSheet properties?
[SOLVED:] If find any data on column P add CHECKED word on Column O
Ribbon Toggle Buttons Issue
[SOLVED:] Crashing UDF - debug tips needed
Help next sheet macro
How to speed up a Change Event Loop
Userform & scanner, won't go to the next field
[SOLVED:] Chartobjectsd and SeriesCollection
Cell reference changes to make a change in URL
VBA/macro to filter Pivot Table Filter Field
Simple Loop For Selecting a Range and Replacing Values
[SOLVED:] Excel VBA events only working on last element of Collection
Filter multiple sheets with same headers in one sheet
[SOLVED:] Run-Time error 9 Subscript out of range
[SOLVED:] Find and collate rows with repeated partial text in one column
Chart generation loop issue
Need copied web workbook to overwrite to the same worksheet
Why can't I UPDATE the SELECTED value from the ListBox?
[SOLVED:] Need Help in VBA
Hide current Roll based on Cell value
[SOLVED:] Type Mismatch
[SOLVED:] Explanation about a specific function
[SOLVED:] VBA Investment Returns - How to find last day of a month?
Sleeper: Macro to populate all the macros to the ribbon
coverting if formula to macro
Split range based on total
Returning a Value
Daily Cash-flow Forecast Planning
[SOLVED:] Unable to resolve type mismatch with userform entry
how to make exception when I get message of “if could not find the specified object”
Copy worksheets (names, data and format) from saved data file to open active workbook
[SOLVED:] VBA cannot resolve type mismatch error with vlookup
[SOLVED:] How to make a search filter in Excel Userform that displays the output in the ListBox
[SOLVED:] Filling Empty Cells with Data based on Averages
[SOLVED:] VBA Code for Worst Month from Daily Data
ByRef Array Button Click
[SOLVED:] Worksheet/Workbook properties
[SOLVED:] Trouble with CountIF Function in VBA, I think
Unable to View XLS File Created in Office 365
VBA Help
Sum Variable types
[SOLVED:] Wildcard Filter Not Working For Dates
[SOLVED:] Extracting Letters from the String
Comparing two cell range
[SOLVED:] VBA Sumif in R1C1 style not working
[SOLVED:] Match, Find, Offset & Sum in loop not working
extracting object browser information
Extracting directly from a text file into excel with specific conditions in theheader
[SOLVED:] Renaming multiple worksheets from list
[SOLVED:] Excel, switching between worksheets is "jumpy"
Select Rows which has specific value (but now Entire Row selection)
[SOLVED:] formula
[SOLVED:] VBA code to unhide Unhide multiple columns based on multiple values in row
[SOLVED:] Obtain text between words and populate to different cell in another sheet
[SOLVED:] Problems with vlookup on another sheet
[SOLVED:] PAUSE AND WAIT EXCEL VBA
[SOLVED:] Use cell ref in table formula
Search function using VBA
[SOLVED:] Fisher Yates Shufflein Excel with VBA
[SOLVED:] VBA Matrix Operations Help Needed.
Extract data from a table using two criteria variables
[VBA-excel 2007] How to check if variable exist on userform
VBA is Stubbornly Interpreting 10/12 as Date
auto draw triangle from cell values in worksheet
Code to unprotect worksheet in 2016
Room reservation in sort of calendar
[SOLVED:] Referencing a range into formula: explanation
[SOLVED:] rename sheet and first row.
Active Directory Bulk Check
help
[SOLVED:] Colon as part of string in Userform Label
VBA - Split/Extract data into specific worksheet with formatting
Allocating amount with invoices based on FIFO method
Using VBA To Conditionally Format
Getting values from specific cells in a dynamic range
VBA with index + match with 2 criterion issue
[SOLVED:] Compare rows of two sheets based on multiple columns
Workbook Partial Name Match
[SOLVED:] join models
Single Column Arrays or Vectors
VBA for Date Expiry does not close WorkBook
Cannot pass object to sub-procedure located in worksheet?
[SOLVED:] Copy Down Formulae Row (range of cells) Down to Last Row.
A VBA Code which sort values, remove duplicate and vlookup
[SOLVED:] Define Worksheet As Public Variable
[SOLVED:] Split Function - Allow for variances
CALLING MACROS FROM SINGLE USERFORM
[SOLVED:] Combine rows of data in to one cell
[SLEEPER:] using VBA sendkeys with vmware horizon client
Excel Questions on using "Switch" formula
[SOLVED:] How to add a single letter to the end of an growing number
Same details load on multiple orders
[SOLVED:] How to change non-tabular data into tabular data with VBA
[SLEEPER:] Printing excel sheet to pdf
[SOLVED:] Application.Caller error for AutoShapeType 152
VBA Coding Related to Data Entry Form
Advance Filter : Not showing Particular Filtered Items.
VBA codeperforming two functions, check column then count all columns & create tables
[SOLVED:] Userform unload issue
[SOLVED:] Setting date picker to certain columns only
[SOLVED:] macro to edit part of a cell contents
Application.Run?
[SOLVED:] Data Using Double Click on Header but multiple range
Search textbox and create chart in userform
PROTECT SHEET NAME
[SLEEPER:] Excel auto filter total
Compare two date column in different sheets, return adjacent value in matched dates
Bringing together 2 sets of data
Excel Macro To Combine Multiple Sheets in one only
[SOLVED:] Array problems ... need help
Object not defined while trying to clear contents of row
Unique Concatenate Values
Delete button added to new row and delete row/move sheet.
[SOLVED:] Save specific sheets as separate workbooks
[SOLVED:] VBA Biweekly payments and monthly interest payments
[SOLVED:] How to use previous row's Beginning Balance in calculation
remove line
[SOLVED:] coping conditional format and moving the compare cell with it
find and retrieve a price from a different sheet index match - vlookup?
Select a cell with target.row
Select CSV file and Import - UTF-8
Excel VBA MySQL
Problem with like
Compare the last two months and remove the color in the first Number
[SOLVED:] VBA to Create Data rows for Multi-Valued Columns
Summing up values between 2 criteria in rows
Populate Listbox with Combobox
Formula To Replace Suffixes
Deleting Comment Indicators for Comments in Selected Range
Help!!
[SOLVED:] Populating text boxes
[SOLVED:] Code to know when values in column changes
[SOLVED:] Excel VBA Automation Error (and Crash) when running macro twice
Create UserForm with Vlookup (combobox and textbox)
Filtering a Range into another Range
vba accessing file on server??
[SOLVED:] MessageBox line length
number not found ... error proofing vba macro
[SOLVED:] userform input box to print a page
Help -- updating listbox and worksheet data
How to create a GeoJSON editor with VBA
[SOLVED:] Please help to modify my code
Extract week start and weekend day exclude holidays & weekday excel formula
[SOLVED:] Function to list pdf files within a folder
Special chars to UTF-8