- Hiding Macro List - Using Shortcut Key
- Help, i can't figure out 2 "And" operators!
- Pull email addresses from SS, by domain, into CSV format.
- force text in a cell based on value of cell in a range
- headers
- Visual Basic
- Misbehaving 'Worksheet_Open()' Event
- Help, i can't figure out 2 "And" operators!
- Temporarily Disabling an Event Macro
- Use Array to activate workbooks
- run a procedure when opening a workbook
- Macro for Graphing Data
- Helpneeded in writing special function, "IsBetween"
- Histogram VBA Code won't run in Excel 2003
- Anyplace Online With Excel 2002 Object Model in PDF File ?
- Querytable
- OWC Formating Columns
- Custom function to return output in multiple cells
- Finding strings within strings
- dynamic range reference and use of common code
- Finding strings within strings
- Quotes in formula
- Activate Workbook
- Input Mask
- Re: pivot table refresh
- Mp3 Player
- searching date
- Return of row and column
- Pivot Table Error
- creating folder
- exporting
- Selecting cells by color?
- Automaticlly Running Macro on Changed Cell
- import text file
- Copyi8ng format after row insertion
- Calculations Return by SQL
- How to get last entered value in a ROW?
- Run A Macro based on changes in cell
- obtaining the name of a button
- RefEdit irregular behavior - corrective measures wanted
- deleting extra spaces in a string
- Grab a key and use it to query another worksheet
- Shapes In ActiveSheet
- for-each-next loop
- PrintPage OFFSET problem
- Enhancing performance of excel jdbc: odbc driver
- Make button to print Multiple occurences of item based on input
- Generate an event when a cell is pressed
- OLAP Report viewing fails to Launch using EXCEL XP
- Cutting, copying, and pasting my selection
- Using ExitSub to stop a Save
- Finding a given string in a cell
- How to set chart PlotArea to marry up with fixed rectangle, for any screen resolution
- Application Error when using GetCommandLineA
- Can not open file (Critical)
- When you select a range with a macro
- Runtime Error
- Looping Through Records.
- USERFORM and MENU
- EXCEL.exe stays open after Quit method in an HTA
- creating controls at runtime
- Excel and Pocket PC does it have any interface?
- Resize and a question
- Append Data In Worksheet To Access Table
- Where is Excel VBA Help Info?
- Problem with macros on Mac
- Is there anyway to undo a save?
- referencing other work book using the INDIRECT function
- using variables to set ranges
- Opening a Workbook
- The MAX value of certain type ?
- Database Filtering and Import or Copy to Remote Client Workbook
- Deleting Rows beased on Values
- Detecting Input Change on User Form
- Left Lookup
- Hiding columns by Macro
- Programatically saving an excel .csv file to .xls file...
- Path where Workbook is saved
- A code to modify the system time ?
- Columns To Rows
- call .DOC from an Excel VBA macro ?
- UserForms compatibility problems
- How to combine Vlookup and MAX ()????
- Using Webquery via VBA
- text files
- workbooks().open halt
- referencing worksheet functions
- open text files as a worksheet
- Keeping inputs in proportion with Solver
- Q: Changing a link without link validation
- Combo Box value changing when query refreshes
- Closing Access
- How to insert columns with macro
- General Field Format - Need to change to decimal
- From worksheet enter DO-Loop start & end code
- Creating a button on Excel Toolbar
- ShowAll Data
- vba clearing out values stored in array
- Naming a Range with VB
- Re: Comparing Values in Range M
- Pasting Data
- Validating number of entries
- Conditional Column Hide
- VB reference book suggestion
- Making a query and a chart on the fly
- auto date
- Duplicates Value
- Stoping an Auto Open macro from running
- Amend code or change it completely?
- Hidden macro
- Bypassing Protections
- Hide cells
- Checking for valid date
- Sending Mail from Excel: Body Text
- Clear contents of worksheet before populating
- Getting information from a different worksheet
- Multiple users
- Multi save
- Pulling Info from a No of Columns
- Linking two Excel Files
- Capturing the directory when a workbook is opened from Explorer
- Splash Screen
- clear the Form
- Can't get this syntax correct, please help.
- Arrays
- password protect
- How to count checkboxes and use in .Recipients.add?
- Invalid characters in Excel
- Export range to html
- Adding browse button to userform
- Search all sheets
- Adding spaces to a text field
- Exporting macros to a different users PC query
- Closed workbook remains in memory.
- Excel - DotNet - Variant Arrays as Params
- Start-up userform
- Lookup Formula for "When Negative ... "
- removing a row if it is non numeric
- opening websites with random addresses
- Automating Excel with Java Script
- daily csv file needed into automatic web charts?
- How to tell wich object/shape was clicked
- ChangeLink
- FOR EACH
- Calculation Method Failed
- Deleting a row if column K is blank
- Problem writing formulas - please, please help!
- Convert VBA to VB
- Find blank cells and calculate sums
- Switching off 'Save preview picture' in Excel
- Copy cell contents into Macro code
- print a form
- Multiple comparison of list items.
- write data to access
- How to export pivot table to a plain table?
- Macro
- Write data to access file through EXCEL
- Trying to find a value from one sheet, on another, then compare rows
- Range naming
- Newbie: Libraries for Excel?
- xlLastCell question
- Comparing Values in Range M
- Write data to access file through EXCEL
- Forms Controls
- Query AS400 and unknown character
- Changing Toolbar and Menu Items
- Last cell in range
- Date & Time format
- Converting MouseDown Coordinates to Chart Point Coordinates
- Comparing Values
- Embedded ActiveX controls
- Tools For Office - Excel Menus
- LISTBOX'S
- copying cell text to non-Microsoft application
- Search and return value
- Macro to find last datafield
- How can I batch print Excel files?
- Command Buttons on Sheet moving with cells
- Working with 2 drop down list
- Count number of HPageBreaks on worksheet - examples
- copy a worksheet to another xls file
- Making a form with only a certain amount of rows used
- Mac Serial Port Communication
- Input text
- Date or datetime
- calendar control
- If Range.Name question
- multiple selection
- refresh sheet2 with a sorted data from sheet1
- How to: Add blank row at bottom of range
- Find Method question
- PASSING an array to a sub in VBA
- Option button querry
- Re: Correct declaration of variables
- VBA Masters
- Formula for colors
- What is the problem in this formula
- Can Columns Resize Automatically???
- Correct declaration of variables
- A Function to Compare Values
- Range names being deleted and altered
- Scripting.FileSystemObject Networking
- Disable Code
- Deleting a column based on a value
- Time Formulas
- new macro
- Need help changing Range
- Form
- Help Fast! Can I add chart to user form in Excel VBA
- Icon in menue to start macro
- Form
- Divide By 0
- Named Range Cells vs. Absolute Cell Addresses
- Chart Object Caption
- Specifying 2 sheet names
- Adjusting VBA code for some flexibility
- Force Acceptance of Macros
- Events not working on Excel 97 for workbooks created with Excel 2.1 - is this too hard?
- How to convert the right number of decimals in a numberformat from Excel to Word
- sending/receiving data over TCPIP
- Macro column selection
- DLL libraries msadox and msador15: Versions Problem
- DLL libraries msadox and msador15: Versions Problem
- Index Formula Question?
- Can non-Excel users run a VBA Excel program?
- Named Aray Formula
- DMS
- Doevents Application
- Compacting Excel-VBA file
- userform titlebar and closing form
- Text printing from VBA Excel macro
- Programming Excel worksheet function
- Create a "key"
- Delete text from cell containing text and numbers?
- Convert -ve numbers to +ve
- Excel97 workbook crashes after changes to columns
- Automatic completing of names and ID numbers - Problem.. help
- Excel97 workbook crashes after changes to columns
- Amending code question
- Missing Question
- Adding OLE objects from VBA in Excel
- custom function
- Code to allow user to enter criteria for autofilter
- Macro to delete a workbook.
- Excel Automation Problem: 'Public Member "Find" on type "Range" not found'
- first Tuesday in the month
- Compare databases
- comments AutoSize
- How to pass value in cell between workbooks ?
- Oracle Date format
- How to make the invoice number increase
- Calculating date overlapping
- myMenul.Caption = "P&L Report"
- Macro works from RUN but not from shortcut
- Automation with Delphi
- How to disable a macro
- MISSING:shappmgrp 1.0 Type Library
- Formula to macro...anyone??
- Can error 1004 be trapped????
- Worksheet_calc
- Using variables to select a range
- COMPUTE CHANGE IN PRICE BETWEEN CELLS IN A ROW
- Can't quite get this syntax to bring in the required information.
- Mask input in input boxes?
- buttons???
- Easy Value listing code
- Path Not Found
- Returning value of a cell containing a formula
- Inputbox Cancellation
- Enum BrowseForFolderFlags
- autorun a macro
- Inserting value at end of range
- buttons???
- find and copy
- Multiple Filter in VBA
- Snailspace Macro Needs Rejuvenation....Anyone?
- manipulating the built-in Data Form
- userform with date searching in worksheet
- Best book to learn excel?
- Events not loading in Excel98 for workbooks created in Excel 2.1
- Problem getting excel to work in Visual Studio (C#)
- How to cause userform to display
- Userform to select start date and end date
- ON ERROR RESUME NEXT
- Conditionally clearing a cell
- Calculating and re-calculation a matrix of 100 numbers in Excel
- Web Query and Line Break <BR> tags
- App events behaving differently in diff. versions
- run-time error
- Scrollbar
- PrintOut with Adobe Acrobat 6.0
- Why does this work and not work
- On Error Resume Next
- delete an excel file
- "Find" question
- Probably a stupid question..but Im just starting out
- renaming sheets
- Empty Modules
- Inserting a Row with VBA - reply
- ListBox
- Using linked workbook as a parameter in a user defined function
- Modulus and the Mod function
- Extracting data from a single cell
- Help with user function please
- deleting rows in excel
- Remove Close Icon ?
- Newbie
- conditional printing
- Confirm Open After Download - Reading Registry
- Why some forms not available?
- group name for form controls
- checking errors in the formulas
- making macro resident in memory
- CommandBars("Insert").Enabled question
- classification in column
- Inserting a Row with VBA
- Checking values already in combo boxes
- Autofill userform textbox
- Testing a cell
- PivotTables, Page Fields & VBA
- MISSING: shappmgrp 1.0 Type Library
- Very basic macro question.
- How to pass value between workbooks ?
- Any Development environment for Office 2002/2003
- test_for_xmas_day - i think there must be a better way
- Worksheets in alphabetical order
- Hpagebreak help needed please
- why does't this work? (chart in excel)
- How can I copy formatted text from an Excel textbox into an IE .htm document ?
- Replace cell of column with cell of other workbook
- Code for printing footers
- Creating a loop from my code
- Cancelling the BeforeClose Event
- Userform and controls locked property
- Match Function(Code modification)
- listbox.row source
- Remove default formating and extra data
- Holiday Formula for an Employee time sheet
- Columns To Rows On Another WorkSheet
- Reload Typelibrary? .Remove() & .AddFromFile() fails
- file information
- Deleting Rows
- Find Replace
- Help with text box limit (1024)
- Re: Passing data back from a form
- Precedent/Dependent in VB
- data into an array
- comparing data and write values if true
- Excel and the Serial Port
- my big chalenge - import acces data in excel
- Query Table Problem
- Ping anybody
- Modifying Code that deletes a Row
- Dialog Sheet not updating
- Trapping Events generated by a Worksheet
- selecting sheets
- Text box in form truncates information. Please help
- formula help
- Programiclly copying worksheet to another workbook
- Worksheet codename
- validate data using code
- Help with some sheet code
- Using app events to trap workbooks opening.
- How can I list the results of my macro without overwritng previous results?
- ROWS() returns 1?
- Clicking 'Cancel' on an Input box
- Formula
- Aircraft Scheduling Problem>> VBA code needs adjustment.
- Disabling messages from Project
- Simple VBA spreadsheet within Frontpage
- Inserting Date In Filename Using Macro
- Userforms.....
- conditional formatting with a twist!!
- Conditional Formating with VBA help needed
- Setup Userform
- Setup Userform
- when a Find statement is successful
- Inserting specific data into moving cells
- Setting list box contents
- Checking for invalid dates
- Count the number of just the horizontal manual page breaks
- closing workbook
- Creating Listbox
- HPageBreak dosen't f...... work
- view comments in cell
- copying ranges etc
- For next
- Global Variables Not Accessible
- Re: Formatting Cells Dependent on Contents
- Limiting values in comboboxes.
- Newbie needs help
- FileSearch Problem
- Formatting Cells Dependent on Contents
- Re: Formatting Cells Dependent on Contents
- Re: How To: Get Last Cell
- How To: Get Last Cell
- Net send
- Cells V Range
- Text format alignment problem
- Very simple Select problem?
- Multipage Object on User Form
- Select Case Picking up number
- Bypass macros in Read only
- regarding Excel 97 to XP migration / conversion??
- Using enumeration with controls
- Is workbook open anywhere in network?
- Hi there...
- Correct syntax for use Replace command via DDE?
- Is this possible?
- How To: Check if a cell value has changed
- SolverParameters behaviour different in VBA and Excel?
- Function parameter description
- Sumproduct error
- Converting figures into words In Excel
- Re: Formula needs tweaking - HELP!!
- autocreate chart
- How can I build a Excel Function that acts like those built-in
- Sort Code Modification
- Keeping Linked Info When Tabs are Renamed
- Formatted printing
- Extracting records that meet multiple criteria
- Formatting Cells that contain Matches to Data in a List
- Combining Modules
- Re: Me have deceived
- excel 5 dialog sheets
- How to hide Excel's Top Menu Bar
- Can I program a userform via spreadsheet?
- Can worksheet data be exported/imported to/from flat file?
- Storing Variables
- Determining active conditional format of one cell
- Macros in this project are disabled
- Custom MsgBox using values from 2 different cells
- Forms
- Scrollbar updating
- Avoid "...contains one or more links that cannot be updated" message.
- Inserting TextBox1 Value into Conditional Column/Row4
- Worksheet.Protect Question
- User form question
- Create worksheet index
- Refedit question.
- Error 91 - Object variable with block variable not set
- is it possible to jump to the souce of link in sheet with mosue click??
- How to refer a Variable across Workbooks ?
- comboBox
- inputbox
- Excel runs slowly in the background
- If then MsgBox
- Best place to declare variables
- Is Excel Typlib backwards compatible?
- Highlighting Textbox1 Value when form initializes.
- replace line of code in vba protected project
- Excel Logic needs a Doctor !! FORMULA FIX DESIRED!!
- How to group or organize dozens of macros?
- I'm sure this is easy but i can't do it...
- advanced filter
- Txt Import problems.....
- MS Query - DB connection
- Variable produces a complie error
- Re: Clearing clipboard
- XP is deleting Forms
- Disable Prompts
- Message Box
- Req Help: A slight variation on the auto_open theme.
- Data validation code
- Re: Clearing clipboard
- Very basic question... I MUST be having a brain fart....
- Hiding Sheets
- Auto accept a value in a cell
- Printers & LPT
- Excel 97 VBA: tracing a run time error
- Deleting Workbook
- Cannot use range objects
- Controlling and setting images
- Excel 2003 VBA Help not working when automating via VB 6
- Individual point standard error bars on chart
- VBA code for Userform
- Allow user-entered file reference
- Inserting & Deleting rows can take ages in Excel 2000
- Tricky Graph Question
- Exercises and tutorials
- Excel Reporting (Graphs - Generating)
- ADO, VBA and SQL
- Problem opening .htm file from Excel 2000
- deleting objects using VBA
- named range not specific to worksheet
- Use Current directory to store file
- Macro that will autofill a column with data, up to the last row of data in previous c
- VBA in 97 vs. 2002
- #Holding values in different format#
- Display Current File Name in MsgBox
- VBA filesavename
- Array of page ranges
- vba...finding location of number
- Page set-up when selecting multiple sheets
- bitmap for buttons
- Loop through checkBox on worksheet
- VBA Speed question
- bitmap for buttons
- Create dynamic variable names?
- Replacing Carriage Returns
- find files and copy to new directory
- Two cells into one
- Two cells into one
- mail workbook
- RefEdit - cannot select range on another workbook
- Changing Calculation Method
- Userform Textbox - Date Problem
- Saving in Excel 97 a workbook developed in Excel 2002
- RTD Callback and CIS with firewall
- Date Reference in VBA
- Look up Headache
- Help menu in Microsoft Visual Basic
- Calling objects
- linerar/integer programming problem
- vba code problem
- using date ranges in a pivot table
- Personale Number Rounding!!!!!
- detecting a vertical page break
- SaveAs didn't work in VB protected mode
- counting rows to an empty cell and making a chart
- Extract name, dates & number as criteria Then paste to current file
- Converting time to numeric number
- Write data to access file through EXCEL
- access the solver reference library
- List Boxes (Help!)
- Reading .csv file into array
- System Resources
- Autofilling a formula to a variable last cell
- VBA code to save gives error 1004???
- Search or FIND on a userform.
- Reclaiming VBA Code in a corrupted file
- simple conditional find, copy and paste
- array of rows
- Need help on Logical Statements
- protecting cells with macros
- Save excel file with filename = cell text
- Run Macro from another X number of times
- Text Import & Current Range problem.....
- Variable Array Problem
- range.address ?
- invalid picture file
- Adding Records to Access Table
- Need suggestion for multiple messages
- how to programmingly insert a new row in excel sheet?(using VB code)
- Email Workbook
- Change sheet reference in formula?
- Excel 2003 Split cells
- Disable app window controls
- vblookup and type mismatch
- Learning resource for VBA
- unlock project with VBA code
- Format dates
- changing case
- Data validation using code
- selecting a range from a list
- Need help with two Execl VBA problems
- Show Grid lines
- Removing the little Excel icon in left corner
- letter salutations and envl. address.
- Macro to copy formula on worksheet close
- How to run a excel macro from SQL
- How would I convert the following into a excel sheet?
- AddIn Project for Excel
- Find in Excel VBA
- Compare and identify new data
- Open Dialogue Box to a certain folder?????
- Excel XP removes AS part of statement
- Sorting Names
- always trust macros from this source - is disabled. Why?
- Combobox not writing value if next selection is same
- Comment Box Sizing
- easy combo box question
- Rankings within a database
- listbox please help
- *Easy* question this time!
- Tooltip on lineshape
- Embedding command buttons in cells
- Check calculation status
- opening text file triggers vb error
- Display message in macro
- Using Userform object in Excel via automation from VB 6
- Hide macros executions
- Hide macros executions
- Hide macros executions
- Warning Statement to Delete Macro
- specify an input directory with GetOpenFilename
- Worksheet Object Name
- how to find out if text in the Excel cell will be trancated?
- Application Calculation Error
- Mouse Scrolling in VBA Module
- How do I run an external program?
- How to create date format in vba
- Application.FindFile
- How to Create a Document and Save it from a WinForm
- Linked worksheets-Help
- Missing References between Excel Versions
- Need help with IF statement ! ! !
- zoom to a range of cells.
- Passing variables from module to userform
- Disable the opening of another workbook
- VBA - Normal project file
- Searching for data on seperate worksheet
- Protect Code
- why doesnt it do what I want? (lol)
- How do I Freeze information to keep from updating
- 100 x hundred
- Selecting a certain cell
- using xlColumnField
- Survey Forms and Excel
- Turning Calcuation Off Completely
- Notes and Closures
- Re: delays in macros
- find in closed workbook
- Correcting #NAME errors
- Selection from list with worksheet names
- Close routine
- closing a file without saving
- delays in macros
- Excel Global Variable Setting
- Excel macros
- Simple question
- TRICKY ONE FOR YOU CODEMASTERS!!!
- listbox value not initialized
- Run-time error '1004' - Unable to set the Visible property of the Worksheet class
- timed macro
- Help!!-combobox with Text
- button to call website
- Progress Bar Help
- input(1m#1) strips the null characters
- help!!
- Open a file
- Using drop-down list in Excel 2003
- Licensing policy for Office Web components
- autofill values
- Newbie question on deleting duplicate rows
- multiple search criteria to find and copy from sheet1 and paste into sheet2
- Another loop & sheet question
- Read security level
- Underscore character _
- Crash on save
- How to shift address info. from rows to columns?
- Loop worksheets
- ATTN: KEEPITCOOL
- Button Enabling based on check in checkbox
- Compile Error, Can'f Find Project or Library
- Conditional Button Enabling based on Checkbox
- Return the column of the next empty cell
- Semi-log graph?
- Algorithim to generate/check valid serial keys
- Strange Module line
- how do I stop the find at the end of the sheet
- is this formula possible in excel?
- Control tip text - can you have a new line?
- error trapping
- Naming objects on creation
- Change a date in text format xx.xx.20xx to a recognised date format
- VBA generated command buttons
- beginner text box question
- Updating sheets to include new data beside old data
- Project Window
- Need help with sorting, please.
- Close and save macro
- Excel VBA and XML
- mail merge
- Getting list of open workbooks
- Last cell within an address
- Converting a string date into a Excel Date
- Adding items to the second column of a list box
- Array Help
- Calculation
- Hide Columns That Contain Checkboxes
- option groups, formatting
- How do I?
- Limit a macro
- scroll bar
- scroll bar
- MAPI create object error
- VB String Comparison In Excel
- Searching Columns
- Public Function IsStrikeThrough(rng As Range)
- VB Find
- In VB, get Auto Filter Range
- Format row based on cell value
- Remove Formatting Apostrophe
- save command bar into an excel workbook using vb
- Fillright
- Control Excel
- Simple Variable Question
- Portability of early bound code - clarification
- Starting Excel
- I am a little confused with the VLOOKUP results I am getting....
- finding cell info to rename sheet(s)?
- Help : Code for selection non-contiguous cells
- Copy ranges (columns) instead of whole row
- Problems with Match function
- Read a single column text file
- VLOOKUP Problem
- Copying a sheet to new work sheet
- dynamic arrays as an argument/result in programmed functions
- Insert Page break in Word
- Passing data back from a form
- Re: Passing data back from a form
- Updating (Adding Rows) To A Second Worksheet
- Calculating # Days in a Date Range
- Validation from a list
- Re: Create controls dynamically
- Re: breakup spreadsheets
- breakup spreadsheets
- Formula Explanation
- excel VBA or VB6 -which one
- Making a macro run when the user closes a workbook
- Re: Making a macro run when the user closes a workbook
- Re:
- vba gridlinecolorindex question
- Seperate columns with a tab??
- many workbooks in one.
- Re: Turning macros into executable code
- Import output from mailmerge
- Reading Userforms
- What is the easiest way to setup a 'global' macro which is always available to Excel on a PC?
- Currency
- Importing Access Data and formatting it in Excel....!
- PivotTable DefaultVersion
- I post the same subject.please help me on this
- Inputbox or UserForm
- File directory into a listbox
- Excel 2003 VBA Help for TRanspose is missing
- Deleting name-objects
- ListBox array
- Checking database field
- VBA function returning the value EMPTY
- First four columns lose formatting when DAO macro is run
- conditioning 'find'
- Sort cell values
- Scope of a public variable
- time indication bar
- Pictures in file
- Delete worksheets
- Prevent Users from switching worksheet
- Maybe a little off topic
- Calculating total days from 2 dates
- printform vba
- Validation from a list
- vba problem
- CDO email questions
- error message
- Automation SaveAs HTML
- Help with text box and time
- Autofill months in cell
- Procedure kills copy and paste