- How do I create a For loop within a For loop?
- BackColor, Forecolor, Bold, and Font Size for ComboBox in Commandbar
- summing ranges
- Problem with hundredth of seconds
- Calculation problem
- Creating table from cell contents
- Re: Opening Excel from an ASP file (VB works, ASP gets ASP 0178 error)
- custom function - with built-in function
- Workbooks.open method fails
- Named Range Fails in VBA Code
- RunTime Error (Automation Error)
- Help with emails from Excel-add via Outlook 2003 (mistery apostrophs)
- Filtering ODBC data
- move all files in a directory into another
- Help to convert one row of a sheet excel in one page HTML
- macro to save and increase invoice number
- How to Open file as read only
- Deleting zero values
- Deleting worksheets
- Chinese
- deleting an AllowEditRange
- Opening all files located in a specific directory
- Delete selected rows data
- disable events while macro is running
- Macro crashes if I run it twice
- Vertical scroll bar in a MultiPage
- "IN" comparison operator
- Pasting text from Excel to Word (macro)
- Calling Excel 4 Macros From VBA
- Importing CSV files in Excel
- Declaring array constants at module level
- textbox automation error
- Macro Error
- How to generate a file copy of the Excel Find results list
- Is the formula an array formula?
- Worksheet protection problem
- Set module-wide objects?
- Workbook Sharing
- Message Pop Up Box
- Re: Looping through and linking
- VB code to total up a column as the value change on a nother
- Excel Function Addins
- VB code to total up a column as the value change on another
- Using Application.match against one dimension of a multidimensional array?
- Calculate Median with a macro
- currency formats
- Trouble Programming from DotNet Against Multiple Excel Versions
- How do I convert a nominal monthly compounded rate to a quarterly.
- Open file
- Excel cmd button
- Help with VBA Input Validation
- Using "InstrRev"
- check boxes
- Strange behavior with text box values . . . help!
- Find WorksheetFunction - finding text within text
- Pivot Charts, auto formating and macros
- select and nonselect ??
- Count occurences
- Looking for a way to control...
- How to make 0.5 same as .5
- building a list in a col...based on another col
- Hiding a sheet
- How can I get Excel to flag the need for recurring updated data?
- How can I get Excel to flag the need for recurring updated data?
- OpenText looses leading zeros for zip
- Further Clarification with Event Handlers & Class Modules
- Building object reference
- checking for a connection to the web
- Suppress double click behaviour when a picture on a worksheet is active/selected
- Strange problem with ActiveX component and Excel 2003
- alerts
- MsgBox keeps popping up
- Use button on sheet to transfer data based on todays date
- Put in clipboard, but keep the current content
- vlookup problems
- Groping by column
- Getting an exact match
- passing a value to another function
- Calendar in worksheet
- A MACRO TO BUILD BORDERS
- How do I use an If Or function
- Right click detection
- Testing for named cells (i.e., ranges)
- running macros/vba code in a shared environment
- Query to DB2
- 'For - Next' question
- Using Workbook_SheetChange for single column
- data validation to restrict input in cell based on value of cell above that cell
- Access to Excel combining criteria
- Microsoft excel weblogs
- TAB Key doesnt work.
- Fill values into a listbox matching selected values from a combobox
- onClick in Excel
- problem with Worksheet_SelectionChange
- shorten value in a cell
- Problem with create an add-in
- Searching for Archives
- clearcontents, worksheet_change, cell validation
- Align text for labels in user forms
- drag and drop and Worksheet_Change
- NetDDE in Excel 2003
- How to check Excel file already Open
- Conditional Formatting Counting Colours
- External Data from Sharepoint
- Find Findnext in selected range
- Detect NULL (??) range?
- Query with cell reference.
- How do I import data from Calendar into Excel
- is there a way I can have excel shade a cell a color based on tha.
- Simplify CrossJoin function
- Error problem
- Excel Link Question ?
- Copying an entire row or Rows based on column criteria
- Enable/Disable Menu Items
- how to remove the message-pls sugg
- separate modules for each sub routine?
- Pivot Table Programming
- Spreadsheet screen flickers for a few second when using a condition
- Missing cells
- workbook saveas function, xlText file format
- Using Range object as created
- Sub in "thread"
- Enter a formula in column A, if a condition in column "B" is met
- Help With Total of Values Please
- formula to get the file save date in a cell?
- Automating Word - Print one page not entire document!
- General Question
- What Excel 4.0 macro command do I need to use to delete a range na
- Changing Macro Name?
- Macro Name problem when I change workbook name?
- How to randomly distribute rows from sheet 1 to sheet 2 & 3 with V
- master sheet??
- protecting a sheet in a different workbook
- VBA and Trim
- Generic Sheet Names
- Design/Logic Comments
- Worksheet Controls in design mode
- Stop Error Message
- excel
- ODBC Connection
- Copy from website to Excel
- Adding Cell Commnets together
- List worksheets
- problem returning a recordset from a function
- Updating Worksheet Names for Rolling-12 Report
- Excel VB Buttons Disappear
- Best Way to Distribute and Upgrade a Spreadsheet
- Creating a local and hidden name; Parameters
- Print Area & Page Set Up
- Copy & Paste formulas
- Adding certain cells
- EXCEL Macro Available?
- Posting again. Please Help! How to "track changes" using VBA
- Worksheet Change Event
- With Statement
- Another change event question
- Select every "odd" column
- Erase Data on Sheet
- Looping Thru Objects in UserForms
- Copy data from one workbook to another of same name
- suppressing a footer on the first page of a printout
- Identifying excel
- number as string and adding spaces to it
- suppressing a footer only on the first page of a printout
- Multipage Controls - Experts Only
- how do I calculate a mean
- Saving a File
- password protect project with VBA code
- how to remove the message-pls sugg
- thumb size in scrollbar control
- Sorting
- URGENT: Creating a drop-down menu to perform v-lookup function
- Excel Database Query String Too Long
- Beginner's help
- Ogives on excel?
- copy values based on date
- error message with Pivot Cache
- Excel in MSIE
- Copy Destination:= Code Stops Here
- insert scanned worksheets,then apply formulas, similiar to backgr.
- Scary
- how do I use SQL within vba for excel?
- how do I use SQL within vba for excel?
- show VBA source line numbers
- Deleting blank rows
- IsError Function
- working with strings
- If, ElseIf
- Copy a form from excel into a new word document
- Webquery datafield naming changed between excel versions 97 and 20
- Compiling A Workbook
- Protecting spreadsheets for coping
- excel might let me have more than 1 color police icone
- i need icone foe special paste-value
- Help with Run-time error: "Type Mismatch"
- Re - GGVT Excel Copy of a WorkSheet Takes Mighty Long Time
- File open on Erro question
- Unable to set the XValues property of the Series class
- go from input cell to input cell
- Worksheets("Brackets").DropDowns("Game10").Click
- Inop Macro
- Soup to nuts listbox help needed
- Comparing data columns
- 3D charts and contours
- When workbook is reopened, macros are disabled
- Deleting rows after copying data
- Replace Code Programmatically
- Capture Screen to *.gif file via VBA Macro
- Prevent Error Message
- Help finding error setting range to Visible Cells
- Looking for help with macros and chart making.
- Excel workbook will not close due to VB Reference link
- Using macro to save as todays date
- Help with Address property in nested loops
- Automating Excel
- Login and password automatically entered in a web query
- Change Workbook Event
- Routine for checking if file exists
- Consolidating Code
- Attaching One Worksheet to Email
- comments shown halfsized
- Can Excel read from a USB port?
- Syntax for Accepting Worksheet Formulas in VB
- Need Sample VBA Code
- HOW TO PLAY SOUND.WAV FILES SIMULTANEOUSLY UNDER EXCEL
- Button to move row and delete old row
- Macro to delete un used styles in a workbook!
- Understanding declarations
- How do I use a variable name for a workbook in vba
- Spinner
- Unable to Record
- maximum variables within sub
- How do I modify rounding rules in Excel?
- Listbox textalign
- Programaticaly update webquery - help
- Invoking Local Cube Wizard
- Setting size of icons
- closing opened workbook/app in memory
- Combo Box ListFillRange Property - Non Adjacent Cells
- row background colour in html
- combing cells
- error when using variable name for workbook
- R1C1 versus A1 in VB code
- Replicate data using fill down.
- Cell Calculation taking to long
- Lost VBA extensibility library reference
- Is it possible to prevent opening of workbooks in the current instance of Excel?
- Need to use answer from combobox selection as listfillrange for s.
- Reading a Range to an Array
- Programaticaly update webquery - help
- Generic Sheet Names
- Excel 2003 won't run simple code that Excel XP and Excel 2000 will run
- Informational userforms
- Dim vs. Public
- Count Autofiltered Rows?
- Present Value of Remaining Cash Flows
- How do you update a public constant
- Purchase Order with Drop downs that will Auto fill typical informa
- ActiveSheet.Paste crashes
- Password Question
- Calculation Mode
- Setting Password & WriteResPassword
- Application.OnKey
- Please Help
- Display a message whil eprocessing
- badly struck! how to pass values from asp to excel
- Is there a "generic" Error Handling method
- Find cells without multiple spacebars and format...
- Get the row number that matches my value
- Data Entry Dialog Box
- Data Entry Dialog Box
- Data Entry Dialog Box
- Combo box hyperlink navigation
- Finding most common word in a list
- Problem with printing from VB-script in Excel
- Problems with Dr. Watson
- CommandBar ActiveX
- hide macro
- Using custom template with Excel.Workbook.SaveAs
- Unload all addins in VBA
- Macro for Save As
- Opening a directory using code
- How to get a variable range
- Cycle through controls with similar names
- Macro does not refresh on the "Calculate" command.
- Tell if workbook is opened in IE
- Repost - Extracting a table from a cell
- Combo Box lookup
- count how often a name exists
- custom right click menu
- Customizing right click menu
- Combining multiple sheets onto one
- Program to add a row?
- Compiling vba code as stand alone exe
- Macro help anyone.....
- Function tool or programming...Help please!
- Define array of sheets by inputbox
- Reorder items in listbox
- How to convert a number "eg: 19521016" to date format
- Range.Resize from Visual Basic in Windows to Excel
- Command Button Caption
- Open form on Enter
- What is the best way to Track Employee Absences on a spreadsheet?
- Simple Clear Contents
- Where For Art Thou DIM?
- Sheet Name
- Fixed decimal point.
- Best way of copying text to Word from Excel
- Format command
- Macro trying to open second Personal?
- Filling a cell based on the content of another cell
- Button to move rows to other tab
- Validate data
- PDF issue when converting from Excel
- Lookup Value
- Quick userform question.
- Can I perform tasks on a closed Workbook
- Open a form on Enter
- Macro save as Expansion
- run a macro from asp??
- Extra reference after opening a file
- How can I pass an array as TextToDisplay to a hyperlink?
- filesystemobject
- Delete Sheet
- Total up a column as the value change on another
- No negatives
- Contents of a TextBox to HTML
- INSERT into named range using ADO
- Not getting the object structure of VBA Excel
- Accept Overwrite Automatically
- Delete all Characters "except"
- Macro for formatting columns with dates, weekdays, and widths?
- Export CSV File, set Windows Read-Only attribute
- Images
- Copy/Paste Merged Cells via Macro is not working
- alerts
- Add a Row
- Macros that only run once
- How to Determine PrintJob is Finished with VBA
- vb scripting -- copying web page, paste as text
- advice needed
- modify formula
- case select and a range
- Use Toolbar Button to Toggle Addin
- Move sheet to another document with variable name
- Merge multiple files into 1
- How check if form is loaded?
- Excel 2003: instances not closing
- help with hours minutes and seconds
- DIR Function Question
- Vlookup with 8 sheets-please help!
- (Un)usual "cannot set Xvalues" error message
- cell comments
- Split Sheet
- Loading a Reference
- VBA with Adobe
- displayfullscreen = false not working
- Macro to Manage Blocked Senders
- PC to MAC VBA function problem
- Does Excel 2003 knock out add ins?
- IP address format
- Setting a Date variable
- Sum Formula
- ThisWorkbook.Path not updating
- Stop prompt for password when Excel closes
- (",) Hello, I Have Good News!
- Error getting Row number
- hyperlink navigation using combo box or list
- Running macro when cell contains text
- Can't clear saved data in Pivottables
- Excel should allow formulas embedded in text.
- Converting dates to years, months & days
- Controls Toolbox control vs Form Toolbox control
- Huge sheet into smaller sheets
- control mozilla firefox
- Programming
- vbModeless user form crashes Excel
- Cell contents is a macro
- Worksheet audit
- Lock Screen to current view
- worksheet functions language
- Using a VBA listbox to populate a worksheet
- Remember SelectionChange range in the Change sheet event?
- MsgBox Font Size change
- how do i change the expense statement template macro
- Help???
- PasteSpecial
- security of code
- String Arrays
- hyperlinks
- DropDownBoxes Which update base on other dropdown values
- Playing around with Syntax
- adding hyperlinks
- Using loop for selection macro
- Select a sheet and activate a Window
- go from input cell to input cell
- F8 and Yellow pattern for compile error
- How do I delete a workbook after the vba has run?
- Multiselect list box
- XL Free Floating
- VBE file open coding
- Only works on One Worksheet, When Looping thru All WS
- How to disable the "Insert Copied Cells" context menu item
- Auto Open Excel
- How to stop sheet deletion
- Vlookup
- Comma to period
- how to change de data base of a dinamic table
- AcitveSheet.Paste crashes in XL 2003
- Pass a Variable List Of Values To Subroutine or Function
- Recognize Names of other Workbooks
- Drag&Drop over an UserForm
- Print Chart Worksheet
- (",) Good News for Google Groups, Usenet and Other Users
- Modify "pick from list" to read named range
- Detecting Security Level
- When I email an Excel spreadsheet to a co-worker it is distorted,.
- Memory Usage
- Excel Selection in VBA
- Macros to Open & Update Files
- Close a foreign application - ADOBE
- How come the XLA worksheet becomes visible?
- Copy and Paste Macro - Simplifying
- Using Vlookup to pull data from another workbook
- Auotomating Hyperlink?
- option buttons' values = false
- Proper Syntax for Date Modified?
- How you decimate data using EXCEl (i.e., remove every second or t.
- Add msocontrolbutton to commandbar problem
- Closing form turns off commandbar control procedures??
- SaveAs text file from VBA Getting Error
- Question on "Programming a MenuBar"
- re: vlookup in VBA
- Excel cell formatting
- xl instance
- Get Last Day of Month
- tab color
- Running a macro Upon Closing
- Pivot Table Events
- Filling in a Date Series using the Fill | Series menu command
- How to insert Calendar for Userform
- Prevent "Opening..." alert when opening from VBA
- Implementing late binding for VBA
- Import files on a mac
- can't open excel - user.exe error
- (",) Good News for Google Groups, Usenet and Other Users
- Changing direction of cursor after hitting enter - toggling with toolbar macro??
- Editing Number Input on a User Form
- VB coding to go to last cell at end of any given row?
- Where can I find some good Excel spreadsheet for managing my bank account
- How to use workbook_open()?
- Using the Application.ScreenUpdating = False?
- Using the Application.ScreenUpdating = False?
- Template Update
- Scrolling through Auto List members list
- Testing to see if windows application iis running
- Cleaning up the syntax
- Referring to the base workbook in which the module is situated
- Execute a program from within VBA
- how do i display a value in a user form as a result of a selectio.
- Lock and Unlock Cells
- ShowAllData in all workbooks and sheets
- Minimize a form
- Save to directory and create if not exist
- Help w/ VBA code
- ActiveSheet is blank
- deleting 2 rows
- getting a list of users with permissions to a workbook
- Event handling...
- text box with standard text
- Automated spreadsheet Consolidation
- Consolidate multiple spreadsheets
- OLE Combobox: Excel breaks down when it has focus
- UserForm usage
- passing range to c#
- how do you send a email from an specific excel column (database)..
- Bad performance
- Row Color
- OLE Combobox MatchRequired property not working
- Easy VBA question: range control
- Tricky... Macro Security!
- Trying to set default Worksheet file name from C++/MFC
- Sort IP address.
- Removing Duplicates and Pasting
- how to find and copy values on sheet 2, based on a list on sheet 1
- VB question- please help!
- Speeding up writes to cells?
- Change default path to personal macros
- Immediate window - Compile error
- Change negative sign from end of number to the beginning of the number.
- ADO method for getting highest ID #
- Overflow error
- possible until 5461
- Merging Cells.. Lots of the little buggers
- Permuting compound words - With or Without SPACES
- about xll
- Extra Quote Mark
- How do I use a password to protect an Excel file from peeping eyes?
- VBA NumberFormat
- Count between Hi and Low
- disable F1 after F2
- Form Date picker
- VBA 2003 cut/copy | paste values only
- Copy pasting a range in to a single column
- Corrupted Macro
- Creating a "To Do" List
- Saving a column of data in another file format
- Menu Item Deleted
- Search by rows and then go to selected row...in a frame?
- Installing a Custom Add-In
- Workbook_BeforeClose
- Must be more than 1
- VBA Code to Print a Variable as part of CenterHeader Problem
- Loop Through All Open Workbooks
- Input form question
- Toolbar Icon Size
- second file/Workbook open
- Determine if it's a leap year
- How do I have an image in a cell based upon a referenced value?
- msoControlButton tpye problem !
- VBA 2003 Save|Change|Restore builtin menu OnAction
- Is worksheet open
- define a database path
- Macro?
- Does folder exist problem
- Programming the Progress Bar problem
- Automatically run a macro when a cell = FALSE
- Combination of 2 combo boxes to populate 3rd
- string output needed
- Macro compatibility problems between PC and Mac (Excel 97 and Exce
- Protect VBA codes
- Macro for Emailing a spreadsheet
- Qualifying OptionButton with ro without MSForms
- is it a microsoft prob..can it be resolved or not?
- change worksheets through code
- SQL Connect
- VBE toolbar not ready for cutomizations
- "Formula is too complex to be assigned to object" ?
- Bulk processing
- mutiple same lookup values
- delete values in cells
- sumproduct or other way in vba, help and thanks
- Programmatic indication of file to be PROCESSED.
- Error Handling with a Match Function.
- Filesystem again
- Conditional Hyperlink?
- Sum of Variable Cells in a Column
- Selection in data range
- Is Validation?
- autosave before close
- Cells(r, c) syntax and horizontal alignment
- Renaming Forms
- Running code on hidden sheets
- manipulating a textbox in charting area
- Select Visible sheets
- Auto_Open question
- Open Save & Close All Files in Dir
- VB question
- Returning Cell to Upper-Left-Most Corner
- Splitting string into letters and numbers
- Adding files to an array using Dir
- Problem with the round function
- Array or Pivot Tables???
- Passing String to Formula1 Method in VB
- Multi Selection List?
- Formats: Too many different cell formats error message
- How do I invoke a VB subroutine that exists in an Add-In?
- Set row heights to values in cells
- loop calculations in excel?
- IQY
- Running code on hidden sheets (revisited)
- Selecting range based on values
- Close Adobe after printing
- Problem getting info to transfer
- extending excel named range with vba
- On a PDF Note --- Check this out..
- Can I get a chart to an image file?
- Trust VB projects setting Grayed out
- Count elements in array
- Adding text file to a user form?
- code line number
- RE: Fill in the blanks
- Error Trapping
- Add-in Auto-Generation
- Code Line Number in VBA
- Fill in the blanks
- Changing font color of textbox text.....
- printing and viewing
- macro extracting text
- Validate mm/dd/yyyy
- VBA Range Issue : Cannot programatically select more than 42 columns
- Format
- Using VBA to Paste items copied within Excel
- big counting problem
- EquationType Property
- Coding with pivots and Multiselect list
- List Box - MultiSelect
- VB in Excel
- Refering to Desktop
- 'Right'
- Must be first
- Saving A File
- Create an Adobe PDF from other PDF files
- Resources problem with VBA & charts
- opening consecutive files
- union problem
- Remove a Reference
- Need help with a macro
- VBA question: editing alpha characters out of numeric values
- converting from text to number
- Macro one workbook to another
- Beginner looping / summarize question
- How to Determine if column of certain rows in a text file has data?
- UnMerge Opened Workbook from Add-In
- replace cut command
- Font Examples via a Macro
- ActiveSheet in a Macro?
- Changing data in a column
- Renaming a Module
- Using .formular1c1 with the Range/Cells Method
- Help needed with this autosave macro problem
- command to be run at a certain date
- Commandbar - how to find out which msoCommandButton was pressed
- Removing Password using VBA
- about "GET.CELL"(cel interior color)
- find value and copy column to new spreadsheet
- Populating the combo from worksheets
- Autofit, Centre and Text
- give back times of current month automatically
- Want a simple VBA code.
- Check cell contents then format as locked
- Convert a String to an number
- Model Audit
- Capture footer info without opening a workbook
- Footer info from unopened workbook
- counting items in a range
- Finding Last Column in a given Row
- Creating a (Modal) version of File :: New :: Contact from Excel (into Outlook)
- Stuck on a validation loop
- Preview of Spreadsheet/Document
- Jump to the next count in a FOR Loop
- Cell value prefix
- Save without prompts
- Adding checkboxes via code to a workheet
- Adding checkboxes programmatically to a worksheet
- SelfCert
- Disassociate Macros when saving under different name
- VBA Form Button Closing WorkSheet
- Import xls file..vba excel2000
- Changing Sheet Name
- Set certain rows to Bold
- Do loop without do? Why?
- Stripping out contents of a cell after 8 characters?
- Extracting Footer information from unopened XLS file.
- Extracting footer informatiojn from unopened XLS file.
- How do I plot a scatter plot in 3 axies?
- File get bigger when I save in excel
- disable right click menu
- Recordset Filter by Array
- Passing CheckBox Value from Click Event to Main Macro
- Displaying Custom Toolbar in Specific Worksheet
- How to detect another application
- UDF runs in 2K, don't in 97
- How can the range.calculate macro be run with "iteration" and "ma.
- Hiding Workbooks
- insert or update
- converting a cell text to date
- how to copy formula without changing reference
- Displaying cell contents based on input?
- stop recording toolbar
- USING SOLVER IN EXCEL
- Application.Selection Is Range?
- Outside Data Sources
- Validate Data in VBA "How to get lost focus cell address"
- TextBox in UserForm with > 24h time format
- Passing argument to another Sub
- Adding and Changing 'CustomDocumentProperties' from VBA on other f
- VBA Excel project won't work when opened in intranet
- Copy cell data Workbook to Workbook
- update label or text box
- How to keep a workbook visible
- command button move worksheet from one workbook to another
- Page Break
- Is There a Function To Reset Macros?
- Relative referencing in macro won't work
- stack space deficiency
- R1C1 and the $ sign
- Form writing blanks!
- How to add control to toolbox
- Display history in user form
- How can I get this code to work?
- VBA Help
- Number Formatting when joining two strings
- Logging activity
- Formating of Numbers
- The disk is full error message
- Selecting a variable number of cells in a row
- Removing Defined Names
- VBA project in Intranet
- Macro Start Autorun without Enable security
- Userform runs other subs when initialized
- hyperlinks out of a combo box
- Opening a dialog
- collection of sheets
- Dates to Worksheets
- Spreadsheet with merged cells - how can I unmerge the cell and re.
- create a right click menu in excel 2002.
- how to set random numbers that add to 100%?
- sending the active worksheet and an additional new sheet
- problem importing data from another file
- Range of even/odd rows
- How to get enique records from data list?
- copy active worksheet plus another worksheet
- How to know a row or cell is blank...
- how do i programmatically insert a button on a worksheet
- data validation quirk
- Macro to Count how many times a number occurs on a day
- Finding new entries in list
- Reverse VLookup?
- Copy changed rows into a new sheet and save them
- Excel SendMail Not working in XP Office 2003
- Numberformat for Cells using Automation
- troubles when 2 webbrowser navigate simultaneously
- First Empty Row
- How to calculate this on all rows?
- show messagen when running a macro?
- Limit User scrolling
- Autofit excelrow
- making normal text to hyperlink.
- Hidden cells
- Event Procedure
- without for loop
- Event Procedure again
- Macro to Extract Values from Master.xls to Report.xls
- greying-out item on custom popup?
- VB msg box - can it have a title?
- Find, Match, Compare or Search.... Help!
- Userform handling
- Excel VBA
- Auto move scroll bars of listbox
- .AddShape(Type, Left, Top, Width, Height)
- Between values
- Can I list which sheets/cells have changed?
- rename worksheets after copy
- Formula in given via input box
- data entry template
- macros code & color based functions help
- File Error: Data May Have Been Lost
- Sort Contents of Moving Range
- Excel Wookbook naming