Excel Help [Archive] - Page 163

Check if labels are visible
[SOLVED:] copy multiple rows of numbers to new location on same sheet.
EXPORTING DATA TO MS ACCESS FOR SIMULTANEOUS MULTI USER
[SOLVED:] Part of a string
[SOLVED:] Delete text line with specific word from multiline cell
Search for a string in text files.
Publish to Sharepoint
[SOLVED:] Transferring selected cells to a new sheet
Sleeper: AdvancedFilter - Unique Column 1, Greater than 0 Column 3
Replacing Date with Period Based on Matrix
auto fit cell height for merged cells in sheet that has protected (locked) cells
Convert Binary to decimal on and vice versa on VBA
Solver in Userform Linked in Excel
Using non-contiguous ranges in Solver VBA
Help VBA search
[SOLVED:] Finding cells formatted with colour gradients of various colours
Like expression with AND or OR
Formula/vba - Summary Report without Pivot
[SOLVED:] VBA - Filling Master Template
Room Booking System
combine multiple txt files
[SOLVED:] How to Add Different Texts to End of Excel Cells Macro
VBA - Collection help..
Date Picker VBA that will work on all versions of excel
Copying multiple text files into one excel but different tabs
MISSING DATA IN EXPORTING CALCULATED QUERYTable FROM ACCESS TO EXCEL USING EXCEL ADO
[SOLVED:] Pull rows from array given two conditions
[SOLVED:] Run-time error '424': Object Required
simple copy-past
Subscript out of range error in VBA code
Replacing multiple numerical values
Insert a line break after word wrap
newbie vba questions & help with posible loop for multiple cell values to sheet
[SOLVED:] VBA- Variable declaration help
VBA Array Help in filtering data with logic
[SOLVED:] Combo Box Index select
[SOLVED:] Combine common worksheet names when splitting a file
[SOLVED:] Turning off alerts issue
[SOLVED:] How to Copy Paste Symbols-Phonetics Data to Excel sheet?
Range.Find Issues
[SOLVED:] When you have one workbook, two windows, does any event happen closing second window?
Is there any event allowing Cancel of closing a Window (not closing a Workbook)?
Apply AutoFilter based on selected cell in another sheet
Declared public variables have ceased to pick up values
[SOLVED:] Copy and rename multiple sheets
Excel 2016 Open Read Only file
[SOLVED:] Interactive Way to Search Based on First Few Characters Typed
[SOLVED:] Between two numbers
[SOLVED:] Clear all textboxes except 1
[SOLVED:] Copy value - Another Excel
Splitting up a String
Delete certain rows and highlight certain cells
How to remove [TAG 001], [TAG 002], [TAG 003], etc from string
Prepare hierarchical and non-numeric pivot tables in Excel
Search string if it contains words from a range then replace with adjacent cell
Inserting Recordeset into Access DB via VBE - Error operation must be an updatable...
[SOLVED:] Sum values vba code
Running macro on files in a folder: impossibly hard!
Count only visible data after filtering
VBA to perform lookup for individual lookup range
[SOLVED:] Cannot show merged cells
copy and change date
[SOLVED:] Copy Data from worksheet to another one with VBA
[SLEEPER:] Bad file name or number - Runtime Error 52
[SOLVED:] Changing Column Headers
VBA code: copy data from sheet and paste values onto another specidied workbook
Get first and last dates (dd/mm/jj) from year range
vba - Extract Unique values from Single Column via Colllection and Dictionary
[SOLVED:] Data Conversion using Dynamic Multi-Dimensional Array
[SOLVED:] Linking a commandbar button to a macro in an addin
Macro for sorting by lot number, splitting table w/new header, then sort by due date
[SOLVED:] Fill Column
Array only returning first column of values
[SOLVED:] Pass Params on Activate event
easy VBA seek for help!
Help with random selection and variable criteria
Multiple Rowsource in combo box?
pick a new interior color from an array when next color is needed
[SOLVED:] How to fetch data from a excel table with multiple rows.
[SOLVED:] Match FileNames and then Merge those PDFs
Userform with listbox and checkboxes that finds values on a worksheet
counting number of occurrence of a value and depositing that number in another column
[SOLVED:] Refer to range in cell formula
PLEASE HELP ME!!!
Select Random cells from range
Get name of procedure
Reconciliation based on recurring values
[SOLVED:] [R1C1] Formula with a loop index in VBA
[SOLVED:] VBA code to set print preferences
[SOLVED:] How to Selection.Insert Shift:=xlDown with keep destination formatting?
[SOLVED:] SAVING RANGE AS PDF FOR MULTIPLE FILES
[SOLVED:] Problem with hiding rows
Multiple dropdown list
Excel Sumproduct Count Blank Cell as well...
Caption label
Modify macro to output to Combobox
Extract Items from String and then Sort
Matching data from columns with offset multiple row data in other worksheet
Cell content as part of filename
Count colored cells in a range using columns and rows, output result
VBA scrip to sort data inside sheet
Number help
[SOLVED:] Copy / Paste data ranges to specific locations
application.run - return value byRef
Control Tip Text
[SOLVED:] How to get the first & last range value for this type of data...?
Updating a Chart while VBA is running
Copy Multiple Files from Absolute Paths to SharePoint with Same File Names
VBA problem
[SOLVED:] Copy and paste VBA
[SOLVED:] VBA code for selecting data from statement to output sheet
[SOLVED:] VBA Code to remove Data embedded in the "Pick From Drop Down List"
[SOLVED:] Userform open from one worksheet and referencing another worksheet
VBA code not working in 365
Error Handling for InputBoxes
Run-time error 438: Object doesn't support this property or method
[SOLVED:] Copy .pdf files from one location to a new folder based on a list of cell
[SOLVED:] VBA Code to add groupings to subtotals
[SOLVED:] Need help with logic
VBA Advanced filter help..... Criteria excluding a list
[SOLVED:] BeforeSave and Userform: Issues with saving the excel file
[SOLVED:] Multiple selections from drop down list
On editing protected view programmatically , display setting are getting changed .
VBA filter and cell formatting
Copy data from one sheet to another sheet where the values are matching
[SOLVED:] Help import from csv file
Search data using Userform and then scroll through matching records
VBA how to superscript characters in a string following an apostrophe?
[SOLVED:] Declaring Variable Type - Excel 2013
Export as CSV file
User Form - Many Text Boxes - Restrict One Text Box with Password for Editing
Loop through a folder and copy data from files to another WB
Word file - filled using excel and send by email as attachment
Why is my code showing error??
[SOLVED:] VBA to replace previous table and check if one cells value is equal to the previous o
Print to PDF file
[SOLVED:] VBA Code to Run Code Across Multiple Worksheets at One Time
Array issues - one vs two dimensional
[SOLVED:] Excel VBA code to Delete 'Heading 1' from Word Document
Excel to JSON -- bracketing
Findvalue from 2 searchstrings
VLOOKUP not working properly
[SOLVED:] Use .Range("A1:A10000") to end of records?
How can I control when and if my chart updates and not updates?
My chart "hides" from view sometimes after running or when idle.
Two userforms in one sheet
[SOLVED:] Create a File list with metadata
Filepath to reference cell value
[SOLVED:] VLOOKUP Not Updating when Data Repeated
Userform - Compile Error: Invalid qualifier
[SOLVED:] Format transfer to sheet 2 after match in sheet1
Creation of File list in a new Workbook
[SOLVED:] Printout VBA
[SOLVED:] VBA Code to stop loop if cell / range is blank
Crank Nicholson
Crank Nicholson Method
[SOLVED:] 2 separate change events code issue (Floating Cmd Button & List box selection)
Input user form to change cell value
Excel help copy and paste from sheets then move to next row
Formulas NameManager
Excel vba merge cells based on duplicate cell data
Transform data type in column
VBA to Recalculate Grand Total
Application.Match gives 'Type Mismatch' only on descending date values, match type=-1
VBA Code to edit and update existing data
Rename New Sheet?
Macro to clear hidden contents based off other cell values
Update Shared Spreadsheets
Active X Textbox Content to Userform Textbox
[SOLVED:] Button click to change shape color
adjusted code show the data in listbox on userform
VBA pivot table error 5
Making 2 Dependent drop downs
Skip blank from Auto Filter
Runtime Error 438
[SOLVED:] Excel Macro help - If target cell in range of cells.
Code that detects data in cells and pastes data into the next cells
User defined directory not working
Flags on birthday calendar
[SOLVED:] Produce parts list from breakdown
VBA: Filtering for a date range from 2 ComboBoxes for dates
[SOLVED:] Hyperlinks with changing Sheet Names
Set Range Using a Function
Importing pictures by directory string
Debug stops running macro and will only continue in step mode
autofit cell height for merged cells
Search with Table
Yearly Calendar Project
Application.FileDialog clean up
VBA Code to Loop and Calculate Subtotals with blank rows
Backtesting futures using VBA
conditional formatting help
Filling ComboBox?
[SOLVED:] VBA newcomer - help with IF to determine whether to run code
Procedure too large error
Data migration between tabs using VBA
Search and Fill Listbox
vba excel function return #VALUE!
Copy Data from one Worksheet to Another
Convert from range to tables and code support?
[SOLVED:] Find and replace module help
VBA Error When Add / Delete a Row
How to Calculate Standard Dev without using the worksheet function in VBA
[SOLVED:] Abbreviate the next succeeding instances of scientific names
type mismatch error that i didn't get before
subtract today's date from a date in another column
Find cell matching text then get last row before blank
[SLEEPER:] Case issue
[SOLVED:] VBA macro code to expand a certain column
[SOLVED:] Transfer data from Excel to double column of information in Word
[SOLVED:] Vba Custom Format "0000" in File Name
[SOLVED:] Excel VBA to read txt file, input all data into one cell
VBA Update from Excel to SQL Table Contents.
[SOLVED:] Good way to mark a textbox so users know it is required to fill
Sleeper: How to calculate Volume Weighted Average Price (VWAP) of all relevant deals
cumulative sum between two dates
Fetching data in various cells based on on one cell
[SOLVED:] select data using drop down list
[SOLVED:] CTRL + Shift + Down in a Macro
tracking worksheet changes over multiple columns
[SOLVED:] VBA copy / paste to the next specific row
[SOLVED:] Replacing drop downs by two multichoice listboxes to copy&paste in between sheets
[SOLVED:] Data uploading from userform to excel when "No" is selected in msgbox
Store in DataBase
[SOLVED:] struggling with vbYes and vbNo coding
[SOLVED:] Get data in various cells based on a cell value from another sheet
[SOLVED:] VBA to insert blank rows based on conditions
[SOLVED:] Remove Header / Footer from files in folder
Excel Vlookup and multiple search results
[SOLVED:] setting a cell to a formula
[SOLVED:] VBA to calculate TOTAL based on condition
importing sheet from another file - issue with data validation
[SOLVED:] Parenting Calendar in excel exported to CSV for import into google calendar
Change first letter of word to uppercase
[SOLVED:] Removing duplicate from keywords
VBA That Will Group Specific Blank Rows
Form Close
Excel formula help match
VBA Replace From Code to Range
VBA search function
Batch script for inputting data into cells
Sleeper: Cascade String concatenation problem
ClearingContents in ranges that don't intersect
[SOLVED:] Export Multiple wbk
Delete the list from UserForm
Drop down list without blank cell
Data copy from other sheet based on cell value
Issue with code to check whether an excel file is open or not
VBA Help - Avoid triggering a Change Event on Delete
Best Approach to Do This Report