- Sumif for countif?
- Array formulas are not valid in merged cells.
- Macro to jump from the find box to found item
- Macro to return to previous worksheet
- Using variables with ROWs
- Ctl-X activation of macros
- Pivot tables and loop
- Moving active cell after copy
- Dynamic input for Chart gives error9 but seems to do his job to...
- Excel Reports Wrong Border Color
- Max Number of Sheets
- vlookup function in excel
- Formulae for Macro based files
- Why doesn't this work in Windows NT & MS Office 97
- VBA version
- What's wrong with this picture? VBA Date code..
- Workbook.Open Event Procedure not firing
- If/Then Macro
- How to let Embed Excel WorkSheet support Excel Addins?
- Re: macro adding a number to a number already in a cell
- Accelerator Keys
- Unlocking in 97
- Another Date problem
- Re: macro adding a number to a number already in a cell
- Append to open CSV
- Delete rows if they are empty
- Development Tools Available for Excel
- All Possible Combo's ?
- Shorter and faster?
- Setting TopMargin Property in VBA
- Save Excel to CSV with Quotes?
- No success deleting modules
- macro to expdite editing cell
- Delete Rows above keyword
- sorting questions
- Copying macros
- SumProduct Formula
- Auto fill?? Help??
- Saving a file with VBA that references current file name
- graphic converter?
- Finding first non-blank cell
- Microsoft Query - Excel - Compute BY
- Menu question + FaceId questions
- Problème avec Range(x).Select
- Formula needed
- Anyone mastered RTD techonology yet?
- Here we go again.
- user changes sheet1 - have the macro xyz run on sheet3
- "Too Many Different Cell Formats"
- Re: IP Addesses
- Re: how to make macro not dependent on datafile which has date as its part.
- changing the caption of a label
- Speed?
- Excel File format List
- Recognising Text formatted cells in code
- How disabling sounds when calling a shell program?
- Case statement
- Applying protection to an Excel Expense Report
- Show image
- How to load another XLL in the XLL?
- Need Macro To Copy & Sort
- Need Macro To Copy & Sort
- SUNPRODUCT
- OnTime Problem
- You don't have to be rude
- Re: dealing with multiple named worksheets with one macro
- ActiveX Control Button
- Re: ComboBox Question
- Re: trending data from a csv file with one macro with changing worksheet name.
- align text in the center of a range of cells
- Re: difference between 2000 and 2002?
- macro to disable the printpreview menu
- Re: difference between 2000 and 2002?
- insert excel vb script
- check if file is in particular folder
- Re: How do i change the graph source data to a variable dependent on the value in a cell
- Re: How to download: "Microsoft Forms 2.0 Library"?
- Re: Reluctant Macro
- Re: You don't have to be rude
- Re: macro adding a number to a number already in a cell
- copy sheets to another file
- Data form with multiple records
- excel macro
- Another Speed Problem!
- custom paper size
- Sub: Help needed!!!
- margins do not fit page size error
- Bogus Excel 2002 Macro Security Message
- Re: Copy only bumbers from cells
- LINK TO OPEN EXCEL FILE !
- LINK TO OPEN EXCEL FILE !
- Excel worksheet startup
- Add text to a rectangle in VBA
- Re: Limiting decimals text box
- PivotTables' name? And the PivotChart
- Re: Limiting decimals text box
- Determining selected worksheet
- automate find & replace
- Naming a variable in a file path
- howto_find _values_in_sum?
- formula problem
- ControlSource Compatibility VBA - VB6
- VB Macro
- vba..finding first non-zero value in a row
- VBA - hiding rows
- Running For Each-Next on Visible Cells Only
- Ghetto script - need help! one last thing
- start a macro from a func
- dynamic variables
- On going onto a sheet run a macro?
- Print Preview Input Range or From List
- Get items in ListView in columns
- VBA 6.0 vs. 6.3 Help THIS SUCKS!!!
- hyperlink is not working
- Display sheet upon exit
- Spell checker
- Setting printer paper
- Delete sheet code
- Current row/record shown when opening data/form
- programing reference worksheet
- using odbc in excel
- protect - macro?
- Oracle data to excel
- Can Excel dial a phonenumber from a cell?
- help
- Dynamically set Sort keys
- macro to hide rows based on formula?
- inserting page number in cell
- Sorting Excel combo box list
- Macro does nothing if ran in certain worksheet?
- activating workbooks
- please help
- open sheet on workbook open
- EXCEL "EntireColumn.AutoFit" Help!
- variable counter/total
- add-in absolute path
- opening files from explorer with startup file and addin
- Adding Items To Active X ComboBox on Sheet
- Freelance
- Copying Functions & Worksheet
- Urgent: Object Explicit Error
- VBA's Future
- Copying a range to the row below
- Use only VBA - request for experts
- find if there is a particular folder in a path
- For Each with Range object in Excel 97 SR-2
- Addressing the Excel file in which the macro is present.
- Automation and Diagrams
- Cell to dialer script with win xp
- Addins - calling functions
- Tricky Formel (counting days in combination with lookup)
- "Programmatic Access to be Denied" displays when running macro on excel in XP
- detecting the state of filters
- Solver in VBA
- RefEdit control bug
- Excel properties
- Extract a cells format and apply to a variable
- Copy Until Blank
- "Run-time error '1004'" Method 'Range' of object '_global' failed.
- combobox change event
- Mailing in Excel
- Printing a Word doc from Excel
- copy 3 sheets & save them into new workbook
- Protect Cell automatically
- Data analysis Regression in vba
- Can excel make a phonecall from a cell?
- Irregular VBA error with data validation
- ODBC System DSN Connection
- Copy cell with individual formatting
- Selecting Rows in Pivot Table
- Removing decimal from a cells value
- Office97 controls seems different on Office2000/XP
- Select Data only
- VBA and ActiveX Licensing .. ?
- ODBC import screws up fx
- Next in Series
- Activation combobox problem.
- Function that returns decimals only
- Where Clause Errors
- Freelance
- A pointer or two needed using userform
- Minimum value location
- change event/after update event??
- Please Help
- Macro to create folder
- changing chart title via vba?
- changing chart title via vba?
- Multi-Users and VBA
- How do I make a macro present (like an add-in) on opening Excel?
- Re: Removing and Applying protection in VBA
- Complicated formula
- Creating/modifing Outlook Rules from Excel
- Strange Problem: Opening Excel using VB appends 1
- Do Event
- Lookup Across Multiple Lists
- Enumerating Printers
- Format -Time Error on Excel 97
- Re: Copying Variable Ranges
- date validation
- Select a range
- reading xls from asp
- Using Microsoft Query to Extract Data
- encoding Today's date
- Easy Question
- opening & writing to Word from Excel
- Passing array to a function
- User sets range
- Need help on How to programatically Import VBA Project Excel Objects, Forms, Modules
- Print Preview Question
- Input Box won't show when Application windowstate minimised
- Excel macro
- Date problem from code to text box to spreadsheet
- Continuous Time/Date Updates
- What language can XLL be written in?
- VB 6 Toolbar and Microsoft Excel Object 9.0
- Using CreateEventProc fails when used with a Worksheet.
- Autofit on rows within a specifed range
- Color of selection in combo box
- Repost: Dop to next visible row when filtered?
- Selecting paper source
- Search an array
- Removing Checkboxes Programmatically
- How do I highlight a cell?
- Find size of array passed to user-defined function
- DTpicker problem
- Re: Input Box won't show when Application windowstate minimised
- Excel Expert
- Creating Multiple ODBC System DSNs from an Excel Spreadsheet
- After using Acrobat Distiller object, certain formatting causes error
- Customising the Task Pane in Excel Office XP
- Filtering dates in two different columns
- Shell Command to initiate Linux program
- Using SUMIF with linked sheets
- sequential number generator
- Update links and SaveAs?
- Search for hexadecimal values
- Excel VBA
- Formatting in a Message Box
- TRIM function - for the whole sheet
- Carriage Returns - Detecting
- data from excel to access
- Excel's built-in dialogs
- How to select a certain item of LisVview control?
- Programatically retrieve a list of public functions.
- UserForm Problems
- get path - save new file - same sub-directory as existing file
- Workbooks.OpenText
- Newbie Q : With VBA Read cells from unopened sheet
- Batch printing
- short cut menu doesn't show when right click on mouse
- Activating a workbook help
- Sort Dialog Arguments
- Create Message Box without buttons
- Batch printing
- How to Copy Formulas not Values ...
- How I disable a command button until cell has value?
- Keypress nest
- Comparing Values Needs Correction
- count # of elemnts in a column
- AutoFilter Custom Conditions
- Macro drops date formatting to csv file
- Operating on a Selected Range
- Sorting a Work sheet - using drop down box ??
- Publishing A Web Page
- Re: Convert a negative result to a positive result
- Length of Used Column
- Re: Convert a negative result to a positive result
- Re: Convert a negative result to a positive result
- Lotus123 to Excel
- MsgBox carriage return
- Inserting Rows
- Re: Load Macro at start up?
- Re: Load Macro at start up?
- problem in excel 2002 and windows xp
- Need A Formula
- Load Macro at start up?
- Select range using criteria
- Conditional formatting
- Activating A Query from An Input Box
- Conditional Formating
- print preview menu
- Spam is a big problem
- Opening Excel via Access
- getting cell values from worksheet
- CDbl function
- Page setup for multiple pages
- Help Creating a Macro
- formating multiple excel .csv files ?
- Reason for calculation...
- Userfrom textboxes
- Userfrom textboxes
- 2 questions - Creating a TimeBomb - Securing Code
- filtration of worksheets tallying 2 million seperate phone numbers
- Multipage TransitionPeriod
- Insert SUM function for range
- Looking for code to browse Dir & Files
- forcing complete calculation
- Change the value of a cell
- userform textboxes
- Macro to Define Range Name
- Reading Data From Series of External Workbooks
- Is there a method for refreshing an object variable?
- userform textboxes again
- Looping question for 2 columns
- Problem with Saving format of the Excel
- New excel file with VB
- VBA
- Color Chart Axis
- Conditional Statement-w/Objects
- Newbie Help
- Sorting numbers vs. numeric text
- exporting/coverting excel to pdf?
- Format multiple sheets in VBA
- Copying and then reselecting a workbook with VBA
- slider code
- AVI FPS
- A '.Select' question
- Excel 2000 and 2002
- is there a way of saving a filter?
- Error Loading dll
- GetSaveAsFilename
- Re: Input Box won't show when Application windowstate minimised
- C++ Client for RTD Server
- Re: Driving me crazy!
- MS query
- looping through a range
- Subtotals in object model?
- Cell Change
- Code to make graph invisible / invisisble
- Help Please! Thanks in advance.
- VBA Forms in Excel (viewing a list of data via a form)
- Excel Error
- testing the value of a cell
- excel manual reference
- Pretty basic VBA help....if you know how!!
- activate PublicConst
- Hyperlinking to an Autoshape?
- listbox.value not equal to listbox.list(listbox.listindex,0)
- excel scheduler
- Counting Formated Cells
- Save a file and send as an email - written into macro
- pivotTable and filtered list
- Where do I paste this Code?
- Web Query address parameter
- Multiselect Boxes
- looping Ranking formula - R[1]C[1]
- Changing consistent Cells
- Stop macro when open excel from VBA
- Named Ranges
- Application file search error in Office XP
- Hide Formulas.
- Microsoft][ODBC Excel Driver]General error Unable to open registry key 'Temporary (volatile) Jet DSN
- Web Query address parameter
- Macros stripped out of a file
- Error no. 1004
- Attributes of a cell
- Cannot get appropriate Event fired with WinSock control
- What data type?
- path user defined chart
- Countif Function ">75%"
- O2OLAP Market Comments - October 2003
- Open external program
- from end of month to 24th of the month
- From VBA-GUI textbox to cells
- Excel and Colours
- Nested with structure
- Cell change
- Using Word and Excel in one Macro
- No Buttons on message box
- Extracting Data
- Column property in MultiListbox
- Forgot to paste!
- Can I use this Outlook control in Excel?
- Re: Print Additive to file
- Refresh & backup tuning!
- printing
- Scope of Public Variable
- Charts to Word
- purchasing Excel
- Detect when Active Cell Changes
- text to columns
- looping formula - r1c1 problem
- Conditional find
- Function Max
- maximixe and minimize
- Recalculating with a new total
- Constant
- Extracting Data (Updated)
- excel 2000 VBA Password
- variables in row and cell functions
- macro stops copying sheets into a book after the 11th sheet
- excell 2000 to access 2000
- Default month
- Automatic sheet naming
- Unloading User Forms?
- Recording Software recommendation
- Unorthidox error messages in macros
- Help me out!
- Compatibility
- Determining Cell Types in Excel - exceptions
- Macro recording does not work properly
- Data Input Execl Form
- Merged Cells Autofit - code amendment
- Re: Looking for code to browse Dir & Files
- dropdown list that take data dynamiclly
- end of month to 24th
- Formula, I almost have it
- Detect Group mode
- XL2000: Shape object events
- Simple Excel Macro - Please Help
- User-Defined Excel Functions
- CheckBox controling a ComboBox
- Extractind Data (Updated Emaple)
- obtaining data from Access
- Formula
- can the following be put in an array
- error trap
- TextImportWizard & VBA
- Merging Worksheets in Excel
- emailing Spreadsheet?
- vb macro
- Help exporting worksheets/data to a workbook.
- Referencing the secondary y axis scale values
- I lost all my excel files along with the excel program, how do I get it back
- XL2003 Add Ins
- Convert Excel to text in VB6
- If .,AND ... Then failure
- User Defined Function Not Available In Other Worksheets
- How would I create a routine that runs every 15 mins?
- Listbox on click
- Thanks!
- Excel Spreadsheet into .exe
- Excel stealing focus
- Full Screen Mode
- Circle Invalid
- Send Data to Access
- Help files for Excel 2000
- Pivot table field formatting
- Can I Choose a Font for an InputBox?
- Excel Cells to specific fields in word document
- Fonts for E-Mail Addresses
- Combining Excel Workbooks and worksheets
- Hide (visible=false) all open applications?
- Macro or Script???
- Copy contents of Range to other cell
- References In Excel
- excel 97: linking 2 combo boxes
- Macro Polo
- Help with a project. Help me please.
- auth data not passed to "transferring file..." dialog
- continued combox frustration
- help with debugging
- Just learning VBA..
- file path
- Re: Hide (visible+AD0-false) all open applications?
- Re: Print Preview Question
- Help Copying from Outlook to Excel
- Populating multicolumn listbox the wrong way
- looping formula - r1c1 problem - Con't
- Refresh rate in getting external data from file
- Msgbox question
- dynamic substitution of worksheet reference
- Exel not loading every 2 days
- Workbook_Open event and combobox state storage question
- Docs for Excel object model with p/e/m
- Menu problem
- Re: Hide (visible+AD0-false) all open applications?
- Worksheet name = cell value
- Deleting shapes crashes for me. (Excel 97 vba)
- How do I change a function's otional parameter default values programmically
- Disabled Enabled
- Problems Attaching Macros to Command Button
- user form
- Moving chart window in macro
- Screen Updating
- Excel to Word document
- Html in Excel !
- Html in Excel
- Array size limitation?
- Execute a command line app but i want a string returned.
- How to call the TextImportWizard?
- type variable as argument of a sub
- Formula to change Negative numbers to positive
- Good VBA reference guide
- Code Changes Not Executing
- saving excel file as tab delimited text programmatically
- Detect any Volatile UDF
- Excel and colours
- csv file into vb.array
- Using UsedRange as limits in a For Each loop but for cells on another sheet ?
- Checkbox BackStyle Bug or Not?
- pls help!! copy -paste to another sheet. getting the sum
- VBA code to scroll all the way to the top
- The end of VBA?
- sum up range
- Checking if file exists in VBA
- Where's the !@#$%^&*() manual?
- Selecting all Cells with Data?
- pls help: short cut menu doesn't show when right click mouse
- Getting the previous cell value after changing a cell
- creating an "inferface-table" into one cell
- Can This Be Done With A Macro?
- Forms - Set Control Source to insert data in next blank row
- Opening a PDF document from Visual basic
- Adding Ranges, increasing worksheets
- adding blank rows
- How to fill adjacent column using a table lookup...
- Subject: Re: Opening a PDF document from Visual basic
- Excel code to Wait until Word finishes printing before closing
- Re: What's Wrong With This Function?
- Active X
- DOH!!!! I'm a BONEHEAD
- Sub From Yesterday
- Column Code
- copying macros
- how sendKeys to Acrobat Reader
- Formulas not "saving"
- mso-page-orientation asp excel
- Dropdowns
- Macros not appearing in the Tools > Macro > Macros list
- Saving Documents from templates to specific places
- Determining end of user-selected range
- Parse raw data
- How do I get Hyperlink from a cell
- Data Anaylisis does not work in Embedded Excel Table in Word
- Re: removing special characters
- Parsing the directional out of addresses using nested IF .
- Fail if macros are not enabled?
- accessing SQL server from Excel/VBA (instead of ODBC)
- Loop hits Row 8 and goes to End Sub??
- IsError() Not Working
- how to remove a reference from Excel project?
- Apply a function to the entire column
- Count Spaces In A String
- vbCancel
- VBA - BeforeSave - NEED HELP
- Macro help
- Amend form code to allow an option
- need help adding named range as new series to a graph
- How to sum selected values from a table?
- Response to Steve for Formulas not "saving"
- Subtotals in Excel object model
- Clearing Dropdowns In A Worksheet
- EOF Range
- Re: Hide (visible+AD0-false) all open applications?
- Target cell - unexplainable results
- Create matrix data from two columns?
- Excel over HTTP or SOAP question.
- Passing Userform as an argument to a procedure
- Read data from ascii file
- question on setting Range
- Using Macro To Merge Two Columns
- Creating Custom Function: TRIMSTDEV
- enable spell check
- flip an autoshape using VBA- recorded macro doesn't work
- Renaming Worksheets with For Each Loop
- HELP - simple VBA property causes Excel to crash
- Printer Object
- Grouping and Hiding of columns functionality
- Excel 97 VBA on Win98 Out of Memory Error
- How do I draw lines..??
- Delete Rows
- to STEVE from CAROL
- launching macro on workbook loading
- Moving cells
- Problems with SendMail ?
- Sorting referenced cells
- Application-defined or object-defined error
- Grab Password Name
- Trapping the Enter Icon
- Excel Changes File Name During Code Execution
- Excel VBA talking to Excel COM Add-in
- copying cells to another workbook if the contain spacific words
- Vlookup
- Re: Sorting referenced cells
- where are my VB codes
- Paste Down
- countif(and) problem
- Custom Autofill
- macro - security issue
- Referencing a new worksheet
- ActiveX Error w/Calendar Control
- one line macro to enter password for workbook
- Is it possible to permutate in Excel
- Close file without Save Changes dialog box
- MACRO TO COPY AND PASTE!
- Excel97 SDK: How to build a multi-lever menu using Excel SDK?
- variable calling in different modules.
- Loop thru multiple files - Modify worksheet visible property
- Loop thru files in DIR, delete worksheets & reset worksheet Name property??
- open outlook email from excel?
- Date only to appear if text is added to previous cell
- Re: extend list or database
- Macro error with message 400
- create multiple rows using a variable in a cell as source
- Button for wave file
- Checkbox Control to Hide/Unhide Worksheet
- Combobox
- function CELL( )
- class range...select...(reserved for expert)
- EntireRow.Hidden
- Program timing
- ActiveX as picture
- minipops_quiz logoquiz - cheats
- Replace Standard XL workbook icon
- Formula using VBA
- Msgbox
- repost: Listbox text align
- How do I use Workbooks.Add
- excel problem
- If value betwenn 0% and 50% than yes
- Combo Box becomes blurred
- Referencing Cells in Macros
- "TEXT" numbers - count problem
- text in listbox
- Path
- Documentation & testing
- Gray background is shown when loading a workbook
- MS QUERY
- Saving CSV files in Excel macros
- MS QUERY w/out querytable
- Having trouble with formula to automaticly enter data
- I need to validate with a formula
- Disabling/Enabling Macros
- Dropdown Rowsource
- macros disabled after apply SP -3 to excel 2000
- Simple macro - help please!!
- Delete rows if they are empty
- Parsing Shell Command with Parenthesis
- How Do I...
- DATEPICKER CONTROL
- macro for timestamp option button
- Combo Box - Can I Concatenate the list?
- Proteting against a button press
- Excel won't quit
- Library missing..
- Parsing Full Names of varying lenths and parts
- Autocomplete (?) in code not working
- Link .xls cell formula to .xla function
- utility
- offset property to define range
- Macro warning when no macros in workbook
- Modifications to Permutation Macro
- Can anyone find what is wrong with the following?
- How to Insert Picture in Excel?
- Wish to parse through a text string to find data
- skipping text formats
- Excel Compiler - is one available?
- SPSS Excel
- Copying sheets
- VB backwards compatability to 97
- More Macro Madness
- Error 1004 - unable to set the orientation of the page setup class
- Excel outline showlevel
- Dialogue Boxe
- Selecting Rows by Column Value
- Open all linked files and close them.
- Changing the Hyperlink in a cell
- "Not Enough Memory" new macros problem
- Publicising Benefits of VBA
- test
- macro for conditional formatting
- Tab Stop Broken
- DataCombo control...
- How to keep Excel sheets on a database?
- relative reference
- Maintaining Column Widths in CSV Format File
- Changing PivotTable source
- Activating workbook with variable Name
- Excel/Windows 98 second edition
- Pausing a macro for user input
- unwanted concatenation
- Cell Edit
- VBA: Userform Access
- Grouping Option Buttons
- How to uninstall XP PIAs
- Add-in installation on Excel 2002
- Basic VBA question
- Code For Expiration Date
- Export to text with custom delimination
- ReDim an Array
- Opening a workbook minimized...
- making a cell fixed number to a input number
- auto open a workbook
- my script wont post, unless i hit a key..
- How to return a XL97 spreadsheet info to the requested web page?
- Is this NewsGroup Operational
- Count Cells containing Text only
- RE: C# and OLEFormat.Object
- Not sure how to tackle this
- Disable "Save" &/or "Close"
- queryinterface error in vb.net
- Attention: Leo Heuser
- How do I use Workbook.Add
- can we start form by clicking hiperlink ?
- Code for modify a column
- Format text in Outlook from Excel
- Disabling Minimise/Restore Down buttons
- A very simple question....
- Comment Box
- Ambiguous Name Detected
- In unten stehendem Prozedurausschnitt soll an Stelle des Feldes 'name' jenes Feld eingesetzt werden, das in der Variablen sortierKriterium steht.
- Create Excel Macros
- Append new row of data to range
- Reliably get sheet 1 of the active workbook
- Array Help Needed
- Sum
- Inputbox used to return value of selected cell
- Inputbox to return address of cell selected by mouse
- Macro slowing down after a while...
- Determine range with VBA
- Let me have another try
- Printing with reference to current PC
- setting tab order by code
- How can I avoid a BLANK cell being interpreted as a ZERO?
- Assign a variables value to a TextBox
- Missing Security option in Macros
- How to make a sheet the active sheet?
- Excel Data Sort - doesn't. HELP please
- Page Setup for multiple sheets
- MACRO TO REPEAT FORMULA
- Newbie : Combo box on cell ?
- Windows Media Control and VB6
- "Run Time Error 1004 Application Defined or Object Defined Error."
- Re: Customisation of Chart Dialog
- Is it possible to set a class member to be another class member?
- true 3D bar charts possible?
- Row Heights
- Sum at point of change
- handicap predictions
- Run time error 1004
- Creating a Function that references cells to other cells...
- Using Solver within Macro
- Too Basic A Question
- refedit query
- Add & Delete Records in Excel using a form showing a scrollbar also!
- Resizeable Rectangle
- Wordwrap wont!!!!
- ActiveX Warning Message
- Changing cells temp.
- Looped process
- AutoFill Method
- REQ: I need help working out this function.
- Formulas
- How do I remove toolbars and specific menus items to restrict use?
- Userform Textbox Currency Format Problems
- tabbing round a userform, whole field is selected
- UsedRange & Formatting of Cells
- Disable ALT KEY
- Last question I promise