- Re: Delete records using excel Macro
- Hiding macros
- Hidden worksheets
- Install this critical pack from MS Corporation
- Worksheet Protection
- "This macro calls that macro, which calls .."-how many?
- User Form
- Best practices pivot using SQL-sourced table?
- Email Array
- Replace ActiveCell w/Query Results?
- Disable Excel Prompt
- Range of Cells to populate in a text box on a userform
- Custom Footer using ThisWorkbook.Path?
- Linking cells to a field on a website
- Change to existing macro
- how to delete empty row in vba
- Merging 2 Excel Documents
- Hiding a hyperlink!
- Cell limitations?
- Sending print commands to the printer
- Using variables for row index
- Sending emails via Excel - please help.
- query info based on dates
- Detecting if a userform is loaded
- RE: Apply that corrective package from the Microsoft Corporation
- MIME multiple Excel spreadsheets
- Change Font Type
- How to find a value then select that column
- How to find the first blank cell in a range
- Time a sub routine in thousanths of a second
- Inserting and arranging sheets
- Protecting Sheet
- copying and pasting loop
- Code Modification(From previous post)
- Repeated application of AutoFilter
- Sending Emails according to sheet name
- Sheet Name
- Leading characters
- Tom Ogilvys Code
- Books Excel
- Delete cells - auto move
- Excel Custom Function with Select Case
- VBA Copy Worksheets
- Help needed coding a macro to adjust the source of information each time it is run
- VBA Object (External) for EXCEL
- EnableEvents and DisplayAlerts problems
- Deleting rows with specific value from row 1 to 200
- Global value does not retain value when UserForm is hide
- Can I create in VBA a class with instancing type different from 1 and 2?
- command buttons
- Get external data not working properly
- extracting a stringvalue from filename
- Com Port and VBA from Excel
- OCX Error in Excel
- secure a sheet
- Run-Time code refuses to work in Windows XP
- Need help with algorithm
- On Enter and On Exit events of MSFORMS controls?
- Worksheet name in order
- Responding to cell events in Excel
- How to hide row range from code?
- Count Function in Date Field
- Copy rows to different worksheet destinations
- Assign code to shape
- FillRight
- Run Time Error 1004
- "Each Row from there to here"?
- converting a number to a date
- My Autofilter is overzealous!
- Adding reference in code
- Grouping & collasping in a protected worksheet
- Logical Functions
- Logical Functions
- Copy Worksheet Help?
- Run-time error on command button
- Formating Macro
- Change Printer
- Timed Automatic Refresh of Cells
- NT Domain Logon
- Create an Input Box in Assistant
- Open files in directory
- data validation vs. locked cells
- access X ecel
- Copy and Paste to New Workbook
- Excel Writing speed
- Combo Box addItem question
- Excel - add to "Worksheet Menu Bar"
- how do i ignore cells with font color?
- how do i ignore cells with font color?
- how do i ignore cells with font color?
- Re: PasteSpecial problem
- how do i ignore cells with font color?
- Duplicate Rows
- how do i ignore cells with font color?
- how do i ignore cells with font color?
- how do i ignore cells with font color?
- how do i ignore cells with font color?
- how do i ignore cells with font color?
- how do i ignore cells with font color?
- Remove a reference
- how do i ignore cells with font color?
- how do i ignore cells with font color?
- how do i ignore cells with font color?
- how do i ignore cells with font color?
- how do i ignore cells with font color?
- how do i ignore cells with font color?
- how do i ignore cells with font color?
- SaveAs syntax when using a variable
- Setting Spreadsheet control data source to Excel file
- automation macro
- Transferring data from on excel spreadsheet to another
- Testing Closed Files
- Button, Button, which Button?
- problem with selection when calling macro externally from VB6
- User form trouble
- Differences between Excel 97 and XP
- determinate if pop up menu exists
- Minutes vs Hours
- Random function
- formatting a worksheet
- Find active Windows()
- Use of the "OR" function
- getting the Weekday from serial
- Link a macro to a cell value
- Macro selecting the last used cell does not work
- Identify Forms DropDown as it is triggered
- Passing data between spreadsheets
- 50 workbooks
- RE: Programming Excel in Windows 98 Second Edition
- text to values
- Can I "sign" my own macros? or some other fix for the message about security and macros?
- size of file
- Excel COM Addin
- extracting info the best way
- Modal User Form
- How to merge excel using vba
- Chart.Export throws COMException (0x800A03EC): Exception from HRESULT: 0x800A03EC.
- Highlighting locked or unlocked rows, Searching cells
- Passing ARGUMENTS between event procedures of a USERFORM
- Password set/clear macros - help!
- change a cell formula
- formatting headers
- Code to check for active worksheet
- Edit table to have more of a DB structure
- Custom dialog box on protected sheet
- Tab backwards
- Enter a constant into Ten Workbooks
- RE: tracking user activity on worksheet
- PivotTable and connection string
- Re: PasteSpecial problem
- How to convert numbers to words?
- Opening Excel Workbook from Word using VBA - Always Read Only
- Messagebox: Alert user Worksheet is Unprotected
- How do I make a button to PasteSpecial Values only.
- Setting up Reference Library using VBA
- Excel Macro Program assistance required
- Alternative Text for shapes
- Macro doesn't start up
- Macro doesn't start up
- Keep display steady while macro runs
- simple question workbook size
- How to display a message box
- Need help with advanced filter
- Make a cell into a Macro button
- Adding events to newly add Menu
- Using VBA to rename Pivot Table Query
- Request password during Protect macro
- How to package macro/VBA for commercial use?
- How to package macro/VBA for commercial use?
- two identical scripts, one with problem, the other with NO?!
- automated import of csv files into excel
- Help in classific a group of numbers
- How to cycle through pivot table column labels?
- formatting headers
- Excel Versions
- group cells.......
- Colour cells with dupilate numbers
- Crash in excel.exe
- USer Defined Function
- Sorting a date range of data
- VBA Syntax Question?
- Export extension
- VBA code Help needed
- Validate Alphanumeric
- Getting started with a User Form
- countif (problem: text, number)
- Horizontal aligning of more than 1 excel sheets
- Textbox on excel sheet do not update with VBA
- Autorun macro on opening spreadsheet
- content coloring
- VBA Date Function formatting
- Macros
- How do I open an Excel file in the Web components spreadsheet control?
- Check to see if cell value exists
- how do i ignore cells with font color?
- HTML TAGS that format Data for import into Excel
- Macro run order
- Prioritised listbox
- Formula for Subtotaling
- commandbuttons properties
- Form lists influencing other lists
- 16384 bug
- external data with a password (take 2)
- How copy format, font, color and border without copy/paste?
- Linking Text boxes on worksheets???
- VBA: rename a variable
- Excel solver addin.
- Total by Selection by Column, Help Please.
- Answers please to my query
- help to get output from message to the current cell
- libXLL now available for .NET
- formatting results from mysql query
- How can I get a list of system COM references?
- PivotTable and connection string
- simple count or sum function??
- Control ComboBoxes & Worksheet Protection
- Check For Open Workbook by another User
- SaveCopyAs - Userform disappears
- Units for Application.Height?
- 430 Class does not support automation
- Using the Microsoft Spreadsheet Control as ActiveX
- replacing data on a non focused worksheet with calculated data from the same sheet
- automation error -2147467259
- How to update Access Table with Excell Data
- Exposing Class Module from VBA Excel 97 SR-2
- RE: Try corrective package for Microsoft Internet Explorer
- Excel function wizard categories
- Code to search the Internet?
- Why is my clipboard empty?
- Protect workbook for Excel 2002 and Excel 97
- Why, when I create workbook-level name does it jump it to Sheet-level ?
- Calendar Control 10.0
- A question about Nothing
- Help with Select Case or Best Method
- Launch an external telnet application
- Re: Hidden Columns
- Re: Resetting Screen to Full
- Re: Hidden Columns
- Re: Resetting Screen to Full
- Help Stop Resizing Excel!
- Chart & ms Query issue
- IsInArray function speed
- Page Tabs
- changing directories
- User Form Initialization
- RE: Resetting Screen to Full
- Minimizing application from VBA
- Check this internet pack from Microsoft Corporation
- RE: Resetting Screen to Full
- No match on Advanced Filter -- how to detect?
- Worksheet_Change
- merging excel program with tdc finance program
- Processing a UserForm from an AddIn
- Locking Visual Basic Cell References
- Data Refresh Errors
- Re: Problem with SheetCalculate Event
- Cycling through worksheets
- YIELD Calulations
- Excel ignores VBA commands
- Determining new category number
- PivotTable question
- import email from Outlook
- Limiting Data Imported from Access to Excel
- Dynamic Macro Input
- Auto Expand Combo Box
- assign paste to "cntrl b"
- How can I get into VBA for a custom toolbar - Excel 97
- Dynamic Filename From Macro
- Advanced filter
- Newbie : Find / Find Next
- Re: Open text files as Worksheets in a workbook
- Maintaining dynamically created range co-ordinates.
- Transposing one column into three
- Design Q: XL XP, 97 and multiple users submitting data over intranet
- macro usage in Excel through a VPN
- Automate the Userform option
- 0 "0" ""
- populating multicolumn listbox with an array instead of...
- PivotTable columns not going Invisible
- Hyperlink written to worksheet produces error
- MsgBox Popup in Excel
- V-Look Probrem
- Multiple joins in an Excel Query
- Reading an Excel file after upload
- Drop Down box displays only first list item
- Count Records & Display MsgBox
- Can I make some thing happen if I get a "reminder"
- Tom Ogilvy - Request for follow-up on previous help offered
- Print Preview Causes Crash
- Workbook Protection
- copying selected cells to another sheet
- CopyFromRecordset - Is there a way to filter data that's copied?
- Copying Formula's
- Finding max value
- Using Sub-procedures w/in a function
- Using worksheetfunction from macro?
- Possible to automate Powerpoint from within Excel of Visual Basic?
- EXCEL automation ACCESS VIOLATION vb
- make button - assign to cell
- Hidding rows with 0 as the value
- Edit/Find
- are these groups monitored by MS
- Re: Using VBA to rename Pivot Table Query
- Help me please...
- Listing the contents of a directory in a spreadsheet
- Date Formats
- Combobox Visibility Problems
- inserting sub rutines
- MACRO TO LINK DATA !
- code to find dates
- Selecting a random number from a set criteria by clicking a button
- Creating a SHORTCUT to a file in XLSTART
- excel 97 HELP
- VBA Report How?
- Different colors for combo items
- loop problem
- Modules and Forms
- Hiding macro execution
- Is there a way to turn events on or off?
- copying rows one at a time to another sheet ones a criteria has been forfilled
- Using subfunction in a function
- how to break passwords
- What have I got wrong? (Macro),,,
- VBA code to automatically close file
- RE: Check the important package for Internet Explorer
- VBA - VLOOKUP Sub
- lookup and vlookup
- value interpretation
- Find a String
- Excel - SQLREQUEST - #N/A
- Branching Macro
- Irregular areas of numbers
- Hyperlink --- misswritten....
- Restricting Menus
- HELP relative ref command is gone
- automatic macro execution
- Date format when opening a .CSV file programmatically
- Excel 97
- Copy button images
- Patch Panel Matrix
- Re: Help with "if" statement formula
- URGENT - Need date format for SaveAs code
- Any automation calls gets hung when the Excel workbook has an active cell.
- Re: Help with "if" statement formula
- Modify cell from function
- Duplicate entries
- If formula question
- deleting workbook names in excel
- Network error
- how get cell value from different worksheet?
- How can I find Duplicate Cells or Rows
- Re: how get cell value from different worksheet?
- The instruction at "0x65255ac9" referenced memory at "0x00000008". The memory could not be read. Clikc OK to terminate etc
- Need to modify one small peice of code...
- Can I set a spreadsheet so that when it is opened, a particular toolbar is loaded.
- Class Question
- VBA Autofilter Criteria
- Tracing method calls
- how get rid of upper left green triangles?
- Populating combo boxes
- Combo Grief
- adding sheets together
- Get rid of deleted macros in Excel
- Color Coded Cells
- "Proper" string function
- Problem with VBA Help
- msoBarNoCustomize
- cell value
- Highlight the bad stuff help!!
- Adobe PDF Writer error
- Formula Referencing Problem
- Non Working Cells after command button
- Delete/Collapse Rows Not Selected
- working with positive and neg numbers
- Cannot install MSOffice XP SP1
- Non-Functioning Scrollbar in Excel User Form
- Rotated Text and Line Spacing
- replace a number with a string from database
- something like autofilter?
- Pasting to new worksheet with formats
- SQL against AS400
- Re: Range Names
- Retrieving URL
- Re: Autoexecute Macros
- Open Method of workbooks class failed
- protecting a csv file
- After Workbook closes all my combo boxes do not retain dropdown list.
- I would like help on my function
- transpose: long column -> many rows
- Data management for csv file
- Serious design problem
- Security Level wont change...
- Can I prevent users selecting multiple cells?
- Specific question
- Bad DLL Calling Convention (Error 49)
- DATA LINKING MACRO !
- Range Names
- Re: REPOST: Software recommendation (Recording software)
- Non-contiguous Range limit?
- distribution curve
- Inserting Object in Excel Footer
- Inserting # of rows depending on value in Column
- How can I send data from excel thru smtp
- Do you know how to create a new sheet in a file by macro?
- Calculating a textbox on a userform
- Combo Box question regarding range
- Detecting Change Event for Active X Checkboxes
- Here's a good challenge for someone to work on
- MSVBVM60.dll HELP!!
- Excel Query and Cell Formats
- Cross Referance
- Putting a Border On a Partial Row
- find & replace help
- MsgBox Useage
- Reading from file
- closing an excel worksheet inside vb .net
- extracting unique values with a formula or with vba
- Running a Excel Macro from Windows Scheduler
- open workbook problem
- MZTools install help
- Macro assistance required please
- Deleting Cell Name from Macro
- creating Shapes
- Modules and Forms II
- sending one sheet by e-mail
- cells protection
- Linking drop down lists
- Setting Pivot Table Page Field Names using VBA
- Setting Pivot Table Page Field Names using VBA
- Compile Error: Next Without for
- Sort by Manager
- Date format when using combo box
- annoying bell when trapping errors
- Hyper-Threading Technology for XP with Excel 2000
- treeview drag drop
- formatting text in TextBox in UserForm
- Looping Question?
- Excel programming
- Select from table and listbox
- Re: Combo Grief
- Hiding macro
- Pivot Table Strange behaviour
- Automating a date field to change on certain action
- settings and resettings
- Code mod to add name
- Pivot Table Copy Paste
- File Attributes / Save As New File Name
- combination box to cell
- finding macro containing excel files
- Looping question
- Generate .txt file from 2 cols of data
- How to read data from xls files?
- linking text box with seperate combo box list
- Replace
- Switching between worksheets
- Funny macros
- Automatic Macros
- Unable to get the NormDist of the Worksheet Function
- Screen Area
- is it possible for an html/asp page to access Excel directly
- Can't run workbook with a macro from an 'at' command
- Input Box Drop-Down List
- highlighting row
- Re: Insert rows on multiple sheets
- Pivots using other pivots and dynamic query problem
- reference vlookup cell
- ttoe
- calling an external vbs file on the worksheet close operation
- Selecting File and FilePath
- Dynamic charts with VBA & graphics?
- save on exit message box
- save on exit message box
- Calendar Control
- Sum formula
- Double Subtotal Problem {Excel 2000}
- open workbook by VBA
- Counting checkboxes with a true value
- Macro Help Please
- piggyback cell from formula function
- How many rows fit a page
- Multiple Apps, one DB
- list box
- Listbox--moving items up or down
- Excel Com Automation
- Pasting unformatted text
- Locked Sheet
- Adding Spell Check
- Re: Insert Macro
- Get a part of a filename
- help with macros for getting daily averages from 10 minute increment data - MS2000
- Excel binary file format
- cell, vlookup, same values
- Is it Possible??
- How to access ACCESS from Excel!
- Solver won't work in macro, Excel 2002 SP1
- Name of Event for Sheet
- Send array data from Excel macor to Word Doc using DDEPoke
- size of module
- Mixed variable problem
- Excel 2000 and Memory
- VBA: using ignoreblank property
- Enter key text symbol
- code librarian
- check range for certain value
- Alternate row coloring
- After OpenText all pastes from external apps use format from OpenText
- Getting Column width using macro..
- Taste security update that came from the MS
- COMBINAISON
- importing mulitple files
- Splitting Rows
- Excel VBA Question
- Dynamic Selection of Pivottable Drop Down Items
- Referencing Procedure in Personal.xls
- intercepting password routines
- Code for a progress dialog??
- Help with data sorting - macro?
- Re: xlfArgument?
- Connection issues
- Re: Identify Forms DropDown as it is triggered
- Manipulate all DropDowns on a Worksheet
- Trace Precedents
- MACRO OR VBA CODE TO PREVENT USERS FROM PRINTING THE CONTENTS OF A WORKSHEET?
- Using variable to call worksheets
- FW: Prove the corrective package which comes from MS
- How to stop Excel help auto tile
- using Cells.Find between 2 sheets
- Editing Comments
- VB code for disabling
- Switching Selections
- Whats wrong with this VBA statement -ActiveCell.FormulaR1C1...?
- Protecting VBA Code
- Call up a Windows Message from Excel
- range("myrng"), names("myrng").RefersToRange??
- truncate data on cell ?
- Creating an Excel Database!
- Help with Time formula
- >_< investigating the programing for 'combined cells' >_<
- Excel's database features
- How to make toolbar buttons larger?
- email OLE objects
- testing cell value
- VB code
- Basic Offset Function Usage
- Read List1 and write List2
- Precedents Property
- printing window pops up when Visible field is false
- onditional formatting
- Search, find, copy from sheet1 and paste into sheet2
- Disounts Help Please
- link to Perl/Java
- Updating Infos
- Color Rows Automatically
- Protect Macro Coding
- how to step thru only one subfolder of a folder to find like files
- Re: Sheet names in VBE
- Taste critical update from the Microsoft Corporation
- How to Delete a VBAProject
- Excel to PDF
- Launching a DOS box from VBA
- Using Basic Excel Functions
- Confused on MS Products to Create COM addin
- 2 Copy Sheet ?'s
- Go to the Last Row for Counting Purposes
- Can't insert form objects
- Counting a colour that is Conditionally Formatted
- proteger celula
- Is this done within Excel
- impossible syntax??
- Worksheet_SelectionChange stops working
- file size suggestion
- Why Excel 2002 crashes on simplest Workbook_Open events?
- Application Problem
- Creating something like a file manager in Explorer with Excel Dara
- Circular reference and Naming sheet
- Re: Move selection after Enter
- toolbar macro for esp. worksheet
- overview of postfix vb variable notation
- find sheet from list.
- Shortcut for the "Custom AutoFilter" window.
- xlfTextref
- Saving files with names from ranges
- Sending array data to Word with DDEPoke
- Select Text in Text Box
- Excel - Web Save Problem
- Defining Range Question?
- Reference last entered value in a column
- Automatically including the Form and Code in all the user file
- Controlling Word template from Excel
- Simple use of Len?
- Columnwidth of a merged cell
- Formula with quotes and ampersand
- split a cash amount into two separate cash amounts
- C# - Excel Hangs When Opening Workbook
- C# - Excel Hangs When Opening Workbook
- Launch a Sub Worksheet_Change Event from inside a macro
- additon of values automatically
- How to Close Telnet Session using VBA
- Delete zeros in light yellow cells
- Password to access a worksheet
- Excel programming problem
- code in VBAProject will not run
- Printing Question?
- Looping a solver
- Try the important patch
- If Target="" error
- Deleting Worksheet - No Confirmations ?
- Auto Numbering
- Closing Wookbook with items in clipboard
- Debug Step vs Run Mode
- Re: Excel 2000 math question, repost
- VB6 much slower than Excel VBA
- GetOpenFilename w/default starting directory
- repeat post
- Scrollbar settings in a UserForm
- Excel - huge file sizes
- Move a drop down via VBA?
- Changing font of part of text in a cell
- send file by e-mail
- excel 97: if then and for next loops help
- Transfer Range to Array
- backing up file in directory
- Devious multiplying Forms DropDowns
- Determining Office Version
- Insert comment command
- Formulas with Counters
- Combobox populating based on Option Button
- Are you sure popup box
- Is range a valid address?
- Sending Emails according to sheet name
- Check this important patch
- SQL queries with Excel in VBA to populate a spreadsheet
- Search and replace 9000 times?
- CurrentRegion Failure. Please help!
- A Thank You note to Pio Sjoblom
- Having data populate text boxes based on Combobox Value
- Save file to Web Server from Workbook on Web Page
- auto close while MsgBox is open
- Using Macro to convert > 240 to PRN
- Retrieving title bar info.
- Try on this correction pack which came from the M$
- Labels in a user form
- Error in using "Frequency" function in VBA code
- "Sheet" versus "Worksheet"
- French Password Encoding - cant open workbook!
- userform image from picture in worksheet
- Combo box match required
- 3 textbox values based on value in ComboBox1
- Combo box controlling visibility
- Texbox values based on Combobox Value(more detail)
- Question about ).End(xlToRight)
- Add control to the Chart menu of "Chart Menu Bar" commandbar
- VB Code that will copy color coded cells to an invoice when activated
- Time Lag
- Microsoft Excel 97 Reinstall Question
- Using IF Formula
- Pivot Table - Multiple Pivot Field Selection
- importing a module
- impossible to change the activecell???
- Excel Scheduling Calendar
- Maximum file size
- Sheet Protection Oddity
- Can't update the data from internet while running macro
- Excel custom plots and custom trend lines
- How to display a msg box while opening a sheet
- Display a Message box while opening a XLS file
- Thanks Trevor Shuttleworth
- print with data
- FW: Use that critical package that comes from the Microsoft
- Take a look at that internet pack
- caption sensitivity
- legend display in a graph in excel
- VB how to connect two sub's
- Macro to "Stop Playing" wave files
- how to add 2 ranges
- Try this internet package
- Excel-SQL Connect
- Hiding/Protecting vb code in excel
- how to run macro of closed excel workbook using VBA
- EXCEL LINKS
- Range Class falure
- Automatic Macro Start
- Vlook accuracy
- macro buttons
- Stating ranges in formulae
- Date...
- Books
- Use macro code from external xls file
- Open Workbook from VBA
- bad file name
- Add Formatting Code in Macro
- Open Access
- Save "Range-Value" to variable?
- Remove Cut & Paste Options
- Window Errors
- Adding/removing rows in Excel
- Zoom Not Resizing
- Format + Data
- Opposite of Auto_Open
- Offset Problem
- Excel menu programmed in .Net through PIA
- Possible to assign an array to a SeriesCollection
- Newby question: how to add icons to message boxes?
- Sorting by highlighted cells
- Right Hand Column on Screen
- Save As - Multiple Sheets fails to save as text file
- Refererence to a value in a cell
- I'm new to excel and need help
- Copying custom views from one worksheet to another
- vba array question
- MaxRows 65536 in a sheet - A Code Snippet
- Sum Calculation
- Concat + dates
- Replace sheet formulas with value
- If statement with multiple conditions
- automatic notify
- Re: Use VBE Sheet names in code
- Convert row data to Column data...
- Rogue vertical pagebreak
- macros
- Re: Select a range of columns based on active cell
- saving excel workbooks
- Splash Screen
- recalulating when hiding rows
- ".printform"
- Avoiding Run-Time errors when sending emails from Excel
- Select All and copy and paste
- data problem
- Use the security package
- formula help please
- "delete" key activates Sub Worksheet_Change
- Excel Menu Dissapeared
- help with excel macros getting daily averages from 10 minute data
- Data ranges for Graphs & pivot tables in macros
- Auto-entering the start and end of a month
- Specify date range
- Insert comment command
- Printing an error report
- moving to CLIPBOARD
- Good guide for Excel/Query/SQL
- Disable Macro at open by an external macro
- Chip Pearson
- Truncate last five characters
- VBA
- Export Personal Macros
- Access Recordset with Built-In Function
- Trim string vII
- Using Outlook98 with Excel97
- Editable Excel Spreadsheet Online?
- Re: Texbox values based on Combobox Value(more detail)