Excel Help [Archive] - Page 154

[SOLVED:] Vba how to check workbook name first before opening it
[SOLVED:] Delete the value of cell that start by char with exception .
copy entire row from sheet1 into sheet2 if ID matches and column header should match
OptionButton LinkedCell trouble
Download Csv file from the Website VBA
Chart with Dynamic Row and Column Count Help needed
Variable x,y axis scales, series names and chart title
[SOLVED:] VBA Before Double-Click Event executing when not desirable
[SOLVED:] VBA help please
[SOLVED:] Infinite VBA Loop
Macro to Insert Objects from folders and move it to respective Sheets
[SOLVED:] VBA Macro to select and bring back a new campaign code
vba array /loop help
Copying data from one sheet to another
INDEX MATCH with 2 range criteria in the same sheet
VBA code for adding a new value in data range using user form
[SOLVED:] RE-ORDER and Inserting Columns of two Workbooks.
[SOLVED:] Custom sort with placeholders
Refresh MS Query - Password Issue
static "fake" pivot table
Fill Internet Form
time deduction
[SOLVED:] How to set loop for selecting columns and converting numbers stored as text
Send E-Mail via Macro if Workbook was saved and the was name changed aswell
[SOLVED:] VBA Code to create a list of changes from a workbook.
Help with VBA coding
To copy specific columns from a raw file to another workbook
Change color of numeric characters
Help with my code (Finding specific max values and applying it for other column)
Close Workbook After Idle
Filter - Copy - Paste
Formula Help
Outlook Calander Appointments With Excel
VBA code for a routine process
VBA Code Updating Word Doc Bookmarks Data to Push New Data from Excel Cells
Shared Workbook Which Has 12 Worksheets
[SOLVED:] Loop and copy paste part numbers based on qty
[SOLVED:] An Array of Sheet Names
Advice for my prank code
Excel recalculate everytime i write in a cell
List Box issue
Help Combining Two Private Sub's Into One
Copy specific data from a worksheet containing searchable comboboxes to another sheet
Test if active cell is within 2 separate unrelated ranges
I don't know what to do with message in Excel
[SOLVED:] help with understanding loops and multiplying integers
[SOLVED:] Excel 2013 - How to check whether a chart series is selected
[SOLVED:] Change Mulitple Userform Label Backcolors (Excel 2013)
VBA excel looping to subfolders outlook
[SLEEPER:] VBA wait on VBScript to finish?
How to read values in custom tab of file properties dialog box in windows.
Removing uncommon entries between two lists of names+data
compare 3 arrays. If uniqe in dimmesion (2,3,4) then check and copy to Tab1 or Tab3
to many line continuations during parsing
vba algorithm
VBA capturing screenshot
[SLEEPER:] Loop based on count of serial number and fill formula
excel vba replace
ROW DUPLICATION WITH MULTIPLE VLOOKUP VALUES
VBA Conditional Formatting Help
[SOLVED:] Sum of all months
[SOLVED:] Setting 1 range in 1 Workbook equal to another range in another workbook
VBA API Parsing and pasting json string to excel spreadsheet. run time 13 error
Data Retrieval
Checkbox to write values to multiple cells
Transferring Data
Looking to Highlight Certain Phrases
Export Multiple Sheets and Save As a new file
vlookup range in another sheet
[SOLVED:] VBA Code to copy data from one sheet to another based on date
Transpose Tables arranged horizontally to vertically
[SOLVED:] Checkbox Loop
my code is working.... almost
Can't get a loop to spit out individual files...
[SOLVED:] Sum on the basis of multiple creterias
VBA - Recursive Function modify Code - Output ERROR
[SOLVED:] VBA help to compare 2 sheets and pick out duplicates
[SOLVED:] SIMPLE vertical timeline ...
Array add dropdown Combobox for UserForm
[SOLVED:] Find and color text with Text List
[SOLVED:] color uppercase words
Copy and past whole rows to a different tab based on two criteria
[SOLVED:] Shape Fill Color Does Not Change (Excel 2013)
[SOLVED:] Display Cell Contents - in ListBox
pls help conditinal formating or vba
Macros to copy from desirable worksheets to the same worksheets in another workbook
[SOLVED:] Ensure Selected Item in Listbox does not exist in Range
[SOLVED:] Sort and spilit into column from one cell
VBA to email each sheet in a workbook
Moving Folder to another Folder if name of folder and cell match
Pivot > show all data
[SOLVED:] Shapes Array (Excel 2013)
Run-time eerror 424
Highlight Duplicates based on Different year in each row.
Add string of text to a specific point in every cells
Rename Files
[SLEEPER:] Excel VB "Unprotect" workbook statement
[SOLVED:] Setfocus in Access form FROM within Excel ?
VBA - Removing a Sheet based on a condition (else a message box)
getting #N/D on function.transpose
Creating shapes and position them
VLOOKUP VBA FORMULA
[SOLVED:] Start From Last Column - Sequential Number
Copy text to cell from another sheet
Moving Files & Folders by Last Modified Date
[SOLVED:] Sum on the basis of mutiple criteria
[SOLVED:] Find values in a range then copy and paste data to different column
Autofilter, copy, paste to new file
Count Highlighted Cells In Each Column
[SOLVED:] Run Macro only if selected by left click
Sheets change every few seconds in a loop
Extract URL with the hashtag #
[SLEEPER:] Copy particular columns from one file to master file with condition
Help with VBA to send email to several recipients listed in different columsn
[SOLVED:] ListBox - PreSelect Values
[SOLVED:] Quick VBA find question
[SOLVED:] Class Event for ComboBox Enter (Excel 2013)
Userform too much loaded
excel - search for document and open
[SOLVED:] Conditional Formatting Help
#1 VBA to sort data from multiple worksheets into a worksheet (same workbook)
Problem in automating form filling web page.
[SOLVED:] VBA to send 1 email containing all attachments
Run-Time Error 53 File not found
Pass Chart Data Point number to variable
sending email with multiple attachments
Excel VBA Highlighting dates in a range which match a date from an inputbox
Convert Row Range formula result to Value
[SOLVED:] Underline specific text in shape caption. (Excel 2013)
VBA FOR TWO INTERACTING DATA VLAIDATION DROPDOWNS
Amalgamating and texting
SUM IFS CONDITION COMPLEX SCENARIO
How to create a dynamic range for vlookup based on active cell
[SLEEPER:] Logic to pull directory, two tabs and transpose data
VBA code to seend seperate sheets as PDF to seperate emails
VBA Code help - Search files within folders and return file name and path
VBA code to delete contents of one cell based on change in another
[SOLVED:] Send e-mail with multiple range in body of e-mail
[SOLVED:] Merge specific worksheet from multiple workbooks into a single worksheet
[SOLVED:] If E and F is empy paste to column
Counting Number of Colors in a sheet (not Number of Colored cells)
[SOLVED:] change from vba code (const as date) to (cell.value in worksheet)
[SOLVED:] Find all cells with certain value and delete the whole row
After uppdating cell excel jumps to other sheet
VBA code help 2016
Multipage: When I change the page the date changes.
VBA code to print unique values and corresponding values from the other coloumn
VBA not to show excel file, excel logo, excel ico but only show a User form
[SOLVED:] Auto Fill Next Blank Cell in a Row with Value from the Row Above
[SOLVED:] Compare 2 Sheet and by 2 column and compare date get the value on sheet 1
[SOLVED:] Import .csv file
Extract data from the outlook mail which has attached excel file
[SOLVED:] Error - Duplicate record after filtering n the Header can't be copied to new workbook
Complex VBA - Trying to use specific online calculator and download data to excel
VBA Textbox get last entry from time stamp
problem getting internet values
Code to hide row if no value
[SOLVED:] How to copy and paste only bold parts of string and not unbold parts of string?
Send Notes Mail out of Excel with monospaced body
Cntl+. macro ?
Dlookup only works when Access is open
[SOLVED:] Increment number sequence by two conditions
[SLEEPER:] VBA code errors for exporting sheets as individual PDFs
Getting “Type Mismatch” with VBA PivotTables and Filter Dates
[SOLVED:] Excel VB to hide an entire row based on sheet name match and cell dynamically.
How Many Coctail With Fruit From İnventory(most effective ways)
Impossible to trigger a value input in a menu with VBA (javascript)
VBA to replace text in a single column
[SOLVED:] inputbox vba problem
[SOLVED:] VBA: Detect if the webpage on Internet Explorer is loaded
[SOLVED:] PDF from a macro in excel
[SOLVED:] How To Load Macro onto Exported Excel Sheet
[SLEEPER:] Can you query a RECORDSET using SQL
[SOLVED:] Placing comma separated values into the corresponding cell
VBA - change color with double click and count cells based on color
Date calculation and formula
[SOLVED:] Problem with Range().EntireRow.Insert when creating insertRow sub
Runtime error 438
Update the Master Workbook from the Copy.
How to insert a specific row from my sheet, into the email-body using VBA-Excel
HTML Scraping
Userform Listbox Search Function
Transfer Data from one sheet to another sheet to create invoices
Copy data from excel which receive in outlook mail
Draw line around page margins
VBA code for plotting ternary in excel
Code to copy row if two criteria match
INDEX/MATCH formula with INDEX return being in row higher than MATCH value (xlUP)
Most efficient way of finding the last row.
Copying specific fields of multiple txt files into one master excel
Out of places to turn for Time and date stamp help
Change the list contents in a cell, when changing the contents in another cell.
If and Index and Match against a couple of different conditions
MAcro Creation Date
Can VBA record multiple iteration wb results with for next loop from a range of data?
Excel VBA
How to disable the sheets protection
[SOLVED:] I need to create a macro, but unsure of what formulas to put into it
Automation of Drop Down list
[SOLVED:] Wrong customer apprearing
[SOLVED:] Excel Optionbutton Calculations
problem getting internet values
Filtered data in Listbox based on Option buttons EXCEL VBA
[SOLVED:] Code for Pivot
Find Copy and Paste
[SOLVED:] Copy Values if name of sheets in two different workbooks are equal
Call data from another sheet based on multi critiria
[SOLVED:] syntax problem with a While nested into a Loop (for an Array)
Auto Updating Row for Sum Grand Total
Code for selecting data and paste in another tab
Copy rows with specific values and paste within the same worksheet
[SOLVED:] How Do I Change The Date Format in VBA Code
Copy Cell Values Using If Statements through VBA Code
Looping through combo box
[SLEEPER:] VBA Script locks the excel sheet
Assign exact dates of material availability to each production order
How can you use a variable to reference a worksheet object?
Spell check stopped working
Is there a cleaner way to write this formula?
VBA Userform (Excel 2016) - Textbox date calculations: Date + No. of days=Expiry Date
[SOLVED:] Trim and LCase values in an array
Macro to recover an excel encrypted workbook
[SOLVED:] Dynamic vlookup refering different workbooks through VBA
[SOLVED:] Saving worksheet range without formula to array
[SOLVED:] could not set the list property. Invalid property value error
[SOLVED:] Multiple Frames on A Excel UserForm and switch the visibility
Filtering data on multiple creterias
VBA: Internet Explorer zoom level
[SOLVED:] For Loop for 2 Range
[SLEEPER:] Help with Merge in Excel
[SOLVED:] Textjoin help needed
VBA breaks when it comes to deleting command button and selecting A1 cell
[SOLVED:] Import most recent xml file
[SOLVED:] Average and addtional conditions
automatically hide/unhide the row based another sheet cell value.
[SOLVED:] Hide/Unhide Rows Based on Cell Value
[SOLVED:] Concatenate Transpose - Multiple with Multiple
Customized Footers with VBA
Extracting data from a variable length string
Hiding ribbon commands
[SLEEPER:] Reading value from another application
[SLEEPER:] Time formula
In work materials vs delivery date
[Help] VBA for scheduling
golf 4somes
Test to determine workload
Else without IF error !!!
Data lookup formulas
Moving data between sheets based on headers
Numbers update as per Pivot table