Excel Help [Archive] - Page 158

Searching multiple values
Formatting the data with the help of VBA Macro
copy/paste data from nth column into two columns
How to use VBA to set up equal number of Rows per Page for a worksheet for print
Copy data from "All Levels" sheet to Master Sheet.
Size of Files
EXCEL USER FORM (Update Existing Date and Time)
Combination algorithm for this condition
[SOLVED:] Refactoring & issue with row
[SOLVED:] An application.EnableEvents issue. Help needed.
[SOLVED:] Avoid selection and select in format number
VBA with counting files
How to get a cell property?
[SOLVED:] Compare values in 2 columns, if values match copy value in adjacent cell to new colum
Need help comparing numbers and generating a temporary 'no data found' message.
Auto-Filtering A Dynamic Table and Copy-Pasting to Word Template
Compatibility Checker & Recalculate formula Messages
Filter a table using a different name each time and paste the results in a new file
Find corresponding value in database, the copy whole row to update it.
[SOLVED:] Function does not work. Where is the mistake?
[SOLVED:] Help with Split Function
[SOLVED:] Need Assistance with Pivot Table Change
Floating box Help
VBA for click on BUTTON Internet DOCUMENT
[SOLVED:] Filter a text file and produce a new one
[SOLVED:] Need help- Sort columns within rows numerically. Cells contain text as well as number
Extract data to another sheet according to different filtering conditions (using vba)
Combine rows if there is a blank cell under column A
Can't change Range.value
Macro to auto copy a cell and paste it in a particular column
[SOLVED:] Formula to Return value when a cell falls between two values
Transforming dataset into a different layout (Formula if possible?)
[SOLVED:] Question: Passing objects to sub-procedures
Specific range date on this code
[SOLVED:] Invalid image error :481
[SOLVED:] Opening and editing mutiple csv files
[SOLVED:] Excel MDI vs SDI
Find match from range and copy/paste values to destination row where match found
Create Report based on criteria match
VBA code that Unhide sheet that are hidden using (xlSheetHidden)
Excel VBA conditional insert of page breaks
[SOLVED:] VBA Code to loop once (Do While) Replacing Array, Object Error
[SOLVED:] Unable to Control Cursor at End of Script
Copy Cell Values to Columns if Criteria is Matched in VBA
Formula instead of Pivot Table
Reset Cell Value to Zero every day (after midnight)
matching words from transliteration and replacing using vba
[SOLVED:] Date Format
[SOLVED:] VBA to group and identify
Encryption Decoding VBA String
How prevent open Excel file automatically when open connection to an Excel file
vba code analysing different workbooks
[SOLVED:] Downloading images
Macro to auto-copy a cell and paste it in a another cell at particular times
reference cell font color and value
[SOLVED:] How to assign a variable value in to another variable
#NAME? Error with VBA
VBA button work 3 activity at one click?
[SOLVED:] Save Attachments from Current Open Outlook Email
[SOLVED:] Problem with date comparisson
[SOLVED:] Macro timing issue
[SOLVED:] Data Validation in a MessageBox - VBA
Insert Picture With Cell Reference In Excel VBA Dont Show In Other Computers (Help)
VBA copy and paste with criteria and different sheets
VBA Run-Time Error 13 - Mismatch???
[SOLVED:] Explanation VBA code [Activate+Loop]
[SOLVED:] VBA Message box to display column titles based upon totals
Run several Fast Fourier Transformations in a row
Googletranslate()
matrix rank
[SOLVED:] Run-Time Error '1004"
Problem: Compare two excel files and mark new text.
[SOLVED:] Sum Cell range based on Worksheet title with wildcard.
VBA to copy a Specif sheet from multiple other workbooks in MAC
[SOLVED:] VBA Inputs restricted to specific decimal ending values
[SOLVED:] Is there a consistent way to get a sequential list of controls
[SOLVED:] Deleting Ovals - Logic: If they are above row 70
COMBOBOX Change code not working properly
Print reports from a drop-down list in Excel into one pdf
[SOLVED:] Dynamic range help for conditional formatting rows
[SOLVED:] VBA to resize cells with wrapped text
Seeking help for creating a nested loop with condition
Get Active directory Username Details in Textbox2 based on Textbox1 Value
I want to automatically create pdf and send via outlook email to different addresses
[SOLVED:] Doubleclick add row
Help with analysing consistencies in data set
VBA code to click on Image button in IE
Extracting data from same cell in dierent workheets and files inside a folder or sub
Merge files in one folder to a master worksheet and update
[SOLVED:] filtering with * as one of the multiple criteria
vba for next loop
[SOLVED:] VBA - Use variable from InputBox in formula?
Run-time error ‘-2147467259 (80004005)’
[SOLVED:] User Defined Function vba
VBA Help, Automatically entering passwords on multiple workbooks
Append an order number in a text file with a string and then save
VBA Nest If Statement help
Sleeper: Images Gallery in UserForm
HOW TO COMBINE 2 MACRO INTO 1
Enter a password for multiple protected work books
VBA FOR INSERTING ROWS
Need help with my VBA Dictionary task
EXCEL FORMULA NOT UPDATING CORRECTLY WHEN COPIED FROM ONE YEAR TO THE NEXT.
Pivot Table, Calculated Item - not working on large file
Excel.Action
VBA in shared workbooks
ASSIGN MULTIPLE VARIABLE FROM SINGLE VALUES IN ARRAY
Excel Won't recognise as date (mm/dd/yyyy)
Text to Rows Macro : Subscript out of range
vba new
Check game numbers
Create text files with file names from excel column
vba add
Check first five characters and replace offset
Deleting rows with specific text
listbox population based on search value
XML substitution of values
Doevent and buttons
[SOLVED:] Transfer worksheet to another workbook
Use of the WorksheetFunction INDEX and MATCH
scraping vba dropdownlist
Insert symbol into text box - in the active textbox where the mouse cursor is located
VBA to compare and update data on Master Sheet/workbook from another Sheet/workbook
[SOLVED:] Change ActiveCell within a selected range
Size with Chart property of format picture in VBA
[SOLVED:] SQLiteForExcel Help
FORMULA TO COMBINE MULTIPLES CELLS
[SOLVED:] Excel to Text File
[SOLVED:] If values equal zero command.
[SOLVED:] Multiple concerns with my Sheets
[SOLVED:] Object variable or With block variable not set -Run-Time error 91
Application.FileSearch replacement
[SOLVED:] Include 3 sheets only in filtering
Splitting data by range
[SOLVED:] Excel Ribbon
[SOLVED:] Display 3 donut charts based on combobox
[SOLVED:] Visualize state of ADODB recordset in statusbar
[SOLVED:] input data from vba userform textbox to a spreadsheet cell depending on the time/date
1004 error on delete picture on mouseover VBA
[SOLVED:] insert formula via loop including cell contents in a range
copy and paste based on a value present in two sheets
execute netsh with "Run as administrator" in VBA
drag & drop merge with copy-paste-code
Macro for a variable range sum if formula
VBA Code for numbers colors-for different format cell criteria
Send a file to the dropbox with a macro
[SOLVED:] Setting Header/Footer issues
[SOLVED:] Adding line numbers to VBE Code using MZ-Tools
VB Script
[SOLVED:] Listview specific rows conditional formatting
Complicated VBA
Macro to create detailed payment schedule using summary list of bank facilities
How to get Percentage
VBA Conditional Formatting
Multiply VBA InputBox value by cell value derived from json API URL Web Query
[SOLVED:] Hide rows based on username
Index Match and Wildcard *
Header/Footer Print settings optimization
Transponse each n rows + merge rows periodically
[SOLVED:] Save customrange to csv file
[SOLVED:] Opening unknown File names in known Folder
[SOLVED:] need help on using results from formula to use in case macro
Normalising Data in Excel with VBA
Pivot table data sorting in percentage problem
Userform to filter ,add and edit data
Fill Listview form 3 identical sheets (with same headers)
VBA error on clearing cells
VBA: Create a List of Userforms and make check visible one's
[SOLVED:] VBA CODE TO INSERT CHECKMARK ON ANOTHER SHEET
VBA COPY PASTE DYNAMIC RANGE EXCEPT HEADERS
Check combos values and add if not already added
LISTDATA MISSING FROM COMBOBOX PROPERTIES
Custom Save Button
[SOLVED:] Having trouble performing a few tasks in VBA, possibly need a loop?
[SOLVED:] vba userform textbox Value from date picker (Monthview)
[VBA] (Challange) Match dates between two workbooks and export data
Count Listview subitems based on condition
Button Click
Sleeper: Make a more complex VLOOKUP formula
Help with find/replace loop.
VBA Dynamic array
[SOLVED:] Trying to return Table Column rather than Sheet Column from Find method
Getting max value from a dictionary
Formula to import and sort data from other sheet based on dates
Change ActiveX Image Control from UserForm
[SOLVED:] excel macro help
Move file to new folder based on cell value, create folder if not already exist
open workbook
[SOLVED:] Userform instructions
VBA save a variable when criteria is met
Populate a cell percentage based on amount of dates in a range of cells.
How to rename TextBoxes on userform
Ignoring Error VBA
ControlTip Text not showing in excel Userform
USERFORM WITH MULTIPLE ENTRY LINES
[SOLVED:] Sub Not Defined error when using a renamed combobox
VBA restaurant ordering form
Highlight cells with inputbox
VBA Conditional Format Error 9
[SOLVED:] Paste and End(xlRight)
Copy Paste Without Opening The .csv file/s
How to make my combobox invisible
Comparing two columns with empty rows but same data and delete
Allow access to certain sheets in a workbook
Copy And Paste All Rows That Match A Specific Criteria
Copy calculated data ranges in Sheet2 O:O to Sheet1 offset column block areas in C:C
vba example
VBA Row offset when dynamically changing cell value
[SOLVED:] Set Worksheet to variable name
Extract Unique List That Meets Criteria
[SOLVED:] macro or VBA code "is it possible?"
Long if statements with numbers.
Lookup formula Corresponding value in anywhere in array
[SOLVED:] Msg Box Problem
[SOLVED:] Remove excess cells
[SOLVED:] VBA creating new folders and files
Need Help Re-writing Recorded Macro
Help to separate two codes and place one in a Userform Function
Display CopyFromRecordset result vertically
Timer/StopWatch - How do I make button turn to red and flash when I click Start?
excel stops working and crashes when working with excel user form
INSERT TEXT AND FORMAT AUTOSHAPE
[SOLVED:] .AdvancedFilter using an array as the criteria
Array loop
Password protect and unprotect a worksheet/workbook
Lock and unlock lines in worksheet based on usrname
[SOLVED:] Insert progressive numbers in a column but every n rows
VBA Counting instances of journeys
[SOLVED:] COMBO BOX MISSING, BUT PROPERTIES EXIST
LISTFILLRANGE COMBOBOX PROPERTY NOT WORKING
VBA to check column I and if find data and match the same ID in column A Put Data in.
To set Date filter on pivot via input box when opening a file
Array Formula - More than one wildcard in lookup
Legend Issue
[SOLVED:] vba cell event change & call macro combination
Lock pictures so immovable (but do not want to lock objects)
Run time Error 438
[SOLVED:] Modifying VBA code in multiple files
Automation Error when trying to run stored procedure on SQL server
Learning VBA
VBA: GetObject / Copy and Past is bringing only 255 characters
Find and Replace Multiple values in Excel
[SOLVED:] CANNOT PLACE BUTTON IN SPECIFIED LOCATION
ACTIVE X CONTROL MOVES POSITION WHEN MACRO IS RUN
VBA - Lock the cell based on Conditional Formatting
Required VBA code to change Color of chart & also formatting
[SOLVED:] Any way to make this apply to a larger selection instead of just 1 cell ?
[SOLVED:] How to set up spreadsheet for regression analysis in Excel 2016
[SOLVED:] Userform with File Selector Process not working
[SOLVED:] How to find the top5 and bottom5 values without using large or small