Excel [Archive] - Page 72 - Xtreme Visual Basic Talk

Internet automation (Part 1)!
run macro every night by itself
Generation of XY scatter plots on excel using Visual Basic
Custom date sort macro
For "first" sh in workbook.worksheets
Countif across multiple sheets
Check & replace value
How to Drag and Drop picture in userform VB
Macro to loop through a folder using multiple variables
VBA Do loop within a select case statement
2 column combo box - use 2nd column as variable
Macro for change -1 to "YES"
Why can I no longer set a reference to my Code Library Workbook?
Excel VBA - sum by category
#REF after ODBC query - cannot solve with paste Sub
Rearange data from one workbook to another
disappearing form in VBA
Disable commandbar only for a specific worksheet
Hide Selected Shape Highlighting
Excel Project - Extracting Data
Looping through a list of files
wait for user response
Simon Says I Hate VBA
Running Macro opens editor and must hit run again
Run-time error '13': type mismatch
Please dbug this code
Another autofilter form issue
Sort Ascending with Expanded Selection
Method Range of Object _Global Failed
delete row below cell by criteria?
match a line and return the 4th line from it
Cell colored
Sending an email via Outlook from a non-default address
Help Button Link to html file
Translation from c to vba
Geting specific value from TAG in Web browser using VBA 6
Using Dictionary VB Excel
Embedding Customer Userform on excel
Getting the numeric value in a string
Find occurrences and delete rows
change the header based on the company name
Calculate Dates
can some one point me in the right direction?
Workbook opened by user during code execution
Trouble with ActiveControl
[vb6] Excel Filter Criteria
Pointing a part of a webpage to a cell with a WebQuery
Searching one page for something found on another
Populate a userform combobox with filtered range
FormulaR1C1 problems with offset
Loop through cells and delete matching - complicated
Basic vba, in need of urgent help
Get selected option tag from a select form of HTML page
2 Date time difference
Excel 2007 Ribbon button call VBA UserForm
Opening Excel Files: File Source Name is located in a cell
Load userform with information from a worksheet
Having difficulties with sorting in excel
Moving and Renaming Files
Textbox Value Updating a Specific Cell
sort 2 dimensions array
Multiple search parameter boxes, User form?
Accessing Data
AutoComplete based on value in either of 3 cells
Custom add-in function prompt problem
Select from Drop down list in Internet Page
Update
Showing the 'Print' window
Download excel report from a website
Cant get a value from a text box
Create Table and Be Able to Add to It
Paint
Combining cells if adjacent cells empty until non-empty cell reached
Using VBA Loops to AutoFilter Table
Filter numbers from words macro
Loops, Arrays and Autofilter!!
Copy From Textboxes To Empty Cell
dinammicaly pick a name range without using VBA
Deactivate excel ribbon button if no workbook open
Macro to open all files in a folder
Excel Import Data
advanced filter criteria
countif column from other worksheet equals certain value, dynamic rows macro
Create bar chart, dynamic cells, VBA macro
Add header image from within workbook?
Excel Add-In/Plugin to monitor time taken on each file
hide rows
Data Validation: Combine Two Cells In Drop Down Only
Copying a picture from a web page and pasting into Excel
Excel Autofilter and then fill rows with formula/data...
How to select a autofilter range in Excel VB Macro that could change?
AutoComplete Words in TextBox While Typing
Copy filtered Data from one workbook & paste to other Workbook
Add/Delete task in calendars created in Excel
Benefits of static functions
Activate sheets and cells in separate workbook
Date Txt file last modified and not last accessed
MS Chart - Multiple Series from one data source?
Update ActiveX Button Caption
Highlight row if cell <>"" - on 3 different columns
Select Every other Column for Hiding
VBA to create pivot table - type mismatch error
Stop at first Empty Row - Fill Blanks in another Column
Half Maximum UDF Error
Advanced Filter Command Buttons
Click Event For Shape or TextBox??
problem-solver: 2 subroutines work alone but not together!
loop with if condition ???
Adding text and combining cells
Error checking macro for excel
DialogSheets
Button Click in Internet - Button without 'Name'!!
colour id
VBA custom date picker format
Excel VBA & Internet Explorer 8
Excel 2010 vba and IE9 file download dialog automation
Can't select Sheet then select Cell
Dynamic Cell Summation
scale webbrowser
remove seconds from date/time
VBA - Multiline Textbox translation
Sheets of a closed workbook
Finding the second largest number
Alternative to Vlookup?
populate headings and values from lookup table
Check if an object property exist
Creating Borders Loop
Checking to see if a cell value is in a range
run time error '1004': method 'range' of object '_global' failed
VBA excel auto generate unique identifer on userform
Name multiple dynamic ranges in one column
Issue with Macro in VBA
Multiple form - problem
Organizing Text in Excel by length
Trapping Windows Lock event
Run a macro from a batch-file
pivot table in vba - grouping problem
Usage of Inet under MsOffice2010
Project is unviewable - locked
Type Mismatch Error
Login Script
Excel VBA-sums
Excel code needed
Dynamic graph that shows the last x months of data
How to use Windows("").Activate ?
clear cell contents based on a particular cell value
Returning column number when searched for a string
VBA Excel : Chart.export creates corrupt files randomly
Excel VBA to login to a secured website
Deleting a row based on a cell reference input
unwanted quotation marks
Dynamic pivot table based on date range
Copy Dynamic Range from Workbook2 to Workbook1
Automatically copy data to different sheet with variable range
Dynamically update caption in user form
Userform ComboBox
error while running following VBA codes
Combine Values that have match criteria
adding numbers - separated by the + sign
If two geographical data match in two sheets, copy unique id/code found in one sheet
Problem with changing active cell
VBA to move activeX control lable to a specific cell
range.find runs slowly
VB Loop
Entering variables in place of the address
Delete rows based on some criteria
Need 2 Parse while Automating IE
How to lock the system clock
Graph keeps giving Run-time error 1004: Application-defined or object-defined error
delete (almost) similar rows on different worksheets in one workbook
Colour Palette - Picker
DAO to retrieve Access records does not work
Add nonstandard userform controls at runtime
Edit Cell details using a VLOOKUP
SpellNumber Function
commandbutton hyperlink to variable link
Way to track previous untracked changes
Excel VBA controlling ie to click
80k x 80k line cross-reference
Matching data from multipal workbooks to one Spread Sheet
How to identify open .xlam workbooks?
Can one switch tab menus in Excel 2010?
Structuring a program
Problems making VBA code to create start, pause & resume command
VB.net/Ecel pivot table question
Delete Part of value in Cell
Vb6 and OpenOffice - StarDesktop
Unable to get "Locked" property
Userform with variable comparison operator
Trapping contents of non-contiguous cells
Page setup not working on opened document
Variable Not Dedfined Error
Rename Sheet Error Capture
ADO Recordsets with Excel and mixed case
Get excel tab name
Excel vba ADO to retrieve any record from database using a variable
LastRow,Autofilter and CopySheet
Find & Replace Formatting
Use the Current IE to open the page
Copying Data From One Sheet To Another Sheet Of An Excel File
no blinking when running and progress bar
Compile Error with the Right() command
Excel VBA open folder in Explorer
Set values in a column to be the same as another column
IE Automation using VBA
Auto upload Excel 2007 sheet to Access 2007
Option Base 1 Function MatrixMult()
Error Retriving Data from Excel Sheet
Setting field with calculation
Function Argument -> #Value
Compile Error: End if without block if
Change value of graph vertical axis
Trouble with SpecialCells
Match # in two worksheets and cut and paste to sheet 2
Userform TextBox Decimal Points in the Wrong Place?
VBA finding known values
Speed up loop
PP (Print Problem)
VB Code that will allow certain tabs to be saved as PDF's
How do I load an Outlook Form (.fdm) from Excel
Delete rows based on a column of criteria in another tab
Excel Workbook Session Time Out
Break link with VB code
Replace Dynamic Values in Column
Create PPT from data range specified in Excel
When do class properties & functions get calculated?
Using a Named Range in VBA to change a pivot table filter
Sorting data - lump together certain rows
Delete multiple UNIQUE phone numbers, NOT duplicates
Advanced Filter(Unique) not fully unique
Drawing binomial Tree
cant open shapefile (MapWinGIS object)
Is this an issue regarding 'converting string to integer' or else?
UserForm created by code is losing ListBox data
Runaway routine
vba match returning wrong value
why the "type mismatch" error
Word automation terminates Excel without runtime exception
Searching for a value and copying the cell next to it
Job coding, comparing strings, creating codes
Edit External Link Address to Access
formula.Array issue with = signs in array
Vlookup and last column
String parsing
Outlook address book in Excel
Remove Duplicates
Custom Userform for printting
Checking for the number of Rows in Dynamic Range
Delete empty rows for searched column
Vlookup and Two Workbooks