- Creating worksheets from another worksheet
- How do I hide an Excel MENU item?
- How to distribute custom toolbar updates?
- formatting date
- Insert Details from ListBox onto a NewWorkbook
- Dropdown list
- why error for activate method
- How can I add a PASSWORD entry box to my EXCEL app using VBA
- function doesn't work
- Free books on Charting, Basics, Data Management, Functions; Free Add-In "Excel Usability Enhancer"
- Find Whole Word Only
- Max-function with alphanumeric values?!?
- Using text files
- command to return the row number or cell number in excel?
- Call Excel from VC++ Win32 DLL
- Creating recordsets based on a range
- Writing to Excel using ASP.NET
- How do I pass a worksheets name to function?
- Excel 2003: custom function with dotnet
- Quiz.xls
- Problem copying from one workbook to anoth
- checkboxes
- Inserting Pictures from Access OLE Object field
- Addin problem
- Numeric Text Boxes
- Creating Pivot Table with VBA
- VBE Menu Bar Visible But Not Functional
- Need a "GetFolder method"
- Naming
- Offset
- Error if can't find text
- Permission problem when opening excel file from ASP
- Excel
- Help with CSV format
- Summing in Macros
- VBA send mail with groupwise
- Return Range in VB
- Revealing formulas
- Block deleting all zeros at once.
- Linking powerpoint to Excel
- help on charts
- Navigating a filtered list
- Looping
- ActivityLog - UserStatus
- turning off minimize, maximize & close
- copy and paste loop
- Find first and last cells in column that have a certain fill color
- Find first and last cells in column that have a certain fill color
- Sort issue
- Re: formula problem
- Auto Load
- Disable Macros Automatically
- scrolling to a specific cell
- synchronize worksheet in a workbook
- Errors with #import "Excel9.olb"
- Summary...Number of shts varies
- pivot table
- Problems with xl97 & xl2K
- more help with a hide macro
- Date Format Help
- Getting around Initials popup screen
- AskToUpdateLinks
- Function Error
- Still have formula prob :o(
- Using ADODB to read data out of another excel file
- Changing the vlookup cell
- saving a file
- VBA & Acrobat 6.0
- Macro to Create PDF from excel with filename...
- Array question
- Open file in the application that created it
- I need to change the BG color of a cell dynamically
- Several versions of Excel on same PC / same user?
- accessing data on a web site
- Using Input Box results in a formula
- Difficult Pivot Table Technical Question
- setting tab name for worksheet
- Page Header
- object by variable name
- All good except...
- tab through certain cells only
- Month Calculation
- Using a variable name as part of a file pathname to open many files
- Using a VMA for a reminder?
- Capturing the Update Links Property
- referencing filtered cells
- 3 columns and one line chart
- Querying a database for values in each row
- Excel 2000 VBA ActiveWorkbook.FullName
- Calling ApplyCustomType for Excel 2002 in C#
- Remove VBA Project module
- Extracting Sheet Name
- Emailing Excel Sheet As Attachment
- Stopping event during opening and saving
- Code works in XL2000 but not in XP!?
- Microsoft Visual Basic Editor and Mouse Scroll
- Help with some code to insert rows
- Add a dynamic date to a header or footer
- Design Input, please
- Simple copy rows with certain value to new sheet
- Security setting of low ignored for macros
- Store Hidden Data in the Cell
- .ScreenUpdating Problem?
- Worksheet_Change and comment in a cell
- Identifying cell from which a call is made
- VBA Code -- Cleaning Data
- Code
- function to convert inches
- A general programming question.
- Grouping OptionButtons post-creation
- Dividing data into worksheets by column values
- ASCII 133 -- Accented A or Ellipse
- Select column two
- Having trouble posting messages
- Thanks
- Inputbox question
- Auto filter macro
- Conditional value code
- Within Range ? Greater than, etc.
- Re: Range().Select Not Working
- Pivot Table Question
- Re: How do I Delete Lines from VBA Array?
- Using Excel WorksheetFunction.Mode function in Access VBA
- Re: What is the VBA equivilate to Excel worksheet function lookup
- removing and replacing toolbars
- Urgent help!!!! VBA
- Problem with UDF
- Conditional formatting using VB
- Past directly into TextBox on UserForm
- Where is the complete Object Model
- How to create a dynamic Userform via VBA
- Special Ranges of Cells
- Excel Single Instance
- How do I use RecordNavigationControl
- Code Edit
- Creating Sub CommandButton1_Clk programmatically
- Excel ODBC Query
- Locating first cell that has a number in it
- 3 VBA Conditions(last edit)
- Groups and Protection
- X axis labels from a Data Source...
- Meaning of simple code
- MSForms.TextBox Exit event isn't available in Excel class mosule
- Do I need an MP3 License?
- Re: Open Access DB in Excel with Command Button
- vba and ocx
- Status Message User Form in Excel '97
- Grouping rows and columns on a protected worksheet
- Multiple Source Worksheets
- pivot and vba !!!
- Trapping an open Workbook
- txtbox code
- Visual Basic query!!!
- Re: Open Access DB in Excel with Command Button
- Split fullname into Drive, Path and Filename
- Multiline textbox.. Can you have multiple font colors within?
- how to disable saving???
- open database
- Custom Menu
- addin problem: sheet mismatch by function parameters
- Setting bkcolor on active cell when left mouse doubleclikked
- VBA Detection of Workbook already Open
- Problems with "addin administration"
- Detect MsgBox keyUp
- I am new to VBA and am stuck
- Dimension problem
- What is wrong??
- Tools/Options/ Row & column headers
- Range Acting Lke Control?
- Numbers Only
- identification of cell that exceed certain number of characters
- Macro Dispaly Box
- Changing the height of a commandbar control (edit box) at runtime
- 2 Qs: grab net page, and import as fixed length format
- Excel 2000: maximise a sizeable form?
- Automation
- Excel scatter plot
- compile error in hidden module
- Custom Toolbar
- Formatting equation output
- Automation
- Listing files within a folder
- RE: Open Access DB in Excel with Command Button
- Save As "Error" Searching for idmxl8.xla Add In
- Count unique visible records
- Automation from .pdb to excel and then to access
- Userform and Text Box
- Selecting cells
- Cell question
- cells.find...
- Help using Network DDE in Excel
- Converting mulitlingual .xls using solver.xla
- Excel/VBA question: Link ChartTitle at run-time, anyone?
- Form
- Need code - new user
- Saving to same directory
- Changing the name of a referenced file
- Dont know how?
- Passing Parameters to Userdefined Functions
- Change code to make worksheets instead of workbooks
- How do I reference Current Cell when cell isn't the Activecell
- if statement
- Hiding and protecting sheet without crashing Excel!
- Finding ranges in an array, cut and paste also.
- Wildcard character with Select Statement
- autonumbering in excel..
- HELP - Need to prevent others from viewing my MACRO LIST - How do I do this?
- Microsoft Query - how to reference a cell value in a filter
- HOW can I add a PASSWORD entry box to my Excel app using VBA?
- Search two sheets simultaneously
- Shape Size in Cell
- Listbox for navigation
- Tab Code
- restricting access to workbook
- Input Value to Multiple Cells
- Memory corruption?
- Deleting rows based on criteria
- reference sheets
- Re: reference sheets
- Getting a number from a textbox to use in a vb formula
- Like operator as a worksheet-function
- Userform Formula Help Needed
- displaying filtered data on another sheet (Excel2000)
- Userform using 3 ranges to populate.
- Disable call for Addin
- Inputbox - display text as asterisk
- Creating a copy of a worksheet
- getting error
- Deleting Whole Rows From ListBox2
- Re: MAKE THOUSANDS NOW!!! EARN TONS OF CASH TODAY!!! NO GIMMICK!!!
- creating pdf files with macro
- Coloring a row a different color upon completing a cell
- today code in vba
- Excel messages
- Deleting/Adding/Changing values based on ComboBox1 Value
- spreadsheet on userform
- Deleting Files in Folder
- Format Conditions
- to kevin RE CloseSwitch
- Format
- Auto Open question
- Save File with multiple cells values as it's name
- Save Macro Question
- Function: Join Cells with Format
- Possible form help needed
- Userforms and Spredasheets
- Exporting images
- Page Header from a cell in bold
- Add a form onto a macro - Need help ASAP
- Long time to load
- inserting a character amongst characters in a cell.
- VBA: Select Excel's Worksheet using wildcard
- date formatting
- Code to Show All Pivot Table Items
- Excel 2000 microsoft development environment
- pivot table destination
- Dimensioning Arrays
- Union only works for sometimes.
- vba code for lookup worksheet function
- How to make a Password login screen in excel
- Conditional Formatting
- VBA Code
- Combining workbooks into one?????
- Combo Box
- Application.WorksheetFunction.MMult
- Userform Validation
- How to create Specific date in macro code
- Format Conversions
- Opening a saved file
- Newbie help please
- Applying formulae
- special cell selection
- Creating a copy of a worksheet II (Just 2 more things please...)
- The Tricky Blank CodeName Property & Excel 2002
- Deleting conditional formats based on condition
- Custom userforms
- Worksheet_Change & Undo
- How to open a specific MS office file using button in Access?
- Quickly search for and delete entire row if certain character is found
- One-D Array to Column Problem
- Variable in Range statement
- Need help with looping through a dynamic range
- Help Design a Medical Practice Spreadsheet
- Combo Boxes
- code for showing userform on cell selection
- Updating database from excel sheet with macro
- Search number in a string (excel vba)
- Delete empty rows
- hyperlink made easy???
- excel vba array basic operations
- month according to numbers
- HELP!!!! Can't stop a loop (NOT an infinite loop)
- VBA source code
- Delete key causes error in Worksheet_Change in 2003
- Formatting font with concantenated string
- blank columns
- Combo Box for navigating in a worksheet
- Compile error distMon
- range selection
- Deleting rows A to E when finding dublicated Data in Column B
- Copy and Paste Macro Help please....
- Value padding in VBA
- freeze panes...perhaps in microsoft script editor
- Identify and move duplicate rows?
- Summarising figures - can anyone help please
- Drop Down Information
- additem listbox
- I Can Not Use Data Groups In Protected Sheets?
- Macro no longer works now that in Excel XP
- Macro no longer works in XP
- Pivot Table Question
- ComboBox Items
- Dropping Data to a VB.net Program
- How can I CHANGE VALUE IN A CELL IN A HIDDEN WORKSHEET?
- automation error kills excel
- Format Textbox as %
- I want Cell content as Autofilter criteria
- LastName, FirstName format
- Secure Workbook
- Strange problem saving add-in
- Unable to add a hyperlink to a custom CammandBarButton
- Inserting rows before page break
- Simplifying code using array
- Run macro on all worksheets within workbook
- For....Next- Array of worksheets.
- Need help ....
- Triggering an Excel macro on press of SAVE
- Data Records Take Up Two Rows.
- international problem, decimal separator and chart series
- Merry Christmas and thanks for your help during the year.
- Check for number
- Coverting a VBA array from 2-D to 1-D
- Recursion with user defined functions
- Help Please !!!
- Using result of user input?
- Excel 2003 prompts for the password when I am not opening the stated file.
- Excel Pivot table Events
- saving new file name
- MISSING: OCWebPreview ActiveX Control Module
- arrays
- inserting rows with formulas
- how to call a macro from a worksheet event?
- ActiveSheet.Next.Select not working!
- autodestruction
- Problem with process Excel
- Printer name from handle
- Filtering
- Using Microsoft Web Components In VB
- vba variable problem
- Random numbers
- Calendar Control 9.0
- Embedded Objects in Excel
- Weeknum Add In doesn't load when launching Excel
- Insert range function and CopyOrigin
- Excel Formula - Error 1004 - Bug? Mistake?
- Naming a range
- calculating balance w/interest
- 1004 method 'COMAddIns' of object '_Application' failed
- Variables in a Range statement
- Can anyone help!?!?!?
- testing for blank
- Word/XL Mail Merge, 2000
- separate copy of excel
- Importing text to excell without especifying path
- a little help? OLE object, which version of app?
- referencing a control
- rounding of numbers in vba
- sort an array
- Save only new or changed cells
- How to use Ctrl+Shift+xldown in code
- Variable Not Defined? objPivotCache
- Excel 2000 replacement for Response.Write
- 1004 Method 'COMAddIns' of object '_Application' failed
- Cell address to Points
- Pivot Output formatting.
- Replacing links with values
- Temp File
- Help please to match data in a range, get the next column's value.
- Help Please
- Way to change a single line of vb code in several hundred excel files?
- controls and macros
- problems closing workbook
- Help with excel!
- insert a row according a condition
- Problem implementing SolverAdd - Can anyone solve?
- secure an excel spreadsheet
- Problem with SolverAdd. Can anyone help?
- Find last row can't find anything...
- Importing text file into an existing excel workbook.
- Protect Statement
- Sharing Macros in Excel
- Programming Excel -The most efficient way
- Updating Cells that Get Value from Macro
- Way to change a single line of vb code in several hundred excel files?
- Using an array variable to define chart values
- Excel freezing when zoom active and on dual-monitors.
- Logarithmic Chart in VBA
- How to make opening of workbook conditional of opening of another workbook
- Excel Parameters???
- I need to compare 2 separate lists
- Office 2000: excel to access automation and parameters
- VBA & XLL - function shadowing.
- Query - Where is it???
- Changing Cell Colour
- On Edit activation
- Substacting two military times
- Equivalent of Match Functn in VBA
- Cell Date/Time and NumberFormat issue
- resizing columns with pixels
- Using Property Let with a Type as member of a Class
- Chart.Export creates zero byte GIF and hangs on server
- Help saving a select to a text file
- counting spaces in a string
- Excel macros
- Buttons
- Reversing Words
- Worksheet_Change problem
- Find Empty Column and paste cell values
- VBA Function syntax
- Variable scope question w/combo-box
- Basic Stuff.
- How to make the opening of a workbook conditional upon the opening of another workbook
- Paste method of worksheet class failed error
- Bypassing password
- calling private subs
- Ogilvy Help :) - "Object variable or With block variable not set"
- Macro to force text to rol to next cell
- Excel fill down formula recalculation question
- Really easy?
- Cell to contain page name
- macros, filters, HELP
- Test to see if a spreadsheet window is open
- HELP! My macro won't link with form
- Help?? Averaging cells
- Unique numbers
- Call_Database_Form Code. Please Help!
- Is this possible?
- Help please....
- Filter Criteria
- Reconcilling list
- Opening an excel file with VB within Excel 2000 with or without the .xls suffix
- =(TEXT(RIGHT(A1,4),"####")&(TEXT(LEFT(A1,4),"####")))
- Questions!
- reference to previous worksheet
- RP - Office 2000 automation parameters Access and excel
- Making a Dynamic List in Listbox
- Moving multiple worksheets to new workbook in VBA
- Fill down relating to cell value
- excel error
- copy range between sheets
- Macro to only change selection
- Re: How do I Delete Lines from VBA Array?
- Help with IF statement
- Controling a dialog box after I've selected the datasource
- Column-replying macro
- Business hours calculation
- .Net and Excel
- aligning entry in text box
- Matrix Multiplication Function creation
- Need help with VB code for saving cell data
- Forcing Date Entry
- MS Query Limit results
- Getting Window Owner in .NET
- moving folders
- execute a macro from another macro
- Inserting blank rows
- Calling sub programs
- Run time error 2147417848(80010108)
- UCase in textbox, help
- Urgent Macro help needed
- Excel Help
- Set the elements of an array vertically to the cells
- Adding icon to standard menu
- Excel Macro
- running a macro saved as a string
- how to get hwnd from application object?
- Help with setting range limits
- breaking out of a loop
- ComboBox - Excel
- FindMethod 2 col range
- Why Prompted To Save Again?
- Add Sort button
- Inserting Functions
- VB
- This does not work: Range("A1").Select
- Deleting data from Shared workbook
- saving .prn with more than 240 positions
- Rank and Cell colour
- parsing words in a cell separated by commas
- need help to for macro
- insert 'x' number of rows???
- running macro upon a spreadsheet's startup
- vb script to add names to tabs
- Disable selection of shapes
- parameters in treeview
- saving .prn with more than 240 positions
- sending email within a macro
- Where is my syntax error?
- Copying and renaming worksheets
- Fill down range
- Possible to write Excel macros in JavaScript?
- Help appreciated
- How to get right URL for a Web Query
- Problem with logical sentence
- For each loop
- Help in conditional SUM
- How can I optimize this code?
- Input Command with Mainframe file and multiple variables
- printing and groups
- Really Dumb Question
- Extract row based on a criteria
- Dget in VBA gets Object required run-time error?
- Use SUMPRODUCT to find duplicate rows (not one column)
- VBA code need help on CopyPaste
- Macro not with a file
- Creating a MailItem in Outlook from Excel using Late Binding
- FileSearch Hangs Excel
- excel - count sleected items in a listbox
- Email Attachment from Excel using Outlook.
- Paste Error
- SendKeys problem
- Autofilter and protection
- Acquiring filenames for multiple files with GetOpenFilename
- Marco vs Lotus Note
- control in excel 2000 does not work any more under excel 2003
- Problem opening a komma separated file with Excel 97
- Open a XLS from a Module
- Shortcut key
- xlR1C1
- Sheets ("").Copy not working
- Help ('IF' Statements) Please !!
- Code to hide rows based on cell contents
- Create a new menu in VB
- Excel Object in VB when running under scheduler control
- unable to set the colorindex property of the font class
- Pie Chart formatting
- Calculating a range in VB Excel XP
- Worksheets and arrays
- Help on cell formatting
- How can I use a worksheet while running a userform?
- POJSDF
- Excelmacro - Office -97 --> Office XP
- Copy selected columns only
- How to force repaint of popup commandbar?
- Changing font size, bold and underline
- Change from a sum reference to the number
- Test a file to retrieve format
- Change the appearance of a built-in menu
- Start macro on cell change
- Chart "Automation"
- rows that dont want to be deleted!!!!
- Copying a selected prn file to printer.
- Using GetSaveAs
- Autosorting and working out medalists for data.
- Outline numbering in Excel?
- Cycle trhough a list of names
- Add In Locations
- Canned VBA Date Validation
- Email Text Message
- Creating "Plain Text" mail message in Outlook from Excel VBA
- Please Help
- AddInError Excel97 --> ExcelXP
- ADO and Checkboxes
- conditional format for vb code on pivot output
- How find character position # in string from right end? Or how get range row num
- Moving the Active cell to the left of the screen
- Restricting access to workbook
- Comparing two rows
- Seperate numbers from letters
- heure
- MVP Challenge. Erratic Userform Compile Error
- Excel the best!
- html tags with a cell
- How to open a merged word document
- Log File for Excel Spreadsheet
- print a form landscape
- Autofilter across Worksheets
- check 2 speadsheets for diference
- RTD Server disconnectdata
- Call a macro in other workbook
- I have posted this message before but did not get any response can anyone help me?
- Summation of rows
- change a macro so that it copies and pastes data as values rather than references
- Can you save an external macro?
- Format when opening .CSV file in Excel
- VBA conversion confusion
- Restore toolbars
- ADO from Excel to Access
- Dynamic Creation of rows in Excel
- Printing fixed columns and rows
- Problem with Find function
- coloring a tab
- Excel Shapes
- Macro to insert hyperlinks
- RegisteredFunctions in C# fails when trying to get the list of addins and function
- Help with getting rid of unused cells or ranges
- using vlookup, but error #N/A
- Copy Rows to Existing Worksheets
- SQL.REQUEST - controlling refresh frequency?
- Sub A1 Line Malfunction
- Display Saturday's Date
- Find and Replace Data from one into another
- setting cell contents to text using C#
- Creating a new Excel Addin
- Excel 2000 VBA Question
- URL String
- Converting Range.value(error)
- Editing Query Parameters
- Form display errors
- UserForm Result Posting
- ENTER key
- Close VB in Code
- simple help needed please
- bottom right cell on screen
- Macro for dropdown
- Resetting variables
- Create Worksheets Based Upon Changing Column Values in XP
- Format Cells ?
- Excel version comparison
- Turning Off Cut & Copy in a Workbook
- Import .BMP File From Web Using VBA
- Array Formula Question
- Macros - Range Selection
- Help with this Find code please
- Anyone successful taking data into Quickbooks?
- calling an Excel Add-in application
- Excel Basic
- setting row in macro
- mass changes in formulas
- Best Way Question
- Transposing numbers
- Type mismatch while running If statement
- Connumdrum #1
- Connumdrum #2
- Random Number Generator
- vbAccelerator sGrid control- spacing columns.
- Missing Numbers
- Loop across Sheets and number of sheets
- open excll from network
- Disabling Ctrl, ALT keys
- Unspecify Error in Range count
- excel caused an invalid page fault in module excel.exe 0177:3003b3fd
- Office Clipboard: Clear all with VBA-macro?
- Open Html file i Excel
- Problem due to password
- How to code a timer to trigger a sub-routine ?
- Find a certain word in excel and select the cell
- Runnig a macro when excel opens
- Help with Sorting tables
- erasing checkboxes
- Counting items
- import CSV file at location D7
- Problem in activating a sheet
- Accessibility of Custom Functions
- comparing text
- Calling up a specific Help topic?
- Invoice autonumber with mulitple number sequense
- Check for Excel version before running?
- Declaration?
- Deleting Sheet
- followhyperlink
- Check status row (hidden or visible)?
- Howdo I password protect a list entry
- For | Next ...OR... Do | Loop
- Go to record found by Criteria in Data Form
- .CurrentRegion in Excel functions
- new comer problems
- auto enter date in cell on data entry in row
- Scroll selection into view
- Run Query w/Function from Excel
- How to concatenate a range?
- Padding out reference numbers
- Converting file formats
- Directory browser in Excel VB
- Import PDF information into Excel
- copy without formulas
- setting a chart size
- Rename wrksht tab from cell info w/Macro
- time/date formatting bug
- Calculating number of days in month
- Word Search from Excel results in Duplicates
- run macro in book1 from book2 - how?
- How do I delete ExternalRata range names?
- For Loop in Filtered List
- Macro Ceiling & Floor Calculation Problem...
- Formatting of workbook window
- Activate Workbook in Separate Excel Session
- checking value in column
- Formula Modification Needed
- Pass a filename to a query
- how to validate a combobox?
- lock out menus?
- "save as" macro
- "Out of memory" when running a Web Query
- Can I edit .iqy file from code?
- ScrollBar1_Change() problem
- bulk mailing problem
- Prevent Locked for Editing on a network
- autorefresh display autofilter criteria question
- Getting data from web site to excel
- Filtering for exact text
- Easiest way to add functionality to ALL Excel spreadsheets
- Range selection in a sheet module
- Adding new rows to spreadsheet
- Creating properly formatted text file from vbscript using excel data
- Paste Code
- Sheet module VBA not copied
- Run Query w/Function from Excel
- deleting array element
- Scrolling a lstBox automatically
- How to change international decimal separator
- alphabetic order
- Validate Appointment Times?
- Urgent info. on opening a mail merge with the datasource open
- Send Sheet as part of macro
- Application.Close
- SaveAs and relative path
- help me...
- Define Range in Deleting Empty Rows
- Renaming Sheets in a workbook
- Use Your Brain
- New to this thing
- How to split text?
- Use Your Brain
- Create a HYPERLINK with a macro?
- Stepping backward through an array
- macro in excel to copy from excel to word
- how to specify the filename
- show message
- External data query - need to use SELECT * (ALL RECORDS)
- Decimal Symbol
- Macro Runs if Template name is .....
- Find all formatted cells
- DB query syntax
- How to check a Variant for its data type
- How can I get the worksheet name use micro function?
- Sub Error with Sheet Protection Enabled?
- Excel 2000 Web query not returning all Table Data
- Find text and remove row
- Can this be done in Excel?
- Close second instance of excel
- Question about using AND or OR with If-Then statements
- concenate or vba or sql
- How to insert a lot of values into cells?
- VBA Index / match type formula copying formulas, not values
- Userform and checkbox....
- delete rows with certain condition
- Routine??
- How to determine if instance of Excel is running
- Excel and Windows Eventlog