- Simple question - Named Range in Macro
- DMEDIAN
- Pasting problem
- Load Sheet2 on Startup??
- Find intersection point using lables?
- Remove a character from a column
- Re: Excel Headers & Footers
- XLDialog Printer Setup
- Help with a formula
- Object Library Not Registered
- Array Sorting in VB
- Clipboard Message
- Is there anyone out there that can help me?
- Distributing Workbook
- Need Help writing a macro
- Missing Project or Library
- Selecting a worksheet in a workbook
- Are there any dangers in adding a lot of "comments" to a workbook?
- Combination Numbers between 000 and 999
- Application.Filesearch yields incorrect results??
- If "text" exists in COL A, keep (quick one)
- automatic data fill , based on list into dynamic range
- AutoSave code problem
- multicolumn listbox move or value set
- Increment column in loop
- Paste literal text
- me.printform
- Re: Adding to the SeriesCollection of a chart object in VB6
- Does this make sense?
- Formatting a new seriescollection in a chart object
- Excel to Word
- Auto-Subtotal
- macro using PROPER function
- Can Excel download files?
- Re: switch applications?
- Deleting or Hiding Rows
- Re: common subroutines - add-in
- Formatting a column - needs refresh?
- how to hide a chart series or make it invisible
- Difference between .Activate and .Select
- Re: ListBox Question
- Re: Macro Find
- Subtotalling a column of data?
- Legends in a pie chart in excel 2000
- Re: Can I use Environment variables (such as %USERPROFILE%) in Excel .
- Unable to get macro hotkey to work
- Selecting workbook
- Run Macro when loading addin
- Forcing charts with common columns to display colors consistantly
- Excel 2003 text file generation slow
- Re: Copy and Paste (Tom already in disscussion - more help needed)
- Printer Selection Box
- Creating a multi-user spreadsheet
- Get filename
- extracting parameters from formula
- Count from Input box
- Input box doesn't return sheet name with range
- Re: saving with VBA
- Re: PC Spreadsheet not working on MAC
- Excel VBA Autofilter on dates not operating correctly
- hightlight table or create borders
- Re: File_Save
- Re: File-Save
- Filtering of data using frequency filters
- Excel VBA - Delete cell to right of cell
- SQL - TOP 1 Usage
- Assigning data source to chart
- NEGATIVE HOURS
- misc ?'s about creating forms
- DDE limitation?
- Selecting ranges
- conditional match function
- UserForm implementation
- Mail shot
- OptionButton selection dilema
- macro which import alfa*.txt file, how to ?
- Chart Placement
- Display an Alert popup.
- MsgBox commands
- How to show unicode String ?
- Need help : Open a csv file with semicolon separation
- Date formating problem
- listbox listindex problem
- "Transpose" Macro.
- Creating Access DB
- Increment final value in for statement
- conditional formatting
- Autofilter with Range problem
- column value
- Conditional formatting
- Autofilter with Sum
- Assigning PRINT AREAS and no. of PAGES to PRINT
- Find last column with data
- Check null for range objects
- copy and paste table in another existing worksheet
- Open file with file name from cell
- How to create a shortcut key to access buttons in excel forms
- VBA Code for selecting days
- Assigning range names to arrays
- Re: updating charts
- Macro/Function to delete.........
- Security Code
- Copying and Pasting in a different worksheet (Urgent)
- VBA Cut and Paste Help
- Re: Print Userform Landscape - VBA
- Re: Creating a header with non-contiguous rows
- How do I get this VB Call to work?
- Problem with Help file in VBE
- Status Bar and Column/Row Headings Help
- strange error message following INSERT INTO statement
- Test for exact match in string
- How to reference # of copies in print menu?
- Error 91, Object var or With block not set
- Two Questions
- Drop down lists
- Can you make a cell on a certain page constant on all pages?
- Preventing User Access to VB code
- expandable listbox
- Identify CD-Rom drive
- Eliminating Duplicates
- Closing
- Re: finding the last column and referencing it by letter
- Vba - generating button into worksheet
- Auto close excel without saving
- My program uses up resources
- Moving VBA scripts to new workbook
- Stupid End(xlup) problem
- Code is not working....please take a look!!!
- creating a drop down list
- GETTING THE NUMBERS TO POST ONTO THE NEXT LINE
- Toolbars
- Modifying FindNext and Copy Code
- Run Macro w/o Opening Excel
- Array question
- Re: Macro to find name of sheet tabs
- Merging two or more workbooks
- SHDocVw.InternetExplorer
- Sheet Group & Formating in VBA
- Passing Variables
- Problem with format()
- loop through form objects
- Get table names from access through vba in excel
- Can I Group Form Check Boxes?
- Moving objects on a form
- An efficient find function
- Picking the latest entries from a column
- Deleting Duplicate Rows
- Is it possible to teach ones self VBA?
- Re: Only allow certain users access to specific sheets within a workbo
- Validatio Problem
- Re: FindNext and Copy Help (Urgent)
- How to paste cells from Excel into Outlook email body?
- Highlighting cells with vba function
- Save problem
- Open all files in a folder
- Re: FindNext and Copy Help (Urgent)
- Running Code From Controls On Other Forms
- recovering linked values in macro
- For Each Next
- Re: Virtual Memory Error when running Excel
- Re: Hide VB Source Code
- VBA - Flexible Sort Macro
- Inserting Rows Macro -- please help!!
- Togglebutton with the triplestate turned to True
- Saving Range of Cells as Image File
- Macro for Custom view
- Invalid Use of Null
- textbox & tab
- Web query & Passwords & Java & HTML
- Re: Personal xls will not open automatically
- combination of numbers
- Auto New macros?
- How can i get the value of the AsktoUpdatelinks form ??
- Create Barcodes in EXCEL 2003?
- Need Comments on Code
- If statement in VBA
- Range.calculate debug, Excel 2000 VBA compatability with Excel XP
- Sheet properties
- Worksheet Function using VB code
- Command Bars
- Starting Easy
- Extra feauture to the following code
- I have a Function Call that won't cause calculation.
- TypeConverter Excel-Automation problem
- Check if clipboard is empty before .PasteSpecial xlPasteValues
- problems with XL 2000 files in XL 97
- Setting ComboBox ControlSource in code
- How can you make an array of objects?
- PRINT AREA IN PROGRAMMING
- Qn: Date Format in TextBox in UserForm?
- Siple but what was the formula for splitting names?
- Help File
- solver.xla fails
- how to get onkey macro to fire while another macro is running
- Excel – Macro Problem – Appending Data
- Get the list of data inside AutoFilter list
- appactivate
- EXCEL 2002: How do I user/simulate a Timer event in Excel form
- appactivate
- Pivot Table - Subtotal of 3 columns
- GETTING DATA ON TO SHEET2
- Don't want to insert a partial row
- Looking for faster method for Copy & Paste
- Question about removing Web formats and content
- Filtering data out of access database
- Changing only source file of pre-existing text import QueryTable?
- 2003 Secutity Issue
- Select an item in a listbox using code
- cursor position
- MS Progress Indicator Mimicked. Thank you.
- Excel 5 macros
- Copy a range from a CSV file in a webpage to my local worksheet
- Adjusting screen layout?
- Relative time in SQL
- How to launch excel spreadsheet and load xml file from cmd line?
- Replacing keystrokes
- Fax
- list of extended properties for use with ADO connection strings
- Vba - User email direction
- Protected File
- Copy cell without border
- How to declare variable as Excel constant?
- Loops in a range for a more than one ocurrence of samevalue
- looping and copying from onesheet to othersheet
- How to do Cut and paste
- creating Toolbar on Word 2000 using built-in Visual Basic Editor
- XP upgrade and old 2000 macros
- Triple Lookup Formula!
- Lock Commandbars
- the anatomy of a nestled condition
- Comments
- Vba - automaticaly closing userform
- Excel VB help
- properties of object on another sheet
- How to hide rows?
- Counting Days of The Week Only In a Formula
- Hiding Formulas
- Prevent save when content change?
- IsDate Function
- OnAction Variables
- Importing text from webpage into excel and then loop?
- Using Dates in VBA functions
- Double Drop Down List & Corresponding Text Info Disply
- How to input a range in a logical test?
- I want to compute this formula: =IF(Q48=Protected!C27:C35,+Q48,"".
- Delete Folder
- Comment box sizing
- Using Hidden Sheets to populate listbox
- Confirm formula change
- Application.run Macro Code Problem
- File in use open read only
- enter todays date
- transferring data between two workbooks
- Mimick MS Progress Indicator?
- Format Cells
- Extracting Global Address List (GAL)
- Copying row data to another worksheet
- Sharing a workbook
- Tabs
- Delete menu
- Add large ammount of formula
- Change Multiple chart source data
- count cells if >""
- Which PC has workbook open?
- problems closing excel
- Should I keep Trying INSA - VLOOKUP?
- Help Please - User Database
- Is this possible?
- Re: Highlight Button...
- convert cell contents into a comment
- Run time error 70 permission denied
- How to total Items in a List "not that easy"
- Path in footer
- Address Book - Outlook
- Picture or Object Blanking out??
- Qn: Define a variable in Initialize for Userform
- apply conditional formatting
- Manipulate user permissions in a worksheet using VB
- Qn: Plot a position on a Chart??
- Re: Long Text in merged cells not copying correctly with sheet
- Advanced Conditonal Formatting
- Re: Relative referencing
- Qn: Checkbox Enable??
- Help needed
- Still having a problem checking cells
- Virtual Memory Error when running Excel
- Excel 2003 Commandbars
- Excel in network
- LTRIM Problem
- making a timer
- Bypass Replace File
- Excel VBA -Custom function sumproduct
- Copy Array pointer rather than entire array
- Insert Row when data is different
- Problem sharing spreadsheet between Office10 (Office XP) and Office 11 (Office 2003)
- Formatting using VBA
- Simple way to add a reference to a cell
- Custom Menu
- finding duplicate entries
- Toolbar Buttons and Macros available always
- align a picture/shape in a Range!
- MsgBox2
- Declaring one bidimensinal Array
- Multiple ThisWorkbook's Causing problem
- too many conditions! what to do?
- writing macros to hide rows
- Help with checkboxes
- MsgBox Title
- Update Alert
- Renaming a Worksheet with a macro... but...
- Copying formulas, formats, and sheet names across workbooks
- Countif Error --- Please Help!!
- .Textbox won't word wrap. Why?
- Re: updating charts
- labels and comboboxes
- Protecting / Hiding the Code
- Re: Naming an Excel Workbook
- Re: Quit Application Without Saving
- Re: Quit Application Without Saving
- Is this possible
- Control Toolbox buttons
- Userform doesn't recognize other user form upon re-load
- Excel data to Access?
- Does SUMPRODUCT work with "INDIRECT"?
- q. Using a macro to transfer data from Excel to Word
- Re: copy & paste macro
- paste as value
- Searching for cell values
- Unsupported methods for XL macro in IE
- Re: Naming a newly added sheet
- Re: Naming a newly added sheet
- Pivot Table Name Reset
- haha
- Re: Getting PrintForm to print all Frame Captions
- Re: How to save as a semi-colon delimited file
- Decimal portion to a seperate cell???
- cursor problems
- Lookup Help
- Filling a selected range automatically
- Change Shortcut Key Programatically
- Userform does not show on startup over LAN - problems
- Excel comments field
- Can't stop Excel help autotile :-(
- Cell color change on mouse over
- AutoFilter Criteria VBA
- Excel formulas
- Excel VBA - Printing Seperate Graphs
- Custom Menu Bar
- Becomming an MVP
- Consolidate - Relative Reference
- Signature lines in footer with "No Dupes"
- Prevent Workbook_Open macro
- Urgent help with nestled condition is needed
- J-walk face id menu - Problem
- Excel Mergefield?
- Date/Time Stamp Macro Button Problem
- Removing extended dash
- Footer Memory leak
- how do i copy a formula with different cell reference?
- How to keep a running total on a col that has frequent new entires
- Send mail from Excel
- msoControlEdit
- can it be adopted for a 16 team 4 group?
- script for a form
- Worksheets Add & Naming
- Inserting a variable number of rows in a worksheet
- Count of characters
- Pivot Table - show 0s in empty cells
- The value of a ListBox Item
- Newbie's question.
- Workbook comparison results in subscript out of range error
- SetFocus Question
- Macro Fails to Run Correctly
- Macro/Command Button
- followhyperlink method issue
- Excel menu toolbar hyperlink issues
- Correct Syntax - Collection Key
- How to use Digital Signatures
- "!" at end of variable
- VBA REFERENCE BOOK SUGGESTIONS
- Problem with formula: need rolling average of 10 months
- Macro for "close w/no save"?
- finding non-standard years in a dataset
- Do loop to add a new worksheet
- Excel to select a row based on previous rows
- Excel 2000 VBA date format changes in subtotals
- UpdateLink Question
- RE: Edit Text Import
- QueryTables Error
- MsgBox - Don't Show Again
- Automatic Macros
- formatting suggestions
- control excel from Agilent VEE with ActiveX
- multiplying data
- Time format behaviour
- Validation
- Is Active Workbook ="ABC"
- Creating an installation file
- Automating Fill series Function Multiple times ?
- File Search
- Assigning global macro to keyboard shortcut in Excel 2003
- Automated export from Excel to Outlook
- Load 2nd form - second one not working after hide - help pls
- Set a cell to blank (Null)
- What does this message mean?
- Default Menu
- Re: Trendline Data
- Macro to delete duplicate entries
- Re: Easy Array Question...
- Re: Easy Array Question...
- Re: Easy Array Question...
- Read Only Wrkbook Sheet
- Re: Trendline Data
- ClearContents Not Clearing Query
- Re: Trendline Data
- formulas for pivot table data
- Re: Copy Formula loop based on number of rows w/ data in a col B.
- Sendkeys and wait variant
- updating Excel from DotNet
- Re: copy sheets selected on user form
- sending email with commandbutton
- Re: copy sheets selected on user form
- Qn: Ensure Number is valid for a circle??
- Class module in VBA
- Retrieving a value from a cell
- Exception Access Violation (0xc0000005)
- Setting up default chart properties
- Code Execution has been Interrupted
- Listbox Problem
- RE: VBA-XP-Excel 2000-2003
- Set print Range
- code for converting data format in another format
- Adding columns with dates -
- Re: Put the value of a cell in a variable
- Time format behaviour
- Time format behaviour
- Re: Time format behaviour
- Re: error handling off??
- Textbox
- Any fast method to parse a string into row & col information
- Re: RandomNumber Generator
- Exporting & Importing Macros
- Range
- Adding columns - with tech info
- EXCEL Checkboxxx Props.
- excel VBA problem - setting workbook as variable & opening/re-opening
- q Using a macro to paste data from Excel to Word
- string length
- VBA - find double quote (") in string
- Macro fire at given time, through command prompt
- Excel cannot complete ......... when screen saver is activated.
- Re: Running Event Procedure When Cell Updated on Excel Worksheet
- cell-fill-macro again
- export form??
- Make a built-in toolbar permanently not visible
- UserForm events
- Help with Do Loop that names rows as ranges
- Data from Excel to Access
- cell-fill-makro
- Delete
- Adding columns to get correct results
- Class module to filter textbox entry
- Print Macros
- Read only mode
- finding text
- Loop until underlined border??
- Filter
- code to select a column down to last poplulated row
- Web query on password protected page
- .GetOpenFilename assitance
- Calling Solver from an Excel 2003 Macro
- Disable Customize in Excel 10,11
- Need for Application.Volatile?
- Open wrkBook (auto_open) programmatically
- Offset Range
- repositioning aging categories in a pivot when present
- ChartObjects
- Excel 97 to XP problem
- Merging data from several sheets
- How to use function CELL(Infotyp;Ref) in VBA?
- Excel Validation Help Needed
- Difficult project using arrays
- Commands fail on different PC's
- another lookup!
- Check box - checked or unchecked?
- (Disable macro's while) using the GetObject
- Excel automation through .NET Interop: NumberFormat property looks like NumberFormatLocal
- Move ? spaces to the right
- Macro for comparing 2 values (number and date)
- web page object reference
- [variable] definition
- search for one column values in another col ?
- Device I/O Error
- save w/o prompted and activate a file
- MsgBox position
- Using If Statements to change colours
- Save without prompted and activate external file
- Save without prompt and Activate a file
- Customize Pivot Table
- Pivot Table - Code Optimization
- Find the last Row in a Range
- using a macro to copy cells from one sheet to another
- Convert *.Xls to *.csv
- Disable Macros when opening workbook
- A VBA code that clicks a checkbox
- How could I run my macros in a protected with password worksheet
- Excel error after using macro
- Filling a textbox with text in another cell
- remove help icon from inputbox
- Find...FindNext Problem
- Formatting &[Date] in header Excel 2000
- vba/macro for loop-based summing?
- User Input
- Missing coefficients in multiple regression
- forward and back buttons in EXCEL
- Quick n' dirty code to delete rows?
- Excel Macro question? Column position
- Summary on one page
- Merging cells text
- remove drop down arrows
- Excel 2000 / How clear drop-down list in Pivottable?
- Template behaving like .xls file
- Help with a macro
- Negative numbers
- Auto Edit HTML Page
- Conversion from currency value to currency text format
- Excel calculation
- Closing Excel from VBA
- How to automaticaly hide all toolbars in in workbook when another workbooks are open?
- Tracking changes
- workspace
- RE: Adding Macro Button on Standard Toolbar
- Adding columns
- Link multiple spreadsheets to one central spreadsheet using a macro
- entering formula using variable in Excel Macro
- Control Button stays on screen
- Remove First Row from Variant Array FAST?
- Excel 2003 blows me right out sometimes
- converting dates
- Pivot Table Vba Automation In 2002
- Adding two columns to determine number of days to pay
- Return value of Property Get when using enumerated type
- VBA - Lookup address
- Macro File Help
- Re: Is it possible to get cell contents from another sheet?
- apoligies:changing excel icon
- VBA - Lookup cell address
- Is it possible to get cell contents from another sheet?
- Re: Is it possible to get cell contents from another sheet?
- Hide Sheet If....
- Sound when running macro
- Updating Data to Access Error
- right
- referencing previously selected cells after macro execution begins
- specify the exact size of a chart through microsoft script editor
- MS Query problem
- problem evaluating custom functions
- What is wrong in this Sub?
- Opening an HTML doc - inconsistent results manual vs macro.
- Re: Upgrading to Office 2003
- Splash screen on opening excel
- choose the right volume
- passing reference arguments to VBA function
- mouseclick events
- Re: File specific Auto correct entries
- Excel spreadsheets formatting
- Qn: Position of Cursor in UserForm1
- Qn: Load Data into UserForm1??
- passing criteria via Get External Data from a macro
- Qn: Paragraph or LF in ONE Cell??
- Excel macro recording problem
- Qn: Sound in MsgBox??
- Protecting Cells with macros
- Qn: Display Text in TextBox in Userform
- Shortcut keys for buttons on forms
- Excel Template Wizard?
- Opening an external file
- Opening Recovered Sheet - 3rd Post
- How do I count in Excel?
- Make 1 row into 4 rows
- need to copy row above but different thoughtout data
- Lost the 'Help' menu, urgent!
- VBA Primer
- Suspend code
- New Line Character
- User Defined function - second posting
- How to see if the opened workbook is opened by another user ?
- Removing Dialog Box
- code for select a group cut, paste and delete
- Automatic Activation of Design Mode
- Error Handler
- Automatically Close Excel
- Saving
- goal seek problem
- Reducing File Size - Turning VBA into txt?
- How to suppress the prompt from merging cells
- Refresh Multiple Pivot Tables
- adding new data on new sheet
- cell displays formula instead of value
- Like Sumproduct() but using values from a list
- PUT data in closed workbook
- Visual Basic Text Functions
- I try again with auto tab
- Please help with this filter
- select alternate rows - quickly
- Executeexcel4Macro?? (Dave, I need some help)
- Workbooks.Open not functioning properly
- Autofilter global Show All function disabled in protected worksheet
- Selecting first cell in a colmn after a filter has bee applied
- how to save only one sheet as workbook
- Excel 2003, problem with UK date format, using OLE
- calling an MS Access query from within VBA for Excel
- Get Pivot Table count of rows in VBA
- Timeout problems
- Disabling Right Click Menu
- Worksheet That Works Like Pivot
- difference between 2 times
- excel
- selectfile control
- excel
- Help with applying function to cells
- EXCEL 2002: How do I user/simulate a Timer event in Excel form
- Inputs.
- Re: HowTo Count number of replacements
- Chart question - Walkenbachs book
- Is absolute security for Excel VBA code possible?
- Open a TXT file from WEB ?
- RE: Worksheet as file
- Re: Still can't get it right
- Re: Calling a procedure in a procedure
- Color Text
- Passing data to an open workbook from Lotus Notes
- MsgBox - How to display In Other Instance of Excel
- coloring cells
- Re: Calling a procedure in a procedure
- How to open an html file from within a macro
- Re: Calling a procedure in a procedure
- Running an Access Query From Excel
- Macros incompatible for different versions?
- Populating data from an external database
- Open a Spread Sheet In a Mdi form In Vb.net
- Select a row, copy and repeat on the next row
- dYNAMIC Array declaration, a small correction in my last thread!
- Declaring variable as a dynamic array?
- Macros incompatible for different versions?
- Autocalculation settings when multiple spreadsheets open
- Saving files
- msgbox title
- Re: HowTo Count number of replacements
- Advance Filter problem
- Re: how to open a Workbook and activate a specific sheet
- SELECT ... INTO ... IN ...
- Re: how to open a Workbook and activate a specific sheet
- find location
- Deselect top row in pivot table
- Macros incompatible for different versions?
- Cut and Paste to A Seperate Worksheet
- So close and yet... (Pros Only)
- Verify Totals
- can it be done without using code?
- Combo box help
- Need to do a SQL-like functions within Excel. Need HELP!
- Re: Could not set the RowSource property
- Text Boxes / ctrl-f
- RE: Insert method of range class failed
- Insert method of range class failed
- Divide up Worksheet
- Save file with fields within quotes and comma separated
- Creating a chart (Getting the correct input and output)
- range data type
- Save takes seconds vs. SaveAs/Save As takes minutes
- User Form Template???
- ComboBox Values
- Apologies: access/excel ado via vba - forgot a line
- access/excel ado via vba
- Copying Worksheets from one book to another
- Opening with a password with VB
- vlookup from VBA on a closed workbook
- VB programming interactive macroes
- Conversion to Text file
- Hourly calculation
- Excel VBA- If Then statement
- Dynamic Validation Lists
- Problem populating a multicolumn listbox
- Adding add columns and not getting duplication
- Inputs into equations withwout having to repeat the equation every time.
- Hiding Excel Menus
- Hiding Excel Menus
- Hiding Excel Menus
- Counts
- irrational problem
- can i add a row for (x,y) values and perform its maths?
- How to eliminate any new pivot Items
- Re: VBA To Replace Duplicate Values with Zero (Complex)
- ParsingCellData
- Read all -- Adding columns for paying
- User defined function
- Help with Pop up screens and Error Pop ups
- Need Help With A Loop To Copy
- Windows Explorer Right-Click Extension
- Make Option Compare Text the Default??
- Adding columns for purpose of payment
- Update cell selection of embedded worksheet in Word
- Print Array in Cell
- Repeated validation lists in several worksheets
- How to use QueryTable with insertion sql
- Userform cannot return any values
- Test if Clipboard is empty
- programming the VBE for a new event procedure
- Can I attach a toolbar to an add-in?
- Find Method
- Find Linked Cells
- Using cell references in Excel Macros
- running a webquery after every 5 secs
- Searching text lists
- Password protect excel code
- Colouring cells
- Difficult returning result !!!!
- Search for criteria and count
- TextBox Controls--tabbing
- Insert a heading
- deleting row using macro need help
- Additional feature to code given on August 6th
- Tab Name same as Cell - PART 2
- Naming A Table Array in Vlookup
- Naming A Table Array in Vlookup
- Naming A Table Array in Vlookup
- VBA execution stops at ActiveSheet.Copy -- but only sometimes!
- Help with some code please
- Excel VBA question - Running a autofil
- RE: Access and retrieve data from network workbook
- MDB add-ins for Excel 97
- read text file
- read text file
- Cannot suppress an ErrorMessage
- How can I use web query with a password protected page?
- Read text data
- validating macro
- screenupdating workbook open
- Countif with row criterion
- Autofill
- Sort options by Excel VBA
- Activate button when row selected.
- Recognising cell values
- Paste special to the active cell
- SQL Query Headache
- Switching Names Around
- a faster method in changing cell value?
- How to parse the comma seperated strings into the excel sheet
- Cell Comparsion (a bug?)