- Removing the little Excel icon in left corner
- Show Grid lines
- Need help with two Execl VBA problems
- selecting a range from a list
- Data validation using code
- changing case
- Format dates
- unlock project with VBA code
- Learning resource for VBA
- vblookup and type mismatch
- Disable app window controls
- Excel 2003 Split cells
- Change sheet reference in formula?
- how to programmingly insert a new row in excel sheet?(using VB code)
- Email Workbook
- Adding Records to Access Table
- Need suggestion for multiple messages
- invalid picture file
- range.address ?
- Variable Array Problem
- Text Import & Current Range problem.....
- Run Macro from another X number of times
- Save excel file with filename = cell text
- protecting cells with macros
- Need help on Logical Statements
- array of rows
- simple conditional find, copy and paste
- Reclaiming VBA Code in a corrupted file
- Search or FIND on a userform.
- VBA code to save gives error 1004???
- Autofilling a formula to a variable last cell
- Turning Calcuation Off Completely
- System Resources
- Reading .csv file into array
- List Boxes (Help!)
- access the solver reference library
- Write data to access file through EXCEL
- test
- Converting time to numeric number
- Extract name, dates & number as criteria Then paste to current file
- counting rows to an empty cell and making a chart
- SaveAs didn't work in VB protected mode
- detecting a vertical page break
- Personale Number Rounding!!!!!
- using date ranges in a pivot table
- vba code problem
- linerar/integer programming problem
- Calling objects
- Help menu in Microsoft Visual Basic
- Look up Headache
- Date Reference in VBA
- RTD Callback and CIS with firewall
- Saving in Excel 97 a workbook developed in Excel 2002
- Userform Textbox - Date Problem
- Changing Calculation Method
- RefEdit - cannot select range on another workbook
- mail workbook
- Two cells into one
- Two cells into one
- find files and copy to new directory
- Replacing Carriage Returns
- Create dynamic variable names?
- bitmap for buttons
- VBA Speed question
- Loop through checkBox on worksheet
- bitmap for buttons
- Page set-up when selecting multiple sheets
- vba...finding location of number
- Array of page ranges
- VBA filesavename
- Display Current File Name in MsgBox
- #Holding values in different format#
- VBA in 97 vs. 2002
- Macro that will autofill a column with data, up to the last row of data in previous c
- Use Current directory to store file
- named range not specific to worksheet
- deleting objects using VBA
- Problem opening .htm file from Excel 2000
- ADO, VBA and SQL
- Excel Reporting (Graphs - Generating)
- Exercises and tutorials
- Tricky Graph Question
- Inserting & Deleting rows can take ages in Excel 2000
- Allow user-entered file reference
- VBA code for Userform
- Individual point standard error bars on chart
- Excel 2003 VBA Help not working when automating via VB 6
- Controlling and setting images
- Cannot use range objects
- Deleting Workbook
- Excel 97 VBA: tracing a run time error
- Printers & LPT
- Auto accept a value in a cell
- Hiding Sheets
- Very basic question... I MUST be having a brain fart....
- Re: Clearing clipboard
- Data validation code
- Req Help: A slight variation on the auto_open theme.
- Message Box
- Disable Prompts
- XP is deleting Forms
- Re: Clearing clipboard
- Variable produces a complie error
- MS Query - DB connection
- Txt Import problems.....
- advanced filter
- I'm sure this is easy but i can't do it...
- How to group or organize dozens of macros?
- Excel Logic needs a Doctor !! FORMULA FIX DESIRED!!
- replace line of code in vba protected project
- Highlighting Textbox1 Value when form initializes.
- Is Excel Typlib backwards compatible?
- Best place to declare variables
- If then MsgBox
- Excel runs slowly in the background
- inputbox
- comboBox
- How to refer a Variable across Workbooks ?
- is it possible to jump to the souce of link in sheet with mosue click??
- Error 91 - Object variable with block variable not set
- Refedit question.
- Create worksheet index
- User form question
- Worksheet.Protect Question
- Inserting TextBox1 Value into Conditional Column/Row4
- Avoid "...contains one or more links that cannot be updated" message.
- Scrollbar updating
- Forms
- Custom MsgBox using values from 2 different cells
- Macros in this project are disabled
- Determining active conditional format of one cell
- Storing Variables
- Can worksheet data be exported/imported to/from flat file?
- Can I program a userform via spreadsheet?
- How to hide Excel's Top Menu Bar
- excel 5 dialog sheets
- Re: Me have deceived
- Combining Modules
- Formatting Cells that contain Matches to Data in a List
- Extracting records that meet multiple criteria
- Formatted printing
- Keeping Linked Info When Tabs are Renamed
- Sort Code Modification
- How can I build a Excel Function that acts like those built-in
- autocreate chart
- Re: Formula needs tweaking - HELP!!
- Converting figures into words In Excel
- Sumproduct error
- Function parameter description
- SolverParameters behaviour different in VBA and Excel?
- How To: Check if a cell value has changed
- Is this possible?
- Correct syntax for use Replace command via DDE?
- Hi there...
- Is workbook open anywhere in network?
- Using enumeration with controls
- regarding Excel 97 to XP migration / conversion??
- Bypass macros in Read only
- Select Case Picking up number
- Multipage Object on User Form
- Very simple Select problem?
- Text format alignment problem
- Cells V Range
- Net send
- How To: Get Last Cell
- Re: How To: Get Last Cell
- Re: Formatting Cells Dependent on Contents
- Formatting Cells Dependent on Contents
- FileSearch Problem
- Newbie needs help
- Limiting values in comboboxes.
- Re: Formatting Cells Dependent on Contents
- Global Variables Not Accessible
- For next
- copying ranges etc
- view comments in cell
- HPageBreak dosen't f...... work
- Creating Listbox
- closing workbook
- Count the number of just the horizontal manual page breaks
- Checking for invalid dates
- Setting list box contents
- Inserting specific data into moving cells
- when a Find statement is successful
- Setup Userform
- Setup Userform
- Conditional Formating with VBA help needed
- conditional formatting with a twist!!
- Userforms.....
- Inserting Date In Filename Using Macro
- Simple VBA spreadsheet within Frontpage
- Disabling messages from Project
- Aircraft Scheduling Problem>> VBA code needs adjustment.
- Formula
- Clicking 'Cancel' on an Input box
- ROWS() returns 1?
- How can I list the results of my macro without overwritng previous results?
- Using app events to trap workbooks opening.
- Help with some sheet code
- validate data using code
- Worksheet codename
- Programiclly copying worksheet to another workbook
- formula help
- Text box in form truncates information. Please help
- selecting sheets
- Trapping Events generated by a Worksheet
- Dialog Sheet not updating
- See critical pack from the M$ Corp.
- Modifying Code that deletes a Row
- Query Table Problem
- Ping anybody
- my big chalenge - import acces data in excel
- Excel and the Serial Port
- comparing data and write values if true
- data into an array
- Precedent/Dependent in VB
- Re: Passing data back from a form
- Help with text box limit (1024)
- Find Replace
- Deleting Rows
- file information
- Reload Typelibrary? .Remove() & .AddFromFile() fails
- Columns To Rows On Another WorkSheet
- Holiday Formula for an Employee time sheet
- Remove default formating and extra data
- listbox.row source
- Match Function(Code modification)
- Userform and controls locked property
- Cancelling the BeforeClose Event
- Creating a loop from my code
- Code for printing footers
- Replace cell of column with cell of other workbook
- How can I copy formatted text from an Excel textbox into an IE .htm document ?
- why does't this work? (chart in excel)
- Hpagebreak help needed please
- Worksheets in alphabetical order
- test_for_xmas_day - i think there must be a better way
- Any Development environment for Office 2002/2003
- How to pass value between workbooks ?
- Very basic macro question.
- MISSING: shappmgrp 1.0 Type Library
- PivotTables, Page Fields & VBA
- Testing a cell
- Autofill userform textbox
- Checking values already in combo boxes
- Inserting a Row with VBA
- classification in column
- CommandBars("Insert").Enabled question
- making macro resident in memory
- checking errors in the formulas
- group name for form controls
- Why some forms not available?
- Confirm Open After Download - Reading Registry
- conditional printing
- Newbie
- Remove Close Icon ?
- deleting rows in excel
- Help with user function please
- Extracting data from a single cell
- Modulus and the Mod function
- Using linked workbook as a parameter in a user defined function
- ListBox
- Inserting a Row with VBA - reply
- Empty Modules
- renaming sheets
- Probably a stupid question..but Im just starting out
- "Find" question
- delete an excel file
- On Error Resume Next
- Why does this work and not work
- PrintOut with Adobe Acrobat 6.0
- Scrollbar
- run-time error
- App events behaving differently in diff. versions
- Web Query and Line Break <BR> tags
- Calculating and re-calculation a matrix of 100 numbers in Excel
- Conditionally clearing a cell
- ON ERROR RESUME NEXT
- Userform to select start date and end date
- How to cause userform to display
- Problem getting excel to work in Visual Studio (C#)
- Events not loading in Excel98 for workbooks created in Excel 2.1
- Best book to learn excel?
- userform with date searching in worksheet
- manipulating the built-in Data Form
- Snailspace Macro Needs Rejuvenation....Anyone?
- Multiple Filter in VBA
- find and copy
- buttons???
- Inserting value at end of range
- Prove this important package that came from the MS
- autorun a macro
- Enum BrowseForFolderFlags
- Inputbox Cancellation
- Returning value of a cell containing a formula
- Path Not Found
- Easy Value listing code
- buttons???
- Mask input in input boxes?
- Can't quite get this syntax to bring in the required information.
- COMPUTE CHANGE IN PRICE BETWEEN CELLS IN A ROW
- Using variables to select a range
- Worksheet_calc
- Can error 1004 be trapped????
- Formula to macro...anyone??
- MISSING:shappmgrp 1.0 Type Library
- How to disable a macro
- Automation with Delphi
- Macro works from RUN but not from shortcut
- myMenul.Caption = "P&L Report"
- Calculating date overlapping
- How to make the invoice number increase
- Oracle Date format
- How to pass value in cell between workbooks ?
- comments AutoSize
- Compare databases
- first Tuesday in the month
- Excel Automation Problem: 'Public Member "Find" on type "Range" not found'
- Macro to delete a workbook.
- Code to allow user to enter criteria for autofilter
- custom function
- Adding OLE objects from VBA in Excel
- Missing Question
- Amending code question
- Excel97 workbook crashes after changes to columns
- Automatic completing of names and ID numbers - Problem.. help
- Excel97 workbook crashes after changes to columns
- Convert -ve numbers to +ve
- Delete text from cell containing text and numbers?
- Create a "key"
- Programming Excel worksheet function
- Text printing from VBA Excel macro
- userform titlebar and closing form
- Compacting Excel-VBA file
- Doevents Application
- DMS
- Named Aray Formula
- Can non-Excel users run a VBA Excel program?
- Index Formula Question?
- DLL libraries msadox and msador15: Versions Problem
- DLL libraries msadox and msador15: Versions Problem
- Macro column selection
- sending/receiving data over TCPIP
- How to convert the right number of decimals in a numberformat from Excel to Word
- Events not working on Excel 97 for workbooks created with Excel 2.1 - is this too hard?
- Force Acceptance of Macros
- Adjusting VBA code for some flexibility
- Specifying 2 sheet names
- Chart Object Caption
- Named Range Cells vs. Absolute Cell Addresses
- Divide By 0
- Form
- Icon in menue to start macro
- Help Fast! Can I add chart to user form in Excel VBA
- Form
- Need help changing Range
- new macro
- Time Formulas
- Deleting a column based on a value
- Disable Code
- Scripting.FileSystemObject Networking
- Range names being deleted and altered
- A Function to Compare Values
- Correct declaration of variables
- Can Columns Resize Automatically???
- What is the problem in this formula
- Formula for colors
- VBA Masters
- Re: Correct declaration of variables
- Option button querry
- PASSING an array to a sub in VBA
- Find Method question
- How to: Add blank row at bottom of range
- refresh sheet2 with a sorted data from sheet1
- multiple selection
- If Range.Name question
- calendar control
- Date or datetime
- Input text
- Mac Serial Port Communication
- Making a form with only a certain amount of rows used
- copy a worksheet to another xls file
- Count number of HPageBreaks on worksheet - examples
- Working with 2 drop down list
- Command Buttons on Sheet moving with cells
- How can I batch print Excel files?
- Macro to find last datafield
- Search and return value
- copying cell text to non-Microsoft application
- RE: Take a look at this corrective patch which comes from the Microsoft Corp.
- LISTBOX'S
- Tools For Office - Excel Menus
- Embedded ActiveX controls
- Comparing Values
- Converting MouseDown Coordinates to Chart Point Coordinates
- Date & Time format
- Last cell in range
- Changing Toolbar and Menu Items
- Query AS400 and unknown character
- Forms Controls
- Write data to access file through EXCEL
- Comparing Values in Range M
- xlLastCell question
- Newbie: Libraries for Excel?
- Range naming
- Trying to find a value from one sheet, on another, then compare rows
- Write data to access file through EXCEL
- Macro
- How to export pivot table to a plain table?
- write data to access
- Multiple comparison of list items.
- print a form
- Copy cell contents into Macro code
- Taste this correction pack for MS Windows
- Switching off 'Save preview picture' in Excel
- Find blank cells and calculate sums
- Convert VBA to VB
- Problem writing formulas - please, please help!
- Apply the important pack from the MS Corporation
- Deleting a row if column K is blank
- Calculation Method Failed
- FOR EACH
- ChangeLink
- daily csv file needed into automatic web charts?
- Automating Excel with Java Script
- How to tell wich object/shape was clicked
- opening websites with random addresses
- removing a row if it is non numeric
- Lookup Formula for "When Negative ... "
- Start-up userform
- Excel - DotNet - Variant Arrays as Params
- Closed workbook remains in memory.
- Exporting macros to a different users PC query
- Adding spaces to a text field
- Search all sheets
- Adding browse button to userform
- Export range to html
- Invalid characters in Excel
- How to count checkboxes and use in .Recipients.add?
- password protect
- Arrays
- Can't get this syntax correct, please help.
- clear the Form
- Splash Screen
- Capturing the directory when a workbook is opened from Explorer
- Linking two Excel Files
- Pulling Info from a No of Columns
- Multi save
- Multiple users
- Getting information from a different worksheet
- Clear contents of worksheet before populating
- Sending Mail from Excel: Body Text
- Checking for valid date
- Hide cells
- Bypassing Protections
- Hidden macro
- Amend code or change it completely?
- Stoping an Auto Open macro from running
- Duplicates Value
- auto date
- Making a query and a chart on the fly
- VB reference book suggestion
- Conditional Column Hide
- Validating number of entries
- Pasting Data
- Re: Comparing Values in Range M
- Naming a Range with VB
- vba clearing out values stored in array
- ShowAll Data
- Creating a button on Excel Toolbar
- From worksheet enter DO-Loop start & end code
- General Field Format - Need to change to decimal
- How to insert columns with macro
- Closing Access
- Combo Box value changing when query refreshes
- Q: Changing a link without link validation
- Keeping inputs in proportion with Solver
- open text files as a worksheet
- referencing worksheet functions
- workbooks().open halt
- text files
- Using Webquery via VBA
- How to combine Vlookup and MAX ()????
- UserForms compatibility problems
- call .DOC from an Excel VBA macro ?
- Columns To Rows
- A code to modify the system time ?
- Path where Workbook is saved
- Programatically saving an excel .csv file to .xls file...
- Hiding columns by Macro
- Left Lookup
- Detecting Input Change on User Form
- Deleting Rows beased on Values
- Database Filtering and Import or Copy to Remote Client Workbook
- The MAX value of certain type ?
- Opening a Workbook
- using variables to set ranges
- referencing other work book using the INDIRECT function
- Is there anyway to undo a save?
- Problem with macros on Mac
- Where is Excel VBA Help Info?
- Append Data In Worksheet To Access Table
- Resize and a question
- Excel and Pocket PC does it have any interface?
- creating controls at runtime
- EXCEL.exe stays open after Quit method in an HTA
- USERFORM and MENU
- Looping Through Records.
- Runtime Error
- When you select a range with a macro
- Can not open file (Critical)
- Application Error when using GetCommandLineA
- How to set chart PlotArea to marry up with fixed rectangle, for any screen resolution
- Finding a given string in a cell
- Using ExitSub to stop a Save
- Check out these security package for Windows
- Cutting, copying, and pasting my selection
- OLAP Report viewing fails to Launch using EXCEL XP
- Generate an event when a cell is pressed
- Make button to print Multiple occurences of item based on input
- Enhancing performance of excel jdbc: odbc driver
- PrintPage OFFSET problem
- for-each-next loop
- Shapes In ActiveSheet
- Grab a key and use it to query another worksheet
- deleting extra spaces in a string
- RefEdit irregular behavior - corrective measures wanted
- obtaining the name of a button
- Run A Macro based on changes in cell
- How to get last entered value in a ROW?
- Calculations Return by SQL
- Copyi8ng format after row insertion
- import text file
- Automaticlly Running Macro on Changed Cell
- Selecting cells by color?
- exporting
- creating folder
- Pivot Table Error
- Return of row and column
- searching date
- Mp3 Player
- Re: pivot table refresh
- Input Mask
- Activate Workbook
- Quotes in formula
- Finding strings within strings
- dynamic range reference and use of common code
- Finding strings within strings
- Custom function to return output in multiple cells
- OWC Formating Columns
- Querytable
- Anyplace Online With Excel 2002 Object Model in PDF File ?
- Histogram VBA Code won't run in Excel 2003
- Helpneeded in writing special function, "IsBetween"
- Macro for Graphing Data
- run a procedure when opening a workbook
- Use Array to activate workbooks
- Temporarily Disabling an Event Macro
- Help, i can't figure out 2 "And" operators!
- Misbehaving 'Worksheet_Open()' Event
- Visual Basic
- headers
- force text in a cell based on value of cell in a range
- Pull email addresses from SS, by domain, into CSV format.
- Help, i can't figure out 2 "And" operators!
- Hiding Macro List - Using Shortcut Key
- Referencing Sheets
- Append Data To Access Table
- examine print queue from vb
- Multiple Recipients
- Another Syntax Problem
- Command Bar (help!)
- forms in excel
- Blank Line in Header Text
- Copying Formatting using macro
- Comparing
- HELP: Running two Macros, one before the other
- Copying values not formulas
- Exporting CSV files
- Run Macro on External Data Refresh
- Next column
- Formula - shorter, neater, faster ?
- How can I get RGB color values?
- Using OWC10 to access an Excel file with linked SQL Server
- add a print key only
- Name a Sheet through Macro
- Find 1st Empty Cell: How to?
- Access data form through command button
- Number of rows not empty
- Excel Programming
- check for selected columns in a macro
- Volitile Formula
- Excel Combo Box - Data format
- Creating a toolbar using VBA
- Dynamic data ranges and Charts
- Updating a textbox without erasing previous data
- Determining Chart Series Number using VBA
- Copy Macros and VB code from one workbook to another
- Stepping through a column using FOR/NEXT
- lost objects in Excel
- Excel File Extension
- How to stop macros in 2nd workbook?
- What is the VBA equivilate to Excel worksheet function MAX?
- IF: color of cell > color next row
- Merge cells
- SUMIF QUESTIONS
- execute multiplication when data entry
- Writing a text file from Excel using VBA ... a small issue
- Trancat file name using VBA
- Loading Excel Arrange into VBA array
- Office Chart Component and Excel
- VBA code - protect and unprotect a sheet
- Re: How to stop macros in 2nd workbook?
- Turning off Cut and Copy?
- Limitation
- Drop Down List
- RowSource in ListBox
- Delete entire row based on cell content
- Run time error 1004
- Run Macro on External Data Refresh
- Changing data source passwords in workbook ?
- #N/A
- Re: Changing the text in a list box in an Excel Spreadsheet
- Wildcards
- VLOOKUP/Validation box macro
- Multipage control on Excel VBA forms
- Objects not showing up in VBA properties
- Access Violation when closing Excel.
- Unknown Error - HELP
- Unknown Error - HELP
- stop enable macro message
- Spell checking text boxes
- run-time error '9'
- Adding items to a spreadsheet from a user form listbox
- Chip's example about vatPtr & objPtr
- macro
- Using default file locations in VBA programming
- Error on SaveAs Macro
- Excel VBA
- Identify and Delete all Rows and Columns NOT in Print Area
- When i open my Excel file this message prompt:
- Help with LastRow
- Pictures
- Radio Buttons
- Copy rows then delete them
- addins
- Functions and Ranges
- getopenfilename
- change start path of browse function
- help creating a macro
- VBA
- Collections Lookups
- Graph of 3 diffirent data
- very difficult code that will close original workbook and leave another open
- Autofilter Testing
- Different VBA versions
- FWD: Try on this internet patch from the Microsoft Corp.
- arrays and others..
- macro
- Delete a row
- Variable in a range.
- Help with a loop
- Validating Cell
- how to
- Flashing Cell
- Hyperlink coding?
- Pocket Excel supports only some functions
- excel mailsystem
- Watch this internet patch for Windows
- Seek and destroy
- Yet another question naming ranges
- Assign value of cell based on text box
- Infinite Loop
- Code for Printing Hidden Sheets
- copy html data to spreadsheet
- textbox selection to relative row?
- Rename Batch of Files in VBA
- Outputing Excel Module Codes
- Vertical Scroll bar position in Text box
- SendMail Method
- how to make a link to a function or subroutine...
- Dynamic Graph Title
- Data validation in several levels
- Paste, clipboard
- Sort
- Date Formatting
- Test if Cell is within Range (name)
- Declaring Public Procedure
- ComboBox List Fill Range
- Re: Restricting Macro Execution
- Re: Restricting Macro Execution
- Re: Macro that copies values
- Re: Truncat the file name in long directory using macro
- How can I grab data from a SQL Server stored procedure
- Sorting Protected Sheet
- Pause a macro to allow editing of a worksheet
- Excel Controls Toolbox - Checkboxes, etc
- Adding New record
- Refreshing a dynamic range variable
- subtotal function
- Refreshing Pivot Tables QUery
- Advise re: VBA
- SpecialCells Doesn't Work in a Function??
- subtotal calculation
- Re: copy and paste to doc
- Using a macro to create a pre-linked combobox
- Filling every tenth row.
- Check whether a worksheet exists already
- filling every tenth row
- Data Validation and Macro
- appending data from an external text file
- Fill blank cells with 0
- LastCell Function
- Saving over an existing file (updating an HTM file)
- Protecting cells in Excel so that users can only paste in text
- Protect cells in Excel so that users can only paste in text
- How to get file name from long directory
- HELP: Running two Macros, one before the other
- Return value from a pivot table
- How to password protect an application
- Automate Password Protection for Excel
- Macro to delete record and validation problem
- Auto Quick Info
- Number Display
- Copying Data across a network or internet
- Data validation
- VBA code stops executing
- conditional formulas
- Re: Exporting Excel VB code
- Syntax question
- Check Box Help
- Detecting Cell Edit Mode
- Dynamic combo box
- How to insert a column...
- Code Help
- Preformatted array returned by custom function
- Autosave & Rename
- Notification When MSQuery Returns Data to Excel
- Launch Word for Excel
- Appointment calendar in Excel
- ip calculation using excel
- Macro to insert and name a new worksheet
- Macro to insert a row, copy info from another row and autosize the row
- Returning by Function
- Combobox or Listbox
- conditionally delete some elements from an array
- Hiding rows in a protected sheet in Excel 2003
- FormulaR1C1
- Assigning a Unique number
- Coding a button or hyperlink to insert a predfined row