- Difference between Word and Excel
- More than 65,000 lines and ACCESS
- changing pivot table views with a macro
- Inserting Hyperlink
- combobox to drop 'up' not down
- Parse String
- VBE Question
- Data Form
- Data Form (ignore previous one)
- Macro to change cell borders
- Prevent running macro upon closing Excel
- another question for Tom
- matching items on 2 sheets
- Copy Column A
- How do I format a text box control to display the source in time .
- Setting up autorecovery problems
- Esc out of userforms
- auto add rows to ranges
- error on ActiveWorkbook.Close
- Format to percent in msg box
- Avoiding 400 Error code
- Open PW-Protected MS Access db using Excel VBA
- VBA Code to Import VBA Modules
- Find and Open Workbook then copy and move sheet
- VBA ActiveWindow.WindowState Problem
- Count Days Worked
- Two big size excel file
- updating a text box
- Please help me to adapt this code.
- Rename sheets
- Error unprotecting worksheet
- merging or cancantinating worksheets
- How would I set up a Genealogy tree?
- Help required putting borders around cells.
- Making Workbook_Open macro conditional
- Special Index/Match formula
- How do I split "A1B2" into "A1" and "B2" using text to column fun.
- VBA Guru's - any way to speed up this code?
- Automatically enable macros for particular template
- Turn Rows into Columns
- Turn Rows into Columns
- returning filename in excel
- Removing Excel Add-Ins
- Range Name
- Application-defined or object-defined error on copy
- Ex03 Custom views don't work
- Finding a match
- Rename Sheets
- matching items on 2 sheets
- Error Loading Add-In
- Argument limit on user Function?
- display sheet choices in combo box
- Visual Basic Error
- My Excel formula is using my text as a cell range.
- I need assistance getting VBA code to do the following...
- Passing a Range
- How to disable the "options" menu?
- Test for end of array of objects?
- recover worksheet
- RegEx Replacement patterns
- Passing an array in a user defined function
- Using Array Index function in a sub
- Inserting formula programatically
- Relative/Absolute Formula writing in to a cell.
- Excel97 Date and Time Help Please
- #Name?
- Workbook activation issue
- Help with Condensing 10 Digit Number Please
- Pivot Tables - Percents in subtotal
- De-link a cell reference in a formula.
- Moving data from Col B to Col A
- Out Of Stack Space
- Drop Down List Box size too small
- CutCopyMode | Impact on Run-Time
- copying results from multi selection list boxes to cells
- 3D formula fill in problem
- Status Bar with For Each Stmt
- Passing var types, groups and properties to a sub
- Simple Checkbox Question
- Use current filename as a string
- can I have a cell in my worksheet to control the number of copies.
- Problems with sorting a pivot table
- selecting filtred range
- insert sheet and naming it
- A repost - Permuting SPACES within a String of words
- Filling Series of columns with Dates
- macro to white out (to change a font in selected cells)
- Printing, VBA
- Problems with excel
- Greying out Custom CommandBar items
- Loop that deletes sheets if data ends on a certain row
- How do I open an excel 2002 file in C#.NET windows application
- Data won't sort
- Help with imprting a csv file into excel
- Target.offset
- Counters?, Count Rows?, Get Rows? in an Excel Macro
- Userform template/api
- Function parameter limit
- Moving rows to 2nd tab when worksheet is protected
- Send Macros with an Excek attachment using Outlook 2003
- RTD returning arrays
- Replace "#" with an integer in VBA
- Help with design
- macro to show on desktop
- Date Time Picker ActiveX Control Version 6.0 (SP3)
- ? for Jim Thomlinson
- Interaction with Internet Explorer
- aligning data lists with code
- how can I return the active row and active column?
- Custom Menu
- Function List
- Check Box
- automatically select object references
- How to require entry in a cell or group of cells?
- How can I make a custom button in one Excel form to e-mail easily.
- Refer to Elements in an array
- Format NOW function
- Programatically access Excel's Solver?
- For each Checkbox
- Using listbox as menu on userform
- passwords
- Import External Data
- Total Row Not Calculating Correctly
- shared files
- disabled list box text color
- displaying info on a form
- vb "400" error
- HOW WOULD I GO ABOUT ADDING SOMETHING LIKE A SHOPPING CART TO AN .
- String manipulation and creating an "offline" excel workbook
- String manipulation and creating an "offline" excel workbook
- Random entry from list
- another "400" error
- merging cells and comments
- Using Excel Spreadsheet to Survey Customers
- Using Excel Spreadsheet to Survey Customers
- UserForm positioning to second row
- String Function
- Naming and Adding Worksheets
- List Worksheets & Chartsheets
- Modify Name, Title, Author, etc. of an Add-In
- Working with columns of data
- Waking up a Printer
- Sort Filter & Create Text File
- Excel 2003 VBA question
- GetObject() returns different types of instances
- 2 Quick Questions
- Query on implementing drag-and-drop with VBA
- Excel Addin and Windows Profile
- SQL Query
- Error on refresh backgroundquery - help please
- Retrieving the state of a checkbox (form type) from VB .NET?
- text box
- When MultiLine Txt Box Returns a square to the formated wordwrap cell
- Sorting Problem Need
- Row color by grouping?
- inventory location flow sheet question - formula needed
- Reading dates from text file
- Loading Excel Data into PeopleSoft
- Delete a file
- Can I disallow the user to open a file if he disable the macro while the file is opening?
- Storing variable in Option.Tag
- Can I save my Excel sheet with Macro as webpage? It seems the Mac.
- Wrap Text
- Exporting to Word
- Run/execute VBS and pass arguments
- 4 column sort... Fools rush in....
- How can I set up a dashboard in Excel from which different worksh.
- Mass update VBA macros with batch program
- Finding column of a particular cell
- Hiding All Groups
- Change event help
- ScreenUpdating & DisplayAlerts
- prevention emergency kay - for experts
- Properties with Intellisense
- Range selection problem
- Application-defined or object defined error
- Deleting AutoFiltered Rows
- Text box
- Text file to measure file usage
- how do get rid of a selection after pasting
- Save Filename
- Argument limit in Excel Function Wizard
- copy last row without header
- Do you wish to clear clipboard memory?
- Only print worksheets with data in B2
- Path names to xla file in formula
- Problem with if statement
- Erase Code
- Saving in a location
- Rumba/Excel
- Copy picture from image control
- Moving Access Mini App to Excel
- excel VBA
- Auto-set Chart Data Range
- Analyzing Text file records in VBA without importing into Excel spreadsheet
- GetOpenFilename
- 2 Worksheet Comparison Across 2 Workbooks
- Microsoft Query: retrieve data by dates
- Microsoft Query: retrieve data by dates
- excel
- Restricting User Input...
- Run-Time error "70" Permission Denied
- Add shortcut key or hot key via vba
- scrollbar on a text box
- Formula - Time, Cell
- Insert the same value in other sheets
- Copying Workseet to NewWorkbook
- Abandon invoice
- VBA VLookup Problem: Run-Time error '1004'
- Unknown address change
- Comment indicators - web translation
- connect to an oracle db
- Automatically copy down a column
- Excel Access VBA
- IF Statements
- Shared Workbook; Update-on-Save not working when called from code?
- File name a variable
- splash screen
- Delete method
- sum over more then one sheet
- VBE Weirdness
- Macro Auto-Fill Field.
- Is this imposible for VBA to perform?
- copy temp sum in bottom right of excel to clipboard
- Internet Explorer & Excel
- How do I switch between windows in the active workbook inside a M.
- moving cursor to a text box
- Incorrect templates path
- Enable Warnings
- Failure to open workbook via automation
- Sort and Combine
- How to return the xlConstant for a number
- Hyperlinks - They seem to work fine - just cannot find the cursor
- Strange Log base 10 results
- msgbox
- moving cursor to text box
- Ecxel Macro to summary and eliminate duplicates
- Coverting Dates to Text
- word more intelligent than excel???
- So close! Problems with Loop
- Import txt file
- Excel97 How do I enter a formula help please
- function for finding position of numeric character in a string
- Recently Used File List Doesn't show saves
- Excel Linking to Access
- Using VB in Exce, can I loop through all worksheets?
- Import text file FieldInfo:=Array
- names changed somehow
- Online VBA Training
- excel and access melded would be a wonderful platform for medical.
- Find a String in a Cell
- Best options for importing text file
- Automatically Replacing existing file on save
- Extracting Custom Menu Code
- Naming columns
- Change cell formula & assign to VBA variable...
- Insert Row Condition
- Calculate Number Attending
- how do i auto date a page in excel
- how to reset a value in a cell after another
- Why is ActiveX invisible in Design mode
- Check rows for duplicate references and add related data
- Using 'On Error'
- Userform1-Can I override the need to click on the form?
- Select file after GetOpenFilename
- how can I add a print dialogue?
- Lookup Outlook Contact to Fill Excell Cells
- construct range?
- dialogue box problem
- Protecting non contiguous cells
- Copying a range of values between worksheets
- Redesign for hitting limit argument in a UDF
- conditional reset
- Changing Text in PowerPoint
- How to avoid 'Microsoft Excel is waiting for another application to complete an OLE action' message while debugging ActiveX dll ?
- Extreme slow performance of Excel while debugging from Visual Basic IDE.
- Macro asking for input
- How do I enter Unicode characters in Excel?
- VBA Equivalent of ASP 'Execute' Command
- If statement
- count non-empty rows
- Regular Expressions in VBA?
- skip empty sheets
- Button flicker with screenupdating
- Clear then move text up
- Some help w/ simple loop, please?
- New to VBA
- How do I write a macro copies a column to another sheet but that .
- Excell 2003-How Do I get custom drawn shapes into Autoshapes file
- ontime method?
- ontime method?
- creating a collection of Sheets references
- include empty sheets
- How can I set up a page tracker?
- Networkdays
- find highest number then select next cell
- messagebox problem
- excel freezing
- overflow error 6.. the macro just stops any idea why?
- Export Excel Data to an Outlook Email
- msg for ron
- Getting info off the Web into my spreadsheet
- Hidding macros
- vba 2003 cut copy animated border
- Extract formula from Text box
- Lookup/Progamming Help!
- ListDir
- Nesting ,Ands
- Error in code re case construction
- auto start filtering
- How do I determine if conditional formatting is applied to an exc.
- Formulae
- is word really smarter than excel?
- VBA/Vlookup with workbook defined in a variable
- Excel Start-up parms
- Find the range of a SubTotal
- Change color depending on cell value
- Web Query Query
- Dynamic copying & pasting of rows
- How do I stop duplication of cell data from a list (you can only .
- AUTOCALCULATION IN EXCEL IS NOT WORKING WHEN FORMULAS ARE COPIED
- Is anyone having problem with Excel 2003 Application.ScreenUpdatin
- How do I link the spreadsheet with data in MS Money 3000?
- Sumif Help needed
- Preventing screenupdating from modfiied
- User Form - frame scroll with wheel mouse and cut & paste from tex
- Copying an Excel Graph to PowerPoint
- Coping dates
- Embedded chart along with DATA to powerpoint
- Error exporting data
- how to get rid of selection of cells, after pasting
- Create User Defined Folder
- Can You Change A CommandButton Code Using A Macro?
- Formatting text in a a cell with selecting it.
- Check sheets name and open goto workbook
- Menu Issues when creating an Add-in
- User form/ to show please wait
- Application Error 1004
- Checking the number of files in a folder using VBA
- Merged cells numbering
- Count Rows
- Counting CheckBoxes on a Userform
- Addin Menu Question
- Getting value of an Autosum
- Changing a Macro
- Outlook and Excel
- Conditional formatting with imported data
- Update Complete Message
- Dim as CommandBar Does not Work
- Table Caption
- Finding column again
- Beep or Make Sound after Calcing
- splash screen macro problem
- Setup a macro to select a specific column within the same row
- Counting cells in a schedule.
- How to set Axes Min/Max values in C#
- Code to Send BCC
- Linking to hyperterminal
- Move down one line
- regarding filter
- Insert variable cell in the formula
- Custom date formats
- Looping through Worksheets
- Delete a Worksheet
- How can I export cell content in Excel to a text file?
- function trouble
- Counting how long a Macro takes to run
- Problems with R1C1 referencing in buildling indirect references
- Updating an Add-in
- Adding a Chart or Worsheet??? with VB.NET
- How do I populate this list
- Can I add a description column or alternate column in a validation
- Date and day
- Function behaviour, can someone explain please?
- Open file - How to test the path ?
- Message Boxes.
- To Bob Phillips ( Filesystem)
- Need VBA assistance for Excel Open Dialogue Box
- maximum days in a month
- Formula Replacement
- vba code
- Missing functions and commands
- how do i write a macro to automate some scenario/what if modeling
- Help please
- vba coding for formula in cell
- % Formated cells randomly changing to hh:mm:ss format
- Range name as varible
- change directory for refresh data
- Evaluating a Sting in VBA
- Macros
- copy worksheet to new workbokk & save
- How to prevent routine from running on certain sheets
- Format a txt box.
- MsgBox Syntax
- Workbook_Open
- Test if Cell is Empty or Doesn't Exist
- display contents of a worksheet in a form/frame
- Pivot Table
- a macro that launches another workbook automatically
- Re - Excel Loading Multiple Instances to Trigger Events amidst Switching-from-One-to-Another
- Distance To Margin
- Renaming a cell name
- Question about multiple data sources
- Password
- paste image into a form
- I don't get it, Whats going on here?
- MAKE WHEEL MOUSE WORK ON USER FORM FRAME WITH SCROLL BAR HELP!!!!!
- Please help to correct syntex error
- How to transfer the length of one column to a formula in Visual ba
- List valid values if a condition
- Time
- Averaging specific data in columns
- Calling a macro from a key
- How To Imoprt Text File With No Delimiters?
- macro - how to make working for colums D:X
- IE not detected
- Insertline Macro
- Add In target directories
- Copy sheets
- Detecting a printer is connected
- Using A Macro To Add Event Procedure To A CommandButton
- Programing cell comments
- How do I stop the cursor from scrolling?
- PasteSpecial Paste:=ColumnWidths
- Formula in loop stops working
- Custom button starts new instance of Excel
- IE not detected
- Buttons work (but don't work in a cell)
- Weighting random allocations within a range
- Automatic timesheets
- Stopping Display Alerts
- Search and replace for non printable characters
- Excel file gets corrupted
- Run macro in another workbook
- Copying formulas in a column
- To Read from an Excel sheet
- Message Box Pop-Up
- install a macro for all workbooks
- Adding custom faces-icons to toobar buttons.
- Format A TextBox For A Phone Number
- Too much for Excel?
- Identifying which workbook a worksheet is in
- Getting a File Date & Time stamp
- Speed up code
- I need to execute the SQL.Request with SQL strings larger than 512
- Copy Sheet Limit
- IsNumeric Test
- Shell command ignores parameters
- using automatic macros or object macros
- Using .Find with Hidden Columns
- non-duplicated values
- Copy cells without splitting column
- Re: Copy cells without splitting column
- Photo in a sheet
- Adding additional rows in VBA based on character strings
- macro stop before end if I use a shortcut ?
- Row parts and range confusion
- RangeSize set by macro
- Clearing objects in a VBProject
- Running an excel spreadsheet from a website
- Using SUMPRODUCT in VBA
- Can Cell X be modified by Cell Y?
- Delete String Element
- In excel, I am trying to copy a column to another sheet automatica
- time problem
- Email/Excel Website diff. methods
- Report--anyone???
- Picture resizing
- Dynamic Button Names?
- Creating a toolbar for my add-in
- Suppressing or turning off the Printing dialog
- querytable connection
- OFFSET in Excel VBA Function
- filtering question
- populate a validation List?
- Offset.Value
- changing value of a list box
- ODBC imports numbers as text
- Question about Excel
- Format As TIME In A TextBox
- Loop a macro
- roster
- Function in another workbook
- Custom Worksheet Header
- Macro, if then next
- Excel 2003 Memory Leak
- WS formula for Julian date not converting well to VBA??
- Assigning values to words, then referencing them in a formula
- open Goldmine email msg from Excel VBA
- Better way....
- Comments in cell (try #2)
- Saving file
- Put text on clipboard?
- how do i use the excel function search in excel vba?
- Visual Basic commands for email
- Network activities while runnung macros
- printing
- To read from an Excel sheet using simple ASP
- Function for summing values of a field by date criteria
- Can't think tonight - for a friend, can you help?
- IE not detected
- User created control for use in Excel?
- Tom Ogilvy RE: Yesterday
- Time Calculation - How long a macro takes to run
- Start macro by Command Button?
- Default browser for web querys?
- Re: advanced filter
- Re: Comditional Formatting Problem
- Re: Comditional Formatting Problem
- Re: advanced filter
- What Causes DSUM to Report #DIV/0!?
- Need Help Please: EXCEL+Vb Programming Newbee Question
- Calling an excel spreadsheet from within a browser
- Wondering why the following ADO connection to Access isn't working...
- Open a specific file
- Macro Excel 2000 do not work in Excel 2003
- Round number to 5
- I want to combine a "match" command with a copy and paste command.
- Combo box column widths
- headings in a combo box
- Public vs Global
- algorithm creation
- How to prompt user to set password that protects their worksheet?
- Refer to selected cell in custom function
- Listindex strange problem
- More than just time
- format cell in excel as to convert any numeral into words automat.
- Re: Re-formulating the problem: Dynamic Button Names!
- Re: cells automatically colour differently with 'what if' scenario
- Can I have an array of arrays and access an element simply?
- Re: Type Mismatch Error when running a SELECT SQL
- winsock lag error
- Programatically sending a sheet through Outlook
- Please help with do while
- Worksheetfunction help
- UF within a loop
- Re: Trapping NO selections
- Add-In
- The Web query returned no data
- Moving data between worksheets in VBA
- Private Sub Running Other Private Sub Inadvertently
- Prevent Excel VBA Code from being Interrupted
- QUESTION with Match command and OFFSET
- Pasting from Excel Clipboard with VBA Macro
- saving blob
- Unable to embed control - Microsoft Map is no longer supported?
- Use of public variables vs. passing arguments
- Export table to SQL
- copy photo
- copying deleting in excel vba code
- Recording a macro within existing macro.
- Renaming Worksheet Error
- OFFSET and SUMPRODUCT
- add-ins
- Financial Calculation: Return on Investment
- Size of worksheet
- HELP! Sh as Worksheet
- Personal.XLS MACRO Workbook
- Reference to analysis toolpak addin
- Re: For...Next Question
- Drop down list disapear
- Reported problems with Office 2000 Service pack 3
- Event question
- How do I create a formula
- Absolute vs. Relative Cell References
- Docking Project Explorer Vertically
- Convert Text Column to Date?
- dynamic named ranges
- Re: Button to allow a search
- Passing a range into a VBA function
- making drop downs "volatile"
- Formatting SUMPRODUCT
- Time sheet
- Make a Fresnel Zone Calculator
- Help!
- Msgbox delayed using AFTERUPDATE
- Populating a select group of cells with randomized names...
- user form and frames
- test
- Need help with FORMULAR1C1 property
- Need help with VBA
- VBA protection
- critique my project
- Macro to combine data in a column
- Generate Random Number Table
- Re: Type mismatch error
- Open a Workbook
- Function or VBA required to extract cell info from an unopened fil
- MSChart.chartdata + Excel Names
- For Each Loop with Exceptions
- Check for an item in a collection (without looping)
- Default column separator
- Find the zero(s) and remove from a concatenation
- Run Macro
- Problem running code behind a userform
- OWC Spreadsheet focus
- Select numbers between two numbers...
- Button to stay on screen as you scroll
- help
- hide or unhide pivotfield using a checkbox
- File Always Asks "Save Changes Y/N" even when no changes made
- XML creation via a macro
- How can I get a larger list height for a combobox while drop down ?
- Shortcut Menu With Toggle Control
- How to consolidate/sum a list
- Copy Method of WorkSheet Class Failed!
- Convert net tons to long tons in an Excel Spreadsheet.
- hyperlink to a button
- validation cell
- Change Event Track
- data validation cell
- VLookup problem when a new row has been inserted
- Select Case with Text
- Run-time Error "13" - File Type Mismatch
- Trimming Email addresses
- How to trap automatic link prompt when an excel file is being open
- Automation Errors
- Select and Move based upon keyword
- Button Control Jumps Around
- Add-in Asking to be Saved
- Calling a macro on a remote computer
- Tracing and reassigning macro short cut keys
- Merge rows with similar data
- Dave Peterson
- mouse position in EXCEL
- Lookup in VBA Array
- RS232 to Excel woorksheet
- Suppressing events
- don't find my message : connect to oracle db (4.2. 19:39)
- Any takers?
- Delete Rows on cell content?
- Copying sheet to another workbook
- Cell 255 character limit & VBA
- Obtain value of a control on a shortcut menu
- Code to trigger drop down-select event
- Can we use "*" to replace string in VBA excel macros ?
- How do I sum hours from multiple workbooks?
- need to remove last few characters from data in field
- Running code from list
- Erroe on Geting External Data
- Closing Excel within itself
- Password Pop-up Dialog on Excel Exit
- File Length
- Change Event on Sheet Objects
- application.dialogs(xldialogsformulafind).show and then some ...
- excel, vba and vlookup
- References in VBA
- Restricting Opening Workbooks in a Previous Excel Process
- List Header Rows Property
- replace names
- Using methods in functions with arguments.
- error in geting external data
- Recalc on HUGE workbook
- Search using document properties
- SaveCopyAs
- QueryInterface for interface Excel._Application failed
- Saving workbook
- Date/Time in different time zones
- copy method in office:mac 2004 Standard edition
- Merge all files in directory
- Speeding up calculation
- vba code for validation
- Formula that referance a Cell
- Dir("D:\") refresh problem
- how to stop "On error resume next" ?
- computing ratio for samples with many subrecords
- quarterly reports
- Capturing a Cell Reference After Update
- Using SUM with a custom built range
- ActiveWorkbook SaveAs
- HELP WITH CODE
- Get range value active workbook on open add-in
- Updating Column
- Language
- Workbook_BeforeClose problem
- thoroughly-baffled by InStr function w/ binary compare
- Excel Charts into Powerpoint
- sendmail macro help
- last digit
- Write Procedure With Logic Test To Open File From Given Directory
- IE in Excel with intellisense
- Renaming an Excel file using a macro
- Copy/paste range without resizeing cells
- trying to find random drive letters
- Time Code
- How to know whether it is using ADO ?
- reference to cell left of a cell...
- ADO recordset error
- Problems with BeforeSave and Application.EnableEvents = False
- Select Case on a range - problem
- Increase macro speed?
- Autofill
- Frozen Status Bar upon Errors
- Code behind worksheets
- terminate a runnig macro
- shortcuts to excel files.
- Import Text file
- Why get Ref in my cells ?
- Calculate on Status Bar causing VBA to run very slow
- Move an Excel macro to another Excel file
- Select a cell
- Select Until Empty Cell From VBA Code
- Input box used as password input
- Looking up two variables
- Beep when Messagebox is displayed
- i sent by mistake
- "Type" statement and arrays
- Application Run Time Error 1004 and Stack Error
- OnTime method
- how do I import macros from other users
- Workbook_Open() problems
- UserForm Viewing
- Using Trendline Formula
- Removing every second instance of comma sign
- Multiple Occurences within a range
- User forms in Excel
- Autofit of Row Height with Merged Cells - AGAIN!
- Using formulas in Excel
- chart
- Calculating Minutes and Time
- Execute on Cell Change - Problem
- Send Mail question
- Detect Custom Menu
- Function limitations?
- Control to Choose Row and Column in spreadsheet
- bad arithmetic
- Search Cell Address and Cell Names in VBA Editor
- Does VBA round .5 up or down?
- ToDo utility in Excel VBA?
- Filling a cell with today's date (Datestamp completed marco)
- Maximum Number of Bloomberg DDE Links
- help with web query
- Can't Exit Design Mode because CommandButton2 cannot be created
- vba filter dates
- Attachments
- PivotTable using Named Ranges
- Inserting time into cell in excel and have it not change
- list boxes
- Querying Data from Secured Access Database with VBA
- Disabling Row Select from Header
- Automate multiple series line graphs
- auto run macro
- another listbox question
- IIS, Excel, client server Excel... what direction to take
- function and combobox
- user form and frame control
- Creating Pivot Tables inside a Macro
- excel charts
- Automating Modification of a Cell Link
- Type mismatch accessing variant array too many times