Microsoft Excel Programming

438 - Object doesn't support this property or method
Automation Error - Element Not Found
Re: Find number of spaces in a string (instr)
Controling recalculation - or how to solve my speed problem?
VB for "conditional" formatting when recalc occurs
Can I test dynamic array for empty?
RE: How can I assign a macro to each name in a drop down list
Position of MyBar
RE: Find negative value & Clear
select first empty cell in a range
location for add-in files
date range for pivot
Re: edit word doc
Re: Debug - last leg of project
Font size (Excel-Autocad)
Re: Tough Excel/Access/VBA Problem! Please Help!!!
Re: change DAO code to ADO
Autofit Column Headers with wrapped text (Not a merged cell issue)
Re: How can I assign a macro to each name in a drop down list
Re: Userform assistance please
could not get solverget working
Breaking up a string
Re: Common dialog control
Re: Problem running macros in Excel filenames containing special characters like []
More efficient code advice needed
CopyRecordset in ADO
How to work a year on year figure
How to work a year on year figure
Re: How to attach an Excel spreadsheet to this forum for help
Extracing Data from Unopened workbooks (DAY 2)
Chart question
RE: Changing Cell Text/Data
Simple loop?
Code not working
page break preview and form button
Re: Quick Start to working with checkboxes etc within a worksheet
How can I rewrite this using an Array?
Truble Attaching PDF Files
Re: Permutations, Array, For...Next, etc.
Re: WebBrowser1??
autofill with dynamic lists
Macro for Ctrl-P to print
Macro
Re: WebBrowser1??
Re: Error on ExecuteExcel4Macro Page.Setup
Selecting proper week
simple loop question
Re: VeryHidden
Re: Excel loop to delete redudent rows
Re: Applying Macro to only certain sheets
Re: Applying Macro to only certain sheets
Re: Quick question on multitasking
Re: Intersect, Union... where's Deduct?
Re: what's wrong with this paste line??
Re: VeryHidden
width of Merged cells within un merged cells
RE: openning Access via Excel
Explorer Hangs on "Reply"
Re: Protect File Saved
suppressing passwords to edit linked files
look up for values in the cells
RE: Excel loop to delete redudent rows
RE: Macro giving runtime error on one PC and not another
Listbox
how do i prohibit user's from accessing formulas (lock the formula
how to add a formula at the bottom of a pivot table?
Re: Loop question
Re: 311983 to 19830101 (YYYYMMDD)
Re: Conditional Compilation Based On Excel Version
Re: multiple worksheet data into 1 worksheet
Re: create a button and assign a macro
Extract and Transpose
Excel FileName as variable in macro?
Re: combobox rowsource as code
Identifying a cell that has changed
ot check out a screenshot of excel 12
Mouse Control
Help with populating a text-box with a pull-down box
method range failed
Re: VLOOKUP From Another Worksheet???
Need
Re: Strange VBA speed issue based on whether overwritten file originally existed or not (?I think?). Excel from Access VBA
Identifying version of Adobe Reader
Re: 311983 to 19830101 (YYYYMMDD)
RE: close without saving automatically
Macro not performing
Re: Auto Sort Columns on Workbook Open
Icon Programming
list related files, select which to open form
Re: Auto Size Wrapped/Merged Cells
Re: Not a valid add-in file???
Re: change data validation
File lists
Re: select listbox item automatically
Zoom - VBA Code
Re: macro {r 1} command in lotus
Re: Dealing with data in rows and columns
Re: VLOOKUP From Another Worksheet???
RE: Dealing with data in rows and columns
Shell Function - Syntax
RE: Deleting Sheets Warning
Re: Vlookup syntax
Re: Vlookup syntax
RE: When to kill an object
Scrollbars on a Userform
Re: Goto Button
Syntax of VBA Code
Re: Goto Button
Re: Clipboard clear
Re: Clipboard clear
help with sumproduct function
Re: Shape Selection Name
Changing cell color
Re: A variable that save its value
Hide and unhide columns
Re: A variable that save its value
Re: Shape Selection Name
Re: showing userform with excel minimized
Macros Don't work anymore
Re: A variable that save its value
Re: Collection Issue
Re: How to identify variable workbooks in an excel Addin
supressing system warning messages
Re: excel macro to move minus sign
Loop & add number list
Re: Info. in a function
Re: Book on Class Module
Weekday in English when using foreign version of excel
Re: excel macro to move minus sign
Re: Array of files
RE: Forcing an OnKey
RE: Forcing an OnKey
Re: UpdateLink giving error 1004
Re: Pull Cells From Sheets
Re: RangeFromPoints
RE: Replacing an Error
Re: sort issue
RE: Prevent deletion Comments
Re: Timing loop help please
Order in which add-ins run
Re: Stop Macros from Running When Workbook Opened via Automation
Re: Using a cell reference to select a worksheet within a macro
add up and calculate textboxes into a label
Re: Daily and Monthly Average Macro
Re: Command Button Color For Next Loop
RE: Excel VBA error
Re: Repost: Speed of inserting pictures and Excel memory
Re: Command Button Color For Next Loop
Error when executing 'Charts.Add' command
Re: Excel VBA error
DefaultFilePath
Populating Specific Lists Based on Criteria
RE: Please help!
Re: Excel 2003 & add-in programming
Re: Referring to named ranges in a macro
Re: I am an idiot - Please help me!
Re: concatenate + format color
Clipboard Problem
Re: Sizing a chart
Re: Creating a Custom commandbar button
Re: Entering current date and time
Re: UpdateLinks
Re: Converting xla to xl COM add-in
This one is WEIRD!
Re: newbe VB application in Excel
Calling stored proc with parameters ..
Re: Macro Problem
Absolute addresses and ranges
RE: VSTO2005 - HResult Exception obtaining Range Object
Re: Macro Help
Re: Validation, drop down list
Re: Hyperlink
Re: loop with array
Newbie Needs Help
CopyPicture only works second time
Re: 3 dimensional array
Re: Loading sheet names in Combobox
moving data from one cell to another
Re: Dynamic Columns in Named Ranges
Re: Can I Reference a Cell "Number" Dynamically?
Re: ListBox
Re: Range Selection
Re: help locating first empty cell in a column
using a calculated column value within a range
Re: Summing duplicate entries and non duplicates
Re: XY Chart Labeler
is text capital
Re: VBA Array Function
RE: Languages support in Macros
Re: Import data from Web cvs format
Re: Option Button/Focus Problem on Worksheet
Re: Invoice
Re: cell color
Re: Control Panel-Dual Display API
RE: Invoice
Re: Weeknum
Re: Modify Command Button
MsForms.Control Event Class
Re: Error 336
application.activeprinter and network device
copy colomn by code
Re: Buttons
IF statement
Coding question
formula through vb code
Re: OptionButton in a Form
Formats of the Row above
Re: Alternate shading based on series of numbers in 3 columns
Re: find the data
'combine' question
is it possible?
Re: Upload to bank account
Calculating Dates from Non Leap Seconds
Re: Extract the maximum value and copy the entire row.
Moving cells and deleting rows
Re: Macro Help Please
Re: File not found - error
Re: Combo Box Scroll Bar
Toolbar Reactivation
Auto run a macro when a date/time has occured - any thoughts?
Extract Data Between Cell Ranges
Is it possible?
Newbie Frage: How to macro-out the daily numbers??
Re: format column to text
Re: Naming field & replacing characters
Macro to randomize and delete accessed hyperlinks
Open File to Protected
no worksheets are visible when I open a file by a right click
Excel-sort paragraphs in a doc(s):egAll on heart on one page?
text in custom toolbar buttons
Why would FIND not work as a batch file in a DOS window?
Need help for develop Excel 2003 Add-ins
Pop-up Alert Help
Is there a way to test first if MySampleAll.xls is already open
please help!
Formatting portions of a cell
range in a table form
"Selection is too large" error
RE: Loading AxSpreadsheet from a .NET resource
Re: how to hide something with excel
Re: Querytable results into vba Recordset
Populate a Combo or List Box
optimize coding on named range
Re: Custom Sort Problems
Code for Sending files using lotus note
Re: To repeat data row after row.
Excel icon
2 pivot tables in one sheet
FAN Charts
Worksheet_Deactivate() problem with deleting data
Re: how to hide something with excel
Re: keep previous result when change, urgent
RE: Graphic objects and Add-In problems
Right-click Combo Event
Entering Formulas in VBA
Re: Macro runs slow
Re: Excel List Sorter
diabling the macro alert in opening files
To copy data from different workbooks
Apostrophe
Worksheet_Deactivate() problem with deleting data
Re: Cell colour chg when formula results equal a weekend day, i.e., "Saturday" and a date that falls on a Saturday?
Challenge Converting Non-Contiguous References
Save as Text (tab delimited) problem
two consescutive finds
Delete file if file exists.
Set Calculation Mode to Automatic without calculating
APPLICATION.RANGE EXCEL
How do I calc interest using 2 interest rates in 1 calendar year
Scroll with active input box
Xla with activeX crash in XL2003
Help Needed copying a worksheet to new workbook
form location on sworksheet
Bitmap manipulation from VBA/VB
Re: Populate a ListBox
Index & Match w/ VBA
Copy cell contents using Input Box
VBA Help needed copy a worksheet to a new workbook
Printer Setup Dialog Box
Web Query
veryhidden with xl2000 & xl2003
Help! Query Refreshing
Macro Help
Can you Copy a Chart from a Website into Excel?
Paste Conditional Formats
Pro-actively run formula
Formula error
All uppercase characters
C# .NET Excel development and Internationalization
Speed Up A Macro / Delete Worksheets
Re: I need a macro to run when a cells in a specific column ares exited...
Decoupling the source of a Chart
RE: Loading AxSpreadsheet from a .NET resource
Need to know what cell called the custom VBA function?
RE: Excel and Asp.NET
Updating records in an Access DB
Repeat F2
Excel Search Filter
Re: Where else to get help?
RE: Macro runs several times, but later crashes - some overflow Proble
Copy selection based on relative reference
Body for e-mail using sendMail
Re: Macro to convert data
Run Time Error for Vlookup & Match command
Re: help locating first empty cell in a column
moving around a sheet
SendMail error
Wait until MSQuery Refresh finished
Remove all borders from a range
TextBox ControlSource
Turning Excel Worksheet Linked to Word Document into Report Templa
Checking before opening "activate:newwindow" to see if already opened
SQL query a workbook -> too many named ranges?
2 excel windows open
VBA Script in Excel Stalls Out On It's Own After Opening Secondary Excel File
VBA Script in Excel Stalls Out On It's Own After Opening Secondary Excel File
ControlTipText Questions
Find a specific word in a column
Odd fill down formula macro question
Turning off automatic calculation when opening a CSV file
X marks the spot
Macro to modify a macro
over 65500 cells?
How to detect if there is change in any cell vlaue in a worksheet?
Need to Save Excel XML as just Excel file for user to open in Excel 2000
how to assign sub routines to events
Help adding info from Multiple Books to 1 sheet.
combination macro
Total sum based on file name
Transposing Sun and Moon rise and set times...
What variable would I use to aquire Today()
My command button has stopped functioning
RE: List of property names and values for a given Object
Data Validation Issue/question
Time error in user form
2 excel windows
Copy module from one file to another
Run procedure in Personal.xls which needs name of calling workbook
Id
Use of a Key line
Copying cells from on sheet to another sheet (via sheet module)
Cycle through a MultiPage Control
need help converting rows to columns (not transpose)
synching two lists
Running a query from an open workbook
Create a macro to Open Hypenlinks
multiple files from one file
Add-in failing with different install drives
Mass population using a macro or something else?
know possible, but have no idea how
Finding Specific Data and modifying it
combining rows and deleting easy for u experts
Ordering Lists
Before_Save event
Update Value Message, Getting Data from Other Excel File
Email Range of Cell Content to create subject and body from link
'Named' formulas problem
Macro to move the contents of a cell
Best fitting curve
Interrupt While loop
Macro Help!!
Shrinking an Excel File
HELP - 'Named' functions
Help with copying a drop down box
Data Selection Page Links
Know when XL loaded from Outlook
BeforeDoubleClick Cancel=True not working
Multicolumn listbox data display
Find text and move it to other cell
Exporting a worksheet as a static image
Email challenge
go to sheet1 to sheet2
Excel ODBC query tables memory overflow
micro programming links
Unhide items in PivotTable
Write headerhandler to decompress the attachment
finding the row value of a defined name
WHAT's THE RULE?: Use of apostrophes(" ")
Want to Open Windows Explorer With an Excel Macro
How to access live data
Goto a form in MS ACCESS
Difference operator in Excel VBA
dos
2 different functions on Double Click
Copy data from diff workbooks but without opening sheets
RE: find first o from right
Look Up Available Speakers
Use part of string
Returning a value dependant on a cell...
can I use excel vba to write tables to a mysql database?
RE: Programmatic cancel of shortcut menu
Cumulative Time Problem calculating more than 24 hours.
Renaming a sheet
Receive soap attachment from JAVA to VBA
transpose the code from "rows" to "columns"
Re: Code to automate exporting to a .txt file
Drop down menu for navigating between worksheets
Workbook tracking.
Copy Condiltional Formatting using code
Conditional execution
Re: Programatically Changing Hover Labels
Recalculation
VBA Code req to select Notes or Outlook
Access library
Distributing elements forming n groups
VBA Code Recompilation with new version of COM Dll
57121 error, but not a Mac in sight
Browse dialoge
Logical Loop
VB: moving data range
close code
Auto Run Macro Upon Entry
VBA Hiding Rows
Trouble creating DSN-less connection
HELP with inserting formula
Form Issue in VBA
Re: Excel 2003 & add-in programming
Help with code
Prevent Save in Excel 2000
Unique Values in a list
Transposing Sun and Moon rise and set times...
Colour of commented VBA
how can i define initial worksheet
Run Module1 first then automatically run Module2
initial worksheet
Conditional Formatting type of operation
Macro to open a workbook
Creating Msg. Box
Find and loop
buttons
Copy rows across sheets
Problem trying to make my DLL callback a VBA function with paramet
Excel Sub-Totaling not Compiling the Total Lines in Proper Order
Positioning a Button
help with retreive print
Placement of Chart in Worksheet
Need to Save Excel XML as just Excel file for user to open in Excel 2000
removal of delimiter
Personal.xls
Re: Creating a Custom commandbar button
Re: Clipboard Problem
sendkeys examples in excel
auto-export VBA modules
preventing reference to a particular cell
Can a file know if opened using a program?
cell size and find increment
change cell color..
Access and Excel VBA
More Excel VBA and Access
Opening/Closing workbooks without dialog boxes
THIS IS A BUG
storing data
Nonsequential column numbering
Logical Testing
How to remove " via vba ?
Email Syntax error
having a macro insert a comment
Getting macro to record keystrokes instead of cell contents
Dueling programs
Keep contents in clipboard
sub for deleting data on a sheet in a range
Date Value auto filled in
Should Method Belong to the Class?
HELP! - how to set in spreadsheet to be used by only one user?
Message box to confirm action
On MouseOver for Cells/Sheets
insert alternatives combobox
Is folder accessible?
macro linking to excel
Size of arrayformula with VBA
Macro to change row number within formula
IF IS NUMBER THEN
copying problems..........
Multiple SendMail Recipients
Help; When protecting the Workbook, tab Macros won't work
to find the last column in macros
Why would Excel change position of control buttons?
Function - Malfunction
Where to find the best URL for a Excel/VBA COMMAND REFERENCE URL?
Very slow macro
Thank you
Excel Macros in XML
Close Workbook
Protect multiple worksheets in a workbook at one time in EXCEL.
Excel saves CSV using semicolon(;) instead of comma(,)
Automating file opening and saving
incorporate variable into VB code
locating the cell having maximum value
Formating Print Margins
Find Function
copy and paste to different work book
comapre 2 col.
VBA Code to extract records between a date range
Copying data into alternate unprotected cells in another spreadsheet
Autofill
How to determine full path of table by a macro within it
Where are the hidden macros?
run macro on selected sheets only
How to rearrange order based on dates of inputs?
Copy Last row UsedRange to next row
Excel97 macro to archive Outlook mailbox
Create a folder from excel
word object in excel
timer in Excel VBA
VB FILE LOCKED?????
iterating groups?
Placing Workshet Name in cells
Send a Fax via VBA
Conditional Text?
How to show old macros?
Re: Can Someone Please Help with this Looping & Match Macro
Adding code to control on form causes Excel to crash
Save a File with a cell value
Adding code to a control on a form causes excel to crash
link between list on same sheet
Deleting all rows after the last active cell
File Open Multiselect
INSERT INTO sql statement causing error
working on a selected file via GetOpenFilename
formulas to macros
Test for file path, alert user and close workbook
Dynamic File Loading
Identifying Text
Which info to change in my macro?
Parse String into Variables
Selecting rows based simultaneously on 3 criteria
EXcel with VB6.0
Upgrade problems with 2003
Controlling the windows taskbar from VBA (API example)
Letters and numbers only
Change desktop icon
Can't find messages
Runtime error 424 - Object required
How can I get an excel macro to close without saving !
Copy a directory
VBs scripting for calling excel sreadsheet
Sum Column
cannot make the excel fill in/delete cells fast
Column showing "overdue"?
3 unaswered questions,1.customized format 2.button question 3.Open
for each optionbutton
Less than numbers issue please help
Master workbook
If statements with drop down toolbar
TreeView Help
VSTO and Excel--End Cell Edit Mode?
circular reference when using a UDF
Macro to change worksheet page settings VERY SLOW.
calculate range in microsoft visual basic 6.3
Activate "current workbook"
Macro Help Please
How to ask VB for the last cell modified???
checking for cell value when exiting
dynamic range question
Manipulate pivot tables in VBA
How to sort on the row selected by user?
Re: delete hyperlinks from graphical objects in excel sheet
VBS starts Excel. How to point to different macro when run?
Initialize Userform, Populate Listbox, Dynamic RowSource?
i need help plz
Passing parms to a VBS file or a macro when executed?
Combo Box of Control Toolbox
Userform Date
Email from Contact List
How do I merge entire columns without merging the rows?
worksheet projecting month to year service contract amounts
Multi-Dimensional Array Let & Get
Import from mainframe
Clear cell based on shading
trigger event if any data in modified on ONLY the current workshee
Can you import data into an Excel Calendar Template?
show list of wbooks present into a dir
Need help w/ macro creating a chart
valuation formula or macro
Running Monarch from within VBA
2 comboboxs, different sheet references
hide rows with macro/togglebutton
variable name
Copping cells EXACTLY from one Worksheet to a new Worksheet?
VBA password problem
User function argument question
Passing chartobject as a parameter to sub
Function () that manipulates other cells
Creating a dynamic Worksheet name?
Help with macro instruction
Open File with name incorporating ~yesterday's date
Font size test
Edit text of formula
Rotation property?
RE: VBA problem with excel 2003
Save file with time date stamp
word OLEObject in excel
Pop-Up for Range
RE: VBA problem
Find any number within string
automatically update money central quotes
Filter list in place if a cell has a keyword within a formula
Force Macro Enabled
Count numbers within a row
userform startup splash screen
Hide excel, display userform only
Excel on the Taskbar
Duplicating rows across sheets
table grouping
Can I make the arrow on a List Box show all the time?
Drop Down List
get range of cells based on colour
Can I create a List Box that ties to a macro?
icon problem
Macros for calculating the range
Macros for calculating the range
Finding a value from another workbook
Re: Permutation in excel
Automation Error and Document not saved
Fetching datetime/user-defined field from Excel?
PageBreak problem. How to improve performance?
Constant in Formula
How do I toggle a button across a range of columns
Manipulating clipboard?
Copy Locked Cell Status
Pass Combo Values to an ODBC Parameter........
Cannot open file for output
How to convert a Chinese character into unicode number?
Excel not responding. Only works if I run split macro in 2.
"Slidey Bar" for Code Progess
Code execution has been interrupted
Relative Referencing Formulas in Arrays
Excel VBA: How to track changed cells
Copy empty cells from one workbook to another - Code
copy/paste
incorporate string variable into VB code
Looping through Excel Applications
Multidimensional Arrays as Properties in Class Files?
cannot connect to .mdf database
Dealing with 3 Printer Ports
Range empty?
IF Statement for Combo Box List
>>> Programming with symbols
Event Procedure - Pick List Choice Unhides Worksheet
Reading a color, and setting a value
Delete cell contents that contain numbers and not formulae ...
validate controls
How can I get a cell's comment moved into an adjacent cell as a st
How do I send a macro and toolbar to another user?
Copying toolbar
Can somebody explain to me how Bob Phillips' unique record counter works?
How do I copy all of excel file including header
last day of the month
Detect if a cell value is a formula
Why does this simple thing not work?
'Out of stack space' error on SaveAs
Can an Excel query retrieve information from AS400 database?
Can an Excel query retrieve information from AS400 database?
How do I check if a text value is repeated in a column (Excel)?
macro help
Concat Variant Values
Copy empty cells from one worksheet to another
reading data from 2nd file in 1st file using Combobox
ADO 6.3 compatibility with 6.0?
Problem with Name of Excel Chart
listbox sizeing problem
Input box opens hidden worksheet
update control source value
I want to pull out certain address in excel and put into a file
how do i create a button to clear a value field i created?
RE: Why is the Excel Addin the Activeworkbook
setting ComboBox Control font
Automatically email co-worker when a range of Excel cells change
Object Postioning property not available for control
Sumproduct to count
Setting a workbooks protection/read only/locked
Worksheet Parsing of Rows Based Upon Column Value
Combo Box - Please Help!
Find Cell Contents on Another Sheet in Workbook
ComboBox
how can I sort on the column selected by the user?
Pull Down Menu Macro
Prevent printing of some sheets and not others in a single doc?
counting consecutive repeated values in a column along with the range
vlookup retaining data?
Lookups
Two situations in the same column
Return top ten results
floating toolbar
Range Definition in Macro ?
Is Instr Slow?
Opening a file to a dynamic sheet
Need a list of command button face ID's (images)
Re: Find Contents of Cell (Macro) - Help me!
Parsing Arguments Question
converting CSV to XLS for online download
Locking VBA module so view only
Copying sheets from ListBox of names to a new worksheet
Calendar
How to specify a cell format for pivot data field?
How to create Help Text?
Email Help
sheets count
Macro for one-click paste special transpose
Excel sheet contects are to be formatted into some specific format
How to test Worksheet exists before trying to create it?
Shet Number Position
changing drive letter in custom macro toolbar buttons
Tring to look this dynamicaly instead of manual code.?
Vlookup in VBA?
Re: Vlookup in VBA?
Fill.backcolor and forecolor do not consistent in Chart and Shapes
Inputbox Convert Millimeters to Feet and Inches
Creating a new excel file programatically
Cell color
Excell Programming
Re: Last time modified timestamp
Arrays in macros
Delete rows that do not contain a list of values
create a chart without set range
Outlining with condition?
formula
Controlling VB executable from Excel File
ActiveCell.Value changes with Format?
Moving rows to another worksheet based on content of cell
Simply DLL in VB.NET and using it in VBA
Determining how excel was started
VBA Code req to close all workbooks
How to create a Pivottable from Textfile
insert text to a specific cell
Change Text Case
Help me Someone!!!!!
Re: insert text to a specific cell
Copying range to other workbook
Retrieving data from not opened Workbook
Replacing references from one file to another
Converting from US date to UK date
Copy empty cells from one workbook to another - Code
Delete Userform
Excel OLE in VC++;AutoFormat Method
Re: Macro - Need location of XLS itself to be set as default
Excel Explosion
changing a recorded macro - date problem....
Macro to subtract data from cells
Edit Text in Formula
Start Windows Explorer from Excel
Personal.xls
How to pass sheet reference to a procedure
excel limit data entry range, control cursor movement to 2 cols
In execel how can I convert dates from yyyymmdd to mm/dd/yyyy
Format as fraction - why doesn't this work?
Supress dialog box for missing linked file
How to refresh a web query every x mn?
How to avoid excel automatically detect the cells formatl???
Automatic query data refresh with template-- system or file setting?