- Japanese Excel and English
- Wrong output
- Separating one large workbook into several smaller workbooks
- Is it possible to run DOS commands in Excel?
- General Mail Failure with SendMail
- For...next in reverse
- how can I put a cell reference in a header/footer?
- Please help!
- Again about Row Highlighting [HELP]
- For each...next reverse
- Error 1004 update autofilter and pivottable
- Excel/Visual Basic
- for each...next in reverse
- Excel/Visual Basic
- Quick question
- Delete Rows Based On Content
- Excel/Visual Basic
- Returning the range name in VBA
- Performance issues, looking for alternate solutions
- Wrong output
- Delete Rows Based On Content
- Returning the range name in VBA
- Selecting a cell value in VB for a Query Table
- Returning the range name in VBA
- Range Names
- Error in Sending Email via CDO
- Exporting data from Excel 2003 to MS Project 2003
- Sorting by date, then calculating totals
- on mouse over
- Interface not supported
- Locking Protection on a Spinner
- Using Protection on a Spinner
- Linking different workbook
- Linking different workbook
- Macro expires
- Message: The macros in this project are disabled.
- Excel filename command line parameter to VB
- Weird Excel problem
- Sorting Sheets in a Workbook
- Exporting charts as GIF - error
- Exporting charts as GIF - error
- Sorting Sheets in a workbook
- Sorting Sheets in Workbook
- Sorting sheets in Workbook
- Saving Excel document blows up Infragistics menu in frame
- Could really use some help with this macro.
- linking spreadsheet nightmare
- Dynamically generated content
- Can I slow the rate that VB executes individual orders?
- Command button - won't execute twice in sequence
- Changing source for series collection in charts
- What time is it in New York?
- Sending Outlook mail through Excel
- Re: Copy continual, refreshing records to a new sheet
- command button-print
- Pulling Data from Range
- Goal Seek macro
- Help with VB script please?
- How to import multiple image files into spreadsheet
- Turn off Excel's 'want to update info?' prompts
- Progress Bar
- Dynamically generated content
- Maximum Number of Rows to import
- Maximum Number of Rows to import
- Maximum Rows inan Excel Spreadsheet
- unique file names
- Text Import Macro Help
- Multiple "With" commands - Please help
- Book Recommendation??
- Dynamically generated content
- Multiple "With" commands - Please help
- Complicated macro needed (please)
- Left string in VBA
- Getting Access Error Messages when running Access through Excel
- Cycling through form fields
- Compare & Delete in Excel
- Problem Organizing Macros under XP
- SumByCellColor
- Problem Organizing Macros under XP UPDATE
- Forms that open from forms
- Checkboxes in Shared Workbook
- inputbox vs. userform/combobox vs. Windows file handlers ???
- Excel macro running out of memory.
- copy range of cells using VB
- Excel 2003 should have the auto save add-inthat was available prev
- Wie kann ich einer Zelle eine Hintergrundfarbe zuweisen lassen, w.
- A beginner needs help with Excel and VB
- Date Function in VBA???
- VBA Formula Question
- In Excel 2000 - is there any way to set up a cell to repeatedly a.
- Returning the range name in VBA
- Web Interface Brain Buster Problem (for me at least :)
- Cell bordering
- textbox validation
- Application-defined or object-defined error
- Excel active sheet's Textbox size limit
- Combo box to filter
- Selection based result formula
- Get bytes from file
- What macro is executing?
- compare and merge 2 sheets if columns same
- Locking Protection on a Spinner
- can you insert an object into a cell
- How to force userform to display everything?
- DTPicker not working in Exel 2000?
- Entry of data in formula bar ignores cell percentage formatting
- Strange Formula Request
- right click menu
- Accouting & Database
- Turn off Excel's 'want to update info?' prompts
- Changing a formula using a variable...
- Calculating the difference between hours
- Range ID not saved
- Why does my AddIn do OnConnection() twice?
- Find last cell with data
- how to union two array with same structure
- xlChartType
- xlChartType
- Image control
- Linked WorkBook ... TabSheet Sort?
- Filling Down Automatically ?
- Cell Links for Option Buttons
- Runtime Error
- flagging dates with conditional formatting
- Point Scoring Using Substituted Numbers
- Replace dot with commas
- Help with workbook path
- Break up a text file.
- Problem with displaying characters in excel sheet
- Use Windows Network logon as password
- Excel 97 to Excel 2002 :problems!!
- Macro to control screen saver
- VBA Code to save to 2 locations
- Small DB in Excel
- VBA coding of a Logit regression
- How to protect several columns and allow refresh query
- Slow code operation when refering to different sheets
- Macro to group outline
- VBA Coding for Logit Regression.
- VBA Code for Logit regression
- MS Outlook Item.Send - How to remove the popup message?
- Change Cell-Background color into Text
- Compare & Delete in Excel
- import date field from access into excel
- Could really use some help with this macro.
- Creating Directories
- User input as a range
- Excel 2003 Object model for Excel 2000
- import date field from access into excel
- Alternative to ...For Input As #1
- Finding MIN, MAX, and average
- Shortcut Key
- VBA - Run Macros Remotely?
- computational convergence
- Chart - conditional formatting
- Convergence
- Summing rounds answer to
- Printing Multiply Workbooks from one Excel Workbook
- Macro to activate VB Code
- Could really use some help with this macro.
- Protecting part of a Spinner
- Keyboard Shortcuts
- chdir not accepting string for path
- coping rows using a loop... please advise
- find from Excel VBA a text file last row
- Macros/VBA to fill time card
- Macro Removal
- Worksheet with Macro
- Selection Too Large
- Macro Removal
- check if cell is hidden
- find out if cell is hidden in if statement
- Excel Interop > ActiveX>SEcurity exception
- deleting file(s) by their file extension
- rename macro
- Functions don't work anymore!
- Sharing macros - extreme newbie question I know.
- error 429: ActiveX component can't create object
- Need a Macro that will sum Values in a Column that are red
- coping rows using a loop... please advise
- How do you get a pivot table to do server-side processing?
- Sharing macros - extreme newbie question I know.
- Fill Series with Step
- Identify duplicate values
- Excel file with macro not visible
- Blank rows in a filtered list
- Easy VBA Syntax Question
- Change Cell-Background color into Text
- Disable Workbook_Open() Macro
- application.volatile activation
- Easy VBA Syntax Question
- Target Frame
- Moidule Line # continued
- coping rows using a loop... please advise
- Break out data into tabs
- VBA Code to save to 2 locations
- Export data from Sybase into Excel 2003
- Importing Text file into Excel 2003
- How to do this?
- Compare two worksheets using VBA in Microsoft Excel
- coping rows using a loop... please advise
- Saving a worksheet with links
- Bigmatrix Addin
- Re: Copy continual, refreshing records to a new sheet
- linking ActiveX Controls to perform function on another control
- lock up rows w/dates diff than current year
- Returning values from a multiple chart series
- Logic test
- Compare two worksheets using VBA in Microsoft Excel
- Excel Data Validation
- Cell doesn't do calculation until you force it.
- Averaging last 8 weeks
- Stumpt !!!
- Application exception occurred:
- avoid access of hidden sheets
- Saving a worksheet with links
- To count an alphabet in a cell
- Help with Time Calculations
- Could really use some help with this macro.
- Problem with writing CString Date to cell
- Newbie Q: OpenRecordset from Excel
- Extract full path given filename
- Use full page
- Create Subtotal Macro
- Form Doesn't Disappear
- Auto_Open - Prompt to Continue?
- Handle Compile Errors
- Run-time error 1004 and SR-1
- Istext function
- Function to check to see if cell has hard coded data in it
- Hmmm... Excel OVERRIDES vpagebreak and hpagebreak vb code????
- VBA or Macro to Update Column
- VB UserForm to MS Access
- path
- Lookup macro?
- How to delete rows with repeating values and leaving only one with highest value on the next column?
- Change the colour of a bunch of cells, based on one cell.
- TextBox1.value=TextBox2.value-(TextBox3.value+TextBox4.value)
- Hide calculations during computation
- Pause a Macro?
- Kind of like offset.....
- Flag Earliest Dup
- Powerpoint -> Excel conversion
- some problems calling components :(
- change color and protect rows
- Newbie question: clear contents in first column of copy-pasted row(s)
- Creating excel files using VBA
- Help - Download Stock quotes from Yahoo! (long history)
- Any Idea on how to modify this code relating to query???
- My addin function wont run twice.
- Hmmm... Excel OVERRIDES vpagebreak and hpagebreak vb code????
- formatting problem
- Error only without references
- Help with run-time error, please...
- pivot table
- Counting Unique Records
- Excel Addins - Index or key
- formula for automatic numbering the records
- Prevent selecting locked cells
- Worksheet views
- Please help - expected record status "missing"
- #Name for user function
- Excel Addins - Index or key
- Excel Addins - Index or key
- Macros - Relative cells in Excel
- formatting text/number in a command
- Copy layout to all worksheets
- Calcultae % with empty cells
- Excel Addins - Index or key
- Runtime error 1004 - when I increase the amount of data
- Compile error when running a vba script.
- Horizontal scrollbar in ListBox
- Determine version of .xls file from VB6
- Editing Module thru VBA
- Contiguous Column Selection using variables
- Buttons not to be printed
- Sending an email
- Current path to Qualified Path
- UDF was not being calculated for all cells
- Proper Syntax Sought For NewBie Excel Programmer
- Add Worksheets
- how to list all validation cells on a sheet
- TextBox1.value=TextBox2.value-(TextBox3.value+TextBox4.value)
- Creating Directories
- Desktop Shorcuts
- Add autorecover to excel 2000
- Sum Based on Cell location in Column
- VBA Object Browser icons key
- Converting text data type to numeric
- Shortcut menu help
- How do I insert a row and keep all the formulas in the cells?
- Can not change the numberformat
- How to print last page of sheet?
- Filtering results
- Having a problem getting Excel to work from my .Net VB Program
- microsoft excell
- addin problems
- Programmer for hire needed
- This may sound stupid.....
- inputting (x) triggers input of 1 through (x)
- lookups
- Collapsing a table
- Formula Range
- Check if DLL is registered
- How to fit a "ln" function
- Forcing case
- Filtering results
- check protection
- change faceid
- Excel window will not exit.
- So simple I can't find the answer!
- VBA - Combine Workbooks
- Blank rows in a filtered list
- Application.Quit
- Filtering results
- is excel by itself enough to do scripting?
- How do I select on a SQL Datetime field in Excel Query?
- Excel VBA Loop & Variable Reference
- Moving from one Excel File to Another
- help with textbox change event
- Cycling through variables.
- copy paste with min data transfer
- CopyFromRecordset with large amount of data
- compile error Next without For
- E-mail Macro
- Creating Drop-down menus in Excel
- For Each with Select Case
- E-mail Macro
- Alphabetizing and Grouping
- alphabetizing and grouping
- Make a cell mandatory before sending
- Huge File size after import
- Hide calculations during computation
- summing a range in a closed file
- Huge File size after import
- IsMissing()
- Retaining the ONE most current dupe...
- Excel table function
- Using for next with two counters
- list of proprties and methods
- VBA Code to change color of field based on entry - query also.
- Next function?
- VLOOKUP
- TextBox1.value=TextBox2.value-(TextBox3.value+TextBox4.value)
- For Each with Select Case
- Conditional Statement?
- For Each with Select Case
- Working with Comment objects in VBA
- Combining 2 Ranges in a Single WITH Statement
- assign value to cell in another worksheet
- some problems calling components :(
- Cannot dropitem from multiselect listbox
- Protect Excel sheets with Password Using VBA
- I dont know if this can be done
- I dont know if this can be done
- How to hide excel?
- hide a row
- multiple outputs
- Printing question (VBA)
- How to save a vary filename by Macro in Excel?
- run macro text missing
- Toggle CommandBarControls msoButtonDown/msoButtonUp
- Copying rows with spesified data on one or more columns from sheet/file to another?
- Strange Title Columns Print Issue
- XP activesheet.paste error on VMware servers
- how to count/sum by function/macro to get the number of record to do copy/paste in macro
- Function calls a Sub to change the cell font color
- Deleting shapes
- userdefined trendline
- Print_Area link problem
- How to hide excel?
- How to add UFD arguments description?
- handling the print to file prompt
- Using Excel to extract data from SAP
- Excel Add In - Limited Use?
- Custom face on a button without using clipboard?
- Visual Basic Getting confused with Dates
- Date format problem following cut/paste from Access
- Edit Mode
- Copying a sheet to a certain position
- Automatically execute a macro
- Inputting numbers only in Text Box
- Workbook Open Event does not fire
- multiple combinations
- Custom button face without clipboard?
- Custom face on a button without clipboard?
- Filtering results
- Using ADO CurrentProject in Excel
- Edit Mode
- Macro dependent on hidden sheet?
- how to store a value generated in a sp sheet
- Time Clock
- Macro to Open all workbooks in a folder and change default font
- Excel Add In - Limited Use?
- call sub
- macro for printing pivot charts
- graphing in excel
- Comments to help Users
- Using "GetString" with ADO
- macro to delete rows
- macro to delete rows
- Moving data from Excel to Access
- On Error Goto doesn't goto
- Auto Update
- On Error Goto doesn't goto
- How to apply changes to many WBs in one go?
- Programmatically Creating Worksheet Event
- Program to change the Excel cell to a different color.
- IsMissing()
- Excel 2000 sp3 problem with vba and Solver AddIn
- selection by values
- Numberformat in ADDIN module doesn't work.
- combo Box programming
- count the occurence of number in a column
- How to pass parameters to excel from web?
- Writing to a file from excel
- Conditional Formatting Columns
- Macro to Record date workbook is first opened
- Running macros
- Trouble call VB ActiveX dll from Excel
- Extracting variable sized strings from binary file
- Conditional Formatting Columns
- Goal Seek
- Sorting problem
- Appending to workbook and worksheet
- Excel 2002 VBA - my toolbox controls have dissappeared
- Create toolbar take long time
- Comparing two lists
- using VBA to rename active sheet
- Erzeugen einer Excelinstanze verursacht Zugriffsverweigerung
- Comparing two lists
- Total question (macro?)
- Conditional Formatting Columns
- Applying styles in VBA, then pasting into Excel
- macro - hiding rows given a cells content
- Comparing two lists
- copying page with VBA
- Solving for a variable multiple times
- Comparing two lists
- Using "GetString"
- Sorting problem
- Sorting problem
- spesific fonts for headers&footer is Excel
- permission denied while drying to create a excel instance
- Intercepting a Tab on Entry
- Scroll the window to the top - frozen rows
- how to excel with more features?
- Bottlenecks in an Excel VBA application
- Select Case from Text Box Input
- Web Query and Dynamic web address
- Document a .xla file
- Active Cell
- Formula too BIG Excel 97
- Web Queries & changing URLs
- Web Query & changing URL's
- web query & changing URL's
- Devide/0 error
- web queries & URL's that change
- Help with commission form
- I need some Advise
- Open only existing Excel Files in a given Range
- add text in a chart
- web query & changing URL's
- web query and changing URL's
- web query & changing URL's
- I need some Advise
- Combining 2 Cells and retaining format of each?
- opening a file that will have wildcards in VBA
- If then statement with two true conditions
- VBA excel + Forms : Vlookup on database by form / VBA excel +
- web query & changing URL's
- data validation question
- web queries & changing URL's
- copy down
- web queries and changing URL's
- Re: Scroll the window to the top - frozen rows
- Limiting view area to user
- Change Icon
- Limiting view area to user
- pivottable page fields
- vba on vba
- Web Query Run-time Error
- Web pages that run an excel spreadsheet
- Help please - how to run Solver in a protected sheet?
- FindNext
- sum a salary column using macro
- date out of control
- how to know which row to append for the last row
- how to paste to last row in another sheet
- Cell Position
- Changing value of chart axes based on the minimum value of the plotted series
- Colour of Precedent arrows
- Excel Add In - Limited Use?
- Hiding Macros?
- remove add-in entry via registry
- Turn Off Macros With Workbook Open
- Block saving using dates
- sheet event does not recognise Tartget
- search rows
- Rounding Percentage
- can't find a correct formula
- Treeview save Data reload, Speichern der Daten Excel VBA
- User Form Help
- Disable auto xlmsgbox, replace w/own
- How to connect to iSeries and run a query using VBA
- chart graphing
- Sheet Protection and Book Recommendation
- Paste value of Find
- dragging userform
- Copying to another worksheet
- String problem.
- Boolean formula for Conditional Formatting
- number formatin XL 2000: mixing alph.chars.& numbers
- Macro to edit existing formulas
- object variable or with block variable not set
- 1. Selecting multiple items from drop listbox
- Close workbook with "Cancel=TRUE" in the BeforeClose()"
- loop to insert rows
- loop to insert rows
- debug message pops up when I select a range of cells and delete
- UserForm Toolbox displaying
- Unprotect workbook
- Excel->Access OLE Error
- object variable or with block variable not set
- Macro causes "Do you want to replace the contents of the destination cells"
- Message Box position
- how to combine items in 3 columns and produce all combinations usi
- Adding a 3rd IF statement ??
- sumproduct or countif
- closing boxes
- Help Please
- Help Please
- Adding a 3rd IF statement ??
- "Immediate Window" displays strange code!
- Workbook open event not firing (both 2000 and XP)
- dynamic rows
- Valdiation
- Calculating the difference between hours
- Calculating the difference between hours
- RefEdit causing crashes
- add-in installation Inno setup file
- Pivot table
- Search Code
- Data from multiple variable length columns to one column
- MACRO question
- Trying to adapt progress meter
- simple loop macro
- Auto_open & Application.ontime in shared files
- Removing commas
- creat the records based on the values in another sheet
- simple loop macro
- simple loop macro
- Moving groups of cells with mouse
- simple loop macro
- ByRef strangeness
- Help Please
- print scaling
- formula or macro
- Copying Macro help needed
- VBA Code to add date
- Moving groups of cells with mouse
- Moving groups of cells with mouse
- Help Please
- round to ,5
- security
- Crete an An Account with regular withdrawls with a declining bala.
- Still stuck
- Array Sheets Copy to new Workbooks
- cell security
- Place a check box at a particular cell
- Email and if statements
- VBA Code to add date
- Pivot caches?
- VBA Code to add date
- Generic Name for ActiveRange in VLookup
- Saving as a specifc file name in increments
- VBA project does not close when workbook is closed
- VBA project does not close when workbook is closed
- VBA project does not close when workbook is closed
- Calculation does not appear in userform
- Hlookup, but to next highest value
- Passing variant arrays to C/C++ dll's
- some doubts....
- accessing a workbook cell in a different directory
- Compare A to B to get C ??
- deletling messages from newsgroups
- how to schedule to run excel macros report
- Pivot table protection
- how to protect from insert, delete, resequence worksheet in workbook
- Cell Search
- protection workbook
- Excel Add In - Limited Use?
- Date Problems in Excel
- unable to have workbook protect
- Calculating the difference between hours
- Edit cell contents via userform listbox
- I have saved over a file by mistake with a different file
- protect workbook and allow hide/show worksheet
- Can not change the numberformat
- Opening a file from a set folder
- Excel Automation - loading text files
- Re: Delete command button
- Macro for Parameter Query
- Sheet number variable
- String manipulation!!
- Print the same page from many different named files
- ANN: TraceXLL Beta (free download)
- Ranges and Arrays - Passing values
- ADO - recordset - closed excel workbook - know sheet name and cell name but no named ranges defined
- Sheet number variable
- ADO - recordset - closed excel workbook
- Bossing the Text Import Wizard about
- how to sum numeric values of column (variable length) in 1st available blank cell
- Calculation does not appear in userform
- Printing in Draft mode
- Using Esc Botton while filling in userform
- Cannot Remove Missing References
- ControlSource in a userform textbox
- help with looping range and extracting value
- if cell is hidden
- visual basic pasting formulae
- Email and if statements
- Using "Select-Into" text file from XL (Attn: Jamie Collins, others
- AutoShape name assigned to macro
- Worksheet Change
- Macro for Parameter Query
- Show Data Form
- worksheet_change on pivot chart
- adding formula to vba code
- Copy and Paste
- "Selection" Code???
- Method 'Paste' of object '_worksheet' failed
- I have a large worksheet keep getting error OLE.APP Help
- help extracting a value in VBA
- Add value 0 to blank celss
- Show value 0 in blanks fields
- Changing/Concatenate Names from [FIRST NAME/LAST NAME] to [LAST/FI
- Check Boxes
- Email and if statements
- Interaction Excel and Word
- Rename workbook upon closing
- Array Declaration
- Can I use Excel to set up a tickler for financial statememt track.
- Combo Box Code...
- Excel - Powerpoint
- find row value, insert column
- Charting a pivot-table problem
- Emailing in Excel VBA
- getting runtime error
- A procedure should run when one cell switch between false/true - but not with worksheet_calculate or change event...
- Retrieve CD TOC into EXCEL
- date upon open
- enter date upon opening
- date upon opening
- creating FormFields
- Excel macro help
- auto generated number
- Pivot Table variable range
- Top 10 for each Item in column
- Accouting & Database
- Combing Workbooks
- date upon opening
- save workbook as the date content of a cell within a sheet
- Changing control properties/code through code
- traversing across columns in VBA
- Formatting a Variable
- Downloading updates a message box shows up saying SKU011.CAB file.
- Trailing zeros are dropping off
- Options for three compartment analysis - Old BASIC program to Excel?
- custom footer
- pivot table value
- deleting rows
- how do I change the font in an Excel XP forms combobox?
- Controlling ODBC queries with VB variables
- Why can I change display value in locked ActiveX combobox?
- Data Importing and Exporting
- Concatenate Text File
- Capturing a file path
- MsgBox to the front
- Creating an array based on worksheet index
- ClassFactory Run-time Error
- How to get the Mailing Address from Word
- Help with Importing Form Module into external xls. file
- Command line options
- Dynamic Sheet Tab Naming
- Filling Blank Cells
- Copying formulas using Pivot Table data
- Dynamic Sheet Tab Naming
- Delete command button
- Do not delete last item of each
- XL'97 - Cut CommandButton Anomoly
- How to Enable Microsoft.Win32 Functionality ?
- Finding out values depending on zone
- Tool Tip Text for Form control/ Active-X control
- Message Box Positioning
- array functions
- Number of Items in an Array.
- Invalid use of Null error
- Excel Add In - Limited Use?
- pagonis "wrong selection"
- Method 'Cells' of object '_Global' failed
- Appending Tables
- Prevent UserForm on top of a worksheet from being dragged around screen
- Problem setting a range
- Problems with the userform multipage
- Macro for Parameter Query
- copy digital signature (certifice) to second computer
- Send email Error...Please Help.
- Excel 97 - Application.Iteration is always FALSE?
- Calculating the difference between hours
- Macro
- Workbook_beforeclose +msgbox
- Problems with the userform multipage
- Edit cell contents via userform listbox
- Workbook_beforeclose +msgbox
- Handling Dead Hyperlinks
- WordBasis insert command -- text length limit
- read-only default
- Excel 97 - Application.Iteration is always FALSE?
- time taken to recalculate
- ComboBox and "mmm-aa" format
- ElseIf
- An Algorithm that matches two lists
- Copy the row multiple times while translating the columns
- Missing VBA Reference
- Copy/Time Delay
- Combing Workbooks
- gathering data
- Auto opening of a EXcel file on a CD
- Workbook_beforeclose +msgbox
- Combo Box Code...
- pivottable mutiple recordsource
- Why my VBA Code Prints each sheet twice
- Printing twice instead of Once.
- MIN/MAX question
- Textbox's and Dates the usual conflict
- Excel 2002 and the .emf files
- Combo Box Code...
- Stop Cell being Highlighted
- Trouble hiding commandbars
- Count Function
- month problem
- how do I turn off option explicit statement in VB
- Excel should let me deselect an individual cell
- Printing twice instead of Once.
- Graph object always missed info.
- FORMULA
- VBA Formula Result Different Than Manual Formula Result
- Text manipulation with Visual Basic
- Prob: Custom CommandBars and .xls Files Being Re-Opened