- overloading a function
- Excel Constant for Border All Around Cell
- Textbox margin overwritten by auto-margin
- class module
- Script vs Open_Event
- Multiselect listbox with check boxes
- How do I permanently delete a macro?
- Selecting a range offset from a cell
- Lookup?
- need to extract data from a pivot table using variables instead o.
- filter by month
- Problems entering Data validation Programatically
- Excel connecting to Teradata
- Auto check list box
- Cell properties dialog
- Autofilter Question
- changing active cell
- Convert to minutes and seconds
- Copying Formats vs Formatting Programatically
- Using a Cube to store Histogram information?
- Changing Cell Font and Color Issue,
- Can't get Workbook_Open event to work
- Access Time Calculation
- How can I recover from an unsuccessful Find operation?
- .Cells.SpecialCells(xlLastCell)
- Row and Column from Used Range property??
- Merge
- buttons on forms
- Auto Date range and printing.
- Is this possible...Filter list after user selects location
- Does anyone have a Template for a Bank Reconciliation or Cash Rec.
- Does anyone have a Template for a Bank Reconciliation or Cash Rec.
- Need help re Macro
- Textbox Query
- Open excel file, enter values, save & close
- Summing the last records of every month.
- .column
- how do i select different printer trays using macros
- Processor Can't Handle This Deletion Code -- Suggestions to Modify
- Sort Method more than 3 cols
- Determine If An Application is Already Running
- interrogating a workbook WITHOUT opening it from VBA
- Macro Help
- text align code XL2000
- macro to alter worksheet code
- QUERY ABOUT DATA REQUIRE
- Spacing
- Automation: Create Word file from Excel
- Removing code in 'This Workbook'
- How do I automate the deletion of a row containing today's date i.
- Copy From CD
- usedRange
- Macro
- Application.Max wierdness
- Random
- Copy from CD
- MACRO HELP REQUIRED PLEASE!
- Cannot create excel file from .Net in Office 2000
- Macro recording
- Unprotect Sheet - Removal of standard Message
- MACRO Assistance Required
- pain cell max and min
- Pivot Table based on SQL Server query
- X button on userforms
- textbox
- Wildcard - help I'm stuck
- Find Value <> 0
- Excel controlling Outlook
- opening excel through visual basic
- SpinButton Change Selection
- run code in other workbook
- import csv file
- How to make a Case Function.
- Refering to grouped ActiveX controls on Sheets
- I need to create a custom form in excel
- Shapes disappear from Excel 2000 to 2003?
- TextBox6.Text = Application.??????????(TextBox6.Text)
- modify the data in a report
- Close Current File Then Open New file
- type mismatch error
- Type mis-match error
- What's it take for Canadian Application?
- Reduce file size by removing comments from code?
- Hide Unapplicable Ranges of Entire Rows
- Arranging Windows
- Reducing file size (for archiving, not active files)
- Can't find object
- Where is documentation for the C# Office XP/2003 Primary Interop Assemblies???
- variable range automation
- Detect selected chart point
- newbie redim question
- Sorting Rows in VBA
- Cell Protection Within a Worksheet
- end subroutine
- References woes
- Outlook Tasks assigned from Excel?
- Open XML string in Excel using C#
- Find & Replace in Multi-Megabyte Strings
- link to Access DB
- IF Mytest.count>0 then VLOOKUP
- windows file shortcut using vb
- SumIf using two criteria
- Copy Different Name References to New Workbook
- Need some help with Exit Event
- Trendline Properties/Deletions in Excel VBA
- browserflags in registry breaking drop down box value
- Hiding Rows between two Finds
- Hiding Rows within a Subtotal
- Hiding Rows between Subtotal
- Adding hyperlink after the existing data in the cell
- Adding hyperlink after the existing data in the cell
- Pivot Table problems
- Add dropdown on an event.
- Get Displayed Value Of a Cell
- populate a different workbook
- center a message
- Array Test
- Floating Point Functions
- Userform Textbox - fundamental flaw
- date calc returning #name?
- Moving data to another spreadsheet...
- refer to a cell in another sheet
- Macro Help!
- list box
- diferrent Excel versions connection problem
- Printing all Visible sheets
- Copy cells down
- Linking MS dictionary as data into Excel
- avoiding select
- Macro programming in Excel
- Identifying the last number in a row.
- set range
- Macro to run if cell empty
- Count number of values
- ListBox2.AddItem ListBox1.Value becomes a String when being Integer?
- Help with Excel table pasted in Word?
- UserForm Question
- Exclamation message box opening Excel - Archive not found!
- Resolution change
- How do I write an Excel macro to open a file using the CommonDial.
- Searching dates
- Excel user-defined functions.
- Store Information but not in a Workbook
- error in getting system dates
- woking with date's
- Still Macro Warning w/o Macros ...
- Wildcards in Excel VBA - HELP
- Look up
- how to query an LDAP server?
- If within an If...
- Application.Match
- Using code to mimic a find and replace
- Need data
- F2....
- parameters not allowed in queries that can't be displayed graphica
- Import Dat from Oracle - pls help
- Align text in adjacent Controls
- Stop macro from saving changes
- on error goto trouble
- Print Dialog from VBA
- PAssing Values to Excel
- text formatting for msgbox strings?
- Run macro if value in cell changes
- vb problem
- quick cell fill/formatting
- Open book, check for macros, close book
- Combobox value does not change
- Uncheck Check Boxes when Workbook Loads
- Workbook sizing
- No file when Save As is executed
- worksheet saveas question
- Year to Date in Pivot Table
- last row in sorted list
- Update spreadsheet from Listbox
- Stop Link Update
- run a macro when file is open
- Pivot Table
- how to add bullet list of text items in cell
- Import data from Adobe Acrobat PDF Files
- Top 3 numbers in a list
- Locked Sheet - Error msg to display to Users
- Total a Variable Based on Another Variable Please
- Copy and paste special, values not working
- Late Binding issues when closing workbooks
- Import text file contents based on path
- 1-variable Data Table w/ dependency on MS Query fails to update correctly
- optionbutton
- Inventory a WorkBook
- input box upon opening workbook
- Drop-down menu in validation list too wide!?
- Drop-down menu in validation list too wide!?
- Why am I losing macros that I create and store in PERSONAL.XLS?
- Change event and calculate event
- insert new row & fill down
- creating dependent list boxes
- Replicating CTRL-click multiple row selection
- Code to mimic vlookup
- Multi Column ComboBox
- Sheet Information
- red point
- Search Macro Help
- Freeze cells from further calculation?
- Project is unviewable
- Sort by Variables
- Copy every nth row into a new worksheet
- listboxes
- HELP! cant edit query
- create named range in each sheet in workbook
- sort list more than 3 keys?
- ADO 2.7 & ADO 2.8 beforeprint
- all subtotals have summary except one
- Sorting after subtotal
- Search
- If Sheet exists, GOTHERE, else create it
- Find end of list - new problem
- Printing: Best Fit (1 Page Wide)
- Change Message on Protected Worksheet
- Statistical functions not tied to Application.WorksheetFunction
- Calculating a Grouped Weighted Average Rate
- Create RangeNames
- Refer to Worksheet Ranges in Code
- Excel Solver
- Match and Copy
- Macro Warning in File w/o Macros?
- ADO: Read Excel file that is in use (locked)
- Countif in multiple books
- Way to have VB code to filter on entries that have cell with today's date?
- Time question
- export data from MS Excel sheet to external database
- Curdir
- Removing commandbuttons on "save as"
- sumproduct in vba
- Excel problem with trailing spaces
- Zero Values in a Pie Chart
- Find last row
- I need a simple formula
- Find end of list
- Problem with Macro working in new workbooks that I open
- Inventory added sub needed
- Find empty cells
- Programming MS Query
- How do I print hyperlinked documents from a cell in excel
- How do I print a hyperlinked document from a cell in excel
- Stop Debugging !!
- Set worksheet range runtime error 1004
- how do I overcome this combobox 'bug'?
- how to calculate time in a payroll worksheet
- range picker / selector
- problem removing controls
- Run code remotely
- Formulas for creating a muti-unit 12 mo. bugdet using a 1 store mo
- Referencing Combobox with other cells in a different worksheet??
- Validation ComboBox Size or alternative....?
- Macro problem on, Yellowed line - previous line or next line.
- Redefining pivot table source
- Can I password protect VBA modules using a macro?
- EXPORTING data from spreadsheet to SQL SERVER DATABASE
- Inhibit Cut (allow Copy)
- Re: Sum in VBA
- Saveas where file already exists
- Opening a non excel file using vb
- unable to set the FormulaArray property of the Range class
- Protect workbook?
- SaveAs using cell value
- Saving Worksheets
- Macro to rotate data in cells
- debug error
- Link multiple worksheets in one workbook to another workbook and .
- File Attributes
- Data validation - comma
- copy formula using vba based on row count
- Best VBA newsgroup?
- create entries on a listbox on a form
- import XMLs
- import XMLs
- XMLs
- Excel Workbook Address in VBA
- Sheets Looping ignoring contraints
- Code to close workbook
- VBA or no VBA, that is the question
- Ending an External App from VBA
- Cumulative total
- Pivot Table Year to Date
- SQL.REQUEST Returns Single Cell
- Clipboard.GetText
- Worksheets not visible in Excel XP
- Execute code on server
- Rename Modules
- External Query questions
- UNDO in VBA code???
- Help with HLOOKUP Please
- global 'path' declaration
- Code libraries usable in all of Office?
- Copying Sheets
- Formatting Performance
- LockWindowUpdate
- userform-check data type
- What properties show on icon mouse-over?
- color hidden columns
- How to have different columnwidth for same coumn in several parts within one worksheet?
- Minimizing/Compressing VB Code in Excel File ...
- Excel changes celle when copying ?
- Modify sub to output to new sheet instead of via msg boxes
- How do I open an aplication and run a file in that aplication use.
- NormInv performace in Excel 2003
- Find & Replace question
- PrintPreview doesn't work
- Excel Web Query using a QueryTable via HTTPS??
- Can you freely write excel macros in C# yet?
- How to protect option button?
- xlAutoOpen and GetActiveObject
- array to access
- Opening ,copying, access query resultsfrom Excel
- Problems Converting 1-D Array to 2-D Array
- User Defined Function for Wind Chill
- i want a macro in execl to wait for an input from the user.
- Import a data using a command button
- Deleting element in Array
- Command buttons and code - help!!
- Object variable or With block variable not set?
- How do i allow users to edit a cell's contents, but prevent them from moving, cutting or deleting the cell?
- Copy ... Paste
- copy rows conditionally
- Conditional Format and VBA
- Pivot Table Field
- Duplicate Values on Multipage form
- Return to Current Sheet in On (sheet activate) event macro
- Can't put common dialog control on a worksheet
- Stop Copying at Specific Row
- Having problems with a circular reference and the #VALUE! error
- Sub
- Worksheet Change Event Problem
- Write Text File
- Forms Controls
- running code after pasting data
- negative numbers
- Offsetting losses against profits
- modeling offset of losses against profits
- Xls protection?
- #Value
- closing active windows without saving changes
- Comperison Data
- How do I get a Check Box to set a value in a cell when is checked.
- ControlTips not showing.
- I need a formula I can't find in help.
- Copy some information from sheet1 to sheet2
- Looping on Cells $x$y (continued)
- WorksheetsEnableCalculation
- Help Clear Function
- How can I get a negative time in Excel?
- Documentation of Excel Object Model and calling it from VB.NET
- Re: Program line when charting variances?
- Using a form to modify a list
- E-Mail Defaultdaten ergänzen
- Comparing two ranges and extracting non duplicate data
- Copy value problem... if "" then 0
- PLEASE I NEED YOUR HELP
- how do i set up a web excel worksheet to accept new data?
- Loop for a Complex Formula
- Save As Dialog
- Whats the Point of Protecting VB Projects?
- Export
- How do I ensure that all the data is on one page when printing in.
- hide / unhide columns
- countrysettings
- worksheet change event?
- VBA Efficiency Question
- Data List Visible Rows
- Help with adding to a formula
- Excel 2000 and 2003 VBA and Macros Incompatibility
- Excel 2000 v 2003 Macro & VBA Incompatibility
- Excel 2000 v 2003 Macro & VBA Incompatibities
- EntireColumn and merged cells
- Re: Runnig Excel without visible application
- CREATING LABELS FROM 1 RANGE OF DATA
- Copy from one workbook to another
- upload file name
- Query using Excel
- LockWindowUpdate
- Excel not working with .net (System.InvalidCastException: QueryInt
- Numbers 0000 will = 0 when converted to a csv file via macro
- how to select range when no. of rows depends from text place ??
- Error types
- Convert listing of events with dates to calendar - Pls help
- Schedule taskmanager via code?
- Please Help if You Can
- Vlookup and no results with the =left(a1,4) option :)
- Large Concatenate
- resetting custom buttons for macro
- Array Parameters as Variants Only
- Pivot Table Totals Not Working
- Code to fix: 'can't find project or library'
- Workbook Row Count Question
- Commas in VBE Data Validation List
- Re : Excel - Maximum of a Range Row-by-Row
- Or...Yet again!
- need help for copying among workbooks
- Macro / VB / Instert Date Question
- How To Call VBA Code from Excel 4 Macro
- GetOpenFileName method different in Excel xp/2003 from Excel 2000.
- New Function: ConcatenateIF
- Performance Impact: By Reference or By Value
- Macro filters on different length worksheets
- Add-in.
- Cell change event
- using vba in excel 2003
- Programmatically generate name of functition to call
- Macro keyboard shortcuts
- Time Gentlemen Please
- VBA Function that mimics the Access Not Matching Query
- Track changes
- autofill or copy & paste "till a value"
- Copy from one workbook to another
- Deleting Contents of Sheets
- Exchanging data between Linux and Excel
- Deleting Sheets
- Finding out whats Protected...
- Not enough memory?
- counting colored cells when merged
- Excel 2002 recalculation while executing VBA Procedure
- Excel 2002 With WINXP on a dual processor system
- Automation Error
- IS functions
- Open files in folder - skip if already open
- Custom button on custom toolbar wants to re-load "Personal.xls"
- Looping on Cells with $x$y
- Delete Rows Cut
- conditional formatting ... shade cell ... older than today
- Deleting Code in 'ThisWorkbook'
- End Of Month
- Excel 2002 Object Model
- macro on tool bar
- Delete a Sheet without dialog
- Relative cells in different sheets in same workbook
- Checking to See if Range Values Add up to 100
- fast and simple way to match up arrays
- Open JPG and determine pixel width in VB?
- Using Public to Pass Variable
- Copy a sheet and rename it
- formatting based on text
- Select specific Data from a cell
- Using 'Find' and 'FindNext' in vba
- How to deal with Find when nothing is found
- Hiding cell values for printing
- Select rows and copy to another sheet.
- Find Text and put total across from it
- cell address within formula
- Timer Alarm
- Save Workbook without VBA code
- Paste into a QueryTable
- 429 ActiveX can't create the object
- "Ready"
- Autmatically remove filters from all worksheets
- User Form Spin Button
- Looping through listbox controls
- Further Userform questions
- Range problems...
- Loop in Excel?
- DateValue Trouble
- Select column cells to the left/right of active selection - an example
- Re-defining Ranges in VBA
- Using Date in InputBox for criteria in code
- Excel file saved as hex values
- Copy to another sheet fails
- Problem with Shape Names containing punctuation
- Can never edit my projects, everything is always "read-only mode"
- If...and... - can never get the syntax correct!
- Date question
- Chart from VBA
- Logical String Evaluation
- Call Macro when Cell within Range Changes
- Ever heard?
- form problems
- On Time
- Range Values into userform
- Using ADO to INSERT Named Range Values into DB
- change font of certain cells in row(s) when ColorIndex of Column S changes
- average on qty
- User Form Questions
- Extract and copy Rows where value is Greater than 0 (zero)
- Deletion of rows where a value is satisfied for all the sheets
- How do I Hyperlink to a hidden sheet in a same workbook ?
- UserForm determine WinXP windows style
- PivotTable (blank) cells won't display NULL!
- How to use SUMPRODUCT in macro?
- Invalid Picture Error when user clicks on toolbar
- Custom button & VBA function
- HARALD STAFF - CONCAT_IF
- DDE link cache in DDEML library - is it so?
- Application.Min - how to ignore zero value?
- Text Sum
- Need Help - save sheet then hide when....
- VBA code help for item tracking.
- Extracting worksheet index
- Evaluating a Range of Empty Cells with VBA
- Pagebreaks problems - Urgent
- Find and Replace code in Sheet modules
- Visual Studio .Net C# and Excel
- Print Same Range on Multiple Sheets?
- Pick list on a sheet - multiple rows?
- Macro to delete space in front of date
- Automation Question
- Is it possible to share Excel workbook with a remote user??
- Multic Column List Box - Can I add vertical lines to separate colu
- sheet name referencing
- Whats the difference
- Userform Question - is this possible?
- Enable macros => HD/CPU issues- help! any ideas?
- Creating a "Smart" Autoshape
- Reference Libraries
- Autorecovery
- export excel data to a word template using a macro
- Find/Replace based on CF result
- workbook in IF statement
- Using worksheet_selectionchange to prevent null cells ???
- Consolidate data from several worksheets via pivot table
- RTD, how do you stop/start it from pulling in data?
- Textbox/Userform question
- Horizontal line on line chart
- search columns, set variable value
- loan amortization template
- Flash a MsgBox
- Question as to why this will not run?
- My entire Excel worksheet scrolls down when I hit the enter key. .
- Macro question
- MVP help
- VBA Compile Error on Deployment
- Adding a Menu Item into a sheet as a button
- Retrieving the SQL query of the external data range
- Excel crash closing ADO connection object
- programmatic generation of Enum To String functions
- Moved code from worksheet to module
- Last Cell
- UserForms:listbox display problems
- deleting cells in a range
- How do I make a change in time into a number I can use to calcula.
- Searching for "not blank"
- Extracting filename
- Open File Dialog Filter
- Batch Replace function for Large strings
- Importing .bas files
- Help: formula=auto copy from sheet1, A1 only if data in field E1 .
- Application.GetOpenFilename
- Setting "DisplayGridlines" Programmatically
- Select Case Statement does not evaluate
- Define Names / RefersToRange
- Setting the Sheet on Woorkbook Open
- Can't Change Font Colour
- Widening Names Dropdown (Bob)
- Copy & Paste visible cells only
- filtering data with a macro
- Re: CheckBox
- Cell Watermark
- Excel VBA - CopyFromRecordset (ADO) Problems with 107000 records
- Manipulating Data in a row
- Re: Check Box
- Write a code with another code
- Finding data
- Forensic Spreadsheet Review
- More than 24 hours
- ID 860 PLEASE HELP
- ID: 860 Please help!
- Error 1004 Method 'Add'of Object Sheets failed
- VBA Addin
- Two-dimensional Named Ranges
- Setting a variable using COUNTA
- Selecting worksheets into groups?
- option button-if else?
- autofit row code
- Dictionary - Add method parameters
- Require draggable visual object in Excel VBA
- Require draggable control within Excel
- VBA code to Autofill one cell to many rows below where row count will change
- merge two worksheets with different columns and data
- Can I use a defined integer in an OFFSET method?
- how do you generate a report every 5 mins automatically and delete
- Moving section of cells clears instead!?
- Printing formating/range problem
- UserForm_QueryClose questions
- Code Halt - prevents reset of the AutomationSecurity level
- Macro to Paste Special Row Heights
- modeling offset of losses against profits
- selection bug treeview
- Print preview?
- Excel2002 - use sql statements?
- Deleting rows from a combobox
- How Can I make excel go faster
- Email a Userform
- Macro for workbooks
- append two worksheets with excel macro
- Execute Events Based Upon Selected Cell
- value to range
- How do I pass an array to a listbox?
- Unprotecting VBE Project to Make Code Changes
- one very, very bad line of code? Trim and chr(10)
- excel: external data "data range properties" button dosent work
- Total Field Count
- Userform Scrollbar
- Range Cut and Paste
- How do I reference my current file in saveas function?
- Fixed sized printout XY-diagram
- populate multicolumn listbox?
- VLOOKUP formula not updating automatically
- automation server/add-in installation
- How to: User Form to assign a user defined range to a macro variab
- enable macro message not appearing
- Create way to change data in list from another page
- Set Print Area programatically
- byte order reversal in spreadsheet
- Control Panel
- How to Count String occurences
- sumif criteria
- Userforms
- Chart source data range
- Opening CSV file with 69000 + rows in Excel using VBA
- column
- How do you create formulas using the date on the computer?
- click event on listbox
- Deletion of cells by next blank cell command??
- Code to select 'Disable Macro' when opening an EXTERNAL FILE
- Open files in different folders
- Update header BeforePrint
- linking two workbooks with ODBC & the Excel Driver
- Import VBA Code in Excel-File ? (Export VBA Code to file)
- COUNTIF Multiple Criteria
- Sheet name problem
- copy destination values
- Useful Comment Concerning Memory Read/Write Errors
- Passing Back Color to Interior Color
- Comple Error Cannot Find Project or Library
- Save file -prompt
- VBA routine (101)
- Dictionary
- Array Function help
- How to Capture if Spreadsheet is open in IE and not Excel
- Linking a several workbooks and worksheets
- Import a printable gantt chart from MsProject to Excel
- Linking Excel to PowerPoint
- Send SQL to Access from Excel using ADO
- Clearing Interior Colours or all sheets
- Linking cells to several other workbooks and worksheets
- Linking cells to several other workbooks and worksheets
- Like Command Question
- Need help on an issue related with code management & data dimension
- Use of Format function in Excel marco
- Addins from Excel 95 won't work with Excel 2003
- Disable warning on macros
- getpath in a template
- Version difference when opening text files?
- QueryInterface for interface Excel._Application failed.
- Macro
- Excel8.h
- Create a macro to launch notepad while in Excel.
- Autonumber Newbie Assistance... Please
- Conditional formatting and weekdays
- Prioritising on dates
- How do I select a range to print if I have different numbers of ro
- Help with Count Please
- compare data evolution
- MACROS
- Range and SUM of 3 cells
- How can i change the text color in a cell automaticly if i write.
- adding a module to several different workbooks
- Append a column with the text "Remarks"
- Array & variable
- can i reverse the data of cells?
- Trouble increasing the array number and capacity?
- Macro to change Macro code?
- auto fit row heigth
- using worksheet name to find cell in table of contents.
- Excel Macro's use on several tabs?
- time till finished
- Userform Question
- capture WEEKNUM & place in page setup
- allow user to change workbook while in Msgbox or InputBox
- worksheet referencing
- Object required?
- break links
- Re: change folder
- screen flicker
- compare values in 2 ranges
- unable to set hidden property
- Finding Cell Interior Colour of First Cell in Column
- If Then statement in a userform sub
- dynamic named range
- Clearing Conditional Formatting
- Inconsistent formula problem Excel 2002?
- Range and Array question
- Dynamic folder??
- Select All Sheets and clear Interior Cell colours
- Activate Excel after opening PowerPoint from VBA Excel
- Moving in the worksheet during an evaluating function
- Alternate syntax...
- delay msgbox?
- What is the fastest way to bulk load data into Excel?
- Need help matching Numbers
- Macro to insert extra rows in a table
- Is it a way to schedule an excel spreadsheet to update automatical
- help writing a special 'COUNTIF'
- How to use Macro throughout Department
- Excel97 VBA controls don't load in Excel2003
- Get path of open workbook
- How to sort a worksheet programmatically
- Data Validation - Dynamic
- Need exit Sub modification
- Function Delcarations
- I think I'm missing something very simple
- button display
- single button on a custom toolbar
- VBA equivalent of VLookup on an array
- user input and concatenate
- customizing chart column color formats in code
- customizing chart column color formats in code
- range and sum?
- Subracting times and dates
- permissions needed for excel programming on asp web page
- How do I sort numbers based on last two digits?
- Error opening file
- Turn off printing status dialog with Excel automation
- New record in table in Access from VBA in Excel
- macro with a macro
- Copy an array into an ADO recordset?
- VBA Excel - Power Point
- Automate Finding Values/Copy to Different Sheet
- Call Names
- Sum IF
- Remove/disable event macros in SavedAs wkbk?
- Button on Userform calling GetOpenFilename
- its coach again......
- Remove the last letter from a string!
- Sheets - Limited acces
- enable macros accross the network
- UserDefined Functions
- Font/CellInteriorColour
- Copy, Paste then delete
- vb help
- Find Protected Cells
- Working with Hidden worksheets
- Suspend macro while others are running
- Open HTML as Text
- Worksheet_Change on Excel 97
- Find
- To Tom Ogilvy
- hiding worksheets
- Change Macro?
- Prevent loading Add-in ...
- Calling EXE After Calculation Complete
- Button colour
- excel functions in macros
- DDE real time and time dispay conflict