- Removing Column and Row labels and menus from screen
- Excel 2003 RTD Server with Visual Studio .NET/C#
- avoiding VBEopen when using CreateEventProc:AGAIN
- Problem when programatically importing cell that contain numbers and text
- sorting multiple rows at once (including merged cells)
- Shading rows of with similar data
- Supressing Update Links Dialog Box
- Move a text box without allowing it to be cut
- Problems with application.Dialogs(xlDialogFormulaFind).Show
- Tom O thanks...
- Setting print area with vba
- ITERATING A SINGLE CELL!
- Using Macro to Delete a tab in a file
- zero's in excel cell getting rounded off
- How can you fill an input box (user form) with the previous value
- Match
- Routing - macro to open routing dialog and then stop
- before variable contains a value
- Multiple Level Subtotal Problem
- Office Web Components: No Open Method of Workbooks?
- Using VBA to run an Internet-based jsp
- Open CSV files in Excel
- DAY BETWEEN TWO DATES AND TIME
- simple cell copy using VBA
- ODBC / OLE DB QueryTable Editor Add-In for Excel
- Internet explorer object questions
- Developersdex
- pivot table data item
- Converitng Numbers into text (4 as four)
- Run a MACRO automatically by selecting value from combo box
- Data Import Cell Reference
- color formatting ranges
- Just Excel VBA, skip rest
- Simple but frustrating
- SpellCheck msgbox text in VBE
- How do I watch a variable change value during Visual Basic Code e.
- How to disable the Exit Button of UserForm in Excel?
- Strange request Automaticaly send spread sheet as an e-mail
- userform
- Use of ListBox with VBA
- how to handle 'sheetchange' event on 'add-in'
- Unhide
- opening a tab delimited text file
- various
- Possible to view more than one worksheet in same workbook??
- Removing HPageBreaks frrom Ranges
- Creating a rectangle on an Excel sheet from VB
- Copy and paste of sheets via VBA code that has merged cells
- MP3 ID3 API Calls for excel
- Macros andfunctions
- date stamp & appointment tru excel
- Macros always run
- Handle Floating point rounding errors, efficiently
- cdo
- functions using FIND method
- Copy and pasting sheets with merged cells
- funtions using FIND method
- Macro to run filter on existing table
- export many sheets to text files
- Seeking Example Application
- Subscript is out of Range
- how to music to excel conditional formula
- Number and date
- Assign a Date Variable within VBA Q
- Cancel Button on Userform
- Subscript out of Range
- How to create uniform ranges?
- Filter Function for 2-dimensional array
- Help with Array Declarations
- VPageBreak Problem
- Accessing Outlook from Excel
- 64kB limit error
- VBA VLOOKUP AND No Value Match
- When set to route, route with on open worksheet...not the hidden o
- Excel.Application.Quit leaving Excel process stays active
- Beginner - Excel - LostFocus() - Does it work ?
- Beginner - Excel - Auto look up values from worksheet 3 from User
- Beginner - Excel - How to insert new line in Label Text
- SpinButton & Date Format
- Import/Export Text File Tab Delimiter
- How to add a sub-node of a treeview control
- Code Lookup for Number
- Move Text Up
- Arrays
- Launch Macro on Result of Validation
- Error problems
- Forcing a Text Box to accept only Numbers
- Comma Delimited Text File Issue
- Select the end of a row plus 1
- Switching between spreadsheets
- Highlight a Circular Ref
- Error Type Mis Match Error 13
- Help with Header
- Copying Cell Formats
- How do I program in VBA some Excel behaviours like colored-cell-.
- Hide all Excel tool/command bars except mine and reload on close
- Link Management
- VLookup problem
- How to set Printing quality to Draft?
- The On Error Error
- Message box to return curency with $ and comma's intact
- VBA project password for builtin Excel templates
- Statement to give focus to a specific control on a UserForm?
- RegEx in VBE code editor
- Validating a long date in VBA
- Can you use VBA to query an Access database without importing data
- Automate calculations
- Macro Help Needed
- Create a Helpfile within Excel
- Giving Cells a Formula
- Change Logging
- External Reference removal
- extract info to another sheet..
- Updating Worksheet Through User Form
- Password protect parts of worksheet
- highlight non blank cells in column
- Button to generate report
- VLOOKUP Compile/Syntax Error
- I need to change the datevalue to date_text in a formula because .
- Newbie VBE scripting question
- count non bolded items
- Remove "Missing" reference in VB-Tools-References
- how spinner increases other cells
- format listitems
- Cut Paste Coloured Text
- Programmatically saving a workbook to a ftp location fails
- Reversing scores in a questionnaire
- detecting keycode internationally
- Spinner Question
- Select a range in code
- Selecting a range in code
- How do I select a range of cells without doing Range("a3", "f3")..
- Accessing classes defined in another workbook
- Macro to check if data has been entered
- Counting Unique Observations
- Create a pivot table tutorial for both Excel and Access.
- disabling keyboard
- Disable Warning Message from Microsoft Outlook in Excel VBA
- check box interaction
- How to removed the first three char and last char in XLS
- Call Excel from VB6 disabling macros
- Active Directory and UserName
- problem reimporting a form
- Check date
- trigger an EVENT when the value in a cell changes?
- copy data from one worksheet and paste into another workbook
- Varying a macro based on a cell's value
- Regular expressions for replacements in Excel?
- How to recover the excel program?
- Tree Data Structure in VB/VBA
- create a form to find next
- Worksheet _Calculate event handler_how to use
- Dialogue Box to populate several instances
- Excel Spinner Control disabled
- formatting question
- SpinButton Enable/Disable
- Calculations
- Import a spreadsheet
- Suggestions on Control type for Data Entry
- Simple Inventory Control Programs in Excel
- validation - removal from whloe sheet
- Update scrollbar in code without causing change event
- Delete non-selected rows
- experience with Oracle Objects for OLE
- call stack question
- Delete rows with common element
- Select method of Range class failed - but why???
- Making Cells mandatory
- Disable page break preview button
- Listbox initialized on workbook load
- Column index name
- automate open/update/close Excel
- Printing certain pages
- Tom Ogilvy - Delete Non-Selected Rows
- Ref Info Tables
- Use checkbox to toggle between formula and manual input
- Export from Excel to Powerpoint
- automate open/update/close Excel
- Refresh Data Import Q
- Design Question
- Copy chart in C#
- how to parse data and move onto one row
- array of arrays stored in Name: POSSIBLE?
- ComboBox methods in Excel VBA
- Partial Success with ChangeLink & UpdateLink
- Using defined name as a reference
- Excel range selection tool/control?
- Lost vba references and adox conflict
- formula question
- Open an email and attach my excel file
- Print Area
- OnAction Cannot find Macro ??
- Lookup on multiple sheets in file
- How to use SAS data in a pivot table
- FormulaR1C1 syntax
- How do I Bring a window to the foreground? *outlook warning
- How do i make a cell change color depending on the value being in.
- Maybe Outlook maybe excel
- Can I bring up a seperate program with macros? Hit a button and b.
- Previous value of cell before change
- A couple of questions
- How to obtain what the user has just entered (Activecell not working for me)
- Array Formulas
- How do you say "begins with"
- custom icons
- excel, dates and days ...
- animate autoshapes
- Validating a long date in VBA
- Re: Eliminating duplicates from a variant variable
- Dealing with Excel's Word-Wrap Limit
- Create a New Workbook
- Automated Execution of an Excel Report
- Version number for Object model for VBA/Excel
- Auto-lookup values between Sheet3 & UserForm & paste to Sheet1
- Is it possiible to target Appication.EnableEvents on one worksheet
- Excel VBA Close Workbook and Open Existing Workbook
- Working with Charts
- Finding the name of shape in a macro?
- Excel Smart Sequential Fill
- Copy Row & Paste to Last Row in another WB - error
- in excel, the hyperlink dialogue box should show workbook instead.
- Scroll Bar events
- Open a workbook as another Excel process
- writing Macro in Excel
- Keep Chart-Delete data?
- SPIN BUTTON MOVES
- Search filename containing words
- ATPVBAEN.XLA!Random Arguments
- macro to run only under certain condition - how?
- InsertIndent
- Filter by line break
- Syntax error Q
- how do I enable marco
- what is the best way to add help to the template
- VBA Code for Multiple Month Spreadsheet
- Command Bar position
- Data exchange between a DDE prog and excel
- How do you get data to/from Access DB in Excel VB?
- Book choices
- Unique data in control arrey of textboxes
- References changing between different platforms - DLL hell returns!
- Unique data in control arrey of textboxes
- Save from form input
- Better way?
- AutoFilter Program
- VBA: Download file from URL with password
- Removing a module with a macro
- copy a range from another workbook
- Data Types help ... Overflow errors
- Web query and special characters
- combobox population
- Width properties of drawing objects
- cell values
- Record Macro - Record custom user actions
- Macro to Print Multiple Tabs with a Specific # of Copies
- Work Book Security
- array "orientation" in another array
- workbook open event
- Stoppoing ComboBox Change Event from firing when Multipage changes
- Adding checkbox within a frame
- Open Text
- VBP Project Password
- Loop through columns and then rows
- Re: Working with Charts
- scanning and grouping entire rows
- Number entered into cell is dividide by 100. Not fixed by Cell For
- if cell is greater than "" then run macro
- AutoSave
- inserting an excel document to a website
- Average macro/program
- Inability to calculate a range in Excel versions above 2000
- Working with Sheet references
- Passing variables from Outlook Macro to Excel Macro
- Conditional formatting question
- Setting properties of userform controls with VBA
- format
- sort by bold?
- Open PDF
- dropdownlist/AdvancedFilter/shared workbook
- Flow of control in VBA Question - Userform Interaction
- Button
- ThisWorkbook.SaveAs not saving correctly
- Multiple SeriesCollection Selection
- Late Bound Object Click Events
- Default macro usage to this workbook?
- Hyperlink question
- Loop through Labels and Text Boxes within module code
- Printing header on all but last page
- Drag and Drop Help!
- is there way to hide function from Excel interface
- Count specific numbers in a column
- Excel workbook saving problem in vb.net
- How to capture the event before any sheet calculating in Excel
- How to capture the event before any sheet calculating in Excel
- Design Best Practices: Form Control Code in Worksheet or Module
- Widening the Name Box -- need help
- UNSAVED: VBA Project
- Web browser question
- Wrapping a Collection Class
- Holding form control values within VBA
- Color Entire Rows depending on Text in Column A
- USING THE "&" IN VBA FORMULAS !
- Userform Control Paste
- tidying up VBA
- can such a VBA code made?
- import data
- Consider last 6 cells only
- Pivot Table
- CODITIONAL FORMATTING
- open up a word document in excel
- How to convert XLS to a CSV file???
- SUM() function not behaving
- MRP With a Pivot Table
- add to shortcut menu
- How do I change a worksheet in Excel by using a combo-box?
- Password on Website
- Locking excel spreadsheets into fixed format!!!!Help!!!!
- yield function
- Macro Error in 2003
- lining up columns in messagebox
- password
- Disable Option from tools in Menu bar
- Getting a spinbutton / scrollbar to "repeat"
- VBA: How to specify 2nd cell of currently active row?
- Read Only
- Specify which method is default in custom class
- using VLOOKUP from MS Access
- Getting open file's directory, captureing user login ID, write access
- From Excel 97 Programmatically create access 97 or 2000 database and export data to.
- Protect Sheet with password through VBA
- Can I reference a dynamic range within a indirect statement?
- Extract Source Data From Pivot Table
- Why did Excel ask me if I want to save?
- VBA: Hide username and password when opening a web page
- Referencing a Defined Name
- USer defined functions
- Calculating totals depending on cell value
- Working with Charts yet again
- Deleting rows that dont...
- Question about installing MDAC
- Possible to assign macro defined as private to a form control.
- Refreshable Stock Watcher
- Creating a popup via dll in excel
- QueryInterface for interface Excel._Application error
- Converting VB Code for Excel 2000 to Excel 2003
- Selecting total cells once subtotalled
- Extracting attached files from outlook
- wildcard substitution in formula
- what was name of that function/method??
- Excel > Outlook
- Calendar date in UserForm
- Loading data table in a Workbook template
- AND and OR in Conditional Formatting
- sort on not active sheet
- Looping through Cells
- atpvbaen.xls
- PUBLIC DECLARE
- Prompted to save even after setting wb.Saved=true
- Capturing the selected tab in a worksheet_deactivate macro
- Can't save cell values to text file
- Problems with saving cell values to file
- Code for Routing command
- How to set multiple columns in "If Target.Column ="
- Excel VBA Getting email Hyperlinks from sahpes into cells
- Re: How to set multiple columns in "If Target.Column ="
- Write Data to a database
- R/T Error encounter - Posted originally to functions ng - in error
- 2 more questions
- How to programmatically access sheets in a workbook by code name
- Calculating results when data changes
- Why does this not work?
- Renaming Text Boxes and Buttons
- Copy & Paste Freezing Excel
- 2 more questions explanation
- Merry Christmas!!
- Determining background color of cell, in &H0080FFFF& format?
- Widening the Name Box - need help
- protected
- Macro Tutorial
- Deleting Rows
- button
- List of FaceId codes?
- Task Bar & Windows Title changes
- Setting Caption for the RefEdit box?
- How to Get Past the User Form?
- Programatically close a file without saving
- Can you apply a template to an existing Workbook?
- Help with FONTS
- Pasting ActiveX or Form Controls
- Problem with Range function after SP3 installed
- with -.find end with method
- ebook
- export pivot table from excel to powerpoint
- No change event on control toolbox combo box when selection is the same?
- How to copy a CheckBox that is within a Cell to other Cells
- Indicator
- prevent user from selecting and changing a sheet
- PROGRAMMIATICALLY importing CSV data in a SPECIFIC workbook templa
- programmatically changing priority of running excel macro at runti
- Out of Stack Space error
- Workbook property telling number of sheets
- Spell Checking Text Boxes?
- Selecting a sheet based on a cell
- Mystery of the moving control toolbox combo box?
- Excel and Outlook
- VB Script Formatter
- Interest that is Compounded Daily at the Bank
- Change color of entire row and column examle
- Editing Custom Worksheet Menu Bar in XL97 & Associtated Macros
- Substitute chr(39)
- Worksheet update from UserForm
- Toggle a cell
- PasteSpecial error
- Print on PDF file
- Disable drag and drop for a selected range under a certain conditi
- Auto generation of 3 levels of running number
- Looping
- password protected
- test
- & Filename
- Excel VBA & ODBC Data Sources
- Selecting a range
- Filling down a selection
- Formula with a variable in a mocro
- IE User Name and Password message box
- Data Labels in a Chart
- Text length and TextBoxes
- Error with Multiple Recipients on .SendMail
- I/O Error Issue
- Access Error Using Excel COM Component
- Help needed to write a "SUMIF" formula in VBA
- Re: Error 1004 with Data Validation in VBA
- Network question
- CheckBoxes on MultiPage
- Selecting first Unlocked Cell
- Excel Interop Catch Event for Saving a file as xls and as xml?
- HELP using simple TRIM function on relative columns
- Listing files in a listbox
- User Defined Functions
- Programmer for hire
- Programming Project for hire
- Visible=false
- Match
- Option buttons in sync, s/b radio action
- Password lost
- F9 doesn't do calculation
- Not deleting headers
- Internet Explorer question - Refresh
- Select a range
- Lock and protect cells without protect the sheet
- Macro for system
- Excel and outlook
- LineTo in Excel
- Removing blank characters from left of field
- Digitally sign VBA Project at run time
- database with pictures in excel?
- Programmatic font face problem
- Run add-in code when Excel starts
- Nested Count if
- Error: Nonblank cells cannot be shifted off the spreadsheet.
- Type Mismatch
- ActiveX CommandButton gets renamed when Sheet is cloned running Excel97
- CommandBar Controls
- Problem with macro message
- Find cell and determine value in current row
- Embarrassing Excel Macro Function
- MoveFile problems
- Error 424 - Object Required
- solver errors
- set column type
- Module Limits
- Lose the clutter
- Changed cell row number...
- Conversion of VBA to VB.Net
- Excel button :: Filter columns by value - possible? Additionally, hide certain columns
- Protect Workbook
- Hiding Progress Bar
- Need help
- String function in C++ called from VBA
- multi-functional cells in Excell 2003
- Excel 2000 vs 2003
- Workbook_SheetChange triggered to many times
- VB for Custmize / Options
- List the worksheets in a workbook
- macro changes on protected cells
- Deleting rows based upon Error conditions
- Hash table code - anyone ?!
- A file by any other name.......
- resizing buttons
- vbscript question...
- vba sentax
- API in Excel
- FIND AND COPY
- Relative Reference in a Macro
- value of chart scaling
- Excel and AS400 DB2 database
- Application-defined or object-defined error - missing the basics
- sumif acting strange
- Find & Replace : Keep the original format
- Excel automation
- vba code
- Label Caption Problem
- aaaaaaaaaaargh Help! Convert UDF to Visualbasic
- Data entry form with data validation - can I ?
- VBA Command Tree
- Disable PrtSc
- Report from a data table with check boxes
- HELP???
- Prog. Hide range and indiv. columns?
- Set focus to cell?
- Summing a range without making it active
- Looping through workbooks in Folder
- Rows.Count
- Link excel field to Acrobat files
- Copying array formula to a range of cells...
- Identifying repeat ID's
- visual basic example of the defunct "Extract" function in Excel 4.
- STRINGS AND SUBSTRINGS !
- make a cell empty based on condition
- OptionButton in a Frame not visible
- formular to change data on a certain date every month
- "XML parse error" in Excel 2003
- FORMULA HELP
- Userform Control Paste
- Control Sequence from Userform Control
- Setting Excel Cell values using C#
- Remove / Add code through VBA
- FILESEARCH OBJECT
- Universal procedure for changes
- Cherecters and fonts in part of cell
- Paste a file short cut in VB form
- Looping and then Consolidating
- Variable Contents Into Cell
- Listen for a close workbook
- Hold closing the sheet...
- Loops
- Delete rows from outside of Excel application
- Formula syntax, "Object-defined error"
- Button - rearrange column positions in spreadsheet?possible
- Excel macros occasionally do not run
- Help to correct code
- activeform
- Combobox on change event
- Columns that will grab a value from a previous column, incrimental
- code for combo box
- Some Help Processing a Workbook
- Combobox and named range as source
- Find and Select
- Date: library not found???
- Deploying and don't have CD
- Consolidation
- If [something is of the format of.....]
- Using Vlookup in VBA code
- Loop
- Control objects in Excel
- Macro for Word/Excel to create Photo-Calendars
- Ugrading MDAC
- How do I get more then 3 conditional formulas per cell
- Behaviour of VBA ROUND function
- .xll add-in Error in Windows XP "Not a valid add-in"
- Multiple column autofilter criteria? Possible?
- Userform Local Drive & Network drive question
- CommandBars(33)
- textbox sort
- Q about making a function
- Not Copying All Rows
- Help Please
- Invoice Numbering in Excel 2003
- verifying an object exists
- msgbox with no buttons
- Problem with basic looping and criteria
- disappeared custom toolbar
- Cleaning up a web query
- VBA Amateur - Need Help!
- macro to print a Word Doc
- MDAC & MS Jet
- why doesn't this caption property work
- Installing MDAC
- Deleting Repetitions
- excel vb question
- Referencing a cell in the header
- Need formula for calculating totals to range by using multiple cel
- Returning Position Points from the currently selected cell
- Deleting unneeded characters in a cell
- Exch.Rate >> excel cell
- question
- How to enter array formula with VBA
- VBA programs in Excel
- number1+ number2
- 0number
- Macro buttons tiled after print / print preview
- Workbook Title Line
- How to Select Range based on dates in cells
- Setting a formula with code in worksheet added
- Efficiency in my code (a critique from the guru's)
- Move to next blank cell in column
- colored baloon chart in Excel
- Writting a MAcro in Excel
- how to modify address of data in chart
- can I adopt this persentage code to use H1 as referance value?
- referring to tab label in formula
- Hide VB Macro Code
- adding usr defined event procedure of textbox in usrform ??
- Run-time error '91': "Object variable or With block variable not set
- Secure sheets
- Pivot Tables
- Color problem
- Running Access queries from Excel
- Keyboard problem with Excel vba
- Dynamic array problem
- ADO Recordset using Excel as a database. Can't free the memory once opperation is over?
- Userform Controls
- Combobox Problem Re-Visited
- Why?
- Custom Function behaviour?
- Pivot Table - Overcome col. limit?
- Check the value of a cell from VBA?
- Test for Open File
- Help Processing Worksheet
- UserForm-Code Problem
- Read EXCEL table
- Userform Exit button
- download solver add-in
- Help, Macro wont run from a particular worksheet
- ODBC Conenction Programmatically
- Move user to new worksheet with cell click
- Move user to another worksheet with click
- Pivot Table Auto-Fill
- Search input box
- intermittent error - ActiveX component can't create object
- One instance of ADO.Connection for all procs
- Using (what goes in here) for sub routine
- VBA to print Word Document
- determine range size after auto filter?
- Clear range of cells in different worksheet
- if G>I i want A seleceted if I>G than i want C selected
- copying from another instance of excel
- pull down list + value checking
- vba help please
- Add-in does not autoload on programmatic opening
- Function to validate entries in a defined range
- Free Rolodex
- Previous active cell
- data transpose function
- VBA quick help from a newbie
- Error resulting from coding
- how to use relative cell references with solver
- Programming using military time
- opening a workbook without knowing its exact location
- Is there an easier way to fill this listbox
- Strange "N/A" Problem
- Find Method
- auto open, auto close
- Border & Sum
- counting Sundays between two dates
- Help with odd type mismatch error
- How to Convert Text to Number Programmatically
- Array Printing (Selecting)
- Device I/O Error ?
- Newbie - List Box & Buttons
- If Then Statements
- copy data from 1 sheet to other sheet.
- Looping & Summing
- Dull addin menu item
- Obtaining OS language
- Image with mouseover text
- vba code help
- sort a range
- Formatting zipcodes as text in worksheet cells
- Summing
- A recorded Macro to hide certain selected columns hides non selec.
- Delete Certain Rows
- Password protect only one VBA code module?
- How to count COl3 with criteria in COl 1
- Need VBA help
- Protecting Code
- Extend to more columns
- VBA and the SumProduct Function
- If there are no values in row 37 delete it
- Vertical Alignment
- SEARCH EXCEL ARRAY FOR NON-VOIDS AND ENTER INTO ANOTHER ARRAY,
- macro in nonactive workbook
- Load time overhead of VBA controls
- Opening a different application from Excel
- Load time overhead of VBA controls
- Looping through columns
- Excel crashing intermittently on save or file close - caused by vba?
- provide sample excel data in assistance section
- how can i link sheets in my excel workbook
- if cell contains.....
- I'm stuck (again)
- Excel 2003 Alert Messages
- simple formula for next month
- Final Question
- Combo Box & Tabs
- editing strings
- IF...i think
- IF....i think
- Checkbox control
- SUmif and declared ranges
- Finding a cell
- Can't query the HTML
- Updating a Text Box in my Workbook
- How to lose your work!
- Looping & Dumping
- message when activating OLE object
- Detect Excel was started with Windows Task Scheduler
- error 400
- "operation is not allowed when the object is closed" error when using VBA online help -- Resolution
- Delete cells but not charts
- creating or importing new fill patterns in Excel 2003
- Can I use AND like this
- connection to internet mysql-database
- Correct way to use names defined globally in a workbook, in VBA
- define multi region and sort it using unicity
- recalculation - saving
- Buttons - Select All ?
- Variables Held in Sheet Module
- Problem w/ Match prop vs. Match method
- Compile Error:
- Summing same cell in mutiple Sheets
- Looking for templates for a condo Association/secretary/treasurer.
- SQL - extracing digits from a number
- SQL - array
- RefEdit events
- Filling combobox with variable length list
- Changing a "Counter" Value from a Sub
- Are there excel chat rooms
- creating autofilter and using them thanks VBA
- Thread safety of Excel
- Suppress File Name
- access rs232 port with vba
- Can this Formula be Shortened Please
- Detecting Row Selection
- negitive and positive numbers
- Open ExcelApp in other PC via Network
- Send to button
- Freeze panes without line
- select multiple buttons
- Date problems when importing txt files
- Export to Excel API
- Export to Excel API
- Joystick
- where does PERSONAL.XLS go
- Where does thefiles PERSONAL.XLS go
- Macro that waits, then resumes after window is closed
- Addin remains in memory!
- transitioning custom menu from XL95 to XL97
- API graphics question
- Date stamp function