Excel Help [Archive] - Page 161

Search multiple keywords to filter column
[SOLVED] In merged file, re-name sheets to include part of workbook name that they came from?
[SOLVED] if find specify word copy all the row to anther sheet
Trying to replicate MAX function in SAS
Speed up the loop process (Copy paste Value)
Split text in different cells after each Dash
Sorting table with Duplicates
Slicer changing chart styles
vba excel dir loosing file name in looping
Excel Userform with Checkbox value, How to return to Checkbox value in Winword
[SOLVED] How to use an Array instead of a Loop to clear contents of blank cells? - Speed Issue
[SOLVED] Excel macro, combine cells based on same merged row i different column
[SOLVED] Run-Time error '91' Object variable or With variable not set
Charts and forms freeze after VBA macro execution
[SOLVED] Macro For Re-Coding Variables after a Specified Cut-off
[SOLVED] i want VBA to display values greater than or equal to the given number
[SOLVED] Improving Cell Change Macro
Delete columns in spreadsheet based on list of column names specified in listed range
Create table array for Vlookup with match and count to next blank row
Need Help to modify this Macro
Can anyone help me with this code ?
Combining three different tables in a chart
[SOLVED] Calling a function
vba import data from another workbook with auto filtered of specified name
Move to right column after return when I press enter
List (Sort by) Birthday Anniversaries in .txt file
Filter and sum the column values
[SOLVED] RUNTIME 13: TYPE MISMATCH ERROR
Based on Cell value, from next cell has to move to 2nd row
[SOLVED] TABLE OF CONTENTS NOT USING TABS
[SOLVED] URGENT! GETTING DATA FROM ONE WORKBOOK TO ANOTHER USING VARIANT
run time error '9' subscript out of range
Map cells based on text
VB Code Help " Error Variable not Defined " and Run time Error "438""
Extract data from string to new sheet
How do I check values on 4 columns simultaneously on two different workbook?
[SOLVED] Match code is not returning the desired field
[SOLVED] automating calculations and adding to existing table
Find specific cell and insert page break - repeat till end of sheet
[SOLVED] DATE VALIDATION IN TEXTBOX
[SOLVED] Extract Matching Cell Values in Two Columns and Paste in New Columns
insert sum formulas based on worksheet data
[SOLVED] VBA to provide search data from text box value
Listbox.Column
[SOLVED] loop thru every sheet and filter out a specific name and create a new sheet
insert sum or =+ formula based on value in another column for variable rows
Heading Row Returns NULL
Need to delete a workbook
MULTIPLE FIND AND REPLACE FROM USERFORM INPUT
[SOLVED] Log to generate tracking numbers
Need help writng macro to insert Spanish accented characters into a line of text
[SOLVED] Event Handler for external DLL events not triggering
Macros to highlight three or more consecutive numbers entered in a set row
match cells based on a string provided
[SOLVED] Source and target cells specification in a macro
Search for Numbers
[SOLVED] Find string in multiple rows
VBA to copy paste data in Master File........and adjust row as per data size..
Excel VBA UserForm not working. Need help pls!
[SOLVED] HELP GETTING DIMENSIONS OF A VARIANT ARRAY
[SOLVED] ADDING A SHEET USING VBA BUT GETTING ERROR
Hide / Unhide Rows and Columns based on selected cell value (drop-down)
Number of days inventory held
[SOLVED] RUN TIME ERROR FOR A VARIANT! DONT KNOW MY MISTAKE HELP
Restructuring of data without a standardized format
Converting countif to frequency
Help Creating Macro for Selection, copying ranges
Listing Conditional Formatting on Separate Sheet or Workbook
[SOLVED] Saving Current Worksheet as Text in Current Directory
Excel Macro Copying Information From Many Folders
Force Excel Macro With Some Sheets Remain Hidden
XLSX to XML Macro
Show Sheets which have links to other sheets
Add rows to existing table
XLSX-XML Conversion through Macro
VBA from access to excel
[SOLVED] Sending Email Drafts from secondary outlook email account
Copying an active range
[SOLVED] Protected cells - want to enable comments
VBA - Merging and Bordering of cells if condition met....
Transferring Data from Multipage Userform to Separate, Subsequent Rows in Excel
VBA - Unhiding a Worksheet and setting Sheet1 as current view
Modifying COMport Code
Run-Time Error 13
Pull data from overall sheet to new sheet based on criteria
Replace multiple repeated texts in multiple word documents from excel with excel vba
[SOLVED] FINDING LAST ROW IN COLUMN NOT WORKING
Insert Two Blank Row if Condition Met
VBA - Seperating Column data based on Criteria.....
Select case using a collection of values
[SOLVED] Using an array to transfer file names into workbook with multiple sheets
VBA Help - Run-time error '-2147417848 (80010108)': Method 'Value' of object 'Range'
How to Merge Two Worksheet_Change Codes
Copying spreadsheet into 120 sub-folders
[SOLVED] Copy/Paste Loop is only transferring rows 1,2, and 4, but not row 3?
Ranking with conditions
VLookup VBA Code & Elseif troubles
VBA loop copy & paste range to same worksheet name of another workbook
[SOLVED] HARD:MADE A FUNCTION - HOW DO I LOOP THAT FUNCTION IN MY SUBROUTINE????
Inset formula into last cell of table column
RUNTIME 13: TYPE MISMATCH ERROR
[SOLVED] HELP!! GETTING MULTIPLE VARIANTS INTO ONE RANGE!!!!
[SOLVED] Pass the range from userform to sub of module
[SOLVED] HOW TO ADD 2D NAMED RANGES WITH SAME DIMENSIONS?
Can't start edit or remove macros
VBA code (macros) understanding
[SOLVED] Help With VBA Document Counter
[SOLVED] Automated Login Results in URL Change After More Than One Use
trying to count total rows based on group of values in another column
Object required on .Find
[SOLVED] Event Before refresh pivot cache
Multi Find and Replace VBA Script Macro Not Working
VBA - Select Case Error
VBA - loop help in Seperating the data......
[SOLVED] need help with filtered table
Get COM Addin list of functions
[SOLVED] conditional month()
Pass variable from module to the userform.
VBA sorting error
Bug? with activeX combobox
[SOLVED] Trying to code this VBA macro but it's beyond my knowledge
[SOLVED] Adding links of files, seperating filenames with Split() - Error: Object variable or
[SOLVED] Merge specific word files from excel VBA
VBA - Textfile Skip line Help in Looping
'1004': Application-defined or object defined error (VBA)
VBA Help: Email attachment via folder or direct-link
Dynamically adding and positioning check boxes to wrap inside frame
RUNTIME 438 ERROR WHEN CLICKING IMAGE
How to hide textbox in userform by option button?
INSERTING MULTIPLE PICTURES THAT MEET CRITERIA
[SOLVED] Copy value of active cell to another worksheet
Searchable dropdown list (data from two columns)
VBA Code Required to autosize image - I can pay via. Paypal or other method...
[SOLVED] Cross Referencing Filenames Using an ID and "Charting" Results Across Columns
Search, find, hide columns - VBA
Need to select a workbook which changes names everyday
Excel Data Files
Arrange Data Properly
VBA to copy specific columns from word table to Excel
VBA vlookup in file a with data from file b
[SOLVED] Trying to set color to a range
Transfer of data between two workbooks using name of worksheet?
[SOLVED] Comparison isn't finding as true; but values sent to MsgBox show it should be....
Cant count integer partitions by recursive function.
[SOLVED] Working with Dates in VBA
[SOLVED] Attach event to multiple ComboBoxes
[SOLVED] Filter and Sort with Multiple Headers
Run-time error code "438"
[SOLVED] Suggestions regarding speed and efficiency
Lock Cell/Cell Range based on Cell value
[SOLVED] Progress bar...%
Send reminder emails based on date in column, after finding last email correspondance
Is there code similar to "If Not Application.Intersect" & "If Not Intersect(Target..
How to create a public array in class module?
Copy and paste if cell contains specific text
[SOLVED] Perform calculations on a field that has already been added to pivot table
Select and Edit certain type of ChartObject in VBA
[SOLVED] Need advice on VBA Conditional formatting Formula : Run-time error '5'
Copy paste the data by vba
extract data from a row with a lot of data
[SOLVED] “Application.Speech.Speak”, to announce the greetings.
Add current selection to filter in VBA
[SOLVED] Turning 100 Data points into 6000 using VBA HELP!
[SOLVED] Multiple drop down selections in the same cell
Run time 424 object required
Possible to clean up my formula
Double data and runtime error when running macro
[SOLVED] Excel Freezing Up When I Run Sub
How to get msgbox output with spaces between every three numbers?
Extra Screen for Laptop usinig Android Phone
[SOLVED] Loop sheets that begin with given chars
[SOLVED] Vba to calculate the number of days from today to the 1st of the month.
VBA: Copy and Paste if criteria met
I am having an issue with macro assigned shapes
Employee number according to timetable sequence
Several questions about the collection.
[SOLVED] Edit Excel Links in PPT Using VBA and Early Binding
Summarized data based on timetable sequence
VBA Merging duplicate -cells issue
Conditionally put - sign
Data Comparison
[SOLVED] Using a string in names of dublicates
extract data from Excel Columns to an Output sheet
Scanning Input not considered a Change
[SOLVED] Modify a macro to remove blanks from a worksheet
[SOLVED] Userform TextBox Loop Syntax
[SOLVED] Dynamically passing value to Sub using buttons
Bold and color numbers in specific format with special character
Is there a way to write this "for" loop?
[SOLVED] Overflow Error when using Format()
[SOLVED] All VBA Worksheet_Change Events Not Working
VBA to check for PR SAP attachment
Can't calculate long recursion
VBA help in creating a dependent and source views
[SOLVED] HELP NEED TO MAKE CODE GENERIC LOOPING THROUGH CELLS TO IMPORT DATA
[SOLVED] Formula to return two multiple lookups in one cell ?
[SOLVED] If/Then/Else, Search & Set Active Cell VBA Help
Excel Hyperlink when click ,automatically compose a message in outlook
[SOLVED] Loop through all open Workbooks in all Instances
[SOLVED] HELP GETTING SUM OF COLUMNS IN A RANGE
check macro execution / speen
User form in PowerPoint to feed Excel database
[SOLVED] Increment number based on two criteria
[SOLVED] Help speeding up macro
[SOLVED] Find word and delete else exit Sub
Removing Rows Based On One or More Cell Values
[SOLVED] Extract amounts from text strings using VBA
[SOLVED] Compare and copy
Pivot Table Creation Error
IF LOOP FOR LOOP AND IMPORTING FROM ANOTHER WORKBOOK
Coding Excel User Form
Search whole row for
Copy and Paste loop
Suggestion for Best Practice
VBA - Copy Multiple Columns as per mapping sheet union help
How to put a named range in one workbook to another and call a button VBA
[SOLVED] Deleting Queries and Connections not working in O365 version
VBA script/code to email range of data from an excel spreadsheet
Get Unique list of cells in a Column for loading a Combobox
Trouble Changing Active Cell After Pasting To 2nd Workbook
Can I use vba to add hyperlink shortcuts to folders
[SOLVED] Extracting 8 digit PO from Field
Excel file needs help
[SOLVED] Find Function
[SOLVED] how to make filter from data base and show count in VBA tool
[SOLVED] how to marge multiple sheet into one sheet
[SOLVED] how to use both userform and other excel
How to pull data from a Sheet to create a Context Menu? How to combine two VBA codes?
problems with printing
[SOLVED] vba tool for admin database maintain & analysis
Filter Data Based on Dates + other criteria & copy to another sheet
Defining range from First Cell to Last Used Cell
[SOLVED] i need Vba code that creates an input mask for a password ***** in an input box
Retrieving all files in folder or subfolder containing specific text
[SOLVED] Trouble Assigning Error Bars with Array
How to adjust the size of the `Note` after opening it?
[SOLVED] Find All, Copy & Paste to Next Blank in Sheet
How to backup settings of Microsoft Office which are in registry branches?
VBA - Open each file from directory in ascending Order
Copy last 20 rows (or all if less than 20)
Checking the values in Sheet1 with multiple entries in Sheet2, Write the output
Using an addin to package all my source code
[SOLVED] VBA To Re-lock a specific cell after 30 seconds
Find currency and add/debit according to amount
Undo/Redo or CTRL+Z – CTRL+Y »» does not work for my own macros
[SOLVED] how to use userform to operate pivot table
[SOLVED] Countif and Count on visible rows
[SOLVED] Edit textfile vba
HELP! VBA Problems
[SOLVED] .TextToColumns doesn't seem to work reliably.