- Delete rows in Excel file with macros
- add valuew to new sheet depens on month
- Problem with IsEmpty Function
- macro to input data
- Dr Watson Error on opening file with VBA
- Re: rng(1,1) syntax doesn't work for set rng = arange.columns(1)
- Excel Versions
- Re: How can I delete the end of line (result of shift-enter)
- Counting rows in AutoFilter mode
- Formatting a cell
- importing data from MySQL
- summing up hours
- Formatting a cell
- Re: Select
- Formatting a cell
- Close explorer window from excel VBA
- Access Custom outlook Forms from within Excel VBA
- Programming a processor
- Deleting Calculated Fields from Pivot Tables
- autowrite a cell depending on another cell's content
- Read variables from external file
- Combobox Change Event when file is saved as
- Copy/Paste Problem
- Distributing Excel Applications
- multiple selection problem
- CVErr, Excel and VB .NET
- Links
- unprotect more than one password in macro
- Use the important patch from the MS
- Turning off Screen Refresh
- How to hide and unhide rows
- Copy a value to a range of cells
- auto save-as from external inputs
- Getting rid of workbook
- VBA : A picture from http://.../Image.gif
- Persistent Excel toolbar
- Search and Replace...
- Get the integer valure from the current date
- Copy/Paste Problem
- PROGRESS INDICATOR
- Re: Creating a list of found files
- Re: adding button for add-in
- error 424 - Object Required
- Is there any opensource lib/tool to convert excel to text ?
- VB Code
- Several comboBoxes on a Userform
- Re: Search and Replace...
- Re: Search and Replace...
- how do I get " 1st" to look proper (superscript the "st")
- Try the security package which comes from Microsoft Corp.
- Re: Bi-Directional Cell Linking
- Worksheet event for tick box
- Re: Bi-Directional Cell Linking
- 2000 to XP VBA problems?
- VB Script help
- I Tried it, still problem...
- Using Named Ranges in VB
- select a1 on all sheets
- New Excel 2003
- formula
- DDE Server
- define end column in a range
- Undo Procedure
- Filling a listbox depending on font index
- Excel 2000/VB
- reference excel in frames?
- Run Time Error 9, Script Out of Range
- User Forms
- Re: Pop up Box
- Looking for Cell_Change Event
- Designate a folder as the root of the Browse tree
- Re: adding button for add-in
- Variable Control Names
- Count of non-blank cells.
- Blinking Text
- Tab between Text Boxes no longer working
- Delete the code in ThisWorkbook
- insert rows
- Looking for Excel VBA Example
- combo box error-not enough resources
- Test
- Nested loop with ranking
- Re: Dropping lowest 2 values
- How can I tell if a worksheet exists?
- random VBA errors
- Re: Can't get connection string right
- Print non-XL file
- Macro Won't Copy/Paste
- Macro Won't Copy/Paste
- Disabling Sheet Code
- XIRR Add-ins
- Referencing two columns for data
- Deleting a row with 0 in column A
- Run time Error -2147352571 when showing a form
- Define Excel Addin programatically
- Check out this corrective patch from the M$ Corporation
- How to remove an add-in
- ASCII value
- when opening a text file....
- Listbox text property not working correctly
- Using a macro to perform a TASK on another workbook
- Extracting Data from MS Outlook Mail Messages
- FW: Apply that update
- slow program in a loop
- mscal problem
- maximum sheets in a book
- us IF statements
- Msgbox shared workbook
- text comparision
- FWD: Check these critical patch from the Microsoft Corp.
- Command: Data, Form
- Print excel sheet in one page
- Count to hide
- template button network wide
- DOS Command Line
- Renaming Problems
- Selective call procedure
- Page Object property
- Perform Lookup and delete non matching rows?
- Application Error when running Macro on Workbook open
- how to rm the "extra row"?
- worksheet Name and (Name) properties
- Activeworkbook.sendmail
- Create ListBox (?) same as Find all Result List
- Password prompt for acessing a workbook
- Excel sheet always open up `behind` other sheets.
- Call macros from another XL file
- Locking project
- Userform shadows
- Unable to set the colorIndex Property of the Interior Class Error
- Error Msg Deactivating Code
- Sharing Workbook caused error message
- Sorting sheets
- Waiting for app to complete OLE action
- Keypressed function
- Files visible or not...
- Excel VBA code executing a variable as a Sub.
- VBA will invole .net?
- Calling macros from another XL Workbook
- Auto enter data
- Loading data from a huge access database
- Get External Data
- Opening an excel 2000 workbook in C#
- Best way to get data out of SQL Server
- if macro
- Formula excluding #N/A
- Help, there must be a better way!
- Re: Custom shading colors
- Re: Set or not to Set
- Pivot Values
- Create Data base
- Re: print area mising last row
- Adding to a Pivot
- Re: Set or not to Set
- Extracting links from images
- Show Dialog Box - Edit/Replace
- Re: ComboBox with Dates
- Excel to SQl 7
- Formatting a cell in Excel, using pure VB code
- Just a question regarding a formula operator.
- Can I use a User-Defined Funcion in a Conditional Format formula?
- Best way to add info to a SQL database from Excel
- Save Event - Determine if called by code or user
- Re: Removing/restoring menubar in a macro
- How would I do the following? A little complicated in detail...but I don't think to difficult...
- Help needed
- Adding catagory %'s in a Pivot
- Custom Cell Formatting
- Re: Removing/restoring menubar in a macro
- I need help w/ a formula
- default (startup) window size
- copy all worksheet data into a new worksheet
- Excel open an existing MS Query in edit mode via macro attached to a button.
- Question on "GetFile" command
- Retaining column formatting
- Converting CSV text in a single column, into multiple columns
- Cut and paste to Outlook using a macro
- RE: Check out this correction pack from the MS Corp.
- Shortcuts keys sometimes don't work
- FW: Taste corrective package from the MS
- Prove this correction package
- PDFing an Excel Workbook
- XML to Excel 97
- Parsing values into ranges
- Expert help needed
- Tab delimited or not?
- Printing a list of all named ranges
- Pass a variable from a class module
- Pivottable total cloumns
- Close worksheet with Macro or Code
- HOW DO I GET CURRENT ROW & COL INFO?
- code to change activecell
- Class modules
- Re: Set intersection on Excel spreadsheet?
- Web page loading
- Tab stopped working
- Writing values to Web Forms
- VBA and Regular expressions
- Can't Get data without including Header using ADO
- Add-ins missing
- Bloomberg DDE problem
- Converting to macro
- Flipping Cell Data Horizontal/Vertical
- Help within user defined function
- combo box
- HOW TO STORE CURRENT COLUMN & ROW
- Refresh link automatic
- Calendar object in Excel problem - mscal.ocx
- Re: Custom Cell Formatting
- How to find what object type is returned from Selection property ?
- How To Use A Custom Help File With Excel 2000 Forms
- Message Window to tell user "Macro Running"
- Open delimited text file to excel without changing data in that file
- Protecting Sheets
- Strange problem
- A Couple of Macro Questions
- FWD: Install this critical update from the MS Corporation
- Help with formula!!!
- Multi-sheet linking
- Duplex Printing
- Auto_add not called, but not found error occurs
- Trying to generate mutiple list for one
- Re: "Weighting" sub
- Creating Named Ranges in VBA
- Error handling
- Re-Arranging a Block of Data
- placing a pull-down menu at a cell location automatically
- Where can similar macro template / sample be found?
- FW: Install this critical package
- .SpecialCells(xlLastCell).Select
- ComboBox
- i'm stuck with an excel qujitting problem
- FW: Try on that internet patch from the MS Corp.
- treeview add nodes
- Keypressed?
- Assign Unique Number to an Excel Template
- Automatic startup of an excel macro
- Simple INT error?
- Treeview
- How to escape this error message
- Hopefully simple Select Case error
- Use this corrective patch
- English VBA not working on PC running French Excel
- Remove VB Module from workbook
- call sub
- remote refrences
- Maximim download file size into Excel 2000
- control toolbox elements
- Copying a range to clipboard
- get data in sequence
- Sheetname variable
- show password like *** while entering it
- Populating a lis/combo box in excel with access data
- Find
- Comparing value to list
- how to copy and paste cell as a value.
- Repost - rank in if loops!
- Activesheet.Scrollarea
- Excel 4.0 Macros
- Find - Sorry - Please see this
- DateTime Format
- Multidimensional Array problem I can't solve ! Please help me out !
- Use critical update
- Sheet protection
- Error 'Too many different cell format'
- excel not being released by vb.net
- if statement
- Illegal Operation
- Extracting Data
- match #n/a problem
- Columns in Full Outer Joins
- Investing in stocks
- Help please on a simple macro to insert rows
- Referencing Sheet Names In Formula
- default (start-up) window size
- what's wrong with custom function?
- combo box selection disappearance
- Merging Worksheets
- Dynamic Array as pivot table SourceData..?
- help with create spreadsheet programmatically
- Need help displaying array contents
- Writing Macro
- automating chart generation from text files
- Wheeling
- RE: Apply these pack that comes from the Microsoft
- Hiding sheets in Excel
- How to hide all the actions while a macro is running
- How to check cells in a range for a value
- XML problems
- Split text in a column to multiple columns
- How to save Excel files which have passwords
- call stack question
- importing data from Access...
- Creating a link to a excel CELL
- Converting a range to string
- Excel chart, right scale
- Macro Coding
- tabbing through ActiveX controls on worksheet
- Import HTML reports into Excel with page formatting options
- selecting multiple rows
- excel spreadsheet has little bits of embedded code in it ? help needed
- FWD: Taste that patch from the MS
- name of the activesheet
- Repost - How to save Excel files which have passwords
- Inserting Lines
- Highlight all cells, except top row?
- hiding names
- Returning to a previous location
- Excel Queries Against Multiple Databases
- File Searches
- Shape connectors
- Slow enter on sheet
- Code/Messages for User Control
- Is a visible workbook open?
- [ANN]: NNTP Server slowdowns
- Install that important patch that came from M$ Corporation
- Prove security update
- who can't convert one number y number word
- Combo Box
- Array UDF
- Cell References and Looping
- Problem with private sub
- Update Master records -- Array question?
- Compare Generations
- copy printarea from more than 3 sheet & save in new book.
- Selecting the end of a range
- Try on this critical patch from M$ Corporation
- UserForm Caption
- button gets named range
- Protecting merged cells
- UserForm Controls References
- Prove this package
- RE: Look at correction package from the Microsoft Corp.
- Batch Files
- Need Help with Code - TimeValue
- Input Cell
- Prove this internet pack
- DATES
- "NCOMPLETE CALCULATION"message
- API Calls - EXAMPLES needed
- Sheet Update Problem
- Perform action when cell is clicked
- Add Comments with Text From Cells
- Can an add-in macro update a worksheets Worksheet_Change function?
- Check this correction update which came from MS Corp.
- Look at this correction package which came from the MS Corp.
- creating a SPIRAL of stars in Excel
- Is there a way?
- RE: Look at these security update for Microsoft Windows
- How can I format text pased directly from clipboard to appear in correct cells
- Tool tips on UDF
- Some Help Please anyone
- Watch this security package
- How to Monitor a change in a formula's result?
- Logbook generates runtime error 438 on another network computer
- Change File Name Warning
- Pivot Table
- How to replace PivotTable data fields...?
- Excel compare and create
- CODE TO ADD TWO COLUMNS BASED ON ANOTHER
- Multi-columns in a ListBox
- Use these update for Windows
- saving in CSV format ... every 10 seconds
- Set cell formulas using code? how?
- Comments with text from cells
- Defining Range Extent
- Plse Advice
- Plse Help To Reduce
- CalculatedFields in Pivots
- programmaticly change code
- Input box/form
- Suggestions - New Version of Template
- How to count in between gap?
- Macros - stepping left in a macro
- Trapping an attempt to use a custom menu
- opening and write to a text file in excel
- Check out these security patch
- OnKey for Alt f not overriding standard use of Alt-F
- Taste this corrective update from Microsoft
- Try on these correction patch
- Newbie : Autofilter thru code ?
- Help needed with FIND routine.
- fixed save as name?
- help from Tom O
- save as event
- increase date by month
- Web connect very slow in ExcelXP
- AutoFilter - which rows are currently visible?
- Clear Empty Strings
- Controlling image filenames during "Save As Webpage" ...
- Copy and Paste Cells
- How to make the data in a cell blink?
- Excell macro Date help
- waiting for data refresh before continuing VBA sub
- Replacing 0 with blank
- URGENT - NEED EXCEL PROGRAMMER - AUTOMATE THE TITLES IN MY EXCEL GRAPHS
- replacing 0 with blank
- Digital Signature
- Custom menus and toolbar text and icons
- Excel VBA programming book recommendation?
- Use the corrective patch from the Microsoft
- refreshing custom function
- avoid div by zero
- Email from within Excel
- Multi-line cell text content saved in XML
- Protect data in cell from viewing it
- Apply the corrective patch
- test for key press
- THANKS
- Setting Read Only on save.
- Links to Other Worksheet
- resolving reference - Range of what?
- Worksheet Exists...
- Accessing com ports through Excel97?
- Export Shape as gif or bmp?
- New excel sheet
- Unique ID number generation
- event which occurs when a TextBox receives focus
- Taste this patch from the Microsoft Corporation
- Translating Column Addresses into number/integer
- VBA formulas in javascript
- Numéro ligne courante
- Limit search on visible cells only
- Creating a SPIRAL of stars in Excel
- Stumped Again
- Please Help with Excel Sorting Macro!!
- Replicating rows in other worksheets (based on content)
- Re: Formula for converting currency
- Re: Formula for converting currency
- open excel file with cell highlighted
- how to check recordset object exist ?
- Worksheetfunction MATCH
- How to make an Excell-sheet un-usable!
- How to move around in the "refers to" box?
- y=f(x)
- how to programming Excel in C#
- Re: The XLS file is huge!
- FWD: Prove correction patch
- Re: The XLS file is huge!
- Simple change ?
- How to disable macros?
- Help with Macro for Zooming when cells have Comments?
- Formula Help Needed
- Take a look at this important pack from Microsoft Corporation
- how to open excel using regedit?
- Setting form controls focus and enter key
- Re: Pivot Table Refresh VBA Event
- Install the internet pack
- Re: Recalculating block of cells
- calculating two strings
- How to hide Excel window when activating a Shape object
- Send Mail, Excel 2002 VBA ArrrrrrGH
- Display many instances of the same form
- Automatically Enabling Macros
- running a macro by a click
- Re: Copy and paste in VBA
- macro to autofill formula?
- FW: Check out the package
- Creating macro code in Excel
- HyperLinks active in a FormControl
- I need help index/match
- Use this security update
- Inputting data through a VBA input box
- Adding New Woıkbook with a specific name
- Using a macro to make selection in a drop down menu
- date to text formatting
- xl97 delete phantom pgBreaks in VBA?
- TextBox props
- Inserting a chart instead of text into comment box
- A Borders question
- Excel Hyperlink Macro
- Last Password
- paint row in MSFlexGrid
- Serach sequence for referenced files
- copy and delete command button
- Add rows if a cell meets a certain requirement
- OLAP Cubes
- Recover VBA code from corrupted .xls file?
- Try this correction package from the MS
- Macros and Hotkeys
- ODBC Call failed Error 3146 only on some PC's
- Printing Envelopes
- Hiding Rows in Excel with VBA
- Deleting Invalid Links
- Find and Copy ?
- Dir problems
- Combination of user defined fucntion and row() function, doesn't seem to work?
- calculate/concert long/integer to date time
- Help please assigning column and rows
- conditional formater with more then 3 levels?
- Disable Key Events
- Code to automatically turn on and turn off Track Changes
- Inserting data in cells
- inputbox
- Re: Setting worksheet protection password in VBA
- RTD Example in C#
- Cells disappear when I start to enter a formula
- two-condition loop
- UserForm with Cell Data
- Excell File to Text File
- VB project locked and unviewable
- Re: Run Time 31032
- Re: Excel programming using VBA
- matching random text
- A question about decoding, substitute or vlookup of character.
- How to terminate a condition (IF) at its first occurance?
- Populate Userform text boxes in VBA with VLookup data from #2 worksheet
- Email from within Excel only 1 sheet of workbook
- URGENT - NEED PRO EXCEL PROGRAMMER - TO AUTOMATICALLY CHANGE TITLES IN EXCEL CHARTS
- Excel 2000 vs. XP
- Inserting Rows Through a Macro
- how to make a multipage with many pages all of which can be seen easily.
- Class module to detect row deletion or insertion ?
- home delivery db
- invoke macro from outside excel - auto macros
- Compare tabs using Double Lookup, in VB code
- Function to detect if Sheet is protected
- sumif
- Compile Error when loading excel over intranet
- RE: Install the corrective pack from the Microsoft Corporation
- AutoExec
- Convert Date to String
- ListBox ColumnHeads
- Detecting Selected WorkSheet
- Watch these important pack
- one problem in excel
- many to one
- Web Form - Excel Linking
- Custom button and macro function
- adding strings
- Take a look at correction pack from MS Corp.
- Formula Syntax
- Take a look at that critical patch
- Grading System
- Excel 97 VBA: Multipage set focus method
- Macro Copy/Paste Help
- Before and after combo box change
- "Go ahead and replace file" command?
- Find nth and nth + 1 values in a column
- Event for conditional formatting?
- How to show External Data Options form
- Selecting x cells to the left of the one you are on
- minimum # of variables
- slow macro execution
- Finding Unique Values from Multiple Columns
- Manage a new instance of a form
- Check important pack
- Changing to Landscape mode automatically
- TextBox refusal
- Worksheets and SQL
- Re: Opening text file in Excel through macro
- Adding Checkboxes Programmatically
- Re: Opening text file in Excel through macro
- Closing workbooks through macro
- Re: Opening text file in Excel through macro
- even numbers
- Watch internet patch that comes from the Microsoft
- looping through all checkbox's in a userform
- Replacing modules w/password
- OLE Container Control in VB.NET
- Macro for updating links
- Click on Image Control disables it
- Handling Errors from Worksheet Functions
- page control & sub-totals
- Re: Start a macro from a specific line while editing
- Sheets Linking
- Macro name as constant
- Q: A faster way to do lookups
- Selecting drawing objects or shapes in a macro
- Apply that important pack from MS
- Adding button dynamically
- How? Macro to copy range to new worksheet, name new worksheet, loop
- Selecing a picture in VBA
- Toggle subtotals...
- UserForm not hiding
- Re: Subscript our of range when activating a worksheet
- Code Tweek Needed
- specialcells(xlcelltypeblanks)
- Summing Cells and Formatting
- Macro Button Not working on Conversion from 97 to 2002
- Summing a column in a macro
- Error handling
- How to create a Bell Curve chart
- Copying text only if the cell is not empty
- Whose error: mine or Excel's?
- Memorizing current outline
- Am I Stupid? or is the rowsource ignoring me?
- Name a range dynamically
- Disabling external data refresh using vba
- Pre-pending and post-pending cell data in Excel
- Q: Is this vlookup statement efficient?
- Worksheet ComboBox not droping on cue.
- How to pass arguments from ThisWorkbook to a UserForm
- Active X frame on worksheet
- AddIn Default Path - Moving Spreadsheed between Users/Computers
- Need help to finish function....
- Return two mid functions as one string.
- Files in File|New dialog
- A Question on User Defined Functions.
- VBA Memory jog!
- Run-time error 424
- adding a list validation to a cell
- VBA project instability
- Creating a NUL Cell
- Resource Monitor
- Help with a macro
- Protected cell error - Excel XP & Win98
- Custom Function interfering with vba
- Names and References
- dockable form in excel using VBA
- button to execute macro
- range name nonadjacent cells
- Viewing Recordset in SQL help please
- Advanced Filtering in VBA
- vba code needed for date
- Rob Bovey's Code Cleaner makes file larger. Why?
- VBA equivalent to "Return/Enter" Key
- Copy Sheets minus Worksheet Change Event code & Macro Buttons
- Help with a formula
- Student Absentee List help please
- Re: Resetting Menu Bars in Visual Basic
- How to convert sunrise and sunset table to hours and minutes
- Scrollable list box demo now handles multipage controls
- Project is unviewable
- Limit on number of embedded controls in a workbook?
- Create Excel sheet in HTML with comments
- Form Update before ProcRuns
- FW: Watch internet update
- Returning Two Values From Each Worksheet
- Test a String to see if it begins with a Number
- Total Newbie Needs Help
- Print a Form
- Disable Macro Problem
- Preventing someone from unhiding a sheet
- System Registry
- Cancelling Safe Mode Programatically
- Display unicode characters in non-English windows
- Getting active cell address
- Excel
- ActiveCell.End(xlDown).Select not working consistently
- Disable Button
- Macro that asks for password
- FWD: Check out the critical pack which came from the Microsoft Corp.
- Automatic calculation of user-defined worksheet function
- Using a formula to creat a cleared or nul cell
- Access records updating from Excel.
- merge cells and save as .txt file
- Select sheet
- macro to sum an unknown range
- Misshapen controls on Tablet PC
- Excel Web Automation
- Closing Dataform automatically
- LisBox List
- Listbox does not support saving
- Macro to add data
- Install these patch for MS Windows
- Killing Excel :)
- A simple 'If...Then...' code needed?
- XLapp and SheetChange
- Sheet Position
- Automation Error with Excel 97 in Windows 2000 with patch blaster
- No of columns in range
- QueryTables
- How BEEP on internal speakers, not on sound-card?
- interactive vba
- Extracting and Writing
- Macro to modify a Macro?
- Auto Hide Pivot Table Items
- file automatically adding hyperlinks
- Excel print macro error
- forms
- Excel graphing
- Time Based Progress Indicator??
- e-mailing a file from vba
- Password / Spreadsheet saved as HTML
- How to move worksheet from vbscript
- Conditional Formatting in Pivot Tables
- Re: Date Programming
- Clipboard contents
- Pop up window in excel.
- Prohibit seeing/modifying VB code
- Spawning Excel maximized with VB
- New workbook - automatically insert header
- how to start a flash SWF file from within Excel
- Designing web pages for Excel Web Queries
- need script help
- conditional macro links
- Protected sheets and Drop Downs
- Date Autofill --weird!
- Simple (?) formula
- merge cells marco "help"
- Error 2029, Named Ranges, Unseen Cell Values
- Run Macro from a Control Button and linking to AddIn's
- Macro to input formula in range based on another range
- john
- Can not insert object error
- Max Date
- Toggle True/False in a cell
- OLE excel.application starts w/ no menu
- Error in DialogSheets
- DoCmd
- Q: Better syntax to cycle through elements of an array?
- > two filter conditions
- Custom File Types
- Query Table problem
- looping through worksheets from addin
- Execute macro when chart is created
- excel help please
- Times question
- error 800a01a8
- preventing disabling of macros
- Switching to different worksheets during a macro
- Fro Each Next Loop Troubles
- using Evaluate on a Name object?
- pass parameters to MS Query
- Enabling checkboxes in a listbox control
- obtain value from a closed workbook.xls
- Deleting a shape and the cell contents the shape is in.
- In addition to previous question, if opening an Excel file in NON-read-only mode, would the macros on the worksheets work as well?
- How to select range of values in pivot table?
- Full Screen Splash Page... Please
- Copy Data (Sheet2 to Sheet1) Updates Web Query
- Automatically select range and copy to new sheet
- RE: Check this correction update
- Insert Picture to Excel to specified range
- How to use Excel C API to load an XLL add-in?
- Listbox
- Look at these important pack for Microsoft Windows
- Compare tabs using Double Lookup, in VB code
- back-end update excel file macro
- VBA: Error displaying special characters
- countif
- checking office (excel) verion from VB
- FWD: Prove these internet package which comes from the MS
- formula help the sequel
- how to change F-BASIC V6.0 source to vba
- ListBox List Code?
- GetopenFilename default path
- Freeing memory problem
- List boxes
- Excel 2000 and filter feature in a protected workbook
- Prove this patch from the M$ Corporation
- Function Call
- Newbie's macro doesn't appear to work!
- conditional macros
- Removing macro buttons from part of a sheet
- Random Numbers
- ASPX can't change PageSetup property of Chart
- Macros to compute Sales figures Differences between Months
- Reduce or Minimize Excel files using PivotTables! Help Please!