- Show filename only rather than full path in cell
- OnTime Function
- Variable within activechart command
- Exit Excel Macro
- Excel VBA - userform problem. Help please.
- can I hide actively operating XL windows?
- Code Modification
- Could anyone offer some help for DAO in Excel?
- Re: Generic Directory Structure
- Increasing a cell value by 1
- Hide Toolbar with vb
- Changing fonts in input boxes
- Protection and AutoFilter
- Protectin Spreadsheets/userform
- Re: vbokcancel
- Re: vbokcancel
- Using Vlookup w/ Multiple Lookup values
- Re: vbokcancel
- List Files in a Folder/Subfolder
- Clean, Trim & Autofit will not work
- Force a Sort when closing a worksheet?
- Message box repeats itself
- Incrementing columns
- Re: vbokcancel
- Fixing ZIPCODES while converting data
- copy rows from multiple worksheets
- Running excel on a server
- Re: Last Modified Date
- Add a custom command to a toolbar
- How to combine data and delete row
- Start VBA upon opening
- Using DATE/TIME Picker
- copying rows between sheets
- Re: Displaying file sizes
- Alternative to document(50)
- Memory Management
- displaying column letter of active cell
- Disabling messages while running a macro...
- cond formating ?
- Conditional cell lock
- Threads?
- Pivot Tables and row level output
- This should be simple but... I am having problems....
- Anyone willing to help me over msn?
- Workbook reopens automatically
- If statement
- What type of event use to automatically add footer?
- finding ranges
- copy from multiple sheets
- Excel VBA x Interbase / Firebird
- Several subtotals
- how to include foreign characters within a VB code module
- Address Database using VB5 and Excel 7
- Can A Macro "Add" Content To A Cell Without Replacing The Original Content?
- Vertical Custom Menubar
- Bug wth Row Source and userform closing
- How make code execute for ANY active workbook?
- list box displaying single column
- Listing all compile errors at once
- COPY-PAST INTO E-MAIL
- Macro file organization
- Hyperlink Code will not work in XL2002
- Looks for other files on startup
- Can This Be Disabled?
- Comparing worksheets
- Application.ProductCode
- Excel Macro Help
- troubleshooting
- Macro will not work in NEW workbook
- sum with the same criteria
- Data Matching Question
- Running a macro from vba
- Cycle through checkboxes
- Select/hide rows according to interior colorindex
- Listbox ... Showing Selected
- Missing Numbers
- Adding a reference increases the file size...why?
- Display double quotes in text.
- Userforms
- Need Macro for Grouping the same Rows
- Code to run macros
- VBA - How to test if a text box is present on the sheet or not?
- Setting startup point for a for each statement
- readind data from word tables to excel
- Excel Loop from English to VBA
- Add Data Without opening workbook
- Running macro when spreadsheet is saved
- Shortcut menu doesn't work in .xlt
- Sorting in a defined order
- help with find method
- SUMIF ? or similar function needed
- Find a composed number out of an array ...
- Combine Unique Columns and sum up different values
- Starting addins when Excel is opened via Automation
- Transfering text in listbox to a cell
- field focus and protect method with excel 97
- Data from word tables to excel
- Store makro code in Excel?
- Automated Numbers for quote forms
- FlowCharting Software
- Auto Calculating Net Profit and YTD Profit - How?
- SUMIF?
- formula disappear!!!!
- User Form with a field showing current date / time
- Cell Values Entered by Macro
- Running a Fortran executable from VBA
- Excel 2000 speed issue
- Macro: display dates between start & end date
- Copy Chart to Clipboard
- Making an Answer
- Finding Text in specific cell
- Comparing and realigning rows
- Re: Print a file from Windows Explorer from VBA in Excel
- Text vs. Formula
- Need to Specify chart data
- Thousands of Hyperlinks!
- Object Libraries
- VBA - How to select autofilter range in an yet unnamed workbook?
- Round up to next whole number
- Unable to have VB print to specific cells
- Macro code can't find file
- Random Number
- FilterName:="GIF"
- detached / background process
- Page Setup Problems
- Date function
- protect a single module?
- Using VB to create range name
- solver macro
- Defined Order List
- Import Data from Closed Workbook
- sending email via vb in excel..
- Finding Row number of a checkbox
- Use filtered list as FileName with FileSearch?
- Countif Problem
- Public Variable staying in memory ...
- Cleaning My Data Form Import
- Printing off many areas within a worksheet
- Combobox
- using variables to define source data ranges
- Re: Trouble with creating add-in
- Code Modification
- Re: Trouble with creating add-in
- Tutorial 6
- Linking Multiple Excel Documents
- Code Modification??
- Suddenly, many #REF! to linked files
- Date Control
- Errors
- Reference A Named Formula in VB
- Re: Embedded Spreadsheet
- Extracting Data from Word Doc
- Fromula Copying
- VB Custom Chart Creation
- Adding borders to used range
- ADD LINES
- Replace text within an open file
- Attn: Alastair Pivot Table Pain!
- extra dialogs...
- Making a form post to different worksheets
- Record Macro
- Protect code in Add-In
- In VBA, how do I remove everything after a specific character?
- Excel/Word data collection
- Trying to divide Players into divisions
- How Can I embed a Form into a worksheet
- Embed Graphic onto custom command
- Vlookup and return values
- Excel search for help locks pc
- Comparing values in 2 different ranges
- fixed interval sampling
- Calculating Future Value
- Name Box
- Need formula to get the hyperlink out of a cell
- Excel 'bingo' count.
- Error when Solver Reference Enabled
- Copy a cell places x in another cell
- Forcing Data Entry in Certain Fields at Certain Times
- Reference to other workbook problem
- Sendkeys .. Traping Windows pop-up..Pls Help
- Last cell in spreadsheet
- Type Mismatch
- OnTime, TimveValue to repeat every 0.2 sec?
- I need a little more specific help.
- Excel 2000 VBA problem -- sorting values in subtotaled column
- Search and replace Macro help needed
- Max worksheet extent width?
- Database & updating?
- repost: explained better (I hope)
- Re: PLEASE HELP: Programming formulas in embedded spreadsheets
- Help Tweaking this Code
- Novell Groupwise .sendmail problem....
- Code modification
- controlling tab oders
- How to cause Excel to trigger a procedure without the user opening a workbook.
- Re: VBA To remove characters
- if statement comparison & copying a row
- Re: VBA To remove characters
- VBA To remove characters
- MS Office Xp Service Pack 3
- Download Outlook Attachments
- Close window macro
- Name Conflict Copying Worksheet
- Excel 2003/VBA book recommendation
- Getting Name Box data at run time.
- Searching Sheet Names
- Continuing when an Error occurs
- reopen a file
- Open external workbook, select sheet and column to insert
- Re: trapping errors?
- Is it possible to query a sheets data within excel?
- Win API library for VB
- How to add MS Excel 9.0 Object Library
- Trendline Linear Algorithm
- parsing script
- Using user input as the file name I want to save the worksheet as under the one direc
- Excel 2000 Blank Space
- values
- Opening Internet to a particular page
- How to refresh a sheet automaticaly (without pressing F9)
- Zoom
- Diable a macro after use
- GIF to email
- SQL Query
- Find a removable disk
- excel application closes ubruptly
- VB Help
- cut and past sub
- excel97
- Re: VBA To remove characters
- How do I use a combo box in a formula
- Sorting Large Numbers of Rows, Hide Blanks
- Check for newest *.txt file and import data
- Transfer data from sheey1 to sheet2
- Extracting information from a list
- extract value from cell...using formulas
- Close Excel from within Word
- SumIF error 1004
- VBA newbie: How to test the existence of a string in a vector?
- Multiple cell validation on one line
- Printing two worksheets onto one page (A3)
- 2 columns containing numbers need to id any the same
- How To Plot data on secondary value axis in excel chart from vb code
- Evaluating Names
- passing objects
- range objects
- Mutually Exclusive Checkboxes
- What is the path to folder wher I'm ?
- Can i hide the sheet through VBA coding
- How to create pop up toolbar
- Icons to be changed in my toolbar
- how i maintain stock ?
- Macro in Excel
- SQL Query in VBA
- Re-using the same userform
- Assigning a Number
- Reading SQLServer Data Base into Excel
- report from sheet
- Checkbox - clearing a cell
- Multi column listbox from combobox values
- Bar code
- Call Acess db Reports from Excel macro
- Find the difference in two CSV files
- dropdown list IN a cell?
- Deleting all matched values in a range
- Tool Bar portability
- Option Boxes
- Macors
- VBA: how do I change PivotItems(i).Visible tot True?
- Closing Excel
- TextFrame.Characters.Text problem with grouped shape in XP
- Code Modification
- Re: PLEASE HELP: Programming formulas in embedded spreadsheets
- Excel retriving reports from Access
- How to Call a function in another workbook?
- Add scroll bar using VBA
- PDF conversion, almost done
- Average a column minus highs and lows
- Re: title block on all pages?
- help with saveas
- Delete rows with #REF!
- Serious problem with "Select"
- Re: class question
- class question - code included in this post
- Tab Name Question
- Game security code needed
- Where to delete
- #ref macro
- excel automatically changing the 'format' of cells!!
- Start and close another application from Excel
- Pivot Table
- A= B + or - X amount? in VBA > tolerance??
- Disable Screen Redraws
- CommandBar Button parameters
- Identical code - 1 will not work
- Auto increment invoice number based on year and month
- Executing an older excel 4.0 macro
- EXCEL Error# 3464 Data Type Mismatch in Criteria Expression
- Web Query with a Twist
- Re: Open multiple files on Mac OS X
- Re: Can't get to next routine.
- Specify server in SendMail?
- Dynamically creating worksheet tabs based on unique values in a column
- active worksheet
- Re: Sort and CopyFromRecordset
- calculating worked hours from a schedule
- How to use a "with" with worksheets()
- Deleting every other row with VBA
- Error on Code
- create report in another sheet
- Deleting excel macro
- Finding end of range in Part of Worksheet
- Nested Function Limitations
- Create UserForm usign VBA
- Conversion from excel '97 to Excel 2002
- checking if date entered is older than 14 days
- Excel: Inserting cell values in a string
- Hide/Unhide columns with VBA
- cell address..
- Set Color Automatically
- copy matching cell's row to main
- Code modification
- Database Question
- Re: email
- David Braden's TLCoef() functions
- RE: Same code will not work in other ranges
- Copying & Combining text ranges
- send pictures with voting buttons (using CDO)
- Second database/Excel question
- Loop problem
- Set External Link without Opening Closed Excel File
- Message Box Response
- Single Array from Multiple Ranges
- Worksheet Change Problem
- Leading zero's in text join
- Cannot update PivotTable Source Data when copy from other workbook
- looping questions
- Kernel32, where are you?
- Resize chart
- Changing Regional Settings through VBA
- Macro to open workbook
- Finding transactions that equal an amount
- Excel compounded interest rate...
- Need help with simple VB codes
- Links to Null cells - do they have to cause #REF! ?
- Find not finding
- Code/Formula to Evaluate
- Clear Chart Contents
- Protected Sheet won't sort
- case sensitive
- Need to paste
- Printing filtered records from "copy picture"
- Backup specifications
- Forumla
- Selecting Data Ranges
- relative reference formlua
- Looping to new row and copying and renaming worksheets
- xlStockHLC
- TEXT IMPORT
- Pasting values in column next to range
- Excel VBA - Commercialise Investment Program
- Automatically sketch based on data entered?
- Call Up A Macro When Exiting A Cell
- How to create auto-incrementing number based on current date?
- Action when order# is seen on another sheet
- Copy changes value
- Trying to run SOLVER through macro
- Help with Do While :(
- move items in multi column listbox
- Open External workbook insert column problem - Stumped
- Visual basic "save as" in excel doc causes err 1004
- modifying code to save a spesific page&range
- form vb - error message -- validation
- Macro to transfer selected cells from one sheet to another.
- Custom buttons on toolbar
- Change the actual data
- Internet Password
- Opening protected
- Opening a webpage with VBA
- Question about MSCommonDialog object
- Type Mismatch
- Convert Excel 4 Macro Functions
- Disabling Tabs
- Phantom Macros?
- cannot save add-in changes
- Copying a File
- Moving items in Listbox
- Copy Contents Of A Cell To Another
- VB array forumla with date criteria...
- I bet this is tough one< EXCEL PROTECTION...
- Deleting broken references
- need to add textboxes to userform on the fly
- Pivot Table
- Use of SAPI Voice When Opening Workbooks
- About personal.xls and add-ins...?
- e-mailing problems
- Passing value from Hyperlink
- Pull Only Current Month's Data From Another Worksheet
- Screen resolution versus screen points(pitch)
- How to remove an Erronious file lock?
- converting pivot table data to summary data
- List box option
- Disabling ShortCutBars
- Referencing Ranges on other Sheets
- HELP!! I need to write a formula and don't know how!
- Importing data to variables
- How to hide a worksheet and set a password to protect someone else unhide it.
- delete text and move
- HELP PLEASE: Multipage with embedded spreadsheet
- Macro to Run When Certain Cells Change
- excel saves as text not as a number
- Need help with find and replace code
- changing the protection options
- Toggle xlSheetVeryHidden
- HELP! Charts collection not found - baffled and bewildered pls help
- Uninstall problem wit premium edition now replaced with Office 2003
- TreeView
- Function List
- changing x-axis in a chart
- Re:
- Two part ? With routine
- activex frame control on worksheet
- Combinations
- Recalculating a sheet
- Routine Problem
- Moving around a Web Page
- read the name of a saved file - put that value into a cell
- RE: Rob van Gelders code
- Network Hours
- Select a Printer Tray
- How to enter a value in a cell but display a different value in the same cell?
- How to keep the date format in VBA ?
- MID function - Only in reverse
- Data Validation
- Move drawing to cells
- Selecting a cell
- File Properties
- problem unhiding columns
- Help! My customized menu bar is gone.
- Using Default text with Inputboxes
- Formulas
- Printing the selected sheets
- Opening a PDF from an Excel User Form
- Addin?
- Noticed Form Controls not updating
- Play Blackjack in Excel
- Code modification
- Object references
- Determine Current Selection
- Making an array and searching for specific values
- cmdButton_Click()
- prob in date comparison in access
- Saving settings on UserForm
- Opening files in VB
- Clearing optionbuttons
- runtime 1004 error
- How can I open the third sheet from another file
- Setting End Of Sheet
- Detecting Changes to enable a save
- Deleting worksheets
- Determining invalid cells (data validation, vba)
- Hiding Columns before Saving
- old workbook seems to have today's date in E1 on sheet 1
- Using macro with hidden worksheet
- Updating column formula after a refresh
- getting a pivottable to automatically pick up new rows in the source?
- Re: URGENT: Problem in reading excel file in ASP :( - TRAILING SPACE problem
- Autosave
- maths problem i think
- HIDE EMPTIES
- VBA - How to define Page setup, Landscape orientation on a Userform
- adding new worksheets to a workbook
- Stopping running macro
- Strange macro behaviour
- Help with bad mail file
- summing columns when not hidden
- Export "selected cells" to a TXT file.
- Problem showing time
- External Data Link in Excel
- Size of Data Validation Dropdown Box
- Transposing data
- User-Defined Function Help/Variable definition
- Identifing values in a currency column
- Re: Pasting cells over 255 chars
- Run batch file from VBA
- Update MSGraph 2000 worksheet using Excel VBA
- Screen Updating.
- Amending List Validation Ref
- Using find with dates in VBA
- last ran macro
- Selecting a Cell
- inputbox
- Protecting a perticular range only
- Case Sensitive Issue?
- hiding/unhiding custom button
- Re: Filesize increasing
- Help with Delay function
- My last attempt
- List of Sheets
- Controlling free Excel reader with VB or VBA?
- Userforms
- Shape "handle" location
- Shape "handle" location
- NEWBIE: Looking for Function to Subract a letter?
- location of custom button
- Cell dropdown using another Excel worksheet
- List Box
- List Box
- Forgot Code for last post
- Conditional statement
- Re: URGENT: Problem in reading excel file in ASP :( - TRAILING SPACE problem
- Array formula question
- App_SheetSelectionChange
- Handle Unique Contraint During Buld Inserts
- Randomly Rearrange Records
- Handling message boxes in code
- Excel VBA - combining column information
- Delete rows where
- Test for opening of a workbook
- Attachingor Appending files to Excel
- Shared workbook under an addin
- moving the cell pointer after hitting enter
- How can I use wild cards when calling .xls files to open ?
- Pivottables - tailored grand totals
- VBA example not working
- Shift all cells over one column
- Searching for a text string across multiple workbooks
- Excel command-button lock up
- microsoft help
- excel and form
- Creating Ask type field in Excel
- Distributing macros by installing an Addin
- Zoom In and Zoom out
- Cell reference from TextBox
- Deleting rows using a variable
- Re: Row insert is inserting text from column A to eternity.....
- Accessing Active Printer Queue From VBA
- Re: Row insert is inserting text from column A to eternity.....
- Relative reference to worksheets?
- Searching from Bottom Up or a Find Last command?
- Move numeric over one cell
- Adding spaces to long text
- Running Macro when value in spreadsheet is true
- formatting a msgbox
- Assigning a number value to text
- Solver statusbar
- Updating Links
- Excel worksheet question
- Turn off autocalculate in VBA
- isempty function
- ??? dll file
- newbie: numberformat
- Stupid, stupid XP pivottable problem
- AUTO NUMBER
- text box entry format
- macro to open,sort & reprotect multiple sheet with passwords
- conditional msgbox
- Re: Error with Windows Class Property
- VBA inserts columns then doesn't continue to other steps
- CommandBarControl works in one WB but not another
- How to achieve "Call MyVarWithProcNameInIt"?
- Page reference
- Re: Simple Question: How do I change the format of a textbox
- Multiply Array by a constant
- open/close files
- Setting data from current cell to another sheet...
- Adding a new column with VBA
- a custommade face (icon) to a toolbar disappears
- Adding controls to sheet via VBA has unexpected results
- Record Keystrokes With Macro Recorder
- Combo Box w/Dependent Options
- Subtotalling in VBA
- paste HTML with date different in VBA from manual, format error
- Automation Error?
- function won't work help
- Open Workbook with P/W using VBA
- Word VBA Automation to Excel
- Profit Margin Formula
- Selecting the next column with a macro
- control if statement from check box
- LAst Row Number
- Adding a new column with VBA
- Help with Formula, please!
- simple question regarding formatting in a cell with a formula
- sheet event procedure
- combobox
- countif and rank
- alternative to embedding cell reference within DDE link
- Remove "Ghost" Programming From Previous Format
- linking to a cell...suggestion required
- Trapping the last row
- Open Workbook
- Insert rows and Fill Formulas Macro
- Starting Explorer from VBA
- activate module whenever excel starts!
- Add module on all existing excel files.
- How To Format a Cell as "[h]:mm" ????
- Reading with ADO from Access database over network
- ProgressBar in Excel
- Indrect?!
- Selection
- colouring pivotchart bars (using code)
- Userforms
- Convert String to cells
- Updating textbox with value in userform
- Does Excel recalculate everytime?
- Option Explicit help
- Using a listbox.
- accessing user defined functions in all workbooks
- Excel VBA - ignoring blanks and sorting data in lists
- formula
- Checking text & numbers in same cell
- String manipulation
- Help with VBA Vlookup
- Move a range of cells?
- Selecting a range based on cell references
- How to identify the position of a character in a string?
- compile error
- Excel Update
- How to error check EditBox?
- Printing Entire Workbook
- Inputbox and pass values to a formula in an another Workbook
- Help with code for add in
- Selecting/Printing a Named Range via VBA
- Linear Regression?
- Disabling a Button?
- Missing Worksheet
- Sharing Violation
- Vat Calculator
- Re: Options with in a frame
- Re: Options with in a frame
- Re: Options with in a frame
- Auto Open
- Textbox to take focus
- Re: Check to see if a program is open
- Re: Copy and Paste over and over
- SQL temp tables not working with ADO recordset
- Re: Options with in a frame
- Formula Code
- Disabling Save
- how do I pass values to sub's?
- Rs-232 in Excel
- Excel reporting - beta test invitation
- Re: Alpha characters in visual basic
- Re: Alpha characters in visual basic
- Re: Alpha characters in visual basic
- help button in messge box
- Problem inserting Word document
- Save file with variant name from an input box
- different versions of Excel
- Goto function
- Need Solution save as ASCII
- Criteria-Based Subtotals
- Date Problem from Text
- Crosstab to Database VBA
- date
- Still learning
- Dynamically Creating Folders
- find and replace
- Worksheet Change event
- Help with userforms in Excel 2000 (vba)
- newly added sheets and incrementing sheet 'numbers'
- Re: Figure out which shape called a subroutine
- Anyone Please Help!!!!!!!!!!!!!!!!!
- autofilter problem with date values
- Re: Figure out which shape called a subroutine
- Excel VBA: Widening column to fill page margins
- ASSOCIATE A PK WITH AN ITEM IN THE LISTBOX
- Checking for duplicates
- Compare input from ComboBox
- Fix InputBox - Returning mpty string
- Modify formulas thorugh the whole workbook
- Fix InputBox - Returning Empty String
- Macros in Shared Workbook
- Sample matching
- Saving code from templates
- opening an existing word doc from an Excel VBA macro
- removing ' from imported database
- Bold part of a string
- Macros in a Shared Workbook
- formulas
- Update links = no
- Distribute dynamically charts with linked data as stand-alone charts
- Finding the alphabet in the soup
- Code execution has been interrupted
- SQL incorporation with Excel
- Data Fields in Pivot Default to Sum Not Average
- Adapt code questions
- run-time error 1004
- trying to write ' " ' into an activeCell using VBA
- FOLLOW UP TO RUN TIME ERROR 1004
- More Linear Regression
- formula
- Function in VB - automatical usage
- Using Sumproduct in a subroutine
- Not to reinvent the wheel
- Overflow problem
- how to disable the Options Button in Commandbars (Excel 2003)
- UDFs and Circular References in XL2k
- VBA get Workbooks(index) number
- filling blank cells with value 0
- Re: Repackage my Excel workbook into software
- Move anything found in cells col a to col b
- VBA to clear all CheckBoxes?
- search, copy, paste macro
- Simple Excel VBA question: How do I sum a range of cells?
- Re: Repackage my Excel workbook into software
- cut/paste excel cells w/ ActiveX checkboxes to Word
- Copying a Range changes value (not good)
- Excel VBA - End Of Month Report
- Excel, Routing Slips, and VBA
- Button to open form
- Entry of Incomplete Dates
- Re: How to execute macros not saved in a workbook
- range problem with multiple use of subtotal function
- listbox sort
- Default Settings for Comment Box
- Trim function won't work in VBA
- Excel Formula or VBA???
- turning a big nested function into a udf
- Simple Question Regarding a Simple Workbook
- Copying and pasting items in a listbox on a user form to a worksheet
- Textbox on a worksheet
- I have absolutely no idea where to start
- VB to number worksheets with 1 or more than pages
- Quitting Sub from within an IF statement
- Problems with Workbook_BeforeSave (or Close)
- passwords
- 2004 Tax Workbook, has all values working but Net Pay, & expenses
- Objects and Worksheet_Calculate Event Procedure
- Change directory from VBA
- Objects, Scope, and Worksheet_Calculate Event Procedure
- Pivot Table Summaries
- Finding Column based on input, then first empty row
- Re: Copying macros with workbooks
- Re: Shortcut Key
- number description
- VBA Insert rows and fill formulas in worksheets
- having an inputbox more than once in a dialog
- Need some help
- VBA Macro - correlations in random number generation
- urgetn ..help
- RUNTIME ERROR '1004' --- Select method of worksheet class failed
- Passing a Workbook array
- How to establish current ONKEY status?
- Changing bg color when a certain number is entered
- Recalulation of functions
- getting the value from regedit(not address)
- a macro launch, get the quote number out of the excel cell, then auto save the sheet
- The Find Method