- Setting LineColor in a Chart
- Toggle a Caption
- Mimicing the Calculate Process
- Constants being public?
- Locking/unlocking cells
- COUNTIF with more conditions?
- Using text values in an IF statement
- SUMIF Criteria
- run-time error 5 with MID$ function
- HasLeaderLines not working
- and statement
- FIND ERROR Why wont this work?
- Detect workbook name
- From Sheet 1 to Sheet 2!!!!!!
- Delet Rows with 4 fields conditions?
- Referencing A Calling Object
- Counting the weekdays only in Excel
- Wildcard Searches
- DTpicker data update
- excel rs.eof
- Filter 2 columns onto Sheet 2!!!!
- Delete rows - No cells were found problem?
- About cell value manupilation
- Userform connection
- How to
- Weird!!! :huh:
- Error message: Index out of range
- 2 Questions about Excel and VB
- VBA Catastrophic Error
- to read entire ms excel sheet
- Converting text to number
- Insert Name in New Created Row
- VBA and IE
- Something's Wrong
- HELP No negative number possible
- Concatenate range of cells depending on other cell value
- vba date problem
- Can't get code to work. Please help!
- Info on a function
- File Reservation - being modified by another user
- Inactivate alerts upon Excel app opening
- Objects - how to hide/unhide these in Excel app?
- writing to a txt file
- Macro with Sql to Access Database
- Seemingly random command bar button states
- Unable to set XValues of a Series
- finding the last row
- Determining the extent of a range
- Quick one on deleteing a sheet.
- ElseIf Statement problems
- Find Starting point for insert
- reading from a TXT
- Automatic and Manual Calculation
- Cant populate information to webite form
- Very complicated project with multiple workbooks
- chart labels
- Can VBA capture screenshot of Excel Worksheet?
- 5-digit numbers converting themselves into things like B51C6100
- Getting around having to type a decimal
- How to detect one copy of Excel even after its task name changed?
- Modal UserForm becomes modeless after SaveAs
- group by percentages??
- [XL97] Getting validation lists to show something other than 8 entries?
- select sheets in workbook using combobox
- email command
- Unselecting an Excel cell section in VB
- graph in excel
- vba on 'save' function
- Problem for Excel unique file generation
- Problem with Code
- VB code for excel needed
- Know of XL/IE documentation?
- Skipping some code out that it shouldn't
- choose a file
- Code works until uploaded to web server
- Difference between VB and VBA?
- could this be a data type problem inExcel?
- Drag And Drop
- Cell range naming in macro
- Checking if a cell value is member of a set
- Percentage increases
- VB to find a range in excel document
- Prevent text entry into a textbox
- Overflow Error
- Help shortening some code
- Detect one copy of Excel even after its task name changed again?
- Speed up my subroutine!
- select first cell in row
- trying to save a template under different name
- prevent saving of online XL App
- Speed up Array Formulas
- Catching Format(dd/mm/yyyy)
- Save Sheets As Workbooks
- how to label charts ???? anybody charts ??
- Handle Macros with multiple Workbooks
- How to use variable to select range??
- If, then, else Visual Basic Macro
- How to clear all format stuff from sheet?
- WebBrowser to Image?
- Opening database with excel macro
- Any experts on Groupwise / emailing from Excel VB?
- Excel VBA : VBE - Problem
- copy sheet to another
- AutoFilter with multiple criteria problem
- disabling exiting excel
- Copying and Pasting an Array
- Worksheet.Copy placed online behaves buggy
- selection sorting
- I need urgent help with code.
- FormatConditions Add Run Time Error 5
- working with functions
- Arrange Worksheets Alphabetically
- memory loss!
- quickie
- database function lookup with criteria
- Code not referring to the right range
- "Global failed"
- Open and close an excel file
- insert formula in excel with VBA
- Grouping worksheets from different excel files.
- About adding new worksheets.
- Is there a way to fast average and deviation calculation?
- How to deteect switching between mulitple workbooks?
- Declaring a cell
- Global variables
- Difference between cells.value and cells.formula?
- Removed one Excel VBA to VB Form?
- Dynamic Excel in VB App
- Creating an interface for Excel spreadsheet
- Opening Exel file while VBA application running???
- coloring a cell
- coloring a cell
- Vlookup return range
- Set hyperlink on file copy
- Running MS Excel 2000 Visual Basic in MS Excel 2002
- determine rows pagebreak
- text file to VBA array
- Collection problem
- Not Responding On Open
- Get rid of Security Warning?
- Unnecessary worksheets copied.
- Validate email address in Lotus database via vba
- adding two cells in VBA
- OLEObject Troubles
- Double printing
- Excel Automation Error
- NumberFormat problems
- Conrol Text boxes
- remove spaces from text
- Creating a new xls file from a given xl spreadsheet
- creating arrays
- Determining regional setting in VBA code
- Excel Issue
- A step up from .csv
- Help with Japanese Dictionary Translator
- show wroksheet on open workbook newbie
- Date in text box on user form
- Excel Worksheet Name Change
- string to checkbox (vba)
- How do I delete a workbook using VBA?
- Linked Cells Return #Value
- UserForm with an MS Office Web Component Spreadsheet Object
- Date in excel
- Turn off Automatic Calculation
- Disabling exiting excel
- Convert .dat file to excel
- error on oXL.Workbooks.Open
- Is there anything wrong for my Excel?
- Renaming Tabs
- Consolidating all sheets into one.
- Chart -less number than expected Probelm?
- Help Needed With Lookups
- Changing properties of High-Low lines from VBA code
- help!!Problem in transforming the VB programme into Excel
- Insertable excel object
- How do I use a Drive List Box in excel?
- How To Populate A UserForm
- Problem with Office Developer XP in Excel
- excel workbook size
- About copying range.value
- Display autofilter arrows
- OpenText question
- select cell after autofilter
- Creating a new worksheet....
- change directory path in SaveAS UI NOT work?
- Exiting Excel through macro
- textbox input not working
- Naming Ranges
- controling a form from another program
- look-up/Find/Search difficulties
- pass an array
- Code breaks in VBA loops
- Wrapped Text within a merged cell
- My Excle quit, its hwd still not 0?
- Is there a way to detect My excel data is in saving process?
- Counting contents of string
- Re-number Excel Worksheets
- how do I make a macro automatic
- Commondialog in VBA?
- SaveAs and no option
- excel data transpose
- SheetChange only when condition is met
- Virtual Function
- Eliminating Excel blank pages
- Str function in Excel 97
- Why isn't this macro looping?
- Array Formula & VBA
- Open and save Excel file from button
- Copy Sheets to new Workbook w/o Code
- Save worksheet as text file
- Paste componets to a new page
- Text files and VBA Form
- Set Open IE as Object?
- open a worksheet without showing it in windows bar
- DataLabel Position
- Worksheet_BeforeRightClick for all Sheets?
- repeat sub loopish?
- Problem targetting correct cells
- Event proceedures
- Problem with function/formula
- closing an excel file
- Excel crashing/freezing/not responding while completing a userform
- Run macro on 100 worksheets
- A Cell Contains Part Of...
- using a Value for a Range object
- remove pagebreaks
- VBA form attached to sheet
- Anything here to Crash my Program?
- Help Needed on quick one {navigate to specific range}
- Clone objects in Excel VBA
- Setting the Caption for a Form Control
- Automatically overwrite file (No prompt)
- copying values from one sheet to another..
- Problem closing Excel through VB
- Next empty row
- Find error
- Create a Add-In
- variable in find statement
- Chart Text/Label
- Font Changes Appearence
- Cells format
- VB6 & Excel interaction
- Prohibiting Duplicates
- Excel / VB 6.0 Link
- VB code to fill textboxes from Excel sheet to VB form needed
- Webpage using Excel information
- Formating: Drop down / pull down menu / combo box
- collections
- 'Bad Record Length'
- Worksheet change event