- Use VBA to open an Excel cell for Edit
- Re: Publicising Benefits of VBA
- Restricting use of menus and toolbars
- Array Formula
- How many CR's in a multi line texbox
- Shapes.. trying to print a square square
- Formula
- Difficulty hiding check boxes
- VBA: how to force another instance of VB to run
- Stopping a macro without using Ctrl Break
- looping with formula inside
- Worksheets.Add
- link a cell into a vba form
- Why doesn't this work...??
- Excel on the Web
- Working between Worksheets of the same workbook
- Sendmail Macro
- MACRO QUESTION
- Excel Help.. PLEASE...
- Option Button and forms
- Spreadsheet documentation
- worksheetname in a cell
- #DIV/0! criteria
- Excel help + VB
- Prevent users from using AutoFilter
- VBA code to change the Print - "Number of copies" to 3
- Ending a routine
- User access to the VBE
- calculation multiple row & colums
- AutoComplete in a List
- Populating combo box with a function
- variable range: l just can't get there!
- Range.column
- Sum Function
- how can i copy a macro to another pc
- Msgbox help
- argh, can't get it to work
- Print data from FlexGrid
- Modify generic dialogue
- Run command when hitting ENTER on list box item
- Maximize minimize and restore button
- ActiveWorkbook reference fails
- Emptying the copy buffer
- Associating a macro with a button
- Using VB to fill a formula down
- Linking Cell Comments!
- Determine active file size
- Macro Monday Blues
- User Defined Addin - Urgent Please Help!
- Importing data from text files
- Excel vba printout method
- how to convert excel sheet with 65000 records to ado.net dataset
- run a DOS .bat files under an excel macro
- Pivot Table Macro in Excel 2002
- Using VBA with Shared Workbooks
- Conditional number format of cell
- programming font color on select items
- Is there a better option than Getobject to access a .xls?
- restrict entry in a textbox to a range of values
- Connecting to comm1
- On Error
- Connecting to comm 1
- Using Excel to generate Word macros
- Re: vb to copy conditional info.
- Date/Time - String or Number!
- storing numbers within the macro
- How to conditionally sum values depending on values in other colums
- Many names using anonymous@discussions.microsoft.com
- Detect workbook events from .XLA
- vba programming
- Searching mailboxes for strings in messages.
- Filtering
- My Macro keeps stopping??
- Add columns of data in Excel workbook to fields in MS Access
- Operation Is Not Allowed When The Object Is Closed
- How to set a time for the next 1/4 hour
- SP3 removed Macro Security option in Excel 2000
- Collectiong data from SQL server / Repeat!
- Excel 2002 and Excel 2003 VBA help screens
- Changing a cell color....
- Re: Macro 'Automation error' with ChemOffice Excel macro
- converting 16 digit number to text
- Do I need to register somehow to use this newsgroup ?
- SQL Statement
- Still Stuck
- Templates
- Nedd help on my function in VBA
- Automaticaly Emailing A S/Sheet ??
- message when saving workbook
- Copying Cells
- delete rows
- Opening a CSV file
- Getting to the Function Explanation Programmatically
- Create named range
- List of GUIDs and other properties for future references
- Automation
- ranking the bottom of the table
- How to display contents of a cell in UserForm and take input
- ATTN: VASANT
- using mappoint in Excel VB
- Using Excel through COM
- Any difference between Sheets Activate and Select?
- Help - Change Event triggered on File Save As
- References in VBA macros ?
- Run-time error '430' / Class doesn't support Automation
- Over ride double-click handler?
- Help with a Combo Box Change Event
- Import External Data incomplete
- Form question
- Custom Menu
- Pivot Table: Hide Items Poperty
- Pointing to the Correct Directory
- Global variable
- Userform question
- Adding Modules
- Flickering of the Screen when the Macro runs.
- Running Access MAcros or VB modules in Excel
- Difficulties in VBA ( User form and option button)
- vba or function
- question on the definition of refer to
- Rounddown problem in VBA
- VBA code 'find next'
- Format column auto. to "hidden"
- Excel formula
- Cell format
- Specify a folder for saving to?!?!
- ActiveWorkbook keyword seems to fail
- Making arrays outside cells
- Create customs define event
- Problem hiding/unhiding columns using combo control
- SQL Multiple table joins in VBA
- Problems with ungroup
- Autofilter hides totals I want to see
- Compare Worksheet's
- Insufficient memory Caused by Pivots.
- toolbars
- OLE
- Before DoubleClick
- Cheque Writer in Excel
- Problem with Legends in chart
- Pb en VBA Excel
- Creating a Master Sheet
- Tuesday Treachery
- Another Tuesday Task
- How to write an importer/exporter for excel
- How to force a recalculation of values based on custom function
- formatting ques...
- Check activate sheet
- Re: sheet collection
- Re: Page number question
- Re: Page number question
- For Next with step
- Formatting a date as a serial number
- Email from Excel..please help!!
- Holloween Mystery: ghostly blank cells
- Calling Macros oustide current module
- how to trigger macro or force autofit
- Excel 97 automatic cell format
- Annoying "virus" alert when using code to send mail
- excel 2000, vba and msquery(sql)
- Offset Formula Question
- Revised Question on Page Numbering
- VBA code slows to a snails crawl when screen saver activated
- Web service reference Tool 2.0 -
- macro & comobox
- Printing to Adobe without getting promt for name
- Paste a Range from a variable
- Help Retrieving Cell Values
- Comm1 not opening
- Can anyone solve this!?
- Comm 1
- code Help - Routing Recipients
- adding a listbox to a spreadsheet
- Loop through sheets, deselect charts
- sumif
- Tuning Off Toolbars
- Send file automatically
- Sort to Various Sheets in Workbook
- Insert rows
- Maintain Target Porperties in MS Excel
- List Box Visible Rows Only
- Follow up: Importing from text files
- Linking Excel to the Internet..
- Re: @ Round Formulas
- Conditional find
- Re: Delete Rows above a certain point
- What is InBufferCount?
- Re: @ Round Formulas
- Load Macro at start up?
- Changing cell formulas with a macro or VBA
- Use of New Range Names in Macro
- Anomaly, can't format cell
- Start recording macro
- menu in excel
- Counting files using Loop
- Counting files using Loop
- Counting files using Loop
- Executing a Script on an Oracle DB
- Listbox9 does not support saving.....
- UserForm remembering Settings
- Help Excel for Second Edition Windowns 98
- MACROS
- Visual Basic to reference value in Excel cell
- Printing to Generic / Text printer
- Scanning mailboxes and generating email replies.
- Printing Mutiple workbooks....
- Random Number Formulas
- MESSAGE ALERT
- Help with Macro
- Saving VBA Toolbar Customisation
- TextToColumns Dialog
- Creating a Dynamic Function
- Set variable = nothing?
- Delete Rows below a certain cell
- Looping Find
- Selecting single column with merged cell at top
- Open WinZip from Excel
- copy a mocro to another pc. HELP!!!!!!!!!!!!!!!!!!!!
- detect worksheet
- PRINTAREA
- Disabling Toolbar Buttons with no open Workbook
- How do I use a Combo Box to change values in a Cell.
- ONACTION macro tries to open another workbook
- Worksheets.Add method
- Form Resize
- Automating Excel (XL2002)
- Setting attributes for controls
- Worksheet value to user forms
- How would I modify the following?
- followhyperlink failure
- Need Looping Help
- list worksheet names within a notebook
- hlookup in VBA
- Code Snippet - Solution Suggestions
- Transferring data entered into a Text box to another Cell/Sheet?
- proprietary protection
- Excel Marcos and Programs
- Application Size and Location
- Updating form labels from code in a module
- code lost after saving
- Assigning formula using a macro
- Templates and CreateObject
- How Can I Use SendKeys in MAC EXCEL?
- VBA Code to convert Excel to PDF
- Macro execution refers not to the active sheet/excel file
- Ontime questions
- Auto Refresh/Format a PivoTable
- Conditional IF statement
- multilple sheets using days of curr month!
- VBA code to insert images in excel sheet
- CONVERTING A LOTUS MACRO
- Get Last Row
- vba multi threading
- In a Cell, How Can I Make The Cursor Go to The End?!
- Path Not Found Error
- assigning a formule to each cel in a column
- Code slows on subsequent run
- copying and pasting not adjecent cells
- macro & combobox
- Excel and preparing email
- Yes_No
- autofilter using macro
- Macro to play wave file
- ASSISTANT FILENAME
- How to change image by function?
- events
- Print multiple worksheets
- worksheetfunction
- file name
- Re: Display a message whilst a macro runs
- Application Process-Shell Command
- Determining range
- Delete columns
- Using "Find"
- Reading specific digits from a numeric variable
- Need FASTEST way to get data from a large closed Excel File
- How to update pivot table items?
- Stock quotes:Excel
- Excel Test Formula
- Compile Error in Code
- Disconnect a spreadsheet from its datasource
- Renaming files
- deleting variable number of rows
- spreadsheet calc
- Automated Printing
- Print Excel Workbook When Open
- access the function description
- access function description from c++
- access function description from c
- Toggle Button
- Searching unknown number of cells for a value
- Minimize the VB form
- Open workbook without activating it
- Add control at run time.
- 'Floating' UserForm
- Copying a named range of cells
- Minimize the VB form
- Moving Vertical Page Breaks in Excel via VB
- Improving code.....For Next
- Button
- Delete #N/A rows
- xlDialogSendMail problem
- worksheetfunction.vlookup?
- Case sensitive data
- VBA code to open a specific worksheet
- check font colour
- unprotecting a combobox in your spreadsheet
- User form question
- Uploading Problem
- Auto Open won't die or go away
- TCD Format du Tableau xl???
- WEB BASED EXCEL REPORTING
- makro that sums every new number entered in cell
- Protect macro code from viewing/editing
- Creating Boolean Functions
- Help with a macro. Let's eliminate a loop...
- Pie chart programming
- counting occurance of a name in a cell
- Preventing opening workbook inside active workbook.
- Adding toolbar/menu command to Excel using C#
- Retrieving File Name from Text file
- Re: Display a message whilst a macro runs
- Re: Access to Excel
- Open Menu item "Print" from VBA
- Changing Event Subs of Controls On Air
- embedded objects
- Excel to Access
- Exporting to Excel, Then Formatting Columns/Cells
- Range.Select with variable cells ?
- How to Retrieve Last Used Cell In Column
- Add-Ins and Pocket Excel CE
- recherche et affichage d'une image
- Unable to suppress warning message...
- protection sheet and code ???
- Setting Excel toolbar or menu icon in C# WITHOUT using builtin icons
- work schedule formla's
- Macros
- Accessing External Data
- Control IE popup from excel VBA instantiation
- File List Creation
- Closing Excel
- Visible Rows Indexing
- next avaliable range
- Run time error '1004'
- Replace return of line by a space in VBA
- application.worksheetfunction.mmult help
- Re: recherche et affichage d'une image
- Sorting 100 rows of 6 records horizontally
- excel control button
- xlDialogTextToColumns arguments
- IPF in fm20.dll
- merging templates into workbook
- Workbook references
- Sum of cells spanning several worksheets
- how can I lock a file after some days of using it??
- Re: Looping
- removing unwanted characters in a cell
- Referencing other workbooks
- Excel error message in protected sheets
- determinate if a range is empty
- Re: Looping
- Proper method for Excel/Query/Macro reporting
- Detecting non-supported files using Excel.Open
- Menu commands - overruling with macro - How to do it?
- Copy insert rows
- Import Text file into multiple columns
- XLA & COM files
- Point of departure...
- Closing a Window
- Countdown to Retirement
- Changing color of cells
- Convert Excel to PDF via VB code
- Delete rows after used cell?
- Text Box for Numeric Data
- question on button event
- Macro run slow when turn on ScreenSaver
- file extension problem
- no connection to excel
- copying rows
- Add-in auto updating
- Saving a graph as .jpg
- Programming Xml Source Pane of Excel 2003
- Excel cannot update web page
- autorun userform from worksheet
- SaveAs,csv
- extract a foldername with a formula
- Code security
- extract a foldername with a formula-update formula does not work
- Replacing a value within a string using a formula
- xlDialogSendMail Error
- Dir() limited to 48 files?
- Paste Cells in Column A to Columns B-K
- extracting string from value in cell
- Find "." (Full Stop) in cell then all text after colour blue
- Protected worksheet and macro
- Using Find & Replace in macro
- start a macro when file opens??
- html file in excel probelm !
- ByRef not passing address
- Calling macros width arguments in winxp
- Empty toolbars
- Error 50290: Error writing to Worksheet while using an ActiveX Control
- setting up a workdirectory
- Report Question?
- [excel 97 vba ] Reading ranges into an array
- edit default excel template
- dates in dropdown
- Zoom problem
- Selecting cells with a particular formula
- Date Validation
- print form orientation
- date extraction howto?
- Name field value
- program activation
- In Excel VBA, open .txt with Word?
- Easiest way to automate spreadsheet merge?
- default printer
- Re: Selecting cells with a particular formula
- Re: Selecting cells with a particular formula
- Re: Selecting cells with a particular formula
- Delete #N/A rows Formula
- Hide rows if formula result is zero
- Circular References, what a nightmare.
- Deleting Many Cells on a Sheet
- How can I hide the code??
- insert validation in sheet
- .net, excel, extended properties and dbnull
- MACRO TO UPDATE DATES !
- Deleting sheets
- how many combinations in a list equal a certain total
- creating a hyperlink in a shared workbook
- flashing screen driving me bonkers!
- How do I protect my hidden Excel.Application object from unwanted user interaction.
- Generate XLS on server without Microsoft Excel
- oops!!!
- Personal.xls
- variable that refernces the values in a text box
- Unpaid overtime?
- Assigning Macro To Shape
- Function that emulates FIND(find_text,within_text,start_num)
- Program a drop down list to show a specific response depending on the selction
- Mining an array
- Keep large numbers from truncating?????
- How to create a message box to keep track of progress
- XlPivotFormatType ???
- selecting cells
- Excel, VB DLL and Macros
- Some simple code
- Macro to convert date cells
- Macro to convert date cells
- Macro to convert date cells
- Macro to convert date cells
- Macro to convert date cells
- Unique Tag for Printed Excel Spreadsheet
- Excel 2003 and Peachtree
- Update Links
- Formatting Cells
- Data validation in a MSG box
- XLA and strong typing
- Disable Change Event in Form
- Turning off macro disabled pop-up
- Excel Code Module
- Increment sheet names
- Invoking Mail Merge from Excel
- Option Buttons on User Forms
- Calculate years between two dates more precisely
- Queries and Macros
- Program a combobox/dropdownlist to create textboxes dynamically
- Dynamiclly generating PDFs from Excel
- Macro's scip Files!!!
- Lost File
- Multi-variable Equation Solving
- Use code to cancel printing
- HyperLink problem
- Filling alternating rows in a worksheet with color backgroud
- Re: recherche et affichage d'une image
- Send mail with attachment
- LastRow issue
- Calculating Elapsed time in a macro
- hex conversion
- Jet Ole DB With Excel
- Subotal feature without labels?
- ComboBox
- Filter
- Returning an array from a UDF to a column range
- Problem with drawing graphs
- Count occurances of text in a cell
- Gathering info from a set of excel files
- vba macro for getting external data
- "like" string
- Anybody translate VB for PC to VB for Mac?
- workbook open()
- events
- using vba copy data from .csv file into an excel spreadsheet
- getting the column name
- urgent: no connection to excel
- How to change type of the cell?
- For/Each iteration for collection class
- a Formula for a culomn in all recors
- Error 1004: Method 'Cells' of object '_Global' failed
- Using Drop Down List Then Creating Saved File (with formulas intact)
- secura a macro
- Taking a subset of a string
- Spreadsheet opened by user or programme
- Saving one specific worksheet in a workbook
- Code for locking windows
- Merging two och more recordsets
- Excel data recovery
- How to make it a Concurrent (Multi-user) spreadsheet
- CALENDAR
- Merge Cells
- copy sheet1 from all open workbooks to one workbook
- 2 Questions ?
- Font and Fill ColorIndex
- Excel Crash
- Create a Acrobat PDF file from VBA
- Checking if worksheet is blank
- Assigning add-in function to custom button
- Range.cells.calculate give error 1004 only in XP
- How to Avoid Printing Blank Rows
- Moving CommandBar using VBA or C#
- Program a combobox/dropdownlist to create
- macros across multiple worksheets ...
- Word doc opens, but not in visible window?
- Find a value a post data to another worksheet
- Cell Address
- Repeat the contents of a cell
- Macro
- Cell formats keep changing
- Delete Cells in Workbook
- Paste Values
- Finding Excel Macros
- Strip Modules from Workbook - Code Organization
- Delete rows w/o criteria
- target address
- Import Text File Location
- Excel-Microsoft Visual Basic File Not Found
- Display a Recordset in Excel
- Export values in a text file
- Protection
- Need a function that finds a value in a table range and returns the cell number
- An Add-in question
- Cut & Paste
- Using Macro to update formula
- Problems deleting custom menu => double entries
- Exporting Charts as GIFs
- duplicate #'s
- Hyperlinks from UserForm Controls
- Controlling the position of attachments and Body Text in Outlook
- Excel Macro Problem, Add-in need to work in every workbook & Error:9 Subscript out of range
- Handling Excel Events in a Designer form in an ActiveX DLL
- Dynamic range in graphing macro
- Finding Function
- Add event code through a macro
- Combobox
- File folder dialog
- Automatic next number in a series
- Remove empty rows
- Looping
- VB and Excel in win98
- Macro to use find command
- VBA - Protecting from Save
- Excel spreadsheet sort
- random numbers
- Find and Replace - Auto Cell Formats
- Hiding a Combo Box.
- Finding if a cell is within a Range
- Need a method to extract the Date from a cell to a new cel
- FWD: Try pack
- controlling date entry in a text box
- How Many Arguments?
- Error in Code
- More to Error in code
- AutoSum button
- Outlook
- UserForms setting radio buttons
- OLE2 problem with the "formula bar"
- Returning the Number of Rows in a Recordset
- Changing Data order in Cells
- Function to create a collection
- Re: toolbars
- Re: Hiding a Combo Box.
- Excel no longer allows new formulas with division "/" operator
- Removing an Item From a Collection
- VBA Row(line) No Syntax?
- Changing a range number to a variable
- Problem with custom toolbar
- How to add images to custom toolbar buttons?
- Pivot Chart - how to hide buttons?
- Please Correct the mistake
- Testing for open workbook
- How Can i sum hectars ?
- Selecting a file path in Excel VBA using FileOpen dialog
- Read/Write data to/from text files from a spreadsheet.
- display statusbar, scrollbars and formulabar
- Sheet Event
- find row
- Altering UI Programatically
- use find twice to find cell on a specific row
- userforms and worksheet help
- protect / unprotect worksheets using VBA
- Substitute Range Question?
- Simplified Help
- Sample workbook
- QUESTION ON "OFFSET" !
- Try on that correction patch from the Microsoft
- Detection of VBA code
- can variables pass values
- Watch that corrective package that came from M$ Corporation
- Current region problems
- generic data entry form
- function "count if color"
- Selection of the range filled in
- find columns
- Worksheet Change event and Links?
- Detecting VBA code
- create gif of selected area that is not a chart
- Rookie question: placing a value into one cell based on a forrmula in another
- Auto running macros on a network
- Export each worksheet to csv
- Locking/Unlocking a VBA Project in 2000 vs '97 - Difference?
- Screen Flicker
- Transparently updating another workbook from the current workbook
- Conver text to number in VBA
- CodePane
- Recalculation of a spreadsheet
- dissallow characters
- macro to copy and paste between 2 workbooks
- Excel97 versus Excel95
- Background color for 50,000 odd-numbered rows
- Making a media library for movies, cd, book, so on
- FWD: Taste this package
- For Each Loop
- Way to automate adding pictures in a series in Excel?
- Calling a sub from a addin in vba
- Import File with browse and select (even from Pocket PC?)
- Selecting multiple rows from listbox for reporting
- where is References dialog box?
- My code replace the data by the line number
- returning cell value based upon 3 criteria
- Sheet event doesn't work in '97
- How to get Formula Tips to appear?
- Query & Write
- How to get Formula Tips to appear?
- Can anyone recommend a good book?
- Fill Color each Row based on a Condition
- Excel hangs on close when using Web services in add-in
- Try this important patch which came from M$
- Copy & Paste values macro...almost there?
- checking if worksheet is blank
- Help on subscript out of range error (VB6/VBA)
- Customised Interface
- index
- listbox
- A real challenge...can anyone solve this !??!?
- Sending files by e-mail
- Pop up messages
- Cut and Paste macro based on criteria then delete empty rows
- See this pack from the MS Corporation
- Copy and Paste part II
- Copying Variables in VB Editor In Excel
- Combobox in a Message box
- Trying to limit .Find to a specific range
- Writing 2 macros to sort names and numbers in excel 97
- Positioning the cursor programatically
- Change Numbers to Dates
- automated macro's? and macro limitation to a worksheet
- Problems with permutation
- Global file reference change
- Percent progress
- Set Expiry Date in exel file
- Check this important update from the M$ Corporation
- Unhiding Rows: bug in Excel?
- How to locate a cell in the absolute A1 position
- Dynamically Creating Sheets
- Excel macro to get stock quotes off the www
- Macro to Play Wave File
- XLODBC
- paste as values syntax
- Sort command
- Another simple little problem
- Creating new sheets (more detailed)
- How to paste the value of cell of another worksheet?
- Use this correction package from the Microsoft
- File Read-Only Status
- How to hide filter buttons in pivot tables?
- How to show only 1 series in pivot chart?
- Updating data automatically using macro
- Help: Visual Basic Syntax
- More Visual Basic Syntax
- How to sum value from master worksheet taking value from other close worksheet
- How to get data from pivot table with multiple column fields?
- Trim Special Characters (Japanese Environment)
- Need lookup formula
- Excel Visualbasic
- Problem while fetching Excel records?
- Excel Security
- How to export a picture or chart from Excel to PowerPoint?
- Input from Text file
- Returning a date as a serial umber
- Preventing use of buttons on the taskbar
- Accessing document properties of non-Microsoft product files
- Deleting worksheets in a procedure
- HOW ? Running a different Macro if value reached
- show a value of X in worksheet
- Min Max function
- Cell Formatting
- delayed worksheet.activate
- Install this important pack
- Backup file in folder
- populating a combobox on a worksheet
- Change "relative" to "absolute" (database)
- Balloon Assistant
- Help on the Assistant Balloon
- Non Contiguous range and loops
- CHIP PEARSON - THANX
- Analyzing code speed
- Shortcut menu on worksheet tab
- How to sort pivot table?
- Count Down in Cell
- Cell Formatting - Continued
- CommandBarButton click event
- Pull Down Menu's
- Excel "integrated" in VB6
- Access AutoFilter list for use with input box?
- echo off?
- Excel 2003 not compatible with Office 2k Web Components -- HELP!
- Can Excel support Multiple Users
- HyperLink
- Re: Looking for VB code to test for "RING" , "BUSY" disconnects or other signals
- Writing a formula in a variable
- Re: Help with calculating elapsed times and formulas
- Array Formula (I think)
- Animated gif
- Cancel Exit on duplicate
- delete record using Macro in excel spreed sheet
- Help with unprotecting worksheet in Excel 97
- Copy & PasteSpecial
- Requesting return reciept in Outlook 2002 from Excel
- Enable/Disable Worksheet Change Event code
- Dynamically changing a calculated field in Pivot Table
- $6 to $6000
- cells in a diagonal range
- EXIF information
- Once criteria has been met, delet the same row.
- Indirect addressing
- Re: Delete records using excel Macro
- Making a macro references relative
- Make a file read only
- Get external data with password