- Cell in Header ?
- Remove Invalid Phone Numbers
- Debug RuntimeError 1004 in Chart
- Conditional Search & Cut and Paste *VBA?
- selection.copy is getting nixed
- Batching files through a macro
- RE: Change size of comments?
- Refresh pivot table on a Shared workbook
- Question for dummy
- Shoving Excel Columns Into Word Table
- Outlook Email Reference
- symbol
- custom function
- Prn file carriage return deletion within notepad
- How get sum value in status bar?
- Formulas
- Array Formulas in VB
- Please take a look at this working code and critque it.
- Splash Screen Problem
- Mysterious " " in SaveAs Dialog Box
- Hide cell range in worksheet
- combining tasks
- Excel Worksheet Subtotals Data Truncate
- Subtotal Truncate
- How can I use 2 diff. recordsets without opening another db connec
- =IF(B3<O;nodisplay(graphA);display(graphA))
- Custom Menu Focus
- Auto sorting multiple ranges on event
- Delete the list name from a cell range
- Complicated "what if, then" formulas
- Cell has a value of #N/A when the formula refers to nothing
- Calling a common XLA Library file, stored on a network drive :)
- Calling a common XLA Library file, stored on a network drive :)
- Event of the dropdownbox in a cell
- Move the cursor to a cell in button click event
- using an if then statement call a caption box to a cell
- Programming Question
- Help!!! Alerts in Excel!!
- using an if then statement call a caption box to a cell
- Default to Read Only
- Re: using an if then statement call a caption box to a cell
- problem passing an argument to a sub
- Controlling toolbar available
- Add 0 to the beginning of the cell
- macro code to change file-opening password
- Do Until problem
- FileSearch FileName using wildcard (?)
- SaveAs CSV problem
- Missing Numbers from a Range
- original messages in the reply
- Create Function to display name of variable
- Trapping an invalid email error in Excel VBA code
- update txt file
- Version # in excel
- custom function
- coding error
- _Workbook::SaveAs(...)
- Finding the Value (of text and numbers) between N/A's
- Find Min value in range with VBA?
- VBA Precedence Problem
- Filtering based on row
- Better way of finding last row on sheet
- Get the Excel Filename after a save
- pivot field description in VBA
- Re: Excel on PDA
- pivot zero values
- Weird Mouse Problem in VB
- pivot date/sort show
- pivot zero values
- pivot zero values
- pivot date/sort show
- pivot field definition in VBA
- Variables
- EXCEL FORMULA
- List Box Help
- can't use Application.Run() with apostrophe in file name
- Running Dialog Sheet when opening Excel File
- paste special
- Summarizing Data from other spreadsheets
- Help with creating template for users, need to protect cells, but...
- How to avoid deleteing certain rows?
- In Excel 2000, how can a macro look for the next empty cell?
- Specify ScrollArea in a Sheet
- When does entering data into cell end?
- getting a cell value from another spreadsheet
- paste table from pdf to excel
- worksheet change event with .NET interop
- paste table from pdf to excel
- paste table from pdf to excel
- paste table from pdf to excel
- Problem with Option button control in multiple sheets
- Copying cell data without the formula
- Range varying in for loop
- Copy non-Zero columns to new location macro
- Fill Macro
- Need help to convert formula
- Drawing a clickable Button over the App title bar ?
- slow code needs tuning
- Controlling Word from Excel using Mail Merge
- Creating a virtual table in VBA Excel
- Creating a virtual table in VBA Excel
- Favorites.xla
- Save As macro
- Draw a Clickable Button on XL Title Bar !
- Runtime Error 1004 Select method of Range class Failed
- Can I autofilter across multiple worksheets?
- Turn ON Autofilter Filters
- Can I autofilter across multiple worksheets?
- Generating Ranges in VBA
- Excel linked spreadsheets
- Summing Like Element Array Values
- setting up a hopefiully simple macro
- Dynamic Array problem
- ofind
- RUNTIME 424 OBJECT REQUIRED???
- VBA Recording wrong... whats the deal?
- Protecting a workbook
- vba and conditional totalling ... WorksheetFunction SumIf ?
- Fill Down to variable row
- add form with excel 2003
- Problem Running Code in Excel 2003
- MsgBox Display
- Split function
- SQL question
- how to update a pivot table on shared workbook
- Rename Textbox on Worksheets
- Excel 2003 - Error Running Macro
- disabling right click
- how get value of status bar sum?
- Referencing a Range
- Paste Function Value
- Find the Format of a cell
- Referencing a Range
- Problem with TRIM function in Excel
- Password on Save As
- Split Function
- Error: Sub or function not defined
- test
- SaveAs Protection
- Formula
- Freeze IDE or other strategy ???
- How do I create a Macro?
- Workbook Copy
- Help me clean this up...
- Find the Format Type of a cell
- Referencing a Range
- How do I find the number of elements in an Array of Strings?
- Need to fix the number filed so all numbers are 8 in length
- Copy formula
- Complex formula?
- EXCEL-VBA, ADO not connecting to a TXT file
- Excel Macro or VB?
- sub call with string
- Calling a specific version of Access.
- page number middle of sheet
- Summing a whole column
- Access toolpak program from Addins
- Need coding help.
- "Subscript out of range" error for: Workbooks("Test1.xls").Save
- Userform Objects
- Cell lies within range
- Excel in VSTO
- Find & Delete Rows
- Message box when date expires
- Placing a form inside of a form
- Delete sheets with "@"
- copy then paste a chart as a picture
- Enable Command Button 1 & 2
- Where is the computer's archive?
- Formatting MsgBox Text
- So easy you will probably laugh
- Binary operations (left/right shift, binary and/or, etc.)
- excel 2002 vs.
- Disable command button
- active a set of VBA code once the cell have data.
- Line colour of .SeriesCollection.NewSeries?
- Excel 97 vs Excel 2002 coding
- userform
- Command Button Problems Still
- option group on excel sheet
- message without stopping execution?
- Excel Process Doesn't End :-(
- Excel pivot fields and trailing spaces
- find pagebreak
- A VB code for creating count down timer / stopwatch...
- Trouble with validation
- range = range
- error - copy
- coding help again
- code to check a: drive has a disk in
- copy formatting
- Yahoo Chart Into Excel
- Pivottable problem
- Automation Error : The Object Invoked Has Disconnected From Its Clients !!
- cuting some text from field
- Variable not defined compile error
- clipboard cannot be emptied
- Setting sheet.xlt for a workbook programatically
- PING ... Bob Philips
- Correct Syntax for Calling other Subs
- simulate a enter key behaviour?
- how to use a macro to copy cell formats from one workbook to anoth
- Getting the row/column number
- Cell data validation
- Sending Workbooks via Email
- Copying spreadsheets in directory into master spreadsheet
- bar graph colors?
- need a formua for wages
- webquery loses format of leading zero and to scientific
- Macro Help
- Runing part of the macro
- Setting up a List Box
- Data import/extraction question
- Go to another macro
- ByRef argument type mismatch error?
- Macro Help
- Getting error "Too many cell formats!", how do I correct?
- Starting macros when cell changes to TRUE
- Message Box Improvements
- CountIF on two conditions
- sendkeys problem
- Getting data from a workbook without opening it
- change query path
- Fixing SSN's with a macro
- Quick Formula question..
- saving to two places by selecting one (VBA)
- Macro copying macro code
- formulas and colorindex don't work after opentext
- saving to two folders by selecting one
- User form and text boxes on charts
- data entry to next blank TextBox
- Finding a value
- Deleting Shapes in a worksheet
- How can I disable the save function depending on one cell?
- formulas are not working on my spreadsheet
- EZ Formula Syntax Question
- Multiple line, two cell accumulators
- Chart Objects
- Copy columns to last populated rows
- How can i get autoformat name of range in excelsheet?
- displaying time in a combo box
- Save from a template to XLS only visible sheets
- Numerical Breakdown
- count a value in cell if the cell to the left has a certain Value
- Excel 2003 - Error Running Macro
- displaying times in combo boxes
- ExecuteExcel4Macro Problem
- Buttons Moving around page or shrink in size on Excel Worksheets
- Saved seems not to work
- where put code for automatic execution upon opening workbook?
- SheetActivate
- Selecting cols and doing a formula using variable offsets
- Rounding Ranges
- Procedure not working, and I do not know why
- percent of total with partial items
- Extract Data From Multiple Excel Files -> One File
- Run Access Macro from within Excel
- get data from one sheet list in another
- Excel -> Word: Problems copying/pasting shapes
- Range for a single cell
- Validation help
- Referencing an opened Workbook
- Event to trigger when form is scrolled
- Removing Duplicates
- Copy columns to free space in diff wrkbk
- redo CommandBar("cell")
- Publishing Workbook or Worksheet (HTML)
- Print Macro..
- HELP-- Filtering and copying data to a new sheet (w/ macro)
- Add a Range to an existing Range in a loop?
- specifying ranges using cells
- Print Macro..
- I'm trying to disable a clip board
- Data Validation Listbox and the Worksheet Change Event
- Making Cells Automatically Add #'s Instead of being written over
- Vlookup in VBA - Driving me crazy
- stop web query
- .NET, CAS and Excel Development
- is there any way to create a formula in excel for amortizing
- Problem with Named Cells
- Auto Row Height for Merged Cells
- Automatically run macro on sheet change
- can't copy a sheet within same workbook
- can I compile excel as a stand alone programme like access
- How do I call this function?
- Comparing values in 2 columns - Help needed
- vb dummy - two routines
- Excel and .NET
- How to check for an open Network connection in Excel VBA?
- Capturing Excel Copy/Paste/Cut events
- Update on Worksheet_change with data from other sheets?
- XP Styles on Excel Form
- excel auto-formatting - help
- copy the drop down list value and paste to next column
- Looping with Excel Forms
- Finding the last non bank cell in a column
- Repeat Entries
- Named ranges and variables
- cell locking via VBA
- List Box or combo box into a cell
- Ping - Bernie (or any other sage)
- Switch board
- excel in the foreground
- Find specific cells
- Matching values in 1 column to data in another
- Re: Matching values in 1 column to data in another
- hyperlink a cell to an email message
- Help needed to consolidate variable ranges in excel vba
- 2 values in 1 cell
- ToolTipText
- How can I query the 'indent' level of text in a cell?
- Advice on three dimensional array (difficult?)
- command button
- Running macros from shortcut keys
- I refuse to be let down by the experts
- Removing & Importing a macro module
- command button question
- copy equation to new row
- working with data from several worksheets.
- Named ranges and variables
- works in Xl2000 but notXl97 - help required
- Combobox
- VBA/XP/2000 On Error Resume Next problem.
- Looping across worksheets
- Are you sure message
- Subtotals error '1004'
- How to access parameterized property in C#?
- Macro
- Problem with Pearson Code
- Macro help?
- Excel 97 upgrade
- vlookup with closed workbook
- Simple Moves
- Macro ?
- Combining data from multiple workboods into one
- Save File with Date and Time Stamp
- Advanced Filter
- Sending email from Excel vba problem
- Histogram Bins Created From Sum Of Two Cells
- Pushing results HELP!
- base formula calculation on whether different cell has formula
- Variance formula - is this correct?
- copy a worksheet - but not the value (text)
- international excel issues
- In desperate need of assistance
- Do Until
- Solver rounding
- Coping numbers only in cells to other worksheets.
- Macro Won't Run in Excel 2003
- how to create chart by VBA coding?
- Very Basic Excel Object Questions
- Get value from combobox
- Reading mail attachements
- Re: eliminate header&footer for spesific pace
- Data copy from a seperate sheet to data sheet
- Passing a Sub's name as parameter
- PictureBox in Excel VBA
- Macro for delete row with "vlookup"
- Automatic Printing
- Word Mail Merge and Personal.xls problem
- "... whats this??? am puzzled
- Checking for empty cells in a range
- Checking for empty cells in a range
- Out of Memory Error 7
- fast range copy (without clipboard and with formatting)
- help again, last line required
- X and Y Screen Coordinates of a Range !!!
- telnet without sendkeys
- TextBox Color Change
- Steam Leaf Plot in Excel
- Restricting access to ceratian cells
- macro to paste data in alternate cells-pawan
- send email from button
- Automatically starting a macro
- How to use Tools, Data Analysis, Regression in Macros
- macros
- How do you generate random numbers in a normal distribution?
- how to attach macros to excel permanently - pawan
- import fixed width text file
- Autofill formula to last row with data when rows will be dynamic
- "Can't find project or library" error message
- MACRO
- fao patrick molloy
- Textbox values
- normal distribution of random no.'s
- RowSourceProperty
- time line
- help with code
- searching cells for a string of text
- Data extraction... (Pls Help)
- Read Only
- What formula can I use to compare items in two columns
- Executing a macro in a closed workbook
- HYPERLINK link problem in Excel sheet using VC++
- Application.Mode
- offset function
- Static variables
- Link cell show zero when source cell is blank
- MyRow error
- incomplete code
- Macros problem with XP
- Split() method
- Unprotect workbook without password
- SAVE AS MACRO
- delete row base the value of certain column
- Delete Row if text or empty
- Excel Application Level Global Variable
- Which control is the one selected?
- notify drop event of excel/word in C# add-in
- Macro works for me but not user group
- how do i convert a number stored as text to a numb in a vba loop
- RE: HYPERLINK link problem in Excel sheet using VC++
- Userform retain data after closing and reopening
- If condition
- can i use formulas in calendars in excel?
- XL 2003 TOOLS/Macro/security level inactive
- Looking for a 'Contains' Formula in Excel
- Group cells and sort
- macro for formatting
- textbox scrollbars disappear
- Help using a cell ref. to go to another page for data
- How to check for an open network connection?
- multiple line two accumulators
- ms query - from statement
- Invalid qualifer
- Subtracting Dates VBA
- Subtracting Dates VBA
- Worksheet too big
- Inclusive/Exclusive List
- Automatically transfer selected data to another sheet on print
- Loading array into list box
- Throwing an error ... on purpose!
- Mouse-over content in bubblecharts
- Wrong result returned by UsedRange.Rows.Count
- Help with If/then macro in VBA
- How reference columns numerically (not Cells() )
- ADO connection retrieving data to Excel using EXCEL-VBA
- Maximum value of two variable
- Countif for a string
- problem with text from macro?
- Personal file slows navigation
- Importing Data from the Web
- A math/algorithm puzzle!
- opening a file
- how do i chk is sheet exists my attempt included
- names of areas
- functions
- Opening item from Listbox... Need Help :P
- Worksheet has to set to visible as it is not visible after saving and closing Excel by VB.
- How to force Excel to complete one statement before executing othe
- Help w/Insert
- Deleting Pictures
- Using List Boxes and returning Value to cells
- Have chart lines take up full area of chart from left to right
- Search a text file for a string
- protection
- savings files with the use of variables
- Re: Accessing personal macro's all the time
- Save to sheet 2 in workbook
- Timed loop
- Code for Conditional Formatting with Five Conditions
- excluding text entries in calculations
- How can I use values in two separate cells to select a new cell?
- Help me migrate
- Find and change external links to point to the same workbook instead
- Excel VBA: Move Userform Based on Active Cell?
- Unknown problem with simple VBA code
- reliability of macro results
- Macro to find text in all worksheets -pawan
- Anyone in a really good mood?
- Report for Conditionally Formatted Cells
- Problem writing Excel formulas via ODBC
- Max number of worksheets in a workbook?
- Textbox Format
- Print 3 Worksheets
- Re: Problem writing Excel formulas via ODBC
- Sort and Specify that you have a header row
- return text not index for property
- Merging Pivot Table Data
- Macro to copy columns from 1st sheet to 2nd according to mapping-p
- Flexgrid Control
- Copy/Paste charts
- Summing a range if a certain background colour
- How to open new instance of excel if excel is already open?
- Page Setup Macro
- Re: return text not index for property
- after clearcontents() new data is positioned below the cleared ran
- Re: Problem writing Excel formulas via ODBC
- Formatting Y axis values based on other chart
- Dating Problem
- Find the last row
- problem when inserting or deleting cells
- Drawing Objects with duplicate names problem
- Object variable error
- Why!!!!!!!
- wrong positioning of data in sheet after clearcontents()
- how tot open VBA Protectoin
- Workbook Bigger and Bigger
- forget my passwerd
- Populating List Box from SQL Server
- Print splitting...
- Combo box control Drop down list moving
- i losst my VBA excel Passwerd
- searching on more than one column in VB code
- searching on more than one field in VB
- trying to get a row to break....
- Determine last row in columns 1-4 to copy a formula in column 5
- how to stop a macro
- Alignment
- Select range -- convert formulas to values
- Does some one has a golfscore in excel sheet format
- Need vb application to print first Worksheet in excel files
- Excel 2002 Workbooks.Open failed.
- Re: How to add an entry in the Excel Right-Click Menu
- Problem with xlCenterAcrossSelection
- Select the last Cell of a selected Cellarea
- Help for ATL functions
- Formula Help
- Saving Multiple Sheets to Another Spreadsheet Without Leaving the Initial Workbook
- command to show top of worksheet?
- Macro to delete sheets and saves remaining file does not properly delete module
- Re: Accessing personal macro's all the time
- Having difficulties with For If Next loops
- Summing a range depending on cell background colour
- Visual Basic Tool Bar
- Auto-Enable Macro's
- Read Only Problem
- Linking List Boxes and Textboxes
- Auto Adjust the Width of a Column
- Is there a way to programatically resort the sheets in a workbook
- Hiding Tabs
- Max value in 1 column when all values format are text
- Inconsistent macro behavior
- Userform - ComboBox fills TextBox not working
- Code that can't be seen/modified by users
- Information about ATL functions
- VBScripting syntax for Autoformat
- selecting cell range in other worksheet without switching to worksheet
- How to make user forms FULL SCREEN?
- VLOOKUP
- Can an Array Formula Solve This?
- How do I track frequency of occurance in data table?
- Delete a workbook
- Re: Auto-Enable Macro's
- Copy from two files
- Screen size
- Hyperlinks
- Send Mail Script Help
- GroupWise integration
- lock and unlock cells programatically
- Determining Which Page of MultiPage Initially Shows
- Delete PivotCache
- How do I use the AutoSum?
- Copy information down specific cells
- Screen size
- changing variables?
- export excel spreasheet into a text file
- Row Selection or Column Selection or other ?
- Simple Cut & Paste Macro needed :)
- Count If, criteria is greater than
- macro to find if the Excel file is using by other user
- Trouble with ActiveControls and Forms
- Macro to move text from one field to another
- Sheet1 (Code) problem
- Help with following code creating chart
- Use Excel Macro in Access
- Table Help
- MAX in conditional formatting
- Selecting more than one sheet
- Creating Excel Addin
- Re: base formula calculation on whether different cell has formula
- remove Worksheet using Sh.Delete without prompt
- VBA newbie needs a little help
- Could You Explain the difference?
- How to delete cells ?
- Creating an Autoexpand in Excel Combo Box
- Header Font size
- copy data to each worksheet
- Combo Box to return a value
- Re: Macro to delete sheets and saves remaining file does not properly delete module
- Re: Use Excel Macro in Access
- SaveAs Crashes
- 2005 Excel User Conference
- C# worksheet function poor performance
- Help with Named ranges
- Help with named ranges
- Activating/De-activating buttons
- Copy Code needed
- excel problem...help!!!
- In search of VBA script
- Bad File error: Need Help
- copy cell after resize method in VBA
- VBA Security
- How do I use the ActiveCell's contents as a string for a web query
- Excel Function Help
- How to search a range for a suburb in a large range
- Quit without saving
- VB Code Location; sheet, workbook, module
- Way to Link Tab Names
- Send Email from Excel
- good book
- how to filter first column only in range
- Accessing Menu Options from VB Code
- Pointers??
- Get Range, that user marked
- Problem programming the Sort command
- Input two cells with one selection
- Code to list users that have changed a spreadsheet
- Worksheet SelectionChange event
- Assign a macro to create a pivot table
- Screen Positioning of a Dialogue Box !
- Copy command
- Omit page with no data when use "show page"
- Filter Excel bases on the current user
- Re: Formula for timecode duration
- Searching 1 column for data
- Self destructing code
- Delete Sheets
- Cutcopymode problem
- Have Excel VB Read from two sheets
- Re: Formula for timecode duration
- How do I get the address of the cell that is being calculated right now?
- Launching Excel wb from Lotus Notes document
- close excel without saving
- i have problim with my excel VBA
- Reg: Incorrect RecordCount when opened a Excel sheet in ADO Recordset
- Using excel as a database
- Skip blank cells on transpose in a macro
- AdvancedFilter in VB
- vba help
- Hiding and unhiding columns
- deleting objects
- Help required to run simple macro...
- refer to cell using the value in Row 1 and column A
- How do I add help info to a user defined function?
- Comparing 2 workbooks
- Totals
- Make a button disappear
- macro problem
- Insert column
- Password
- Problem adding a range in Sumif function.
- form
- Display "Does not exist" upon search no results
- Changing the Colour of an Auto Shape (Line)
- Programming to delet padded spaces
- Modify VB for a Runnning Total
- Page Breaks when data is NOT on column "A"
- Coding problem
- RE: workbooks.open without triggering event
- Disallow Paste
- Memory Management
- Virtual Memory Macro
- Sheet / Hide & Unhide for editing only
- The case of the missing buttons
- ScreenUpdating Question
- Closing Excel from Script
- objectos
- Slow Performance Hiding Rows
- Microsoft Excel Expert ????
- Excel in VB.Net code
- Query on Date range does not qualify the Year
- Solver GUI works fine, but the VBA macro won't return any results
- Highlighter
- move down 23 lines and make the 23rd line height 92.25
- On Error GoTo If
- Splitting fields from commas
- Macro problem
- Re: Splitting fields from commas
- Text to Value
- Publish method failing, can't understand why
- Parameter in Macro Call?
- Safely automating any language version of Excel
- autofilter
- Printing a Report
- Ojbect required error msg
- how to Detect paragraph in cell in string?
- Newbie
- Range value cells with Sumif
- Textbox question
- How 2 Execute Sheet1 Button_Click Code from a module function
- Web publishing question
- 13 type mismatch help
- set up a command button or macro for open file to "save as"
- Help with find and replace macro
- Controls on form disappear
- Autofilter and Listbox how to acomplish?
- VBA Excel Macro - One File Auto Create Multiple Excel Worksheets!
- VBA Program to Email-able Toolbar
- Can this be done? If bn=b(n+1) and cn=c(n+1) then delete row (n+1)?
- Data Validation Drop-down List Limt?
- Please help / Named range help
- scroll bars in comment boxes
- Loop
- Find a Value Pass Row 99
- Storing column references in a variable
- I need to return the name of a worksheet in another worksheet cell?
- Worksheet Change code not running when you just delete data in cells.
- Controls auto resizing with scree resolution
- Help needed on program
- Help with code...
- AutoFilter: Loop Thru Visible Rows?
- Spreadsheet Performance
- Can you use worksheet names in macros
- Autoexec Macro
- Indirect and Offset argument
- Stopwatch query
- Listbox Help
- Help with a hanging web query (any timeout suggestions)?
- Code Help
- Using Dialog to select a Workbook, Worksheet and Range
- How to represent an empty cell in excel formulae?
- worksheets feeding to other worksheets
- text is deleted when cell is edited
- Another coping and pasting macro
- onAction with parameters
- Cut - Paste in xls file (c++ code)
- vba for lookup and autofill
- how do I remove quotation marks from .CSV file
- form in fullscreen v.s Screen resolution
- Excel 2002
- How to scroll data in a chart?
- ADO Connection Help
- fill cells with colour if content of another cell has CR
- Working with XML Files
- Import grafic
- Creating a PivotTable with VBA
- Return Current Column Letter and Row Number
- Selecting text
- Open a file with a macro
- Saving excel files as jpeg
- XML Files
- List of Unique Values
- Lookup from multiple columns....pls help...urgent...thanx
- Calls from sheet module to ThisWorkbook module
- printing excel worksheet
- Schedule a Macro To Run on cartain day
- Loadin ADD-IN programarically
- Variable List Box Range
- Email Single WorkSheets from a Workbook
- Inserting a Row after a name
- Control disappears from form
- Enable - Disable Macro Dialog Box
- how error-trap "no cells were found error"
- Open a VBA Macro when Excel Opens
- Worksheet Change event code moved to Worksheet Calculate event... and it's not working
- Create and write XLS using OleDB
- Tranferring Text from Excel to a Header in Word
- command button for vba module
- Format portion of formula