- Find next cell
- Function takes damn long! sorry for @#$#@
- Command Buttons changing size!
- Re: Close Excel in VBA?
- Setting references to OCX's and checking for existance
- copy and paste values from a listbox to cells
- What cell is currently calculating? (custom worksheet function needs to know)
- changing the path in linked files
- Format based on cell value
- ActiveX controls invisible on worksheet
- Reading and deleting a selected sheet!
- RE: Close Excel in VBA?
- Bubble Chart by Macro
- Cell On_Click Event
- Close Workbook #2 Before Close
- Err.Number 429
- Hidden passwords
- Workbook Date last saved
- Adding a sound in a form buttom
- Using Paste Link in a With statement
- Re: Inputbox ??? with buttons
- running macro automatically in Excel
- Combobox
- autosave.xla
- how to update the data from web excel
- Access paradox
- Auto-fill acrobat forms with Excel's data ...
- NumLock turns off with SendKeys statement?
- Drop-down list code - how does it work?
- Help: Two-Dimensional Lookup / Speed
- Random rows....
- DAO - Accessing open Excel file issue
- Knowing where to paste
- Huge Problem with value format !! My work depends on that!
- Locking Shapes
- formula filling a row from another sheet
- IF Function in VBA
- Re: Text Wrap
- Go To line of code in VBE?
- Equivalent code in VSTO/C#
- How to create a bar chart/graph in a VBE dialog box?
- How to assign a DCOUNT function to a userform label
- Convert all cells in a column from hrs into mins
- Header Help
- Merging Documents
- Change text colour with MouseMmove?
- macro for gini coefficient calculation
- COMAddIn.Connect=True fails. Why??
- Status Bar
- If...Then and Loops
- Help me Changing the value to string using quote!!
- copying rows based on text string values
- copying rows based on text string values
- MultiColumn ListBox Resets Itself
- Re: Inputbox ??? with buttons
- Using a cell reference for find?
- Question about sub Workbook_Open()
- free memory from PivotCaches?
- Execute code to format worksheet
- Updating conditional format number 3
- Library not Registered
- Creating a database table from a crosstable
- MultiDimensional Array Output
- Hypelink to TOPIC in .hlp file
- Windows Activate
- Replace installed add-in with add-in with different path, but same name
- Re: Formatting Cell Based on Text in Column Beside It - Round 2
- Re: Determining the screen resulotion
- Session Object
- vba LookA:t::=
- excel vb form - creating error message
- Really need help today if possible
- Recommendations on data entry solution
- Re: Determining the screen resulotion
- Excel Range to JPG
- Code Help
- Re: Determining the screen resulotion
- Re: Determining the screen resulotion
- Run time error '-2147417848(800....
- Session Object
- Is this doable in Excel?
- GetOpenFilename : dir & filename
- Do...Loop and how to end it
- Check boxes
- Run-Time Error '61704'
- AfterSave Event
- Attempting to replace cell value
- Turning Design Mode On/Off
- Looking for duplicate rows in a spreadsheet
- Macro in a macro
- VBA command reference
- Saving as a .csv but with differnet deliminator.
- Select a browze picked file and copy Read contents into a work sheet!
- Hidden Sheets
- Re: Userform help with routine
- Grouping by date
- Is this doable in Excel?
- calculated field in pivot table
- Slow search sped up by moving scroll wheel?!?
- How can I scale up message boxes?
- Auto-generate Hierarchical Outline for a task list
- problem in converting .xls to .csv
- Assign next available number
- Text Box Referencing Cell
- Auto fill
- 2 problems - 1st is most urgent!!
- Clear Data
- replace PivotCache in PivotTable containing calculated fields
- help with weird data range
- sheethidden & sheetveryhidden
- Programmatic access to Visual Basic Project is not trusted
- Add lines, recalculate and keep format
- Help with Macro...Never wrote one before.
- Persistant Alert re: macros
- Help with copying data from multiple sheets to multiple sheets
- Assign macros to button!
- Run Macro Upon Open Workbook?
- How do I add a menu bar to an Excel form?
- Counting number of times a unique record is found
- How to Copy data from One Workbook to another
- List boxes
- Change what was entered
- change named range within macro
- Cell.find
- Excel named column with VB.net
- help writing a macro.
- How to dynamically add lines and boxes to an Excel chart?
- Deleting code
- COM Add-in question
- Re: Running a macro within a macro
- Coping To An Unknown Row!
- Calling a workbook from Fortran!
- Bubble Graph by Macro REVISITED
- Re: Running a macro within a macro
- Changing Directory issue, and Eliminating error messages
- Opening a workbook from Fortran!
- Text Formats In Formals
- Memory Error
- select,cut and oaste cells
- Help writing a macro
- Undo Macro
- Routine for sorting within a selection
- Bad Code
- Open external application file with parameter using VBA
- rowabsolute, columnabsolute of address property
- System Processes, how to allocate sufficient CPU speed?
- Linked cells on protected workbook problem.
- GoTo a different Sub
- Having trouble with autonaming sheets in a workbook.
- List of VB commands
- Macro to delete entire row based on empty cell
- Closing workbook without saving clipboard
- cell,find Part 2
- timer
- Why doesn't this work?
- code doenst' work right, help, please!!!
- Microsoft Word X.0 Object Library
- Web Update Causes Change in Cell Value
- Dialog.Box and drop-down list boxes
- Bubble Chart using VBA
- How to Replace Existing Excel File
- .DB import
- A Faster way to Change value to string using the quote mark
- VBA: Help on run time error 424 - Object required
- Checking a pivot table's cell trigger events
- change all range in chart
- Problem with ComboBox and Tab key on worksheet !
- Filtering, selecting and pasting into new Workbook
- Deleting sheets
- Positioning several values in a cell
- pause macro execution
- I want to paste text from Excel into a text file with the use of a macro...
- Userform options
- Macro disable cutfunction
- Access query
- Using DSUM function with variable "Field", etc
- data format
- Excel VBA on downloaded spreadsheets
- Toolbars and options on OPEN
- Assign Range to Array then use JOIN function
- Multipage form - Help
- Help with location?
- How best to distribute search tools with workbook?
- Deploying macro
- writing a formula in macro
- Adding code to workbooks/worksheets using VBA
- Indirect Function
- ComboBox / ListBox avoiding duplications
- ShellExecute starting new instance of Excel
- Excel to Word
- Re: Control Array for User Form in Excel
- Re: Control Array for User Form in Excel
- Warning while closing the VBA editor
- difficult graph ?
- TOP 15 records from based on industry
- question on digital certificates
- Delete COM files in run time?
- Displaying the range picker dialog
- How to define blanks as DCOUNT criteria?
- New sheet
- stop added worksheet becoming active
- Forcing Text Format
- vbs Find last row and paste
- Do ... Loop
- Re: Adjusting for Different Display resolutions
- Re: Adjusting for Different Display resolutions
- Obtaining Max value from Access DB
- Highlight Expired Date
- Tutorial on Excel VBA programming
- Silly Question
- conditional formatting
- nesting sum(if( help...
- dynamically hide/unhide columns with slider control
- Sort data with command button
- Userform ?? using checkboxes
- Re: Web links from a list box
- additem to listbox
- UserForm Question...kinda, more like just a regular VBA question
- More Textbox questions
- combining data from data sheets..
- sending email through excel macros
- Can XL Sheet be saved from PowerPoint?
- Print Formulas
- Excel VBA - Editing a text box populated from a listbox
- get names of all Applications currently running
- Stop a timer
- Is this a loop?
- Dynamic Delete
- Send mail, need help
- VBA Count Function
- Reference Library 97-XP
- Disable Tools
- Call Macro in Other Workbook
- Trapping??? OR On Error Resume???
- Search code with a twist.
- Running an Excel macro using VB
- Changing sheet name and adding new sheets in OWC XP
- Copying works when sheet is first blank but won't after that.
- opening an access form from excel.
- Cell Selection
- Re: Running an Excel macro using VB
- Pull Access Data into Excel
- RE: Pull Access Data into Excel
- Pop up clock to enter in the time
- Re: Creating formulas
- Insert an empty Row in Excel
- Creating formulas
- RE: Creating formulas
- "Find" Macro
- charts
- Use String in place of Object
- Delete Sheets in workbook when saved
- VBA loop will not copy new workbook after about 100 times.
- Pivot Table Updating
- Cell formulas & ScreenUpdating property...
- range selection
- copying formats
- Big file?
- Form pop up location
- How to swap rows - rapidly?
- pdf to excel
- Update Links
- Replace string with input by Pop-up
- Help
- PasteSpecial macro
- new silly little problem
- VBA Hangs on Unlocked Cells When Protected
- Macro doesn't work with arguments
- making only certain numbers increment in formula
- Excel VBA .pagesetup property runs very very slow
- Problem: Checkbox moving after Print Preview
- How to make the opening a workbook conditional upon the value of cell in another open workbook
- Excel 2000 Deleting Column A
- Excel VBA - Userform Textbox problem
- rename workbook?
- Excel - Help With A Project
- Multi-Column Combo Box
- Reading data from a non-opened sheet
- Auto-Select Range
- Recalcuting formulas and automatic loading
- Deactivate number formatting?!?
- Produce an error message with if statement...?
- Having problems with multiple If - End If Statements
- Is this worksheet protected?
- embedded chart vs chartsheet detection
- How can I get the value of a Combo box on an Excel worksheet?
- Combo Box
- VBA code as stand-alone
- Hilight new index items
- Command Box
- Help with macro on displaying
- Carry a varible to a new routine
- Changing a Cell Value in Multiple Sheets
- looking for form approach suggestion
- keeping top 3 rows static?
- problem with copying worksheet
- Calculating hours between a shift time to include core hours only
- Deleting row dependent upon drop-down list value
- Public variable in userform
- Input box size
- VBA Reference Guide
- For- Next with named ranges
- Why does code cause "lockup"?
- Deleting Excel Pages with Macro
- Worksheet_change vs. worksheet_selection_change events
- Delete Chart
- Copying a block of cells within a range of cells
- Calendar Control
- I know this is the wrong group but.........
- CLOSE MESSAGE BOX PROGRAMMATICALLY
- Automic Email without opening excel
- Font size in the Animation Assistant
- Search between worksheets in same file
- DropDown Control
- Find Last Cell For A Named Range
- Command Button
- ? about File SaveAs procedure in Addin macro
- learning from Add-ins
- How to refer to cells with a variable ?
- Find data on separate worksheet
- Open Instance of Excel
- Auto execute macro on cell entry
- Formula or Macro to count non-matching values
- Application status
- Modifying John Walkenbach's Data Entry form
- Userform? to step through row/column data?
- Any solution suggestion to this complex macro problem?
- Change Caption in checkbox
- How do you reset a userform?
- problem with list box
- re-calculation
- Assign Macro to button
- String not working
- reformating data for Excel pivot tables
- Help with colour changer
- Change case
- Assigning form fields to cells in VB
- Input Box: Accessing values on spreadsheet
- Add several Ranges to a Listbox - pls help with this code
- Call macro from click on shape (COM add-in)
- Query to pivot table
- Unique Descriptions
- Formula Code Help
- Hiding cell values in Excel 2000
- Speed up Autofilter deleting rows
- Q. If I wanted to calculate a number with 300 digits, could I use Excell?
- Using Radar-type plot in Excel; question!
- Rename worksheets using vba
- I need help
- Another question on selecting cells from a range of cells
- Changing File Names
- Merge Cells
- Calling Procedures In Another Workbook
- How many WS columns are possible
- Need help with controls moving after print preview.
- Works on XP but not on NT???
- Slowing down Loop process
- Macro needed to replace conditional formatting
- using variable names in series data values
- Display Only Last 4 Characters If A Cell
- Trying to use CDO
- importing excel sheet (with date field) to access database
- How Do You Call Several Named Ranges From A Named Range
- Comparing Column Data
- Copying Pictures from Book to Book using Code
- How to Open a Hyperlink
- how to execute a vba function automatically when openning the excel file
- VBA: Help on DCOUNT function without specifying field
- How to get the "My documents" absolute path?
- Difficult data select for analysis
- Clear cells resulting in div/0 or zero ?
- Max. number of rows in Excel 2003
- ranges and sub range
- opening a worksheet from another Book
- Messagebox which allows the user to scroll through the sheet.
- Multiple Match
- Capture the Outline Show Event... that is if there is one.
- reformating data for Excel pivot tables
- Program - Novice
- Decimal places in textbox on userform
- Value of last row record
- GetSaveAsFilename: run-time error if not wanting to replace
- Delete Multiple Sheets
- Name Range Outside Range
- Delete Multiple Sheets
- Name Range Outside Range
- problem worksheetfunction Match
- How to create a loop to perform same set of action
- Opening Powerpoint from Excel
- Getting values of pagesetup for passing arguments to xl4 page.setup function.
- Match problems.
- Urgent: How to prevent opening Excel file that contains macros
- Coloring of Rows
- Excel Automation Using Visual C++
- VBA UserForm ComboBox Problem
- Update DBF
- Excel vba - Adding a command button control at run time
- Comparing rows of data in two worksheets
- Re: How do you say in VBE language to go to the last filled cell?
- macro running
- Query range
- Modal dialog box freezes browser
- For ..... next loop for changing button captions
- Formatting Cells via Macro
- Open Windows Explorer from Excel
- Reference Library Conversion Question
- how to automatic print a worksheet when a cell condition occurs.
- open word from server
- auto time entry
- Delete unused/part used rows?
- Re-post: Outline Event
- RE: Pull Access Data into Excel
- Automatic Zoom
- COMBINE CELL VALUES
- Progress Meter
- Save
- Go to next available cell
- Application status
- selfcert exe
- Re: macro warning
- Re: macro warning
- Re: macro warning
- comparing 2worksheets
- Worksheet_Change with validated list data
- Excel VBA - Delete toolbar
- Sum for multiply user added sheets.
- Excel references and Intellisense with my own Class Module
- Problem> prints first page twice from vba
- Excel - shared workbook
- Macro to open hyperlink
- opening access form from excel
- reformatting excel data for pivot table
- Looping through files in a folder
- Looping through files in a folder
- Re: icon disapears from tool bar
- Clearing Pivot Table from Memory
- SQL Average Function help
- Mergeing information from 2 text fields.
- Missing Custom Menus on Network
- Variable assignment from cell value
- unprotect befuddlement
- Adding Sum Formula to Footer
- Random numbers - Help, please.
- Excel sheet with macro Type Mismatch #13
- Opening database in XL VBA
- Error message on Average
- Passing a 2D Variant Array From VBA to a DLL
- RE: Clearing Pivot Table from Memory
- Bypass "Run Macros" Message
- Changing Module Name
- Adding code to worksheet
- deleting a file programmatically
- SQL Server data to Excel 2000
- Scroll behind an InputBox
- Page Layout
- Listbox with cloumns
- Error when openning a recordset..
- Adding a back button
- Macros Help
- ActiveWorkbook.SendMail truncating filename
- help with a code
- Change Event Problem
- compare data in two sheets with duplicate rows
- Array Max
- Having trouble
- Run time error '1004'
- file connection
- How to delete my excel file in a network
- macro scheduling
- Re: basic question
- Re: basic question
- Re: email from excel...help!!!
- event procedure
- Making a Hide/Unhide Toggle button
- Array Problem
- Excel ADO recordset
- Accessing ORACLE DB w/ADO
- Outlook (bypassing security) and CDO assitance.
- Run-time error 9
- Help with Find
- Setting Combo box Range for Worksheet Control
- Possible to write COM add-ins with VB .NET?
- RE: Clearing Pivot Table from Memory
- Execute SQL procedure with parameters
- Question Regarding ShowDetail.
- 12 conditional formats on dates
- Email Reminder from Excel
- delete row macro in xlXP
- Cells.Find Part 3
- Erratic Sort in Excel 97
- Printing to Printer
- Excel SDK: Finding array formula bounds
- is this normal
- automatic macro
- Protect Sheet Disables Custom Command Bar
- VBA find from 2nd excel sheet back to 1st sheet
- get username
- Creating a database within my template
- Adding functionality - Deleting row in Named region from ListBox selection.
- Activating a Worksheet with a changing name
- Create cmd button on spreadsheet to run Macro
- error on excel.exe
- VBA test for circular reference
- pivot table vb code - how do I restrict access to dropdown box?
- app events and drag-drop
- CopyFromRecordset Bug with Office XP
- Update DBF (Re Post)
- VBA for hiding row & column headers
- Sending an e-mail
- Cannot Paste a 16x16 Picture into Excel
- Pasting picture in Excel increases size (Pasteface, Custom Button)
- Help Plese.
- Prevent user selecting cells
- Re: Help Plese.
- preventing access to the vba code in an excel workbook?
- values of an interval of cells HELP ME
- Reading data from word tables to excel
- Printing question
- Shorter code
- How to suppress the Outlook Security Warning Screen?
- Finding last column
- How to detect and delete empty rows in a list?
- VBA - compare cell against column in diff sheets
- External Workbook Help!
- delete row
- Extracting data from a chart
- How to automatically add Toolbar buttons and run add-in?
- Macro Fails in Worksheet
- Lookup in multiplesheets
- Changing Checbox Values on UserForms
- Last row
- macros not firing: XL '97 vs XL 2000 vs XL 2002
- 16bit number split into bits
- Change from Check box to Option button
- Excel VBA - create worksheets/dynamic range names problem
- Copy with Advance Filter
- SendKeys question?
- Transposing cells & deleting sheets
- Compare two strings with same characters, but different order.
- Customised Toolbar with Macro buttons
- Replace text string
- Range veranderd bij knippen en plakken
- to:Bob Phillips- don't answer if u don't know what ur talking about!
- Have pulled out the last hair on my head
- Trying to get data from SQL Server (MSDE) database with Excel 97
- Solver in VBA
- How to make Excel 2002 to automatically update worksheet names in hyperlinks?
- convert string to date
- Expanding the Name Box
- Copy to Clipboard Questions
- Macro to password protect several excel files in same folder
- VLookup - which cell am I looking at?
- Passing arguments in gosub routines
- Excel Project and Libraries
- FormulaArray question in VBA
- Fractions of a Second Problem
- Not thisworkbook, but the other one...
- how to check is catalogue exists
- How to position at the end of inserted pictures?
- Overloading builtin macros
- VBA 'Newb' - Output to one FreeFile on multiple events?
- Dynamic Chart Scale
- Workbook not opening
- Protection
- Re: Compare two strings with same characters...MY APOLOGIES
- Time example
- SUMPRODUCT in VBA... conditional sum
- how to link workbook to invoice?
- Which Object Library for Office 97..? 5.0 or 8.0?
- Getting #REF error on copy/pasted cells with macro!
- If function
- Merge Workbooks
- Transpose
- howto use range variables in functions
- Create Live Cell Reference
- Linking between workbooks..
- Userforms
- On workbook open
- SYTAX problems
- Fill empty or blank cells in selection with a prompted value - an example
- Re: formulas with relative cell reference
- Saving to Network share with different mappings?
- Not very efficient
- autofilter/programming?
- Error Handling
- Public/Private
- Re: How to delete all graphical objects in a sheet
- FileExists filename wildcards
- Disable Ctrl and/or Alt Key
- Why Excel plotter doesn't accept zero's row?
- Re: How to delete all graphical objects in a sheet
- Text box for password
- Starting Dialog Box using Macro
- UsedRange/Copy Columns question
- VBA question please
- Excel / Windows XP question
- Using Cell Value to Determine Which Macro To Run
- Links between word and excel
- "Save As" macro
- Using VLOOKUP in VBA
- writing array code
- Protect code/cells using Function/DLL??
- Don't save changes when user closes WB
- Problems Opening Workbook after running macro
- Excel 2003- "File Error" data may be lost
- Excel Menus Removed
- Userform Cell Link
- List boxes
- Refreshing Data Query
- Automatic Currency Exchange Macro
- Chosing from a Calendar
- Displaying different ordered items under the same order.
- USERFORM: default possition?
- URGENT WARNING: CIHOST.COM - TERRIBLE SERVICE - DON'T USE THEM
- Eliminating a Warning MsgBox
- Closing Excel
- Hidden Cells in formulas
- Couple of VBA Questions
- Calling a userform
- Running a MS Project Macro in Excel
- Hide/Unhide Rows based on ComboBox
- Old topic, new post
- how to check if Worksheets(x) exist?
- Opening a CSV text file using OpenText function from an MFC application fails
- VBA: Setting the color of borders of cells
- USERFORM: static
- VBA: How do I switch to landscape?
- Sort calculated field in a pivot table - an example
- VBA run at upon opening
- Help with cell formula, please...
- A big thank you
- Excel VBA Problem
- relative cell reference in a VBA macro
- showing a Userform from another workbook
- look up and input
- Edit/Replace that preserves in-cell formatting.
- Need Help with Next thing
- VBA Summations
- Excel macro error when opened in internet browser
- calendar picker
- Worksheet_Change
- Reducing text beyond =left or =right?
- 12 Conditional Formats based on Dates
- Shortcut Key
- Doble click a cell and running a macro
- Selecting a Time in a cell w/out inputting the data
- Re: Group counting
- group counting
- Name a new Sheet but delete if it exists first
- Converting many lists into one
- Excel SDK: Select a blank cell
- Find several names at a time
- Parsing based on content
- Get optionbutton status
- links
- Help with Modification of code
- SQL Query Without Worksheet Object
- Replace command that preserves in-cell formatting.
- code doesn't work
- Disable Zoom
- Code Modification
- Any sample/tutorial VB6 excel COM-Add-in?
- user form deactivation
- How can I conditionally select multiple rows to be moved with vba?
- Error In Code??
- Re: Group counting
- NONE
- Exporting sheet as text without modifying workbook
- Calculate cell formula changed by VB
- Error 1004 ...
- Show Picture in a pop up message box in excel 2000
- Day and Date Validation
- Macro
- Event Study with Excel?
- COPY/PASTE NON-ADJACENT COLUMNS
- Remove code module automatically
- reformating merged cells in a protected sheet
- chartobject
- Crashed Excel File
- Test to see how many worksheets are open and closing active worksheet
- Drop Down List
- Slow code execution when Excel 2000 is in the background
- Showing a userform
- Printing a file from Windows Explorer using VBA in Excel
- simple code
- How to select some sheets to print with VBA (Based on a user's choice)
- Getting code/button to run/execute
- Datavalidation - dropdown
- Saving lots of files to different locations
- creating dynamic ranges and charts
- Code for Multiple Workbooks
- No data was selected to Parse Error
- deleting Macros en masse
- sumif from an array
- macro runs very slowly
- how to disable a macro by calling it from another macro
- Excel 97 popups
- Calendar
- View Access Reports in Excel
- #ERROR Trapping
- Auto format textbox as mm/dd/yyyy
- Format year problem
- new line
- Format year problem
- chartobject
- COUNTIF help
- Margins ' Default ' settings
- Disable WorkSheets Change
- refering to a workbook
- For ...Next loop help please
- VBA newbie - How to make active cell frame invisible?
- Re: Hide Empty Rows.
- ActiveX Check Box Question
- How would I do this? Updating one worksheet from another...
- Return To Home
- remove header from userform?[blue bar @ top]
- Change Event is looping indefinitely!
- Summations
- delete entire row if present a difference....
- Protection and hidden
- Find Total but not Grand Total
- Disabling Excel functions
- Code modification
- Error 55- file already open
- Recent Microsoft Excel Updates - March 24, 2004
- Count function
- range with dim select
- Insert new row after every other row procedure - an example
- Trap Close event at worksheet level?
- Re: Convert to text
- possition of userform change on event?
- Copy Data from Various WorkSheet.
- Still having problems with building a Database
- Setting ListIndex = 0 does not change Listbox.Value on activate
- Re: Is'it possible in Excel?
- Stop macro if not in correct workseet
- Re: Is'it possible in Excel?
- numberFormat
- Sheet Exist?
- Open dialog box and browsing in Excel
- Removing Modules
- HELP: How do I program in VBA formulas
- Re: Is'it possible in Excel?
- Copy the active chart double sized
- Trig in degrees not radians
- Can I run a MS Project macro from Excel?
- Userform Selections
- Worksheets
- Re: Trig in degrees not radians
- Last cell in column