Excel Help [Archive] - Page 155

Else without IF error !!!
Data lookup formulas
Moving data between sheets based on headers
Numbers update as per Pivot table
Show column headings and corresponding values/text based on dropdown selection
Barcode Asterisks Around Date Formula
vba - vlookup on data stored in array
[SOLVED:] Run time error -2147417848 (80010108) Method "_range" of object "_worksheet" failed.
Export specific sheet from a file to a specific sheet in many closed files
Code for Slicer
How to change code for sheet to work whole book
VBA - Outlook to Excel
Need help : fill listbox with search result
VBA variable url webquery
Force User to Enter Date but in UK format
Excel VBA game help
excel help
Copy Data from one sheet to another IF cells are specific text colour
VBA msgbox help
Eliminating Pop-up when using RemoveDuplicates
Turning Multiple Optionbuttons subs into one sub
Aligning Columns and rows
data transfer through loop
Copying charts from all Excel worksheets onto Powerpoint slides
Different Phone Number Formats from list of numbers
Change Check Box character to text
[SOLVED:] Search using two ranges
Help with time diffrences
Search for Specific Text within a Cell
[SOLVED:] YTD SUM
[SOLVED:] VBA to Copy / Paste into New Workbook With Different Layout by Column & Row Headings
[SOLVED:] Filter between two dates on multiple ranges
Auto update Form Text box with form editor name
[SOLVED:] Changing code from copy entire row to copy specific cells
Checking for MULTIPLE duplicates on save_click
Run-time error "438"
[SOLVED:] Switching worksheets unexpectedly after exiting UserForm
Make Cell Blink 3 times
[SOLVED:] Extracting intersecting values from two or more ranges
[SOLVED:] Need help parsing subtext in cell
[SOLVED:] Find zero
[SOLVED:] Find specific words in a worksheet and change the font color of those words
Distance between 2 locations 2D array
[SOLVED:] How to fix Compile error: Else without if
[SOLVED:] Help with renaming files (Name "xxxxxxx" As "yyyyyyyy" wont work)
Compile error argument not optional
Macro listing files in folder, used to list all now only first
Run-time error; Invalid procedure or arguement
Help Looping through array
VBA Newbie question
Two dropdown lists
Function to list file names in a folder
Help removing encryption from an excel template using VBA
[SOLVED:] Deciphering VBA Code
Extract value from HTM file
[SOLVED:] Hide and Unhide Columns based on Cell Value
Compare list of values to rows in another sheet, copy row on first match
Copy Paste VBA code Required with some additional requirements Button
Sum adjacent columns based on criteria
Salary Structure Calculations
How to run macro only selected rows
VBA to read text file and import specific data from it to excel columns
X-Y Scatter plot using VBA
Yes/No Optionbuttons
Excel VBA: resizing a pasted image in word using excel VBA
VBA format Word
[SOLVED:] Microsoft Object Library Reference Missing - Outlook to Excel
Mirroring of sheets to a single summary sheet
2 selection critria in a WorkSheet form
[SOLVED:] How to keep Inserting Rows Command from moving other cells in a sheet
Select data through 2 slider bars
urldownloadtofile-is-downloading-files-to-inetcache
Senders Email Address: Outlook 2013 to Excel 2013 Not Working
Download and open Excel file
VBA: website scraping in general and specific problem
[SOLVED:] Changing Multiple ranges to Dynamic ones
[SOLVED:] Can you Format as fraction in VBA -- Format(123.456, "# ??/16")
Message when you try to open the file
[SOLVED:] VBA Coding Help
[SOLVED:] Value & Formula - Export Sheet from xlsx to CSV
[SOLVED:] Select range till last empty row
Add double quotes to cells that contain spaces
VBA Table of Contents
[SOLVED:] Select data down to next empty cell in column
[SOLVED:] Need help w/formula to show just some amounts
Copy from RDP (remote desktop) to local desktop
[SOLVED:] VBA- how can i have a userform behaviours just like controltiptext?
VBA help solving assignment
Compare cells
Split to Files - adjustment
Upon exit excel woorkbook save charts as picture
[SOLVED:] Arrays using MMULT Function
Vba view active ie window and mouse over text and pull to text box
VBA for Setting Min and Max Axis for Scatter Plot Graph
[SOLVED:] ForEach Loop Trouble
Import Multiple txt files
[SOLVED:] Dashboard prepration
Slicer vba code
compare dynamic arrays and copy data from another array into a cell in WS
Splitting data into other worksheets based on data in ROW
Macro - Mail every worksheet using A1 as address
[SOLVED:] Limiting Window Size to the used Column range
Excel Macro pulling data from Word 2013 form - formatting question
[SOLVED:] Retain excel cell format when copying to word bookmark
Catching fatal VBA errors
Copy partial rows with criteria to new workbook identified sheet
[SOLVED:] UDF to count colored cell pairs fails with #VALUE!
VBA - inserting picture on from clipboard to userform image
Transferring Excel data into Word
macro save as
VBA Code->copying sheet from mutiple sheets excel into single excel with diff sheets
How can I find next small value(look up value) in a range?
VBA Cells update vica-versa using VBA code - Level 100 Can somebody solve this?
[SOLVED:] VBA - uppercase of the first letter in each word, while the rest remains intact
TextToColumns FieldInfo ignored
[SOLVED:] Adding batches of serial numbers
Ribbon Control not displayed at file open
[SLEEPER:] I like to find next small value..
[SOLVED:] Vba Code for sorting date
Parsen/Scripting web-pages with Excel-VBA - no refresh data
Every possible combination
Print Charts to pdf
[SOLVED:] Ribbon customization issures
Smart View - Connect to a Shared Database
[SOLVED:] Match Overlap Date Range and multiple criterias
[SOLVED:] Take absolute value of all array elements - Please Help!
[SOLVED:] Set value to variable in vba to use different sub
comparing elements of 2 arrays
CommandButton button in Excel 2016 does not work
[SOLVED:] Removing end elements of an array (they are all 0)
[SOLVED:] Find row index where max value is located
Huge working excel document
[SOLVED:] Help with vlookup in VBA
[SOLVED:] Auto copy range data and paste on last empty row
[SOLVED:] Force opening a file as a .XML
Automatic Hyperlink documents in excel workbook using a command button
[SOLVED:] Code that opens a file and uses data from that file to replace data in another
function with paramarray help
Deleting rows which consists cell value PM and CM and remain cell value intact.
Results changing from a drop down selection - understanding VBA code
VBA in Excel to search for PDF's and report if exist yes/No
Hiding Quick Access Toolbar (QAT)
Userform on Mac
[SOLVED:] Setting the width of an inserted word document
[SOLVED:] Excel MACRO that make variable sheets with conditional information
Finding out leaves and exits
I want to make change in data model in manage data model of powerpivot by vba code
Run-time error 438: Object doesn't support this property or method
SSL connection to external source
[SOLVED:] HTML href cutting off URL at first space
How to avoid hardcoding a filepath
Attemping to loop data/extract/compare
[SOLVED:] Array Indexing - Please help, at a loss for words...
[SOLVED:] Generate Text Files
Looping Macro
[SOLVED:] Range(Cells()) and the 1004 Error
Text stretched in inserted word object
Addins and CustomUI, OnAction to only run Subs in book?
Storing Previous Cell Value in Historic List
[SOLVED:] Chart Title and Axis Title positioning
[SOLVED:] CDO Email, specific cells in the body
[SOLVED:] Overflow Error in Array Assignment
code for the filerting and copy n pasting in another sheet
Copy paste with VBA
Change Direction
[SOLVED:] Random Select Rows and Copy to Next Sheet based on user input value
Add a row below an activebutton, keeping the format without resizing the button
Merge two pdf files with partly same name in 2 different flders
[SOLVED:] Delete Rows in Table
[SOLVED:] Open Window in 64 Bit Excel VBA 7 using Windows API
[SOLVED:] Code is dropped when sheet is copied and emailed
Code for Vlook up
Sum for a certain criteria
[SOLVED:] Forms, Formulas and Dropdowns. Difficult
cant figure out compile error: do without loop
Connect via ODBC to Access FE on remote server from Excel
Copy from worksheet to worksheet in different workbooks with IF condition
Custome Date Picker! Duplicate value
[SOLVED:] VBA - Moving files
errore
[SOLVED:] Hiding Rows
[SOLVED:] How to disable "traditional" Save and Save As functionality
Save file to folder with variable
[SOLVED:] Error 1004 with method "Columns" - only when opening the file
Ways to optimize VBA loop
DTPicker - select date, then continue automatically
[SOLVED:] Compare and replace- Long Sentences
Import CSV files in a Loop
Run-time Error 438
[SOLVED:] Creating consistent charts and layouts
[SOLVED:] have cell take value of another cell when a thir cell's value is changed
Consolidate datas from workbooks to masterfile
[SOLVED:] VBA Copy Clear Paste
return only values from one column which have different values in another column
[SOLVED:] Set Focus To A Particular Cells with OptionButton
VBA - How to select range of cells based on value of 2 cells in each row
Delete columns based on current month
[SOLVED:] How to turn off "activate when cell changed" while other macros change cells?
Switching from one tab to another VBA
[SOLVED:] Multicolum list box displays incorrect format
[SOLVED:] problems with copying the values of one cell to another
Removing Conditional Formatting When Printing to PDF
Help needed to edit CSV files
[SOLVED:] UDF returning multiple values
Copy range in worksheet into new workbook - input box
[SOLVED:] Transpose multiple rows, varied length, to a single column?
Removing all non-numbers from the last portion of string
"You've entered too many arguments for this function"
VBA Transpose Paste Loop (looping recorded Macro)
Excel Crashes
Struggling wth VBA, trying to specify paste destination
macros to search for string in cell from text files under folder & return no of count
[SOLVED:] Error 438
Sleeper: Macro to stack lists until empty
[SOLVED:] Excel VLOOKUP to Google Sheets
[SOLVED:] Transpose Column - But Exclude Rows - Found in Array List
Adjusting my working Excel -> Outlook Calendar Code to work with an exchange calendar
[SOLVED:] Weird forloop behavior with worksheets
Trying to create an interactive UserForm
[SOLVED:] Trying to Shorten/Simplify some Code to Make it Easier to Apply To Other Workbooks
[SOLVED:] VBA - Help Needed - Macro SpeedUp
VBA to Download documents using URLs, create a folder and save it in
[SOLVED:] Getting The Cells to focus!!! Using FOR LOOP to find and select only the last row)
[SOLVED:] multiple columns in a list box
Month report in excel doc
Code that will compare two files and merge the data
[SOLVED:] RibbonX customization issues (XML)
[SOLVED:] Looping trough varibales names - is that possible
Programmatically Add Procedure to Sheet Module
Index/Match over multiple tabs
Populate and Sort a ComboBox with visible unique values from an Excel table
PowerQuery refresh / Pivot Table refresh
MkDir Runtime Error 76
Control Box Data Validation won't change font size
Control Box Data Validation won't change font size
[SOLVED:] Need help with eisting event code to in regards to recording row of active color cell
Automatic calculation problem
Randomly selecting 50 cells from a range & filling with color
scheduled macros execute a few times VBA?
how to click href using vba
VBA syntax question for Dynamic Web Query
Copying Excel Tracker into Access - Endless Issues with INSERT INTO statement
Merge data from multiple spreadsheets into one master sheet.
Merge data from multiple spreadsheets into one master sheet.
[SOLVED:] Different results when execute code by "F5" or "F8" (step by step).
cannot get Listbox column count property
[SOLVED:] FillDown VBA Excel doesn't work on second Worksheet
Updating AutoCAD Attributes with Excel
Run macro if cell has a specific value
[SOLVED:] Goalseek last cell in column, changing last cell in adjacent column