- Using Add Method of QueryTables gives error
- Late Binding
- I want to protect a cell but allow formula values only
- Search form
- lock customize bar
- Accessing selected cell from modal dialog
- PRinting two many repeated lines
- does textbox contain a number
- Find loop
- 2D array lookups
- remove reference via code
- For Next & Hidden Sheets Issue
- Copy cells from other workbooks
- save conunderum
- Thanks!
- Strange PrintOut Behavior
- oh, and another thing
- Date Validation
- a round of applause to frank kabel
- macro function is too slow!
- Not found objects
- Email distribution list
- Creating a action for a defined object
- MyBar doesn't run automatically
- Problem- Recording macros for "file save" and "File open"
- Using an Excel "object" with my VB DLL
- Does anyone know why this won't work?
- how do I create a checkbox?
- Lock down a new instance of Excel App
- Control Properties Not In View
- Add-in conflicts
- dynamic subtotal %
- Custom Worksheet Function not updating
- If Range("C1") is in MyArray
- Print Macro - Printing out of order
- Finding Max Within 3 Columns
- Excel column widths change on different machines
- Solver
- Slow Macro on Page Margin Change for all sheets
- Make "BeforeSave" event supply a default path and file name?
- Need program to ask me to save changes when closing
- Re: Active Cell
- Recall a variable referring to a worksheet name?
- Re: Active Cell
- Column Sort (VBA)
- Pastespecial and cut
- excel vba - spreadsheet code "apply to all" problems
- Circular Reference Conundrum
- Conditional formatting & interior color
- Easy one (I hope) Using Sheet Names to reference sheets in other Workbooks
- Virus Warning
- ADO SQL - Using text functions in Select statement
- else if code
- Search Using Autofilter - Field
- User form
- Save at start of month
- Print Area when subtotals are on.
- Auto-Formatting in Excel: changing values
- Programatically saving XML file as Excel spreadsheet
- Formula to search cell to see if it Contains a value.
- How to make the "Save As" prompt appear with vba?
- Problem with setting Pivot Table data orientation
- Help with Menus
- Changing backcolor of commandbutton
- LegendKey modification Error
- Command Button
- telling Excel to go down relatively
- code to terminate access after certain time
- First empty row after last used row
- protect print_area?
- No debug box
- textbox options
- Control Box Option Buttons
- Intelimouse scroll wheel
- Powerpoint and Excel
- Select Cells with VBA
- How to disable Ctrl+Break
- New to VBA from VB6
- Re: xlDialogActivate to Select Sheets?
- Looping though *.xls files except for the main consolidation file
- Pie charts in Macros
- Highlighting only cells with data in them
- Highlighting only cells with data in them
- Macros to run in any workbook
- While reading excel file i am getting null values
- Create a separator line using conditional formatting
- How to disable Visual Basic Editor in Excel file
- Non contiguous to contiguous
- How To Copy Sum of Cell Values vs A Single Cell Value
- for next with web query
- Hiding sheets with macro disabled - with a big twist!
- Using the result of autofilter and performing tasks on each value
- openning spreadsheet
- Printing
- Printing
- Excel Web Query
- A good book on using Powerpoint VBA to drive macros in Excel ?
- Hide zero column in Pivotreport
- VBA question about Variables
- automatic text insertion in preformated spread sheets
- Code for Case & Number format
- Sheet Name not accepts special characters
- Excel in batch mode
- Re: ssfHistory & ShellSpecialFolderConstants
- Loop code problems
- Excel VBA - Last Author properties
- Help with e-mail macro
- Thanks, This works perfectly
- Variable scope
- wraptext is not updating when using references to another cell
- Refresh Browser with vba
- extracting part of string value
- Maximum length of a line?
- Excel filename into cell
- Complex Match problem
- Add library in vba
- Active Directory
- Delete Multiple Worksheets
- Problem with SendKeys + active window
- How does msgbox stop the OnTime event?
- Can an advanced filter do this...??
- Re: When saving add automatically contents of a specified cell in document properties
- VBA to number worksheets?
- calculate the average of a column then move it to excel
- Copy before sheet
- UserForms and Variables and Types of data
- Re: Change from 2K to XP and Excel.xlb toolbars
- enter value, calculate, in same cell
- if function prob
- Excel VBA event trigger problem
- error on oXL.Workbooks.Open
- Re: Change from 2K to XP - global macro location chnge?
- Exiting a VBA Macro by user intervention
- Formatting part of Cell
- How tp query a spreadsheet table?
- blank cells
- don't bother
- My problems with simple addition ...
- ActiveSheet.Printout or Page Setup?
- File Conversion
- Will Excel create a checkbox?
- inserting latest picture file
- Copy and Paste hidden cells?
- Aligning lists
- Date macro
- Name not recognised
- VARIABLE SUBSTITUTION
- Mode Function
- Worksheet Password Protection in VBA
- Re: Getting "compile error" "method or data member not found" on reinstall
- Copying to another Workbook
- recalculating advanced filter?
- Pad with leading zeros?
- HELP! XL2K to XP -what reference am I missing?
- Using vb to launch a shortcut
- Custom paste macro
- Populate Column Header on ComboBox
- Need help with Macro
- Count days
- Excel - get address of cell
- data validation
- Converting numbers to column letters
- Exporting Data Question
- Re: Spin Button...
- Attaching a similar forms to many templates
- Printing Marcos
- User form keeps getting smaller...what the ???
- If criteria not met then message box
- Pivot Table Names
- Userform inside another userform
- How do I get a reference to a control on a sheet?
- Change a positive value to a negative value
- re:enter button in vb
- Seperating Letters from words using character
- Macro to search, compare, copy and delete
- macro
- Re: unable to hide the "ask a question box"
- excel VBA: input boxes
- Excel VBA - Storing text in a variable, and "'Cells' of object _Global failed"
- Print header change
- User Form
- GOTO another sheet
- RUN Time error 9
- Copy Sheet
- Re: Clearing the contents of merged cells
- Ignoring cells with no value
- Re: code doesnt work
- Formulas for...1. Counting unique cells 2. Display unique contents
- changing a Word doc to Excel
- Pass Variables to Subs/Functions confusion
- opened workbook (not resolved question)
- Re: code doesnt work
- Help
- Can a graph use array data instead of ranges?
- Msg boxes
- macro to email excel files
- Creating Macro's
- UserForm Problemo
- Opening new workbook
- Re: code doesnt work
- Ranges using offset
- Resizing a Range
- Password protect data entry to cell
- Can this procedure be made more efficient?
- On error
- Order in which add-ins load
- Hide the DisplayPasteOptions
- Overflow when translating from C++ HELP!!
- Variable with value before being assigned?
- Macro command to open a file
- INSTERING A ROW
- Last cell
- Open Event Code Bug
- vba weird messages - "catastrophic failure"
- Automatically Assigning a Macro to a button
- Automatically Assigning a Macro to a button
- test
- Help: Profit margin
- vba code to reboot
- Clarification please...
- Match & Indirect
- vlookup, with more than 1 result
- userform data to spreadsheet
- Excel 97 vs. Excel 2003
- Excel 97 vs. Excel 2003
- Formula to return Friday's date: m/d/yyyy
- Calling Access Program from Excel
- Getting Windows user (Account) from a VBA routine
- stillcheckbox remains a pain Frank
- Copy/Paste based on cell content.
- **HELP** Can This Be Done
- Functions
- FTP FILE TRANSFER PROTOCOL FROM VBA?
- Protection options through VBA
- Excel end user reports and preventing changes to users excel settings?
- counting formatted cells in vba
- Summation of cells tied to Checkboxes
- makes a new list
- Excel VBA Beginners problem
- hiding rows
- username
- Licence help wanted
- preventing closure of active excel window
- run time error
- Problem with Office Developer XP in Excel 2003
- delete items from a column
- i have a really long problem,
- Looping Text
- Excel 2003
- userform macro button problemo
- Relative Macro Assignment
- Column
- format a listbox
- Executing a Macro From a Desktop Icon
- Opening A File From Excel VBA
- Does CoGetInstanceFromFile work with worksheets?
- Excel 2003
- Test
- Setting References in VBA
- Excel 2003
- Golf Statkeeper
- Excel Version
- external reference
- Macro to hide rows containing no data
- Auto Duplicating Worksheets and Insterting Data from Different Worksheet
- How Do I Expand A Set Range In The Match Command
- Running a macro every half hour
- Variables not showing value
- ([([([ Page Breaks Problem ])])])
- Tab-key
- Excel macro problem cursor down
- verify open windows
- Userform to spreadsheet
- userform
- multipage question
- Reading a tab separated file to excel ActiveX spreadsheet (C#)
- Tab go into the editing text box not next object
- where is the workbook_open event handler???
- I need some help here
- Printout Code Problem
- Activate Chart
- Selection and Areas
- Importing Text File
- Thanks
- Date Change
- Control Toolbox grayed out in Excel Spreadsheet
- Macro to save worksheet
- Adding up values of textbox in Userform
- Sort Orientation
- Simple Macro
- Re: how do you have one cell alter another cell
- Automation Code Problem from Access to Excel
- macro connect to Sage DSN
- RE: Searching zip codes
- Copying across VBE
- making a userform work
- making a userform work ,oops
- Using Macro & offset to put in formulas
- How to lookup hyperlinked cells
- Help with vba coding/userform....
- Help with Workbook_Open
- HTML HREF Opening in Browser
- Undo change
- How to replace a macro with an addin??
- UDF tooltip
- Copying Cell Using Macro
- How to restrict the excel sheet containing Chart
- How to plot chart in VB program
- Saving with date in filename
- Search a column for the last five cells?
- xls file size / memory errors
- copy protection
- copying all formulas, except sum
- AcitveX only runs with admin rights
- Shared Addins
- array formula in Name Definition.
- Macro to copy down specific number of rows
- Data Validation Criteria
- Validation lost on advanced filter copy
- Signed workbook depends on physical location of AddIn - Digital Signature Invalid - workaround?
- deleting last 4 characters from file name
- How to get last row used in sheet DATA
- Why system asks me to save change even after I call save method(VB.NET)
- unable to open excel file
- Macros
- Getting Excel to update Outlook Calendar
- need formula to set value based on a date
- Finding the Last Day in the month
- References to ADO library for ACCESS connection
- pdf to excel?
- Any Visual Basic Users Having Mouse Scrolling Problems?
- current row - VBA
- Turning off Active-X properties
- Problems that in excel2000 arent BUT in excel2002 (XP) are!!
- Using Variable in RANGE
- Using Variable in RANGE
- Halting the Worksheet_Change event
- Copy before hidden sheet
- Delete Sheets
- select X first/last columns of a pivot table with VBA
- click event for changing cell color
- Comparing Spreadsheets to find information
- processing message
- Refresh
- REPOST:Need help moving XL2K to XLXP, please
- Concatenated Formula
- Ranking 'off sheet'
- Selecting rows in a spreadsheet
- How to open a zip file from the code?
- is there a maximum size of parameter for a (Fortran)DLL call from VBA
- How to avoid clearing undo stack after macro?
- Defining a Range
- update access mdb ...
- Temperature dependant variables - can excel do it?
- Items in a Listbox
- Multiline edit list box
- Price look-up
- Passwordchar Example
- Desperate for help with VBA List Box
- Text too long
- array of rows
- an off topic question
- How to show a userform using excel macro in multipage
- DIm Variables
- run out of memort
- Navigation Buttons
- Return MS Word word counts in Excel?
- lat long conversion
- SheetSelectionChange
- storing an equation in a macro
- Listbox Index Problem
- Workbook Formatting
- Populate list or text box
- Lookups in arrays
- vba function
- What Is "Me.Worksheets(..."
- vba function
- calling a function
- vba function
- vba function
- Undo with custom Paste function
- VBA Copy & Paste
- Wheres the bug
- Wheres the bug
- ListBox Multiple Selection
- Simple Question
- Read Range Data into Array
- TCP/IP
- Re: Concatenate
- Re: Concatenate
- Extracting duplicate data from two lists
- Tidy up data
- Deleting multiple rows within a spreadsheet
- IF Statement
- Re: Concatenate
- Problem with Autofill Macro
- Re: populating a multi-column Listbox
- Re: populating a multi-column Listbox
- Finding cells and values
- Increasing a range in a loop
- Finding Matching Pivot Datafield
- Left Side of Excel Screen Turns Gray
- UserForm | Incorporate a calendar
- Re: Userform Question
- Capturing Print and Print Preview events
- macro terminates with no error
- Code to halt a macro
- Help with perplexing form problem
- Need new approach on forms I set up
- Problem with a defined variable
- Excel to Access question
- Create a "helpsheet"
- Hide all images on userform
- automate 2500 cut/paste/format from internet to EXCEL worksheet
- Offset from new name based on what's checked in Userform
- Referencing a fixed cell in VBA using an IF statement
- Exporting Graph
- ColorIndex
- Problem with populating textboxes in relation to drop down list
- Retry - Find and Replace Macro
- Min function
- Copying spreadsheet out of excel with formulas (pressing)
- "><" formula needed
- QueryTables Object Variable or With Block Variable Not Set
- Detect macro's parent workbook or worksheet
- Pivot Table Grouping
- Pivot Table Grouping
- AutoFilter Values + DropDown Boxes VBA
- Manual Input During Macro Execution
- UserForm Wont Load
- AutoFilter & UserForm
- using code from an addin
- PasteSpecial Error
- vba or formula help?
- Can't add a reference to specified file
- Set smallest cell in row,col as BOLD
- Multiple Selection from COMBOX or ListBox
- Re: Parameter Dialog Box
- Need help with the Like Operator
- Complete a "helpsheet" code
- Pulling Array from InputBox
- Excel VBA - Solver conflict?
- Commands at the line prompt using Shell
- Formula Assigned To Variable
- Protect cells
- Code suddenly won't run on XL2002
- Save .csv with overwrite
- Indirect not the correct solution???
- VBA Copy & Paste_Pt II
- Run time error 28: Out of stack space
- Validations - Building a list of
- pls help
- Cell Formulas vs. VBA
- Conditional macro execution
- Average of 2nd/3rd/4th/5th/6th last cells
- Having trouble importing CSV files with a macro
- Changing what is displayed in an image control programatically
- open work book to current date
- Saving a very tricky code
- Printing Multiple Worksheets
- Saving data in an add-in
- Desktop Shortcut
- Sending variable data to a web site to be computed then brought back to Excel
- RE: How tp query a spreadsheet table?
- Multiple simultaneous macros and userforms
- Protecting worksheet
- Update Chart in Pivottable
- Last Cell
- Setting value of controls to ""
- Macro : seeking max value after an Autofilter
- function help
- Not Enough Memory
- If / True
- Range help
- Problems with date format in userforms
- Dynamic hyperlink reference
- New Formular Needed
- Trapping and preventing a form from being e-mailed before validation
- Re: Password protection of an Excel Add-In
- saving file as personal.xls
- Re: Password protection of an Excel Add-In
- Refer to the cell in which a function is entered.
- Re: Password protection of an Excel Add-In
- Is there any method to remove...
- Newbie: How to define the font size in the status bar window?
- Filtering or linking Page Fields in an Excel Pivot Table
- If integer is text???
- Macro to insert replicates in database
- QueryTables Error
- Help needed starting a macro
- Which button was pressed?
- control a network device based on web data
- Clarification: using excel to send data to ethernet device over TCP/IP
- web query w/login and password
- display a set of data as a calendar
- Copy Sheets
- Naming a range with VBA...
- Web Farming
- Copy each control & rename
- converting VBA into a com add-in
- Hide Row Based on cell value
- Re: Validation (Drop down list vs simple text length validation)
- Re: Validation (Drop down list vs simple text length validation)
- Validation (Drop down list vs simple text length validation)
- Using XMLMaps from VB(A)-Code
- RE: Error Handling
- Setting value of a public var from a form
- Format Event Trigger (XL2002)
- Buttonless MsgBox?
- Error with For Next
- Re: formula to sum LAST five (5) values in column
- Re: Loop through open workbooks
- Help! need some adjustments!
- lost double click ability to open files
- Re: copy-paste error
- Rundll32 & user error
- Repaint causes form to flicker
- Syntax error.
- Need Help creating multiple graphs through coding
- Sort Sheets Procedure
- ParamArray
- Select Range of sheets
- Deleting rows based on cell criteria
- Re: formula to sum LAST five (5) values in column
- Active workbook
- Querying sheet of unknown name
- Addd Net Connect Win98 vs W2K
- Update filename
- Problems with User-defined Function
- Wrapping text in VBA Code
- VB6 to VBA conversion. Form vs. UserForm differences. Object variable types
- red Color for same value cells
- Find Cell Value and Activate
- Interrupting a loop
- Change cell color if data present excel 2002
- AutoFilter help VBA
- Re: Verify Data Format via VB
- Combobox ItemData
- Userform Question
- Border VBA
- Pivot Range Name
- How to make a button conditional
- Read only
- Looking up two entries in a listing.
- Obtain Process ID using .NET and API Calls
- Call MS Word envelope printing routine?
- Print Macro - Printing out of Order - 2nd Post
- Help on file and folders Please
- asp.net Office Automation - in or out of process
- Loading images
- Re: Printing Slow Down On VB Repetitive Use
- Macro selecting blank rows/columns
- referencing worksheet as a variable
- # added to number in function procedure
- #NUM!
- tab in userform locks program
- How to use macro to rename worksheet with date +"text"
- problem excel 2000
- how to supress clipboard notice?
- conditional format limit code
- Phantom spaces/quotation marks when using SaveAs Text
- VBA - graphics
- group rows in a range based on criteria from another range (vba)
- How to name a chart for referencing in VBA? And move it.
- Error updating pivot table source data
- Entering Query Parameters by UserForm
- Auto-Click Save on Clipboard
- Browsing for a folder name?
- Random Sample with proportions
- Adding worksheets
- Making a query from a web page using VBA.
- Differentiate between cell colours
- find and replace macro need help
- copy named range
- reformat numbers
- Event proceedures
- Auto Close function in Excel
- 2 sets of option buttons on one user form?
- turning off unwanted warnings
- Excel and Progress
- urgent. looping thru all records and applynig formula to get new results
- Turning off all the mac ros and code in an Excel Workbook
- Verify that the vbe is active when using sendkeys
- Error message
- check whether worksheet's there or not
- Rescale the Chat using VBA
- Left and Right function is not working
- Objects and Variables
- File name
- Accumulate data in pivottable
- grouping sheets
- Disabling normal printing
- Help: Macro to to sum across selected visible worksheets
- Using add-in functions on a form
- Printing Excel doc.
- UserForm possition
- Format Value Paste Button
- copy rows
- Calendar
- Calendar Add in
- Question correction
- Copy Sheets
- VBA and determining which sheet the code is running under
- delete
- Which function is use?
- VBA Problem
- Displaying a message while a macro is running
- Macro for Excel / Outlook
- Unhide sheets based on a cell value
- Can Vba Help With Auto-checking My Spreadsheep?
- Open Excel file on a remote server
- hide TASKBAR in Sub Workbook_open()
- Macro to look for worksheet
- Excel/Text to HTML using ASP
- Is not equal to... in VBA language???
- Help with looking up mileage table
- Calculations
- Import data from a Outlook mail in excel
- formula not being put into new row
- Worksheet / Workbook Change Property
- Function GetActiveWindow Lib "user32"
-   in Excel
- Help recording a macro to define print area
- Pivot Table Layout
- Excel macro - Opening a sheet in accordance with the value in a particular cell
- Hyperlink to open a common dialog on a msgbox
- If then .... else
- WHere can I find a list of ColorIndex colors?
- List Box
- saving file based on network login
- Re: Adding a text box to a toolbar
- Importing Access mdb to Excel
- Saveas with name of another file
- Deleting workbook names w/ VB
- VBA to add a new chart into a PowerPoint presentation
- Add-In...form call
- carriage return macro
- copy & paste from other worksheet - but not allow to cut
- application/object defined error
- Macro Loop, Find, and Total
- printing/importing problems
- User Form With Doc Word
- Querying Access through Excel
- Variable Cell Refs
- Placing a 'find'(ctrl+F) button in a UserForm
- Rescale the Chart Dynamically - I have briefed my situation.
- Checking for duplicate data
- Multiple Button Creation
- Code or formulas, not sure which
- RE: Attaching a buttom with an event on VBA
- How to prevent copying in Excel
- Re: Attaching a buttom with an event on VBA
- Re: Add_in's Data & Forms
- Re: Attaching a buttom with an event on VBA
- Excel. My Cell Must Contain An '@'
- Re: excel defined name change event
- Workbook Builtin Property - display in Windows Explorer?
- Selecting consecutive rows in VBA
- vba for PowerPoint Charts
- Shell command stopped working: is it part of Excel 95 , or Windows?
- Re: excel defined name change event
- Trying to return Range from InputBox
- help moving info from one sheet to another automatically
- Printing? Worksheets not printing the same on multiple pc's!
- Cell Reference in a Macro
- Bit to Bit Compare of Files?
- Code that retrieves values from a closed workbook
- lIST dIRECTORY
- last resort!!! please help
- Control Source
- ComboBox and Set Focus
- last resort!!! please help
- VBA...How do you state a carriage return?
- Validateing a txtbox from form
- Importing Data
- Combo Box Fill Range
- Function variables
- How do I create a plain text email?
- excel formula
- Need help w/ self-cert in XP
- Simple calculatation
- Random selection of items from a group (AQL sampling)
- Query result and formula
- Format Macro Message Box
- Conditional Formating
- counting the number of ticks
- Re: Can I use XML instead of an Excel Web Query?
- Pass Parameter to Access Query
- excel macro - macro initiation upon hitting the ener key
- Best way to paste a variant array into a range?
- Help - Deleting rows from data tables via a check box
- Using concatenate to create a multiline with references to cells
- How to enter a Range of TextBoxes?
- Hide a workbook
- How to create Excel workbook from VB6?
- Code Reference Problem
- drop down boxes and if then statements
- Selection object in Excel 2002
- Minimize Excel When Running a Macro
- duplicate a user form?
- Slow operation
- clinka32.dll
- combobox exit event
- Updating VBA Modules and Forms in User Workbooks
- Re: cant stop OnTime initiated macro, etc
- Used Range
- Multiple If Formula
- Worksheet_Change problem
- Error Trapping Options Change in Excel 1997
- Multi-row data to single line data
- Print Screen
- Wild card in if then statements
- Changing page orientation with pagesetup
- bullets
- Having problems clearing a row.
- List Fill Range Property
- Re: Setting Toolbar height & width
- Addition to code
- Date formatting
- Protected Workbook
- Error 2015 from ConvertFormula
- Conditional cell reference
- Border style of Excel forms
- Automatically saving an Excel spreadsheet with today's date in the filename
- Protecting and Locking a Mail Merge List
- Got code?
- If statement in Auto_Open
- Range.Select
- List Box and Fonts
- Userform - Populate Listbox2 based on selection in Listbox1
- Break monitoring workbook
- Finish this sentence
- URGENT!! macro for moving data to different spreadsheet
- Creating a CommandBar - what's wrong?
- msgbox
- Buttons
- Macro to increase cell value by 1 each time button clicked
- insert rows
- Making All Checkboxes Run the Same Code
- Excel VBA - Skipping #VALUE! error
- Percent Format without Percent Sign
- Working on a macro
- Copying non-blank rows to another sheet...
- Search/Filter to find values in another range based on two cell values
- VB excel Null values !! Please help me !!
- TreeView
- Function help needed
- Problems converted comma seperated CVS file!
- Calendar Gridcells
- Reading, Comparing and Writting