- macros
- Excel Version
- Automatic TickLabel and TickMark Spacing
- Acrobat 6.0 and UDFs
- Linking a Word Field into Excel
- Re: Toggle Hide/Show
- Multiple Instances of Excel in WinXP Pro Task Manager
- #N/A Errors to 0
- Knowledge gained from Access to Excel VBA Automation User request
- Old Macros in Excel 2002
- Compile Error on "dim x as VBComponent"?
- Help with SaveAs
- OLE DB Provider
- very Important
- Testing for null or empty
- CheckBox Event
- Concatanate odd rows
- vba help doesn't work
- Combine All Worksheets into one
- Append Data to Table after Web Query
- Unhiding workbook when loaded
- Excel programming book recommendation
- Excel not prompting to save Add-ins
- Modifying pivot table changes chart type
- Custom menu depth
- 2 Collection questions
- Second subroutine to run automatically
- Merge multiple cells
- Conditional Formatting
- Userform web Data query table
- Toggle Hide/Show
- Maximum Absolute with sign
- Comment Indicators - can I change the color of the little indicator ...
- pasting cell range in an email
- How do I get macros and hyperlinks to update when I change the name of a worlbook?
- Post Excel Data to a Web Server
- Path in Footer
- Select through last non blank row in a column
- Pivot table question
- Matching problem....
- Defining Trial Period of VBA Code
- enter data from a form to "found" fields
- Merging copies of worksheets
- Display unique values in a range.
- Problem with Alan Beban's ResizeArray
- Auto filtering with form type pull down menus
- Forms blank out, periodically
- SolverOK problem - very frustrated, please help
- CombBox - Object of What Collection?
- Excel VBA Save As
- Globally define all Excel worksheets as text
- Customizing pivot table with macro
- What's the best????
- Edit Array Funciton
- VB coding for formatting time used in calculations
- calculating age from date of birth
- Kung Foo Masters Only
- Identify Blank Cells in Col & move coresponding data
- Not Unloading a UserForm
- also,
- Filter on a Protected Worksheet
- need a function (not macro with ontime) to record a snapshot of a changing cell
- Deleting Specific Rows - urgent
- Stats Question
- Timer control
- Show changes after a Merge Workbook
- Log Normal Distribution
- lots of text in text box problem
- RANGE & NESTED LOOPS
- File Searching
- Assigning a Range to
- Send form as attachment via code or macro
- Date Entry Script
- OnTime Help
- Duplicate Email Addresses
- Re: Command Button that changes cell properties
- how do I: launch a macro if two cells do not equak one another?
- Knowledge Base 247412 need help to make work
- VBA - Looking to strip alphanumeric from numeric
- Cannot install Excel 2002 Analysis Addin Toolpak
- Import form from Access?
- SaveAsUI
- searching sheets in large workbook?
- VBA - Today() not available in VBA?
- How to retrieve content of the Excel cell?
- How to auto hide an empty row with VBA?
- VB Error: Paste Special method of range class failed
- Oh no! Need help on unprotect password protection
- Generating reports
- Excel 5.0 entering date
- Append data
- Making GIFs from anything, with optional resizing
- OutlineLevel and Integer Variable issue
- Double-click date entry
- Error Handling
- Access protected VB code by initiating password dialog box
- Don't Update Links to Ext Workbooks using VBA
- Excel 2000 code not working in XP
- How do I get the file properties?
- Autohide Rows based on condition
- linking excel sheet to access using code
- Help - setting up manual recalculation when opeing a file (but before it starts recalculating)
- Why does sendkeys seem to loop
- Most Interesting Problem I Had Ever Got.
- Excel App "invisible" to user
- Code to make sheets in a workbook visible
- How to load a help file using VBA
- Format dates in VB
- Force Macro Enable
- filter problem
- Kill Command
- Dialog boxes in Excel
- Get Max Date From PivotTable
- Hide all menubars
- Runtime 1004 unable to get find property of range class
- Please Help (text file to excel)
- Line insertion
- Excel OCX/ActiveX Visual Controls for creating a Excel Dashboard/Scorecard
- Cell lookup
- Existance Check Fails
- Convert data from MS Word
- How to fill a sheet in Excel2003 with CSV data?
- chart updating
- POP-UP
- Linking EXCEL WORKBOOKS
- Visual Basic editor terminates Excel 2003
- excel vba date format prob.
- Check if activesheet is protected
- WorkbookOpen
- Passing ClientCertificate data from excel to asp/aspx
- auto sort
- Forms Box
- Trap CTRL+C keypress event
- Maintaining column formatting when copying a row to another sheet based on a value
- Hide toolbars
- Calling Sub with Parameter from Menuitem
- Can I make my own FaceID's?
- Help with Pivots (.Pivot Items) - Excel 97
- GROUP
- Turn Off Warning in Macro
- Change active cell properties with command button
- How do i find the last cell range in a sheet
- Pivot table
- Re: Defining input box data type?
- MouseMove causes Excel Crash
- capture paste event into a cell
- Adding Hyphens in a number
- Macro not showing in Excel spreadsheet
- Keeping button pointing to original workbook
- Setting the Values Property of the Series Class
- Copying Text from TextBox into cells in table and then addign a new row
- Insert a value based on unique valuse in a row
- two things: auto email and archiving
- Excel password but cant hide the sheets before entering password
- listing macros associated with shortcut keys
- menubar buttons don't appear
- Re: Change active cell properties with command button
- Keeping name of worksheet who called macro
- Export to CSV to speed up Loop
- UPPER and Proper Case
- Urgent
- Global Variables using User Forms
- Speech.Speak error
- Runtime error '429': ActiveX component can't create object. HELP!!
- If statement or another formula help
- Speed--Excel 2003 RAND vs. VBA Rnd...
- opening a form automatically
- How do i express this in number
- option strategies
- Protecting worksheets with Macros in Shared Workbooks
- MOST & LEAST OCCURRING INTEGERS !
- easy combo box issue
- zip codes as numbers
- Searching a txt file for splitting into different worksheets
- Corrupt File
- edit a macro using a macro.
- Graph Simple/Quadratic equations
- Groupings
- Populating a 2-D array
- SetFocus in user form
- Office Assistant Balloon User Input
- search for cell value and return row values
- sheet.columns("K:M").EntireColumn.Hidden = True
- Automatically adding ':' to Military Time
- Automatic execution of macro
- Macro to Modify Another Macro
- OnChar function
- Automatically converting to HTML
- Need to randomly populate a 10x10 array of cells with 100 names - 5 people listed 20 times each...
- True and True
- sub directories
- Input mask for date
- VBA and norminv
- Hide/Unhide sheets
- Loosing Cell Selection
- Scenario
- On error resume next statement ignored!
- Excel Automation Find/Replace Excel 2000 and 2003
- cells in ascending order
- Publishing VBA Functions
- Autosave of xls files in csv format with macro
- Sum accross sheets
- #value
- what's the Bug....tell me what's happening???
- bank account
- Using Spinbutton to change a date
- Disable Print Button In a Single Workbook
- import- export XML in excel without loosing XML format
- check writing text
- what does (ByVal Target As Range) mean
- Change Event.....Spell Check
- Change Event.....Cell character count
- a label for each name in a list
- add another text box
- Range Question
- Reference an image in another sheet
- Graphics
- Overlapping combinations problem
- Running Code Automatically
- Security - Protecting Macro while generating workbook thru VB 6.0
- Similarly helpful AccessVB forum?
- Please Help (text file to excel)
- path strings
- String to Array Conversion
- class? Compile? XLA?
- Link to User form
- Wrapping Text with VBA
- How to "push" a value into a cell
- Number format in vba
- CopyFromRecordset not starting at current row
- Shell
- formatting for feet and inches
- close(savechanges,filename,routeworkbook)
- copy and paste in different columns with conditions
- unwanted zeros
- excel VBA problem
- Macro - copy entire row and paste at bottom of another sheet
- Code for Subtotalling?
- Moving the Command Button
- determining coordinates for screen placement of user form
- Vlookup Multiple
- String to Range?
- Run-time error '424': Object required
- colorize row if...
- Excel Product Id
- CurrentRegion Selecting
- keypress to fire command button
- Form.Refresh doesn't work...help !!
- Reference Access created form in excel
- Canadian Postal Code
- Terminal Server 2003 + Excel 2000
- Print single sheets from rows of data
- Dynamic 2D Array
- Macro help - copy row, clear, and paste on different sheet
- Running Multiple Modules With 1 Command
- Passing Excel formats in VBA date variables
- A counting problem?
- Date Function
- Text box format VBA
- Array Lookup
- Multiple Recipients in SendMail Method. HELP!!!
- Understanding Selection "Type"
- Need help subtracting time values
- Array MATCH function for VBA
- Trying to make cells numeric only
- Re referencing an object
- Excel auto macro problems
- If values in two columns are equal I want to automatically execute a macro
- Jump to section in Validation List
- Creating UserForms in Excel
- Publish to Web, Zero Values setting not saved
- Scroll Bar
- COM Interface and IDE caching
- create worksheet and insert row
- What Tasks Can Be Automated?
- Can not set Y Values in XY chart
- For Robin Hammond
- VBA on the net?
- VBA code halts after opening a file
- Sendkeys and NumLock Key
- CreateTextFile not updating file
- Find cell select row and delete
- Converting Access dll calls to Excel program
- Save As - using data from two cells
- 2 or 3 rows, not just one
- Calling lookup table gurus.
- use a txt.value on a form to search a sheet
- Cell Background Color
- FUNNY BUTTON
- Find row number of maximum value
- 2 lists of values - identify differences?
- Help with data entry form please
- Can anyone help?
- Convert MS Word table to Excel
- my stock quotes
- Run VBA from Hyperlink
- Setting the default file name in the XLDialogSaveAs dialog box
- stars **** in cells
- Formulae required
- form macro
- Self-updating shortcut menu
- Strange vlookup problem?????
- Screen flashing during macro execution: Interesting observation
- Mapping macro
- Delete characters up to ":"
- Clear Clipboard
- Using BeforeClose for deleting a custom toolbar
- Picture Tiling property
- Write a macro ro copy column at certain time of day.
- Help
- Workbook_Beforeclose vs BeforeClose Event
- How do I update calendar control 8.0 to 10.0
- join more workbooks in one and print sheets
- Trying to select the visible range of cells
- how to know the number of lines on the sheet?
- Using functions in personal.xls
- Responding to Outlook Errors when useing Sendmail!!
- Enable/Disable Button
- order worksheets alphabetically???
- comparing columns from different sheets
- Just a button
- Clipboard
- Finding substrings within a string
- Changing www links in spreadsheets
- Detecting a network connection
- Showing Pictures
- link text box to Enter Key and button
- Custom menus clean-up
- Data Validation Questions
- download a file from a webpage with VBA
- Sending email from Excel
- Positioning the Insertion Point in a TextBox
- Copy Column and Paste
- OT: Is certification worth it?
- Efficient Looping
- ComboBox DropDown when Key is pressed
- FileDialog
- Copy-Paste while looping
- lookup and offset combination
- Conditional Formating issue
- Some VBA questions about cell selection
- Why "User-defined type not defined"
- Validate Cells based on if conditions
- VB.net and Excel COM exe
- ListView to Excel Code (but needs SPEED improvements)
- Data Tracking - Update only with "save"
- Eliminating Blank Rows + "COUNTIF"
- Mouse in Code View
- Watch cell value
- Set Range Var with address length over 256
- Suppressing links message
- Navigating in big list
- Toolbar with Macros
- Macro problem
- Emulate Access with Excel - display form for data entry
- MSDN Library
- checking drop down
- Need help with array formula to count rows w/ mult.criteria
- Mail ID from wabsite with VBA
- Checking contents
- Vlookup - Multipel results
- Excel Database in shared environment
- Overriding Actions of Excel DropDown Menus and Poup Menus
- Extracting info from different rows (& columns)
- Visual Basic Code
- Problem with Application.Width
- Column aliasing fails in ODBC queries w/multiple tables
- cammandbutton into a graphic sheet?
- Inserting comments
- SQL Select statement with Date as
- Inserting comments
- Icons on toolbar buttons (Was: Toolbars with macros)
- Macro: Excel 2000 does not work, XP does...
- Trigger Code with Mouse Click
- how do I build a pause (or delay) into my macro?
- Do not print if error
- Calling Add-In subroutines from other modules
- Saving only 1 sheet of a workbook
- pull down menu
- How to import Text file to Excel
- If Cell in row has data then do this: HELP
- add end rows after suppressing prior rows
- Simple VB Script needed
- Data Comparison
- Help please! Running mothly cumulative average vs target
- Comments
- Combobox selection
- Any simple method to convert Lotus 123 program to Excel VB ??
- New to macros
- Inputting data from Userform
- XL97:Combo/DropDown box and Not In List
- Forcing legal to print letter
- documented memory leaks in Excel 2003 or OWC11?
- Resetting cells
- print row
- need to append range name size with new entry automatically
- Simple VB Script - Part 2
- Macro to move, create formulas and loop
- Convert "merged" cells to "CenterAcrossSelection"
- Grouping Event handlers
- Selecting a printer
- Copying from excel sheet on IE webpage
- Printing a legal sized document on letter sized paper
- Need vb to automatically download from https website
- The cell address of a button?
- Add drop shadow to cells
- Assign button to run macro
- Changing cell value depending on dropdown list
- How do I?
- Macro moving a directory with XP
- Macros work on my computer but not another???
- Macros to Create Pie Chart
- Simple programming question
- Multiple Macro help
- "runtime error 9"
- Excel Relative Macros
- Comparison
- Web Query
- "Application-defined or object-defined error" while printing excel report
- Lookup 'Like' values???
- How to restrict the number of rows & columns?
- Sort using 4 keys
- Problem, need urgent help!
- Merging Files
- multiple user DB access via Excel (troubleshooting?)
- bug submission?
- SQLOpen VBA
- Reassigning macro to add in function
- If then Cell comparison with text.
- Setting a print range using variables
- finding a common set of numbers in separate rows
- Copy Table to New Sheet
- Autonumbering
- Excel VBA - Sort a table with BubbleSort
- VBA code for: Saving to desktop?
- Changing project desktop icon
- Solver and Excel programming problem
- Macro to make a cell work like a check
- Run-time error '1004' PasteSpecial Method of Range Class Failed
- Export information to Access.
- 2003 tax copies
- Calculating Average on variable sized datasets w/VBA
- Clip Board
- Hidden Column in VBA
- Automatic Macro in Excel
- Max of VBA Array
- running one macro from within another
- What does "Application-defined or object-defined error" mean?
- Dumping multi demensioned array into excel
- Highlights
- Double-click entry
- VLOOKUP into another workbook
- Missing Files
- Excel VBA-Looping through Multiselection
- Deleting an Excel cell
- How to find used range of a row/column?
- next available row
- Finding out the workgroup templates path
- Introduction to VB and Excel
- Remove value after decimal point
- General question
- Checking contents
- importing large numbers to vb results in the numbers being formatted to scientific
- file browser when a cell in selected
- Stripping data
- copying text from one group of cells and putting them in a table?
- Getting system information
- Macro dislocated
- formula to follow preceeding value
- Crazy Combobox
- Download (copy) file from the internet
- Excel VBA - Automatic adjusting of 2 windows
- start up screen
- Hiding #N/A
- ParsingName
- Changing the contents of a cell... dynamically?
- Hiding rows based on cell content
- Disappearing Posts
- Comparing 2 worksheets
- Object Calendar 8.0
- Adding up Time like decimal values ??
- Executing Windows Comands using VBA
- Iteration programing
- MANAGING PRICELISTS
- Excel with Access
- ambiguous name detected
- Insert
- Sort Method Questions
- Excel VBA-Looping though MultiSelect on ListBox
- insert row...with reference
- Determining biggest variable
- Limiting the cells a command button can change
- Re: Ascii
- Where can i find the vba documentation
- Re: Tricky Question Re: File Properties
- Autofill - Autonumbering
- multi-file open to one workbook
- Re: VBA - Only Selected area visible
- Excel VBA - automatically extratcing data from two different files
- file prompt
- Problem with using a macro to create a chart
- Dump 5D VBA array to 2D excel array
- Which workbook is stuck in memory
- Which workbook is stuck in memory
- Locking/unlocking cells
- identifying shortcut keys associated with custom macros
- Export textbox value into a spreadsheet cell
- excel reader
- Code is dragging selection when should copy
- Dynamic Table of Contents
- Dynamic Status Bar Routine
- Excel 2000 macro error
- How do I? Link Row Headings
- SMALL(?)
- ScoreCard
- file prompt - more info
- Self-certify in XP
- Append Excel 2002 data to SQL
- counting column elements
- Array Join & Filter funcs
- list box
- Printer Driver Function
- Linking cell
- Error Message..."No more new fonts may be applied in this
- Append from Excel 2002 to SQL
- Showing plus sign on positive numbers
- Linking together data from Eeevvverrywhere...then printing it
- dynamic buttons
- change font size and bold in cell?
- Macro for Multiple Sorts
- VBA code for set print area
- Cut & Paste Loop
- Using Excel to handle Com callback procedures
- date column
- Excel interpreting HTML and CR/LF
- Fancy Object Declaration
- Counting Days Between Variable & Fixed Dates
- Toggle Acrobat add-in on/off
- Re: Arrays
- Populating Third Dimesion Based on Average of three elements of Third Dimension
- Copying data from one cell to another
- Call a proc inside itself (HELP)
- Re: Adding Time
- Hyperlinks
- import from txt file
- Chart - Title Widths
- I need a macro that copies that data from one cell on one sheet to a cell on another?
- unblock .exe attachments in outlook
- control box
- Remove CommandButton
- Copy Sum Rows to Totals Sheet
- Accessing a single worksheet in a workbook
- Form Textboxes
- ADVANCED data strippping
- Excel VBA - 3 Problems (Yes/no box, Password Box, Run Dialog)
- Add-In communication with outside Application
- error control
- SUMPRODUCT help, please?
- Macro
- Button - Save Location
- Date Validation?
- find last row on a worksheet
- Limited help from err message
- Re: If Cell in row has data then do this: HELP
- Cancel Button
- BROWSER
- Custom Data Sort
- Copy entire Worksheet how?
- Re: Custom Data Sort
- Sum Multiple Columns with Macro
- Revisited: If Cell in row has data then do this: HELP
- keep the VBA modules in Excel transferable among different computers?
- VBE Options
- time keeping
- Two Questions...
- Excel Macro
- excel 97 crash
- subtotal with median
- Sorting 2D portion of 5D Array
- Extracting nth element of X dimension
- Updating entries on a spreadsheet via Userforms
- Optional Arguements for Functions
- Error 40036 when activating a sheet
- nesting problem
- protect formats
- Create workbook for data export and then data import?
- custom toolbar loses settings
- Shared Workbook - insert row and keep validation & format?
- Subscript Out of Range error in Array...
- Blogs, sites, books, sample code, Excel+VBA+Finance
- PivotCaches.Add
- Documentation
- Copied shapes are some times oblate
- how to run VB with excel chart at PC without Office2000
- Custom cell formula
- Open data
- Command button
- safe protection of sheets and vba
- HELP - weird Negative Numbers
- Autorun a macro
- offset function
- VBA: Finding duplicates in Change Event
- sum of multiple columns width differs from single column width
- Textbox formatting
- function wizard access violations
- .NET dll
- Switch To/Retry message appears
- Non programmer needs calculation help!!!!!
- Problem with decimal number smaller than 1
- Help! (I need somebody)
- Format Cell Content
- Userform idea
- find existing worsheet
- Control Toolbox vs Forms
- Att: David McRitchie
- CopyText
- Plot data on map
- Sorting algorithms used in Excel
- excel macro
- Now sure how to get data from another sheet
- Reference names and hyperlinks to other files in other directories
- I need help with a macro
- Procedure loop limitation?
- .select efficiency
- Use excel in html format change the links
- combo box not working
- Date Update
- time conversion
- Look at corrective update from Microsoft Corporation
- Dependents on another worksheet
- Extract parameters passed to a function.
- Copy data not format
- Macro Size Limit / open macros with macros?
- Date Functions
- Excel VBA - Help with a loop, compare, delete problem
- Use a cell with text on it as part of a SUM formula
- delete folder
- Out of Stack Space
- Application.Run Method
- Create/Remove toolbars
- VLOOKUP return - #N/A
- xp shell command using vba
- Disable Page Break Preview Button
- Open As Readonly
- Data ranges
- Excel template file, where is it?
- Show All PivotItems in XP pivot table
- RePost: Summing column in 5D Array
- Recursive Subs?
- Conditional Formatting to Validate Data in multiple worksheets
- Activating a modeless form
- Cell value in a formula --> Indirect function? Help please...
- Could not find installable ISAM
- CHANGE QUERY SQL CUBE FROM EXCEL
- Passing parameters
- Deleteing Rows
- Adding a new Line
- add macro to wksht
- Allow access to visual basic project
- Clearing Collections
- Macro to Color Code Cells
- Can I "compile" VB into an executeable program?
- .xls file keeps referenced addin(.xla) filepath?
- VBA - Immediate Window not docking
- problem using Set statement to define range object
- Autocomplete Possible?
- Selecting a PivotItem in code
- CATO file import to Excel
- Return an array of all page ranges in a sheet?
- Printing problems
- Downloading full pages to specific targets
- Macro Library
- Radio Button Selection in UserForms
- Toolbars
- How to Unhide and Use Columns to the right of the worksheet
- Iterating through workbook capturing text
- Configure Combo Box to Show Unique List Values Only?
- Further Split-type help, please
- writing a formula in VBA
- Chart - Title Widths
- Format a header when using Range()
- Formula help please
- Seperate with space
- Run-time error 2147220960(80040220) mail with outlook
- Re: Type mismatch
- MsgBox Question - HELP!
- "IF" "AND" Functions
- Capturing Screen Size Help Needed!
- Random Text
- Can I turn off roundup automatically for a cell?
- Re: Property Set
- data entry...
- creating unique new worksheets
- Macro Security
- Populating a Named Range...
- Thank you re VBE Windows problem
- Progress Indicator in form
- Combining two arrays
- Removing Command Button
- Saving file without macros
- Making your UserForm print other workbooks
- Export to Excel
- VBCodeMod crashing Excel
- Copy recordset from an Access "make table" query
- Opening a Workbook
- How do I sum across rows in a macro? SumIf?
- referencing a sheet in VB
- Error 1004 in printing .ps (postscript) file from .xls file
- BAR CODE Instruction
- calculting stats of column array in 3D array
- Changing Freeze Panes as I scroll down
- Combo box
- Cannot loop through rows in C#
- turn $12 to $12,000
- VBA creating Pivot Table
- cell reference in another workbook
- Need help with a macro
- Copy and paste selections and formatting to new worksheet
- stock control
- forms and reports
- Fill emply column with formula
- Open image from web in window same size as image?
- Re: AutoSequencing in a New Worksheet
- Removing dashes in entire column using VBA
- Copying Range
- Starting Excel from cmd pmpt, pass parameters
- Cell/Variable content substitution
- Help... This code consistently crashes for no reason.
- Re: Excel VBA - Opening Files
- Create new workbook
- Limit worksheet navigation in Excel 2000
- Activeworkbook.Saved
- Cell Reference- Hiding Rows-Urgent
- seperate contents of a cell to two cells
- Re: Type mismatch
- HELP URGENT PLEASE !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
- Timer
- Closing files without save
- Files in a dir
- excluding a value in a max determination
- Exotic CheckBox
- Autosaving
- how formatting CSV file to get alt-enter text in one cell
- FILTERING PRICELISTS
- Logical or
- Web Query - No data
- running windows system commands in VBA
- Update
- MD5