- Autocomplete
- Embedded a .gif animation into a form
- Adding Range Names
- using saveas twice will be error,savecopyas don't use also,why?
- Is there a "Find If" type command?
- Length of worksheet name
- deactivate macro or LostFocus
- Select certain data from a Pivot and copy this into Powerpoint
- Consolidating Several Excel Files
- Find and Copy
- is there a currency conversion function?
- Create multiple copies of rows based on a cell value
- Help with code
- pivot table build using excel macro
- Difference in Values for Price function in Excel
- Auto fill form with data from worksheet
- Prevent error messagebox when refresing querytable from the web fails
- report output format
- Colour Question
- Copying cells...
- Until end of array ?
- Adding column title
- Split code in more than one page ?
- display rows that meet two conditions
- Reference dialog box
- How to open or view VBA project only
- amend this routine to use something other than Application.FileSearch
- close excel application
- Insert Row Macro Help
- how to make the formula
- Hide/Unhide Sheets
- Compile XLS sheet into EXE
- String compare doesn't compare?
- Drawing Problem
- VBA If Statements
- Image Click Invokes Picture Toolbar
- add a new row once list selected
- Trim pace not necceesary
- Unload multiple forms
- Copy rows from one file to another file
- Links from other files
- Scroll to top of page code
- VBA VLookup
- protecting macro code
- Reference to solver problem
- Reference to solver problem
- nested loops
- set up a repeating header or footer to entire workbook
- CommandButtons
- Resizing Userform to screen size
- select and print
- Identifying complex duplicates
- Accessing rows after AutoFilter
- This should be simple?
- macro slows down
- Debugs with Copy / Paste
- Copy from another workbook
- Really Slow Running of Macro
- Macro For Deleting Cells Containing A Number
- Run Time Error 9???
- Random Number comparison
- What does Ctrl+Shift+Enter do? How does it differ from Enter?
- Realtime Data Update Sorting
- How to? Copy from one location to multiple locations (easy)?
- Get RGB color ?
- How to update values on cells in visible range only
- Updating Querytables and Pivottables
- Desperation is Setting in - Date Formats! :-(
- Why does SUM not compute, even if the cells display numeric values
- Find textboxes on a form ?
- VBA
- Macro button not appearing when workbook opened?
- newbie.... need some code... I HOPE!
- are default values possible for "Application.Dialogs(xlDialogSortSpecial).show "?
- Modifying Data inside an array
- Worksheet Focus
- VBA Query again Informix database
- Loading Pictures in Image box
- query sql database
- query sql database
- query sql database
- Drop down list - display text vs actual value?
- VSTO 2003 Excel Command Bars
- Run a Macro via a Scheduled Time
- how to set 'security level' to low in auto like vba
- A challenge for the Excel Experts among us (ActiveX Control & Add-ins)
- What's the best solution to accomplish this?
- How to limit 'calculate' (F9) to specific cell, range, sheets, workbooks?
- Autofill with changes
- resize and copy
- My problem with char(30)
- Clear array ?
- Compare workbooks
- Any way to do this faster?
- Respond at a specific time
- Find files and sum a value inside sheets (VBA)
- Dim an Array with a variable
- Web Query
- Set print area problem
- Type Error in For Each Worksheet Loop
- Date in data imported from MYOB to Excel 2003
- varying colors on a graph
- A Userform goodie - updating records
- Workbook_SheetChange
- VBA Help, cant figure out why it dosn't work.
- Prevent user from overwriting file
- VBA newbie question
- how to speed Find/Replace in Excel(Using VB)
- Creating a folder
- MatchRequired - how to trap the error when a matching entry is not input
- Copy and Pasting into new Sheets
- Require certain password for sheet1 to save
- msg box to clear a sheet
- Get Worksheet Name
- finding ROW without selecting worksheet
- worksheet event macros
- Store hyperlink, when filename may have # in the name?
- Perform Row Function Using Macro
- Copy cell properties from master when user enters a new line.
- Excel is multi threaded program? thanks
- Combining find with clearcontents on multiple columns
- SQL scripts and ODBC
- Finding next empty empty cell in a range of columns
- Need help writing a filtering routine
- class/struct functionality in VBA?
- validation
- Tweaking a Macro to Count Words
- Module vs Class Module
- Loading and changing a photo
- Validate all cell values against it's list prior to saving the she
- Grouping into a Tab
- Treeview expanding when saving a workbook
- Can I remove prefix apostrophe
- rename current file save and delete original
- Finding next available empty cell in a row
- Hidden Character Find Macro Help
- Need macro to generate list
- Sort an array
- duplicating cells in diffrent sheets
- Closing Code
- Slightly long winded transposition
- Force Save to specified folder on 1st open
- MultiPage
- Excel macro convert to VBA - doesn't work, hangs on Range("Q35").Select
- Won't close w/routine
- prevent UDF from executing
- Disable a Specific Message Box
- BeforePrint macro difficulties
- Deleting rows before importing
- MS query return multiple columns in Excel
- Speech Recognition in an Excel Macro
- Having a mcro prompt me for manual input in cell
- change event
- Encryption
- macro help please
- Macro problem
- Delete WB
- How to use VBA to update a SQL Server Table from a Spreadsheet
- Setting Public Variables Error
- Looping through rows and shifting certain contents
- Option Button
- Locking cells
- Too few parameters
- Determine begin month date from month end date.
- Adding controls to each page in a multipage form
- A tricky macro -
- populating a dropdown based on choice from a previous dropdown
- protect/unprotect all sheets
- Populate the Concatenate function using VBA
- Excel Scheduling
- Hide and/or Unhide Worksheets
- Macro Drop Down Box
- Easier Way to do it?
- Project password
- is Excel written with multiple threads?
- Help with multiple "IF" functions
- Override built-in commands
- Indirect reference
- change error message when no more for "find" in macro to find
- Coping a Worksheet - but Getting an Error
- Superscript Button
- Convert Excel. xls to .exe
- Hiding Zeros
- Auto Row Height
- ActiveCell = " < "
- File Open Check
- multi page object from excel vba toolkit
- command button to move user to specific spot on different sheet
- ifcount evaluates always false
- UserForm problem
- local security policies
- Writing update date and time in a cell on inputs
- Require Cell Entry based on condition
- Reference
- Passing a function from VB with text strings in quotation marks
- Get two Values from closed Workbooks
- storing of VBA code
- control button used to clear a sheet
- Checking to see a sheet of the same name exsists
- Protecting multiple worksheets
- Is this really possible?
- organization chart
- Populate a combo box from a worksheet with VBA
- Select item in drop-down list in Vbasic
- Why doesn't "private" work?
- Using excelObj.ActiveWorkbook.SaveAs("C:\MyWorkbook.xml", FileFor
- preventing macros from clearing the undo list
- Simple Sound Macro
- Complex Query Not Able To Get Results in Excel
- Full xpath support in visual basic?
- Collection as parameter
- Macro (can do a save as.
- VLOOKUP formula
- copying worksheet
- IF = text Show "NIL" ..?
- UserForms, mandatory completion of fields
- Print Preview
- SaveAs Code
- VBA
- Digital signature
- Date and Time Formats in UserForms
- Create Function like Sum()
- ??? Combobox auto go to selection
- lines in user forms
- Can i use lines in a user form in excell
- how to add column with the workbook-filename
- Cells
- check exist of filenames in column, mark red if missing
- Macro Help for Deleting Blank Rows & Clearing Cell Contents
- macro creation to format mulitple rows in a list *difficult*
- Macro slow after 2003 upgrade
- Error using VSTO and ImportXml when cell is being edited
- Saving worksheet Data only
- FILTER ROWS THAT MEET THE CRITERIA IN THE LAST CELL OF THAT ROW?
- hierarchys - can you build an elegant hierarchy using vba
- Paste Value Multiple Sheets
- currency macro?
- Go to what I just typed
- Find Macro
- try [code] next
- VBA
- Colon in code?
- Multi Colum Listbox in UserForm
- Application.Run problem.
- Copy a range to cells above range
- Shared workbook opening and saving very slow
- Help with lookup or if functions
- Return WB to original state
- continued issue with countif function
- Macros within formulas
- a strage kind of graphic
- custom toolbar for each sheet in workbook?
- Help with Macro for work
- Macro to name ranges for selected worksheets
- Help - Excel Automation: Turning off all dialog boxes (prompts).
- Remove blank rows without hiding them
- IS EXCEL a multiple thread program?
- Recent File List Problem
- Useform Cascading Like the Solitaire Cards when I try to move it
- If cell = number ?
- Manual Calculation not working?
- using countif from a vba macro
- Copying static cells in a loop....Paste Special problems
- Macro signature disappears.
- Paste Special issues
- Automate Page Break
- Drop Down Boxes
- Export Date Format
- .Find Method for Excel 2002
- Not Enought System Resources
- Hiding and Unhiding Sheets
- XML Refresh Code
- xl4 command
- Adding read receipt to CDO code?
- Code to search and replace info on modules
- Option Button - Cell Link Issue
- Outlook Event Entry
- Hiding and Unhiding Worksheets
- Why is this a number?
- OnTime
- Excel macro to insert blank rows at a ever-changing interval
- Sorting Multiple Sheets
- Open Word Document from Excel Userform
- Diable Ctrl+Break
- countif AND countif something else too!
- countif AND countif something else too!
- Go to 2nd row below last row
- Pointing directly to a cell in a range
- a strange graphic
- getting error out of memory
- Update Links
- Using a database to create new worksheets based from a template
- matching 24 different values to a specific value
- Is it possible?
- remove vba and functions when saving worksheet
- Data Filter Function in VBA
- Getting a cell reference
- Close File
- xls file requires Domain Admin to save locally
- Auto reszie a row with wrapped text.
- macro open files
- Drop Down Boxes or Macros?
- Passing variables between workbooks
- Paste blank cell row loop
- Text box pop-up
- Students and Courses
- SOS: Excel custom Toolbar
- Programmatically make cell pointer invisible
- Put variable into text ?
- If Value Problem
- Button not showing graphic.
- Run-time error 1004
- Brain lock: using array formula within VBA?
- Sequentially run macros
- Macros
- help with this function
- checking a sheet for identical items
- Variable in formula
- Macro for multiple charting of multiple datasets
- Open a semi variable name with a macro
- copy paste values only using destination:=
- question about Web Query
- Making sheets with a macro
- A strange kind of graphic
- Another cell formatting dependent on cell contents question / message box popup?
- Excel macro, editing recorded cell.. not current
- formating cells
- exclude international and national holidays into conbobox...
- the macro don't execute
- Protect cell pls help...
- Changing Background Colour Based on Cell Contents
- Copying the data from the other worksheet
- Putting a search box
- Template path
- Create new workbook, temporarily name it and copy sheets to it
- Extract Target path from a shortcut
- Repeating some code on all worksheets
- How do I trap errors when excel (not a workbook) launches
- help with graph
- Macro again..
- 1004 and Cells
- Paste All Problem
- Pivot Pagefield multi-select? (Excel 2003)
- Timestamp - automated based on the next cell
- type check
- macro with external script.
- syncronising workbooks
- File copy
- Cells Range Error - URGENT
- getting data from excel worksheet in to a script
- Workbooks.Open fails
- Macro to replace another macro
- saving backup
- copy and paste formulas that apply to multiple worksheets
- Open Access Database from Excel
- run a macro in excel formula
- Multiple selection
- Subscript out range error when redimensioning dynamic array
- Excel Add-in for SQL Server AS - Documentation re Calculated items
- How do you Export Excel data permanently to Access
- Copying entire row
- Loop routine fails after 10 cycles......
- Help!!! I have problem deleting 2500 rows of filtered rows
- run-time error?
- run time error
- Conditional Printing of worksheet
- Dynamically Activate a Combo Box
- copy and over write *.jpg files
- Any news from Bunny / TRA on how we did in court on 1/10/05
- Comparing two coloumns text contents & extract different values
- Searching for patterns in text split into adjacent cells
- Capture Find Settings
- Is there a way to install Excel if I use XP?
- color for last day of each month
- WorkbookBeforeSave
- Number formats after breaking links
- two small questions
- Closing a Workbook
- DateTimePicker
- excel input date format
- How can I do AND operation on two binary numbers in MS Excel?
- problem determining a cell's value
- Need help re VBA for Worksheet Open Event
- disable message box during VBA code execution
- Convert cells to HTML
- Merging Columns, keeping text
- Merging Columns
- 1004 "Application-defined or object-defined error"
- MSForms.ReturnInteger assignment
- How to export/save the track change history into another worksheet?
- Help with "Selection.End(xlUp).Row"
- FORMAT CELLS
- Pulling up the Find and Replace Dialog via Code
- Maintaining Column Widths When Copying
- Excel 2003 addins don't automatically open
- Chart VBA Question
- Updating links
- Creating an Excel sheet with Addresses using a Macro
- Code created in a Macro not working for a Command Button
- Macro not working
- Splitting text document into chunks of 100 characters
- Concise border removal method
- how to remove blank rows from a sheet using visual basic sode
- Determine whether a wrkbook have been changed since the last save
- Macro Writing
- Excel keeps converting my %s to Time format
- Sum all cells with interior color...
- Help on VB Excel
- Exporting CSV Files
- Linking question
- Number format locale - XL2003
- Unloading / closing a form with the escape key
- Replace CR character in text pasted from Access database
- Format Excel Column via code
- How do I attach just one Excel worksheet in an email
- Change Shape Name
- Textbox Date formatting problem
- EntireRow.Delete, Causes Problems In ComboBox In Another Workbook
- Conditional Worksheet Access Problem
- Change Event Problem
- animated graphics in excel visual basic
- Using the Solver in a VBA function (not a macro)
- Help with creating a formula...
- Solver does not solve when called from a macro
- Mail_ActiveSheet and DeleteAllCodeInModule
- automatic exporting of data
- Database Search Form Help?
- And/Countif formula
- Need help with Macro in moving columns
- Format subtotal rows
- Macro Open Files
- multiple comboboxes to change displayed images
- Creating a Purchase Order Form
- Merging data revised
- Function Not Recognising Values in Populated Ranges
- Subtotals
- Wrong Number of Arguments or Invalid Property Assignment???
- Select number of rows in a graph?
- Wildcard to pull all data
- Row from database in Excel sheet
- How to add a new sheet with a name
- Scrollbar flash
- colouring a cell
- vba code to record a macro
- Can I do this with arrays?
- Pulling files in using Macros
- Defining sheets to be created
- Inserting foreign/special characters from a database
- Multiple "IF" statements every cell in range
- Can Visual Basic 2005 be used in Excel 2003?
- PivotField AfterUpdate event?
- Worksheets.OleObjects
- a letter equal to a number
- Count if with several areas/conditions
- Subscript out of range (Error 9)
- How to evoke a hidden userform?
- Text File Import (Date problem)
- Group controls
- Form not unloading before next code line
- Range names in a Excell macros
- RESIZE USEDRANGE
- re-calc
- appending some text/html to the "discription" field
- dimensioning variables
- Pls clarify how to call an Addin from another addin using VBA
- excel to word
- Button on a sheet always visible
- splitting information into 2 cells
- Sorting code
- checking Column for matching value
- Need Help with Dynamic Chart Worksheet Change Macro
- Macro problem...Will be a real challange
- Can't see all of one of my sheets
- How to distribute Macros/write add-ins in Office product
- Validation List advise....
- Duplicated occurrences of class variables - VBA in Excel
- Duplicated occurrences of class variables - VBA in Excel
- Auto notify a list of people via email when excel file is closed
- how to match/compare cell values
- Data validation, alpha or numeric characters
- bug in Excel 12?
- Create Hotmail Msg from Excel
- looping through chartobjects returns deleted charts also
- Excel PageSetup Error even when a printer Exists
- empty cells
- Email Help Please
- EssVSetGlobalOption , 6
- Command Button Date/Time Stamp
- Merging Macro - GetOpenFilename & Workbooks.OpenText
- Import Text File Into A Spreadsheet with over 65,000 lines
- Retain Format When Coping Visible Cells Only to New Worksheet
- How do I turn on relative reference(?) in a macro (97ver had butto
- Using DSUM on a Recordset
- BackStyle Property misbehavior
- VBA - remove all empty rows in a worksheet
- Can an Excel macro be automatically run based upon data in a cell?
- copy row and paste to another worksheet
- same info different sheets different cells
- Emailing an Excel sheet?
- optimization question
- File Could not be Found
- Automatically enter custom worksheets?
- Last Saved By property
- VB 255 character limit for strings
- Copy Sorted Coloumn
- Displaying Multiple values with message boxes
- Displaying multiple values in a message box
- if statement
- Rounding Numbers
- OnKey
- Clear selection?
- inputing data
- VBE Module Names
- MS Query - '' is not a valid name
- How to populate an MSForms.ReturnInteger value
- Multipage questions
- Problem copying sheets
- Text Export/Append
- active cell
- VBA Deleting in database from list box
- Test User before saving a file.
- Eliminating Multiple IF/THEN loops
- V Lookup w/ unreliable data
- Forms - Named Range as the RowSource
- Required fields
- Merging data
- Macro syntax to open file in current explorer folder
- RE: Divide Monthly Sales Budget to Day budget
- Macro Location Problem
- Issue in VBA functions
- Re: How to share files
- Refrence to Listbox in form
- Copy Sheet
- Excel 2003 - Keep a Macro Running While the Workbook is Open
- How to pop up a Macro when the cell in one column is selected-urge
- Mail_ActiveSheet()
- Notification
- get data from an Internet Explorer Table
- Return Array from Function
- shifting data in excel (logs)
- Double lookup count
- runtime error 424
- Searching for and Pasting Data to a new file
- is there a way to do this
- ORACLE SEQUENCES IN EXCEL
- VBA Code
- Error Handling on my program
- PHP's fgetcsv converting ¿0a to \n ?
- Inputing data twice into a Query
- Only Printing Header on First Page
- Looking for the truth !!
- Userforms and Checkboxes
- Turning Off Circular Refrences on open
- Opening an excel workbook doesnt work
- Adding an Add-in to a menu
- Writing a macro
- event triggered by cell format change?
- Adding an OFFSET condition to a COUNTIF??
- How to disable Max button on the Excel Workbook
- Selecting all sheets and sheet methods
- Macro finishes faster when left clicking during execution
- export excel data to another sheet
- crate formula in VBA
- Unlock a vb code of a workbook
- Excel to open word document -basics
- Why do VBA and Excel floating point results differ?
- multiple range using GetRange()
- Deleting in a list box
- vba
- adding code to a workbook programmably
- inputing data using vba
- IF Clause
- Copy rows from different worksheets
- Returning the index of an array value?
- Save as file name and specific field
- Populate word doc with excel data
- 'Cell is protected' after VBA runs
- Decompile Excel VBA code
- Hyperlink multiple Images in at one time
- Control Tip Text on Excel Command Buttons
- Excel-Web Queries to Babelfish
- corrupted .xls / Copy Modules???
- Code to Advance filter a list in a shared workbook
- Excel template in Public Folder opens actual file
- Late Binding Issues - My Bad
- Help with UserForm textbox code
- Late Binding Issues
- Creating spreadsheet of Outlook emails
- Need to compare values in two colums and delete accordingly
- Dynamically change cell range in formula by background color?
- Show value of variable on mouse-over in debug mode - bug?
- Copy method of worksheet class failed - help!
- lock button position
- AutoFill Weekdays problem
- Setting The Print Area
- Define User Access Levels to Workbooks
- How do I learn to write Visual Basic into an Excel Macro?
- File Error - data may be lost???
- Toolbar should not be on its own row!
- Compile Error
- Help with UserForm textbox code
- ComboBox Range
- Re: Variable range of rows
- How to Combine Data Regions
- Linking a cell to a textbox
- Insert Hyperlink
- SAP Late Binding Problem
- Insert leading spaces
- Code to hide Entire row based on criteria
- Sum Question
- Zoombox
- Remove ' if not followed by two digits
- How to Connect Data with ComboBoxes and Dependency on each other
- Posting times to an Excel spreadsheet
- Custom Number Format
- How to wrap text in a ListBox
- Print Macro
- ADO Recordset.Filter in Excel 2002
- Performing Action On Multiple Values In A Column
- Marking Dupes
- combining two worksheets into one
- Enter Formula via VBA
- migration issue - OpenText method crashes Excel.
- Is there a list of VB addressable fields for Excel ?
- HOW TO: Name Range?
- Run-Time error 1004
- Return selected option from a control
- Runtime Error
- calculations based upon months
- Userform Status
- Identify the column of a range by letter instead of number
- Syntax for Logical Operators to Limit Input?
- Missing library in Object Browser
- Modifying an Old Excel Macro
- Check for duplicate values?
- Macro To Scroll Worksheet Automatically ?
- How to exclude certain cells from a range?
- Selecting a range from second row onward
- Changing save as file format for excel from VB.net
- Excel VBA: Automatic grouping same entries
- Concatenating text
- USERFORM DISAPPEARS ON EXCEL MINIMIZE
- If number then... how?
- Protect cell and remove row datas
- FollowHyperlink failing
- Macro for counting the number of filtered rows
- ITeS and BPO jobs or Projects
- ITeS and BPO jobs or Projects
- New to accessing mysql dbase in excel vba
- Save As
- Refedit gets mad with touchpad
- Error -2147467259 (80004005) Method 'xxxx' of object 'yyyy' faile
- replace one tag in content of one cell and format not changed
- Excel Got FOcus event
- Keeping a named range between 2 dates??
- Fill empty cells
- Multiple column Combobox
- Connecting to Simcorp Dimension
- Moving worksheet
- Shell command to post to notepad
- The form name changes everytime we open the page
- interesting solver problem.
- Help in Pasting from 1 workbook to another in code
- Code help required
- Copying a range to a new tab
- VBA Excel Chart DateFormat Language Settings Locale
- Need Help using/calling a Reference
- Alphabetize when data changes
- Compare data between 2 worksheets
- Need Help using/calling a Reference
- Scriptin.FileSystem Network Unavailable
- Scripting.FileSystem Network Unavailable
- macro to input data on a specific date
- Need help with this formula in a macro, please
- Re: Calling a DLL Trouble
- vba range in vlookup
- how to loop thru cell in 2 columns
- How do I automatically calculate dollars earned with time worked?
- how many Fridays in a specific month in Excel
- Macro for importing data from one file to another
- How to pick the first day in and the last day out in a PivotTabel?
- VBA code for different versions of Excel
- export as vba macro
- How to print specific worksheets
- Identifying duplicate content in column
- Excel problem using DisplayAlerts
- How can I alter this Macro?
- Executing a subroutine from within a loop
- Calling a subroutine in a loop
- empty cell
- Pivot table question
- Pivot table question
- How can I alter this Macro?
- Resource Planning - How to Model?
- Search multiple sheets, then paste results in new sheet
- What does the '#' character mean when appended to a number?
- Alter mask of image on button
- Writing to a range of cells
- Looping
- cloneing cells in different worksheets
- Simulate Access' After Update Event
- Protecting worksheet within an Macro
- Using macros on different versions of Excel
- Need Help using/calling a DLL
- validation
- Help with ammending a script
- Need Help Using/Calling DLL Please
- Disable events
- EXCEL: put_DisplayAlerts fails if user is entering data and clicks toolbar button
- Customize ROW/COLUMN header
- Error 400
- Arrays and Join Function
- Dependency problem
- Web Query Error 1004 - Cannot insert columns...
- imitating cut and paste
- Creating Multiple Scorecards/Files and Compiling data
- Calling a DLL Trouble
- Marco and command buttons
- Is Excel VBA best for me?
- Mapquest Web Query issue
- Cell value change to trigger macro (worksheet change event?)
- Rounding
- Web Query: Obtaining source link from a cell in a macro
- Put a Formula into a Cell with Index
- compare two col data & add info
- Accessing specific items in a range
- Formula in a range which varies in size
- Integrate Word and Excel
- Prevent Duplicate Validation List Entries
- Copy the 14 cells and transfer them to another sheet loop
- Keeping the exponent at a fix value in Excel
- Pivot Table help!
- PullDown List with two Columns help!
- VBA Help: delete whole row if the cell does not contain string "*"
- New custom FaceID for automated button
- Worksheets
- characters and values
- Conditional Formatting
- Built-in Excel constant for maximum number of rows, for columns?
- ERACE MESSAGE FROM GROUP
- Can't open VBA-Code Window
- How to program an auto incrementable number in a cell, at each ope
- vb help, convert excel formula to vb formula
- Please Help!! DD:HH:SS to seconds driving me mad
- Removing and Restoring Excel toolbars
- Is it possible to create a patch or update an Excel Program?
- VBA Code
- Inserting a formual with " in it
- Remove screen 'flicker' on executing code
- Variable Picture in a Form