- Lists within Combo Boxes
- Add up, subtotals then totals
- Auto Open
- Updating Custom VBA Functions
- Undo Macro
- Adding text to the body of an e-mail
- Open Folder from inputbox
- Re: Outlook attachment
- if statement is true, copy data to another location
- Number precision problem
- Importing Checkbox Values
- Using dates in macros
- Re: zero'n out table values
- Command Button run-time error
- Toolbar sub Menus
- VBA instead of lookupformula
- Empty ThisWorkbook module, but Macro warning problem
- Help Please
- Best way to protect sheets and document.
- Workbook Before_Close question
- Help Required With Snake Column
- = positioning
- Additional criteria for a countif statement
- Adding space to VBA code
- Re: File already exists
- Logging on to network drives automatically.
- Identifying Multiple Selected Worksheets
- Form help
- Protecting Formulas
- looping texboxes - possible or impossible?
- Removing Leading Zeros from a String
- Create folder with a macro
- Help With Counting
- Excel Form Issues...again :)
- Problem Tracker
- "Are you sure" Prompt
- Pattern Matching with cells function
- help with user definded function.
- Set Validation list to show top item
- 'Save As' function / macro
- Challenge...Excel Chart to Power Point
- Am I doing something wrong here?
- Run Time error 1004 Paste Method of Worksheet Class Failed
- Array transfer - 1 dimension v. 2 dimension
- List named range per sheet in workbook
- Need Macro to Print Selected Wkshts
- common dialog control... list vs. detail display
- worksheet_calculate **help**
- opening a form from a combobox selection
- Excel startup macros - visibility of...
- Printing Multiple Pages
- VBA range from cell value
- Filtering multiple worksheets
- belblanco i posted a solution
- Export Data from db to an excel file.
- Execute Excel Macro using Java
- Web Query - UserID/Password Protected Textbox
- Adding 3rd shift data when missing
- Paths when working with macros
- Protect and Lock Problem SOLVED!!
- Return to xls app's MainMenu when help file is closed
- Problems creating a chart with VBA
- Pivot Chart Data from external data source
- How? - Error message for turning off autofilter with code
- Single quote in a textbox disappear when put in cell?
- end Macro after cancelling open dialog
- Checkin into SPS prompts no matter what...
- How do I know from C# code if sheet is protected ?
- transposing and calculating
- Inserting A Row Where Data Changes
- deleting code by macro
- Code crashes when ComboB = empty
- Convert Vlookup Formula to Macro
- Re: deleting code by macro
- Changing individual chars within a cell
- what do You say? :)
- help needed with msgbox
- Code for Input Box
- user defined functions
- LATE BINDING using Set WordApplication = CreateObject(strApp)
- help with variable
- VBA: "Volatile" use of concatenated worksheetfunction expression
- Ok now im stuck
- How do you search values and display them in lables/text boxes
- VBA Referencing a Named Cell Range in another Workbook
- Sum partucular cells by colour of sheet
- Copy Values to Below last Populated Cell Q
- Controlling Word from Excel
- How to hide a Range of Columns?
- How to hide a Range of Columns?
- Exclude a column from a table calculation
- Entering a Excel formula in a Cell through VBA?
- Manual / Automatic Calculation
- MultiSheet macro, to sum based on condition
- Adding a simple linear equation
- How to use VBA write formula
- % variance
- Lines in forms
- Displaying data on a different worksheet.
- multiple criteria in a countif
- Expense report problem.
- Spreadsheet Control on User Form
- VBA Codes
- Printing User Forms
- help to open pwd Excel from Access
- Web page link
- Duplicate headings in pivot table
- arrays of objects
- 2147217900 undefined function
- Rounding
- Userform show problem...
- Copying cell contents between worksheets
- Date/time code, both, accesible by hotkey?
- Trim Function - Error Library Not Found
- Removing all code from a Project
- Re: Blinking Label
- protecting vba code and unprotecting using a vba macro
- Excel vba query - data integrity
- How do I open a program(CADD) with VBA
- Re: arrays on forms in Excel
- record filter
- Excel VBA moving embedded command buttons
- Remove border line of a few cells
- Excel VBA moving embedded command buttons
- Get Open File Name
- VBA code to send range automatically via email
- Determining the size of a range.
- Re: Blinking Label
- Re: Object arrays on forms
- Re: arrays on forms in Excel
- Two cells whose contents look alike but aren't
- Multiple ranges to Auto Filter
- Summation
- File Loading Problems
- Copying data from many files
- Conditional Formatting and programming???
- Open webpage
- Program won't run when uploaded to intranet site.
- How to Filter Date?
- connecting to a WSDL from with VBA
- Change notice
- Get Open File Name
- Opening multiple text files
- Calculating # of busn days, not just calendar days, between 2 dates?
- Variable in AutoFilter criteria
- Deleting a row when cell's value doesn't match a criteria ?
- FileCopy creates two files
- collaboration using excel ???
- Re: How do use VBA to avoid reverting to my default properties for a l
- Macro for copying named range to any sheet
- simple code problem
- checking Excel version number
- Re: Last Hope -HELP!!
- Setting the formula property of a textbox
- Re: Last Hope -HELP!!
- Width Property missing from Listview (mscomctl.dll) in VB6
- Does anyone know how to programmatically disable Application.xlcut
- object classes
- Web style layout
- Activating VB form by changing cells
- Data Entry in a cell still in progress - how to detect and correct
- Best Way to Plot Graphs Clearly?
- Pivot Tables
- excel 2000 and c# .net
- Appending new data to existing data in a spreadsheet
- RE: Bold in Listbox
- Excel - VBA Run Multiple Macros Upon Opening A File
- Printing non contiguous blocks
- Solver won't keep the solution.
- vb hide the excel view
- Userforms: combobox.value type
- Excel 2003
- Non printing rows and auto height rows.
- Auto-Insert & Delete Comments
- Insert Date Comment
- clear cell
- Re: open and activate workbook?
- Re: Time formatting
- Re: Time formatting
- let and get in class module
- Auto FIlter
- multiple VLOOKUP
- Re: ListBox - Row Source problem
- Need help with inserting hyperlink into worksheet from a form
- Folder and filenames?
- Delete range
- GoTo Worksheet based on which button clicked
- How To Trap Cell Value Change Event so determine XL calc sequence?
- Break/disable a macro when opening a workbook
- How to do an Access Database Query in Excel
- Repost: % Variance
- Data files are corrupt after saving from VBA - Excel 2000
- Copy format without copy & paste
- Retrieving Default Chart Type?
- Problem with .Calculate
- COM Automation Menubar disappear
- Adressing
- Unwanted freezed screen cause by screenupdate = false
- Autofill from non constant cells
- combo box macro runs when using "save as"
- vba and orgchart shapes
- Excel VBA TextBox problem
- XL Calc Sequence - To Charles and ROb
- Column Heads?
- Excel 97 vs Excel 2002 (XP) Notification Problem with Exce > 97 (2
- Excel iDispatch problem
- Linking a Movie File to Excel
- How to detect optionbutton being clicked?
- Return value from first row
- A wacky problem - controls move on the screen after printing
- Opening text file in excel to maintain as "text"
- Activating a Userform in VB when changing Cells in Excel
- Custom Properties
- Select First Active Cell if the cell is in a pivot table
- Macro to Copy Selection to new Sheets
- Open ODBC in Excel
- Populating a range
- Format
- Programitically Transpose Data and Parse it
- HTML Objects
- Application.CommmandBars.Add performance problem
- Renaming modules
- Delete all Rows in a Variable Range
- Vital: Protecting sheets so macros/buttons still work?
- Counting rows and columns (newbie help pls)
- Adding cells
- Outlook - Different Versions
- Selection of Rows
- Macro Help to Copy to Last Cell
- Print Validated Only Macro
- Macros saving files.
- Re: Passing Macros Between Workbooks
- KeyPress Events
- Filling a ComboBox?
- Spreadsheet query
- Number of workbooks open
- Exporting to Excel and Apostrophies
- RE: Loop never ends
- Creating a ratings list in Excel
- Re: Solver Help I think
- Undo functionality w/ VBA?
- Remove code from all modules closes Excel
- Borders around cells
- Excel & Access
- VBA - Forms Exit Errors
- Userform disappears when you try to initialize from a command button
- Macro in template opens last saved document
- Re: Loop never ends
- Re: Loop never ends
- Override/Bypass login for exteranl database
- Help with Chip Pearson's Code for Deleting Blank Rows
- Data Consolidation from many Workbooks to One Workbook
- vba code to block review toolbar
- Size and location of an embedded chart
- PageSetup calls are slow
- Creatiing various "what/if" scenarios
- Form Option Buttons and Combo Boxes in VBA
- Automating Word from Excel
- Find Matching Data in different columns of different worksheets
- good com excel add-in books
- Help : Macro for capturing current system time
- how to remove command bar button
- accessing constants like msoBarTypeMenuBar
- excel VBA set array controls
- Dynamic 2-Dim Array
- Add/Delete Worksheets and Reset Numbering
- Track Changes
- renaming array of controls
- Macro to backup?
- Survey Problem
- Function to Place Value in Specified Cell
- modification to suit Excel 2000
- how does excel store new line and line feed characters?
- Counting columns, adding totals
- Copy & Paste
- VBA Question
- SendKeys
- MSForms.ComboBox
- Range probelm in VB6
- HELP: Link all values in a workbook under same folder on one sheet
- Email Hyperlinks to workbooks!
- Trouble with editing data from a user form
- IF, Then formuals
- deleting wrong range!
- counting rows and columns
- Cycling through predefined worksheets
- Filtering Problem
- Excel VBA - Range.Replace within workbook over several sheets problem
- newbie
- Adding references automatically
- move around cells
- essai
- Preventing copies
- consolidate data
- Office Web Component Spreadsheet: C#
- Re: Loop never ends
- Sorting dates in a combobox
- Problems closing a workbook with VBA
- Solver Help I think
- Cannot seem to Cancel EXCEL App Right Click Event using C#
- How to do this:
- Problem implementing connection point sink
- currentuser name
- CurrentUser Name
- CurrentUser Name
- CurrentUser Name
- Pointing custom toolbar entries to correct macro path on copied workbooks
- scroll barr up & down
- Calculate no. of years for Capital Expenditure
- font color change
- confirmation and close
- Re: Selecting Previously Active Cell
- looping every third row
- quickest way to remove all duplicates?
- Excel macro & MS XP OS trouble
- VLOOKUP problem
- Using Filtered Data for ComboBox
- Populating a Range by Code
- changing the constants in the find function
- get data from closed workbooks!
- Sorting by more than 3 Fields in VBA
- Updating
- Re: Print Macro that will Print Entire worksheet except....
- Help please with UserForm controls
- What cell am I in?
- RE: Problem implementing connection point sink
- Re: Treeview in excel
- Use of OR
- Auto Number Formats
- Sub Total
- Sort Method question
- Loop 20 columns Help!
- Worksheet_Change Recursion ARGHH!
- Comment Boxes
- Web Query with looping variables in the URL
- Re: Paste Special
- Controlling a cell in a worksheet
- Combobox -> to specific row?
- Re: Paste Special
- Transpose Rows to a single a Column one below other
- How do I run a Macro, but not watch it run?
- RE: Treeview in excel
- question
- VB Code to size the comment box
- Chart SeriesCollection. Problem changing from Excel 2000 to 2002
- discontiguous ranges in charts
- details of a pivottable always in one sheet
- Leo Heuser format cleanup code, and a question
- Time Delay
- How find if target is object in Worksheet_Change (ByVal Target As.. ?)
- VBS Control spontaneously relocates
- Delete Add-In
- ClearContents in event proc raises error
- Remove Data validation Input messages
- HELP : ComboBox (Forms), Activex or What ?
- macro to copy paste non empty data
- Advantage of MapEdit
- Automatically answering no to save request
- Could someone help me to do that please ?
- Large File 56M
- setting a range variable equal to the value of a string variable
- Hiding Rows Without Using VBA
- Concurrent users to a worksheet database?
- Using Worksheet Codename to Determine Worksheet Existence
- converting times
- call a procedure using current inputs
- Loop thru All Files in a Folder
- Chart in a userform Option 1
- Not unhiding rows when pointing to cell to complete formula entry
- Change events and linked cells
- Need Applescript for Converting Upper/Lower Case
- Chart in Userform Option 2
- Textbox with currency format
- Range deletion
- AVG Formula
- how to copy values to another sheet
- User informatiion
- Fill MT cells in a range
- Net Send command trough VBA
- Excel VBA - Cells Counting Problem
- VBA Calculation on "only" Filtered Visible Cells
- Problems with j-walk data form
- Hello, I download historic data from yahoo.
- XML & XSL for two worksheet
- Active Directory Export
- VB code is not working like it should
- sorting with a blank column
- Userform Reset After Scrolling
- Occasionally losing the scroll bar function...weird
- Auto Delete rows
- Dependent list in Combo-Box
- Opening PDFs from VBA??
- tks for help!!!
- delete comment
- After Filter - Move to first cell
- Automatic makros in templates Excel 2003
- Automatic Calculation Options ?!?
- Test for Worksheet Exists
- Find across several sheets and put results in a message box
- The Biff8 and Ole2 formats
- row selection and cut + copy
- Programming a Hyperlink to PowerPoint
- Changing the 3D-View in powerpoint using vba
- A small project
- Application.Quit still wants to save
- Sendmail: Problem when used after a Userform
- Problems with LN in VBA
- Slow calculation
- Delete certain rows
- deleting rows that are not equal to a value entered from an input box, Please Help Me
- Problem with message box return value
- Excel VBA Macro
- Pivot Table Help with Column Headings
- Setting a range with the last used cell?
- =Sum (Auto Filter)
- Automatic saving
- Excel Charts - Toggle Series On/Off
- Deleting duplicate Rows AND the original
- Excel - FTP - XP problem
- Impossible Date Formatting Requested?
- Re: Workbook_Open & Macro
- Re: Make a cell in excel an object in VB
- RE: Problem implementing connection point sink
- Help with Mr Doug Glancy Code - Snake Columns
- Accesing vba project from wb that has vba project password protected
- sum of hours
- Unable to record (macro)
- Re: Popup calendar
- Searching for zero value within a selected range
- Excel custom toolbar / DSOFramer
- Re: Changing characters
- Re: Changing characters
- vba select same cell across all worksheets
- Re: Logical test
- display edit | fill series dialog box
- RE: hide unused data
- Count new occurances and not repeats
- Save compared results to new work book
- Merge cells, Wraptext & Protect
- Pivot Table: Show columns with no data
- chr(160)
- Counting columns, adding totals #2
- Summing every third cell
- is there a way....
- ComboBox
- Help finding Row ID of Row where value in cell matches a value
- User Form activated by a macro
- Help with find and replace routine
- Simple database w/ vba excel
- Sorry for the attachment. new and just trying to help. It will not happen again.
- Saving Excel WorkBook as WebPage Thru VBScript..
- Function to resize an array
- macro triggered by a change to a cell
- can someone help me with this problems please?
- Data validation input message
- Command Button font size increases when clicked
- Running Windows-Excel macros on Macintosh
- Condensing Data onto a New Worksheet
- Merge Cell Question
- Comparing and deleting duplicate cells
- Distributing All Days Across Months by CPearson
- Distributing All Days Across Months by Chip Pearson
- Array formula range size
- Calling Rob van Gelder - Help needed with Vlookup Macro again
- I need to Sum multiple columns by referencing one formula
- Highlight Check box
- ActiveX Control Properties
- Macro error 1004
- Insert Code Problem
- Macro question
- Conditional Formatting Issue
- Strip date from string and transfer datetext to number
- error handling
- print minus value in red
- Reference range in formula problem
- Macro for Confirming Delete
- Combo Box Drop Down Area
- How to find the last row and column
- Re: VBA to check if there is a data series in a chart?
- 1004 error when selecting a range
- VBA error 1004 "Select method of Range class failed"
- Displaying multiline Text into Excel Cell through Interop
- Error 1004 when selecting a range
- Formating a Time Calculation Result
- Worksheet Tab Click
- DataSeries Method
- Time Calculation
- Trim or Len help (I think)
- Need some syntax help, please
- Outlook from Excel
- Anyone in atlanta area that can fix up existing excel macros
- Dim... As ...
- Complex Reference Problem
- hiding macros
- printpreview freezing
- playing sounds from cell value
- Tools | References - information about references
- Writing a DLL using Visual Studio 6 to return cell address!
- Open excel in safe mode?
- Formula
- Possible array formula?
- Search and Delete
- Prevent Duplicates
- solving a matrix in Excel
- Code for deleting entire row
- VBA Performace for Huge size (50MB) Workbooks
- Save as PDF Using VBA - Excel 2004 Mac
- ActiveX Control (TextBox) question
- Memory problems in Excel
- Opening a Form from send menu?
- Summary problem
- Combobox list
- 2 conditions in Worksheet_Change event
- UsedRange
- need help understanding syntax for adding a page to multipage
- returning number of subscripts? MyVar(x)
- Macro to update all worksheets in workbook
- Not sure what to name this subject
- Format question
- selected numbers to disappear
- real time sharing in excel
- Another code for deleting row
- Sending text into the cell below
- Further ActiveX Control (TextBox) questions
- Start Excel from send menu
- moveing values with macros
- Lookups
- Copy a range from different worksheets and place in another worsheet
- using a macro for a fill
- Counting columns, adding totals #2
- Retrieve item names in ListBox
- Problems about the path of the Add-in file(xla)
- Formating imported data
- Excel File Creations thru VB
- Chart series (not starting at first year)
- Cancelling AutoFilter in a macro
- Macro for worksheet protection
- User message
- variable Question
- Excel VBA - changing variables during a loop
- change cell value, but keep formula
- use Vlookup for sum all found value?
- subtotalling using vba
- selecting used area
- Copying an Entire row using an IF Statement
- use of "formula"
- sum
- Automating PowerPoint
- Userform conditional fields
- windows for experts
- How to programmatically remove an AddIn (xla)
- Activeworkbook.range ---> Not supported by VBScript?
- VBA code problem
- Viewing help for user defined functions
- DDE excel and VC:Urgent
- RE: Changing characters
- Header Font Color
- VBA Frequency FormulaArray Syntax
- preview chart problem!
- Hide Combobox
- Copying an Entire row using an IF Statement
- Inserting rows syntax + row #'ing code in protected sheet?
- .visible property causing an error in Excel 97
- Extracting Information From Excel To Outlook Keeping Formatting
- Close an Internet Explorer browser window
- Determine exctent of selected range
- Macro - Doesn't work in dedicate module
- Excel VBA - using yearfrac function in VBA
- Word Picture Object question
- Thanks renegan
- Protecting a book protects too much?!
- Workbook_BeforeClose
- Excel crashes when copying worksheets
- Random Sort (Can anybody Handle it)
- Quick help - SQL statement in Excel Macro...
- parsing cell format correctly
- Determine the last column of data
- repost: connect two rows of data
- Macro to find blank cell
- pivot tables from ASP
- "Radio Bottons"
- Copy cells from xls file opened in browser
- Changing a row colour automatically based on a cell input.
- Hide rows
- How to use macro to dynamically add the VBA code and data together
- Printing Footer
- Formatting times
- Floating Toolbar
- How to find out the size of a variable-size array ?
- Importing Text file from a server
- A Macro to change macros? VBA problem
- timestamp
- Macro to delete columns and set print area
- COM server timeout
- Find and Highlight
- Import Makro
- MSiInstaller error, when opening excel with Web app
- highlight current day in the sheet
- Excel VBA - Cells Counting using VBA codes and displaying results in msg box
- hiding toolbars
- How do I solve this?
- How to Select a Row in VB Macro
- E-mailing through Outlook via Excel VB
- File systems
- Profiling Excel
- Cumulative Year to Date Chart
- Calling Excel Macro From Vc++ via DDE
- "OnCancel" syntax?
- VB activates unwanted function
- Read variables from AutoCAD
- VBA PROBLEM - Running Macros!
- Function to extract values
- Excel VBA - Newbie: Auto deleting cell value
- Draw border above specific text string
- Drill-Down Pivot Macro
- FTP From Excel
- Macro to create pivot table/ chart
- "Copy Method of worksheet class failed"
- the best candidate gets its first choice
- Remove multiple duplicate cells
- Countif
- I need "On Error" help
- Startup
- Re: Print Single Statement Help PLEASE!
- Prefix macro
- Command Button Question
- conditional page set-up
- Excel via intranet Display Alerts problem
- Array Formula in VBA
- Returning the correct value from a pricing grid
- Counting specified words in a column - macro if possible
- count value in column and VBA
- Sync scrolling on two textboxes
- RE: Detecting Row Deletion
- Windows 2003 Hosting
- Re: Detecting Row Deletion
- formula calculation when cells are changed
- Dynamic Chart Range and Chart Update
- Excel Formulas to Clear/Match/Filter Entries
- Editable Combobox?
- How to thread
- clipboard forgets on call back
- Sorting 2 Linked Arrays [Retry]
- Generic Plot of a Bollywood Musical
- Matching Values to Zero
- Enable References
- Column and row references of range
- Workbook Open Event
- Excel formula
- Solution to Mouse Wheel Won't Scroll in Visual Basic Editor
- Accessing MS Project from Excel
- Saving a file from a command button with user input
- Updating Values (don't want to be prompted)
- preventing input of illegal characters in an inputbox
- Specifying position of new Worksheets via C or VBA
- Excel Programming Help
- Macro that changes Drop Down Box
- Upload/download a file
- conditional printing at top of page
- custom command bar question
- Suppress add-in confirmation message
- Limiting the scope of On Error
- Subtraction formula
- hide
- RE: Conditional Formatting Help Needed...
- Insert Character - Built-In Excel Commands
- Retrieve Macro description
- Textboxes
- Shape names
- Refreshing a custom Function
- Disabling Save Pop-Up
- Deleting Row
- Embedding Command Buttons in a Text box or List box
- VBA Setting .Value to a date does not respect local system setting
- Import and Rename Files
- Disabling/enabling events with a button created by code??
- Input Boxes & getting tied up in knots with strings!
- Print sequence sheets
- ListBox Headings - customized!
- Getting started programming a UDF.
- Copy sheets from A to B without reference
- Delete Row At Excel 97
- Excel equivalent of 'Keep lines together'
- concatenating cell names?
- VBA help on one of Jon Peltier's Charting
- Macro crashing on different computer
- sorry this is just a test if i can post
- Biff8 format documentation
- Call VBA Gurus - Help to Optimise two small UDF's
- Determine start column/ end column of Merged Cell
- Group and Outline by marco?
- copy shape image into image control
- Parallel Task (Threads) in VBa, is it possible?
- Searching Data
- THIS IS A TEST EMAIL....IGNORE
- Online Resources for Speeding Up Code
- Including a variable number of columns in Excel Sum formula
- Auto Close and Save
- default mail program -activeworkbook.sendmail
- html markup to specify data type of cells in Excel
- SQL Combining Field Results
- Returning the value of a named formula
- VBA Alternative to Vlookup
- Finding last row that is empty
- User function and Open Event
- RE: Custum Excel RMB Context Menu
- VB Code to stop cells being deleted
- Find last empty row
- Enabling a menu item
- Can I stop Excel program flashing on screen during run
- Write cells fro one file to a specific place in another
- Macro for unprotecting/protecting worksheets WITH passwords
- Close where no password?
- Command Button Code to copy data
- Many users for an Excel file in the server
- How to save the workbook1 from workbook2
- return screen view
- Line Interpolating from X-Y data set.
- Backup macro running twice
- Re: Update Links
- Re: ActiveSheet.ShowAllData shows everything - way to have hidden _not_show up?
- Re: FileSearch inconsistencies between Office/Windows version combinat
- Re: Another FileSearch Problem
- Adding new worksheet using VBA
- Re: Another FileSearch Problem
- Re: Array of Values from Worksheet Range - What does it 'look' like?
- Re: test cell for text string; return value if condition is true
- Re: Array of Values from Worksheet Range - What does it 'look' like?
- Re: program formula to ignore any cell displaying "N/A"
- Finding the last used cell in a column
- Re: Array of Values from Worksheet Range - What does it 'look' like?
- List Box Control
- Formatting the linked cell when using a List Box User Form
- Access closed workbook range in Custom functions
- Knoppen en werkbalken
- Excel VBA - go to worksheet "name" based on a cell reference ="Name"
- Increasing the width/height of cells programatically
- Re: Alternate row highlighting with a difference
- Re: Create combo box dynamically
- Re: VB.Net DLL Using Excel Named Ranges
- Re: Creating a monthly back up using Auto_close??
- Re: Adding "And" clause in SQL string causing SQL Syntax error
- Re: Dr Watson is pushing my head under the poo....
- Re: Updating Access from Excel Macro
- delete row or col
- Last open
- Need to calcualte depriciation
- Named Range - Empty columns
- Re: Create combo box dynamically
- Combining Macro Files