- Creating sub menu in Command bar
- Button to websight?
- YIELD at par price not equal to Coupon Rate?
- Searching and displaying the result using VBA
- why it doesn't work?
- Screen Res change macro leaves me in VB Editor instead of workshee
- calculation on excel
- VLookUp in Macro not compiling
- Removing Smart tags
- executable to install macro into personal.xls
- Interactive Chart/ "Method Cells of object '_global' failed"
- Can anyone help? Please?
- Image Controls
- input box
- Grab name of folder
- function to return days
- Multiple checkboxes, one macro?
- Error Handling
- Worksheet wide vars
- Declare API call to Windows GetFile
- VBA to hide a column and unhide it
- VBA to rename sheet WITHIN Excel
- SelectionChange event
- xlVisibleCellsOnly Help to copy only Visible Cells/Rows
- Transpose data
- assign onkey to 1 worksheet
- Web Queries
- VBA Password forget
- Arrange and Tiled
- click data point in chart and delete
- VBA running VERY slow
- Arrggh! If help
- Opening linked spreadsheet file in Access
- Worksheet_Change not throwed when adding a row
- For Each statement
- Automating Access / Excel with batch file
- Get the path to the directory that the active workbook is in
- when setting Imagelist for ImageCombot, Excel crash
- Dynamic conditional formatting
- Location of "My Documents"
- Visual basic unlock "SORT" function in an EXCEL spreadsheet
- increment cell reference whilst reading numeric contents
- Deleting sheets without confirmation
- Setting Property Values of Text Boxes within Forms
- Can VBA be used to list macros
- Interesting Code
- Using a macro to remove a macro
- EnableItemSelction on Page Field in 2003 VBA not working
- clearing unlocked fields on a protected sheet
- Copying worksheets to remainder of workbook
- Changing Phone Number Formats
- Subroutine question and public variables
- Array questions
- Using the ENTER key to move between form fields?
- finding the source location of a result
- global function
- Sharing WBs with Macros
- Compile Error: Strange happening
- refering to a workbook name within vba
- Saving Excel VBA code to Personal.xls
- Macro to Count Rows
- Not Book.xlt
- UDF argument problem
- Invalid property value.
- If/Then with Dates
- digitally signing excel doc
- To find number of non-empty cells across columns
- YAQ (Yet another question)
- Excel as a dabatase, please help
- VBA Macro to copy an column from one Excel file into another file
- send email in VBA
- links question
- REPEAT SOME ACTION IN MACRO
- Print in continous serials from a Sheet
- loop macro
- break excel links
- Where is the Worksheet_Delete event?
- Retrieving list of worksheets programmatically
- VBA code disappeared when open workbook in other computer
- "Processing" Pop up box
- Download .png
- Access to Office
- Data from web site
- Workshoot Menu Bar Hijacked!!
- Data from web page
- Create a dynamic chart with code
- Macro to Change a Range
- How to prevent deleting certain rows
- Simple IF statement
- How to make Hyperlink jump accordingly
- No duplicates from range to an array
- vba to edit outlook contacts from cell entry
- Change cell format based on condition.
- Add new vaue to a different sheet
- .find with merged cell not working
- Input Box Processing troubles
- Insert date automatically
- networking
- Custom Functions in Personal.XLS
- how to check if range contains particular word
- Help with Error Messages
- Deleting all buttons in a collection
- Open File Dialog Box
- MultiPage Component Property
- Bypassing File Version Dialog on Save
- source of good vba examples for newbie
- Openning a file using the password from VBA
- Re: Shade col. up to used cell
- Populating a listbox from range xl2003
- Bypass an
- MOVE Worksheet to another workbook ?
- help needed with LOOPS please
- command button()_click
- Larger Number
- does code for this exist? help please
- How do I add a number according to a specific condition ?
- How to compare the contents of two rows is the same?
- Is it possible with my chart?
- Opening files
- Run-time error '13':Type mismatch
- Historical Stock Quotes - Yahoo Finance
- Fast Consolidation
- Correct syntax for Active Worksheet
- Select case
- listbox remove Item
- surpress zero-values in specifi columns (not complete workbook/window)
- Searching for files that contain ???
- Storing the results of a list box
- Deactivate Events not Firing
- Message Box
- Help: Excel 4 macro suddenly no longer working
- Sound Alarm when time expires
- Keypress
- Macro to insert formula result into range with zero values in cell
- hpagebreak and vpagebreak
- VBAProject
- How to remain formating in Pivot Table?
- It's not CommandBars("Cell"), right-click menu!
- No Macros but Macro enabling message
- Chart Area
- Replace application.RTD property by Application.RTDServers collect
- Using VBA to find the author of a workbook
- Can I assign a macro to each item in a drop-down list?
- This is easy for you people!
- Z-test using excel
- Find problem
- Simple column moving code needed
- how to calculate Standard deviation of product of numbers?
- Array error
- Adding a Control programatically
- Re-run solver when some inputs change
- What are my variables ... ?
- Updateing worksheets when openening workbook
- ideas - Query table refresh
- Run a dos batch file as soon as I exit/save the spreadsheet
- UDFs
- Deleting copies of a spreadsheet
- Writing saveing date in cell when saveing.
- Comparing date to string
- OnSheetChange or OnSheetCalculate Event Handler
- automatically open a spreadsheet for the current day's entry
- lookup functions?
- Clearing references?
- Outlook Address Properties > Excel
- Error changing protected cell
- Developing custom secure Excel add-ins
- "writing" to a range
- Efficiently Pausing VBA Execution.
- UserForm/If Help
- Quit
- Inexpecting slow execution when writing to .PageSetup.Leftfooter
- How to compare two columns for a specified string?
- Auto_Open/Workbook_Open subroutines showing SCREENUPDATING
- Using VBA to disable macros when opening files
- How to call a procedure when a cell value changes?
- prevent change sheet name
- OLEDB Error on Excel Macro
- MsgBox question
- Duplicate Lookup
- dataset to exel issue
- ComboBox Problem
- displaying selection data from a listbox
- Locate and Move Specific Cells
- Asking users to Enable Macro's
- Latitude/Longitude conversions in Excel - Please Help
- Programmer's Companion
- Help with macros
- overflow-how big a file can Excel handle?
- On Save Procedure Conumrum
- need help with hpagebreak
- not sure what functions/code to use?
- Runtime Error between Terminals
- Circle Reference
- Sorting a single column
- Changing data in footer in VBA
- Helo with excel marco
- Adding Time (hours and minutes)
- Changing ListFill in a shared WKB
- Problem with File.Search
- Program vb to do something in case of an error.
- In Excel my autofilter? is omitting some data rows from output
- Access/Excel data to compare and sum conditionally
- Listbox Help
- Non-blocking calls to Excel Macro using OLE Automation
- need some help combining a variable
- Problem with playing sound code
- Writing a Procedure to print non-contagious area on the smae page
- Matching
- exiting excel takes ages if any add-in loaded
- How to depress confirmation dailog
- Comment Box Adjustment
- Problem with calling .dll from excel VBA
- private variable: same module, other Sub/Function
- Select shape leading to Out of memory
- How to check for Bolded character is a text Box?
- Copying cells from one sheet to another if document has been saved.
- Running a macro outside of Excel
- VB code + Data Validation query
- VBA for charting
- Registration Key Sample Code
- Access query does not work in Excel
- deleting characters
- Software Expiration Code Sample
- Check relative / absolute references
- Adding Username and Password facility
- Excel vba script extremely slow
- Worksheet_Change and Application.undo
- Copy data from a worksheet
- Preserve Formating
- Bar of Pie chart - Need Bar creation
- Message box during data load
- sorting
- Path problem
- Problem with List Validation
- Demonstrating mouse clicks with Macro
- HEEEEEEEELP
- last cell plus one
- Choosing printer in a printing macro
- Choosing printer in a printing macro
- Excel Macro mousePointer control
- publish one (and only one) html file?
- Date formatting
- Data validation and application.volatile
- Why doesn't this work ?
- Using a formula result to reference a row
- Maximizing a workbook
- More help with setting print area to last entry in columns A thru AA and last entry in row 7
- Calculating Non-Constant Values in Cells
- Break-Even (or Payoff) with inflation factor
- updating cells which containing formulae via odbc
- Combo Box ListFillRange causing save prompt
- Date format
- Using excel through vbscript
- User form error when opened
- Macro Language
- ODBC/VBA?EXCEL and ORACLE database
- Highlight if ?
- Insert text into filename
- clear checkbox
- exponential increase
- copying from one file paste in another
- What's wrong with this picture??
- Am I missing something???
- worksheet calculate - how to run it line by line?
- Printing differant rows
- Automating data import and separation
- command button
- grouping
- Data source for Pivot Table
- formatting & programming
- exponential growth & Break-even
- count pages programmatically
- help
- Excel CreateObject on server
- selecting a range
- How use summation?
- Printing problem with amalgamated cells
- battleship code
- Find exact text?
- Delete records from 1 list that are in another?
- Help (cesar code)
- setting ScrollArea problem
- automatically copy values of worksheet into new workbook
- block variable not set?
- alert
- How do I set up a form that narrows a data set w/ each menu select
- Date Range problems
- Making a combo box user freindly
- List boxes
- Option Explicit
- Searching for a variable field
- Macro code to change tab name
- Was Delete Key pressed?
- Find red cell in macro
- Use a macro to create new sheets
- New Registration Key Generation
- trouble "locking" a portion of a formula..
- Array formula with AutoFilter
- Dynamically creating formatted tables from raw data
- Worksheets Exists Code...
- changing merged cells from code
- calculate commission $ based on total sold and commission percent
- Excel 97 error: 'Copy method of range class failed'
- Validating Dates
- ++HELP ME PLEASE++ ComboBoxes as a Variable to Select Sheets
- out of range error for range value
- Allow ONE checkbox selected in a group
- email help please!!
- Passing variable to Access
- Worksheet_Change Errors
- Print data in footer using _BeforePrint
- Copy cell macro
- How can one open a protected excel sheet whose password is lost?
- Automaion Addin not loading properly!!
- program drop down menus
- Chart: Use range name for source data
- On Error Resume Next
- Code works for any WBK except the PMW
- Office 2003 / UpDown Control
- Copy worksheet excluding defined name ranges
- Help with Mr. Peterson's Code.. Print serially from a Sheet
- Text selection macro problem
- Multi-conditional sum with VBA code ??
- How do I go to a specific column?
- Printing an entire workbook
- How to record macro for Solver in Excel?
- error handler not working correctly
- Changing footer programmatically in multiple sheets all at once
- vba excel help
- open excel spreadsheet with password
- Return to column A
- Special cells format
- create a discount function in excel
- ListtBox
- go
- forgot password
- how to insert a chart in a userform?
- forgot password
- Advanced Sorting\VBA Code
- Please help me
- Copy/paste from Excel to a password protected intranet application
- Excel User Conference - US Location
- Please Help
- Please Help
- Please Help
- Analysis Toolpak Translator - anyone got it?
- Analysis Toolpak Translator - Anyone got it???
- Best Technique to clone worksheet
- SLN - Straight Line Depreciation
- if numbers match then color row
- vba help...ranges in new sheet etc
- Lotus Macro
- Copy sheet without Code
- Cannot change part of a merged cell
- Submerged text in a sheet
- Scheduling application based on Excel
- Removing User name at Comment
- Excel 2003 - Update or Don't Update Links Problem
- Keeping Textbox Values After Reopening Userform
- Data Manipulation
- Assign a worksheet name to a variable
- set a column length
- Exclude cell from average calculation
- Changing Feild Color via value
- Macro - Modular fill function
- Search for worksheet
- Pain in the ass macro
- Extract a hyperlink from cell value
- Progress Bar
- hard coded text
- Weather data Sorting with formula
- How to set excel column width from visual C++ using COM automation?
- help with chart
- Multiple Cell Conditional Formatting
- Extracting (copying) modules from one workbook to another.
- multiple cell conditional formatting
- printing a receipt for eack row
- How to use a subroutine stored in an add-in
- Excel 2K3: Opening spreadsheet, also opens book1.xls?
- cant find a macro
- Macro Recorder
- Re: Incrementing times and dates
- How to display an open file?
- a new error message
- Printing same table on reverse side of all pages
- Trying to search web via macro - possible??
- Excel Error
- Paste Using CommandButton
- Excel VBA macros and real time data calculations
- debug.print range "full" address
- Simple +formula not reading value from the reference cell
- searching for a better way to hide rows
- I need a text box and can't find one
- Accessing controls in excel using vbscript
- Delete Non-bolded lines only
- Pivot table
- Send email from VBA
- Send Email from Macro VBA Excel
- Update multiple locations when changing a value on one worksheet
- Event macro firing twice
- Exporting embedded OLE objects to file
- form_unload problem
- Control Toolbox Controls keep resizing ??
- erroneous "save changes?" message appears
- NEXT LEVEL OF ScreenUpdating
- Excel XP SP3 and linked files prompt
- Macro to save Macros
- copy and paste to another sheet based in cell color
- Turning on/off the Hourglass pointer in Excel
- GetOleDbSchemaTable: Exclude named ranges from Excel
- Are there "GoTo/Jump" type of formulas to move between worksheets
- Weird clipboard behavior
- Problems setting Application.DefaultFilePath
- another chart question
- Can't 'SaveAs' Directly to Network Folder
- string concatenate
- 2005 Excel User Conference - Sept 16/17 - Ft Worth, Texas
- Spreadsheet Programming
- Need help with code for Excel Macro
- Flagging duplicates
- Search Macros in closed file
- Macro 2 Extract Data 2 Paste in New Wksht
- emailing worksheet
- VBE( Visual Basic Application)
- Scope and Lifetime confusion.
- Macro Message box doesn't display output?
- automated file loading and saving
- Closed Excel but Vba project remained
- Can Excel hide a row automatically based on value in a cell?
- Compilation error in Excel 97
- how to load chart in user form
- how to increase size of diagram lines?
- Insert Character in a String
- Creating workbook from a "template"
- Split a workbook into several using cell value for filenames
- Re: Compilation error in Excel 97
- Populating a main and 'regional' sheets
- for each cell in range....direction problem
- Re: Compilation error in Excel 97
- Excel & Chr(133)
- How to write to a template txt file
- International HTML Import Problem
- Autoformat - customize?
- How do i know how many rows has been selected?
- Modify sub to swap text phrases in cells
- getting to the web link Excel 2003
- Printing Recto/Verso
- Conditinal format of cells within a worksheet + woorkbook
- Starting Point of macro
- Forecasting value of an used car in Excel
- Loops
- SLOW CODE!!! . ........ help (maybe due to unsound BINDING)
- Excel gets slower and slower....
- ADO SQL: Im getting CRAZY
- How do I retrieve the column names in a ADODB recordset from MS SQ
- Userforms submit button to clear after it enters data?
- Random numbers not using randbetween()
- Find firse cell.address that will prin on page 3
- Update
- Email from Excel; MS warning "program is trying to send mail on your behalf"
- a little more secure login
- changing result worksheet of macro
- Horrific news from London
- blank value for row and column in msgbox
- VBA for tab order/moving cursor to a certain cell
- Shooting a Bullet character in Excel cell.
- Formula ?
- Add hyperlink to body of email thru Excel
- line not accepted ?
- Sorting texts and numbers as if it was all numbers
- Opening a document without adding the path
- Pain in the ass macro Part 2
- Opening a document without adding the path
- Break Chart Links
- Format row from c6 to ?6
- Exporting Excel Schedule to Outlook Calendar Subfolders
- Macros from Add-in?
- Macro assistance
- Filesearch 1004 error with XL 2003
- run a procedure in 1 wkbk from another wkbk
- Need help with "save as" macro
- what am i doing wrong
- Counting Conditional Formats
- Can't seem to get an answer to this problem.
- xlstart .xla automatically opens when starting Excel 2003
- Workbook Change
- Take action after entry in a textbox (or after tabbing out of/into it)
- Find Function
- Making a list box of checkboxes
- Read Only
- Error when deleting sheets
- Reverse the order?
- VBA for saving a file to a specific location
- Re: xlstart .xla automatically opens when starting Excel 2003
- Saving Files
- Looping problem
- List Box Selections
- Filesearch in Remotely Called Macro
- Adding Button to Popup Control
- work behind msgbox
- is there a before_worksheet_deactive sub
- text conversion problem
- Get Install directory for Excel
- collection usage/syntax please
- OnAction-property of cbbutton in VBE editor
- Selective formula pasting
- need some help with selecting a sheet in a loop again
- Closing the Print Dialogue box
- Something about the scroll bar
- Trying to reference ranges in another workbook using index in conjunction with match
- When writing a macro in excel workbook, how do I refer to ea cell
- filename insertion in cells
- Deleting cell borders before file opening error occurs?
- vlookup?? trying to get Excel to tell me a value
- Help with Excel ActiveX listbox controls
- advancedfilter blowing up with runtime error 1004
- Setting more parameters with Print area code
- Change VBE Project Password
- Save As "Cell A1"
- Run Time error 13
- Retirement Savings Last
- preference question
- Help: weild checkbox problem
- Setting file names
- Help: runtime error "method seriescollection object_chart failed"
- Filter name and copy to another sheet.
- Filter name and copy to another sheet.
- TextBox calculation
- TextBox calculation
- Call Stack disabled
- referencing ranges using R1C1 format
- referencing ranges using R1C1 format
- Buying Tips - I am all ears ...
- Putting Data & Time in file name
- unwanted copy
- copying from one file pasting in another
- Worksheet_Selection Change code will not allow cell contents to be copied and pasted onto the sheet it's running on
- URGENT!! Use macro button to hide empty columns and rows...HELP!!!!
- reset me
- Change IP address with macro
- Copy filtered range
- Tricky hour calculation (re overtime spreadsheet).
- Custom function valid in Data Validation/Conditional Format?
- Need code to sum a series
- mouse macro trouble
- Copy range lead to lost data
- Positioning
- how to use VB code to define vlookup in two workbook
- Arrow Keys disabled after Sheet Protection
- I only want one checkbox to be allowed at a time
- stuck in loop: Worksheet_Change(ByVal Target As Range)
- Confused about ranges and arrays in worksheetfunction.* functions
- Cells Program
- Pivot Tables
- doesnt become Hyperlink
- updating a form for next use
- Prevent Paste into a cell
- Strange Worksheet Protection
- Open file with open dialog box
- Save excel file as another format file
- Moving Cursor & Sheet back to the Original Location
- Executing a macro in another spreadsheet?
- How to control the UserForm's position?
- counting number of entries for a date
- Trig on drag and drop event?
- "Unable to get the Pivotfieldsd property of the Pivot Class"
- Help Please
- Cannot change SeriesCollection.Values! Why not?
- find and return fixed value
- Skipping Auto_Open
- Automatically send e-mail with Lotus Notes
- editing filename
- Report number
- SaveAs Issue - different approach
- Set buttons to own workbooks, but not to general workbooks.
- Set buttons to own workbooks, but not to general workbooks.
- what the problem?
- Password Protect Indicators
- Macros
- Excel User Conference Update
- Type Mismatch when running query on SQL Database
- Currency changer
- Search for text, change font color
- [beginner] create macro to insert symbol
- How to reshape data sets between long and short form as in stata?
- Exporting to CSV or Text files with variable ranges on a worksheet
- Exporting to CSV or Text files with variable ranges on a worksheet
- Formulas are skipping a row
- break link problem
- "method 'Copy' of object '_Worksheet' failed"
- Paste works sometimes?
- Taking range as input from the User
- Save a Text format file to CSV using VBA...
- Find & replace
- FileSystemObject help please.
- Pausing macro for user Excel input
- Old macro breaks!
- RFT conversion
- How do I use CountIf formula to count a within a range of numbers
- Re: How do I use CountIf formula to count a within a range of numbers
- why do I see this runtime error?
- Excel Error
- help to change data in cells
- sum if statement
- How to aviod Toolbox Items move their position in Excel 2002?
- DDE Question
- Identifying Unique Rows
- Assign a macro to a command button
- Workesheet Calculate - strange behaviour and theoretical question...
- Select Cells in Print Area
- Dynamic Range for Data Validation
- Open Batch File For Processing
- PERSONAL worksheet problems
- SQL syntax in VBA for Access
- Access query to specific cells
- Insert Date that Macro runs
- Re: Insert Date that Macro runs
- Excel/Outlook Inconsistent results
- Last cell in column (with hidden rows)
- Hyperlink Delete problem
- Text Box
- If cell is checked, then list ondifferent worksheet
- open another workbook in vb
- Sequential numbers
- Averaging Values from Sheets in Array
- How do I use a cell value as the filename in an external link?
- show all columns in a worksheet
- How to delete a row and the contained <forms> checkbox?
- Searching the row that contains the same two columns
- Searching the row that contains the same two columns
- Please help!!! Using code to password-protect and unprotect...
- how do I...
- Export TXT from wksht selected in ComboBox
- refer to a userform in a formula
- Movve data from rows to columns
- copying some cells
- nooby here:D
- macro to save as
- Printing in reverse order
- Send Userform results to worksheet
- Re: Filter name and copy to another sheet.
- Adv Filter Formula Criteria
- Triggering an excel menu using macros
- Macro based Import Data Inserts Cells, I want Replace
- send a outlook template message from excel
- need help with togglebutton
- Component not correctly registered
- Find troubles
- Visual Basic and VBA Forum
- Inputbox error? 10 divided by 100 equals 0.100000001490116 ???
- read all the files after choosing a directory
- Bolding Row from VB6
- Delete (Kill) Active Workbook
- editing a dynamic array
- Protect Formatting
- FIND method doesn't work in UDF. What's wrong with this code?
- Ability to filter comments in Excel
- multiple file names in macros
- a fomula that tracks the highest level a stock reached
- VBA Excel Solver ValueOf: Reference Problem
- Logging Data Single Input
- making list, selecting empty cells
- Setting printer header via code
- Run macro based on cell condition
- Trying to set Option button values in macro on protected sheets
- Global Macro
- Save As
- Can a CommandBar Control Caption be Formatted ?
- mortgage loan spreadsheet
- VBE (visual Basic Editor) variable
- Creating Leading Periods
- Software purchase advice
- is there anyone that has successfully sent a page or a copied range using outlook express?
- Wrap Text in Merged Cell
- vlookup result
- More help on setting print headers via code
- Copy rows and move on
- Using part of an autofilter?
- combo drop down code problem?
- how to extend columns pass IV
- filter with special forrmating
- Testing for an open file
- How to create a toggle button on the menu?
- Focus In Modeless Form (spare me the grief)
- Referencing Libraries through code.
- Variable within the code
- Formula VS Formula R1C1
- How to filter out multiple occuring partnumbers?
- Please suggest the best calendar control on the earth
- more sample for illustrator
- VLOOKUP from another sheet VBA programming
- test
- Re: Focus In Modeless Form (spare me the grief)
- compare TIME in IF statement
- copy from unopened workbook
- how to include special characters in a formula?
- Opening *.txt by code with varible path
- newbie question. abt cols and rows.
- copying data from one book to another
- ByRef Cancel in event module
- Date limited
- Changing code that set's print area...to active sheet only
- referencing months
- Turning points
- counting filtered rows ...
- Help with code that finds a sheet's name
- Autofill cell to right
- Determining the number of cells with data in a column
- Copy a single cell to a cell in a range
- Delete all row data EXCEPT
- UDF user assistance?
- What are 'cls' files? VB, I know, but how are they used??
- open some txt files ,find text , copy the text before that to a single cell
- How to refresh the data in a Pivot Table?
- Exporting EXCEL Graphs as .gif (image file) using VBA or VB
- Calendar Control
- Applying names to ranges of cells for formulas
- Re: Exporting EXCEL Graphs as .gif (image file) using VBA or VB
- Test For Macro Security Settings Level
- Change the range of a pivot table data source
- how to write macro that filters odd & even numbered data ?
- I cannot close a workbook in vba, I think because it odlinked to
- why the method "show" invalid?
- mscmctl2.ocx ... calendar and date picker sometimes not available
- Need code to copy from "code modules"
- copy sheets of cell length is more than 255 char
- Code
- how can I arrage file in folder into worksheet
- Is filtered property?
- reading the hyperlink
- printing issue
- editing the web query through a sub
- Insert information to multiple similar files
- print area poser
- Problems with .Refresh BackgroundQuery:=False
- Amending Cell formatting with VBA
- Printing automatically
- Print array based on menu choice
- keypress event on a userform
- Open workbook name size
- Hexidecimal Editting
- is there any way to avoid displaying alert pop-up in DSOFramer?
- Create a pivot table via VBA code
- Properties transferring from excel cells to word file properties
- Highlight a row without losing background colors
- Trying to find Item with in a sheet
- Cell address from Vlookup
- VB Project Protection
- Referencing error
- No more new fonts can be applied Excel 2000