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