- Error when string length > 1024 and starts with -
- Delete all rows with designated word
- Get Run Time Error 13, Type Mismatch on the Application.Quit line
- Populating Sheet Data From A UserForm Combo Box Enabled For Multi-Choices
- macro help?
- Set to Read Only
- Variable life
- Excel crashes with .Close command
- Creating dymnamic named ranges
- How to graph a 2-dimensional array?
- testing the state of a checkbox in vba code
- excel keeps crashing
- Filling rows
- anyone have any improvements for my Weeks Function?
- A Drag drop question
- Functions and Ranges
- Updating Data Retrieved from an HTML file
- Getting a Run Time Error 13 - Type mismatch on the application.quit
- Open a file with Front Page from Excel
- Sorting Worksheets
- Option Buttons
- Copy Current Region
- Calculate time
- Macro control
- Excel automation and shared workbooks
- Graph macro question
- AS400 Date value conversion to Excel
- Combo Box
- Click Event
- Cross reference?
- Hanging on sheet close
- Another Date Format issue
- Macro short cut key
- Is this possible in excel 2000? - Excel doesn't quit when using a particular file
- replacing a range with a variable?
- Passing an unkown range to a function
- Pivot create
- charting cell references
- HELP! Custom Random NumberFunction in VBA
- Getting Details from 1 field
- list of opened workbooks and selection
- ListBox with variable width columns ?
- Excel - adding control programmatically.
- Print to File
- Filters
- Defined named range to array
- Conditional Formatting
- Re: Control for Range
- Help Please
- Re: Control for Range
- Hebrew inverted characters macro
- Which one is faster?
- Refering to a cell in the Header /Footer
- GroupName
- positions
- Return string array from function in excel 97
- Adding rows to create list from DDE data
- Fitting the used area to a page
- Using code to calculate a value in the next row
- Creatiing a Combo box (ActiveX)
- Single message box for multiple IF statements
- Unable to CC more than one recipient when sending a Lotus Notes mail from Excel
- Run Time Error 1004
- ***UPDATING MORE THAN ONE EXCEL WORKBOOK****
- Highlight blank cells
- GetOpenPathname???
- cell naming not showing up in drop down list of formula bar
- RefEdit irregular behavior - corrective measures wanted
- Formatting when doubleclicking in pivot tables
- OptionButtons
- Probably not possible, but... (XL -> PP, and gray border on pictures with VBA)
- blinking cell=> in ms excel
- VB Code Cleaner
- (trying again...) code stops executing
- Type Mismatch on Date
- Deleting a query
- Help: Question Regarding Name Function
- Using variables in worksheet.range
- Heres the proble...
- Greying out cells
- Validating Entry into Textbox
- last cell of a closed file
- application.displayalerts
- Refresh Pivot Table message
- Copyinng & Renaming Worksheets
- Delete based on results of formula
- Timer
- Hexadecimal Calculations
- OfficeXP "Cannot open pivot table source file" when refreshing pivot table
- Excel 2003 + Solver + C#
- Referencing variable
- Excel: VBA userform is shown but not loaded/initialized even though it was first unloaded?
- Re: Excel 2003 + Solver + C#
- unexpected problem in VBA Code
- Flat File formating with Print# Statement
- Range Offset setup (follow Up)
- trouble opening websites
- Stop a VB program from running
- Getting data from DB via FTP
- Freeze Conditional Formatting
- .exe-ing excel files
- locking and unlocking a row of data based on whats entered in a cell
- Excel 2000 Dynamically Set Print Area
- Essbase VBA Macros - Help
- Copy Button with worksheet
- Hide Columns
- Populating cells
- Re: Autofill in a form
- Change sheet reference
- Check if directory empty OR no of files in directory.
- reading html when hyperlink address not hyperlink text diplayed
- How to establish a trial period?
- Macro closes excel and therefore won't run anymore
- Excel as Image Browser
- Error Method Cell of object global failure
- Combining Two Ranges
- check if a file exists / is open
- OleDB returning DBNull for numeric cells
- data selection query no1.
- data selection query no2
- Set up an Ordering facility for a Buying Dept
- How to web query a login required site
- Open a file o the program that was created
- How to connect to SQL db & update cells
- Show user form, leave wosksheet active
- Automating defining names
- Trouble with Union
- Opening browser window
- using hyperlinks in a protected worksheet
- VBA - Form Text box value
- excel and Pocket Excel
- Excel and Pocket Excel
- Save As based on cell value
- Reading and writing from/into several worksheets
- Hiding Ranges
- Sharing workbooks
- Excell's options
- Don't know where to start
- Get External Data Query
- Copy until new value
- A line from MSDN Library
- Visual Basic Question
- getting and error with autofill ":=" ?
- VB.NET insert row in Excel XP
- Grid Lines vs. Borders
- Move Data Between Excel and Internet Explorer
- update...."object required" rt er 424
- Drawing a Curve programmatically
- Copy formula without changing all values
- Re: table preps for xls external data refresh
- IE to Book1, to book2, then close Book1.xls
- extend selection
- I am in need of a Programming Consultant
- SetFocus using variable name
- Using vb to create an excel object and save it as a CSV file
- Today()
- Re: SetFocus using variable name
- Installing someone elses UDF
- selectively copying ranges from one sheet to second sheet
- Screen Area Resolution
- "Unspecified Error" with CommonDialog in Excel 2002 after updates.
- Disjointed formula/macro code must be mended
- Avoid printing blank columns
- Compilation error question
- Assigning Different Caption to a Check Box
- unzipping a file
- rename file macro
- COMBOBOX
- Struggling with 'If Else' syntax!
- copying macro
- VBA Excel Functions
- Recording Page Setup macro
- calling a dll from excel macro
- Three Axis' Charts
- writing to txt files
- Trapping Worksheet Target
- how to print a chart from values calculated in macro
- What's the equivalent way of "Cells" method for the C++(ATL)
- Textbox Text is Truncated
- Offset Code
- Goto...Return question
- Column Number to letter in Row Source
- Toolbars
- Pivottable database connections
- A problem of Excel.
- Trapping Excel Close event
- Is there a "replace" or "Substitute" command in Excel's VB?
- calendar already done?
- How to handle Blanks (empty Rows)
- Can't Exit Design Mode
- How do you extract the top ten values in a table?
- How to create User Defined function in Excel
- Excel memory problem
- find worksheet by FindMethod
- VB numpty
- Run Time control events
- PageSetup is slow
- Calling Subroutines/User Functions from Macros
- Index of Minimum value in array
- Tricky Transpose
- Detecting Worksheet Activity
- Excel programming not using COM
- How do I add a vertical spacer bar in toolbar
- Exporting Access data to different worksheets on the same workbook
- Excel VBA
- Creating a Named Range using VB
- Start up files
- macro to pick data
- Random number
- add in failure
- Add Names
- Validation...
- Random Numbers
- function calls
- Exporting subset of rows to multiple files
- Multiple Web Queries
- Follow Then Thread (Sewing 101?)
- problem with code
- Copy data
- Add values of textboxes together
- Unable to set the Chart type to XY Plotter
- Random numbers
- Macro shortcut key
- excel shuts down when text is changed in cell
- After Enter in a cell
- Opening a new mail dialog box in Excel using vba
- Complex Conditional Formatting
- vba-showalldata
- How to select entire column using VBA
- Is there a TimeDiff function?
- Matching cell
- Copying data across 2 xcel files
- Reading the Registry - CSV Download Flag
- Word Scramble
- Excel Copy
- Why 2 macros differ so much in speed?
- Excel to Access - ADO?
- CODE to select range based on User Input or Value of Input Field
- Copy value in formula
- Excel XP Macro Loading Problem
- Problem with PrintArea property
- Web Querying from excel.
- Date Formating using VB Vlookup
- Inserting records from Excel directly into a SQL database
- Object defined error
- Run a macro when new selection in listbox
- Range as argument in function
- Way to prevent VLOOKUP from verifying remote file exists?
- Image resizing DLL
- Help with some code please
- Re: Top Ten List
- Repeating macro
- Deleting rows filled with 0
- vba- go to top of page
- Need some help with in coding!!!! text file importing
- Help with data importing from txt file to excel programmatically
- Counting Instances of a Value?
- Creating a function
- Auto_open or On_open
- How do you list all the workbooks you have opened and the sheets in each workbook?
- complex column sorting
- Calendar Control & Office XP SP2
- Creating Shape at runtime
- Selection method not available in VB when referencing Excel worksheet
- Shared Workbooks
- VBA cheat sheet?
- Simple VBA - What's wrong??
- Macro to nsert value from table, then next value, till done
- vba - How to opening a file (*.doc *.xls)
- Time.
- need to set a cell background color which is not within the Excel colorindex range
- Can anyone help with input boxes?
- Trapping Excel Close Event
- Accessing pixels in bitmaps + retreiving from registry
- Importing texsts files
- Unsaved file as E-mail attachment
- own-made FaceID 's or command buttons in menu bar
- Help with locking Cells
- Printing hidden sheets
- CUT and COPY?
- Excel Driver
- Sample Array
- Creating Folders from Excel Using OLE Automation
- populate listbox
- Hide workbook
- Object variables
- Updating a Function's Result
- Listbox on custom toolbar?
- Visibilise toolbars/menus based on active sheet
- Add pictures to UserForm at runtime
- Shared Workbooks
- FindNext problem when using PasteSpecial
- inputbox help
- Validation list using code
- Application.Calculation
- Checking if workbook is open
- is it possible to CLICK & insert date
- Floating List Box
- times
- looking for html to pull series of urls
- Export Excel to Word
- Time to output in seconds,00
- print sheets
- Code runs different in a commandbutton than a macro why?
- Help with setting up an Ordering system, please
- Applying formulae to cells???
- Mmm tricky- but i'm sure someone out there can help!
- Delete all blank worksheets?
- Charts on a User Form
- public declaration
- Color every 'nth' row?
- Dialogframe
- VBA Query coding in Ms Excel for Mac OS 9 (ping Jim)
- Limiting tables in Excel query
- Help with Validation Tables
- Accessing the clipboard after copyface
- Paste values
- Blinking Text?
- Select a value from a combobox drop down list through code
- Forms
- Printing multiple worksheets only if data exists
- Validation List with Variable Lengths & Invisible Empty Cells
- Cut & Paste Data into different worksheet based on specific criteria
- Disable the right mouse button??
- Modify code from one macro to another...any takers?
- Running Excel from a Server
- Strange problem with filesearch...help
- How to calculate cell's contents printable width?
- myaddin tutorial
- Identifying and locating linking cells!
- Disable/Enable Macros through code
- Floating Cell Total
- Trying to select values in a column with blanks
- Conditional Data formats
- File won't close when "beforeclose" event is used.
- Need help with combobox output
- listing which documents were changed by macro
- CountIf for two columns
- Address
- List Box format
- Auto_Open vs Open and call macro --priority question
- creating a checkbox control on a user form using VBA
- List out FileNames.xls with K4 Blank
- Simple Questions
- move '-' from back to front???
- Getting data from Pivot Table
- Delete all special characters in a selection?
- Statistics, Charts and VBA
- Question about Protecting a Workbook
- ComboBox Question
- deleting text is easy... but what about this?!!!
- find cell with value greater than my number
- Accessing Addin from Sheet_Event Code
- Widen Data Validation Dropdown
- Accessing Addin from Sheet_Event Code
- Re: Excel XP Macro Loading Problem
- Blinking Text
- Return ActiveX properties by means of a variable???
- Point Me. Searching strings for lists of keywords
- Copying calculated values
- Opening Excel with a stream
- Printing selected pages
- message box/question box in a formula
- VBA Training course?
- Protecting Add-In's from viewing
- formula?
- Bad Office CD -- how do I get a replacement.
- Functions not executing in Excel 2000
- How can I convert text to all lowercase?
- Listbox ColumnHeads
- Personal.xls Macros
- Time stamping - automated by worksheet update
- macro how too?
- listbox will not refresh
- How to make paste FaceID disappear after API paste?
- Bringing info from userform to spreadsheet
- Lost Menu Bar
- Sending mail from excel with CDO
- function or call macro
- conditional colors in stacked bar chart
- OLE picture refresh?
- Excel sheets saved as XML files that can be read by .NET
- Excel XP Macro Loading Problem
- Create and show UserForm from Add-In
- Problem with the Excel 10.0 Object Library
- excel - ListBox multiple Select
- Re : Making use of the Built-in Dialog Boxes
- How to create a PASSWORD ENTRY BOX at startup of Excel Application
- Sending data as POST request to a Webserver via VBA
- How To Copy a Sheet to Another workbook
- How To Copy a Sheet to Another workbook
- Looping through Ranges of Rows
- When workbook is closed tries to reopen??
- Spreadsheet 'Tours'
- Excel Addin and Delegates in C#
- Sort one column and entire rows get sorted
- Web-based (preferably free) VBA Excel tutorials
- Validate Excel Range with RegEx
- How to get cell in a certain place
- Looping through Ranges of Rows
- 'find' in directory
- Adding/Deleting from toolbars using VBA
- Userform and reading multiple listboxes
- OLE Automation
- Application Hangs Up Computer During Opening
- Automatic email from Excel through Lotus.
- Excel Web Query Function
- Search across multiple sheets and subtotal.
- Exporting Excel output to pdf/rtf/doc format
- Sending Excel file as attachment to Lotus Notes mail
- Application.Inputbox Question
- Leap Year
- Formula from VBA to Excel worksheet
- Copying data ranges in a macro
- Shared Workbook: Conflicts
- two column combo box Excel 97
- Extract All worksheet names in workbook
- Comments autofit
- Remove Excel AddIn from AddIn List !! Help
- Re: Comments autofit
- How to Show a userform from XLA sub
- VSTO 2.0
- Variable-Length String causing error
- Call Excel from VC++ Win32 DLL
- Menu Editor /Windows Menu
- How to get screen size ?
- Execel sum up
- Excel Addin and Delegates in C#
- stupid textbox
- Possible? -- RAND()
- Repost: How to calc string's printable width?
- Type mismatch? string 2 a long??
- how to rename sht after TransferSpreadsheet method?
- Iterate through files in a folder on Hard Drive
- Help with my first macro please
- Problem with cells.Find within a loop
- Displaying worksheets
- current cell in user-defined function
- polygon.net web query help
- Split large sheet into several smaller sheets for emailing
- FindMethod-DateValues
- leap-year condition
- Importing Multiple lines of text in a single Excel Cel
- Simple (?) Formula Problem
- Most popular word
- how automaticly print excel sheet.
- Retrieving data from Oracle
- Catching an error
- (xlDown) not working properly!
- Add % sign to numbers
- Practice Files
- Excel 2000 drillthrough - How?
- How do I retrieve data from an Oracle db?
- (xlDown) not working properly!
- Excel thru Terminal Server
- Custom cell format
- Publish Macro
- exporting excel to text with : delmited
- free up memory by deleting variables
- Text manipulation
- Run a Word Macro from Excel
- Accessing combobox/listbox values
- Sizing Comments
- Formating cells to only accept ShortDate format
- Programmaticallly fixing references
- Error message after installing Office SR2
- Single Step Dialog Box
- J++ to J# upgrade of _IDTExtensibility2 Addin
- Macro that adds then deletes
- Save sheet as .TXT out of Workbook
- BackColor property code
- Hours spread uniformally between two dates
- ado
- Increaseing the number of aurguments in a function
- Evaluating a cell
- Changing cell color
- Section 508 accessibility and Excel
- jumping to a cell which matches user specified text
- Selecting columns
- retrieving table names from Excel and Access sources using ADO
- Finding and moving hypens from end to beginning of cell
- Excel Network chatroom - testers needed
- Bound column does not work after hiding form
- direct to certain cells using drop down list
- How to Use Financial Function "ACCRINT" in VBA
- extract data
- Function layout
- Excel Workbook Security
- Task Pane Doesn't Close
- Please need HELP - Need to add and INPUT BOX so that users need to enter a PASSWORD to use a workbook
- Hide rows?
- How to attach commandbars with VBA
- Changing cell format with VBA?
- Condition Statement
- I want a help Please
- Where do I find the listing of the differnt methods, properties etc used by VBA?
- A Pivot table issue
- multi-select drop down list
- Userform array/subsript range error
- Experts kindly help
- XLS file-format
- @ symbol
- Buttons in Toolbars
- OnChange - argh! How do I get this to work please?
- Auto-update of formula results
- emailing from excel
- C. F. Formulas Needed
- Dynamic Range Naming
- Workbook on intranet unexpected behaviour
- Complete Excel App? Advantages?
- Transfer of data from excel to access
- unable to set the OnAction Property of the Text Box
- ODBC Links in Excel XP
- deleting sheet: how to omit warning
- Excel - special sort
- MS Excel "path" and XP/NTFS folder naming
- security change possible in VBA?
- How To: Command Bar Face ID property
- Need Help in importing text file
- HELP: VBA help file
- Macros i XL 2003 versus 2000 - speed problems
- Illustrated list of Toolbar buttons
- Mail for the postings
- Object not defined
- Named arguments for built in dialogs
- HELP!! Populate text in single XL field, or bulk copy text into 1 field
- CHANGE PROTECTED CELL VIA MACRO
- size of a chart sheet
- combine an IF and SUM
- Can't call up floating macro toolbar-stop recording/relative ref.
- Macro Questions
- RefEdit doesn't work properly
- Excel Event Problem
- Printing
- Adding Toolbar at startup
- Last, First Name Swap
- Dr. Watson ordinal44 error
- editing control/form objects on a worksheet
- unprotecting workbook
- Microsoft word
- Lehman formula
- Identify if another user has spreadsheet open - in VBA
- Referencing a ComboBox control from a Workbook Object?
- Cond. Format Formulas
- Multi-column ListBox. Multiple bound columns???
- listbox1.additem syntax for multiple columns
- On change event
- Interrupting an add line
- Import txt file
- Deleting records from access using ADO in through Excel
- a few simple newbies questions
- FileSearch macro returning incorrect docs?
- Newbie help with cell reference
- J++ to J# upgrade of _IDTExtensibility2 Addin
- If Checked Box true???
- Dynamic Control Creation in VBA
- SendMail
- Sharing Excel File on Network - Saving
- Newbie question on cell reference 2
- General Text Search and Highlight
- how do I make a simple macro
- Trouble getting solver to load a model
- Help modifying code
- Inserting a shared list from code
- I can't quite get the syntax for printing to the manual feed tray
- Determine if there's data in embedded word document
- Selection.ShapeRange.IncrementLeft error
- Locking only certain cells
- Selection.ShapeRange.IncrementLeft error
- Referencing Cells in VB
- run a macro from a cell reference
- excel print dialog
- variant array containing cel adresses > convert to actual ranges-array
- Calling .Move() From Javascript
- How to do selection.subtotal in VBScript/ASP ?
- rearrange an array in a different order
- Set properties in an XLS file..
- Find range by interior color
- Re: Multi Column Combo Box
- For loop...
- "Disable Macros"
- Printing displayed sheets
- Object Library References
- Re: Multi Column Combo Box
- If..then..Lookup?
- deselecting a highlighted range after a VBA copy procedure
- How to find the type of Sheet in Excel.Workbook.sheets collection
- Help with calculation
- what object group does this reside in
- Making code accessible to many buttons
- Excel in IE - opening new window
- FileSearch for a TextorProperty with a wildcard
- Closing the Userform when macro is running
- trying to search excel from Outlook... NO Results
- How to assign directory for GetOpenFilename method
- Import from one excel worksheet into another
- Re: Subscript out of range error
- Excel 4 macro
- Deleting lines with no data
- Building Custom AutoComplete
- Object Library References
- Rollup of Data in Multiple Sheets (based on user input)
- cut & paste between sheets based on cell data
- dates on forms
- MOre excel 4 macro problems
- How does one link data? Sort different columns?
- Appending records from one table to another
- Excel VBA worksheet will not run different computer.
- Formatting for Numbers & Currency in textbox
- IF function with multiple string conditions (Excel 2000)
- How to verify specific Worksheets are present
- moving rows based on criteria
- xy scatter graph - add points to series
- building a text string while looping though a worksheet
- How can I make a sound alert using macro in Excel! (But not use speaker)
- Excel not visible in c#
- Hibernate using Excel macro
- Unix Directory/File Listing
- Add Text to Column Contents
- getopenfilename in access
- Counting number of grouped/outlined rows
- RefEdit
- Saving workbook from vba
- Problem with Pivot table reports
- Excel macro
- Icon
- Running worksheet function in VBA
- Get folders list
- Search/Replace in Comments in Excel
- Compare Ranges by Address
- Minimum Cell Value
- Exporting Excel Comments in to Access tables
- Access to Worksheet in AddIn.xla
- prevent recalculation of random data except in a "Calculate" macro
- From Cell to InputBox
- How do I change the datatype of a cell?
- Anyone know how to do an EXCEL Script - details inside
- force a line break in a comment
- how to run through a table an delete the empty cells?
- publishing html using excel - problem with files becoming corrupt
- HELP WITH FORMULA
- Formatting a header with VBA
- Change Input language
- Unknown Error Message
- Making code more efficient
- How to run subtotal function from ASP?
- Unusual question
- displaying entries once
- How to obtain multiple quantities from an Excel VB function?
- Years and Weeks
- Re: A 2 fold macro question. *(I need some MVP help on this one.)
- Tom Ogilvy:Object Error Still
- How To: Get the index value of the selected color
- Copy results and then remove formula
- delimited data in column
- Worksheet Protection - Help!
- Formating a Picture
- SQL Database
- Number of Lines in a Worksheet Function?
- Crash working with Excel 2000
- can you..
- Create text pop-up in VBA function
- Paste into textbox
- How to Exit Excel Automatically
- Re calculate
- Visual Basic macro to do something that is done trhough an Excel function
- Adding Data to Next Available Line
- Help on Excel VBA macro
- Has the Page Setup Leak been Fixed in the Newest Version of Excel?
- Identify link location
- Using vlookup in VBA
- Using Rows().Delete
- Loops
- Locate max value cell
- worksheet change event
- Opening text file in Excel
- current date formula ?
- How preserve the value of NOW() or TODAY()?
- AppActivate trouble...
- Excel Project
- Automatically copy select rows to different page?
- count how many characters in a cell?
- select only certain characters from a cell.
- What is VB_Invoke_Func attribute?
- Create master sheet RETAIN formats
- Auto invoke of a VBA Sub function
- Sub Run-time error
- Excel User Form problem
- Excel Form
- Automatically run VB code on workbook save event
- Can't find a macro
- "Split Unioned Ranges"
- Help Please!, Retrieving E-Mail
- SendKeys {HOME} not working
- Insert rows depending on entry in certain column
- Prompted to save changes after macro save - why?
- User Forms and Pivot Tables
- Excel hangs on Workbooks.Open Line
- Arrays
- Copy and Find
- Moving a range between sheets
- the file already exists - do you want to replace the existing file?
- Opening properties box
- Assign Active Cell Value
- AutoFilter
- Closing Workbook without Saving
- Help with Formula
- Opposite of CONCATENATE
- HOW-TO? Loop through cells in a column
- Extra rows with no data
- Tabels and calculation methods
- To sort data in VBA/excel by the method of the minimas
- Excel contents to Outlook email
- Summing with Macro
- open utf-8 csv in excel
- Task Scheduler
- Re: A 2 fold macro question. *(I need some MVP help on this one.)
- listbox scrolling with mouse
- different screen resolutions
- three types of comboboxes.
- Saving
- Selecting used part of a range
- Method 'Range' of object '_Global' failed
- How to change color of buttons if pressed?
- Calling a .Net Procedure from a Macro
- Memory problem
- Control or VBA programming a button
- VBA code that only runs when a worksheet is active
- A problem in VB
- Creating a Hide Macro
- Suggestions on setting filter while in a userform
- passing variables from an excel macro to a powerpoint macro
- Calling Sub(s) from ThisWorkbook
- Get file size
- Can a named range be protected???
- OpenText very slow
- Is there a "Non-Intersect" VBA method to remove a sub-range from a range?
- onTime loop running in the background
- Get rid of empty rows
- Cell formats
- Function Add-in troubleshooting-Vlookup
- Overflow in VBA, but value < limit
- macro to import data from mysql
- How to lock the path to a macro
- Web Query general question
- Magnify dropdown list
- Month
- How to make the Toolbar Invisible through VBA
- How to move to the next filtered row/col in VBA?
- Calendar question