Excel Help [Archive] - Page 171

Userform error
Variant-type object array element is deallocated by With statement
Show graph in userform but via sharepoint
[SOLVED:] Lookup formula not returning the correct result
[SOLVED:] Userform is not displaying anything when i change a "box" to visible or not visible
[SOLVED:] Worksheet SelectionChange Error - Target.Address - if statement
Script not working after moving data to SharePoint
[SOLVED:] Help: Capture file location on the first opening of a workbook/workbook open event
Column getting truncated
Open and Close Workbooks | best Practices
Excel file always opens in read-only mode when opening from sharepoint
[SOLVED:] How to create a values only copy of WB while keeping formatting and filters in tact?
Excel VBA folder-search-tool
Application Visible with more than 1 workbook
[SOLVED:] mismatch when sum values in multiple textboxes
[SOLVED:] Cumulative based of criteria
Opened Workbooks are still opened after executing Macro (Workbook.Close doesn't work)
HELP!! can't figure out details for a file-combining macro
Not Getting Sum Result From All Sheets
expenses compared to the budget
Market data and charts
copy with loop double variable
[SOLVED:] Date Help
Macro for inserting rows if value
Multi-sheet procedure
[SOLVED:] How to Change the Value of a Cell based on the values of two other cells
[SOLVED:] Zero Out Column if another column has a certain qualifier
[SOLVED:] Create Summary
How to prevent duplicate value
Shell Command results in Runtime Error 5 - but path appears to exist
[SOLVED:] Countif in VBA Module
New to VBA: Compile Error Syntax Error
Add the value taken from the user to my range for ActiveX ComboBox
Loop Through Data Validation List and Copy Values Given By Each Item
[SOLVED:] Re-Arrange Columns after Import
[SOLVED:] Is it possible to store range objects in an variant array?
[SOLVED:] clear dependant drop down boxes
[SOLVED:] VBA code to pull in data from SQL table
copy information with vba
[SOLVED:] Deleting Worksheet Stops Script
Pull SQL Data into Excel by Date Range
Setting tab order, adding ability to stop/start code and refine functionality
Macro Or Command To Change Photo In Excel - Urgent Weekend Help Needed
Data validation and manipulating input
[SOLVED:] Check if within multiple ranges check problem
[SOLVED:] Compile Error Private WithEvents oCbarEvents As CommandBars and Private Sub Worksheet
strAddress = .ActiveCell.Address Run-time error 438 when switching sheets
[SOLVED:] Delete Rows if Cost Code Bucket is Zero
SUMIFS on multiple rows and columns, based on a mapping
File Selection- if user cancels- End Sub Then call macro1
How to split a big text file (with more than 500000 lines) in to smaller files
[SOLVED:] Conditional Format:Need to compare 2 cells with any other 2 cells for the same number
wrap broken lines in one line in a given text or log file
Copy text from text file between keyword in rows.
[SOLVED:] insert auto serial number in user form
[SOLVED:] storing processed data
[SOLVED:] Textbox within a Frame in UDF unable to take focus. Why not?
[SOLVED:] looping through functions
Helper columns to solve problem
search and copy the line
Help to remove duplicate strings from table
VBA script updating values other sheet
[SOLVED:] Formula with OR condition does not return expected result
How to close all the hyperlinked files automatically?
Array loop values
Make a declared variable equal to values from multiple cells
[SOLVED:] HOW TO CONCATENATE: IF(condition;result string;result string) result string?
Sleeper: Find a Partial Match from Location Sheet
[SOLVED:] 3 questions regarding VBA Excel
[SOLVED:] Expanding the range
[SOLVED:] need Code to select value from dropdown list using numeric values
[SOLVED:] MkDir and "Path Not Found" Run-time error 76
Criteria based lookup
Instant change between one textbox to another.
Insert Multiple Image and name image in Userform
Copy and paste styles of diagram
[SOLVED:] VBA Excel - reduction of lines
Copy and paste specific ranges
[SOLVED:] create Summary report from information on the DATA Tab.
Checkboxes and filters
[SOLVED:] Copy Data from one workbook to another - based on tab name
[SOLVED:] VBA Userform macro help for range dates
[SOLVED:] Search for name and letter matches and split equally
Search for a match files using value from selected cell in Folder or Subfolders
Return latest result for work schedule
[SOLVED:] Every time you open the UseForm, it generates a new code
Image embed
[SOLVED:] AutoComplete doesn't recognize Cell A1, it starts getting information from the second
check if serial number is repeated
Can someone recommand an obfuscator for xlsm?
Doppelte Einträge zusammenfassen
[SOLVED:] How to range table "t" from ActiveSheet "Charts"?
How to convert number of color to RGB?
[SOLVED:] how to force users to enable macros
[SOLVED:] IF Countif and Textjoin - Help required
[SOLVED:] Help for viable registration solution and code improvement
[SOLVED:] How to pull information from different columns of data from the same row?
Help needed- Analysis of splitting of orders
Need vba to code to split data depends upon col I:I and col J:J
VBA Help on drop down list
HLEP!! I need help modifying this code.
insert selected row from listbox to excel table
Worksheet Change Referencing Cell in Another Sheet
Automatically delete rows after time period using time stamp (have partial code)
Excel counts a blank as zero. Why not leave it as a blank?
[SOLVED:] Cross section by matching column and row headings
Filter values from a table and display them in different textboxes
Price List Comparator
Filter By Multiple Criteria then match results to different workbook & paste new data
A search code with three possible results
[SOLVED:] How to save multiple selected information from a LISTBOX?
Making code more concise - VBA scrape information
[SOLVED:] Pivot table
VBA Code for pasting today's date into a text box
[SLEEPER:] VBA Email TO Cell that contains IF formula
Vlookup to ListObject "Table copy, paste"
[SOLVED:] Saving is not creating a new record line, but saving over it
VBA Help to change Form of Smart Art Nodes
Finding Shape types WITHOUT selecting the shape ?
How do I get one cell color to change based on another cell color that changes?
Why do macros work once and then stop? Example is included
[SOLVED:] Putting Values with Leading Zeros Into CSV file
Copy data from user selected source file to current open workbook
Using the TEXT function and Concatenate function in one formula
How to Solve using CurrentRegion if cells in Table is Protected
Copying values from one column in a sheet to another column in another sheet once.
VBA - function Vlookup
Can I add cell info into a comment box via a formula?
VBA - Range of object _ Global failed
Help : Error on saving workbook to dektop synced with OneDrive
Lookup to add Products from one table to another VBA
code to setup crop dimension
Does anyone else have this error 1004?
Picture shows in userform with search
[SOLVED:] Fastest way to transform data
[SOLVED:] show multiple separate information
Retrieve formulas and autocomplete
[SLEEPER:] Loop between two tables to sum their matches
VBA - Problem in .range
Log Scale graph in excel
[SOLVED:] Formula to FIND specific TEXT within a worksheet
how to create a portfolio Optimimizer using VBA
[SOLVED:] Move data around in workbook
Item number with current month
Linear interpolation with lookup of two values
Using VBA Set for workbook and worksheet
VBA Code for Highlighting Cells based on If then Rules
Create a Userform with a Textbox and link it to a Cell or Table
VBA Code for PDF of Vibile Sheets in array
Method 'SaveAs' of object'_Workbook failed
[SOLVED:] Keycode 13 only for textbox input on userform
[SOLVED:] Conditional Formatting borders around cells with formulas
[SOLVED:] Making a function based on Find having IF
Simple code that refreshes link to another excel file with Password
[SOLVED:] Sort range from one empty row to the next empty row Custom
[SOLVED:] Repeat Search Function
[SOLVED:] Formula to format the cell? (so text gets enough space)
Reference a cell.
Macro not working for fetching data from Active Directory
After user clicks 'Notify', do this
Unrecognized text on different computer
Compare the selected item of a listbox with a table
errors on Macro code for consolidation
How can we use VBA/Macros Excel for solving this interesting simulation question?
[SOLVED:] Help with simplifying my background substraction (data analysis)
Transferring data workbook to workbook
Sleeper: VBA using Loop
Sorting two way pivot table with VBA?
Sleeper: Linear interpolation in Excel
Sorting and cutting part of the sort into a new tab
[SOLVED:] Msg error: "Exception from HRESULT:0x800401A8" when refreshing reports automatically
Extract a number from text in cell using VBA
[SOLVED:] IF Else statement not executing properly
[SOLVED:] Pin Folder to Windows Explorers Quick Access in VBA
VBA code
[SOLVED:] Code only doing it for cell not entire column
[SOLVED:] Can a Header
Precedents arrows state
Haven't encountered this before, what does it mean?
Dynamic update for each userform textbox through looping
How to make a macro work in selected worksheets and how to fix a macro error from CF
Help duplicating from one cell onto multiple rows
Modeless Form Closing
[SOLVED:] Problem in concatenate
Macro called from Menu no longer responding
Break record row into multiple rows
[SOLVED:] Can't loop a macro
Insert Row & copy and paste formulas in new row
[SOLVED:] Lookup values from a range with partial non-ordered keyword strings
Creating a VBA to find and delete duplicate values within Excel workbook
Reformat found data and count equal 'strings'
Insertion range depends on meeting conditions
[SOLVED:] How to add row in second Sheet using ActiveCell in first sheet?
[SOLVED:] Impossible to insert
Editable listview items
VBA - Prompt To Save Excel File In Variable Location
help with the debug
Help to fine tune the codes | transform data, delete blank rows and then autofill
Removing leading letters in a text using VBA
Add some cell values as notes
[SOLVED:] How to assign a worksheet change codes to a button to refresh the values
Range Address Variables
VBA Macro Sort Range
Fiter, Copy and Paste unique values in the next available row of another workbook
Replacing hyperlinks with find and Replace
Copy the last 3 columns
[SOLVED:] VBA code to search on folder and sub folder for file named in worksheet
How to cycle through control sheet in workbook
[SOLVED:] Combinng Ranges into One
Macro That Inserts a New Row and Defines Formulas to Cells
Move To Top Of The Sheet
Crossposting VBA Question - Overlapping Text Boxes with all Shapes
Adding label for msoDropdown control type
[SOLVED:] Copy the Last Row Within a Range and Paste to Last Row in Another Sheet
Cannot get Application Caller to work
excel help
Function behaving differently
Hide/unhide columns
Noob question about Do-Until Loops
DO NOT Copy Data Under Table/ Copy Data from Table to Table
macro to add or subtract date and time from yyyymmdd_hhmmss format
Need help with sending multiple .bcc from range in excel
[SOLVED:] VBA doesn't compares correctly via greater than string comparison
[SOLVED:] Multiple Individual Exclusive Checkboxes with data validation Macro (code here)
[SOLVED:] autofocus on userform after print out
VBA - Flat Text Import Changes
Filter for suffix [x] when a comparing file has _x suffix
[SOLVED:] Help with Code to splitting values into 2 columns
[SOLVED:] Small VBA Macro: introduce cell text into a CountIF formular and get output
[SOLVED:] Shape Colors Updated per Cell Value (150 cells and shapes)
Using a class module for several userforms, identify which userform is active
[SOLVED:] vba code if lastrow is full, it errors out
vba print 2 ranges in one page
Transfer data from one work to another
[SOLVED:] Scale display vba code
[SOLVED:] Delete rows with previous dates
[SOLVED:] Copy Multiple Range on Multiple Sheets.
[SOLVED:] Code searches entire workbook-Need only specific coulmn + keep formatting after Paste
[SOLVED:] Change active page of Vision object in Excel
VBA Form Source List
How to calculate a route / find waypoints between start and destination
Transfer specific columns from sheet to another
[SOLVED:] Refresh custom formulars that checks background color and output as 1 or 0 (File here
Convert ASCII code back to text with StrConv + vbUnicode (VBA)
Quick VBA Question - Adding Another Condition - Use ElseIf?
Need Help converting columns to YML format
[SOLVED:] Help needed to count duplicates but derived by a column of values
A macro to show and hide specific rows in specific worksheets
Finding duplicates in 6 columns by excel VBA
[SOLVED:] Vlookup in Different Workbook - Sheet Looping