Excel Help [Archive] - Page 166

Searching for Macro
Arrays in VBA errors
Listbox and name manager comparison
How to a reference to a new sheet in same workbook
Sum function in other sheet
Maximum Limit for MMULT()
[SOLVED:] Sorting one Column in a Table
[SOLVED:] RE: VBA auto filter Iterate through each criteria
[SLEEPER:] Hilbert Curve VBA
[SOLVED:] VBA error: Run time error "424":Object require(pull data from HTML Element)
fixing show message when open workbook from dialog to copy data
[SOLVED:] if cell value in range = "code" then copy paste value to last used row another sheet
Finding Keywords from Text String - Formula
CommandButton1_automatically update the date in ("A") column
Insert new row for breakdown detail data
Put NA on cells with dates before indicated start week
text in cell in condition
[SOLVED:] How to copy the most current file from one folder to another
Need help to Code VBA using the combination of text and date format
Hundreds of sheets, trying to loop through and extract specific columns
find replace
[SOLVED:] Value from UserForm to Worksheet - Accounting format - (How to?)
VBA - Count # of cells in Column B that are greater in value than in Column A
[SLEEPER:] Last update field formula on Google sheet
Calendar to bring the Leave Type from Leave Data to Calendar
Total dummy when it comes to VBA, so hoping someone can help!
Filter based on two columns
[SOLVED:] adjusting code search files into folder and sub folder
[SOLVED:] VBA - hiding column based on value of cell
Excel VBA problem on application.inputbox that returns range
[SOLVED:] How to remove rows based on filters?
[SOLVED:] Calculating between 2 worksheets
Sleeper: Copying a Value to an Addess Reference which is Nested in Another Cell
Convert a formula to UDF Function
[SOLVED:] Stacked Chart Percentages
Change all Workbook Connection Strings
Assigning a value to the specified cells?
Perform action with dynamic ActiveX button
[SOLVED:] transferring a column from sheet to sheet with the help of button
Single & Double-Click a Shape Object
Transfer the values from one sheet to another by adding them to below of previous row
Search in Excel specific word, delete all rows who does not have that word
[SOLVED:] Excel VBA to create a series of new pivot tables
Sleeper: Compare two sets of data with multiple conditions
Looking to condense data with quantity totals
VBA Code to pull data dynamically from multiple sheet tabs
How to subtract number of hours from 24 hour timezone in alphanumeric format
create uninterrupted sequences of 2,3,4,5,6,7,8. from 01 to 25 goal.
Does Excel 2007 SP3 work without issue on Windows 10?
Validata Lists using offset, match and counta formulas - Different Sheets
[SOLVED:] Return to Cell in Column A after entering value in Column Z
VBA to arrange response value in large database
Text Wrapping - Stuck for a solution
Count number of users active each mont
VBA - Opening File with Yesterday's Date
Roster Automation
Put NA on week dates IN RANGE
Transpose 1 Column to Multiple Rows/Columns
[SOLVED:] VBA -Identify blank fields for user form before submitting -Force User to add data
VB on Time
Duplicating Multiple sheets to all workbooks in folder
VBA Copy paste Images from one cell to another cell on a different sheet
[SOLVED:] Find column header
[SOLVED:] Changing numbers with scientific notation (E+) in pivot table created by VBA
OLAP pivot table vba filtering using VisibleItemsList
Copy data range to a new workbook
[SLEEPER:] Adding a sum total to a Ron de Bruin VBA to email workbooks
[SOLVED:] Formula assistance required.
[SOLVED:] VBA to Find Maximum Value in a Range
[SOLVED:] Dynamic Array not Resizing
[SOLVED:] 3 columns matched create report
Combine specific sheets from multiple workbooks into 1 workbook.
[SOLVED:] copying images from one folder and pasting in another based on schedule in excel file
VBA Help
User Form error
[SOLVED:] Anomaly With Formula
[SOLVED:] Object Required Error when Selecting Range
Index Match to Determine Paste Location
Advice needed to speed up Painting code based on defined colors.
Automatically Printing Autofilters / loop through all filter values then print vba
[SLEEPER:] Convert Excel range into HTML table
Excel pivot fields recognition issue
How do I link a cell to 2 non-bold cells and 1 bold cell and keep that formatting?
[SOLVED:] sum data based on dates from sheet to another
[SOLVED:] Using Application.Run
Copying vales with their number format from Excel into a word table
Insert Multiple Picture into excel thru vba
Dynamic dropdownlist from productlist
[SOLVED:] Help to amend vba to highlight any cells where file paths do not exists
[SLEEPER:] Worksheet object onClickEvent with changing cells issue
Refresh item data in IRibbon combo box
vlookup from Last Modified File in Folder
Assistance needed for converting formula in Array VBA.
transfer if there are no blank cells
XML Map Export and Save
[SLEEPER:] Folder and cell value
Error checking on existing roster
[SOLVED:] Highlight minimum value ignoring 0
[SOLVED:] Loop Vlookup for each cell in range from another worksheet
Updating VBA code to Paste Values only
[SOLVED:] loop through range inserting sum formulas based on start and end indicators (text)
If Checkbox is checked, display message... If checkbox is unchecked, do nothing
'Cascading' comboboxes
create a cubic grid shell in VBA
Pivot Table Copy Paste 5 Days in a Row
Convert Text to cells Sentences by Punctuation Marks
Adding and Activating Reference
packing list serial number generator for boxes
Concatenate Values
Update image/replace image from excel to PowerPoint
Trying to rename individual shapes within a duplicated group.
2007: Issue with graphics shifting when saving to a PDF.
Help with Debugging Code
open file with vba
[SOLVED:] 2007 Formula: Trying to locate a numeric value in a square named range.
Export to PDF (specific sheets) if cells in Input sheet are >0, if condition is met
[SOLVED:] Count number of occurrences via combobox in user form
Excel VBA with Advanced Filter Error messages
help needed to calculate dates and time together
Create New Folder Based on Cell Name and Copy Files into it
Macro or form based solution for attached excel sheet
Help to check string of file name, if meet will copy valu to master workbook
Workbook open event not working
Macro wont run on duplicate columns
[SOLVED:] AutoFilter Percent Values +-5%
[SOLVED:] Sequentially Number Search Using an Array
[SLEEPER:] Intellisense working Sporadically
[SOLVED:] Use dropdown to populate other cells
[SOLVED:] Vlookup to delete entire row on another worksheet
random selection from a growing range
[SOLVED:] VBA Coding Help for Conditional Formatting
[SOLVED:] Fuzzy Lookup add-in VBA
[SOLVED:] Looping through Dates to Determine in Date Falls Between Other Dates
If statement help
Search for Strings Listed in Column A and Insert Offset values in B
Finding IDs
[SLEEPER:] Is there any way to create a macro to keep doing nonlinear regressions?
Auto populate table from another worksheet
[SOLVED:] Multiple find and replace in Excell sheets
Syntax To QuickSort A Range Of Numbers In An Array
[SOLVED:] Copy, Rename and validate multiple excel files
2007 VBA: Cannot figure out recursion to show all possible paths in a 4 x 4 grid.
Run macro run by itself
[SLEEPER:] Create and fill X new rows based on instances of character in cell
Excel VBA data transfer between workbooks
Importing Multiple .Txt Files Into Excel Based on the Date Last Modified in VBA
Counting the number of times a string appears on a filtered worksheet.
[SOLVED:] Convert Many Invoice Formats to a Standard Format
Importing text file into Excel but worksheet names are too long!
[SOLVED:] IF condition is not working with formula
[SOLVED:] Make code more efficient
Exiting Command Prompt window from Excel
[SOLVED:] Create a new folder based on cell and copy list of file into created folder
fixing error code get folder names and files names
VBS for Check the zide and move files
"Run-time error '1004' with .xlt file
[SOLVED:] Date Not Filtering Correctly
Run-time error 1004: The extract range has a missing or invalid field name
Open specific worksheet and hide all other worksheet
[Question] Dynamic amount of averages
Extracting data from excel VBA
Filtering a DefinedName that a ComboBox pulls from within a VBA Form
Add-In Buttons Delete When Excel Closes
SaveAs2 fileformat/encoding not working ???
Help about sorting rows and assigning a new field automatically?
VBA code to copy data from Excel by rows to multiple text files
[SOLVED:] RE: copy paste entire pivot data Using VBA
[SOLVED:] Excel formula syntax
(Question) Make Subtotal ignore ="" Cells
Easy! Need some help, Delete Line from txt file
Change String
Find & Replace - All worksheets except one and with different Target column
Filter Listbox value marching with Combobox value
Auto-expand text rows in protected worksheet - can I do it?
Looking to make this macro Faster
[SOLVED:] SUMPRODUCT HELP?
[SOLVED:] Need assistance copying Cells that just contain certain data
Excel VBA Multiple loops
[SOLVED:] Copy, Find Match in another worksheet, and then Paste Range
Call shortcut only in specific column
Run time error 438
[SOLVED:] Locate a set value and copy the value in the cell that's below it
Code to loop through ws only works on active sheet
[SOLVED:] User forms - Alternatives to Me.Field = "Value"
VBA help for sales report
[SLEEPER:] Use Macro on Teams/Sharepoint/Onedrive
[SOLVED:] Userform search is not working after delete any record
Making a dynamic list.
VBA Help - Code for Report Updates
Populate in listbox
Vlookup not working when Table array refers to a cell with variable
Scroll Bar (Form Control) Offset Table - Sync Scroll Bar Pos. Across Multiple Sheets
[SLEEPER:] Could use some VB help with dealing with combo box data from a Union All query
Last save time
[SOLVED:] Like Operator
Filter/paste rows by months in the near future
[SOLVED:] Need VBA Help With the following info
[SOLVED:] Convert Excel Cell Text in Bold or Italic to HTML Tags/Convert Cell Line Breaks
Upper Case
VBA conks out on very simple code
[SOLVED:] VBA Index Match across two worksheets
VBA help on pulling data from an external workbook
Use a master list to run a macro that opens, extracts, and closes multiple workbooks
Expand VBA code to search Column & Paste Cells to Other Sheet
Type Mismatch error when there is no type mismatch
How to create a macro that puts today's date and time in cell
[SOLVED:] VBA Disbale Copy&Paste in target range (not complete sheet/workbook)
[SOLVED:] Drag tool to adjust formulas correctly
How to fix a messed Excel sheet and make a proper format?
Extract and move records , then delete from master sheet
[SOLVED:] Function for checking and opening a workbook
[SLEEPER:] VBA Macros 438 runtime error
[SLEEPER:] VBA Sum Array Formulas
[SOLVED:] Custom Sort On Column
Xlsm file problem
VBA Time Stamp for single cell entry
VBA code to open workbooks in a folder, create new sheet, paste headers and formulas?
Change alignment
[SOLVED:] Object Required Error in UnHiding rows
[SOLVED:] VBA code to calculate dates from an event
Macro to find best way to combine numbers to equal a certain sum
VBA look for cell next to first blank, copy and paste
[SOLVED:] RE: Pivot table creation in existing sheet- VBA issues
VBA Code Copy&Paste Request
[SOLVED:] Debugging VBA built on Excel2013 not working on v2016
[SOLVED:] HELP - Calculate Based on Dynamic Variables (What-if Scenario)
excel to pdf print
How to hide/unhide worksheets based on cell value?
Is there a way to protect or lock my macro?
Generating a table of events based on a calendar on a different worksheet
Trouble sorting as part of a Macro
Auto Filter Data from Multiple Worksheets Using only One Combobox
Truncate Data in Excel VBA to prompt Pass or Fail
What function should I use?
Macro to copy a cell value and put in different worksheet
[SOLVED:] Creating an 11 digit number
Formula Assistance Required
VBA
Array of unique values in a Column range
Disable SAVE/SAVE AS and Make Savable Again after Username and Password
Converting three calculators in a workbook into one with a dropdown box (hardcoded)
[SOLVED:] VBA Sum function NOT calculating small values
[SOLVED:] Delete Hidden Rows when Filter applied
Sum with integer
save from template to range value name workbook
[SOLVED:] VBA to add new row above and include formatting
[SOLVED:] Paste to next empty row in another workbook
How to move data between date rows using VBA?
Conflicting Code (Add Row & Move Row to another Worksheet)
[SOLVED:] Requesting help to correct the codes