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