- Difference between NEW and CREATEOBJECT?
- curious sheet behaviour
- Applying two or more filters through VB
- SubTotals
- need to disallow pasting into cells directly
- Question number Two
- save worksheet as new workbook
- Selecting Filtered records only when AutoFilter is on
- Displaying a specific worksheet on opening application
- Window;1 doesn't display
- Using Filters, Copy + Paste in a Macro #2
- Need help with an array
- help in selecting cells , VBA in Excel
- login to worksheet from command button
- Re:"Insert LineBreak-Macro"Thanks BOB!
- Excel VBA Code
- Database Export to Excel
- Help with Date checking code
- File kill help
- Anyone can help
- Distribute Excel Workbook with licence?
- Forcing Events to happen
- Hair Pulling Problem...
- Copy method fails in IIS
- Reset New Collection
- Can't change font on conditional formatting
- COUNT where cells value = to "value"
- URL too long in Excel (VBA).
- Active X Support for Excel
- meaning of Dynamic?
- Excel VBA - Check for Duplicate Records
- ChartCalculate code causing error when saving workbook
- Copying Data into another worksheet using macro
- pagebreaks
- Re: Ron Helped Once Can you do it again?
- Odd behavior with SaveAs
- Re: Ron Helped Once Can you do it again?
- Get NT Username
- tab order in frame control
- Creating a Checkbox inside a cell for each line
- Dim cell AS range....
- lookup
- Turning Filters ON in a Protected Shared Worksheet
- Sort row values descending
- MS Query: Break data into separate sheets based on value?
- Pivot Table - Page List
- serial port data acquisition
- Sort on two columns in two dimensional array
- How do I get cursor position and text being typed?
- Excel VBA Form problem
- Pivot table: Adding dynamic columns
- Calendar Control
- Will setting Saved = True in Workbook_Open have a negative effect?
- Show Record Macro Toolbar
- Copy/Paste
- Conditionally inserting blank rows using macro
- Need Quick Fix... Find macro Issue
- Re: Find and copy in macro
- Export from Excel to Access ADODB
- Re: Excel VBA MID Function
- sheet name as cell : link?
- TIR function
- Re: Excel VBA MID Function
- Re: Excel VBA MID Function
- Inputbox
- Public variable is reset after addin macro completes - thread/focus pblm?
- Re: Excel VBA MID Function
- reference missing?
- Excel VBA - Delete rows within a date range
- Is there is a way to tell conditional formatting is on?
- Import of Database VB app into Excel Spreadsheet
- RE: Ron Helped Once Can you do it again?
- Apply more than one filter in macro/vb code
- Type mismatch
- Web Link - multiple instances
- Code writing:Where to start ?
- Conditional Formatting between different workbooks (see details..)
- Hide details
- How do I tell excel to export graphs to ppt and only have to update excel?
- Combine sheets into one sheet - Urgent
- reading statements
- Inserting a row
- Compile error in hidden module error
- SQL Queries in VBA
- converting dates
- File association to Excel spreadsheet
- date of update
- Conditional cell lock?
- Log Password Entry Attempts
- limit or deny opening other files
- Updating a database query from XL
- Home Made Conditional Functions
- Locking down columns
- How to tell if a range or cell is dirty
- ListBox with hidden and visible sheet names?
- Disable Button when no workbooks are open.
- check for running app
- Round to numbers in a list
- Send Outlook Attachment within Excel
- dbase
- Working with FedEx electronic invoicing
- Excel.Ink missing
- Macro Button To Modify A Cell's Contents?
- Renaming worksheets!
- Problem importing a txt file
- Problem passing by reference
- filling
- VBA InternetExplorer ReadyState loop
- new to VBA
- Display the Hyperlink Dialog when inserting Hyperlinks
- personal.xls...attention Robin????
- Excel VBA - Delete entire row if all values are 0
- Extract alphabet from string.
- Cell Alignment
- problem with calender control
- VBA Code Help
- Status Bar
- Command text syntax and comma
- Protection
- back up tracking system while we change software
- VBA Code
- FileDialog Folder selection spec
- Using VB to auto print documents to pdf files
- Excel VBA Backwards Compatability Problem - 2002->97
- How do I make Macro Buttons Transparent ?
- survey for the unemployed
- ListBox Procedures
- Use ListIndex to set Sheet order?
- Web interaction
- hide and restore personal display settings in excel menu
- Run a Macro over a Closed Workbook??
- Counting number of lines in a CELL
- Don't update Links
- Combobox update
- Find row number of last value in column
- Macro - code for ranges urgent!!!
- E-mail using Lotus Notes
- How I can compare numbers in one book to another book
- Refresh Problem
- Saving cell content externally.
- Sub Total Method URGENT
- Best Solution / Ranges
- Create Object
- Extract data from SAP to Excel?
- Little task
- on cell entry
- Macros assigned to buttons do not work when copied to CD
- How to get rid of a VBAProject?
- New Macro
- Pivot table source data question
- Looking to subtract one list of values from another
- Life of a variable
- Excel VBA - clock in buttons problem
- Hatched page break lines
- Problem Reading Delimited File
- Dynamic GUI
- Only allowing one open workbook in excel
- timeformatting and colored cells
- vba event
- Open file in directory
- Excel 2000 Protect ... But Free Filter
- Save file without prompting
- no tab index property in VBA for text fields
- .additem
- VBA code in "Data" menu
- string passing to DLL
- Repost- problem with calender control
- Can't Group or Ungroup in Protected Cells
- Close Window
- FileSystemObject Error
- For loop question
- Trouble with copy and paste
- Excel Chart Event Coding
- Re: I want to *beep* *beep*!!!!
- Re: I want to *beep* *beep*!!!!
- Re: Data Validation Prompt Message
- control in user defined function
- Combo/List Box
- Deffinatly need help!!!
- Embedded command button doesn't respond in new window
- converting date from a textbox to a date format
- Inserting data into file.comments
- Open dialog in macro
- even/odd returns 1 0r 16
- ActiveSheet.PrintOut - problem
- Pivot Table Pain!
- stepping down rows
- Re: Dump of all variable contents
- Excel Web Queries
- Selecting & Displaying An Array's Contents
- Excel VBA/Macro - Textbox
- how to protect sheets from VBA?
- how to sign Excel 97 AddIn
- vba filter
- Change Excel workbook icon
- opening a workbook
- PivotCache memory resource Problem
- xl2002 workbook wont open in xl200
- activating excel from VB
- Worksheet_Change /ActiveCell.CurrentRegion ?
- copying cells with formulas, but to keep it alike in destination
- Naming Workbooks and Sheets
- Re: Can I reset an array to myarray()
- Excel Instance
- Re: Can I reset an array to myarray()
- Empty Cell Question.
- Truncating a cell value AFTER the decimal place
- Delete entire row if A1,2,3... is empty
- E-Mail Question
- For each next choking.
- event in worksheet switches to VB code window
- File Size Increase Controlled, Question
- Open File
- Retrieving external data
- Key modifier for double-click event?
- Parsing Text Strings
- Calling SUB
- Remove data with listbox
- Unexpected error (336)?????
- problems with Data Form macro
- List Files as HyperLink through VBA
- Entering data between existing data
- Button Faceid
- Recreate a macro menu
- Query Hangs or Slow Performance after 2 updates
- sheet totals
- Opening all txt files in a folder and saving as excel
- .OnAction with arguments
- can i link a cell to jump to a worksheet?
- Adding a toolbar on a form
- Add-in functions (some work, some don't)
- Workbook.Variables?
- Importing Data
- Date Calculate
- STATUS BAR
- Save exact copy of workbook
- Simple Copy & Paste
- Getting results from VBA calculations into cells
- Universal Macro
- Chart Series
- Datagrid to Excel problem (ASP dot net)
- macro stops midstream
- Variable Reference in R1C1 format
- user form StartUpPosition
- Using sheet codename problems
- Compare worksheets
- excel.exe error when adding controls to userforms
- Moving a row to new work sheet/book if order=yes
- File Name Exists Error Trap
- Timed Tab Rotation in one Workbook
- combobox update
- problems with DataForm macro #2
- Macros
- Auto open macros in Excel
- Transpose
- Macro doesn't run on another computer
- Filter columns in Excel
- Get rows which match selection criteria
- Web Access Timeout
- I have an error when a start my macro
- Office automation application which will work with any version of office C#.NET
- JE McGimpsey & Frank Kabel
- Is there a "Before" Open event?
- Removing "external links" in Excel
- Trouble setting variable as filename with date
- Removing external links in Excel
- CONTAINS SPECIFIC TEXT OR NUMBER
- Copy formulas, not values
- Converting strings to Sum worksheet function and control variables
- TextBox 'ShrinkToFit' oddity ???
- Help with Visual Basic
- Invalid use of Null
- Control of Listbox Colors
- SpecialCells and a Special Character
- 1 Question (no work involved)
- Split Function
- Is It Possible To Make A Cell Blink..
- File Exists Killing Workbook_Open()
- Problem when trying to convert one column with multiple rows to one row with multiple column
- Screen Flicker while processing
- Floating Toolbar Questions
- Excel 2000 Hanging while reading large file with Line Input
- Problems with referring to workbooks
- Broken References
- Forcing a macro to (semi-) automatically run
- Run macro on certain day and time
- (Probably) simple question
- Consolidate Data
- Button from Control Box
- Assign code to button
- Explain Macro?
- Remove last characters
- Slow Execution of User-Defined Function
- Get active cell?
- Compare worksheets
- Cell Change Event
- move content line to column
- Amend a macro by macro
- "Cell"
- Excel VBA problem
- Userfrm Lookup Works For text not Number
- numbered labels
- date formating help
- Macro works fine in xl2002 but does not in xl 2000
- return row number
- Re:backup warranty tracking system
- Time in combo boxes change to decimals when printing
- dropping prefix '0's when creating a spreadsheet in code
- Run macro in another workbook with arguments
- Finding last sheet
- Formatting Number & Text in same cell
- Before and After Print macro
- Q: How to change tab color based on cell value
- Selecting a range in a different worksheet
- Can't find project or library
- Import .txt files into XL with time fields-need to calculate
- Determined if filtered range is empty
- Speed of SpinButton
- Close WorkBook with CommandButton
- Create Add-In
- Conditional formatting in a cell formula
- Checkbox to remove recipient from email
- Checkbox to remove recipient from bulk email
- Indicating worksheets are hidden
- Selecting cells which do not meet a formatting criteria, and assigning a Range object to these.
- Sorting issue
- UserForm Events
- menumaker.xls
- Listbox questions
- Scrolling in Multipages
- Using Data Form
- Nested If(and(...
- Distributing secure ('er') Excel workbook
- Using user form to change cell value on worksheet
- repeated question: how to protect sheets from within VBA?
- Loop through files
- vba filter code
- Excel pictures - saving to a file
- Extra save
- Printing one or more pages?
- number of rows in spreadsheet
- VBA code to make CUSTOM VIEW fill ANY RESOLUTION SCREEN
- Insert Row and copy formulas
- Subroutine Arguments
- incorrect results when working with doubles or singles
- Maximizing width of graph
- Format Concatenate Entries
- C# Excel Automation Add-In
- Hiding a toolbar
- Dynamic LastCell
- Tom I Know You Can Do It...
- Changing a Chart on a Protected Sheet
- Max WorksheetFunction
- Disregard last posting
- If/Then help in returning value
- Use function in xll in conditional formatting
- countif with second if?
- Response
- Formatting text in a textbox to show separate lines
- Quote in filename causes problem with Application.Run
- Office C# code behin : CommandBar Class Problem ?
- Ckear Clipboard
- count time format as decimal
- Run Macro on Worksheet Activate
- Prevent Access To VBA Editor?
- CopyIntoFirstEmptyRow
- funcres.xla
- set range question
- Creating a Button to add to existing values while subtracting range
- Use of Templates??
- VBA ComboBox
- Count by fiil color
- Email - Outlook no Closing Session
- Do Until Code
- RE:count time format as decimal
- auto filter
- checkbox to remove recipient from email
- reading a value from an autoshape 'oval' ?
- Choose file for query
- access a cell by it's name
- Combobox
- Edit Textbox using KeyPress vba code in Access
- keep formula after typing in a value in a excel cell
- VC7.1++ Excel add-in sample code? Visual Studio 2003
- '$' sign in the form window
- Referencing a Subprocedures Name
- Problem with comma seperated list
- Disable Window Right Click
- referencing values in adjacent cells to selected cell
- Search and replace by page break
- Showing Loop Status
- Analyze timescaled data in excel
- random text generator- urgent help
- Keyboard Shortcuts
- Not sure if this is possible!!
- Unselect Filtre ....
- Reference styles and local/non-local formulae - international problems.
- problem with resize property
- Pasting Data into a worksheet
- excel application does not shut down after program exit
- save photos from a worksheet
- Excel 2002 Workbook Opens Very Slowly
- Getting data from SQL Server into Excel
- Display set area
- Reformatting of cells on requery of sql source
- Excel question
- FormulaArray
- Row Height equivalent to xlColumnWidths?
- Create a help file for VB functions
- range question
- range question
- range: question
- macro won't pull up list's data form
- changing values acroos worksheets
- convert number format to time format
- Don't want to SEE macro working
- define cell for autofit of merged cells
- beginnersproblem copy formulas to cells
- Showing Worksheet Range in Userform
- Paste text only
- Save sheet without links
- Workbook's BaseTemplate
- Re: Paste text only
- Dynamic execution of a loop
- ODBC connection for insert into SQL Server
- Cell Alignments using a reference worksheet
- Using Send Keys to unprotect and protect VB project
- Repeat Multiple Page Headers using VBA
- formula error
- Concatenate and copy in VBA
- Concatenate and copy in VBA
- Re: Frame Index
- Notify without opening workbook
- date format ??
- Web Query
- Paste Function in Macro
- Datagrid to Excel - error - rendercontrol
- setup
- Toggle custom button caption
- Clear Clipboard on Workbook Close Event (Excel XP)
- Set range as multiple columns
- Value from Registry
- Hoping a guru can help this novice out with a simple macro
- Calculating the minutes between two times
- Assign Formula to Variable
- Auto Print
- Find the two lowest values and subtract them from a total
- Application.NetworkTemplatesPath Not Working
- Userform text & combobox population help required please
- Date Calculation in UserForm TextBox
- Variable Autofill range
- worksheets collection... find...
- How to save each worksheet as seperate file?
- Combobox
- Multiple worsheets
- Error Message in VB
- Formula Length
- validate an option is chosen
- Method 'Range" of object'_Global' failed
- Re: VBA to prohibit changes to scale setting in page-setup
- User Defined Functions
- Saving filename same as import filename
- Pivot Table Formats in Excel 97
- Variable Autofill Range
- SetActivePrinter
- Summing Duplicate Entries in Excel 2000
- VBA VLookup Reference Problem
- Catch File>Save/Save As/etc...
- account format in excel
- XL 2002 vba on an XL 2000 machine
- Filters on with worksheet Protection on in Sharedworkbook
- Newbie : How to sum cells via VBA code.
- Open an Acees Form from Excel
- Exporting multiple worksheets as CSV
- stop in cell
- reference to Comments
- tabular questionable
- Entering Dates and auto-completing
- cond'tnal format 4 date changes
- Forgotten share & protect password
- restricting fonts
- Wraping text to next line
- Question on Positioning Bar Chart Labels
- Conditional formatting formula is evaluated repeatedly
- CopyAndPaste Object w/namechange
- Next Cell Question
- Automatically running macros
- cell to textframe using characters object
- auto copy and past
- SaveAs another file name, then keep working
- How do I test when a vaule is not found?
- Finding Non-Blank Cells
- SmartDocument events
- lookup, cut, go to named worksheet and paste complete rows
- Sort column
- Save date in filename
- Getting App.Path in VBA?
- Newbie : Sum Cells Part 2
- help: Activesheet.save error with XL 2000
- Err.Number 1004 with various Err.Descriptions
- Replace Function
- Need to search workbook for NEW worksheet
- Printing Diagonal Cells Problem
- How to "Set alias for worksheet in other excel file"
- Apply a Font using Page.Setup and ExecuteExcel4Macro
- VBA Vlookup External Reference
- publish excel as web page
- Can A Named Range Be A Variable?
- Import *.asc file into excel fixed width
- GetSaveAsFilename - how to code the arguments
- Creating folders with VB
- Excel VBA - Exporting values to a txt file
- Previous Excel Question
- Case sensitive sorting in Excel
- Excel error when opening a file from ethernet
- application.inputbox
- How to select cells?
- Pop-up menu with valid values
- Graphic Visualization of an ORACLE data on EXCEL
- Seqentual number save
- VB Form to populate spreadsheet.
- Range Resize property
- Copy & SpecialPaste same cell
- Live link from the Web?
- I meant this to be for word, sorry, can you still help me?
- write excel C++ without excel
- Excel VBA - Executing external programs in an excel macro
- Add add number
- Add add number
- Macro to assign a printer to a workbook
- Automation remote saveing help needed
- Copying a Worksheet from an AddIn into an empty Workbook
- better search method
- read this
- Multiple combobox association
- How to handle hierarchy processing like this
- turn on sharing
- How to perform allocations, planning and budgetting in Excel
- pastespecial
- Protected Worksheets
- variable = current cell in VB
- moving to aparticular view - SOUNDS SIMPLE?!
- VBA Editor not showing list of properties & methods
- Changing the Cell Background Color when a keyword is entered
- Save as
- Save as
- ISNUMBER
- If a called sub exit, how to the caller exit right away?
- Textbox & Barcode Scanning
- Problems ignoring error message
- Re-Post: Long and Varying Worksheet Save Times
- Long Time to Enter Cell Values
- Create Workbook
- Converting currency
- Re: SaveAs Dialog Arguments
- BMSLtd.co.uk
- Select method of Range class failure
- Changing the behavior of the "tab" button
- Selection Failed
- Count rows On error MsgBox
- Get output Path
- workbooks.open and appliciation.screenupdating
- Macro Sharing
- Macro not executed Excel --> PowerPoint
- Deleting duplicate entries
- cut & copy line...
- Default Value For Functin
- Format and Convert
- ole
- Counter
- Macro & Tool Bar Sharing
- Macro to prevent saving
- conditional formatting >syntax
- Linking...system locking up
- Protected Sheets suppressing object usage
- help on select case
- Active cell plus 1
- Blank lines
- Re: 'Application.Goto Reference
- Macro to Delete Rows
- Resizing list boxes in a form
- Create Folder / Copy Folder / Replace
- ??
- conditional formating
- EXCEL AND OLEDB
- Function Calling Subroutine
- Run Time error
- TextToColumns
- cell formatted for current day
- new to Excel-have problem
- Selecting Contiguous data that contains many empty cells
- best approach? or select last row before page break
- Export multiple datagrids on web page to Excel
- day and date in cells
- VBA and comments in Excel2002
- User form
- Excel Question
- merge cells in Excel??
- Can't Save
- Excel process remains active after runtime error 1004 in IE Browser window
- I need a macro to convert my date formats into a custom layout.
- Combobox 2nd posting
- Does Excel 2000 VBA code need to be "de-compiled"
- Delete blank rows?
- RunAutoMacros xlClose then Application.Quit
- quotation marks before and after each input
- Clearing cells that only contain spaces
- VBA code does not work in Excel 2003
- Disable File-Save menu item in macro?
- Open and Save Excel file on the internet
- Pivot Tables....
- How do I add text to the body of my message using SendMail?
- Creating / Adding items to a combo box list
- DoCmd.OpenReport problem
- DoCmd.OpenReport
- Need help: Finding and Extracting certain cells
- End of List
- adding text to end of cell
- Excel Pivot Table - 2 Reports With Same Page Fields
- Re: deleting content in cells
- sort columns
- Code modification to accomodate scaling and print areas.
- how to set pivotitem.visible property to true
- Can Names refer to Collections?
- Automatic Form
- Chart appearing as a picture??
- Hiding macros
- instr isn't finding all the matches
- End of List
- Some minor Questions
- finding the 5 largest numbers in a range
- Make customize powerpoint having graphs/charts from excel
- IndentLevel
- Test values in data table?
- Place The Contents Of A Cell From The Active Worksheet Into A Cell On An Inavtive Worksheet
- Require checkbox to be checked before processing
- opening a file
- Sum a column
- Problem identifying with Checkbox's status
- cancel dialogue box automatically in program
- Get a cell's name in VBA
- Insert forms created in excel's visual basic into a worksheet or at startup
- Time Stamping
- Symbol font with Times in Data labels
- Excel Prg to retreive numeric values
- Do not copy buttons or macros
- Can I use "Unicode" numbers to specify a font?
- Unique ID/Name for a computer?
- How to extract number from cells in excel (function in Excel or VBA?)
- Search based on comparing several values in the same row and column
- Finding blanks in dynamic ranges
- Excel 2000 importing huge ASCII files into different sheets
- Stuck!
- adding numbers macro
- Identifying blank rows
- format cell based on value
- Printer error building Excel workbook...?
- winzip in macro
- counting cells
- Calling an Excel Doc from Internet Explorer
- looping to End
- Excel 97 - Common Dialog Control Help
- Application Security Loses Control
- Macro help
- Combo Box using Key Input
- Almost finished my project
- Access control on a worksheet - help!
- Protecting a macro
- Object Library 11.0
- Macros for emailing
- VB Editor compiles before I finish typing
- using 'enter' on a textbox to activate a command button?
- Set Range in one macro to range in another
- Help with time VBA
- Macro to Autofilter
- Large scale
- Active sheets
- "rows" syntax
- Help! Application Error >_<
- Associating Comboboxes
- lenght of a number
- Enable Macros
- range
- Setting ranges
- Re:Help with time VBA
- Refresh listbox on userform1
- VBA - How to Write to Specific Worksheets
- Convert
- Call Private Function from ThisWorkbook module
- Importing Excel data
- excel vba- userform problem
- help with string functions
- toggling a chart on and off
- Running 2 Excels simultaneously?
- question about creating a message box
- computers are not logical
- Question regarding an activex control button
- How to get the RGB values
- Multiple VBAProjects in Excel File
- What is quicker? Nested or non nested ifs
- Caps Lock
- Subtotals
- AddIn with Tables
- Multiple excel spreadsheets in one HTML file
- How to make a new table based on selected result in listbox
- Deleting Hidden Files
- excel addins have reference to wrong file
- How to get relative range?
- Replicate an Excel 2000 sheet between two locations?
- how to add search criteria in VBA, EXCEL
- Test for shaded cell?
- help with links needed
- Problems using VB.Net OleDbDataAdapter and Excel
- Using "Like"
- Tab Between Active X Controls on Worksheet
- Re: i will check
- AddressOf / Windows API question
- vlookup works sometimes
- problems with .xml and Excel 2002
- Setting cell background color based on value
- How do you use "except" in a for next loop
- VBA Problems
- Disappearing listbox entry
- Deleting Excel Message/Dialog Boxes
- Customizing toolbar buttons
- How do you change button color by moving over it?
- Explain Parameters for a UDF
- Re: format cell
- Clear Clipboard in VB
- Re: Help Please
- Fundamental use of Round
- Public Variables with UserForms
- Save a copy of Excel in Access???
- Text box invisible scroll bars
- Highlight the entire row of a selected cell
- why macro slow first time
- Re: Auto Filter Subtotal
- Detecting whether Caps Lock is set
- How to clear a selection
- Screen savers
- "Unable to Open File" - excel output of Datagrid <-help needed
- Row Height
- arrays - module to module
- Re: Sending Mail using Lotus Notes
- Deleting Rows based on text in cell & formatting cell based on text in column beside it
- get excel to automatically add fill color
- SQL.Request from Oracle Database
- putting validation to TextBox in the userform
- DATE = 1ST OF MTH
- referencing ComboBox