- VB.NET and Excel Range data
- Concatenate with multiple lines in same cell
- Desktop Saving in VB
- For..Next loop problem
- Go To combobox
- How to return to selected cell?
- losing arrays
- User Functions Compilation?
- Excel 97 pivot table VBA problem - why has microsoft built in these random limitations?
- 'Pulling' rows into sheets
- Multiple Col. Selection
- scheduling macros for excel
- Date validation
- Problem incrementing rows
- File formatting!
- complex cell formatting using VBA
- VBA5.dll for Version 6.3
- Find active cell
- Cell Question
- Looping and Filling Info
- Sheet count
- Step through a Word macro called from Excel?
- XL add-in dilemma
- Using a collection class to implement mutliple find/replace strings in cells
- how 2 launch user form ..
- Custom Diaglog Box
- tom oGlivy: Linking data ?
- Recognizating worksheet name
- Web query question.
- Increment row change by two
- Save As Macro
- disabling a command button
- Formula/Text?
- hello :)
- List box data
- Iterating through Cells .Net/Excel 2003
- hyperlink function verification
- Multiple Lookup in VBA
- variables in formulae
- total populate date
- Re: Clearcontents
- NetWorkDays in VBA?
- pausing a macro
- Cycling though all sheets in the workbook
- Easy code!!!!
- If Statement help
- Optimize Slow function
- Excel's VBA <> Word's VBA?
- Re: Shifting Data Right Within A Range - 2
- Make name Generic
- Trying to Open Multiple WorkBooks w/ same beginning FileName
- Can't get parameters on macros working...
- Using the Excel TEXT function within a VBA program
- Determining if two ranges overlap
- Removing Addin Buttons on Toolbars
- Find
- Pivot Table - Hiding Rows
- Help needed with writing a formula
- Filter and copy entire row
- Date Problem
- How to automate a macro to run on all sheets in a workbook
- VBA help screen
- Import .prn file to Excel
- Class module
- Convert a 100,000 character linear text file
- PivotTable and PivotCharts Problem - Manipulating in VBA
- Printing radio buttons with the circular outlines
- Undo macros
- test if a sheet exist (with the name) ?
- VBA Conditional Formatting
- Solving equations programmatically
- Running a excel macro from VB6
- Track Excel File usage?
- Can subroutines be called based on a commandbutton number?
- Duplication warning
- Defining range
- Calculate vertical midpoint of a print area in a sheet
- "Insert Line Break-Macro"
- Finding week from date
- Thank you, TOM OGLIVY: linking across the worksheets
- #N/A error
- Excel References
- Suppress dialog while opening a write protected Excel document from VBS
- updating a workbook
- How do I reference the cell address next to Active cell
- Import some data
- List boxes/combo boxes
- R1C1 to Range
- Deleting files
- Email templates & Excel Macros
- How to empty the clipboard using vba code
- Automatic update of code in other workbook
- How can I get all table names from MS Access databse
- Problems with SearchInRange() macro
- function in a cell
- How to make a nex sheet?
- Repeat cell content
- Printing numbers in Excel. Macro needed.
- strange "subscript out of range" error!
- Problem with Importing Data to Spreadsheet
- How can I get the last used column in a sheet???
- Freeze formula results
- Sockets from VBA
- Trying to create a conditional sum
- multiple scroll areas on sheet?? and combo box values
- running a macro ina workbook that doesnt have that macro
- remove the row value in the pivot table creation code.
- creating logarithmic trendline equation function
- Sorting a Filtered List
- graph showing date and time of arrival on each date
- One Single Message Box for chained macros
- Error: The procedure number is out of range
- Pasting into Filtered Lists (Visible cells only)
- More on Concatenating Rows
- Insert a row after each account no change
- Assigning a query to a control button
- Populate combobox with visable rows only
- SavingExcelChanges
- what's the best way to do this?
- Excel Graph
- Error: Too many cell formats
- Deleting broken range names
- Menu Options
- Transferring Workbooks with Macros to and from Mac Excel
- Identifying Date Cells
- macro to filter/print pages using certain criteria
- Query on Control Source in Userform Textbox
- object model diagram
- Generation of graphs from a template sheet crashes with VBA
- Help "saving as" please
- Multiple destination cells for data entry
- Branching in a macro
- IE6 and Excel Web Query
- Copying an array to a worksheet: Excel 97 vs 2000
- Further ActiveX questions
- negative number
- Automate Excel from VS.NET
- Re Name a Worksheet as a Date Format
- Looking up dependent values in a list
- deleting toolbars
- Vertical mid-point on sheet
- Microsoft Office Macros
- Change format of a cell
- Moving Between Worksheets
- More Formula Help....
- Form limitation
- Macro Random Behavior
- Macro That Moves Cursor Down
- SQL.REQUEST query omitting rows in MSSQL DB
- sheet names
- returning max UsedRange row number
- Find Keyboard shortcut in a macro
- Excel File size, when imported JPG images
- Date autocomplete (XP)
- Formula problem
- zeroing cell values in a collapsed group
- Reading Access - Multiple Indices
- Filtering Names By Date
- Date format
- filtering out whole pages only
- How to update a pivot table, without refreshinh the whole thing?
- Create Pivot from array?
- XLL Functions with no parameters
- Copy_to_sheet macro
- textboxes and datatypes
- Autofilter
- Code Cleaner in 2003
- Array or Vlookup
- Improving the speed of FOR/NEXT statements
- Need Macro to rename excel files
- Commandbutton in UserForm to run Macro
- Looping down list and each time copying to another worksheet
- Looping down list and each time copying to another worksheet
- Imbed SQL in Excel ?
- Delete results of Autofilter???
- truncating pasted text after 250 characters
- Select instersection of two ranges
- Common Dialog & other
- More formula help.....
- Deleted macros still showing enabled
- Printing Excel BLOBS
- SaveCopyAs method
- Function that returns name og curred sheet
- Form
- Hourglass
- Loops for deleting rows
- Flickering edit bar during loop
- Showing worksheets in an Add-in
- ActiveX Controls
- Change Word Total and Grand Total
- Will upgrading from Excel 2000 kill VBA?
- Hiding Worksheets
- User form - Picture in the caption?
- Using TextBox to AutoFilter
- How can a formula get the location of the cell it is placed in?
- Returning an array in excel
- Internal Hyperlinks in toolbar
- Userform
- Columnwidth changes-Event
- Test Post
- Create macros to print specific cells
- 'splain the code please :)
- tracking a macro like the evaluate formula tool
- graph troubles in VBA macros
- Event Sequences
- HELP,how to show search result according to specifed criteria and selected fields
- Conditional ranking
- Is this possible?
- Excel VBA - Userform Checkbox/Textbox Problem
- Shifting Data Right Within A Range
- How can I merge multiple files using SQL?
- Old Value
- UK to US date format
- How to pass an Excel range as an argument to a SQL Server stored Procedure
- Adding range to array, keep formatting
- Copy paste range
- Problems with SearchInRange() macro
- VLOOKUP
- Sort data failure
- Delete hidden worksheets
- Hidden Worsheets
- List to Range
- Icon in toolbar
- Updating Links
- Excel Menu 'pop ups'
- Repeat job
- Decimal declareren
- Sub routine failure
- Put formula in cell
- Coloring cells thru VBA
- DropDown list
- Delate Names
- Macro freezes Excel
- Assignment by reference or value
- Excel crash error code
- HELP sort 2 worksheets
- compare two cell values on different sheets
- Excel 2000 macro security level
- VBA back compatibility
- Excel 2000 - range.calculate error - 2147417848
- Run macro in background
- Column.
- Programming Array Formulas in VBA - Can they be intermediate results in RAM?
- Help with SUM code
- highlight cell as answer
- Request Vba code Export gif file
- Sorting question
- checking for missing values
- Combo box question
- Using cell contents ae address
- Combine two macros using InStr?
- Embedding Executables in Excel File?
- Userform Problem
- create help files!
- check if protected
- TOM you made my day...
- highlight cell as answer
- printing module code from vba editor
- #if..#else..#end if.
- Scroll Into View
- excel save AND concatenation problem
- Determining if Macro Can Run
- COM Add-in file location
- delete commandbuttons on copied sheet
- what is this object called? - right hand corner of statusbar
- xlUnlocked Cells Not Working
- Last Row
- Positioning custom menu
- Stripping Path from File String
- Creating a SubMenu
- Why did XL stopped showing me the Macro Commands List
- Why did XL stopped showing me the Macro Commands list?
- Question on ktmsgbox Utility
- Activecell.FormulaR1C1 Versus ActiveSheet.cells(column, row)
- Re: how to put formula in a cell
- Question on ktmsgbox Utility
- How to delete an embedded chart
- findnext issues
- Data Validation erratic bevavior
- program for filtering data.
- Error with "Find"
- How to activate the cell in same row, column 1?
- VBA to set which columns in Autofilter
- Deactive Activate Workbook Events - Add Menu
- Get next Integer value
- How to hide/show row/column headers and sheet tabs.
- How to check programmatically whether Excel is installed on computer?
- Worksheet Data Filters
- Displaying the URL's of imported webpages
- Automatically moving data
- UDF, Category, Data Type, Format, Using
- saveas for backup
- Combobox problem
- Variables - simple question
- Writing a macro to change external links to manual updating in Excel 2000
- Technique to move (reorder) items in Listbox
- Hide or disable print
- Excel Macro for multiple sheet ??
- reading password-protected, open webpage
- Computing Date n time
- Can Page Setup values be controlled with VBA?
- WorkBook_BeforeClose (Delete Menu)
- help!!! i can not send target to my sub in event
- Accessing File Properties
- Open Winword from Excel
- Replacing a value from a formula
- Disable Macros through VBA
- Temporary storage, Addin events
- Code Help
- Format Chart's Y-axis . Urgent
- Checking for VBA5, not VBA6
- Excel Problem - Delete Row Macro
- excel function within a function
- Re: Edit information in a cell and not change content
- IF Statement
- Function help
- Excel VB Macro HELP!
- Next line in header
- Re: Personal.xls
- Re: excel function within a function
- Looping input from a text box
- Column format as Text
- SubTotals Problem
- Re: Formula Help
- Db function
- function within a function #2
- Re: excel function within a function
- VSTO .net - Adding a Usercontrol unto Worksheet
- Hide a data field on a pivot table
- Excel VBA-Error, range function not working?!?!?
- How to neutralize Active Cell?
- it's not working anymore, please help!
- ID location of duplicates in different workbooks.
- Adding error-bars in a pivot-chart
- Fixed objects will move
- Editing Addins
- Convert XL2K wkbk w/ macros to XL97?
- Email again
- Error Handling
- Excel VBA crashing
- Excel x CSS
- Re: Formula Help
- Workbooks referenced by a deleted workbook
- Inputbox for Worksheet name - problem
- Excel VBA-How to close all open workbooks except one specific?
- Copying unique values
- Workbook referenced by a deleted workbook
- VBA Calendar control
- delete empy rows
- More help with SaveAs
- Menumaker.xls Create Macro on User Toolbar
- Scanning Through Filtered Data
- Do Until Help
- Help with "IF" Formula
- problems calling this function
- Lookup of sorts...Matrix Array etc.
- Email from Excel
- A few RTD Questions
- Find all running Excel Application objects
- Pause?
- Calculating pagenumbers before printing
- Parsing Data
- Parsing Variable Range of Data
- IRTDUpdateEvent failure
- Run-time error '6' overflow
- Help with SaveAs
- vlookup?
- For Loop and If Statement question
- For Loop and If Statement question
- Textbox value
- Macro error stack full
- Type Mismatch
- Deleting Sheets
- Writing Text Files
- Leftaligning text in right header
- Data Migration from Lotus . 123 to xls
- data tables
- FindNext problem
- macro adjustment help
- range.calculate error - -2147417848
- display values in cell
- 'Programmatic access to Visual Basic project is not trusted.' message
- worksheet_change event with a combo box
- Conditional Formating Format Painter
- How to write back a SQL Server table from Excel
- Finding the query range
- Re: how can i know the hidden by programming
- Re: When open an old xls, an new macro is in a new module.
- Re: Help with SUM code
- Re: Find entries greater than 'Dec 2002'
- Selecting Multiple Chart Series
- Advanced Filter
- Re: Find row (and column)
- Selecting Multiple Chart Series
- Deleting All Sheets Other than specified from a workbook
- Re: Get objects property names in run-time?
- Re: Easter egg in Excel 2002?
- Re: Moving Data Within a Range
- Problem with list
- Paste Special
- Truncated text in a combo box!
- Dialog Boxes
- When is "?" really a "?" (.SaveAs with Chinese chars)
- Excel VBA data export
- How to use multiple sheets with range in userdefined function.
- Take value from sheet
- possibility of automatically placing an autoshape using a function
- highlight cell text
- using a button
- Listbox issues
- Duplicate ToolBar Buttons
- macro or vb to alternating row color
- Data Types and inaccuracies with Trig functions in VBA
- Excel Access Query
- Negative number
- Code to format data in cells in VB
- need help- SUB: DATATYPE FOR A CELL..
- Got a little challenge any ?
- Looping through Sheets and passing values to an Array
- How to record a New Web Query that requires login + password.
- Macro, Persoanl Work book and CSV workbooks
- Save the layout of PivotTable
- Need simple VBA math help
- efine the data type of a variable
- Red bullets in left border column
- Deleting rows which match filter
- maybe i'll get lucky again
- From form to sheet and back using proc
- getting rif of apostrophe in front of ss#
- Removing VBA Code (programatically)
- Worksheet_Change event won't fire to execute Macro???
- combo box codes
- Arrays
- vba programming copy/ paste cell values help.
- From forms into a new row neatly?
- Code to check if workbook is the last one opened
- splash
- Excel & dates... how to determine order.
- Formatting a MsgBox number
- Creating new VBA code on the fly
- "Reset" a workbook
- Error retrieving value of the specified Excel cell (Not active)
- Pivot Table in Excel 2002 XP - Calculated Fields
- VBA & Conditional Formating issues
- No need to reply!!
- DB Connection error
- help with arrays
- Re: no password carryover with "protect sheet" in macro
- Userform ComboBox and TextBox help!!!
- Help with saveas
- Increment through For Next loop
- Spelling out a numeric value
- xls property
- compare
- Programming in Excel 2003!
- Excel VBA-open & save all delimited files
- Split Workbook - improved code required
- help in writing a macro
- VBA Help Screen question
- text match
- Button to close without saving
- TOM it did not work...
- Add-In / Tool / VBA Code for Renaming Range Names
- getting coordinates of a range
- UDF - detect cell border
- Frank - Thanks
- range.activate
- Tim
- Can I change the font of a toolbar button
- Re: TEXT(Cell1,"MMMM YYYY") to work in all locale.
- file property
- Help with macro!!
- TOM I have put a wrong question
- pressing the "reset" button and freeing memory
- Looping through sheets.
- Looping through sheets.
- help with arrays
- Row Count
- Excel VBA-How to save sheet w/in all workbooks as sheet1?
- more workbooks in one
- Using VB to code a Macro within Excel 2000
- Re: Excel sheet data to oracle.
- Remove single quote, help needed!
- refresh data vba question
- text match?
- Re: Macro for changing tabs
- UserForm 2
- Email a worksheet
- Is there any way to enumerate the cell which contain a formula?
- Calculating Sum question.
- Trap a DateValue Error
- Fill a Listbox with Values from a Pivot Table Field - an Example
- Re: Macro for changing tabs
- how to delete a row
- Excel & VBA Macro Help AGAIN
- Dialogs Command
- Running a macro when a Wb is opened
- Sorting two separate worksheets
- Using INI files
- Copy and rename files from hyperlink
- Emailing Lotus Notes From Excel
- VB combination code
- Dynamic data exchange between two computer on a network with VBA
- Getting a range from Excel into a Word document
- Comparing Formulas - for budget purposes
- Unwanted Square Character in .txt file
- Copying tabs in a workbook
- Determining last copied range
- excel 2002 build problem :(
- UserForm position
- control toolbox contrls disabled in design mode
- Need a macro to do what this VLOOKUP does
- Comparing records from 2 tables
- How to input 2 dates and mark them as range...
- TEXT(Cell1,"MMMM YYYY") to work in all locale.
- Distribute Personl.xls and excel.xlb for net use
- How can I call Range::Find from C++ without crashing Excel?
- How to become a better programmer, post college. More projects or less projects.
- VBA equivalent of findstr
- Preventing compile errors when referencing objects ehanced after 1997
- Moving home
- display settings
- Numberformat
- replacing column alphabet
- Printing second page if data overruns, otherwise print first page
- Read Only Enforcement
- Re: Macro
- Re: Using qry from excel to update tables in a db2 database
- Excel and MDB Datbase Files
- There has got to be a better way
- VBA Replace Dates
- Generating a Hyperlink Macro
- Morning
- Validation lists
- Selecting a Page in Page Break Preview
- Using Word Bookmarks to read Text
- Re: Using qry from excel to update tables in a db2 database
- Re: Using qry from excel to update tables in a db2 database
- Cell validation
- Date and sequential serial numbers
- covering cells
- GetSaveFileName across mixed language network
- How to get image's path?
- Excel VBA- format string length to get a cell height
- Restrict a column to allow only unique entries?
- Which is the best language for rewriting code into DLL's ?
- Transfering Required data from *.txt file to
- Adding menu to the mouse right click pop-up menu
- using VLookUp in a VBA program
- KeyDown / KeyPress Events
- Font color buttons?
- Running Macro with B/ground Timer
- Excel vs VBA Dates
- size of the plot area
- Delete a row
- specify a range of numbers in excel formula
- Inserting a Face ID onto a Command button
- Checking input for alphabet (i.e. words)
- Web Query
- How to add a macro with password protection
- Filenames into Excel
- Delimiter for Data Validation
- Please help
- Variable
- Controlling Tab Oders
- Creating new VBA code on the fly
- using a macro to unproctect a password protected sheet
- columns seletion error
- Help, Need Copy of Excelrecovery
- Password protection
- script detecting the change of active cell
- VLOOKUP help
- How to get the number of a row
- Combining 2 HTML files into a Single Workbook
- Textboxes and loops
- Mass find replace - inserting a linebreak
- Transfer values from column to row using macro!
- populate a cell with an external workbook referance
- How to determine a range size
- Copying too much.
- Not Hiding Columns
- Beyond a wholesome discipline, be gentle with yourself.
- Determining the group a picture or textbox is a member of
- Re: Using qry from excel to update tables in a db2 database
- Re: Adding 4 business days to a specified date
- Renaming tabs
- ShowDataForm Initialization
- How Can I Check Multiple Ranges?
- Please help, file name issue
- Conditional Formatting limitations...
- Default Filepath question... How to???
- Find Unique Entries
- Automating import of a certain type of 'txt' file
- Complicated Table
- Range problem
- Wacky form
- Re: Function name not recognized
- Userfrom code in written in Excel 2000 running in Excel 97
- Re: Getting rid of "extraneous" data (rows)
- testing whether a character is a letter or number
- Macro to save excel XP spreadsheet to excel 97 spreadsheet format
- ListBox question
- Cannot Record a Macro or Edit VBA
- split cell content
- Use Checkbox Value or Public Variable?
- HELP!
- Deactivate Formula
- Clearing Cell Contents
- Code to print w/out cell shading
- ComboBox RowSource --- can I use a userform OWC10 spreadsheet range?
- pastespecial on a worksheet question
- Determine last row then sort
- pivot table single column
- Compact Excel Spreadsheet
- srf
- Resizing comment boxes
- How do I set values from a userform
- Autonumbering
- Filling a Combo Box with VBA
- Conditional Formatting
- Moving and parsing data - Copy & Paste problems
- run time error 91 all of a sudden
- How do I set focus
- How to reference unsaved workbook in functions????
- Linking to an external referance with a variable file name?
- Excel Object Library Reference
- Diverting output to another workbook?
- Recognizating worksheet name
- "Subscript of range" error
- listbox with checkbox or radiobutton groups
- Customised charting and data lookup
- Linking ComboBoxes through VBA
- SQL query to ODBC
- SaveCopyAs cannot access opened file?
- Using Round function on French and US Win2k
- Converting Lotus 123 macro to Excel - copy/move data to worksheet
- Converting Lotus 123 macros to Excel - Sort by Due Date
- Summarizing several item values in one cell
- Expot to Access
- Pivot Table value in category renamed but the old value is still there
- IF AND in VBA
- Mortgage amortization Template
- eomonth funciton in VBA
- Getting rid of Prompts in a macro
- VBA Functions
- Macros
- How can I make a simple database.
- Copy/Paste to all Worksheets
- "ghost" link
- Sace and close
- Recordset in Excel
- Excel VBA-Change chart range to variable
- Cell check
- Customizing Toolbar
- Re: ActiveX registering problem with VBA
- Set a PivotCache as the results of a query
- create a "check" macro
- Excel VBA-
- How to read active Excel celll value by external vb application?
- Add value to existing cell value
- Filecopy and UNC-pathname
- Re: ActiveX registering problem with VBA
- VBA/ActiveX ComboBox autosize bug - Selection of value multiple times shrinks text.
- Macro to load on open
- Help with Arrays & Ranges in VBA
- Macro to unprotect workbook
- Locked cells
- Calendar Macro
- Keep the Enable Refresh option (VBA, SQL)
- Getting File property info with code?
- calculate
- Concatenate Function
- Macro
- Using chartspace in a user form
- Comparing Excel Workbooks
- Mail Merge
- Checking and Updating
- ForEach procedure adding values
- Maximize Excel
- Excel automation
- making macro run faster?
- Comparing negative number
- Sharing
- Is file opened?
- XL97: where are my favourite MVP's ?
- Create (or find) a complete object tree for excel
- "Dumb copy"
- TEXT(Cell1,"MMMM YYYY") to work in all locale.
- adjusting Y-axis
- csv example
- change value in a cell if other cell is changed
- Listbox control
- Pull data in a new colour
- Set focus on command button
- MANAGING MACROS
- Empty listbox
- Chart Identification Problems
- format painter
- copy files from one dir to another
- Listbox with Bound Columns
- keeping code in .dll library
- Excel2000 VBA - Workbook size increases abnormally.
- Matrix inverse
- Getting a function to return a formated Range string
- Problems with Excel 97 and XP
- Another problem with changeing a graph
- SelectionChange Event
- Changeing a graph
- runtime error 1004
- Drag and drop onto cells?
- Zoom on selection
- Repost:I accidentally posted this in the general excel forum. Date Logic
- Calculating Dates in VBA
- Chart Series Question
- Assist in converting Lotus Macro to Excel?
- how to select every third row
- Need Help with macro code modification
- Listing Temporary Internet Files
- Making a connection: shape clicked and cell it lies over.
- EXCEL PIVOT TABLES DETECTING EVENTS
- emailing from excel
- Maximum character input in a cell
- Get sheet name given a cell
- Unable to get VLOOKUP property
- Macro Ran in Excel 97 but in XP. What Needs Changing
- how to put tab character into textbox?
- Vlookup with tableLookup is external workbook
- UserForm_Layout event - Excel97
- Hiding Toolbars Question
- Re: Macro assigning help PLEASE
- Hidden name
- Undefined unction when using VLOOKUP
- Auto Clear Cells
- Generate a Modulus Sequence
- Macro to mark double numbers in another colour.
- Join string with variable name to get variable value
- External dll
- Path
- ComboBox with an editable function
- VBA-Select several ranges using variables
- Defining Custom Colors
- SetFocus to first textbox on userform upon Userform1.Show
- Can't Update Cells from a Function?
- Making Excel Ignore invalid references
- Combining Msg Box and Data
- Save Location - Date Format
- Running Totals
- List Box and Quick selecton of item in drop down
- Macro to move selected cell contents to a specific column on same row
- emailing workbooks