Excel Help [Archive] - Page 137

Speed run time of code
Move rows that meet criteria of sheet from multiple workbooks to other workbook (VBA)
Identifying Duplicate E-mail Addresses with Different First and Last Names
[SOLVED:] VBA Help - Code to create a copy of a macro enabled workbook
Passing Excel macro variable to access macro
[SOLVED:] macro stops if no data in filterd criteria
[SOLVED:] VBA to replace numerical data with Alphnumerical data.
VBA date
[SOLVED:] Checkbox populated by worksheet cells via userform
[SOLVED:] Filter columns from negative values for Histogram Chart
[SOLVED:] Sum values between two specified dates
[SOLVED:] Help to convert COUNTIFS to VBA
[SOLVED:] testing for correlation matrix
excel vba error 91 object variable or with block variable not set
Frustrated need help with Email code Excel, Lotus, Attachements
Errors dumping an Array to a range in a table
Need explanation to save file as
END IF WITHOUT BLOCK IF
Choosing/listing from existing database
[SOLVED:] Loop through folder only opens one file
Paste Special: PasteSpecial method of Range class failed
Run-Time Error '1004' Delete method of Range class failed
Extract data with one criteria and no duplicate
Date picker
Creating workbooks/sheets based on a tables in a master workbook
copy data from a range in sheet into rows in another sheet
Listing text files based on search value - returns multiple instances of same record
[SOLVED:] Help with Pasting Values
Passing one function to another
Get the first instance of a value from a range
[SOLVED:] Captilize Select Characters Within A Cell
VBA to download images in web
Using Excel VBA i want to protect a range of cells but other cells should be editable
Converting LEFT and RIGHT with FIND formulas to VBA macros including IFERROR
Help for VBA Code as too much time while processing
Finding blank cells in named range and input 0
Sort files by date in a folder and then use this ordered list to open the files
[SOLVED:] Run Same VBA Macro Code On Multiple Sheets
Vlookup with multiple results
run time error '1004' Help!!!!
Error with Protect and Unprotect through VBA
HTTP Response cookies not retrieved in results for XMLHTTP request in EXCEL Macro
[SOLVED:] Workbook closes "by itself" when some macros run or other workbooks opened.
Checking if other sheets in the workbook contain the same content as a defined cell
[SOLVED:] Match Funtion VBA
How i can exit from compo box after select ?
Change Excel sheet Tab colour when date entered in a cell
Restrict Duplicate Values in a Row using excel VBA
VBA Coding needs advice - To Simplify
[SOLVED:] Copy Values from an array into sheet tab names
Copy-paste extracted data in values to reference sheet (VBA)
[SOLVED:] Clear Contents VBA
Need help creating a formula for multiple sheets of data that will tie into a chart
Daily Data for Entire Year - vba userform
Excel to PPT --- can't detect error in loop
Need Help: Check Sheet Name Exists Before Creating New W/ Same Name
Sleeper: Best way to add a column to a range with offset of n
Choose Invoice Number from a userform combobox and copy data to invoice output
Vba İnformation About The Array() Cells() Property
[VBA] How to trigger a macro with a letter key without "Ctrl"
[SOLVED:] How to avoid to continue searching (on the same sheet) if specific word is found
Advice required to run code faster
Solver VBA code for multiple sheets
[SOLVED:] Conditional Formatting Formula
Solver VBA code for different objective function cells
[SOLVED:] How to populate data from one sheet to another?
[SOLVED:] Filter question
Deleting worksheets with specific name ??
Runtime Error 1004
[SOLVED:] Looping formula
Loop data is not recognized
Different charts in one diagram: chart modification problem
[SOLVED:] Need vba macro to highlight duplicates in a column
[SOLVED:] VBA Calculate Event
[SOLVED:] Copy and Paste Data from One Tab to Another
Loop Through SubFolders Task - Merge Files as Folder Name
[SOLVED:] VBA appears to be missing something please help!!
VBA for highlighting needs revising
Track changes to a column, not when rows are inserted and deleted
Edit rows with userform textboxes and coboboxes
Help with code
[SOLVED:] Delete Sheet Macro Crashes Excel
VBA error on copying workbooks from file location
Help on Excel Project
relative range / Offset within a sum - how to change the range summed
auto scale every chart in a worksheet based on each charts x and y axis min and max v
[SOLVED:] VBA codes clashing
Creating Chart Via VBA
Analog clock with Chart
Windows 10 MISSING: Microsoft Windows Common Controls 6.0 (SP6)
Macro that will consolidate multiple worksheets regardless of worksheet name
Store image in VBA?
[SOLVED:] Copy + Find + Past (2 Files)
[SOLVED:] Excel VBA Date Issue Transfer from one worksheet to another
Extracting Left function -String into Columns
[SOLVED:] How to Compare a textbox entry to a column and find duplicates?
Macro to copy specific data from sheet A to sheet B
[SOLVED:] Mailbatch with 2 different bodies based on cell
[SOLVED:] VBA to merge data and place - between each data from five columns
[SOLVED:] Change event problem
[SOLVED:] Select Active cell to top cell
[SOLVED:] Remove Array Elements
[SOLVED:] Help inserting a variable in to a formula
Lay Dutch Test of dynamic subsets
help, a system to check inventories
Help - Selective look up needed
Copy-paste data from source file to master workbook
Match a string with a string that includes a wildcard (*) excel?
Stock Historic prices on button click
VBA macro for highlighting datain range based on selecting data in another
How to make a dynamic table(dynamic rows and columns) using VBA code
Need Help With Excel Formula
Find yyyymm in date column
Hello masters of VBA... here I am a newie for VBA with a question - please help
VBA to jump to range in contained in a SUMIFS formula
[SOLVED:] Searching selected range (offset) for values in external workbook range
Excel VBA add new list item in SharePoint List
[SOLVED:] Worksheet_SelectionChange(ByVal Target As Range)
Arrays
If statement checking last digit and modifying time
Please Help with VBA code
Macro take multiple screenshots and save in excel
Stephen Bullen's Resize (Userform)
How to Parse Based on Varying SubStrings
[SOLVED:] Trouble Grouping Label and Shape
[SOLVED:] DateDiff in listview excel
[SOLVED:] Sum of cells in a row on other sheet, column reference based on selected number range
Timesheet Help
[SLEEPER:] Macro to savecopyAs multiply based on filter
Simple excel macro if then condition to manipulate column values
Need to copy specific text from open word doc, to excel in a row
Conditional Formatting from one row to another
[SOLVED:] Select Case Conditional Formatting VBA
Convert a value to suit an Excel Speedo's segmented variable scale
How to skip an empty cell in a column ?
[SOLVED:] Save a certain sheet as PDF and name it from a range within the sheet
Data Distribution
Pivot Table from dynamic range
[SOLVED:] Need Help with Userform Progress Bar
Clear Slicers Using VBA
Sleeper: Copy filtered table
Help Needed
Using Index Match in VBA Project
ActiveDocument.Close error
Extracting data from different worksheets in desired format-Part 2 (Editing formula)
Macro copy worksheet to workbook and row offsets
[SLEEPER:] How to generate a dynamic range using VBA code
Populate form ListBox from range
How to recover A corrupted Excel 2003 file
Reading data from Word document; selecting line after table
Assigning variable to table or table name
Need help to convert formula to VBA code
Numbers format preventing calculation to be implemented
Split the Workbook into different files based on SPECIFIC DATA VALUES
Help on macro to fetch data from one sheet and post on the other
Several VBA questions / index match
[SOLVED:] combining several VBA subs
Running macro on another workbook
iserror and lookup not working combined
[SOLVED:] search excel cells for value and input corresponding value in adjecent cell
[SOLVED:] Search string and return file name and Path
if iserror match not functioning
[SOLVED:] Removing middle initials with space in last name
Date Calculation Inside TextBox Vba
Sleeper: Comparing pivot table and adding value to cell
Help with inputting the value in the back sheet using VBA code
Query Access database with parameters on Excel sheet.
How to set focus back into the textbox after an error message?
Using a userform with a for loop
[SOLVED:] Excel to Word Macro Merge File Select Help
[SOLVED:] vlookup array values
[SOLVED:] Sheet Buttons Flashing When Mouse Over Userform
Update cell value on sheet change
Geometric Brownian Motion simulation?
Update cell on sheet change - w/correct file
Logging into a website
Find and add missing value
[SOLVED:] Label in Frame, catch caption with click error!
Repeating a string using VBA button
Calculating differences in exchange rates - FIFO method VBA
Msgbox when textbox not filled but on choice (yes/no)
[SOLVED:] Help with authoirisation list please
Macro to find numbers in a single column
Macro to find numbers in a single column
Overflow error on VBA Module
Simple VBA query
Excel File Recovery
Copy range into a image in Outlook
Macro Automatically SUM upper data when entering new data
Get TIME format to match?
[SOLVED:] error in VBA lookup code
power function in VBA
Applying Border to symbols in Excel VBA
formula to check different between 2 dates within same month in range
Open workbook with one password close with another from a list??
[SOLVED:] Confused between Date and Today
Play embedded wav file when workbook opens
Hide Excel Tabs-Heading-Formula Bar on Opening
Update data from mapping table to another worksheet
[SOLVED:] Align all shapes to the center of their cell
lookup problem
Error Handling for data scraping
Matching data from two different sheets
Add Active X Command Button to sheet and keep Userform Open
Help with Sub
[SOLVED:] Something missing from code
Flip an image in a userform?
Download images from the excel and save to a Folder
[SOLVED:] VBA Syntax to run sql statement with where and order by
Copy data in disperce cells from multiple excel workbooks..?
Copy Pivot Table From One Workbook To Another
[SOLVED:] Listing unique vales in a range with blank cells
Listing values assosciated with headings on a worksheet
Macro to enter filepath on click browse button
Extract specific columns from DBF to Excel
Copy Data From One Sheet to Another with Input Box
[SOLVED:] Group shapes in a single cell without select
1004 Error Copying and Pasting Range
[SOLVED:] Issue with Mass-Email Excel macro
Copy to multiple sheet based on cell value criteria
ActiveCell.Value=replace........not putting range in new column.
Non Looping For Next Loop
VBA Fill arrays from sheet | SUMIFS | create & fill table based on multiple criteria
How to increment Alpha numeric Value
Populate (string) array from sheet
Help with code to export excel to text file with number format
VBA export filename and path
How to leave just the text I want in a cell.
Consolidating Order Sheet
VBA CODE HELP ...if you have time!!!
[SOLVED:] How to get the absolute column number of given cell value from the range C2:K2
Custom Menu/Macro Library
[SOLVED:] VBA find the FIRST real row
[SOLVED:] Run-Time Error "1004" LOOPS!
Match index with closest previous date
Trendline for y-values
[SOLVED:] Excel 2013 ActiveX Combo Boxes Macro Glitch
How to make a solver VBA code in a dynamic range
[SOLVED:] Compiling a List to a Seperate Sheet
VBA code to remove text from a column
vba code for getting the filename for another worksheet on a newfile worksheet
Match 1st ?? in column vertically, if Yes, then see if 2nd ?? matches horizontally?
Macro to loop through Web Queries and enact a second macro once each page loads
How to find and use the maximum value in VBA
read Tag property without opening file
Strings and Variables
[SOLVED:] Test Pivot Table
VBA Pivot Table creation looks different than manual creation
[SOLVED:] Function working within Sub but not in spreadsheet
[SOLVED:] List box looses Blue 'highlight' when changing forecolor