Microsoft Excel Programming

Solver: an unexpected internal error occured, ...
Get Date today from WeekEnding
urgent!
Locking VBA code via Project properties but cannot save the workbook over itself
"Pausing" a macro for recalculation
Change the assigned chart number
rename sheet automatically
if then elseif on text file imported into excel
search or goto command needed.
Change range name
Please help with inserting hyperlink
Help in calling excel files under portal
Sheet Update Help
auto type text onclick in a cell
Capturing an Error
combining cells' data into one cell
templates
option buttons run Click code when value is changed via VBA code
Help with very repetitive task in excel...is there an answer?
save file via Marco
Maths-Integration
Renaming Sheets automatically
Macro to Insert Rows After a given Text in Col A
MultiSelect Listbox (Forms Toolbar)
Is workbook open?
Is workbook open?
Copy the results of an Access query into an Excel spreadsheet
Does file exist?
"LabelColor" an appointment in Outlook with VBA in Excel.
tuning possibilities with checkboxes?
Hiding columns
Help on counting occurences
saving excel 2003 file in excel 97
English and American dates...
VBA for opening file/populating combo box with sheet names
ruuning part of a macro from another macro
on error error
Problem Loading Data from SQL to Excel
How to use digital certificate in xls file
Is there an easier way?
Playing music
macro to run a separate macro dependent on value in cell
Running Powerpoint from Excel
Merging cells must be text format
ADODB Recordset problem
Load and Unload Form commands
inserting a formula with reference to a new sheet in a cell using VBA
New Menu Name
Excel If Statement ??
SQL statement returns zero records
VBA Integrated Development Environment basic question
Pivot Table - Sum up Average's in Pivot Table
Prevent User from saving
macro to create a chart from several worksheets
Help needed...
auto fit-wrap texted merged cells
How to Activate procedure with parameters
error message on combo box
Deleting
Delete a Macro
Offset
WAV Files
Date checking
How to tab to a command button?
parsing complex numbers
Movement
Keybindings Collection in Excel
select a range base on Column A
Excel 4.0 Macro to VBA
NEED HELP ON FORMULA!
Functions returning multiple answers
Calendar Control issues
"Last Saved" information
Getting Grades
Re: Hi Guys...
please help...
Email using CDONTS
Splash
Inserting Blank Lines in Selection
userforms
VB.Net: Create Excel File/App?
Visual Basic code help needed
If Then
Up Capture
VLOOKUP for spreadsheet compare
Dumb Question
help: extracting Execel tables with ADO without reordering them
Spin button questions
Setting variable = to sheet name
macro prompt to show/hide rows
Splash Screen
Referencing Listbox on Worksheet
TextBox from Drawing toolbar - 2 questions
Mapland Excel Addin - Programatically Create 1000 distinct maps
Macro again...
Labels in User-Defined Function Not Working Right (First Problem)
Precisely reposition a graphic
help with hide or delete
right-click shortcut menu
Is it memory problem?
Open Macro Dialog Box
Customizing commandbar problems
Define a Dynamic Range Based on an Index
Macro syntax error when running query
Excel and Outlook Email
userform & textboxes
Combining Macros to make one Macro.
Assign named ranges
xlDialogsSendMail
Excel trouble
Find column name/number of a value in a row
Excel Pivot update from Access
Mail
Excel VBA : Coding Problem
DisplayAlerts Error
MACRO for copying active sheet without using a certain name
passing variables
One on One Training needed in Houston
How to get the macro record button back
GetOpenFilename changes dialog to modless
Re: Copy cells
It works on 2000, but not on XP
works on 2000, but not on XP
email question
CheckSpelling + TextBox
Locking(?) an excel session
Converting Time in a userform
Re: mswinsck.ocx
Transpose Dynamic Ranges
Copy and paste
Excel Macro - Relative Path
Clicking the text in a textbox erases all the data in the box
How to create a Macro to Copy Information in one sheet to another sheet.
How to use mouse events inside an Excel Sheet ?
flickering organization chart
How to handle other workbook events through personal.xls workbook
matching rows between worksheets/books - best practice
Finding and pasting over a row
Workflow OnExpire Event
Worksheet name
Sub Menu Items
Formatting textbox currency on userform
Extract MS word data to MS Excel
Set range based on cell contents - help required
TextBox focus 2
Pivot table giving an error
VB Delete Sheets
Getting records from Access 97 to Excel 97
trouble with a listindex value...
Inputting data on one sheet and automatically updating other sheets
Concatenate function with 200 arguments
VBA-Make Custom Menu Item Fire
Default Path for Add-Ins
Validation Drop Down
Pocket Excel
Control & Break
Object Variable question
Changing Excel Object's page setup wthout having a printer installed
Sequential Page Numbering
pulling out info. seperated by a comma
Protecting a sheet with filters
Automate delete macros
Excel 2003 - Showing Userform
ActiveCell.Address
Placing checkmark beside menu item
Error missing file when running macro.
Frustration -- >Filtering a list with the click of a Button
IsArray on Variant/Object/Range returns true??
Worksheet change code
progress message in status bar
Macro Help - check existing tabs
Excel 2000 VBA - Selecting populated range
Activechart.SetSourceData Source???
Re: Multiple conditional on conditional format formula
Protection Error
Multiple conditional on conditional format formula
Macro Names
Re: Adding values in textboxes...
Re: Positioning a graphical object
Re: Adding values in textboxes...
Re: Inputbox to enter date
Re: Protection Error
1st attempt vba-how do i whatnext in this sub
Re: faster than VBA macros
Re: Display values in combo box
Re: Conditional column selection
Re: User form search criteria example
Re: how to disable listbox change event
Re: Inserting text to certain cells
Re: Sheet After Double Click event?
Re: Conditional Formatting comparing multiple values
chr() for quotation mark
Re: Macro code question
faster than VBA macros
Re: How?
Conditional Formatting comparing multiple values
Re: copying cells
Re: how to format a date/validate for a text box entry on a user form
Re: Looping Through Names
Re: Adding values in textboxes?
Re: inserting a row with data
Re: Combobox Problem
Re: Looping Through Names
Re: If-Then Formula
Re: Inserting rows with a formula
RE: Run-Time Error 1004
Re: Combobox Problem
Re: Run-Time Error 1004
Re: faster than VBA macros
Re: OrIf formula needed
Re: Hi
Re: If-Then Formula
Re: Calling a private sub
Re: OrIf formula needed
Re: Control
Re: How? Can i avtivate the buttons
Re: Two Questions.
Formatting Number as Text
Excel spreadsheet/template for developing a retail price calculation
Formatting Number as Text
Formatting Number as Text
Formatting Number as Text
To Mark Rosenkrantz
Re: Resetting menu option on close...
Re: Formatting Number as Text
variable inside a formula?
Re: Force a Number to be Formatted as Text (keep leading 0's)
Re: attaching range (from different rows) to combobox
Excel 2000 VBA - Set Print Range in dynamic range
Selected Cell equals x then..
Re: Run-Time Error 1004 Copy method of worksheet class failed
Run-Time Error 1004
Launching other Applications from Excel
Re: Right Function Doesn't Exists in Excel 2003?
AutoSave a WB copy everynight at midnight
summing range
Help ¡¡¡¡¡¡ Please
Freezing panes?
Find text in Column to sum
Haeder/Footer param
Simple If Statement
SeriesCollection
sendmail issue
Re: Adding values in textboxes?
What's wrong w/my code?
Deleting Duplicate Rows but keeping the most recent.
If Satement Modification
using functions as parameters
using functions as parameters
Unprotect and protect....
Re: Importing web data to a VBA Array
Excel Clipboard Problems
Converting a Date to a string
Converting a Date to a string
Creating a new sheet
Help with VBA/macro for Excel data
Self-Resizing Formulas
Access to Excel 97 gurus help needed.
Re: Run-Time Error 1004
Adding Range for Search
Re: readonly attrib on a open workbook
sql.request
Keeping user-inputted data with pivot table contents
Counting records in a filtered list
Command buttons etc
Next Empty cell after Row A10
SpecialCells used to enter data
Macro from a different workbook
Help with xlDialogsSendMail or other way
Re: inserting a row with data
How to Reference Global Variable for external application.
Disable sheets tabs right mouse button!
declaring a public array
Problem updating Excel using ado.net
value lessthan x and greaterthan y
User Defined types
disable print option, not Workbook_BeforePrint
Using array to select rows to copy
Locate all occurrances of a value then transfer to 2nd table on another sheet
Locate all occurrances of a value then transfer to 2nd table on another sheet
Lookup...maybe
naming ranges
Combo Box Question
VBA QUESTION
avoiding hang when formula is being edited
Select Sheets via Array Macro
Programatically Entering an Array Formula
Dropdown Rowsource
can vba import code to vba project ?
Replacing characters with leading zeroes
Userform - Label Caption - How to update from a variable
'Excel component' deployment in winform program(C#)
help: selecting rows within an equation
Linked excel charts, changing filenames generates exception
Linked excel objects in word, and my resulting problems :)
Find ColorIndex
Using Cell Contents to Reference External Workbooks
Data Validation Boxes and Ealier Versions of Excel
macro coding
MS Query & Criteria
Disable Save As dialog on ReadOnly spreadsheet
Copy PasteSpecial
help urgent
help urgent
help urgent
help wanted urgent
Crazy problem when using a WHERE-clause in a SQL query
Check rows and paste
colour text
BEFORE SAVE
Workbook opened with macros disabled
File size grows enormously
comments' pos
VBA - hyperlink
Excel 97 macros in cells?
Invisible macro?
Excel VBA -making Objectnames variable
Add-in not working
Worksheet_Change problem
VBA to VB
modifying conditional format
Alternative to SendKeys
Addin for Excel - general doubts
Changing Cell location within a formula
Excel 2003, XML, databases and macros
Excel importing of .csv and .xml
Need Help with interesting Find & Replace macro
setfocus on multipage tab form gives error message
Hidden Macro
code interferes with function charts()
Cells format
Re: button in sheet
Excel 97 VBA - CURDIR, not reliable
Formulae to sum up values including special symbol?
Re: button in sheet
opening and viewing an access-database
Removing text
cell entry
Access query vs. Excel query
Manipulating a Range
Programing buttons
File name into a variable
Re: Need help on challenging question
Data Formatting
Picture scaling in Visual Basic
detecting row or column insertion & deletion
How to check cell data
Cascading ComboBoxes
Scroll view doesnt work in Code
Please help..
Opening and pasting in active workbook
SaveCopyAs
Macro Help
countif help
Dynamically determining .From address when using CDO
Help
Macro to Create text file from range of cells?
Re: Subscript Out Of Range Error Message
Subscript Out Of Range Error Message
Searching and matching the textvalues in specific column ranges
Help getting code to work.
Find folder with next to latest date
Re: Date in userform being saved as general not date which affects sor
Count Rows with VBA
Publishing an autoupdating Excel Worksheet
CommandBar code does NOT work if Excel is Already Open :(
Feeling beatup by Combobox
SendKeys to a remote server application
Replace with total
Problem running a probram using SQL 2000 Job Scheduler
Line continuation error
Programming command button to execute on a different worksheet
Conditional formating
Selecting a worksheet with a ComboBox
Shapes
Excel VBA Test For Blank Cell
Process data in a sheet within workbook using SQL query?
Excel VBA Test For Blank Cell
Need Help Please
Inserting CGM images in Excel changes image aspect ratio
Trying to set cell value using macro
Re: Help getting code to work.
Please HELP VBA problem!!!!!!!!!!!!!
VLookup problem
Resource / Time consuming macro
Re: saving files in a macro
Multiple-step OLE DB operation generated errors
Web query - using cell contents as part of URL
How to select a celrange?
Error 1004
RE: If-Then Formula
RE: If-Then Formula
Combobox
Using variable names in formula
Re: ThisWorkBook BeforeClose Event
Re: ThisWorkBook BeforeClose Event
GetSaveAsFileName
Need Help: Dynamic Range
Click Button to Load External Data Into Spreadsheet
Can you sort a list based on catagory names without useing a custom list?
Missing movements from kernel32?
Random Function in VB
Macro to hide rows based on a zero value in a particular cell
Re: Excel VBA Test For Blank Cell
Problem with using the "Like"-Operator.
Help reading binary file
Scope of macros
Keep my activecell on A1, no matter about the cursor
Re: Would like to add 0 counts to worksheet after data is returned fro
Assign Results from If...Then and Loop to an Array (VBA)
Macros and if statements
help with displaying information
Converting to tabular format?
Need Excel Solver Add-in
Cell Echo Help Required
Delete/Hide PivotTable PageFields "(ALL)" Option
auto download file everyday
how prin in cells by using vb macro
Help on nested loops
moving worksheet to another workbook
changing the source cell for an embedded/linked object
Shell Command - Net Time (Cannot create text file)
Consolidation: Combining groups of identical items
OnAction property not working
Insert VBA code with a macro in a .xls file by workbook open event
Copy and past drawing objects name problem
Is workbook open on the network?
Adding data from Excel sheet to Access database
Re: Retain SQL Login information for Microsoft Query using Excel VBA
append row
Chart is being dumped into the wrong sheet
Excel Macro help
SORTING AFTER AUTOMATED REFRESHING OF DATA
Why I get "Stack overflow" err 28
adding XML element using Excel 2003
How many new customers every month?
Compare and delete cell?
Printer Set Up in VBA
End-of-line markers in tab delimited text file
Problems with solver and vba
Deferred Mailing from Outlook
A fun but not essential problem...
Number display in formula bar
Array Question
Odd results getting files properties
TextBox focus 3
memory problem with excel
Runtime error 91: Objust variable or with block....
Help a Newby Please!!
Excel VBA - String concatanation problem
Re: saving files in a macro
recording
Calling Macros From VB6
Conditional Formatting Formula
Excel - Visual Basic Complie error
Re: ActiveSheet.Printout
Unsafe ActiveX Controls Issue
Macro Modification Help
Using a field to let user +/- from values.
Publishing Worksheets as Webpages
Copying ranges from one sheet to another
Excel VBA - Looking up Values in every cell until match found
Using named ranges in a function
Re: Insert blank row between data
"Refresh Data" Question
auto Filter broken - frozen?? please help
When opening a worksheet I want it to go to a specific cell
Finding name of last user who modified Excel Spreadsheet
Get source from a web page into a worksheet
XL & Access 2000, ADODB and the Find Method
How do I convert Dates from Text back to Date format using macros
Event Procedure Programming
Tim
How to insert a bitmap into Excel Cell in C# program?
sizing columns in code
List boxes
Resize Dynamic Ranges
textbox
Re: Resize Dynamic Ranges
How to insert a bitmap image into a Excel Cell?
Worksheet Change Event
Run macro after Pivot Chart refresh
Removing Range Names
How to Mute/Enable Windows Sounds whilst running VBA code
created form, want to require input
Can I do this with a TextBox?
Groups and coding...
How to extend a standard class (like Worksheet)
Input Box Code Please Help!!
Re: Resize Dynamic Ranges
Query in Excel
question about the macro vb some one help?
Query in Excel...
XL2K: ADO's Find method (once again.)
VBA code for Excel File Save As
Re: saving excel file
Print Excel files without Blank Pages
compare two ranges in different workbooks and copy data to a new workbook
saving excel file
AutoLoad UserForm ?
colorize celle from a range of date
How to find this value
Autosave
SumProduct function
Autotext equivalent in Excel?
workbook-specfic Macro Menu in toolbar
Need help with report output....macro???
Break mode not working
Excel 2000 VBA - Using Split() with no Lelimiter in string
Convert Date Format of 7/29/04 to Date Format of 072904
Directory List
Page Break Preview
User Defined Function used in Macro returns #VALUE
For loop with non consecutive number
Re: Modules
shifting headings over on column
How to Process Query Data after Query is Refreshed
shifting headings over on column
Re: Modules
Re: Macro with Query
Select cells in a column
Macros with vlookup
Importing Text Data into Excel
Excel macro to control Word Problem
Re: Need Help! VBA screen capture question
Help needed with ADODB.Command
Re: Assigning 10x1 array to 2nd collumn of 10x3 array
RE: Would like to add 0 counts to worksheet after data is returned fro
if it looks like it matches, it's a match
Best Course to Import XML with DTD...
WAV Files
Re: Assigning 10x1 array to 2nd collumn of 10x3 array
Create a days in calendar year add-in
Macro Error(??)
Modifying an Excel Chart in VB - DOM question
Passing Dates to SQL From Excel
Check active sheet not the one with macros
6E+02 what is this ugly scientific format?
Cells.Replace need to keep track of result
Returning range object from custom functions
Combo box
Creating a powerpoint presentation from MS-Excel
information From Global Address Book into list box.
Copying ranges from one sheet to another
Search "Total" in all worksheets and delete rows containing "Total"
Detect Macro Completion
Force a new Excel instance
Re: Please help me improve macro to convert spreadsheet to tabular for
Excel 2000 V Excel 2003
Re: Left JOINS in multiple table MSQuery in Excel
Code Execution Has been Interrupted
Pivot Tables Messsyyyyyy
How to check that a string is a valid formula ?
Userform date format problem
Workbook_Open() not running
Deferred Mail(2)
Import modules EXCEL caused an invalid page fault in EXCEL.EXE
SolverOK, he not so OK
Conditional Formatting
Month end report ? expansion
Conditional splitting of cells
Empty keyword in statment Application.caption?
Saving Excel 2000 files as .xml
Concatenate formula with relative cells
Should be straightforward answer...
Linking Or Copying Filter Arrow
Help with Vlookup in VBA
Macro problem with protecting worksheet...........
Move to a specific cell
Removing Outlook Warning Dialogs.
Removing Outlook Warning Dialogs.
Wrting values with macro.
Slow coding in VBA Excel 2003
Insert row if box on userform is checked
copy to the same workbook
Invisible AutoFilter Drop-Down Arrows
Kill Syntax and path
add a workbook.
VBA - Cells
IF THEN ELSE in VBA
"value" works in sheet, not vba
can not assign value to LookIn
Error check and resume
Microsoft Script: <x:Name>Auto_Close</x:Name> causes errors
Re: How to determine column letter in a spreadsheet?
UDFs: A simple question.
multiselect on a listbox from Control toolbox
Cannot assign value to Filesearch.Lookin
Personal Settings Causing Error?
Macro compatibility between excel XP and 97
wrap text in combo box
Listbox refuses to resize
Immediate window error
Macro to copy text from ColumnA to B
Splitting first and family name
ICD9 Code Evaluation Function - an example
Re: How to determine column letter in a spreadsheet?
Setting LinkedCell on a CheckBox Control
How to create a "combination drop-down edit" box?
Re: A development of a Macro by Tom
Opening a new file from a template
Connect a Template with the data source.
Date Conversion Formula from Bob Phillips...
VBA Function to evaluate hlookup text string as formula
List Selection to First Empty Row
Using Querytable.add to import data from a closed workbook
excel with project embeded in it
Populating Cells in a row.
Coverting worksheet macro to regular macro
combination of numbers in lottery
specific cell values in two ranges
Re: Reference Error
Dynamic Range
Convert CSV Files to XLS
Writing to Network Workbook
Text Box - Restricting Entry
Excel 2000: Web Query not working for https site
Programming Formulas
Using a Macro to Write A Marco
Avioding "Version Update" Dialogue Box
Option button problem
Combo Box
Disabling Circular Reference Checking
enhance trace precedent via dialogue box?
Changing Text in grouped shapes
Which function to use to open an .asc file?
Forms Unload for No reason
An problem of VBA for Excel?Please help me.
Use a RefEdit to select a single cell
Update Links on file open
Protecting Macros
Help Needed to Search and Find Specific Data
Scrollbar macros
Adding other bars disabled ???
Getting external data...
Excel bug, variables reset?
Resource of excel to connection mssql to get data
file can not be opened
How to create a new sheet in VBA?
How to create a digital certificate>
how do you change a row height in a protected worksheet
Help with Mr. Dave Peterson's Code for Consolidating Many Sheets to One
button
Write no closed workbook ?
Marking ActiveX control as safe
On Error GoTo
.Protect ET .Validation.ShowInput
Excel Math Bug
unique entries
How can I insert 4000 rows of Excel data into a sql database
Number to text with leading zero
VBA / IF - Then / Custom Toolbar
combo box
ComboBox on UserForm
Create Concatenated List with Incremental Values
Infinite loop? Help.
Excel <-> Application clipboard data transfer
Textbox error checK problems
Advancing A Number With The Push A Button
Excel/PowerPoint E-Mails
Jon Peltier question: use of MATCH
CONDITIONAL DELETE
Device I/O Error
activating cells
Add menu problem,HELP!
Worksheet change subs.
dynamic chart title
Copy and paste subtotal to another worksheet
Populating other cells with combo box selection
prevent coping from CD
dbx file duplicates QUESTION
application.enableEvents
TextBox focus 4
Pivot code
Dynamic Cell Selection
Help in opening powerpoint file variable from excel
last cell in filter
Macro Names
R1C1 vs A1 addressing
Multi Check Boxes (Selecting Just One)
Have a Macro create a Macro
loop to delete rows...
DDE function
filter code help
Excel "Work"menu option
Command buttons stack up!
ComboBox on UserForm
Filling a Word form from an Excel spreadsheet
sorting rows
code help
Re: If Statement
code help cont.
Excel 97 - Prevent Renaming/Deleting Protected Worksheet
Quick question about dynamically adding and naming worksheets
VB Code
Using same VBA program in diff. Excel versions.
Rows Count of a particular column
Rows Count of a particular column
Possibilities Enhancing Auditing Features?
Find
How to locate record in VBA of Excel2000
How to set default font for forms?
Turn Off Scientific Notation
Turn Off Scientific Notation
calling windows with variables
How to create new sheet in excel using VJ#.Net
Deleting named ranges by looping through range collection
Auto Naming for Cell Ranges
Command buttons duplicating themselves
Object variable error
If/Then Matrix? Can Excel do this?
Excel Chart Class/Object not work propely in IE
Problem with external_data
Remove reference names
How to justify in merged cells
Check if empty
Trouble opening worksheet
Changing Cells, How to
Recommended Book on Visual Basic for Excel
Help in Excel VBA Programing - How to check an Excel Worksheet?
Setting printarea through range object
Open Office Kills my secrets !
Excel Grid to Template/Form?
Freeze pane
cannot unhide rows/columns in the worksheet.
cannot unhide rows
cannot unhide rows
cannot unhide rows!
print userform (for MVA)
Excel VBA: Create new conditions
How to save a bar chart as an image file programmatically?
How To:
Autofill Destination
need time calculation formula
Option of Print Preview or Save As
Programatically navigate to depedent cell(s)
Go To Home
Permission to use object denied.
Problem with printform
Insert Excel Sheeet using VBA
which declaration to use
Problem with TabBehavior on UserForms
Custom Menu return to Excel Menu upon Closing
Filling An Autofiltered List
Filling An Autofiltered List
Unprotecting!
Unprotecting!
Selecting specific data to form a graph.
Unprotecting!
function called from worksheet and bad result!