- Change Autosum to use subtotal(9,....) ?
- Transfering Acces Tabel to Excel with Visual Basics
- Excel currency
- xl Dialog
- Possible?
- Using FileSystemObject to get File
- Where to put code
- Re: Closing the save changes box
- Re: web query
- Identify Range Selected By User
- Where to put code
- Personal.XLS path problem
- External Database Lookup via ODBC
- Macro to Rename Multiple Sheets
- formula for avarage with a variable divider
- office web components error
- Select certain rows of sheet & delete the rest
- Change directory for DOS window
- using SaveAs to save 'only' one sheet from one book to a new file
- Type Mismatch
- Re:Macro to insert and delete rows
- Web Query Parameters
- Search code
- macro that closes excel application and open another app
- Locking other cells based on values in a cell.
- code to hide check boxes
- VBA : VBA code for summation formula
- Macro to save file
- Filling a cell with values from another worksheet
- Pivot Tables
- Query OLEDB Provider for Excel file info?
- Msg Box Qquestion
- Can you hide forms checkboxes
- Need help.
- ActiveSheet.Paste Error
- Run-time error '11' & Run-time error '1004'
- Hiding toolbars but keeping the Windows Menu Bar?
- Tired of Excel's Interface limitations...??
- Re: excel 97
- ComboBox on worksheet-strange outcome
- Add signature to files exported to Outlook
- Installation error Access add-ins
- Getting rid of all negative numbers on a worksheet
- First Sheet,First column as template
- Seriously need help
- FBI IS TORTURING ME - PLEASE HELP
- Macro to quit excel and go back to original application
- How can I distribute Workbook with VBA code and library references to other computers
- Before workbook open
- PERSONAL.xls is opening as active when Excel starts - why?
- Re: Run-time error '11' & Run-time error '1004'
- Automatic word wrapping on the formula ... don't know its name
- Toggle Text to be visible and Not visible
- Closing DOS window after shell command
- Basic Macro help needed!
- Find, Offset, Enter Number
- Advanced Programming
- Automatic Sheet Name Read and Rename
- Retaining Formats
- scrollbar control of a chart, live or not live
- Formating column cells
- Help with conditional formatting and referencing workbooks...
- code for having sub rows
- Creating a macro to use the text import wizard
- Rename active sheet
- Re: Text file closure
- Re: Closing the save changes box
- Re: Text file closure
- Text box
- Value of a cell in a range if color is yellow
- VB project protection
- Arrays
- Cell reference
- Need a macro to delete selected rows
- Linked table message in VBA
- application.quit will not shut off application
- Newbie : Help with sort via Excel code
- Array and Named Ranges
- Macro help, again!
- Excel Limitations
- Move Cell to Top/Left Position on Screen
- Macro to Force Response in Dialog Box
- Problem pasting a row from a hidden sheet to the first free row on another visible sheet
- VBA References List
- Error using "Calculate" function in VB
- Simple Listbox question - how to remove items
- VBA and Autofilters
- Selection.Copy Destination:=
- Writing Array Formulas in VBA
- Icon change
- excel
- Toggle text to be visible and not visible
- show the working file
- disable the worksheet read only temporaily in VBA
- Array <---> Range
- Excel 2003 Bug!!!
- Numbering Add-in
- creating dynamic mirrored worksheets
- Protecting Multiple sheets with prompt for password to unprotect
- Additional toolBox controls
- Need a Basic tutorial for Excel VBA
- How to upload the file to Yardi Program
- MID macro
- "Run-time error 91: Object variable or With block not set"
- Disabling Macros
- Deleting the spaces before and after a number in Excel 97
- Back Button Macro
- Fastest way to do this?
- Get a value from a list (Database) aka DGet
- Ignore formulas
- Create and Link check box with autofilter and sum, average of filtered raws.
- Trouble with columns and for each
- Password to get access to certain sheet
- File Name List
- dynamic arrays in excel
- Compile error: type mismatch
- Position of Cell on Screen
- Multiple hyperlinks via macro?
- Automation error in win 98
- VBA AVERAGE formula, ignoring zeros
- Installation error Access add-ins
- Lookups..
- I lose my content of MSDN332.inf and msdn331.inf
- Visual Basic For Applications
- how can deactive cells to input data
- how can deactive cells to input data
- Code using Format Function
- S1.Range("D65536").End(xlUp).Select
- how do you loop through each worksheet?
- Number Switch Code
- Re: VBA problem -
- How can I modify the color of a cell?
- Saving Workbook in Visual Basic Hides the Worksheet, Why
- XLA Unload problem
- Switching woorkbooks & and invoking a macro from within a macro
- Code Run-time error '1004'
- Cut Paste Undo Failed
- Program
- Organizing words, willing to pay $ 100
- Cell A1 in Upper Left Corner
- ScreenUpdating Problem
- filename and path as constant
- Extracting email addresses from Outlook Contacts
- Run a macro at startup
- Need to combine first and last name from two columns
- Quick VBA method for looking up data
- Identifying Bottom-most Entry (And Other Questions)
- Importing/querying data from .mdb file into Excel
- Create custom function and add to the
- Printing only what can be seen
- Can this Macro be done?
- Macro help, again!
- Application.Match with Times
- Application.Match with Times
- I may have found (yet another) bug in Excel
- data transfer between VBA arrays
- Need a macro for selection and sort
- Cursor Tab Order
- updating links when vlookup is used and..
- Forcing Integers into Textbox
- Need help to find the last row of data
- Excel VBA - Calculating average problem
- Determine the type of currency in a cell
- Screenupdating
- Urgent: How to use CheckBoxes in ListBox
- linking cells
- linking cells (2)
- How to find first and last cell in a Sheet with an entry
- Confirming existence of dependents
- Combining Files
- How to modify the comment pop-up behaviour.
- Dialog Query
- Calculation on array in VBA
- Deleting Sheet without message box
- Print Preview all pages at once
- Multipe sheet search
- List Box properties
- worksheet function to vba
- Enforced entries code
- Passing Values Syntax
- IF statement macro
- userform
- Banding - visible rows only?
- how to speed up excel workbook
- Conditional formating
- Set print area with code
- VB user forms
- Accumulating elapsed time
- Sum of Rows when columns are added
- Problem with Data Validation not working
- Coloured Cells and Dates
- Generic questions about variable scope the Initialize event
- Database function / formula question
- Excel to Access
- office icon
- Change the "Delete" key to "BackSpace"
- Another simple one!
- Change the "Delete" key to "BackSpace"
- Problem with FIND
- Mail Worksheet as (html) message body
- runtime Control and code in VBA
- Onkey Error
- How do I calculate percentage from seconds?
- VBA to create an Array of all Sheets in workbook
- Range help
- Endless Loop when using ComboBox1.BoundColumn = 2
- Macro forced to run by data?
- edit/find menu in a macro
- Sort and Add Columns
- calling seriescollection by name
- Error accessing the system registry
- Cell Address
- Copy from User form to Sheet macro
- Modeless property
- Excel-VBA Error
- Excel - VBA Error
- Contracts....
- xlSheetVeryHidden issue
- Blank rows appearing at top after sorting
- Lookup a value based on two keys
- Confirming existence of dependents
- Calling a C++ DLL which returns a String
- Closing a word file?
- Copy formula in active cell
- Viewing worksheets/workbooks
- Using VBA to Write VBA code
- Display MsgBox thru automation
- Confirming existence of dependents
- Checking data with a loop
- how to detect if user has a dialogbox open
- VBA Own Function
- Macro tool for solver
- Launch form from Array
- Print Macro
- Question about an event
- Can I do graphic manipulation with VBA?
- calliing seriescollection by name
- Cell data required upon close
- Date Range Selection the ODBC connection to database
- Select current region less one column
- Re: VBA code to finish this form, Thanks
- Identify User Selected Range
- Footprint size
- Returning an Array as part of creating a cell formula
- Unable to Assign Value To Cell
- editing a subroutine
- Control Toolbox ListBox Properties Blank
- FTP site
- can't get vba to change shading when protected
- En Dis drop down menu.....
- Matching headers and inserting values from a table
- auto filter question
- Removing an addin from the addin's list dialog
- ChangeLink
- .NET or VBA Course
- sorting
- VB to register an Active - X control
- "Static" Methods in Class Modules
- Use Word VBA string in Excel macro?
- WinAPI Functions
- passing strijng with double quotes
- Pausing a macro to select a cell
- Use Windows Script to run Windows Explorer Search?
- Asking for Help
- Remove a command bar
- Select Case for Conditional Formatting
- General Question
- slow file to open
- retrieve data from from a variable wrkbook
- How to find the clip art file name
- Importing text columns in csv file
- Disable Excel's Auto Formatting
- Combobox to cell navigation
- Userform
- WorksheetFunction.CountIf & Worksheet.SumIf with 2 conditions?
- Re: Help creating mimic input box
- ? ABTAIN FILE ATTRIBUTES WITH MACRO
- Control ToolBox ListBox Irratic
- Creating a table in Word
- Strange date formatting problem
- Before Save Requirement
- Creating an array
- Double Quotes
- Double Quotes
- De-Activating the menu option, Window - Unfreeze
- Excel automation in a VB app
- Emailing with a message
- focus on commandbarPopup
- How does one add text or icon to bottom of Excel Window
- emty excel frame
- Turn on Comment Indicator Only
- Triggering Macro Execution
- Excel Error Handling
- Pause during a Macro
- Set new row height based on current height
- AutoFilter /specialcells
- Offset in User Defined Function
- Can't Dim As DataObject??
- Excel/Outlook
- Use cell in calculation only if offset cell contains data
- Re: ScrollArea Property Won't Save
- Adding arrays
- Re: Use cell in calculation only if offset cell contains data
- File's last modified date
- Excel VBA - Import Data for manipulation from multiple text files
- link formula
- Cells.find
- Unique adding of cell from .csv to .xsl????anyone?
- Passing array of strings from DLL function to VBA
- Excel Find All
- Conection with AutoCAD
- Mapping a drive through a macro
- Excel VBA loop until eof
- Sheet Tabs
- macro to determine colour of text in rows
- Run macro after data changes
- Tracking Document Usage
- Search and Replace columns using Case?
- Output to Notepad
- Please help me to solve auto-scan of worksheet
- How to convert PDF form information to excel?
- Newbie Needs some help
- MACRO TO SUM DATA!
- find a string inside another string
- Removable drives
- Multiple lines in MsgBox
- Function "User()" to provide access to workbook
- Graphing functions
- sort 2 columns with "large"
- Append to Comment
- Sort and Save File by Date
- too many external links give "Not Enough Memory" error
- macro question
- VBA function returning multiple values?
- ProgressBar Out of Sync
- Problem with TextBox & ControlSource - Please Help
- auto pick date & time as i enter name help me
- prevent duplicate in Data Validation
- Workbook backup before opening?
- change a xla macro for a new version in XP
- Query for data in an array
- Error querying for open VBprojects in XP?
- data sort macro
- Dynamic Pivot
- Linking Headers & Footers
- Pop-up Error Messages
- Vlookup in user defined function
- Assigning New Name For Each Cell That Matches Criteria
- Loop - for each sheet not working?
- Who can tell me how to programmatically insert an image into Excel by C#?
- Dynamic Pivot
- Number formats in CSV files
- boolean to integer
- What is "Cancel=True"?
- Macro speeds in 95 vs 98 vs 2000
- Excel - Time in Minutes between dates
- capturing a cell value at a specific time of day
- Help with VBA syntax
- Asking for a group of cells
- How to open large HTML FILES IN EXCEL In quick Time
- How to open large HTML FILES IN EXCEL In quick Time
- WorkSheetFunction.CountIf & WorkSheetFunction.SumIf with 2 conditions?
- Function doesn't calculate
- Create directory
- Apply a macro to a pre-selected range of cells
- grafic symbol in cells
- Maybe a repost----Creating Summary
- Addition of rows in table with loop
- VBA Error
- Need function for checkbox in loop
- Dashboard Display
- Setting ScrollArea in Auto_Open()
- Clear the content of a worksheet using VBA
- Advanced Filter does not work in this one
- BeforeSave Sub
- Gathering data
- bar vs. line chart
- Count number of manual and automatic vertical page breaks - examples
- On Exit Command
- Saving an Excel worksheet without getting the confirmation box
- Comparing three columns in 2 sheets
- Re: Mimic input box - Part 2
- Loop for checkboxes
- Exporting Data from Excel
- API Timer
- Excel VBA error on protected worksheet
- Sort By Date and Save
- Create Copy of Current Worksheet
- Auto update...
- Macro for recalculating
- Populating a Temporary Array
- Automatically fill a cell with predetermined
- stretching cells
- backup
- Save xla as xls?
- xla/xls help needed!
- Unable to Assign Data To A Cell
- batch file
- Is it possible to call a UserForm multiple times?
- Formatting cell and doing date arithmetic
- Custom comments?
- textbox query
- Printing Text to Printer
- Call Function From Different Workbook
- scientific notation to text formatting question
- search
- cell.value ???
- odd question
- Using the API Timer Functions
- Macro-eating monster
- Parsing data in cell ranges
- Excel 2000 VBA Sort without Select
- Help with moving cells of info around.
- Controlling VBA
- Fetching VBA "Source Code"
- code to check for project references in VBA
- re: help running macro automatically
- Save file to Network Drive and prompt for name
- Recalulate on format change...
- Try the critical pack
- Formula
- Print Area propery
- Template Wizard and Data Tracking in Excel 2003
- Opening Access from Excel
- how to extract text from a TextBox
- Get SQL data to Excel without ODBC
- Unable to set the PrintQuality property of the PageSetup class.
- Varible in a Range
- Coding in VLOOKUP function
- Questions with 2 workbooks
- error trying to create excel macro
- Removing a module with code
- Problem running macros in Office/Excel 97
- How to pars non-ascii (e.g Korean) strings?
- Hiding Rows with Formulas
- Macro to save file and print document
- SIMPLE DATE FORMULA !
- Euro Converstion
- OR
- Automated Year-to-Date Comparisons
- Using a Loop Statement to Pass Data between WKS and Output File
- Help with find then copy macro
- Excel 2002 workbooks for Excel 2000
- Formula with multiple conditions
- Hiding/Protecting the code of macro
- Control toolbox toolbar
- UserForm Activation
- Help 'splain unusual behavior in simple procedure
- show the current year
- Adding an Array
- FillDown from unknown column
- Excel Driven Access Queries
- Log On Screen / Form
- Userforms Positioning
- Run-time error '9"
- precision calculation
- NEED HELP WITH LOOP !
- add a range of items to a combobox
- Newbie question about web page
- Selecting a cell range
- Problem with Mail Merge
- Save Method
- Checkbox Code
- simple question, hopefully a simple answer!
- Cell format
- Data tracking import to Access with more than 25 tables
- select column cell in same row as loop result?
- Compile error
- Complie Error
- Column Number/Letter Substitute
- protect sheet macro - can't have it enter password
- Check Box Code
- Any way to "Save As" without setting the archive bit on original file
- help in codeing
- Using Excel Add-in functions
- AutoFit
- Help File
- Browse Save As Feature
- SPREADSHEET FORMULA VIEW
- Active sheet?
- macro to close excel application other than application.quit
- Set Print Area
- Set Print Area
- unable to close macro using auto_close or application.quit
- Select File Copy/Paste Macro Help....
- Zip Files
- How to get desired format in textbox linked to a cell
- hot copy
- VBA Newbie, Positioning according to R1C1 format
- Complicated Time Formula
- WS function
- Vlookup - finding more than one matching criteria
- file attributes via macro
- Would like to apply the code to protect cell
- formulas
- Loop with two workbooks
- Modeless but waiting form
- How do I tabulate between textbox controls in EXCEL?
- Sorting
- search question
- Date Error
- Redundant Macro warning or hidden macro?
- Importing Data - overriding auto format
- Inserting a combobox
- Sorting changing a table searching
- Distinct Count in Excel Pivot Table
- excel VBA save file
- Check on the input in an inputbox
- Conditional Row Colours
- Back Up selected sheets
- VBA Autoselect problem
- Problem with autofilter in VBA
- Sheets Back Up
- xlSheetVeryhidden - still option to copy if you know the name of the sheet!
- Auto updates of textbox
- API Timer
- Check Box Code Does Not Work
- Bmp vs Gif in Userform image controls
- FUNCTIONS
- ROUNDDOWN function reference
- Can comment indicators be counted?
- How to convert a column to a string?
- Placing "DRAFT" just on Certain Sheets
- Reduce file size
- Link to ACT! customer database system
- Assign the content of a cell from excel to a variabele
- backwards find function to find character in a string of text
- checking a web service
- Converting a Text file to Excel
- Creating an action button
- Explanation of code
- Command Button Password
- checkbox identification
- Run Query, then Protect Spreadsheet
- spell check a textbox
- Insert a Range name
- vba signatures being discarded
- How do I select this range using code?
- Searching a text and filling a cell with the result
- Mailing Excel workbooks that are not active workbook
- Copy select sheets to another Workbook
- PROB: Grouping Shapes With An Array Loop
- copying range column widths
- Now problem with autofilter
- Select sheet based on cell value
- Pivot table
- Any known Add-In to find/replace......
- Font errors when performing multiple web queries
- capturing a cell value at a specific time of day
- Select sheet
- Accessing Word from Excel
- Running time VBA Excel 2003
- Quick VB Help
- Launching a website from Excel
- Macro Help!!!
- Extract number from name of cell
- running a Database Query
- Excel Comments
- Bar placement
- How can I test when any worksheet within a workbook is selected
- Re-Calc
- Kill statement problems
- transfering info from one sheet to another based on info being transferred
- Font Sizes
- Extracting whole word from cell
- VBA Coding problem -text boxes
- Worksheet Calculate Event
- Adding ToolTip to a button
- Copy text files into multiple sheets of 1 workbook
- dso framer replacement
- Narrow the range a Sumif references
- Sort Listbox Items
- Can you use code to Send excel spreadsheets via Lotus Notes??
- VBA Reference Book?
- Button taking over sheet
- Trying to create VBA script to run Report Manager function.
- Call Excel Print Function, But Not Through a Macro
- XLA problems
- Excel query in a macro
- API Timer Problem
- worksheet function in VBA
- get for loop to go on after blank cell?
- Macro to access Lotus Notes witih attachment -
- validation command
- removing a Worksheet - memory leak (?)
- macro to move cursor
- Resetting the Active Printer
- How do I select this range using code....another try at it.
- How to pull specific data from HTML?
- can't find error in macro logic...
- import mail messages in excel
- Macro Help
- Value of ComboBox on Custom CommandBar
- return the next row
- Displaying part of a sheet on a user form
- Date time conversion
- How do I limit the rows returned into Excel from a query
- counting conditional numbers
- VBA ??: ctrl-arrow shortcut
- Grouping Sheets in VBA
- Unhook (then rehook) workbook events???
- Count duplicates needed
- Access Automation to Excel
- Double-byte challenges. Please help!
- Excel spin button
- Disabling the CONTROL + BREAK shortcut key function - HAVING PROBLEM - MY CODE DOES NOT WORK
- Filtering ComboBox
- detect last row of data
- testq
- Count each group of values
- Making cells change color after a specified period of time.
- verifing entry is numeric
- Making cells change color after a specified period of time.
- return value from MATCH
- How to set equivalent of Visual Basic "redraw = false"
- selecting sheets in vb
- Default printer
- how to overwrite a write reserved file?
- check for valid file
- Macro to Keep Linked Workbooks Updated
- Copy and Paste - Last Row
- Linking a text box to an external workbook
- excel executes only a part of a macro
- Directory Programming
- Showing Values on Charts
- Update the row when type at a cell
- Dynamic update of UserForm TextBox
- VBA+Doing MailMerge with Excel (Off97)
- EXCEL OR ACCESS
- Counting in a range
- protecting cells against cut and paste
- Selecting a Printer in VBA
- Username The Sequel
- Can i setup cells to only accept caps
- Select PivotTable Page Problem
- Select and Delete Columns
- Removing a Btn macro
- Conditional Formatting
- Scroll Combobox with MouseWheel
- Multiple worksheets search
- Highlight/Select contents of object with focus
- Closing a workbook
- Email from Excel
- Looping through the F2 command
- which FormField called a macro?
- run macro from custom menu
- API TIMER
- Continuously accessible form
- VBA Coding problem -text boxes
- Saving and copying results
- Excel macro for delete a clipboard container
- UserForm_Initialize
- Automatically enter Password in Macro
- Saving a spreadsheet without any VBA
- How delete the cliboard
- Error stepping through Autofiltered visible range
- Break Mode query
- Add-on to last request
- how to completely remove an add-in?
- Characters in a cell
- XlPrevious Translation Code
- Username's almost there!
- Loop for changing cell formatting
- Loop Statment help!
- worksheet_SelectionChange Event
- Select Range as far as.....
- Solver
- Excel don't load macros from add-in
- Dos commands from excel
- Using VBA to update Chart Sheet formats and axis titles
- How To: VBA Cells.Find(..... also look in hidden columns?
- Keep Object with Focus on Display Screen
- How find all formulas on tab?
- slow save time
- data base
- Linked Templates in Excel 2000
- VBA to add group divider to custom menu
- Excel fails me - upgrade to database?
- Resizing of Userforms
- hiding #N/A
- Re: Validation/Macros
- Re: Validation/Macros
- Re: Validation/Macros
- Displaying OLE Objects retrieved from MS Access
- Can't insert any controls on an unprotected worksheet
- PasteFace-Problem
- Macro not starting
- Adding Worksheets
- Conditional Copy From One Sheet To Another
- Where do I find my digital signature
- Quit Method do not kill excel process
- Quit Method do not kill excel process
- Where do I find my digital CERTIFICATE
- Identify an Word/Excel file without the doc/xls extension
- Extract Informations inside a Borderframe
- Identify an Word/Excel file without the doc/xls extension
- Identify an Word/Excel file without the doc/xls extension
- Identify an Word/Excel file without the doc/xls extension
- Automatic Macro
- VBA Coding problem -text boxes (more)
- executeble file
- Re: How to covert to text files
- Down one cell at a time
- Event Raised by Paste Special + Link
- Excel VBA issue
- Slow formula's
- Error Loading DLL
- Need help with adding a button to sheet
- SAVING
- Newbie
- API Timer Function Issue
- Problems With Paste
- Text Font Selection Inside Combo Box
- Copy from one to another
- Data validation on print - need code
- Links Break in Protected Sheets when going thru email
- Linked files not updating
- Alerts
- COM Add-in ?
- Identify Document Being opened from an Add-In using Auto_Open?
- Closing ReadOnly file using VBA
- I need smaller code.
- counting and some what
- Creating an ID number
- Routing Slip - Prompts Yes, No, Cancel
- Multiple txt files import
- TextBox Focus
- rounddowns
- Importing multiple text files into single workbook
- Combo box
- Opening multiple workbooks
- Sub Routine Names As Variables
- Histogram and macros
- PLEASE stop Excel version popup!!
- Auto_Open only on initial file open
- Can I disable autocorrect from within a macro?
- File list macro
- Need to identify the start and end of range
- Difficult Sorting Equation
- New spin on old problems
- help with a formula please
- hex3dec
- VB6.0 and Excel
- How to change the first letter in Capital letter
- Importing Multiple files nearly there
- if_worksheet function help please
- Public subroutine called from a private sub
- Sheet Name Confusion
- Toolbar lives on
- Updating sheet