- Excel events - please help!!!!
- Formula
- Calculating R-squared value
- Changing Font Color
- Errormessage when button is pressed twice or more
- How to use Treeview control with Imagelist
- How do I polpulate a list box?
- other type values in array.
- other type values in array.
- Proper case
- Help of VBA?
- Project stays in VBEditor when workbook is closed
- functions run 2 times.
- <shape>.GroupItems acts different in XP for sub-groups?
- Automation error -2147417848 (80010108)
- Excel - Return column alphabet from column number
- Email in Excel
- Re: Sorting a protected worksheet
- how to set default value in list validation" did not return results.
- Re: Sorting a protected worksheet
- Method Range of object global failed
- excel focus problems with custom RTD server (real time data)
- Code runs in XL97 but not 2000?
- Screen Flicker when changing row height
- detect if file opens read-only
- Re: Log file ??
- Excel FIle Not Opening
- sendkeys statement
- Leftmost and Rightmost Cell
- Re: selecting multiple sheets by use of an array?
- Macro to create large 2d surface charts.
- Searching a range in Closed Workbook
- Run Time Error with Toolbars
- InputBoxes Exceptions
- Installed add-in not loading when Excel 2000 started
- Saving to Removable storage
- Automate Word via Excel
- TextBox Formatting
- Help With Very Simple Code
- Sheet Delay
- Can't get Web Query to work
- Reply to Tom Ogilvy
- Protecting Data Validation from being overwritten
- how to tune the resolution of an exported image?
- UPDATE & COMPARE
- reloading arrays
- Opening New Email On top of Excel / SetForegroundWindow
- Real simple VBA not sure why I cannot paste.
- Searching for cell and comparing different workbooks
- Searching for cell and comparing different workbooks
- Missing Nav Links in VBA & MSFORMS Help
- Re: Linking sheet tab names to cells
- date time picker
- Pivot Table not in order - why?
- Re: End of Page
- Excel Add-ins
- Range < - > String conversion.
- Getting a subrange of a specified range.
- How do you build pivot table in VB
- RE: windows 2000 puts my files in lecture only
- Creating remote objects
- Event Procedures: Event on Worksheet to fire Event on another Worksheet
- Coping a sheet
- Re: Can't Set DisplayAlerts to False
- compile error in hidden module with excel 2003
- creating macro to ask for variable info when excel starts
- Insert data between 2 fixed rows
- textbox validation
- PivotCache.CommandText - string length limitation in Excel 2000???
- Re: Excel recalculates formulas when opening files last saved by an earlier version of Excel
- VBA noob - making the date appear on/from a form
- #VALUE! position in column of data
- Paste special values
- Go to SELECTED CELLS
- Delete Shortcut with Code
- antilogarithm
- MSGrid.TWD in Windows 2000
- Adding menus!
- Using value from pulldown box in macro
- User defined menus and functions!
- Criteria Fliter then Count results
- Access a Web Site from VBA,
- Easy one: Focus off individual cell?
- Selecting sheets without specifying
- Re: Excel 'file locked for editing' by <me>, how to avoid.
- Pulldown Sub-menus within the main menu!
- Delete names
- Supress "now printing" message
- Code modification - remove commas from names
- Add border based on date
- changing the value of one cell using another cell
- Accessing PowerPoint files from Excel
- Copy Value but not Formula
- Excel macro licencing
- Automation Error
- How can I use the Spin or Toggle buttons to change cell values
- disable Warning Message
- error
- Allowing only one or two viewings of a worksheet?
- Activating last chart added.
- Adding text
- Using values from one macro in another!
- basic question about loops
- Re: MsgBox
- RE: MsgBox
- Relative Values in a Macro
- Formatting number as accounting
- Date Calculations
- Conditional Copy
- Import images
- using a barcode scanner to validate numbers
- Please use the latest Version
- Export Userforms to Access
- parsing text file, and generating distinct cell values
- Re: selecting multiple sheets by use of an array?
- Wee programming query
- how to rename the sheet in programming
- convert numeric to alphabet
- on _SelectionChange Copy Range to Second Worksheet
- Cell Translation Code
- getting textbox value
- Insert a ghost entry to a collection
- VBA- SeriesCollection
- Sort, Subtotal, Label Subtotal, Insert row
- Visual Basic System Error
- Workbook is viewable in VBE after I close it
- How to avoid several print areas being squeezed into one page
- Updating Sheets on a non continuous cells
- copy & paste command button
- Newbie in deep..... Excel and VB
- Protect formula
- Runtime Error "1004" Select Method of Range Class Failed
- How to run a macro automatically when i open my excel spreadsheet
- Assignning a value to a range
- How to Check a checkbox on spreadsheet from VB code
- Plain descriptions required
- Drive Letter of current file
- Re: MsgBox
- Match / Name-assigning To A Range
- Quick Date Entry European
- Logging things..
- how to get custom papersize from excel?
- Go to last row of data and delete the rest to bottom of s/sheet
- Printing query with Sendkeys
- Reference to DLL corrupts on recompile of dll
- UDF recalc problem between sheets
- Increment number in cell before printing
- How to keep the Checkboxes selected by the user unchanged even after closing the userform
- MS Query
- h2 (30), c1(33)--split- c1(30) -d1(3)
- Adding new worksheet from template in code
- XValues and values.
- Returning last button pushed in Excel 7
- Help needed to test and modify interworkbook links
- validating against a list - Please Help!
- BLANK as a Formula result.
- Autofilter
- Public variables and Class
- Easy one
- TextBox formatting (Revisited)
- Lookup on worksheet return whole row
- Do While only does once
- Pop Ups
- Going to differant Cells after Entering
- Is this possible?
- array formulas and index lookup
- Pop-up Combo Box
- Go to Differant Cells After entering
- Embed Pictures in Workbook
- AppActivate runtime error 5 when used with shell cmd
- Auto Filter. More
- InputBox Function
- query table with patent publications
- VBA Newbie - Simple Macro
- Ignore - just a test
- Row Delete
- Hyperlink to Hidden sheet
- ODBC driver does not support the requested properties
- IF Statement
- VBA code gets lost from workbook if I paste in new data and save???
- Index match lookup formula
- Problem in setting Excel formula through VB
- message box question
- HELP. Can this be done easily? Save me HOURS of work.
- calling subs
- unique numbers
- Cut list macro suggestions
- Runtime error 430
- Rounding questions: (Formula and Code) ?
- Sporadic problem with Enabling Macros
- Inserting rows based on another cells value
- Using a Macro to find a value in a range and activate it
- Change SourceData in Excel PivotTable via VBA
- Excel 2000 vs Excel 2002 Macro
- Extracting useful info from test data
- Autosave excel file
- Paste a large text into a cell
- Limit on number of Sheets in a Workbook?
- Problem with IF Statements Within VBA Code
- Hot Key Confusion - NOT programming related, sorry
- Office Chart doubt
- Name Delete Problem Again
- Isblank check in VB
- Formula to calculate affiliate commission
- Delete Row
- Add-In Problem Disables Excel
- Excel vb Email
- your opinions and help on my best sub thus far
- Re: Macro to advance current row by 1
- selecting contents of a text box in vba
- Re: Macro to advance current row by 1
- How To Copy & PasteSpecial: Range from Mult Wksht into SummarySheet
- convert excel doc with macros as web document
- Would like to Obtain a Cell Address from a vlookup function
- query metastock data
- If B4 =? enter 1 in A4
- Insert Grand total at the end
- copy a hidden sheet
- Fill a Range with VB SafeArray
- Tagging a Cell
- Send Instant Messages from Excel
- Eliminating save message
- Copy Cells if A=1
- internet data transfer library
- Thank You
- select sheet
- Protect Macro from Edit
- command button in pivot table
- saving file
- VBA code to transfer a Range to a Word doc
- Copy pages from one worksheet to another
- Naming Worksheets With Leading Zeros
- Re: Solver in VBA
- output text
- VBA- SeriesCollection(1).Value error
- How to convert Text to Number Function
- Remove rows with dates
- Ideal Code deleting rows/based on bold text
- Tom please respond..it works but but not completely
- Question about Formulas
- Adding file name and path to to footer of all workbooks in a folder.
- send keys
- Special Formula
- Row split not working
- setting the auto row height using vba
- range problem
- complex looping problem
- Changing Pivot Table Range
- Is there any onLoad kind of function for Excel
- Getting Table data from HTML page
- Restrictions on Excel in-place activated in Browser?
- Macro stops before beginning.
- Controlling Input
- "Rounding" error
- Workbook_Open problem
- Solver reference problem
- VLOOKUP
- don't let the user disable macro's in Excel
- How do I do Auto_Activate Macro?
- Multiple IF 's
- macro
- Wow can I switch to R1C1 mode?
- days, GUARANTEED- RETRACTION..PLEASE READ
- Change Criteria in Code
- Validating entered data as date
- Email Excel form
- run until mouse moves?
- Out of Memory Error on Excel XP
- Displaying XValues.
- Strings
- Converting time from hrs + muntes to whole minutes
- Late Binding question - newbie
- expire workbook
- How to copy data from excel to power point screen by screen?
- Please help (need a code check)
- Pulling value from cell to complete path name
- Save As help
- macro warning box
- Move to SELECTED Cells
- Get user selected range into RefEdit
- Excel VBA - Remove Shapes and Cell Contents
- Excel VBA - Clearing Shapes and Cell Contents
- hiding formulas and defined names in a worksheet
- Mailmerge in Excel?
- Auto Run and Installation privileges
- Options when Protecting Worksheet
- Returning Error from Functions
- Delete records by comparision
- referencing another sheet
- Baffling, yet curious
- Disable/Turn off
- Word document from template
- Convert string to range?
- Find in a range
- PictureBox control in VBA Excel form?
- WORKING DATES.
- Need help
- Scoll button in VBE editor; How make work?
- Re: Copy Value, but not Formula
- RE: Comparing worksheets (extra info)
- Program an autofill
- Finding Procedure which generated error
- This drives me nuts
- Retrieving data with SQL and ODBC selected by key values in cells
- How do you say "If, Or, Then, Else" in VBA
- Why doesn't this range work?
- Export the worksheet background image as an image file - possible?
- Absolute changes w/copy
- Excel Data Validation - copy command overwrites
- pivot field size (column field)
- Fancy tricks in Listbox?
- Findcontrol
- ADO or DAO, or odbc query from xls sheet, to xl sheet?
- Disappearing Text in textbox
- Row Select
- Change references ALL at once
- Calculate time worked
- Subscript out of range
- showing current date as part of file name
- Re: Need (perhaps non-existent) Formula Help
- Formating Data Labels
- restricting data when other cell is empty.
- vba code to find ssn and move two columns
- Object required.
- Object required - run time error 424.
- Function
- conditional formatting
- Digitally Sign Macros
- Testing for Identical Cells
- VB msgbox exit
- ComboBox changes text when switching tabs
- Can't recreate A Macro
- saving single worksheet
- Quick Date entry revisited
- Excel VBA - deleting populated folder problem
- Shortcut Keys
- Returning control to form
- Save Excel chart to file with given dimensions
- User defined data type
- Workbook Name question
- using spaces instead of underscores
- running a batch file
- Excel and web browser
- Digitally Signed Excel Sheet - can someone send me one?
- Running a .bat file via AppActivate
- Protecting all sheets in a workbook
- excel VBA password
- Resizing a cell vertically to insert text
- Deleting all HTML coding while keeping text
- Why does this fail with an invalid type error
- excel VBA - for loop for several sheets
- Getting External Data
- Where Macros Are Located
- Print Row
- Sometimes macro does not run
- Re: Print Row
- Two questions
- Error with code... ".Visible"
- transpose to matrix
- Change minimumscale with the change event of a combobox
- Excel VBA - Multiple Issues for a newbie.
- UserForms
- VBA digital sign
- one-tenth of a second delay
- valuta
- VBA Excel problem - including sheets in Add-in worksheet to link to
- worksheet synchronisation and other one
- Comparing values in two columns
- sumif or countif based on font color
- Save As issue
- Is a file already open
- Use of Command Buttons to Move Through Worksheets
- Open a log file
- Excel VBA - Excel crashes when macro button re-assigned problem
- How to enable macro
- Reading Textfile into a variable
- Find generates error message
- protecting the workbook through a macro
- excel graph with vba
- IF function with Array Formula
- XML Data Binding
- ATPVBAEN XLA [Number casual]
- Clearing Data ranges from Multiple Worksheets
- Deleting a sheet
- Processing all worksheets simultaneously
- Edited Data Imported into Excel
- Re: Edited Data Imported into Excel
- with selection speed
- Updating from external file & keeping previous data static
- ASAP Utilities - free!!
- Excel: workbooks.open problem
- Help with formulas (Sum)
- Server
- Aborting from a "Before Print" Event
- automation
- Excel Probel
- Save TextBox Entry after WorkBook is closed
- Indian Coma Style
- Disable Button
- find across multiple sheets
- Indian comma style above 99 crores with -ve
- Not sure of what to call it accept (Un - concatenating)
- Opens Workbook and not Query
- Transferring custom function
- Loop Problem
- excel vba : how to split characters in text file into cells?
- linking multiple workbooks (VBA)
- Execution Error due to file location
- Array Type programming
- Re: FINDing data only in one column
- Re: FINDing data only in one column
- VBA question involving an InputBox
- Re: FINDing data only in one column
- VBA question involving an InputBox
- ValueBox? or force TextBox to read/format value
- value vs. formula
- Chart Size
- Get Average in Subtotals
- Pointer Color
- linking multiple workbooks - UPDATED
- List/Combo Box Setup Problems
- Sending Appointments via Outlook
- Set the size of a chart object
- Using VBA write a mail to some one and Send it
- Public Variable
- Pass array from Project to Excel
- Maximum Count
- Excel VBA question - showing userform when opening workbook
- Re: Britney Spears and justin timberlake 8767 (Attention - do not open)
- Summation of last (DD) days
- fastest hardware for excel
- PivotCache.CommandText - string length limitation in Excel 2000???
- Lock out a portion of spreadsheet based on a condition
- Error when running macro in Excel
- Enabling help on code
- Worksheet_Change Event
- Counting in ranged intervals
- Programatically set ref to my DLL
- Intersection of records in two spreadsheets
- Import Queries instead of Tables (ADO)
- Menu
- Changing Text into Numbers, using VBA
- Import Queries instead of Tables (ADO)
- MsgBox help
- XMLHTTP proxy settings.
- protected cells
- Saving Changes
- RefreshData Method in RTD Server
- Declaring As Variant, Changing to Double?
- Exporting to Notepad
- Error Trap Not Working
- input box , msgbox, formula
- 12th root of two
- Create and write a simple text file in Excel/VBA
- Same Results - which is better?
- PASTE INTO JUST VISIBLES CELLS
- opening and closing files in order with vba
- Open file from vba
- How to do a line break in a text formula
- ComboBoxes and Tabbing
- Multiply All values by a cell
- Retrieving data with SQL from ODBC source
- Excel VBA - Changing a template in an Add-in
- graph\spreadsheet on form
- Simple ?
- Class Modules
- Change a chart's series using VBA...
- Excel Error Message when loading
- dll's and performance
- concatenating strings to call a variable
- searching a list box for a filename match...and highlighting the match
- Moving XL Data over By one Column (*Same Row)
- EXCEL VB Macro Run Time Error 1004 - Setting ColorIndex
- Activate Userform (run macro?) from cell value
- Strings that have quotes in them
- Date Selection Userform
- Unsharing a workbook
- online course?
- UDF: how to get value of the argument's adjacent cell?
- help required with placing command buttons in Excel
- Worksheet Menu Bar
- Updating a Data List
- VBA question - Inputing data to txtbox in userform using short date formart
- Excel Encoding
- Sheet msgbox
- On Error GoTo : How to use multiple?
- Back button Macro?
- AutoShape - Text Update
- Excel VBA - "IF Answer = Problem"
- Reference Addin Module from sheet code
- VBA problem, works fine as formula but not in VBA
- Help with Selection Property
- FileCopy and read-only
- MsgBox
- Protection and filters?
- Excel 2003 v Excel 2000 info please...
- shortcut macro keys
- assign a clickable macro to a cell?
- Application.Run with multiple workbooks
- Getting a row number of the last row?
- delete empty rows
- Problem with excel linking to Access query
- Cell
- Combo Box font color
- Problem in VB help in Excel
- Here is an interesting question
- Trouble recreating Pivot table changes in VBA
- compile error
- opening an excel file from another excel file
- Removing the last empty line (Return) in a text file (CSV format)
- Get points in a worksheet using mouse click
- MS Excel Audit Trail Software
- Re: Range("rng").calculate causing problems?
- Help with randomn blank cell in my data
- Workbook file password protection - forgotten
- SocketWrench
- Code is great, except for one thing ...
- Open workbook with designated sheet
- Call Function in Different Spreadsheet
- Validation lists
- textboxes
- Application visibility
- Global variable declaration!
- Saving it as read only?
- Trim Blanks
- Open file from Cell
- Workbook reference error
- using create object and sendkeys from excel to FTP
- Printing Each Sheet
- Looking for matches
- unable to get original cell value from a "number stored as text"
- Date ??
- Re: Range("rng").calculate causing problems?
- Put Excel data to text file????
- Rename the sheet just added
- App using OWC 2003 Deployment - How to ?
- VBA Execel Macro & Check Box help
- Preventing shortcut keys from working on disabled toolbars
- ComboBox Population of Cell Range
- Delete a sheet
- Sizing a Picture (a .gif) to fill a worksheet, for any resolution
- Query Data from a Sheet
- Query Data from a Sheet
- Dialog For Choosing A File as a string
- Error trap the renaming of a sheet to an existing one
- Excel Macro Help.....
- Rnd (Random) in VBA
- Text box in userform
- formula validation
- Newbie question about publishing VBA project to the web
- need help with a timer
- Updating price of securities in Excel
- Searching for a unique charater in a string, vb
- Public variable usage!
- Button won't call macro
- UDF showing full Path of Worksheet or Worksheet Name?
- Disable entire row delete on certain sheet
- Trying to get/set contents of embedded file using Excel OleObject
- Returning to activecell
- Display mail application either in Outlook, or Outlook express
- Averageing a collection
- A unique ID for protection?
- Changing the last line of a CSV text file
- Add-in functions when starting Excel programmatically
- getting a macro to run when a change is made to a specific row
- Script or Tool to Update Excel Links
- Loop a long formula through range
- Copy Paired Info to Different number of Rows
- Bug on macros!
- Strip chr(13) from Comments
- Code
- From Sheet 1 to Sheet 2!!!!!!!
- Cell protection
- simple VBA question
- Excel Timer with Sheet Toggle Help
- Bad External Link
- Re: Working with ADO to connect to SQL database
- Code to insert text
- Looking for function similar to Access "Group By" queries
- Choose Function Macro
- online course
- DLLs
- Textbox in userform
- Why won't this code connect to ODBC
- Find values in table and return correpsonding data in array
- Saving workbook
- How to soft a selected range of data in Excel by using VB.Net
- Chart sizing inconsistant
- how to have a module to repeat itself at a certain time interval?
- Looping in Excel XP with C# -- Ranges and SpecialCells
- Problem with using formula
- Restoring application settings at end of sub
- Documentation 4 Excel Web Component
- Help needed for ComboBox
- Add a sheet using a template
- Excel Saving and No changes made!!
- pivot table
- Filter 2 columns onto Sheet 2!!
- Place selected object names into array
- disable formatting
- IfThen
- run a macro in excel from an access vba
- What is maximum length of URL?
- fill A1 when open xsl file
- HTML Tags in Excel sheet
- UserForm Label & Format Problems
- Delete Duplicate rows in a range
- userform
- Search using Autofilter
- Use the .NET Library in VBA?
- Quick Question
- Path/File Access Error
- LinkedCell Update does not always respond
- Counting Code
- Macro to copy and past selected rows only...
- Centering Toolbars
- Re: Add a separator on a custom toolbar
- pivot table question
- Screen Updating
- Basic macro ? I'm new to this.
- Object required when formatting
- Using reviewing tools in macros
- userform question
- Thanks Bob!
- Need Code to Populate Cell Range
- find the last row number
- ToolBars and Custom Menus
- Data Tansfer Between Worksheets
- Arrays
- Summary of Multiple Date Ranges
- Sum IF function - linked to external worksheets
- Totals
- OLDEDB alternatives for pulling data from Excel
- Re: Pop Up Screen
- Grey out
- Row and column header
- How to get average with deviation
- Make a particular cell the active one
- Re: Pop Up Screen
- Limits on Case Statements
- Re: Replacing formulas in Excel
- selecting the last non blank row.
- Case Statements
- Counting files in a folder
- Excel VBD DDEInitiate problem
- Copy row
- Re: Please help...I need a looping macro at a specific time
- Password Boxes from xl95 to xl2000
- Struggling to make code work!
- Newbie Excel User Needs Help!
- Controling the list in a combo box
- How to detirmine the target row
- 3 range criteria for Loop
- Copy Paired Info into Diff # of rows
- Copy address from one sheet to other sheets
- inputbox msgbox error
- Excel Parameters
- Prompting a macro to run on change of cell content
- MsgBox execution sends program into design mode
- Rename File from list
- Searching In a Column
- UDF to give position of item If list was Alpabetic
- Inserting Sheets and Naming
- Re: Getting the Sheets Name
- Create a Macro with Starting Cell as a Variable
- Help (please, please) copying and pasting issue
- pivot table drop list
- Re: Replacing formulas in Excel
- association of hot key with subroutine
- Function to cnvrt Phone to State w/out cell ref
- cannot copy formulas
- Probably missing something simple in loop macro...Please help
- CommandButton
- Opening Excel remotely
- Combobox setting
- Excel through SOAP to a webserver
- Sync Code
- VBA question - calling Procedure from userform
- Summation
- leading or trailing quotes
- Disable Macro Option
- Pivot Tables and list boxes
- Protect My workbook, what's my computer's Finger Print name??? and how to access it, from vba!
- Drop bown lists
- VSTO Excel Addin
- VBA question - Copying Sheet from Workbook to another
- Please HELP !!! Converting .XLA to .XLS
- Cant find project or library
- Call/Start Macro
- Invisible Contents
- Making the minimized Excel window icon flash
- refer to a formula for use in a loop
- RE: CommandButton
- synchronize 2 combo boxes in Excel
- RE: ComboBoxes
- Excel: Relative formula to new sheet?
- Re: want several userforms to remain on screen
- sum cells
- Command button macro query
- Saving a file with todays date on the end
- VBA question - getting name of workbook
- listbox works in form; not imbedded???
- Easy one: absolute cell reference in VBA
- hide sheet tab
- Custom Addin, Excel Shutdown Problem
- Trying to give a cell a formula
- Converting code to R1C1 format
- Rounding numbers to whole thousands
- Reminder
- delete columns with 0 in single row
- Cell shading won't show on screen
- Show progress in a user form while code runs
- excel vba - COUNTIF syntax
- How not to fixed cell address in Macros
- open two files with the same name concurrently
- What to use other than .Select
- Pivot table toolbar
- How to put in a warning?
- creating a e-mail macro
- How to change row color when select a cell in this row?
- Lots of Frustration - Lots of Arrays, Dynamic Ranges Don't Work, Help With Options
- Auto Expend Range Using Macro
- when change value of cell
- cannot copy formulas only
- Re: Sendkeys VBA and command line
- Re: Help required with Macros
- Re: VLookup
- How to Clickbuttons on internet Explorer pages with Excel VBA
- Re: goto a particular cell
- goto a particular cell
- Count result output to other sheet
- Copy ranges
- Clearing Memory agter an update
- Xml
- changing range reference
- Urgent
- Findjjing the range that triggered worksheet calculate
- Saving a Workbook
- copy formula to the last used row
- Newbee help
- Automating the "Oval" Object
- Checkbox behaving strangely
- Can't get code to work properly. Please Help!
- Copy Modified Worksheet 1 Data to Worksheet 2
- Is it possible to password protect an OLE object on a sheet?
- RE: Sync - Bob Phillips
- WordWrap in textbox
- Counting Controls in a sheet
- Connect to Oracle Database through ODBC with VBA
- Lock access to a worksheet depending on user name