Excel Help [Archive] - Page 109

VBA – Array Filter
Computing average over columns with VBA
Solved: Inconsistent updating of spreadsheet formula when changing file name
Solved: VBA -- IF Statement
Solved: Detecting when a different sheet is made active without using Worksheet_Activate
VBA Vlookup
Empty vs Zero
Solved: VBA function procedure homework help
Solved: VBA average and standard deviation homework help
Populate a useform textbox with text from Control Box form
Data editing/moving/arrange.
Number Format Short_Cut
Extract Text from Word Document and Put in TextBox
Solved: Combobox: Enter, Tab and Backspace Keys Not Triggering Keypress Events
VBA to Concatenate Variable Range
Solved: copij formula in protected sheet
Specify paper tray
Excel VBA Get Internet Explorer Data
Solved: Cancel a Loop if .Find Parameters Do Not Exist
Solved: Workbook_SheetChange and If Not Intersect error
Buggy Pivot Tables?
Tooltip on Labels
Help Referencing Other Spreadsheets
Solved: Using a loop with Select Case
Solved: (How to) Transpose one long list of numbers in CSV file to a number of rows
Solved: Strange behaviour of =cell("filename",A1) formula
PDFCreator automation in VBA Excel
Two Quick Questions: Using Count Method + Using Offset Property
Solved: Macro to change text to date in a set range of cells.
Solved: Clear Specific InteriorColor Index
How to pass combobox/textbox selected member into sql string in main module
Fastest Way to Build a List
Solved: Save File routine
[SOLVED:] Help with additem from textfile
Simple Copy/Paste code
Create new line for each slash in field
Solved: Counting with SumProduct
UDF and Select Case
[Help] Exporting data and filling columns
Highlighting Min Median Max and Percentile90
get value from local html file
[SOLVED:] Cell Value vs Text
connected combobox
Solved: Excel file that lists the file names in the folder
Attach Hyperlinked Documents to email
Market Survey Monte Carlo
Using VLookup in Excel
Using excel to get email dates from Lotus Notes
Sum particular cells
Solved: Counting Models
[SOLVED:] Disable Double Click
VBA to format windows directory listing?
Solved: clean lines if more than 10 lines in column
Userform code module too big, how to reduce size
Find and replace within VBA modules
VBA Search Multiple Sheets help
Solved: Help to shortened code as its too complex for maintenance.
Lookup code in Userform errors out
VBA Save As Prompt Help
Controlling MS Word from Excel VBA
Solved: Array Countif that will ignore Formula Blanks
[SOLVED:] Another Option Instead of Using Multiple SumIfs?
Solved: TextToColumns question
Different footer for each page of a sheet
[SOLVED:] Get PDF page size
VBA File Sucurity Code
Solved: Sort all files in a folder and open the latest one
VBA: Enable Editing
Example Excel Database?
TextBox Challenge
Solved: moving texts separated by a dash (-) for the bottom row
Trawl directory, format that data into a new list
Add Loop and timer
Solved: VBA What If Analysis (Data Tables)
Difficulties with a userform
Error 1004 copy of object failed
Find string within a string and highlight
Solved: automatic change of tab names
excel vba
VBA code for inserting blank row in between the data points
Runtime error 5 - manipulating strings & Ascii
Solved: Error 1004 when trying to sort data
Solved: Excel Database Search Engine
Dots to comma in userform
gmail send mail with noreply
Help - Custom right-click menu in Excel 2013 64 bit
Grouping data
Solved: file list with last accessed date ....
Tidying up - loop from excel to word
[SOLVED:] Adding the exact IDs
Dynamic chart ??? VBA
Linking cells, sorting by values in column
Automatically combine multiple sheets
Solved: show, either conditional formatting, icon sets, or change font colour of userform Lbl
Autofill or something else to multiply a formula
€50 REWARD for urgent help
Solved: Change word file generation depending on a selection
macro to filter on each unique record and print range
VBA SUM OF COLORED CELLS?? PLEASE HELP
search for date in column
VBA copy cells from one book to another
Odd error -
Network days in a calculator
Solved: User defined function not appearing
Datedif (FULL MONTH)
How can we find to what correspond some values in a function?
keystroke event
Concatenate Excel Files
Solved: Userform entry
Solved: Prevent useform from pulling data from other open workbooks.
Solved: Inserting rows after highlighting a cell
Solved: Error Handling strange behaviour, it only works the first time
Solved: auto quick info feature is not working
Find text string in multiple workbooks
Protecting excell file...
Textbox Validation
Solved: Run-time error '13' on an If stmt
Finding a string within a string multiple times
Userform Repaint
Solved: Calculating Future Costs
Trying to determine if certain fields are unhidden.
Content in Outlook email from range
Networkdays macro automization help
Consolidating Multiple Protected files into one
Use a spinbutton to change items in listbox and update sheet that populates listbox
Solved: Exporting VBA array to existing Access DB
I can't get the correct Rows to delete
Solved: Combine Multiple Workbooks Into A Summary Sheet
Solved: Userform to start with another worksheet
Addition to code
how to create word document based on data in excel
two-variable data tables
Solved: Help Running SQL USP in Excel
The online database؟؟؟
[SOLVED:] Sort specific columns
Data from one wks to others
ClearContents (Differnt columns)
Reading from a Website
Solved: UserForm For Item Additions
KeyCode = 9 Combobox Disappears
Peekmessage and Excel 2010?
VBA Q
[SOLVED:] Post to view attachments?
Find and Findnext Problems
Userform - picking name from sheet
Display value in a cell if between 2 other values
Passing array from one function into another function
Solved: VBA Offset help
Solved: Sum particular cells
Solved: How to get data from UserForm2 into UserForm1?
Solved: Trying to add two numbers together, but instead they are stuck next to each other??
Copy & paste in next available cell
"Subscript out of range" failure. Working with two workbooks. ShellExecute
Data Validation - How to update cells when a name is selected from a Data Validation
mvlookup unique values
Solved: onchange event fired by deletion of row or adding row
Solved: Sum a column based on multiple criteria in different columns
Solved: Access Combobox Entries found in a Userform from Another Userform
strange with excel 2010
Error Messages
taylor/maclaurin series
Cells.find in loop error -> return to the beginning of loop
macro not working for if function
Solved: Track Changes On Row Delete
Solved: show pdf from userform pdf reader based on "file.pdf" from cell reference
Copy Columns Based off VLookUp Result
VBA assistance to separate out strings btw semi colons in cells and copy each indi
change in VBA
Solved: Print page by user input
Solved: If Vlookup, Formula is case sensitive???
Sleeper: Build business days calendar
Combo box display
Solved: Limiting Toolbar Form Controls Checkboxes
Question on Array
Need help to improve code
Run time error 445 "object doesn't support this action"
sound file duration
show/play powerpoint in userform WeBbrowser?
Please help me edit code
Solved: Conditional Format Only On Filtered Records
Download excel from website that uses ASP
Solved: Copy the data
send email notification from excel to multiple recipients
send email notification from excel to multiple recipients
column chart seriescollection transparency
Sort in Excel with Multiple rows and column
Pop Up Message On Conditional Format Criteria
Running Stopwatch Assigned to Buttons
Accessing data in getelementbyid() model
Solved: Help for loop function
Solved: Help Using VBA arrays.
VBA assistance to modify code
Need help for edit code
Run code under specific criteria
Problem with trying to create a data entry screen template
Need to pick up the row and column of a cell?
Solved: Please assist in copying row found during Do Loop to new sheet.
Solved: Compare and delete duplicated data
Events to go to certain parts of code after a value is entered
Dim "refrenance to cell text" as integer
Solved: Manipulation on Array elements
Solved: Copy Selected Data to New Worksheet
Solved: Add commas on each line into cells
How do you read all cells in a row?
Solved: find the data on 2 sheet delete the row of second sheet
What reference do I add to access .net objects from Excel VBA
Continuous Looping, help!
Hyperlink - Listview
auto show a window
Solved: Loading a listBox
Solved: Using VBA to Sum changing groups of Rows
Solved: Merge column by select them
I need help edit code auto sort
duplicate records extraction with percentage requirement
VBA Country code from Cell Range
Embedded Chart Events - Selection Object Erratic
[SOLVED:] Only show maximum value of repeated data
Predefined "Save as"
Solved: Progress bar almost working
Thematic Map India
Count number of cells in worksheet_change
How to assign values to the strings came from combo boxes on the basis of text..?
hide #value!
Rolling calculation
Advanced Filter From Varying Criteria Range
India Map
Separate rows depending on specific criteria
Solved: Getting the path to a folder from just the folder name
Solved: Percent of Row Group in Pivot Table?
[SOLVED:] Conditional IF Based on Cell Value
Automatic consolidate report from selected excel files
run macro from closed workbook automatically for every 24 hours
Solved: Passing data from userform to sheet/cell
Solved: Pop Up Message On Cell Value
I Need help edit code copy and past
[SLEEPER:] How to add fancy controls to userform
Solved: Formula to Add to date Change
Userform_Activate
Run VB application via VBA
Solved: SUMPRODUCT - Multiple Cells (Looking for VBA Method)
Question about drawing table list box
Adding a new row will break my little VBA script
Need some help with date
Conundrum
Solved: UF countif in range
Dynamic selection of columns in Excel
Solved: Please assist in finding a numerical value in the table.
[SOLVED:] optimize macro
Multiple selection in list in excel 2007
VBA to generate Request Response XML from WSDL (Webservice)