- Locked form: {End} key with arrows doesn't work as normal
- Lookup
- grouping
- Looping through my worksheet and copying cells
- How do I make specific columns Proper or Caps?
- macro needs to reference cell values in different worksheets
- Object variable or with block not set
- Starting a Macro when Command is Executed?
- Random Selection
- How to stop warning message when opening excel file in IE
- Workbook name
- Run macro when worksheet is opened
- last column of a row
- Change BackColor
- Accesing Word Document from Excel???
- Printing order
- hide columns from find
- sorting a large selection
- Frame on spreadsheet
- Finding two variables on the same row to match function
- How to perform action in all worksheets
- UserForm Popup Menu ?
- Help with listbox control events
- Array Question I think
- hide save as
- If Then Help!!!!
- Forms Textbox and Assign Macro
- Set up contract expiration dates program?
- Help on Excel data auto generation of graph
- Iterating through cells, comparing values
- If statement not working right
- Re: Help on Excel data auto generation of graph
- Inserting Excel Range into Word
- find "closest" match
- Re: Help on Excel data auto generation of graph
- macro to paste certain cell formats based on wksht name
- automatic printing / print report FIXED
- activeX dll
- Determine Column
- color selector
- HOW TO PORGRAM WITH EXCEL?
- Creating Sheets in VBA
- Search Text in Comments
- VBAProject Properties
- Save .txt file to .csv in VBA
- Individual Page Selection
- Output Text in specific place
- HELP! What's wrong with my code?
- Problem with cell value
- copy row
- Re: HELP! What's wrong with my code?
- How to make Pulldown menus
- Split or copy records n-times as excel scans the value of a colum
- Controls in a Worksheet
- look up syntax
- dll reference
- Need help with dates
- Arrays
- Some sort of a For Each loop??
- CommandButton Failure
- Deleting a sheet via code
- Select Method Failing
- Prevent Autofill from changing protected cells formatting
- how do I transfer information from excel to an existing word document using a macro
- Find Autoshape
- Printing only a selected area
- ActiveWorkbook.Close (False)
- Excel User Conference, 2005 - Ft. Worth, Texas - Sept 16/17
- Routing / email
- change font size in excel vba
- Checking for security level to allow macros to run
- Macro to select rows based on a value in a column
- Problems with ChartObjects
- Font Size on Forms
- Select failed?
- Advancedfilter returning all rows instead of ones that match crit
- Problems with Paste
- macro running problem
- Deleting a sheet via code-- different criteria
- Write value to an Excel VBA variable by reading Access DB?
- Timed Message Box
- Testing an unopened (or opened) worksheet for VBA Project protected
- Forest & Trees????
- Count quanity of values in an Array
- how to delete a chart using code?
- Code for Registering Add-in
- remove routing slip
- Help with deleting rows where the value of the first column isn't divisable by a certain number.
- Can a macro be triggered when a cell is selected?
- Insert Character into Editing-Cell
- Making rows variable
- running private sub
- Reload Listbox - type mismatch error
- Worksheet_Calculate problem
- Problems with DATE data type
- Update custom formulas automatically
- Visual Basic - Macros
- Auto Editing the Row source.
- macro for paste special values in different location
- How to trap the worksheet_BeforeDeactivate event?
- way to run sub after user exits textbox
- Looking at previous columns
- Remove the filename when assign a macro to a menu command.
- Problemas with function Format()
- Custom Class and Properties
- User form/spread sheet
- Help for a macro change cell colour under many conditions
- count up the occurences of non continuous value
- Script question
- Data correction
- VBA English-Spanish
- Selecting multiple text boxes
- Use Parenthesis in Filenames - workaround??
- Scannig number of rows
- Help! Is it Possibe to write UDF(custom formula) inside sheet
- Counting survey responses
- Merge an entire row
- VBA error: Unable to set the Values property of the Series class
- Search and copy macro
- Preventing Users From Locking a Shared Network Add-In File
- tidying up code and refering macros
- updateLink; files with passwords , VBA help!
- opening ftp-file from macro
- Solver macro
- Mailing single rows via button
- sum on a variable range
- CountIf question
- (Newbie) Copying values from an array to the worksheet
- Date Format on Form
- Next For looping in a If
- Placing triangle symbols WITHIN cell for significance testing
- Cells formatting done without me allowing it in VBA
- select first non blank cell
- SQL CASE statement on EXCEL VBA
- Count number of cells in a range with amount > 0
- Make an indexer at rows for many txt files.
- MsgBox with Timer
- Excel function
- Find and Replace in Formulas
- Move page breaks programmatically...
- Save value on form
- Moving to a different cell automatically.
- Missing Cell in a column when it is on row 16
- Opening a Word Document from Excel - ??Stumped??
- Re: Moving to a different cell automatically.
- Excel 98 not functioning properly on formula
- A simple question
- Pass worksheet to macro as a parameter
- Determining the height and width of Print_Area in a closed workbook
- Looping through Worksheets
- The column return value?????
- Input Box problem
- Copy between variable workbook names
- Function with results in offset cell
- Excel and Word Bookmarks
- Duplicates
- Spacing Macro
- How do I FILTER this?
- Why code work in 2003 but not 2000?
- On hard drive, how do I restore .XLS prior to last save?
- Worksheet Navigation
- On Error Issues
- Excel 2000 Solver Problems
- Repeating rows at the BOTTOM of the page
- scrolling a sheet with vb
- Calendar Control
- Change Event on a named range
- Scenario If Date is greater
- Using Web Queries -- unusual problem
- Compare Cells
- protect with password
- worksheet.activate not activating
- IF FUNCTION Trouble
- cell selection
- what is the Excel macro command equivalent to "end up"
- Macros disabled
- how to close a form in vba (not hide)
- Test for dups in Array
- Need help adjusting my code:
- How to create dialog boxes
- buttons on InputBox
- Can anyone recommend an affiliate tracking program?
- code to run another macro?
- Copy Contents of 3 Columns into 1
- flash drives
- Sort the Tabs
- RecordSet object - Cannot get help file to display
- Save If Condition is true
- File Input Question
- command button
- Validate an email address
- SHELL to open an application and pass parameters to it
- Application.Calculation = xlCalculationManual mystery
- Code that ask user for a password before it runs..
- Time Format Input question
- Filling cells via code..
- A macro that copies and pastes autofiltered cells will fail.
- Name of running sub???
- problem to create a line graph
- help with arrray formula
- Disable hyperlinks
- Setting a value in an add-in
- Excel 2000 vs Excel 2003
- copy worksheet
- Sub too large
- Require Workbook to be renamed in order to Save It
- change macro wih macro, is it possible?
- variation to code needed
- paste special/values can be very slow
- Excel AutoFilter using ASp.net
- Explanation needed for CopyAllModules code
- RE: Excel AutoFilter using ASp.net
- Help! How to get all the command's captions within a CommandBars?
- How to make sure a Cell is within the current visible window's ran
- copy formula
- Command Line Arguments
- Centering a Shape over a given cell when resizing
- Advanced Filter...
- Loop through for condition and input in adjacent cell
- Re: Excel AutoFilter using ASp.net
- Attaching excel in Loutus notes
- Code for Advanced Sort
- New Menu in Excel
- Displaying the result of a formula in a text box
- Creating Option Entries in Excel Menu Bars using VB
- Multilanguage translation
- I Need Help To Do This Code In A Macro
- Macro to insert Current Time into protected cell
- save custom data in excel
- Custom Classes and Cans Of Worms....
- Deleting data in userform and database
- Program 2 shapes
- Changeing codename of worksheet via VBComponents collection
- Stuck
- Programmatically reading data field values from PivotTable
- File size...
- Between to values
- remove hyperlinks from objects in the excel workbook using vb
- Sudoko
- Command to bypass the asking to save option
- HELP! - Printing a sheet with values populated from dropdown box
- Send graphic to Access?
- macro editting
- vba date function
- Hide Excel Menu From Screen
- How to show the maximize button
- GetPivotData with column grand totals
- CommandBar
- macro equivalent to arrow keys
- Function to capture the time a cell changes
- Closing Excel
- Excel replaced HTML Project but Images are lost
- Dim Line Labels?
- HELP PLEASE !!! Replaced HTMLProject for sheets but Images were lost.
- Perplexing sheets.
- Repeat series of formulas
- module related
- Excel HTMLProject replaced on RefreshDocument iages lost
- Delete rows with different criteria
- Pbl calculating US$ values
- PANTONE to custom color
- Problem sorting a single column in a shared workbook
- Code to save spreadsheet
- Custom Calendar Format
- Looping through files in a folder
- printing to a pdf file
- Multipage Control Pages - Changing Index Value in Code
- Why is my digital signature is being discarded?
- Multipage Control Pages - Changing Index Value in Code
- UserForm Help
- how to control the "Save as type"
- My errorical understanding of Error handling
- get_Range Restrictions..
- The "Like" operator.
- How can I make this simpler?
- Password Removal Problems
- Autofilter
- Macro update
- Enabling sub menu items via vba
- skipping one row several times over
- "on error resume next" NOT working...
- Validate cell when contents are pasted into it
- Worksheet_Change with discontinuous cells
- Help with function that crashes Excel
- addIn functions in automation
- Visual Basic code to find next available (blank) row in a spreadsh
- Time Userform
- Selective Mailing Of Attachments
- Excel Column Width Units
- Password Protect Worksheet
- Installation of "Add-Ins" in code
- Add-Ins
- Changing DATA VALIDATION box color.
- Macros Security
- Use ADO to copy a graphic to Access from XL
- Saving and Closing multiple files and Excel program
- Selecting text only
- Excel automation question
- How to select columns using column index
- com add-in
- Toggling Display as Icon for OLE Object
- Getting the source name of an OLE Object
- Insert a row then copy a transaction
- extracting a number
- How do I create a list in excell?
- UDF not returning correct information
- importing into excel
- UserForm
- Dates not including weekends and holidays
- Graphs
- Information Rights management
- XLVERYHIDDEN
- Command Button Hyperlink
- Wildcards in Advanced filter criteria don't work with Excel 2003
- Selecting a defined Name via a cell's contents
- Macro to have user enter new worksheet name
- Re: Login System
- Named Ranges
- Setup Excel to autosplit one cell into two
- RE: Login System
- Sending keys to DocuCom PDF Driver
- Activesheet <> Sheets("Name")
- Error 1004 from worksheet activate procedure
- inconsistent size progress bar
- Use a Macro to Save a Copy of a Workbook?
- Application.FileSearch crashed Excel in Windows 2K
- Use Macro to open "Find" window
- Copying data from multiple sheets into one sheet
- Creating a budget from a list of transactions
- VB for Excel/Foreign OS
- Setting Column format as text
- Detect which shape was clicked?
- How can I know if Excel supports the fileformat constant?
- InputBox drop-down menu
- What library is xlLocationAsObject in for use in VB.NET?
- Help with file open and data organise macro
- get date from calendar in dialog box
- Why doesn't this work in Win 2K?
- Excel Menu help!
- Using a macro to work from Excel to Outlook
- Guardar .xls como .txt En Escritorio
- Exporting to a closed workbook
- pivot "fields per column" setting
- is this possible...
- Macros with switches
- Hide all PivotItems except for a specific Item
- Variable for column selection
- Newbie Confused...
- How to copy selected listbox item to sheet
- UCASE problem
- DR watson
- Find out which cell that called my function
- keypress on a userform (with code)
- Alternatives for Sumproduct?
- Moving amouse over controls
- Copy Method of Sheets Class Failed - after many copies
- calendar
- Automation Error ... Urgent help needed
- Array as output of function
- Transfer amount into next column with condition?
- What version Excel file was created in.
- Recursive Function + File searching to return path
- (macro, formula,...) To Copy columm in various sheet's
- Wildcard
- Protect Rows depending on Values in Particular Columns
- Trigger Event Code
- (Leo) Strange print to file behaviour
- macro to merge workbooks
- Formula for last numberic value in column
- Error in Loading DLL
- TextToColumn Split
- price and yield functions
- Cell wont calculate automaticaly!
- getting information about a pivot table
- Wildcard with constant
- Web Query Questions (2)
- Macro to Lock Columns
- delete the hyperlink linked to the organizational chart in excel using vba
- printingstatus
- Formating cells
- Macro for saving file on Auto Date
- Retrieving cell formatting from closed workbook
- This is not strictly excel, but I am running it from an excel macro
- Cell wont calculate automaticaly
- sum cells using command button ADD
- Sum only visible cells within a range.
- How to strip dashes out of numbers in a variable
- Return the row numbers or a dynamic range in VBA
- universal code
- VBA Code to name a variable range
- Sorting based on the first column of a defined name range (Unknown)
- Stop directory & folders changing in link when moving file
- John Walkenbach Color Palette
- Problems with a method form multiple worksheets
- Open files
- get file name for FileSaveAs
- Pasting embedded OLE objects to specific filename
- Format multiple pivot tables
- Repeat series of formulas - REVISITED
- Help needed with the following macro
- Find subtotals of 160 each
- Open files, skip a folder
- functions
- Hiding rows if...
- Inserting Dim'd Name Between Letters?
- VBA Date formatting and locale
- How to inserting text in thos email macro
- still stuck: get filename from range
- Searching for Duplicates across columns and print to new column
- using worksheet functions in code
- how to hide the "(All)" option on a pivot table
- UserForm
- Union over multiple sheets
- cutting and pasting ranges using offsets
- how can i adapt this formula?
- Simple Question (for you wizards...) please help
- Automation and multiversion of Excel
- Creating Status Report like Microsoft Project
- VBA Post
- Range Question (very simple)
- InStr
- Awkward autofilter question (URGENT!)
- VB directing IE to a local site's html page
- Ado Filter ?
- Help on Codes for Accumulating Figures
- Range.Find skips the first cell ??
- Macro fails after screen is locked or screensaver becomes active
- Question about links
- Subroutine vs GOTO "On Error"
- range division
- Current Month
- How can i attach active workbook to email- please see the macro
- print screen
- Date Subtraction/Time between Occurences
- using a For-Next in a module and a Form
- Protection problem...
- Recording simple Macro
- Retrieving cell formatting from closed workbook
- Help me modify this VBA code please:
- Help 'Number Stored as Text Error' !!!
- range function
- auto_close and removing menus
- Copying Custom Toolfaces
- Request assistance with cross sheet problem
- Web query on Open
- Inserting "template" rows
- User Forms and Excel Functions
- Loop until a unique worksheet name is entered
- Data Area in Excel 2005
- Re: Ado Filter ?
- Sort Column B against Column A
- Seting a Constant (via code) when creating a new file based on a template
- Help to get values from 3 option button in one cell
- silly (?) problem defining ResultRange
- MsgBox "Invalid property value"
- Setting a Constant when creating a new file from a template?
- importing worksheet via code
- Help in Table Macros
- ScrollBar object
- How can I duplicate a user form and all code?
- Detect which shape was clicked....
- How to Auto Filter Even and Odd Numebered IPNums from huge collect
- Save method and BeforeSave event
- Development considerations for Win XP
- row sum - 9 cells change values to 1 and add the "1"
- URL string, pulling in Stock Data
- formula in vba
- data validation
- Variable ComboBox on Userform
- creating a Help tool thingy (msgbox?)
- Getting timestamp from a file in Excel
- Timeout
- Using popups instead of Message Box
- getting row and coloumn info from listfillrange
- John Walkenbach Color Palette (Repost)
- Handling Combo boxes...
- Function Counter
- User Defined Function
- Checking External Sheet References in formula
- Easier Sorting
- Word Search in VBE (True/False Solution)
- Disabling the standard X-Button?
- VBA column counts
- create a copy of a sheet and insert it into the same workbook.
- Filter Copy/Paste Fails - Two Ranges Selected?
- Re: create a copy of a sheet and insert it into the same workbook.
- Excel 2003 does not calculate automation add-in functions automati
- Project Window in VBE not displaying items grouped properly
- Speed-up a macro!
- Printing
- Help on Codes for Accumulating Figures
- SQL Database Query
- I don't want to see what a macro is doing when it's running
- removing date from field
- Excel printing
- Displaying A MsgBox for X Seconds
- adding two ranges
- sort problem with first row
- web page and excel...
- Writing a Date Function
- object error
- Properties of workbook
- exiting program
- Interfacing with Oracle 8i
- Find next cloumn
- Locating min/max number of x adjacent cells
- interacting with MS Access
- Fill Color Rows of Varying Size
- Excel 4 Macro Help File
- functions & range vars
- Excel treating text as function
- Re: Ado Filter ?
- How do I group data in an Excel Combo Box
- Weird... type mismatch only half of the time
- I need help Caculating Zip code Distances
- External Links Memory Error
- Formula for Filter
- Question About customized menu bar
- Determine last clicked object / control
- Return last column of dynamic range
- Delete bolded items in column
- Tie 2 or More Modules Together (vba)
- macro to find numeric data & move it
- Auto filter formula - help needed
- Deleting a blank sheet in a workbook
- show duplicate rows in a pivot table using vba
- stock quotes in excel
- VBA Code to access the ACT! 2005 data bases and tables
- Deleting A Worksheet - There may be data ...
- key press event?
- Re: How to plot missing points
- Test for fractions of a penny
- counting and loops
- Sub Worksheet_Change(ByVal Target As Excel.Range) Questions
- Macro to copy sheet(s)
- Simple assignment question
- Printing form & contents
- referencing the active cell
- Help! How do I Auto-Update?
- Need macro that will BREAK a running macro
- Hide individual/range cells and temporarily increase scale for printing
- Subject: how to calculate time in a payroll worksheet- Revisited
- Date Formatting
- lookup physical first worksheet
- How to get system login name
- How to get system login name
- Excel 4 Macro Recorder
- mixing of vba and sumproduct
- UserForm
- declaring Arrays to use in a Form with few modules
- Toggle Columns
- macro to email
- macro to email
- Data validation in 3 cells
- Use Subtotal Function
- Rearrange columns using VBA
- Formula help
- Solver Issues
- Can't delete macro
- Multiple Workbooks
- Cell reference to userform
- Selecting OptionButtons
- Printing from listbox
- Format column to have different decimal places
- ccard 6 or 16 digits
- close file macro
- Excel Macro Programming
- Formula to sheet change
- UserForm
- Check to see if excel file has been saved
- Merging cells
- copy / paste
- which function i should use?????
- Stopwatch In Userform
- Exporting to txt file, how to insert a "Enter" between lines
- if and else question
- How to open Excel file from PowerPoint?
- Range selection
- Chart
- NewIndex for ListBox?
- Proper way to write a conditional statement with ands
- Macro
- Graphics question on Excel VBA UserForm
- Compare Master Account List with Partner Accounts
- Heavy/Slow Calculations
- Add_Ins
- Problem with range and autofilter
- Auto Add Control to Worksheet (to edit data)
- how to check that a var type date is initialized ??
- Events... Changing the Interior Color
- vba for countif
- performance question
- cell change
- Paste text into a header
- Linking Dinamic Cell value into another sheet
- Trouble comparing to subtotals
- Rename a new workbook
- Matching Data on different cells
- Issue with 'Left' in macro
- How to copy 30 csv files from a folder to another folder
- RE: Exporting to txt file, how to insert a "Enter" between lines
- message box transient -sub by Chip Perason
- Re: Exporting to txt file, how to insert a "Enter" between lines
- How can I add values in 2 cells using a command button
- How can I add values in 2 cells using a command button
- matching values and inputing value in the adjacent cell
- Copy folder and paste to another folder
- put worksheet values into textbox on form
- Link submit button to another worksheet
- Macro security
- How Do You Turn A Partial Row Of Sheet Cells A Color From A UserForm
- VBE With Maicro Security
- Remove HTML links in excel
- Removing blank rows
- sheet protection
- Firing Click Events with Accelerators
- listbox value to a form
- worksheetfunction.sum error
- open up an excel program with an auto open macro
- Find the Sunday with min value
- Check for Hyperlink
- Extracting from 1 cell and placing extractions in multiple cells
- Your expert help required pls.
- filecopy
- help with an event driven sub argument please
- Help with multipage+chart urgently needed and very much appreciated!
- Wrong number of Arguments or Invalid property assignment
- Zoom via Macro for WorkSheet to activate?
- Scaling for printing
- Macro-Button make tu hide?
- VBA Declaration problem
- Excel paper setup
- Passing variables between Sub and Userform
- Web queries in Excel 2003 not working at all
- Automate Send To/Mail Recipient
- numbers to text
- Save .xls as .txt In DeskTop
- How do I select the first occurance of a number in a column
- Amend the Code
- *difficult* importing slection from a txt file to new column
- Use static arrays
- Position of Chr(10)
- Create Combobox Visual Basic
- A Function puzzle
- Copy a designed worksheet into Word
- Wanna listen to music while surfing...
- Wanna listen to music while surfing...
- Merging excel worksheets
- different colours for different data
- Checking for copies.. but not an easy one %(
- relative cell references
- ActiveWorkbook pointer for Macros from PERSONAL.XLS
- File saving
- Amending a text file
- Coordinates extraction and comparison
- form window too small - Help needed
- Code can't locate filename
- SpreadsheetML of selection
- Conditional formatting
- Indirect addressing
- date formatting in excel VBA
- Capture Update Links event VBA
- Pivot Table
- Fustration Help? Filter, Visible Copy/Paste
- Can a pivot table function like data filter?
- Rounding to nearest quarter hour?
- Can a pivot table function like data filter?
- Data validation named range update
- Position Form on screen v Window Zoom !
- Bit of help required.
- Msg Box to change Macro criteria?
- Help with vbModeless
- Help! Searching for text with more than one criteria
- VBA equivalent of GET.CHART.ITEM
- Re: Help! Searching for text with more than one criteria
- Error loading forms
- Prevent a workbook being closed with the X
- Copying text from regular textbox
- Auto changing field trouble
- How do I set the delimiter to save as a CSV?
- Date problem when opening a csv with dates in dd-mm-yyyy format.
- Error calling Web Service from Excel Application
- pocket excel and macros
- VBA Code Problem
- SendMessageString ...Maybe !!??
- Automatically Hightlight Rows with w/Date Check?
- Using "i" in File Names
- Need help with a formula
- What is the best way to protect VBA code
- Get floating CommandBar position
- Enabling context-sensitive help in Excel for ADO objects
- Count filtered data only
- Insert Function Problem
- Update links to other workbooks while running macro
- Diff tool for VBA projects
- Protect Excel 2000 Objects
- Generate list from other files
- Ranges in array formulas
- date subtraction
- need help with formula?
- How to show to a form in excel vba?
- Circular reference
- Using an Excel macro to open a Word File
- VB: Find blank row then add another blank row
- Define name, count rows problem.
- Rank the Data
- Ruler in Excel
- VB: How do I find next blank row then add another blank row
- i need formula help
- cross-footing in excel
- Putting column values in multiple rows
- Relative Reference Outlining
- saving Outlook attachments
- remove cells with one digit
- increment number by code
- Borders with Macros
- deleting non-numeric rows
- Excel Menu Item for a PC with multiple users
- column headings
- Filling Column with date
- How to 'Click and then perform action'
- Help With Conditional Formatting
- creating multiple line charts
- Certificate Discarded.
- formula to only calculate the last 15 entries?
- User Defined Functions
- Sheet names in a form dropdown
- how to make the barcode reader trigger a macro in excel.
- What can I append
- select data between workbooks?
- Open Outlook
- MACRO not working on two different files
- Delete empty rows.
- reading a user-set autofilter value
- VBA to save pictures from the web to local hard drive
- Saving Excel document without macros
- Positioning a char in a sheet
- Compile error in hidden module
- Logarithms
- Need Help With Moving Active Cell
- Need Help With Active Cell
- Simple message Yes No...
- how do I use a macro to center a shape in a cell in excel
- Question about dim statement
- How Macro Ask for Variable Input?
- VBA programming-autofilter function
- File with VB programming wont open
- code question
- index and match
- Listpro