- Reformatting text....
- ini file 2
- programmatically adding a break in a menu bar
- save as text crashes
- Worksheet_Change from a validated list
- Want to displays lists items in separate colors
- save as text crashes
- Writing to Notepad from VBA
- BreakLink
- how to get data from cell a1 and paste in cell b2 in another workbook.
- Verify protection status within a macro
- Joining an Excel spreadsheet to another using Access
- function to figure out which procedure
- comapring cell values
- Macro skipping
- Update a range reference change
- preventing special character from being entered in cell
- Disable save & save as then return message...
- Identify unprotected cells in protected sheet and clear their cont
- If cell value equals today
- End(xlDown) won't work
- Cell references when creating charts
- Excel, Fullscreen, Taskbar
- Setting the category Label source for a Pie chart
- Excel UDF Description, Help Keyword, Help File
- preferred method for summing
- How do I find Control toolbox in Office2007
- Select Current Row
- filter a matrix
- Using found variant within code
- Searching for a substring inside another string - there has to be an easier way!
- Maintaining relationship between 3 variables
- popupmenu
- Window Movement
- Automatically run a choice of macros based on cell selection
- Protecting a Range in a list
- Hiding unused columns
- Selective linking items between two worksheets
- Why "expected function" on such basic VB?
- Hi Bob
- Delete entire row if two cells are duplicate
- Info on xml files
- Background color for every other row
- Where's the Personal.xls in Excel 2003?
- a "cell is renamed" event?
- A COM Add In must handle WorkbookOpen event
- Major Error
- Using known arrays to calculate an array of new values
- limit on hyperlinks
- how to read dbf file using macro?
- CONVERT A MICROSOFT EXCEL SPREADSHEET INTO A JPG FILE
- Multiple Command button programming
- Spreadsheets or workbooks - can they be accessed as a network application?
- Troublesome Code
- scope of public variables
- macro to move and save all sheets to seperate workbooks
- delete workbook if not authorized
- Sort by rows...
- "cancel" caption doesn't show up on cancel dialog
- MacID VBA
- combo box problem!
- Pivot Table: Locking Certain Features
- Microsoft Common Dialog control, version 6.0
- Display Cyclic Error as Blank ?
- Follow Hyperlink in Excel 2000
- textbox to return User Name
- runtime 1004 error
- 2-Column ComboBox Issues
- Sort Ascending or Descending using Option Button
- Change the range for a recordset?
- custom format cells
- when encountered Zero/Blank CF issues ...
- Control on different sheet than the executable
- FORMULAS
- How to make a File READ ONLY
- Copyright or Secure a workbook
- macro to insert function without parameters
- runtime 1004 error
- Error Message Copy method of worksheet class failed
- INI File
- Tweaking a current formula
- Find / FindNext Methods
- How do I remove an old command button from an EXCEL worksheet?
- Trying to search a block of text for presence and frequency of terms in Excel
- Delete entire row with a positive number
- Trying to make Date Range variable in VBA SQL Query
- 2 nice requests
- Updating all graph links in a workbook
- Update multiple rows from listbox
- Why does this work?
- how to copy line above when XXX occurs and move on?
- Excel Macro find non zero value in cell and insert row beneath
- Clarification in vb excel programming
- listbox - How to reset the values
- pivot tables
- Counting number of rows that are not N/A
- Sum values based on Text
- Setting external data location for a pivot table
- Lotus to Excel
- Checking list for contents
- Protected Sheet and AutoFilter
- combo box
- Wrong with macro naming sheets
- SUMPRODUCT...with text values within array
- Checkbox to Hide/Unhide Columns Based on Value in Cell
- View Details in OpenFileDialog
- countif formula
- how do you create drill-down detail?
- Append One Array to Another, and Consolidate
- Active X Command Buttons Disappear
- Open book, copy and paste from sheet, and then close....
- Pivot table programming
- How do I add a drop down calander function to excel?
- Protecting an Excel List
- Function with offset
- UPDATELINK problem
- Using variable in CopyToRange:=
- Selection.Find a formatted date
- Closing files by a macro
- Sum Formula
- SUMPRODUCT (I believe??)
- export to a text file
- empty cell instead of 0's
- Idiot proofing my spreadsheet
- Comparing visible values in two arrays
- Moving your selection over a couple of columns
- Using a marco to update my spreadsheet.
- Using a combo or list box to select a statement
- VBA searching
- Colors Shapes vs Cells (Excel 2007)
- Automatically create a chart
- sum at each page break
- Insert row after a page break
- Add Line break to string for Excel (using c#)
- Combining Formulas
- How to print...
- Strange format problem with textbox
- sumif statment
- Time Stamp
- Shapes & Drawing Object Bug Excel 2007 Beta 2
- query table macro
- Changing Multiple Cell Colours based on Drop Down option Selected
- Need help with named ranges in VBA
- How to hide certain pages if a page is dispayed
- Using Command Button to Hide Columns in another worksheet
- ChangeLinks routine stopped by Update Values dialog
- Use VB to get group of cells
- excel 2002/03 vba changelog
- How do I implement if-else functionalilty for a cell in excel?
- How to set row color
- locked cell issue
- How to sum subtotal with blank line
- Why it doesn't work
- run time error 424
- Excel date bug?
- Excel crash as the result of file look-up
- Create univeral pivot table macro - use with varying lenght data sets
- List all (complete) codes from a workbook?
- Displaying help for an addin
- What is the right function
- Counting columns with >1 instance of a specific value
- Pastespecial with Late Binding
- Countif Function
- How to select a font with a strange name?
- How can I use Visual Basic to access Solver?
- Multipage forms imported in XP
- Trouble exporting ado rs to Excel
- How can you use data validation for a cell with a formula
- formulas derived from cells
- cell contents into an array
- REPLACE formula
- Simple Parsing Question in Excel 2000
- disable save and saveas from menubar and save via command button
- Dynamically create procedures in a sheet module
- Alternative to hardcoded password ?
- Help with a macro
- Excel setting which prevents printing?
- To save a web page
- Simple problem with code
- run time error 91
- Check if Any workbooks are open
- Setting a list box to a value
- Encryption - Public Key - what the....???
- Range does not work
- compile error method or data not fount
- Data Validation and Filtering
- get some user info and store as constant
- error "macros disabled, refer to online help?"
- Code Usage Question
- Check if the first sheet is the selected sheet
- "Select" and "Activate" failing?
- Range syntax with variables
- shape range help
- Create a macro to run autofilter based on contents of 2 cells
- Disable Auto Refresh Dialog
- WORKING WITH COLORINDEX AND MULTIPLE WORKBOOKS
- Hide sheet via codename
- .FreezePanes
- merging 2 spreadsheets
- end command not working
- Next available row
- Linking information in individual cells spanning multiple sheets
- "Save" macro problem, still prompted to save when closing workbook (?)
- ActiveWorkbook is nothing in Workbook_Open
- Sending email from Excel with a twist
- Find and Find Next problem
- Macro Not Working
- fix worksheet color
- Turning off merge-warning
- Nesting For loops
- Need one more thing
- How do I track multiple daily individual payments over month/yrs?
- userform to search by entering data into a textbox
- Multiple range names
- initialise declaration
- Auto spelled number
- Use CDO to send e-mail
- How to detech same data in one sheet
- Combobox items determined by the selection in another combobox
- How to print...
- Hide same rows on new sheet as on previous
- vlookup
- Method or Data Member Not Found error, after connecting to Microsoft SQL Server
- Combo text value disappears when wkb opens??!
- ??? How to get list of Color constants
- Basic authentication UI for web-services
- Can using If Formula differentiate number with decimal or do not
- Upgrading Add-Ins to Excel 2007 -- Compatibility & Bugs
- TREND WORKSHEET FUNCTION
- Combobox Rowsource
- how do i create a template for certificates of completion
- Sorting Check Boxes
- Toggle Toolbars in Excel2003
- CODE Function equivalent in VBA
- using VBA in Excel it changes the dot of a number to a comma
- hypertext
- hypertext
- Condition Formatting - Work Sheet Event Code
- Merged cells
- Dynamically setting Dimensions in a VBA loop
- runtime error
- Macro to refresh data
- split function for Excel 2003
- help! pull text info from separate worksheet
- Maximum Number of times
- Need to link to various websites
- macsplit function
- 2 CONDITIONS FOR CONDITIONAL FORMAT?
- smallest
- Insert Listbox in Essbase Form
- DataLabel Manipulation
- macro to save named range as text
- Extract email from excel worksheets
- Column names for dump of text file to Excel
- error in userform?
- How to create a disapearing drop down list
- Change default button
- works in debugger but doesn't run
- deleting duplicate entries
- Named ranges on other sheets
- round number for unknown num_digits
- Compile Error: Expected Variable or Procedure, Not Project
- How do I swap every two rows in a spreadsheet?
- works in debugger but doesn't run
- scrolling textbox
- Printing with macros
- how do I print a named dynamic range
- Getting From UserForm TextBoxes To Lastrow On Active Sheet
- Working with Incative Workbooks
- Macro to hide rows/colums by value
- xl2002 - AutoFilter from Criteria from Other Sheet...
- Creating a Fomula in a Pivot Table
- Excel 2003 is converting weird to Excel Viewer Version 8?
- sort doesn't sort numerically 2nd request
- Speed Up Macro
- Test Printer for Colour/BW
- Add 2nd Column to ComboBox
- dynamic charts
- increase range programmatically
- Prevent Saving From Web
- Undo function in Userform
- How to activate original workbook?
- separate mixed data
- Date problem in Pivot Tables when using SQL as a Data Source.
- Re: Question using the excel find method in vba?
- excel "name is not valid" when naming a cell
- How to copy a worksheet from one workbook to another in vb6
- References to cells in other files
- Delete duplicate rows
- Querying an Excel Sheet via HTTP????
- Consolidate data on different sheets in a changing range
- text boxes on forms
- Pasting ADODB recordset into unopened workbooks II
- Naming and referring to charts
- Row of references to same cell in several worksheets
- OLEObjects, adding a picture problem.
- security warning
- update then move down
- Creating a total line
- conditional formatting
- choosing column heading given a criteria?
- formatting cells loop
- formatting cells loop
- Help with my cut and paste code
- Re: If sheet exists, then...
- Re: Import Data From Landscape Format
- Automaticall disable Protection menu
- Re: open an excel file
- Re: what is the R1C1-style notation in Macro Language?
- Only allow users to enter new data
- IF else statement
- Split Text
- lastrow question
- no sheet in workbook
- RE: If sheet exists, then...
- Sub Auto_Open() - Sheet name - error code
- MS Office Outlook 2003 & MS Excell 2003
- FindFirst
- Force Excel to Refresh Screen
- Football pool
- Changing a Number in a Column Using Arrays
- Excel OLEDB reading Chinese characters problem
- In Excel a macro to run when yes =IF(A1<=B1,100,0) is 100
- Show "Go To Special" Dialog Box
- Complicated VLOOKUP
- Matching CELL text (full word) to full word in string in another
- How to sort a list of telephones # by every 10th, 20th number?
- command buttons
- Pasting ADODB recordset into unopened workbooks
- automatically run startup macro in new workbook
- RE: open an excel file
- Maximize all collumns and rows (evenly distributed) on 1x1 page la
- Re: Question on Find method in vba
- separating info in one column to different fields
- WHY DATE FORMAT??
- Change Formula
- Capture date for =MAX(a1:a250) formula
- Popup Comment Box if a Certain Condition is Met
- RE: Problem with worksheet_deactivate code
- Macro for hiding columns not worling
- Excel code convert to Access code - Concat & eliminate duplicates
- Re: Allowing user to select a cell in another workbook in VBA
- Re: If sheet exists, then...
- Re: find an empty cell or null value
- Re: number not a number?
- RE: find an empty cell or null value
- VB to copy a sheet to active workbook
- Simple VLookup Question
- issue running in Excel 2003, not in 97, error 9 subscript out of range
- Name ranges based on criteria
- How to make "("@")" work with =ROW()-1?
- extracting data to csv from multiple worksheets
- Simple change to list address
- cancel the loop
- Exproting Excel Worksheet to seperate Workbook
- Problem with action on range change
- Keyboard Shortcut changed after XP
- Help with VBA Code
- Printing hidden sheets with vba.
- Sudoku Solver - Help needed..
- Regional Options
- Counting Minutes
- Performance Difference - LCase vs UCase?
- Help with autofilter
- change firstrow variable to be the 2nd row value instead of the fi
- Auto fill the next row in spreed sheet
- returning value based on font color-repost
- returning text based on font color
- Runtime error 13-- Setting a variant Range?!
- need relative cells instead of hard coded
- Testing if a cell is within a range
- Advanced - Search and Update
- Help wanted with VBA code
- Only show userform after startup of app.
- VB Code Question Range(
- Change Event on Dropbox
- Autofilling Macro
- Need simple prompt to save at end of macro
- number from a cell value instead of a string
- Extract Specific information out of xls sheet to a different xls
- Referenced File
- Filter then paste
- Email Sheet
- How do I add new rows with data simultaneously to linked workbooks
- Formula to manipulate cell font
- Create a dollar value
- select last dirtied cell
- Printing
- Excel 97/2003 VBA merged cells
- Events not triggering
- how to switch pages in a multipage control by a commandbutton
- Create message in linked sheet ---- newbe
- help with sorting data in excel(Macro)
- vba sort range problem
- If Or not working
- Passing parameter to a select query
- SPOT THE MISTAKE!....
- print result
- resize Columnwidths Listbox
- Pasting two named tabs one below the other
- Run macro for all documents
- security level
- text orientation in labels
- ....SPOT THE USERFORM!!!!.....
- Macro that searches 5 files .xls and in every worksheet in every file is looking for "text".
- Use excel with java to store data
- save / saveas specific filename.....with a difference!
- Find Folder Size
- unable to open excel file
- user input for date and time
- combo box + option all + use all functions when this is pressed
- Wierd - when saving wb & protected...it opens with sheet 'down'
- What is the selection syntax
- Sending Workbook
- How to set user defined format in VBA
- OLE Excel AutoFilter
- Error Message
- inserting a colored row with the department name
- Wide Drop Down Box reduces to cell size after selection
- For Tom Ogilvy
- creating a button to activate another worksheet within a workbook
- Adding multiple solver conditions in VBA
- Disable VB Editor
- send focus to a textbox
- Generate Email Alert
- Detecting Macro Secutiry Settings
- What was ActiveSheet before changed to new sheet?
- Excel on Windows Mobile
- SaveAs Question
- Custom properties for worksheets
- Code to configure Spell Checker
- VBA question
- insert a row above the first one
- Disabled richtextbox control in excel sheets
- A few questions - newbie in VBA
- Inserting symbols into Cells of a worlsheet
- Cell that is below given coordinates
- Transfer ListBox items to a range
- Searching For Duplicates
- Screening values in cells to create a sentence..
- Select Multipage by name?
- DDE Replacement?
- VBA macro generating MD5
- Saving only changes
- pagebreaks after last department in a group, color header on first
- VBA: Search for word in a file in Folder using VBA?
- Copy range based on condition
- Detecting Null
- Photoblog and Fund Raising
- =HVIS
- Problems while sorting
- Running Custom Code if "Entire Workbook" is Selected for Printing
- sizing a chart in Word that was created in Excel VBA
- selecting and sorting a variable rowlength
- Trying to remove hyperlinks
- Trying to remove a list of hyper links
- Access to this newsgroup
- userform error?
- I am stupid and don't know what the heck I am doing wrong on this pivot table!!!
- Counting instances of an incident happening
- Userform - with Commandbutton fill a Listbox with data..
- saving a file
- Sub Not Working
- ActiveX Error 429, "Can't create object"
- Search for text with specific parameter and copy
- Sub totalling in VBA
- New file format constants
- Ned help with Resize function in Excell VBA
- SumIf with 2 ctiteria
- Range selection
- EXCEL FORMULAS DO NOT WORK
- FORMULA DOES NOT WORK
- Animated clip art in Word & Excel
- Numbering Worksheets
- Kill Files in Excel 2000
- X-axis values in xlLine chart problem
- push a command button
- MsgBox Problem
- Disable Printing If Cell Empty
- Search for a specific file's extension
- sort doesn't sort numerically
- Undo Command Button Actions
- Help with VBA code for reliability report
- How do I prevent unintentionally running a Macro?
- macro securtiy
- Forcing cursor to next cell
- FORMULA WON'T WORK WITH LETTERS
- Error 13...Mismatch
- formatting all textboxes in a userform
- if/then block within another if/then block needs a loop
- test for secondary monitor...
- get screen resolution for second monitor...
- Disabling macros when opening a workbook?
- What is the proper syntax
- game in excel? is there a way?
- resize column row headings
- Strikethrough cells B2 to E2 (a "row", in essence) when A2 has a checkmark?
- Conditional formatting for a row, dependent on one cell.
- inputbox error when clicking cancel
- Calculations across sheets w/ other questions
- Delete Sheet w/o warning prompt...
- formual in macro
- Out of Memory Message - Code Problem?
- Deleting VBA code
- sort macro stopped sorting
- .cells not applicable to range
- Displaying values rather than formula in cells
- find and select a cell
- Calloway Golf Scoring System
- Worksheet name list from range....
- Codenames
- Obvious, but couldn't find this either
- Constructors for Classes
- Some more help with code...Averaging a range
- Error in vba line
- MS Excel Web Query
- Automated Copying without links
- Formula Scientific Notation Problem
- EZ ??? - Conditional Formatting
- format text through vba
- VBA Formula Errors
- save and email button
- Subscript Out of Range when closing a workbook
- check the name of a cell
- Disappearing act!
- how to maintain add-ins? (with toolbars)
- Range Name issue
- Count Dependents
- Goto column A of the ActiveCell
- Windows "Region & Languages" ComboBox Issue
- Application.inputbox for another workbook
- Max Sheet Threshold
- button in a protected sheet
- Finding Maximum Within Range (Looped)
- Reconicle with Arrays
- Maximum number of DDE links?
- Pasting two page one below the other
- remembering the nth item in one sub routine in the next sub routin
- Overriding ScreenUpdate function
- BottomRightCell ignores hidden cells
- UserForm initialize
- Compatibility Excel VBA WinXP vs. MacOS
- Record sets?
- How to create a SUMPRODUCT OR COUNTIF for multiple criterias and ranges
- Addressing a Help File
- userform value
- Advance handling with duplicates
- multiple graphs in excel
- Copy latest date from one workbook to another
- Find same context in to dif. worksheet
- OnTime code error "can't execute code in break mode"
- How to put a calader object on a form???
- integrate output from various workbooks in one workbook
- Triple state command button
- Dave Peterson...
- Spell check query
- Workbook_Open doesn't run
- Spell Check Query
- Access current active workbook from DLL
- Auto Save
- UDF -> 256-Char -> UDF = "#VALUE!"
- Transfer range to array etc.
- Re: Function failure
- Clearing Non-numerical CellCvalues
- Print Rows
- How to code this
- Using Excel VBA to create shape in Word
- Warning message about potentially non safe ActiveX controls
- running macro after refresh of extenal data
- Help with an algorithm
- filter to new sheet
- Filtering worksheet in VBA
- How to Sum
- Code for ComboBox
- If Statement Limit
- looping through variable defined cell addys
- Solver Error
- code needed to update links
- Hyperlink coded for sheets that are not created yet
- Hide Columns
- statistic using excel data pls help!!!!!
- Ref Code Not Working
- Can a TextBox on a user form activate a popup calander for date se
- help to modify code to look to correct folder
- User form to assign an autonumber to spreadsheet - Any Ideas pleas
- Conditional Formatting Question
- How to store Cell format?
- Excel to Peachtree via VBA
- Averaging
- Any Good Book on Excel Pivot Tables
- testing for workbook already open
- how to show the total products sold
- Put the split cell option back in Excel.
- PLLLLLLSSSSSS HELP
- VBA - Move Cell Down
- VBA - Move Cell Down
- Graph Size not adjusting with Chart Area and Plot Area
- userform questions
- Compare 2 range of data
- sort by last name...
- Spell Check
- userform information copy to a cell
- Range intersection
- Removing a line of code
- How do I add sound alerts to Excel spreadsheets?
- kill all button
- circleinvalid in Excel
- Defining range names
- Change errorbar series data from vba
- Debugging .NET
- Specific Conditional Selection
- Saving Selected Worksheets
- Open workbook form from Add-in
- Import Data into a Formula
- Start up folder v Addin folder
- assigning a macro to the tab key
- Using cell value to reference another cell
- Error in Excel 2003, OK in Excel 97
- How do I create a User form to input Data into an Ecel spreadsheet
- Copy Range
- Generating a List
- vb function in personal.xls
- Excel Templates and databases
- PivotTable problems downloaded into IE
- Change Error Messaga from Sheet Code
- Macro needs data from hidden worksheet
- changing button prop with vba
- Bringing up a message box if values already in cells - Help!!!!
- Excel 97 clearcontents method fails
- ComboBox update
- VBA and File System Object
- userform open when sheet activated
- filename in "Subject" in email
- Loading Data into Multiple sheets in 1 book
- Macro stops @ row 300 with count... how?
- InputBox method with range
- Problem with managing excel embedded with IFRAME
- trim "/" from date
- Turn Check box on?
- Formula not adding right
- WHY OH WHY DOESN'T THIS WORK!!!!!
- Changing the textbox value without changing the textbox format?
- Building an address
- Sums, Filters and Events oh my!
- formatting data for import into ms access
- Add a new column to a worksheet
- Auto Program Pivots from a userform
- current workbook name
- How to prevent Excel from formatting Dates ?
- Getting a macro to work in all workbooks
- Save user Menus and Toolbars Status
- Proctect when closing
- Splash or message box that doesnt pause
- Freeze Panes
- Defining a type of the cell
- application.run 'current' filename?
- CHANGING POSITION OF AUTOFILTER LIST
- Userform, listbox and ActiveCell. I'm stumped
- How to Unprotect Project Protection through Macro
- excel should let me unfilter all columns with one click
- Unique Value by Advance Filter
- MinMax Button
- problem (maybe simple) displaying certain text
- Changing sheet content using codename
- referencing crystal report
- Looping through Range...Slow
- Finding worksheet
- IF function with link to different lists
- dfg
- Filling cells
- how to autorun a macro from personal.xls?
- Formula assignment problem
- sort data?
- adding two highest numbers formulae
- DIV/0
- Sorting Collection
- can I use text color to set up a formula in excel (Red text = -1)
- interior color of macro
- Check range before pasting and modular approach questions
- short cuts
- Read Keyboard Buffer ?
- Recording highest and lowest ranking
- Re Countif
- application or object defined error
- What have I done?
- Creating A Breakout List from a Summary List?
- Hide code
- UserForm Loads Slowly
- Hide Combo Box
- Weekly Totals on sheet
- Workbook_Open() Not working
- Problem in Excel...String of Ranges?
- sorting problem with range definition
- Ensure Named Range is in ThisWorkbook
- How does one show an intital value in the combobox
- Format date in combobox
- Formatting Numbers with Decimal Places
- range selection for a sort on a excel db
- merge text
- Data Collection File
- Random Numbers
- Hyperlink pdf problem
- Run-time error "5" after range().delete runs before querytable.add
- IF Statement
- Html controls in spreadsheet
- Reading Comment Formats
- Creating a UDF from a VBA routine...
- Macro to hide column based on header name
- ONe Macro won't call another
- How to add user input to determine a variable in a macro
- ComboBox Decimal Errors
- how to use a knob or level slider in microsoft excel
- Shortcut in c#
- VBA(Excel) tests
- Message Box Coding question
- Getting Worksheet name in Reference Style
- create cell reference in formula
- Date (dd/mmm/yyyy)
- VBA cell content check
- How do I build "hide a row" into a macro if #N/A appears in a colu
- footer
- problems iwth VBA code- for each loop
- Named range in an array
- Promt When Closing
- function
- Find duplicate records and delete
- Weird AddIn behaviour
- CountIF Question
- how to resize the comment in a cell
- Multiple If Statements
- Moving Data
- Performing a calculation in VBA based on conditional statements
- How to set Paste:=xlPasteValues for all paste operations?
- Excel Crash and/or Gray Area on Screen
- Reorder numbers from one cell into another cell (123456 to 341256
- Problem formatting decimals in ComboBox
- Copy last 12 rows after filtering
- adding test and cell address to combo box.
- Excel.exe memory issue - Resolved in 2007?
- Array question
- I set up a macro to hide/unhide columns. It hides more columns
- adding named ranges without a "-"
- record formulas
- Before Double Click
- Add sheets with name as in cells in a specific sheet
- How to add and delete pagebreaks using Excel and C#
- Customize "Dynamic" List
- macro
- Trigger macro on value only
- MS Query refreshing in order