- Open excel and workbook with VB6
- How to get Autocorrect Listing out of Excel
- format partial formula
- Hidden Row
- sorting worksheets and charts together
- Microsoft Office Web Components 9.0
- Toggle command buttons
- Blank lines
- Adobe to Excel
- Help with totaling a columns in VBA
- Msgbox if Inputbox entry contains character
- Autofill Function
- How many hyperlinks can be in collection?
- Excel command line
- Working with data from several worksheets
- Page Break Automation
- VB Help does not display Excel information
- time format
- making cells bold
- What does "\" do in VBA
- Macro with manual file selection?
- Getting Month Name
- Private Sub - Hot key?
- Copying range from another file
- maintaining a link
- Need Help for Help!
- Need Help for Help!
- Retrieving Web Data
- Run-Time error 57121
- A Simply ComboBox Selection returns value to TextBox
- While ... Wend
- Connection with SQL Server - "time exceed"
- range property of range object
- opposite of IsNumeric
- Working on the wrong sheet
- Connection with SQL Server generate "Timeout expired"
- How to Open txt File and Import it to excel
- Help with a macro
- Creating a search button
- Writing Single Dimension Array to Active Sheet
- Need VBA code to terminate a find loop
- Userform always visible
- How to Kill a vba macro from a Function//
- Retrieving Active Directory "Full Names"
- Hidden Row in seperate worksheet.
- VBA acting weird, advice plse.
- Help files
- Want row to stay hidden
- Conditional Formatting Not showing without editing cell
- Macro Copy and Pasting
- Copy data from excel to a defined table in another spreadsheet
- XMLSS href attribute
- Running an external Macro
- VB worksheet function parms
- scrolling in VBA Edotor
- dee
- How to set range
- vlookup relative reference?!!??!!
- Sumif problem
- HELP!!! I give up!!! Help with formula
- macro works differently when using the Step Into (F8) feature
- macro security
- outline...hide levels
- Bundling Solver with Excel File
- copy and paste graphics into comment boxes
- Data Validation from a database query ?
- Deactivating all events in ThisWorkbook
- Combobox Change On Save As
- Graphs
- Merged cells text > 255 chars causes "#" to be displayed
- Adding a Trendline or similar to a 3D Column Graph
- Progress Bar in Cell
- colour text in validation lists
- commands button
- getting rows out of a data base
- Validation from list in different worksheet/workbook
- Pivot table autoformat info
- VBA Error setting Font.ColorIndex
- loading com addins with automation
- 2 if statements
- Getting series name
- Custom save as pathname and filename
- How to search a value with two criteria from a database?
- Incremental number field with User ID
- Macro which finds data? help?
- Multi Sheet select and hiderows
- Macro-pawan
- Another Question Concerning Replacing Formulae With Values !
- removal of circular reference error on excel workbook load
- printing vba code in color
- Select Case on different worksheet?
- Show/Hide Columns
- Excel limitation or bug or what?
- I'm loosing it: rows in filter
- wrong date returned on ws.Cells(r,c).value
- can not restor FormulaBar when i close yhe file
- Moving range to array
- Currency Formating
- Control Word through Excel
- Macros available to several workbooks
- Excel Queries
- calculatedfields
- Pivot Table Selections
- Date format problem on export to CSV
- Macro for hyperlink -pawan
- Continue line of VBA code on the next line
- Activating / Closing workbook using part name and a wild character
- Time Stamp for specific macro..
- Cope worksheets and save to location
- Hiding Tabs
- C++ to Excel
- IDing cells in one worksheet, find them in another, and copying respective data
- Show / Hide Columns in multiple sheets
- Transfering data to external application
- locking check boxes using a macro
- Redirecting macros ...
- Excel not updating
- Efficient Code
- Excel seems to hang and cause asp script to timeout.
- Size a check box
- Error 91 on Second Error
- SendKeys in VBA
- Link Increments
- removing word for column
- dynamic pull down menu
- If Then Statement in VBA
- How can I automate copying blank worksheet?
- Run-time error -2147319784 (80028018) when executing a simple macr
- copying row information in a table to another location w/criteria
- HELP CONSOLIDATING SAME RANGE EACH SHEET TO SEPARATE SHEET AND RANGE
- open pdf files with a certain bookmark or page number
- VBA to proctect locked cells in sheet
- VBA Function results in #NAME?
- Re: How can I automate copying blank worksheet?
- Step 1: EOMONTH Function
- Sum ? / Numbers with Text
- Removing cell borders on any cell
- Static variable
- Opening Varying Files
- Changing Windows Registry from Excel
- Blinking Cell (Worksheet restarts)
- working with two sheets
- Linking a Summary Workbook
- how to declare Pub Const String Array ?
- "Object Variable or With Block Variable Not Set" error help request
- export cell value - Date Format
- Find & Replace / Loop & Vlookup
- Skipping cells in a Do Until loop
- Deleting all dropdowns...
- active cell issue...
- numeric calculation in logical formula
- Adding to acurrent Excel menu
- Problem with running macro on Mac computer
- Capturing a file path
- deleting rows
- formating military time
- vba for hiding rows
- Getting excel to show mm/yy in Funcation bar like it does in the c
- Transfer data from XL into Access: best practice
- Extracting parts of a cell
- Lacking in Macro Building Skill...
- Message Box
- How can you update an array formula using VBA?
- Open Specific Sheet in Workbook
- sendkeys and the "+"
- Code Problem
- Recording Changes Made to Worksheet
- Copying Chart with Chart Series from Worksheet Name
- VBA code for IF statement with OR?
- Convert '6/23/2005' to '062305'
- incrementing every two rows
- New to Excel Programming
- Enter current time into cell hh:mm:ss
- -Help- Sigh...
- incrementing every two rows--the sequel
- Reference to ActiveX control on worksheet requires full worksheet name
- Toggle change control button face id & caption
- Excel Dialog Box/Sheet
- Find Within Workbook using VBA
- RE: I get #VALUE in the cell - sometimes
- form in excel to be attached to the emails address in the form upon sumission
- Pivot Table Macro
- need some formula help please
- Control disappears from form
- Combining Modules
- Another Error Message
- Excel-Form to file.txt
- Save As "something" then date
- How can I Write this to a CSV File Please
- row location....hopefully simple answer :-)
- treeView -- multiple selection
- How to get a return value from a user defined function
- Don't understand why this formula is not working - Help Please!
- Need to identify a column within a range that meets criteria
- looking for a way to make a form Txtbox only visable on Mondays
- Drop list affected by previous choice
- Variables- Multiple forms
- Input box and carriage return for chart title
- incrementing rows for matching debits/credits
- Anyone know of a way, or have a script, to read a TOC from CD's?
- On Cell change call
- Insert cell anywhere
- make pivottable dropdown work like the filter.
- message scroll bar in excel
- Can one use excel like a chat
- Memory In Excel?
- Create scenarios using macro and data in cells
- Dim mySheet As New Worksheet
- Is there a way to cross data types?
- Limit the Loop to 500 Rows
- Re: Another error message
- Can you print user forms
- Load data into a listbox
- MSCAL.Calendar Excel Cannot change Properties Using Macro
- ActiveWorkbook.Protect password:=range("rangename") does not work
- How do I stop a macro from running within a macro?
- Sum Columns
- Print - Userform Multipage selection
- How to do it...
- Runtime Error
- AddressOf Nightmare
- Off Topic a bit... but to this newsgroup
- Page Selection
- textbox character limits
- Cell Value
- time error
- Button that creates a back up in Excel
- Phone Dialer in XP
- Duplicates?
- Addin Issue
- Copy web query across sheets
- return colmn number + index
- RE: Create Macro using VBA / Macro
- treeview node tag hold array?
- Search a Range for a phrase and Format cell if found
- Wrong number of arguments
- Vary formula based on what another cell contains
- completely Locked Out
- columnshead with listbox
- Restrictoin of xp windows feature
- Please help: Coding Problem
- copying data
- Adding new columns from one sheet to another
- adjust range size??
- Default Printer
- Controls on form disappear
- selecting values form multiple excel files into an excel worksheet
- Num convert to Char.
- Tekst in een tekstfile wijzigen met VBA Excel
- Text replacement with VBA Excel in several files
- Naming worksheets
- Checking if not equal
- Re: Checking if not equal
- To Display a figure while excel is ready to GO!
- How not number ?
- renaming text in cell
- how entries in a column can be put into a row
- CountIF on Filtered data
- "counting" through the alphabet
- Keeping Prying eyes out
- How to supply your own web query
- how entries in a column can be put into a row
- how entries in a column can be put into a row
- Create/Update Excel Objects in Power Point
- Strange Cell Behaviour...?
- Disable Copy
- Check for existing sheet in book
- Copy to next blank row
- 2005 Excel User Conference
- Removal of standard Delete msg from within VBA
- Another way with cell comments.
- How to handle error 8007000e Memory Error
- Cell contain default value of cell above it
- Use of Interior.ColorIndex
- active cell in row
- press button "entra" in web page
- How do I enable the spellchecker in a protected worksheet?
- About NUM to CHAR
- SELECT CASE "Jan-03" confusion
- paste in next availible column?
- command button to calculate two cell values?
- Copying
- I need help with combo box
- automatically go to last worksheet inserted in a workbook.
- Macro Help
- Count if with multiple criteria
- Count number of times a specific number is displayed in cells
- Converting String numbers into real numbers
- Converting String numbers into real numbers
- If then and 2 cell values
- How to return rangename of selection with VBA
- Nesting problem?
- Code Help ^
- Object Browser does what?
- More effective code
- keyboard event in user form
- ClearContent & 'Cannot change part of a merged cell' error
- Max numbers of characters in userform textbox and cell
- Home Stretch! *
- I Know I'm Missing Something...but what?
- Combo box problem
- Save and Save as Function gone
- After Save Event help
- Switch names in cell
- macros or code
- Insert Picture Field
- Macro Still Won't Run in Excel 2003
- Download image in Source.xls and save it as result.xls
- Intptr & Int32
- iValue Stops after 10 cells of data
- TOC in Excel
- prevent event procedure under condition
- Trap a checkbox click
- Excel macro to name ranges.
- SELECT CASE - Which Row am I on?
- delete record based on a value
- Confirming a deletion
- Now()
- Marco for Picuture
- Print only desired rows
- Align Right footer text to Left
- Replacing VBA code strings by using VBA code?
- Something wrong in one line of VBA code
- How do I run a macro program for multiple workbooks at one time?
- Hide/Show Shapes on Worksheet??
- End Of Month Data Only
- Addding a combobox to a workbook?
- Compare between String and Value using VBA
- Consultant In Atlanta
- writing a formula to a cell
- calander control and copy command problem
- F keys don't work, help
- Do loop skipping
- Activating the last active worksheet
- COM and threading in VBA
- Speeding up a Data Validation macro
- copy used range across books
- Union, intersection, join
- How do i set up a rank function on a list of results?
- extract information from a spreadsheet
- Clearing a userform
- type mismatch
- Problem with Remove Subtotal in Macro
- Help with code setting print area
- vlookup for an approximat lookup value
- switching from one window to another
- Menu-Item and worksheet deletion questions
- Using a custom format on the clipboard
- AutoFilter
- Need help for a loop
- Run macro from an excel file from another one
- What type of Array is this?
- Flashing command button
- send msg same as netsend
- Put items in combobox using VBA and toolbox
- Difference between XIRR and YIELD
- Passing Worksheet Names as Variables
- can we shrink images to fit?
- Problem of Crystal Reports in .NET 2002
- Creating a function call from from
- Tabular to CSV style layout
- Database
- Detect if a file is in use or being modified
- Module1 vs Thisworkbook for Macro
- Windows NT - Templates - UDF - Links
- Last row as value
- Linking files with variable directory path
- Module 1 - Subscript out of range error
- Listbox navigation
- Open Lotus 123 file
- Filtering by Cell Background Color
- lock cells for editing-pawan
- If find is true then.....
- declaring a certain value
- Hide columns in a group on after VBA-procedure
- referencing a checkbox cell address in a worksheet
- InStr function question
- Possible to see which user is editting/using file?
- Workbook/Macro/Worksheet Protection...
- Late Binding to Word Variables
- how to run macro after changes in a cell?
- Print Selectd Rows
- Replacing Formulae With Values.....Continuation
- Controlling dialog programatically
- Enumerate form items
- Macro updates
- Working on interactive worksheet (need help with highlighting and blinking cell)
- Setting zoom of 2 sheets equal
- Problem in compiling code containing "$" char
- Howto prevent automatic calculation when open a CSV file
- How to "update" SpecialCells(xlLastCell)
- Invalid watch expression
- while macro is running...
- create named range specific to worksheet
- Else without if?
- During filling Excel Sheet copy/paste in Explorer does not work
- auto expand row hieght of merged cells
- Financial Quarter from dd/mm/yyyy
- Excel 2000 : Error 1004
- msg box
- Comments
- HLookUp
- Having troubles using visual basic to paste info from one workbook to another
- Userforms Question
- Macros Written in Excel 2000
- deleting rows, endless loop maybe ?
- find next? urgent
- Declare at application level
- NOVICE :!! PLS help calling function!!!!
- Cut, Paste and Move to next Row
- Referring to Values in a seperate Worksheet
- ActiveX button on sheet too big
- Export from Access to Excel
- Macro Error
- Creating a hyperlink shortcut in the spreadsheet.
- Worksheet specific code
- Using LEFT in a Conditional Format
- Copy Worksheet to specific row in another workbook
- Create Microsoft Outlook CalenderEvents from data in Excel Spreads
- VLOOKUP statement too long
- Microsoft Script Editor?
- Inputbox Question
- Error message for Imporint External Data
- Data Entered in Multiple Rows to One Column
- Creating First UDF
- I need Help - Importing name files to datasheet
- Macros with hidden sheets!
- writing information from a userform to an excel sheet
- array formula help please
- Disable Paste Special
- Combinations
- Yet another error
- Help needed - seriously (looping? macros? formulas?)
- IsNumeric("121d1") = True ??
- Concatenate VBA results and an * in a cell
- Combinations
- Help with Macro
- Printing
- advanced filter
- Copy data from 3rd worksheets and pasting to active worksheet
- How do I generate a list of 5-digit numbers in Excel?
- Suppress sub totals on pivot table
- Duplicate a picture image into multiple cells
- How do I set a comment in a cell with VBA?
- Abort recursion
- help again function >vector>function
- Dealing with old higher versions in registry
- Delete Rows based on an external list
- More used range Q's
- Runtime Error on Simple Sort
- Looping Through Charts / ChartObjects
- can't update chart series unless its activated
- Passwords
- Need Help With Export Code
- Need Help with copying and pasting with var.
- Timing Issue??
- How do make it a connection of Access Database from Excel?
- sumif / countif question
- creating function with multiple arrays in arguments
- How do I use an Intellimouse to scroll listbox enteries in ExceL?
- clock control
- Best Way To Install Add-Ins
- Can I disable Worksheet_activate???
- How do you add 1 to an invoice number in Excel. Formula for this?
- VBA
- Declaring Constants that can be used throughout the Workbook :)
- Break all links in the workbook
- Insert Rows
- Changing Chart Colors
- Re: Break all links in the workbook
- seprate and store string in arrays
- Exporting data from Crystal Report to Excel - Need soln
- setting format plot area in charts to white(automatic)
- Protect multiple sheets in one time
- Using VBA Replace function for single quote
- Worksheet Custom Properties
- autosave
- Override excel's printing dpi setting
- Opening a file without the macro start menu
- Linking Data
- How to Capture Edit Cell Event?
- Problems closing Excel correctly by code
- VBA help please !
- Split Up Excel Table
- Sales with quarter and annual totals
- Getting number of value changes in column with count of each durat
- Hide And Un-hide Excel Toolbars
- formatting numbers
- Lost Toolbar
- active printer
- 2005 Excel User Conference
- active cell
- Compound File
- Excel Function Bar
- how can i make an excel calculation engine?
- toolbars
- Worksheet_Change(ByVal Target As Excel.Range)
- Links a cell to code
- Product of "time" and money
- automatically insert row
- Finding and Selecting Specific Ranges
- automate copy and paste whole workbook to new workbook
- Query
- How to display all levels in a multilevel dimension when report is refreshed
- Sort Feature.
- List to manage employee code
- Code to hide and unhide columns, with certain condition?
- Date Question, not sure which forum
- Count
- Inserting rows in protected sheet
- Save OL Attachments Programatically
- Change data range in charts
- VBA Macros that don't steal focus?
- Result from a combo box
- AutoFill doesn't work when used in Excel com object!
- putting formula in cel gives #NAME error
- Accessing multiple workbooks through a macro
- Borders Object
- Code for conditional formula
- RE: VBA Macros that don't steal focus?
- dropping whole numbers
- open last modified worksheet
- Search & Replace Formatting for part of cell
- Send cmd to com1 record result to new cell
- writing macro
- opening a folder then creating links
- Clear contents of unprotected cells in entire workbook with a macr
- Re: VBA Macros that don't steal focus?
- Removing concatenates for VBA calculs
- Sub Worksheet_Change(ByVal Target As Excel.Range) Questions
- Search Cells
- Change ABC$DEF into two lines in same cell ABC <nl> DEF
- looping thru the worksheet
- macro to save as
- Type Mismatch
- Complicated VBA Conditional Formatting
- Accessing Windows clipboard during runtime
- VBA Sum?
- Paste Method
- VBA Sum....
- Can't compile, module empty?
- Re: For Each - loop doesn't work.
- can I use GO TO results in a formula?
- Hyperlink HyperTension
- counting folders
- 'On Error' question
- Redundant Subtotal Level
- Subtotals
- Make a macro run automatically in Excel 03???
- Getsetting and Savesettings
- Two problems. HELP
- Array formula and date value
- Automatic running of Macro for the whole spreadsheet
- Macro Exit or Link
- Picture Painting
- worktime function
- Addins causing problems
- Manipulating chartobject while workbook is shared.
- create macro - allow user to scroll down drop down items w/ mouse
- Send Email Based on Spreadsheet Criteria
- Run Once Only
- how do I hard code a variable range for a pivot table in vba?
- Newbie-need menu of names
- Imported data... the incredible growing/shrinking spreadsheet
- Writing to a text file
- delete button is grayed out
- Interior color based on dates
- File Save As Using Macro
- Importing/Exporting Blocks of Data
- Collating data from one worksheet to another
- Export two overlapping charts to .gif
- refering to cell data within a macro
- Cell Activate Event
- SendMail Function in Excel 2003 not working properly
- Accessing file properties
- If statement to stop macro
- develop a macro to perform calculations and plot graphs based on .
- quick lil macro
- Boomarks
- DisplayAlerts (Which Ones?)
- How do I copy an entire worksheet to another instance of excel?
- Before RightClick event change
- Validate social security numebrs
- Reading dbf files
- Looping down a Range to delete entire row
- Excel Paste Special Link
- Catching "no cells were found"
- Macro Listing Question
- VBA code to itemize range names and associations?
- Open files
- append data to other workbook
- Refer to Ranges using Cells notation
- Problem in Excel 2002 vs Excel 97
- How can I identify what cell was clicked on when I click on a butt
- FIND in only one column
- How To enable the Sort function for a protected Excel sheet
- macro to delete a closed workbook
- subroutine to get all of the Named range properties
- Linking code to a cell
- Copy 1-4 sheets to a new workbook
- macro to colour empty cells (cells not recognized as empty)
- Pivot Table - Multiple Worksheets
- Macro assignment disappears
- Check for missing invoice numbers
- =FONCTION(CELLULE(A1)) ?
- Range - > GIF
- running macro step by step different from normal run??
- Read txt file for input error handler
- code to save the whole folder in which is the workbook
- Save & Execution Problem
- code to save the whole folder with a workbook
- Program execution prob
- Re: =FORMULA(CELL(A1)) ?
- Macro to translate values based upon data in another worksheet?
- Help with problems
- Managing Modules/Macros - More than one Module FOLDER?
- Not sure if this can be done in a macro
- Easy Print macro needed
- cell position
- Type mismatch error problem when dealing with Strings
- Mehrere Variablen gleichzeitig erfassen
- Macro to set the colomns width
- Horizontal black line in VB editor
- Returning custom errors from UDFs
- Select Folder - Simples Method
- Select Folder - Simples Method
- define range name, use on VBA selected sheet
- Best way to manipulate CSV files
- inputbox loop
- Able to access VB code on a protected workbook
- AUTOFILL with specific range
- Trap New File name before saving
- creating sheets with names from cells
- Adding a folder
- Autofilter criteria based on cell value
- Date not Saving As Expected
- Re: disable copy paste
- msoFileDialogSaveAs problem
- ClearContents does not work...
- Where is file which contains macro List ?
- Moving a file from one folder to another
- forms
- Send e-mail automatically from excell
- excel2000 pivottable macro
- Change in code to copy formulas 2 other cells rather than first one?
- Creating An Application Event Handler
- SumIF and STDEVIF is there a such thing
- Make Function Public
- VLOOKUP/MACRO using dates for NXT WK
- Comparing Two Cells on Two Different Worksheets
- Multiple VBA IF/Then Statements
- Checking iorAll blank cells in a column.
- Checking for all blank cells in a range orcolumn.
- FORMAT COMMENT TEXT WITH MACRO
- Office Excel Add-in for SQL Server Analysis Services
- Execute a CTRL+ALT+F9 command (Array Formulas)
- organizing sheet
- Excel and IE Active Workbook Problem
- ROUNDing on a MAC - conversion error
- Loop/copy rows variable times to new sheet
- Error 13
- save details to xml
- Trap a checkbox click
- Selecting multiple ranges using 'Cells' notation
- Drawing lines to cells with VBA
- SaveAs defaults...
- ComboBox in a Userforn to display a column...
- Calling sub routines
- Find and copy across multi-sheet work book
- Userform opening
- Major linking problem
- MUST BE A SOLUTION OR WORKAROUND FOR THIS FLICKER
- Create and Rename workbook
- sumproduct error
- How to delete worksheet with specific criteria
- My Sort has Issues
- msgbox as a progress indicator...
- Re: TO Bug or Not TO Bug? That is the question.
- Sheet Name help
- Disable event macro while Auto_open() run
- Filling in Feilds via a macro
- Drawing lines to cells with VBA
- Calculation of row count
- Screen Updating
- Visible rows copy to different worksheet
- Next blank line
- How do i find items selected in a list box ?
- autorow height
- I can't insert a Command Button into my spreadsheet
- Run Macro after initial cell edit?
- export excel plots in to word using a macro
- Do I need a Macro?
- Wait time before next command
- Formular1c1
- Macro for Graphing Current Sheet?
- Marco from XP not working in 97
- CheckBox question
- Getting error unloading Userform??
- Controlling Access with Excel VBA
- Complex problem involving VBA in excel
- Short question:Background picture in excel
- How to convert many dates with date360 with same start date
- Passing argument to Excel
- Coding ? pull information from one Workbook to another
- Formatting a cell
- 2D array to recordset.
- Re: Complex problem involving VBA in excel
- differentiate between a visible and a hidden userform
- ActiveX Progress bar initialization in Excel 2003 problem
- Data Selection using Vlookup
- Excel Making Me Nervous
- Excel Goal Seek vs. Solver
- VBA to Concatenate Two Fields of an Array Element
- I don't want to use Send key
- Re: Short question:Background picture in excel
- Help with copy an array from one workbook to another
- fixing code
- VBA code for cursor movement without leaving scroll area
- Noncontiguous Cells or Ranges in a Formula?
- How do I copy cell values in VBA
- Worksheet Dimensions
- Autofill applying untwanted formats to protected sheet
- info in Excel import into Access to combine multiple records then.
- RENTABLE
- loop through a certain group of worksheets only
- Excel Macro or other script
- Worksheet Exists? Invisible Worksheets?
- Shade col. up to used cell
- Automatic Row insertion code
- create new book and copy sheet into..
- Set a file's modified date?
- Paste Special Values
- Run time error '429'
- Adding to Multiple Column combo Box
- ListFillRange not working
- Help wth arranging/graphing data macro
- OnAction?
- why merge cells in a blank sheet are look as a new page?
- On Error routine...
- Prevent excel from copy the format from the aovel rows
- Dynamic arrays and type mismatches
- Make Excel write a 1 in a cell according to number @ another cell
- How do I seperate a alphabet and number in a cell-in Excel
- Big Question?????
- scheduled hours total
- Running the same macro to multiple workbooks
- Open File or Switch Between Windows if File is Open
- Maximum length of File plus path name for excel workbooks
- modidying a macro for better
- Database Connection