- Extract Hyperlink
- Summary display horizontally
- linking radio button
- Variable criteria to delete rows
- Need help with nested IF comparison....
- calling a subroutine outside a spreadsheet
- Workbook_Beforesave getting breached
- VBA : Number of Blank Cells in a Range
- Re: copying a chart
- Re: copying a chart
- Make Macro available to all new workbooks
- Cell as range
- Application on error sub possible ?
- auto filter missing record count & a fix idea
- A useful function: number2text
- External Data Updates
- command button on top
- Automatic sorting of a league table once a result has been entered
- Text box
- Deleting "old items" bug with pivot cache
- Pausing while retrieving data
- Modify ? Tom Ogilvy "count visible filter records"
- Passing cell addressess to variables to be use in range
- Interplay between UserForms question
- If statement to send email
- Saving text file in excel format through macro...
- Static copy of spreadsheet
- Question about ComboBox/Userform/TextBox etc.
- Passing Row variable to row Auto fill logic
- Lookup function to find email addresses
- VBA Excel2000 error 438 help
- Visual Basic within Excel
- Missing paste option between workbooks in Excel 2002
- Delete Asc(10) character from cell
- Excel Function to add a space within a cell
- Conditional Printing
- macro in 2003 template asks for non-existent XLS
- Passing parameters to a called add-in...
- Timing Problem can someone help please
- Converting two column compare macro to vba in Excel
- Carrying Variables into Called Macros
- Copy WorkSHeet To New Book With Print Page Settings ?
- Inserting Date into TextBox
- _Application.GetThisWorkbook() in a C++ add-in
- Assignment to constant not permitted
- FileSearch
- Excel Version Trap
- Inactivate cursor
- Broken reference for chr function
- Autofill help
- Filename problem
- Disappearing formulae
- UDF return
- how to accomplish a menu_less window?
- Option Explicit
- blinking cell?
- Dynamic Web Query
- Code Help
- On Error, Capturing current module and actual line of code
- Trim, Len, Left causing problem
- Multiple attachments in Excel e-mail?
- Comma-delimited files and Reional Settings
- Delete a Row if a Certain Value is in Column C
- Multiplication based on CSV string
- Sort list into alphabetical order
- Re: Sort list into alphabetical order
- Help required on macro for excel
- Referencing "current" row (not using ActiveCell.Row)
- Multiple Subtotals
- Pivot Table two column sum
- j-walk progressbar mod question
- Progress Bar
- Excel 2000 Returning text value Not formula from Cell
- alpha counter?
- dates
- DATA FORM problem
- How to create a mechanism to get the YTD?
- Deleting a named range in VBA
- How have text on clipboard reformatted as a cell would be put there?
- Is the array empty?
- Change Cell Color from cell vairable
- Returning MAX value and MATCH position in specific cells
- "Unable to Read File" on workbook containing Pivot Table
- Using the built-in dialog to format a shape
- Color Coding
- Converting Times
- copy files
- Progress bar in VBE
- return error msg, not run time error
- Find the end of a column
- Checking for bookmarks in Word document
- Arrays
- Still filename problem
- VB Macro statemenent in Excel
- Copying and moving matching data problem
- passing named range to a UDF user defined function
- Worksheets - Visibility
- Assign a variable from a Listbox selection.
- select down to the LAST non empty row
- Rich Text Control will not load in Office VBA apps.
- Re: select down to the LAST non empty row
- Re: Assign a variable from a Listbox selection.
- Finding next blank cell
- Re: Assign a variable from a Listbox selection.
- loop question
- Rows(arguments)???
- Macro coding needed.
- Password protect
- changing 'names'
- Dynamic Range Names & Clear Cell Contents Q
- Excel VBA - Countif problem
- stripping string & placing into cells
- multi formulae data entry
- size of excel files
- Can't record Global Macro
- Excel VBA User Form - button problem
- Saving monthly information from order form
- Using a hyperlink to find information on a different worksheet
- Excel - VBA (Freezing the Display During Maacro Execution)
- Run - Time error
- Help anyone
- Prevent end users from manually running or recording macros
- Web Query
- Web Query
- Set the path
- Active cell
- Reading the ShiftKey state
- Need some help with conditional functions
- advanced filter in Excel
- Hidden worksheet
- True / false statements in Macros
- Excel Process is not terminated when using C# and com Interrop
- Closing non EXCEL files
- Excel Color Code On Click & Redirect
- convert for email
- Import Currency Problem
- Macro Help on Toolbar
- How Excel calaculates
- CheckBox value to worksheet
- excel vba programme
- workbook_sheetchange
- Matrix formula ? Second try (no image)
- Complete Delete
- snake relocate to programmers :)
- Add Remove DLL reference in VB
- Test the color of a cell
- How to do validation ???
- heads of column (listbox in UF)
- Automate Macros
- MsgBox position
- Disable right-click
- Help required for automated mailing list
- Conditional Formatting Macro
- test vba in listbox (UF)
- troubles with the Workbooks.Open method in Excel 97
- hyperlink in Excel
- VB Timing Question
- Saving frm XP pro to 97 problems!
- VB timing question
- Pivot tables changes the case
- Sheet Code
- Saving on C:\
- Excel 2003 and FoxPro tables
- Working through files in a directory
- OptionButton problem
- function of a range of cells
- Text Box Question
- Setting up Worksheet_Change event
- Conditional unprotect and unlocking of cell range
- Show all Data
- Locking ranges
- Workbooks.Open Troubles, repost as suggested
- Learning about macro's
- Need help with custom open/save functions
- incrementing cells withina formula in VB
- Link Excel Fields to Outlook Contacts
- Range Select Error
- Option Buttons
- SUBSTITUTE using arrays?
- Delete duplicate records in the table
- 2 workbooks open at same time break macros
- Re: Macro to run when sheet opens
- Re: Macro to run when sheet opens
- Mysterious standard toolbar
- Delete an autostart Sub with code
- macro question
- Hiding rows
- Automatic Hyperlinking?
- Data duplication
- Conditional summation
- Add reference programmatically before a module compiles
- Moving Data
- Sort Using Date Functions
- Comma delimited text to columns
- Try Before You Buy Spreadsheet
- excel vs. access
- Count number of selected item in Listbox
- aling to right
- Compile Error in Hidden Module TBRun9
- Format by VB opened Workbooks/sheets
- Using Access
- Template Wzard for Excel 2003
- IF and HLOOKUPFormula
- Syntax for Countnig Rows
- Shared Drive/Macro or Hyperlink
- Re: Buttons
- Progress Bar
- Textbox question 2
- formulae in Pivot Table
- Referencing all sheets in a workbook in VBA
- Logic for a FOR loop
- IF and HLOOKUP Formula
- Sum a row of data based on FONT COLOR (
- Disabling Saveas and saving file with a specific name only
- Function Arguments
- Conditional Fill Macro
- Trying to Learn VB
- Custom Date in Autofilter
- RE: Programmatically remove sharing?
- Extracting from another file
- Import text file into excel with preset file layout, delimeters VBA
- Text to Columns doesn't work for this problem.
- reading contents of a file
- RE: do until...loop question
- Web Query - Unable to Record
- Number changed to Text
- I can't make my VB commands to repeat..any suggetions?
- Check If COM Reference Available on Machine
- I can't make my VB commands to repeat..any suggetions?
- Can someone fix this hyperlink formula?
- Automatic Value conversion
- macro
- Event macro?
- Office 2003 PIA do not work for Office 2000
- How apply one action to all worksheets?
- A repost: Automatic file opening procedure seeming to hold cache
- Data Range for Graphs
- Excel Query - Code problem
- Change color of text depending on "IF" Statement?
- Perminant Template
- Perminant Template
- Why can't a calculation and macro execute at the same time?
- "How can I reference all the comment boxes in my workbook and resize them
- Find Method; First letter
- Date format
- Not able to "Step in" - Debug
- Range.Formula in Excel 2003 gives Error reading formulas just below 1024 bytes
- Linking Worksheet File
- how would i select a group of rows based on a column value
- very very urgent vba pogram doubt
- vba code problem
- Rephrasing argument for typename and a different result
- Passing range as an argument in a function
- Is there a way to shorten this?
- Excel not seeing 2nd COM Interface
- vba program problem
- vba program clarification
- Macro resets my calculation to manual
- Resizing Comment boxes back to default size!
- help with formula calculation
- Is this possible?
- pop-up adds
- Macro override password protection
- dictionary function
- Re: how automaticly print excel sheet
- ApiCall: Get KeyboardState
- Locating Cell Number of first occurance of data in Column
- AutoFilter on a Protected sheet
- textbox focus
- Macro
- Excel Macro
- Save as using cell content in file name
- Check for files
- adding reference to the Word-Library
- Paste where cell meets certain criteria
- Userform in excel97 not working right!
- Setting a Range
- When to Stop
- Excel in English run on PC with Excel in French
- macro to executable
- embedding / structured storage?
- "Compilation" d'une feuille Excel / Compiling an excel sheet
- Detecting Macro Security Level
- Spell Checking Custom Properties
- Re: Spell Checking Custom Properties
- RE: The macro 'xxx' can not be found
- Re: Spell Checking Custom Properties
- Listbox Scroll
- Re: Detecting Macro Security Level
- lookup value and change background colour
- Simple (?) Macro Assistance- Select, Insert, Paste, Rinse, Repeat
- macro that counts lines with certain color
- Defaulting a cell to 0
- Combining tables from several spreadsheets
- Simple UDF help
- Setting up a database
- Full Screen With Application Title Bar
- Pivot table cruft and incredible shrinking workbooks
- Print Range Macro
- Problem
- Problem selecting a range to print...
- Pivot Table
- Book 1 auto opening
- Display hyperlink as web address
- UDF help
- Spell Check protected cells
- Progression Tables?
- merging two files
- How to delete a file using VBA
- if statement
- Excel Vba Clarification
- Closing Excel in VBA leaves it in task list
- Visual Basic Help
- Q210684 - Need more info on suggested work around section
- xl macro
- Taking over OLEObjects... Possible ?!
- Variable in range
- If....Or Logic question
- Help with date search
- Swap columns A&B with C&D
- How to make a Macro Iterate
- Number length headache
- Help Me!!
- Quick If Question
- Need help with merge cells in a macro
- Saving a worksheet out of a workbook
- Anyone Well-versed in loop?
- Case when statement gives type mismatch
- Examples of Using VBA, ODBC, and mysql
- Accessing the USB Port
- Reverse of Chr Function
- To Tom -
- Counting groups of similar items
- problem with cell sizes
- Copying and pasting entire workbook
- Insert a command Button
- Chart Size
- Only one user @ a time?
- Detecting merged cells
- Conditional Formating
- Spreadsheet Solutions
- help with some code
- Worksheet Controls Forms vs Active-X
- pivotchart colouring
- "Casing" the strings for smooth code running
- Summing
- Copying a column from several similar sheets into one sheet
- GetObject
- File in use
- calendar userform
- calendar control xls 2003
- really hard cell fomating question, sorry if wrong forum.
- Background Query Timeout
- Is this possible?
- Code Needed
- Excel Error Reports and Unexpected Termination of Program
- Application.Speech
- Spacing
- Office 2000 Programming with Office 2003
- Office 2000 Programming with Office 2003
- Certified Macro's?
- Pivot tables, Validation Lists exist in an excel file
- VB strings, MSXML, Latin 9, and the Euro
- Re: Background Web Queries flaws!
- Create a new sheet in a workbook from a template
- code to update a macro
- Return to MS Excel
- Problem selecting cell
- Copy Excel sheet into IE environment
- calculate shares for heirs at law
- Starting over
- Select charts to copy
- Register MSCAL.OCX
- memory issue using ADO to query Excel
- Combo Boxes
- ListBox and Hyperlinks
- Spell checking a protected sheet
- Next Empty Column in Row
- changing design in excel from VB.NET
- Display range of cells in popup window
- Updating range properties is so sloooow!!!
- Multiple coloumns data
- Sheets Protection for group!!!!?
- Publish Excel sheets automaticly!
- Autosaving files with different names
- Is this crashing for you ?
- locking textbox?!
- count time
- Using SaveAs Statement to overwrite existing File
- How to program a series sum function
- opening directory from excel
- opening directory from excel
- opening directory from excel
- Autofilter with vba wont dispay filtered data
- Date Control using Spinner
- Autofilter vba dont show filtered data
- VBA IDE Weirdness....
- Help with Loop
- Get values from Controls in Excel-sheet
- Vertical Alignment of text in Userform labels
- DSN-Less Connections
- Security warning for non existant macro
- Disabling error checking.
- Copy down command button
- Where is microsoft.public.vb.general.discussion located?
- formulas not executing until workbook is saved
- Autofilter and choosing filtered columns
- Indirect and Match functions
- Excel from Access/File Sharing
- Listen i datavalidering forsvinder
- Add Comments to Word
- running a macro only if criteria are met
- cell address
- How- Message box on opening excel file?
- Deleting shapes
- batch insert pictures one time in excel macro
- Custom functions address space
- For Each...Next statement
- Cycling through the cells in a range
- Populating a label box
- Auto Fill Weekdays Only
- Re: Auto Fill Weekdays Only
- Re: How to pass a date in Excel to ms query
- Need some help with conditional functions
- Transfer numbers
- Formats for date
- Print multiple selections to file by macro
- Adding AutoCalculate option
- Inserting rows
- MultiPage scripted changing
- Multiselect listbox selection question
- problem with military time and making calculations
- Filtering Data in Excel by Team
- IF STATEMENT
- Excel macro - Range & Sheet name error
- Code to delete Macros
- Need help writing a conditional formula
- loop
- Open Excel
- How to abort executing macro?
- Setting a boolean depending on who called the macro
- User Form Help
- Filtering out dates using autofilter
- Problems in Visual Basic Editior, In search of a command
- Lookup an array question
- combobox/textbox/userform/other question
- Excel renaming file to a temp and deletes original (long)
- CREATEOBJECT Using VB
- Detecting if AutoFill was used?
- Summarize formula links between worksheets
- lack of chart uniformity
- Problem with code causing Excel '97 to crash
- I have date I want time
- formula- find min value in range, then average that value with one value on each side
- formulas to values
- Multi-select Combo Box
- Visual Basic Marco
- 2 quick questions
- Replace
- Full Screen With Status Cut Worksheet Tabs in Half
- Workbook Close Event
- Copying a particular range of values from one sheet to another in excel
- Position hyperlink in Excel
- Compare two col to same two on next row
- deleting rows macro
- RE: How to pass a date in Excel to ms query
- Pulling Date Ranges
- moving .xla files and top level tech information
- Need Help on Web Query - Thanks in Advance
- Save web page as desktop file from Excel/VBA
- Renaming Worksheets
- Runtime Error 381 Couldn't set list property, invalid array index
- Runtime Error 381 Couldn't set list property, invalid array index
- Filtered Rows using Mode Function?
- Waste Reduction Program
- Excel Macro Problem!?
- start macro based on result
- Column Limit
- DisplayAlerts Intermittently stops working
- simple scrollbar question
- Sub or Function not defined
- excel's memory limits
- Marketing and protecting an Excel "creation"
- New to VBA question
- MS Calendar help requested: default to 1st of prior month
- Custom function problems
- find & replace (hidden) '
- help needed with timer / loop
- funny problem with range names
- Excel macro slows down on second run
- Conditional Formatting
- Hide a Sheet
- Excel Macro
- Modify code to disable "paste"
- Word Template - Editing Excel with VBA
- userform Radio button updates text box
- Excel VBA from Word Template
- how to get the cmd window to close in VBA??
- Pass array of worksheets to ActiveX DLL (VB6)
- Outlook 11 > Outlook 10 Object Library Compatibility Issues
- Running a shortcut
- Non-Editable ComboBox?
- know when the job of print is completed?
- writing a Function with a variable number of arguments
- Create Excel chart using C#
- Case# 4812 - Display gif picture based on cell content
- Worksheet Combo Box
- Date programming - Absolutely confused.
- Conditional Format
- name
- Excel RTD
- need to have users share add-ins
- importing Data from access
- Closing workbooks
- if ... then action
- Make my macro security
- Problem with custom date formats
- InStr and ADO
- Excel VBA-Importing txt files with VBA
- Check Boxes
- If date Then Paste.....
- AskToUpdateLinks not working
- Help Creating Text File
- newbie spreadsheet problem
- Can this be done
- COUNT cells with Y and N
- Method 'Intersect' of object '_Global' failed
- Sorting Items in a ComboBox?
- Deleting Cell entries then save and overwrite template
- Re: What is the quickest way to copy codes in Sheets?
- Re: What is the quickest way to copy codes in Sheets?
- Re: Remove the Password protection at the launch of excel.
- Re: Remove password at the time of opening the workbook
- Re: CSV File format problem
- Counting Dates
- Macro VBA Code
- Increment cells only in filtered range?
- Conditional Formula
- Excel
- References to XLA files
- Delete a list of rows
- Aligning login logout times horizontally
- Aligning login logout times horizontally
- Dynamic Print Ranges
- click functions
- Solver 32.dll
- Macro works once, not twice
- Listing Named Ranges
- How to write macro for entering mm/yy where it fills to current mm/yy
- How does Solversolve Control Macro
- VBA Valadation xlBetween ERROR
- userform txt box updates spreadsheet
- Consolidate
- Generate Excel files on server
- Experts help needed
- rnd
- easy question on excel/outlook
- Solver automatically in the VBA Reference
- array values type mismatch?
- Button controls on worksheets
- Hide Columns
- asking for a file
- the "&" in buttons
- Worksheet Event Code
- formula question for arrays
- range selection problem
- Macro to delete duplicate records
- A Macro to Edit Cell Content
- Custom print macro
- lookup problem..can you solve!??!
- Write-Reserve problem...
- Re: Textbox ControlSource Property - Excel 97
- Need to sort based on Check Boxes
- Deleting a Column
- searching for the first few characters in an active cell
- Advice wanted fromMVP's.
- character limitations
- character limitations
- Mail Merge Programming????
- Batch Watermark Macro
- copy / paste without skipping blanks
- macro and lookup in workbooks
- Filesearch in VB6
- A macro to fill in the blank cells
- Import text wizard in a macro
- error (ComboBox-?)
- What's Wrong with This?
- Compile error for macros
- Can't open Excel2003 workbook containing VBA macros with Excel2000.
- problem with performance of excel macro, pls help
- Clearing Cell Contents
- Help - This macro converts my text numbers.
- Using different range names in same function
- Enter Key behavior with Userforms
- Hiding rows programmatically
- creating new folder while saving document
- Query between worksheets
- Automatically define series of named ranges
- Automatically Cut Row of Data and Paste to Other Sheet?
- Question of Import Export Files
- Equivalent ActiveCell.Id property for Excel97
- Trust and Signatures in VBA
- hiding the headers
- check folder event
- How to schedule a Macro ?
- Create a xls File on Server without Excel?
- switch on 'snap to' from vba
- Pivot table change leaves MSQuery open
- formula help reqd please
- Exel VBA - Sheets.Name
- Address of Merged Cells
- Can I "Save As..." an Excel Sheet to an Access Table?
- Runtime error with the sheet collection, which was not there in 20
- convert 400 word files to excel files fast?
- Replacement CD
- Why do i have to re-assign macro's all the time
- Conditional format cell ranges with loop?
- Last valid value in array
- Telling MSGraph which cell I need
- Need Help on Web Query - Thanks in Advance
- How access a listbox on a worksheet
- How can i access a listbox?
- Method of protection fault when sharing file!!
- Error in 2003 which is not in 2000
- Capturing Excel Opening
- Combine Closed Sheets
- Using Validation list to copy from another Workbook
- snap to from vba
- convert a number of seconds to HH:MM:SS?
- Selecting Variable Rows
- Deleting entire rows
- trouble displaying as text
- automating delection of certain rows
- Same variable name in different projects
- VLookup in VBA
- dynamic list to remove duplicates and spaces ?
- Newbie needs help with formula
- Excel No-Launch
- Sort list by color (makro)
- Excel VBA Format Row on Condition in Cell
- deleting the last nine characters in a cell
- autonumbering only when original file is opened
- Application.ScreenUpdating malfunction
- Re: Calling a function without starting with "Personal!"
- Date Formats in Headers/Footers
- VLookup
- Formatting Header and/or Footer Dates
- Using SUM with worksheet range selected by two combo boxes
- Cell text format
- Unfilter
- SUM Function Yields Zero Result
- Tom Ogilvy - 'Snap to'
- Variable File Name
- Copy And Paste Rows
- Run Macro Upon Opening
- comandbars/toolbars
- question on arrays in vba
- Like Character?
- locked cells
- if cell empty hide row macro?
- converting to excel file
- HLOOKUP Question
- Control the insert of a new sheet.
- FileName
- Copy a range of cells in an unopened workbook and paste it to the current workbook
- GUID of the Reference
- Display a picture depending on a value in a specified cell?
- Creating dynamic (formatted) tables
- MS Query
- Two Different Columns of Dates
- application.Value(Variable)
- Delete everything after a certain character?
- Newbie: Conditional question
- Autofit column width of all worksheets in active workbook - an example
- Copy same data from all files in folder
- RE: macro does not sheet name
- ComboBox problems !!
- Counting Fridays in a month
- weird date issue
- Creating Word Documents with an Excel Macro
- Can not write string to a cell
- Programming double click functionality
- convert whole excel file to vba (tough question?)
- Double click funtionality
- Navigating To Find A File
- Rename Files from Explorer
- Sum the first 10 numbers in a 26 cell range
- closing form semi permantly
- closing form w/ Maco
- Sarbanes Oxley Question - tracking changes in macros
- Tracking Changes
- About the use of "Getpivotdata"
- Can't check checkboxes in userform ... sometimes
- vLookup to another open spreadsheet
- select all & copy in word from macro in excel
- Excel VBA - Capturing a checkbox caption into a worksheet.
- Data import odbc
- Sorting columns with multiple rows
- "what triggered the event"
- Open external book before updating links?
- Where would you like to save - Name?
- Opening as Read Only
- Deletion of rows according to background color
- Menumaker problem
- loop through all named ranges
- using variable inside activeCell reference call
- Setting up deposit account
- Hiding cells based on formula result
- Strange behavior Chart.SeriesCollection(n).Values property
- Shared Workbook grows bigger when saved
- Hiding cells based on formula result
- Re: Hiding cells based on formula result
- Other language
- Increment value inside conditional format
- Printing 11" by 8.5"
- Text color question?
- Excel VBA - Found last row number but can't select it
- Function debuging help
- two dataset comparison
- protection and macros
- Excel VBA - Action if a cell holds a certain value?
- Converting Dates
- lookup source for Macro from a dynamic Range
- Formats in Listbox?
- Import Text File
- reformatting a table
- creating workbooks(with macros and userforms) programmatically
- How do you hide a row based upon cell criteria?
- VB6 and Excel - 1004 error
- Accessing a SAS dataset?
- How do delete every second Row
- Hinduism, Normism & Declaration of Heaven on Earth2784
- How can you make a macro global
- inputboxes
- Reduce the stock when place order
- VB and Help Windows Maximized
- The old application.quit problem
- Create combo box in Excel using VB editor during run time
- arrays
- Opening and closing many spreadsheets from .NET
- Displaying Excel charts in VB
- Newsgroup protocol question
- Excel - web page interaction...is it possible?
- Copy and Paste to Bottom Row?
- macro from General to This Workbook
- Error Handling
- string problem
- How can you do this?
- Filtered Rows / Numeric Data - Automate Position of Total on Worksheet
- how to make a chart from formula values? VBA