- Conditional Formatting script
- How to find out how many rows do my collumn have?
- CommandBar("Cell") additions
- Transposition of data
- Command for recalculating macros
- vba for excel
- What's this button?
- FollowHyperlink
- Preserving Previous Formula Values
- specifying chart size
- formula?
- Excel to Access
- Forcing users to enable macros
- Weighted Average Question
- Excel VBA and multithreding
- Cycle through a list (Part 2)
- Clear contents of row but preserve formulas?
- Another little ? on CommandBars("Cell")
- Turning Colored Cell's Off
- Office 2003 not able to run wscript??
- On Paste
- excel macros
- ODBC errors with new pivot table
- variable name based on calculated info & iteration formula
- UserForm
- Work schedule help
- Automation and Add-Ins
- formulas refer to columns that are deleted
- Calculation Options
- Pastespecial via vbscript not working
- "Multiple-step operation generated errors"
- Excel schema using Jet OLEDB Provider?
- passing strings
- ColumnWidth not working...
- Creating small "recordset" or sorting a numeric 1-dim array
- Excel VBA - Web Query causes Excel to run out of Memory
- Disabling Screensaver
- Is this correct?
- Need some help
- Convert text to values
- HELP: Forcing Excel to print Entire Workbook
- Paste Clipboard
- Time Stamp
- Trapping warning message
- Creating regressions with more than 17 data points...
- CELLS WITH TEXT
- Create new sheet
- Calender Pop-up
- Formula help
- Code Documenter for Excel VBA?
- need command
- Lost password, modify my worksheet!
- Excel Gurus = want a macro in 1 workbook to get info from another workbook = Read please
- Sheet creation code modification
- How to Get records from a query in access and put them in Excel
- COMException 0x80028018 - old or wrong library - newbie to automation
- basic spreadsheet
- Converting a date to a non date format
- Worksheet Position
- Updating links
- Time Calculations that roll past 24 Hrs
- UserForms to deactivate workbook
- Excel file
- Running external programs
- Variable scope question w/combo-box, 2ND try
- Duplicate sheet error handler
- Updating worksheet problem
- Named Array
- ActiveSheet.OLEObjects.Add - method inserts icon instead of image.
- Stop open file through Document Property
- SubScript Out Of Range.
- ListBox Question
- How to get Control M to move cursor down
- Looping
- modify cell references in a formula programatically
- HELP - How do I disable Excels menu items so others can't use
- Macro in Excel
- Printing worksheet
- CustomDocumentProperties
- Changing "Cancel" in SaveAs
- combobox matter
- how to make sure the file is saved on a network
- Amount of code in UserForm
- Code malfunction
- Screen off during Macro execution
- Transferring ranges to/from arrays
- Expanding Code
- Re: Expanding Code
- Excel VBA - Web Query causes Excel to run out of Memory
- Re: Expanding Code
- Switch images in VBA
- copy down to all Vlookup "#N/A" cells ONLY (in the same column)
- Compatibility with older versions of Excel
- change password
- Delete Entire Row.
- Setting range of cells format to currency
- User Form
- Populating sheet names in combobox
- Email a sheet code modification
- "running..." message
- Excel automation from C++ with MFC
- Workbook_BeforeSave
- using ranges to determine input
- FileSearch gives unexpected result
- Question about VBA?
- Slow Looping
- working with images
- get filename and filepath
- Date Highlighted on Calender Pop-up
- help button
- Pastespecial via vbscript not working - REPOST
- Pastespecial via vbscript not working - REPOST
- Vba code
- Calling from C#.Net App Office._CommandBarButton.Execute() method in Excel 2003 throws a COMException
- Printing a user form landscape
- Outline Performance Degrades
- Excel VB, Workbook.activate
- Sheet naming question
- VB scripts from Office 97 that no longer work in Office 2003
- Bank reconsolidation/Transaction Matching/OS List
- password change again
- Find and replace '
- Before right click in a sheet
- input template
- Excel 2000 Chart & VBA: why oh why?!?
- Pivot Table question
- Protect Destination Formatting
- List Box on worksheet
- Worksheet Code Expansion
- Conditional Sheet Attachment
- commandbar with own textfield for datetime input ??
- spinbutton.enabled = false not greying out
- Enum
- Advance Filter
- Setting Cancel = True in WorkbookBeforePrint
- re Password Change again
- Run time error
- PasteSpecial macro
- just copy the data, not the fuctions
- Why doesn't my loop work?
- Disable the Edit menu command 'Paste Special'
- Browse Button for File Save
- VLookUp.
- Please confirm the following bug in Excel
- Excel as RTD server?
- Universaly available macros
- How to find the current pagefield of a pivot table?
- SpinButton Rounding Up
- Macros in Template
- Is there an easier way to address ranges??
- Before Right Click event
- Engineer calculations
- Protection lost on Open
- running macros in downloaded files
- Reference oleobject within shape group
- Excel Macros Getting Cleaned
- Opening a file
- INDEX MATCH
- Heeelp: Method 'Cells' of object '_Global' failed
- Extend Excels range
- Refer to Hidden Sheet from VBA?
- Group Function on a Protected Worksheet
- Underscore in Excel Title Bar
- How to use macro to enter password?
- refresh van uw screen commando
- Concenate (Kjede.sammen)
- Excel Crash only if VBA not open
- Problem with named Range in ADO extract from Closed Excel File
- Linked worksheets
- Does anyone know how to do this?
- Text Boxes
- refresh of screen -- commando
- CheckBox values
- Feeding Date Values From C++ Using Automation
- Comment
- Passwords
- Security...
- Insert Page Break in the Worksheet
- Code Tweek Needed
- Charts
- attach custom toolbar to spreadsheet: how?
- Delete Specific Range Names
- Username
- Enable and disable worksheet controls?
- Use VBA to replace 2002 by 2004 in Date
- Autocorrect in VBA
- checkbox - default checked or un-checked
- textbox - format for dates (mm/dd/yyy)
- Multi-column Combo Box
- VBA beating me up.....again
- vba code to sort data?
- Syntax to define a variable for current file
- Specialised validation
- Newbie: How to Print by VBA a Single Page in a Worksheet
- Deleting series of repeating rows
- Trouble with Excel Charts
- VBA Editor SetUp
- String Manipulation
- Loop within Excel Formula?
- Excel crashes when .Net framework installed
- simple excel VBA programming
- Problems with a Form's behaviour
- Disabling Selection of multiple worksheets
- auto-launch a MACRO?
- Working with ODBC and filtering data
- Conflict
- File Path Problem
- Fixed Width - Opening Certain Fixed Width Files
- Memory Leak
- Macro Question
- Random Selection
- Cannot type text into VBA Help Index
- Changing the Style of a Combobox Via It's Name
- Macro Question
- macro code for sending e-mails
- Longs losing accuracy
- Help needed (idiot onboard)
- Running Macros
- changing the application name in the title bar
- Automatically run macro when opening file
- autofill range
- Open a new instance with a shortcut
- Run-time error 1004
- Deleting blank cells in a selection
- Copy and paste isn't that hard (is it?)
- Disable save, but not save as
- Variables and range problems
- security for my macros
- WHY?
- enable / disable macros
- Moving a file
- Setting Conditional Formulas
- How do you combine lists
- Vlookup to Access Dbase
- How to convert concatenated text to a link to an external workbook
- Is there "pointer to a function" in VBA
- AutoFit Selection
- registration
- Make 2 long columns into 8 shorter columns
- Working With Worksheets
- How to create transparent objects on images in Excel
- Limit entry in range
- Delete Macro After Running
- Image set transparent becomes opaque on clicking it
- MsgBox Question
- Programming help
- Excel & Custom Menus
- Finding the name of the pagefield clicked
- Summing undetermined colums
- Help in VBA programming
- Excel Formatting
- unknown menu appear when installing an AddIn
- EXCEL FORMULAS
- dot 2 koma
- Highlight Track Changes with VBA Code?
- Finding a date in a sheet
- List boxes, Arrays and Sorting
- Assigning Macro's to control buttons.
- Locking cells in Excel
- ADD-INS NOT WORKING IN XP WHICH WORK IN WIN 2000
- activecell.formula syntax
- DDE very slow with Excel 2002, 2003
- DDE very slow with Excel 2002, 2003
- Retreiving info from a web page table
- multi tab selection prohibition
- Attaching cells to word documents
- copying and renaming sheets
- Close Open Woorkbook and Quit Excel
- Surveys
- Range objects (?)
- unknown combobox name
- How to disconnect when WebQuery done
- Searching range for value (code written but needs 'tweaking'!)
- Passing Selected Sheets' Names to a Macro
- Run a macro when cell changes (due to calculation!)
- Index / Match - desperation
- Cleaning up data
- SaveAs Macro Help?
- Moving Rows
- Counting names in a column
- Chart created in VB generates 2 additional meaningless series
- "Enter"on keyboard problem
- Passing a named varaible to Excel's Autofilter
- close window trapping
- VBA application; Subscript Out of Range
- Help printing to PDF file
- Capitalization in Declarations
- Footer word wrap
- Flushing a File
- XL97 - Command Bar Removal
- Chart Setting Xvalues
- Method selection of object _Global falied
- Templates Ignore Protection Settings
- How can I ?
- Macro for worksheet to workbook
- Exit Sub?
- Run code from one worksheet to populate another.
- reference new sheet in same workbook
- Status Message
- Range Search
- Highlight non- contiguous rows
- Calling Bubble Sort Function
- Find / Replace / * -1
- Many Sub Worksheet_Change(ByVal Target As Range) In One Worksheet
- Argument with onAction in a menu.
- Help on closing object properly
- Remove Save Button from toolbar
- Define a range globally
- Re: Highlight non- contiguous rows
- Trying to find string in a column or row
- Delete modules programmatically and save
- Excel 95 Dialog -> Excel 2000 Userform
- Excel VBA Examples ( Book or Program)
- FP2000 Publishing problem
- Formatting a workbook for database import
- structure of classes,objects,properties,methodes,events...
- Margin of Error Formula
- Pop Up icons
- Proper Programming
- Manipulating text - 2 queries
- How do I figure out what I need to do....
- fso delete folder
- User Defined Function description
- can I call a procedure using a variable
- Copy and Paste from One Workbook to Another
- Spinning numbers
- Right formating with an ident
- "Out of Memory" when import text file
- passing a range to a user defined function using a form
- SOS:Know Deleted/Inserted Range in Excel 97/2000
- activecell offset
- VBA searching a row
- DDE very slow with Excel 2002, repost
- RaiseEvent from a class contained in a 2nd class collection?
- Add worksheet
- Spinbutton sorting
- Practical Excel Range Looping Project
- programming vba in vb
- Save As Boxes and VBA
- Funny shade of green
- pagenumber of active cell (vba)
- Slow Down...
- A simple problem...
- Function and needing to Refresh
- dumb question
- please explain
- Top left cell in used range
- excel97: runtime error 1004 select method of range class failed
- Macro won't run from CommandButton
- Excel 2002 - VBA code to insert copied cells??
- Running a Macro Automatically
- FileSearch using VBA
- button to update cell
- Need help Selecting, Sorting, Autofitting a range
- excel2000-question
- how do i set an entire row or column to a range?
- export method not working properly
- Cannot Type Text Into Excel VBA Help Index
- How to get out of loop ????
- Merry Christmas To All
- Trying to import data from many closed excel workbooks into one: Please Help :-)
- Needs help about Real-time Data
- evaluation of a cell with a formula
- Set range statement
- Form will not refresh without an unneeded msgbox
- ListBox Result
- OLE DB Query Table to Oracle using Parameters
- Performing code without opening the Workbook
- My Add-in causes problem with opening a file twice
- Detect Comment + Happy Christmas
- vb code in excel
- Printing using Acrobat
- Offset & Combobox's returned Value
- Macro recording box
- Report: Copying pagebreaks of a reference sheet to other sheets
- C++ Com Addins for Excel
- Change VBA Code,Stock look up
- Window's System Menu, can't remove menu
- An Interesting Excel UserForm Question
- read from 1 cell read to and other using vba
- Search/copy/paste Macro
- Defining a discontiguous Range object
- intersection? of two cells
- How to check for next empty cell in list
- Executing code with opening target workbook
- Executing code with opening target workbook
- Where can I find TAPI code/reference for VBA?
- count Worksheet using Wildcard
- Basic Excel Question
- time
- Checking to see if a Workbook is Open
- Sort buttons by caption?
- Sql query on a range in the opened worksheet
- Determine if a cell has datavalidation
- How to determin a Excel file has Macro
- How can I set encoding in EXCEL
- How can I set encoding in EXCEL
- Differences in formulas using HTML between 97 and 2002
- OFFSET problem
- Re: Check it out!! = VIRUS
- Listbox
- Loop
- How can I know if a sheet exists ?
- How to enable multiple selection for combo box?
- Finding column Letter
- Macro to paste a copied range
- How to paste data?
- Spreadsheet snapshot in UserForm
- Multilpe Checkout problem in Office XP Dev
- How to run a Sub while opening the xls file (what event to use)?
- Sorting
- BASIC VBA QUESTION
- Creating e-mail in Excel
- Simple help with macro please
- Creating formatted Outlook Msg from VBA
- read Access table from VBA
- How to build build a macro that automatically imports>
- auto format 5 worksheets out of 6 when opening excel spreadsheet.
- if then clause in a cell
- Option buttons to select a row of cells
- Asign Array Variant to Column
- move the cursor to a button
- Images and Userforms
- Keping a UserForm open as VBA runs
- HELP WITH CHART SETSOURCE DATA!
- Undo Please?
- More help on closing Excel.Application
- Userform and Worksheets
- list Workbooks in Current Folder
- Debug Error
- PivotTable Dynamic Range
- Combining names
- cell number in collection
- ignores hidden columns?
- Q) Last row/column ------ excel formula query
- If Error
- Cant find workbook
- Workbook Path
- Strip out data using VBA
- File Not found
- MARCO to import text by selecting columns
- String Question
- WRITING TO A TEXT FILE WITH SPECIFIC FORMAT
- Macro to copy a range
- Update VBA Module Code
- Need suggestions on netting data
- VB PasteSpecial when range changes
- Introduction to excel programmin
- Cells values included in personalized e-mails
- Reverse of Hlook up
- show userfrom from another application
- Exporting data
- copying sheet
- find in access database
- second combo box will be dependant
- How can we share more projects?
- Excel 2000 Macro
- VBA online help script errore
- Shortcut to toggle active Worksheet
- SaveAs...
- change chart source from range to raw data
- save on leaving a cell
- Selecting a range
- Time intervals below 1 second.
- Writing to System Application Log
- counting cell conditions
- Opening Excel in my program
- Linking Cells to ListBox - How?
- Linking a workbook to an add-in
- Changing Data and Charts
- Define a name question
- defined name question
- Installing Personal.xls on other computers
- Controlsource
- PlotArea picture from wbk?
- VBA question involving numerous additions
- Complicated Time Formula
- Creating 'yes' or 'no' option in a designated cell
- Addins
- Compile VBA code
- Installing Files
- ComboBox or what?!?
- return values rather than formula.
- Linking textboxes to cells with formulae
- User Form / List Box
- Selecting Range After AutoFilter
- ChartingQuestion
- Excel percent adding macro
- summary by date
- New Product Announce: Convert Doc to PDF For Word
- multiselect listbox
- Passing parameters to UDF
- TotalEditingTime
- Data sorting macro
- Determine if Workbook is Open or Closed
- Input Box
- User enters data in popup box - its entered into desired cell
- Can't get the logic right
- List macros for user to select...
- Help to modify macro please
- Can I sort without activating / selecting sheet?
- convert text to number
- Problem with Excel 2002
- Open up rows
- Concatenate different ranges
- Tabbing to Checkboxes
- Progress Bar
- Combining variable names
- Bloodhound.ExcelMacro
- Pivotitem count
- Making a Msgbox popup
- how can I read date and time from ascii file?
- Freeze/Unfreeze Panes and window display
- Spinning Numbers
- Compiling a macro as a .exe?
- Arranging cells to create a database
- Budget System
- Using a Varible inside of a proper address
- Editing code
- Print windows opened with FollowHyperLink
- ListBox problem
- Re: VBA/Macro Help Needed
- Check Selection
- On error goto 0?
- Attaching a macro (module) code to button
- Incompatibility between Excel97 and Excel95 macros
- Saving button on all workbooks
- VBA and X10
- Showing PERSONAL.XLS
- Naming Chart
- Problem to calculate cells
- Selection.ColumnWidth
- Start and end criteria macro
- What does F1 mean???
- Viewing built-in functions
- Only Show User Form Once
- Viewing built-in functions
- How to refer to a blank/null value?
- FAQ
- Worksheet Mailing Conditions
- Impoting a text file - Excel 2000 VS. 2003
- AUTO-CHANGING THE DATE
- Disable Events
- save picture in worksheet into certain folder
- Determining Last User Action
- Close Workbook Programmatically
- Inserting Module into Workbook
- How to stop Excel from accessing the net
- Populating word document from userform inputs.
- Change focus from Userform back to Sheet
- Last cell with data
- offset problems
- Load Windows Explorer
- About RoutingSlip
- Update on Current Selection
- Extracting info from a database
- vlookup problem
- Try to change the path of the Query of pivot table in Excel 2000
- search/copy/paste macro
- copy range from one sheet to another - basic doubt
- Search, find, copy muliple cells from new sheet and paste
- save data , images and hyperlink between two workbooks
- Performance tradeoffs of complex worksheet functions vs VBA? when to switch to a UDF?
- Excel Macros Slow in XP
- Spreadsheet to calculate payouts in tournaments????
- Constraining custom toolbars to one file
- Task ID for App
- Microsoft Queries - copying and changing criteria PROBLEM
- Query Problems
- Highlighting text in a textbox
- Macro for creating folder
- Pick Several, Add All, Remove All
- Need strip out data from column A using VBA
- Upgrade
- Using VBScript to create Excel SS and sort by column.
- Re: Saving only current sheet
- Lines in a Module(Procedure)
- combo coding
- Re: XLSTART default
- Re: How to set multiple filter values for a filter in the page fields
- Excel XP removes AS part of statement
- Re: Help? Inverse factorial?
- Help? Inverse factorial?
- Disable item in combobox
- Excel to Access using ADO
- Creating a List Box on the fly
- Moving a sheet from a closed spreadsheet & making it part of an open one.
- error 57121
- Printing
- Re: Number format as condition for not deleting a line
- Using With to speed up macro
- Disable Macros for Template
- Runtime error Permission Denied
- Assigning Macro in another workbook
- Padding Numbers
- VBA Names madness
- Control Order on User Form
- Protect sheet while enabling outlines and custom views
- Range selection code in a macro
- Insufficient Memory Error.
- Get List of Keyboard Shortcut Bindings
- Re: Naming Chart
- Stripping out non-numeric values from external data source
- Text importing problem. Please Help!
- Formula
- assigning macros
- Offset not working
- Subtotal + Conditional Format Question
- Changing font size in row and column headers ?
- ListBox Result to a Specific Cell Location
- Name define
- Routing Slip Question
- Regular Expressions in VBA & Excel including an interactive tool
- Fix InputBox - Returning Empty String
- Export Excel data to Access Security problem
- User Form
- Printing A Range
- Interactive Macro
- VBA Script in Excel
- How do I read text file in an EXCEL SHEET
- SendKeys command not focusing on the correct open program
- How to get column values from other excel file in VBA
- Testing for a open worksheet from Outlook
- Printing Ranges
- Problems creating "line and bar chart"
- Access values from another workbook
- Autoload custom menu on Workbook Open
- excel project
- Making output go to a worksheet
- Macro for selecting a row
- Error
- VBA code to open file?
- Use "VLookup" function
- Get the name of a group given the reference to a shape within the group
- Testing to see if a Workbook menu item exists
- OLE Object -TexBox Properties
- Excel data format problem (Urgent)
- Excel data format problem (Urgent)
- Automate printing. Some help please!
- Far too many "IF"s for my own good
- Putting text in a cell
- Access field order using ADO
- Web Query Failure using url.CFM with xl97
- Show user form
- vba date & data formatting problem
- File size problem: standard remedies not working.
- List box setting of initial value triggers a change event
- need time conversion formula
- Access from Excel using ADO
- How do I make an open workbook the active workbook
- Activate new window
- Optimize Time In Filling Cells
- Functions and Ranges
- Close Open Workbook
- Weird double selection
- Help Please
- Why an error?
- assigning cell values in formulas
- FormatProblem
- Image on heder at VBA
- new error when try to load userform
- Pattern Files
- UserForm ListBox
- Problems with combo boxes
- Pre-numbered forms, I think its impossible, but...
- Special Cells to Loop back
- Left three text characters
- Display problems...
- Dynamic list box
- Automation
- Record Count (There has to be an easier way...)
- macro that copies controls
- Populate array
- Class module
- Strip Alpha Characters out of an Alphanumeric Dataset
- Function Library Creation
- Using 'SAVE AS' within macro with mutliple files and keeping default savename
- SQL string to return top row
- Is there an easy way to replace list A instances with list B instances (sorted lists).
- Selective Protection of a Worksheet
- Code to edit code
- Help modify simple existing code??
- Can't Update Links
- Floating Command Button - How to???
- Tab support for worksheet activex controls
- Print Control in Word/Excel
- How to Copy worksheet to new workbook with dynamic name?
- Message Box
- Get Object
- Format comment username
- Removing the rightmost digit
- Syntax
- Changing a formula that is copied and pasted using vba with excel 2000
- Closing an Unsaved (but Changed) Workbook
- Pull Data from a closed workbook, without opening it.
- Printing
- Removing the right click capability
- Parse
- Beginners plea for help
- What's wrong with my NextRow code?
- excel for each ..next
- Macro
- SpinButton Problem
- Set an Access field "not" required w/ADO
- 7 segment LCD display
- math powers, fractions and editing ASCII characters
- Making splash screen
- Detecting Macro code behind a sheet
- VBA Code to wait 50-150 mS
- Payback period macro
- One macro for many controls?
- Explaining an addin
- File...Send To...Email Recipient
- Macro for several worksheets
- ActiveSheet.Copy
- Sortin Numbers as Text: How?
- Excel random sorting query
- find & delete + fill to end code?
- Combo Box Item
- Find errors
- Desperate -Lookup function needed!
- a string object
- Option Explicit Error
- compile error using Left() function
- Running command button click event code
- Generate powerpoint slides from excel automatically
- Help - Run Macro on Calculate
- Looking for sample of VCR or Navigation buttons for use on UserForms
- open word file?
- Copy worksheets
- test
- Absolute references
- pastespecial in vba
- Inefficient Space Removal
- Directing data to new worksheets
- Detecting Macro Code behind a sheet (2)
- Rows ColorIndex
- Better Use of Dim statement
- Pass an ADO recordset
- Excel sound alert
- Toolbars
- MS Excel 2000 - Data Delete Help Needed
- I Can't Get VBA to Work
- Formula pasting is not working
- selecting a range in vb
- Embedded option buttons
- ASP to Excel
- Using the Back Button when viewing Excel through an Intranet Browser