- automatically copy into cells
- Runtime error 1004
- The Run-Time Error 1004 That Wouldn't DIE
- Macros & alternatives
- Selecting data from 1 workbook to copy and paste to a 2nd workbook
- programming a dice roll
- VBA Counting a range ofhgighlighted cells - before select
- how do I protect folders by password
- Editing text in text box grouped within a trapezoid
- PLZ! Help me out with this "killdupes" script
- Unprotecting not working in Shared workbook
- Pass multiple characters to a string variable
- How to replace defined portion of string
- Use varaible for worsheet name in a formule
- How do you look for quote marks?
- sumproduct
- Positioning MsgBox
- Replacing a string within a text file
- More than three conditional formats
- Copya and paste data pb
- how to create button?
- creating a list box
- Sending E-mail
- subtotal
- how to protect header & footer
- all
- Excel Form Validation in VB
- Is it possible to use the MScomm command in excel's VB editor?
- Squares
- Mirroring worksheet contents without using Pastelink
- Copy after Autofilter with no rows found
- detecting a tab delimiter
- Move Dash
- Finding Array Formulas in VBA
- Commandbar not visible in a graphic
- Colors overridden in a Macro
- How to catch the workbook names...
- Selecting a column
- Convert to Number
- Hlookup
- ambiguous selection
- Algorithm Challenge
- Excel and Shockwave Flash (Active X Object)
- Need to find named ranges in Excel
- Deleting Worksheet Error
- Shade Columns based on criteria in cell.
- creating a new sheet (back log)
- variation of 2 rows
- VBA and Excel web query not accessing the Web
- Import CSV to 1 sheet
- Cell Formular
- importing 10 sets of data with a macro
- I want a macro that can open a worksheet in a closed workbook
- drop down problem
- Determing a range from numerical data
- calculation based on row and column values
- Tab key functionality in a protected worksheet
- Obtain Word Doc Info Into Excel
- How to catch the colorindex in a series
- Is this possible?
- Choose printout color or b/w using vba
- Brackets and Macros
- row select
- Replace code
- Calculation
- Sum a range with vba
- XL "encountered a problem & needs to close"
- Dates
- Visual Basic: Setting up a button to switch on/off a picture
- referencing a column
- range offset
- Insert value of formula into cell
- I have a smorgesborg of vba/excel questions
- droping leading zeros when writing to a file
- User Defined functions
- Binding data to a ListBox without using cells
- FileNotFoundException
- need help with "searching" and "end"
- Testing Values of Cells
- How to Combine Grouped Records onto one row
- Semi-Complicated Question...
- Macros to Organize the Data from multiple files to one file
- autofilter copy to new range
- Print If statement...
- Error In Saving Excel File
- hiding the column and row heading
- General Cut & Paste Issue
- How To Turn A Row One Of Two Colours Without CF
- Help me finish my project please!
- User Form Formula
- Palmtop for Excel / Excel for Palmtop
- Data Validation Drop-Down List Problem
- Code equivelent to a key combination?
- syntax for code in MsgBox()?
- Would like to ask assistance in filtering multiple pivots at the same time
- Code Calculation Problem
- autofilter/cell selection problems
- simple? Word Bookmarks link to Excel
- GetSaveAsFileName saves empty worksheet
- passing a range from another worksheet
- newbie VBA help please
- Format Half of a Cell
- BNF for excel formula
- Selecting The Last Row
- BeforePrint Event
- Can I make a Macro Undoable?
- Comparing data
- feed data in multiple files without opening them
- Finding error messages in a workbook
- Problems using SaveAs and SaveCopyAs
- Proxy Error (Connection refused)
- How to get a macro to work on another worksheet
- Problems with pivot tables and/or charts
- IDTExten2ibility2 OnConnection method: Can't get it to start
- Remove button
- How to export data to a closed Workbook
- Sending mails on behalf in excel
- no add link into history link....
- How to run a macro (in personal.xls) whatever file (in the listing) open
- NumberFormat
- can anyone help with copy-finding macro?
- Debug/Compile VBAProject not available
- Refine search criteria for Find Method
- Textbox/Cell Problem
- Add/Change Data validation list
- sheet tabs and selection
- Pivotitems("(Blank)") in foreign language
- ASP: CreateObject("Excel.Application") IIS 6.0 Win2003
- help needed with formula or macro or both !!
- not insert link into history of IE
- Set OutApp = CreateObject("Outlook.Application") - Runtime error 429
- Find last nonblank cell in column
- Save as txt-file macro
- Using Excel Library
- SetbkColor doesn't work !
- Automation problem
- Adding a worksheet from a date named workbook and save as current
- new sheet with change of column please
- help with dates
- Excel File Growth Problem
- Replace reference inside formula
- Print (Manual feed)
- Get the Date
- Date Type Mismatch
- excel encrpted
- run macro on only one open workbook
- is it possible to unable the user to add more sheets to a workboo
- macros
- Looping and Testing Cell Values
- How do you programically remove carriage returns within a cell
- EXCEL.EXE Application Error
- Combobox Problem
- Locked cell without alert
- Application events
- Nested For Each Statement
- find all the excel files in a folder.
- Find out what is selected for AutoFilter
- Help with "Waiting for OLE Action" error?
- How do I determine if it is a new file or an existing file?
- ComboBox input
- Can I use a Macro to unprotect a sheet in the workbook?
- Command Button in Excel
- Please help! Almost done...
- Add-ins
- Add a Excel's references from VB .Net
- Range with numerical data
- Date format
- Timer control in VB available in VBA
- Spin Button only allow upwards of the previously saved value
- on error exit sub
- Macro to select range based on cell not being blank
- Using a cell integer to select a macro
- Help with vb excel macro
- first column in row
- Need to know a workbook is just open
- Rounding up to the nearest 6" increment
- SOMETHING TO SHARE: Encripting/Decripting code
- Click Event taking time
- Macro to Insert Comment to a cell
- SUMPRODUCT Issue
- Plus sign in front of formulas
- Sort Help for Excel
- Help creating a macro to copy from one cell to another spreadsheet
- Re: Printing Views
- Recording macro for multiple cells
- Excel formula pasrsing - BNF, Yacc?
- range function
- How to make command buttons move among worksheets?
- LARGE
- Protecting VBA code
- access
- expanding a start date and end date to show all the dates in a list
- Recovering VBA Modules
- Workbook "Locked for Edit" Problem
- Disabling disable macros
- add line during code
- Remove links to other spreadsheets
- VBA Newbie stuck
- Date With VBA
- Function working on whim
- How can I run solver from a macro button?
- Macro doesn't work when I use Protection
- text in forumula problem
- Disabling the option to move cells programatically
- Problems using IgnoreRemoteRequests in a shared add-in
- encryted data in excel
- Using SMALL where first two values are =
- Hiding a whole sheet in a workbook
- Macro with non-static column length (name last row?)
- Easy Question
- type mismatch error
- logos and such
- Returning Values from specific cells in Excel using C#
- leading zeros!!!! arrrrrrgh! please help
- Extracting Terms from simple linear equation
- Code slows down after a few runs
- Forms Toolbar Button question
- Run a macro always I open an Excel Document
- Copy only Visible Cells of a Variable Range...
- Keep text color from a Index Match Formula
- How do I set up a while loop for formulas?
- how to update time in corresponding cell only
- How to identify operating system user in excel?
- Boxes on form. Datatypes error I think
- add/subtracting date:time in Excel 2000
- retrieve cell value from the cosed file
- Grouping Cells with Macro
- Worksheet().Range(Cell(), Cell()) syntax?
- RecordSet & New Class - Good idea?
- ABOUT MSGBOX
- Problem with Work_Sheet Change.
- Sort multicolumn listbox items?
- Conditional Test with Text to Speech Output
- Find a match and display a message
- Removal of empty cells in an Excel table
- Apostrophies SQL from Access
- Help Opening file on network
- How to display set of record s on the forms using previous & next button
- ChildItems and ParentItem of PivotItem object dont seem to work
- Can Excel 97 be controlled from VB.NET
- Code for Access file manipulation from Excel
- Access Link Help!
- Worksheet change
- help me out with this - it's killing me..
- How to control "Date Time Picker ActiveX Control"
- excel 2003 xlodbc.xla
- Excel hang when SaveAs
- Cell alignment centered
- view 100%
- Haw can I to create the numeric counter?
- remove query table when saving
- If, And
- Ignore other applications
- Syntax of this code
- Need help with insert text file Macro
- Filling out word documents and printing them
- OLE combobox
- updating spreadsheet.
- Excel User Conference - Book Winner Announcement
- Basic Code Problem
- messages from excel --> to avoid
- CDate Problem
- only display positive values
- The opposite of .Verb in OLE Object
- breaking a link
- Automatic cell formatting
- Open file without macros
- question on vlookup
- delete all the spreadsheet
- print preview
- SAVE AS code
- Workbook Before Close Event Cancel flag not functional(?)
- open cell formationg dialogue from macro
- Paste and Save As using Cell as name
- open, copy, and paste
- Toggling the NUMLOCK when using SendKeys
- Pivot Table list box
- Autocopy from one cell to another cell in a spreadsheet
- offic XP (Excel)
- I can only manually update?
- excel 2000 macros
- how to determine column heading from lookup
- moving between Excel sessions
- Marching ants
- Document variable in Excel
- Selection highlight color
- How to find my favorites?
- Save As File Control
- Variance in an array
- Capabilities of linking excel cells with outlook calendar
- Enter key movement direction
- Conditional Print Macro
- vba code doesn't work
- VBA to select a defined range
- Macro and Protected Sheet Problem
- Renaming of Worksheets from Input Data
- Help!! code to paste
- VBA macro in Excel to control Project
- Compile Error: Procedure too Large Question
- Problem with error trapping
- How do I link cells based on true/false?
- customized function
- Excel Query linking to External (outside domain) SQL server
- how do i delete just 1 hyperlink in a column of many?
- Assign formula array in vba
- How can I delete rows accordinng to formula
- Application-Defined or Object-Defined Error on simple code
- Variable Percentages
- Make a cell required
- Excel combo box - value list?
- How Invisible Can You Make Your Code???
- VBA SumProduct Problems Contiued
- add an extra row
- Newspaper Columns
- Advancing to the next cell
- i cant format textbox as number!
- how to get a macro to record F2, Home, Delete keystrokes
- Too large-how do I split
- TextBox1_Exit niet uitvoeren!
- Macro Security and other painfull issues
- Macro to border row from start column to end column
- Open multiple "unknown" filenames within a macro (array setup)
- Can anyone see the problem with this code?
- Searching within comments added to cells
- UserForm Tab Order
- Userform-Change textbox color and font based on input in other tex
- LastValue Function
- about macro
- Problem running row color macro
- How to automatic calculation and macro execution between 3 workbooks?
- add/subtracting date:time in Excel 2000
- Open multiple HTML files in succession
- modular arithmetic
- disable the close "X" icon
- Setting the Print Area in a macro.
- Deactivate sheet
- Error Code 6: Overflow
- Why can't I delete this shape now?
- Design
- setting minumumScale of an axis programatically
- Conditional Date Formatting
- Use Excel as Access
- Cut/Copy Combobox - I can't update
- copy from 1 sheet into another?
- OLE comboboxes
- last cell
- Conditional Commenting
- Populate a Combobox from range.
- Why Type Mismatch error
- RE: Excel Doctor
- Send from excel to webpage...is it poss?
- Conditional Closing and Saving
- Insert 19 cells "Shift to the right" if cell contains "->"
- Insert a chart on another sheet
- consolidating my BOM
- Excel seems to become lethargic
- Excel Save Issue
- Can I change this to work for a closed workbook
- copy formula in a range
- Text file import using ADO - XL converts fields to dates
- Apply Border based on last Day of Month
- Showing bookings in a calendar
- VB code to update existing Pivot Table
- Scrutinizing Controls on Form for Certain Value
- Newlines in a line-wrapping Textbox
- disabling a message box
- visual basic & chart data labels
- Selecting columns through a loop
- Time comparison
- Userform help needed
- Print Preview and Modeless Form
- Hiding A Row
- Need a macro to do this...
- Recognizing Date Ranges in excel
- ActiveWorkbook.Save DOESNT WORK !!
- Round a decimal to the nearest sixteenth
- How do I count number of occurrences (dates) in a rolling year?
- Error opening Excel app via automation
- How can I do an Absolute Cell Reference but non Absolute Cell Pais
- How can I do an Absolute Cell Reference but non Absolute Cell Pais
- Options other than VBA
- How to prevent unautherize change?
- Print a Spreadsheet w/Task Scheduler
- Compare/Copy columns from two books?
- TAB properties in a UserForm - Requesting Help from Excel VBA Guru
- Send Worksheet in Email
- how to replace a hard return?
- increment number by code
- Random Number Generator
- Queries / Excel
- assign objects into array or object variable?
- Runtime Error 1004 on selecting range
- ActivX in Excel
- Macros written in Excel 97 will not work in Excel 2003
- can I clean old excel data format with macro on funny spread sheet
- Subtotals and inserting formulae
- msgbox to lookup part text any help pls
- set "value if true" to "fill cell with color"
- PrintArea
- Excel Database
- Listbox
- Email with notes error
- working Excel worksheet on the astive DESKTOP
- Insert autoforms and objects dynamically
- worbook.name not accepting range value
- Thanks Norman Jones... You are a Genius
- Additional send to address for notes
- Code to bring my company up to date!
- Concatenating
- Business day difference between 2 dates
- ScrollArea
- How do I pass info from excel to a hyperlinked explorer page
- Identifying and separating groups of data.
- Excel vs Access what art the question?
- Make a Workbook into VB Program
- calling procedures from worksheet buttons
- VBA: Answer YES to Contents of Clipboard
- specialeffect to command button
- showing hidden items of a pivot table in a cell
- Handling Dates in VLookup
- VBA text file to .xls
- Running a macro to protect a workbook on a already protected workbook UNprotects the workbook ??
- Auto Run Excel macro subject to condition
- Group Pivot data by week
- search column for a specific piece of data using vba
- column of entry for textbox value
- Search and Copy within Excel using VBA
- VBA: Pasted Cells Not Formatted
- GetOpenFilename restrict file list to "ord*.xls" i.e., only list ord*.xls files
- Control save prompts in VB code
- search a column for a specific piece of data using vba
- pictures and buttons
- who can make excel appl. useful for Euro zone
- Excel BNF
- Setting Extended Attributes
- Macro Creation for name formating
- Formatting text in a user form text box
- Re: FW: See this internet package
- Event Procedure - Data Validation List
- Comparing Cells in Workbooks
- hidding worksheet within a workbook
- what do I do wrong?
- Fill and sort multicol listbox from VBA code?
- Choosing certain files in directory and one in particular
- advice.
- Update workbooks from a master
- How do I make Excel copy entries from 1 workbook to a new one
- How to Delete Another WorkBook Macros using Macros.. Possible?
- no word wrap in userform textbox??
- Issue with Do Loop
- copying to external workbook
- New Web Query Macro
- Dynamic Chart Range
- Custom toolbar with existing formatting buttons
- How do you convert Bday into Date in VBA
- Hiding macro menu
- Referencing a file name within a called subroutine
- Data validation across worksheets
- How to Delete Another WorkBook Macros
- Data Filtering
- how to use histogram in vba code - analysis toolpack
- combobox
- Counting people
- Highlite Items
- Change the FOR loop top
- Automating multiple entries from Excel to an Oracle-based database
- how do I copy from textbox or combobox into a cell
- Thank You Nigel
- declaring public variable value
- object defined error
- Code assistance
- Compare cell content from two worksheets
- Entering a date in a textbox
- Auto Filter + subtotals
- Excel Check Box
- MODE spreadsheet help
- Invisible Worksheet - Keeping it Hidden
- How to build a forward/back range finder
- sumproduct?
- Controlsource errors
- Sub Exits Unexpectedly
- Dates
- Public Declerations
- pasting and Ifelse function
- Paste after print to a new line
- rows
- Can't get rid of Command Bar
- Editing Macro
- PageBreak Macro with Hidden rows
- Different Controls across different excel versions
- Re-POST: How to close forms opened from other workbooks...?
- Why I get #Name? When I use a sub
- Semi-transparent label background??
- ADO & SQL
- How to launch one XLA from another on Excel launch
- Run a macro when a Worksheet is clicked/activated
- VB editor not saving desktop
- Creating Folder Folder in My Documents VBA - HELP
- Just a few questions...
- dynaically updating a defined table name address
- problem about sending data in Excel to an Access database
- Change Colors With 5 Different Conditions
- How to prevent dialog box
- Problems with Combobox
- detect column name of last populated data
- Countif using vba
- A Challenge (Linking word and Excel)
- How to make Dropdown box Jumpup
- Language
- Cell location
- hiding/disabling areas in user forms
- ActiveWorkbook pointer for Macros from PERSONAL.XLS
- beforesave and beforeclose
- delete duplicates
- For Each Function??
- Absolute / Relative References
- SendMail Method
- Excel section in a word document
- Repeating formulas in VBA
- clicking on a point in a scatter chart
- Linking a comment to a range
- Comparing 2 lists
- Find and print in new sheet
- Getting value from an unopened file (indirectly referenced)
- Printing rows in 1 block
- how do I let a macro repeat itself in excel
- macro to remove a named range always called "database" & if possib
- Additional Recipiants in Notes Send to
- Counting CheckBoxes
- Naming Worksheets
- code to export excel table to word
- Need help with coding a solution.
- Macro warning when opening excel
- Printer Dialogue
- Problem with using variable in Find statement
- If Then Statements HELP!
- Forms accessing SQL Server data.
- EXCEL Macro calling on Outlook
- .NET code hangs setting up a chart
- Check for References to Blank Cells
- Fill in Formulas
- Reference a User Name via macro
- Problem with Conditional Formatting when Inserting a Row
- excel macros "persisting"
- sumif does not work
- How do I write macros with relative reference cells
- disable send function
- Page Break bug update query
- VB scripts to calculate as NetWorkdays
- Code execution has been interrupted
- find and paste
- Worksheet copy issue
- SendKeys
- Re: find and paste
- application.ontime
- FormulaR1C1 gets strange application/object defined error
- Cell Select
- Copy and Paste Function
- ACTIVESHEET.PASTE not working.
- COPY - *want* to include hidden columns
- Adding Items to an array
- picking some data from a column
- adding code to shrink columns to reasonable width
- Drop-Down List
- transposing contact info
- UserForm with Frame - Problem
- creating excel spreadsheet from webpage using VB?
- Office 2003 Chart Web Component
- Automatic email when document changes
- Fill Down & Copy
- Editing VB Code with VB
- Looking for a Good HEX editor
- Inserting Form form Visual Basic...
- Like Function
- Macro names in a Module
- how to use object variable to change the property of a
- Hard breaks in text to soft breaks in Excel
- combobox limit to list
- Disabling Cell Editing
- deselecting...
- Send Formatted cells with VBA to Lotus Notes
- Programming and the Task Pane
- Find Unique Records from two sheets
- How do I set Excel cell format to "Text" from VB.NET?
- Delete Sheets in VBA Project
- Cell On change
- VB print to Terminal Services Printer
- Code not working
- Apply Border
- Running Macros from Command line
- CommandButton displaced after hiding/unhiding rows
- Newbie: MsgBox, etc
- Macro to save to .csv
- VBA column hiding
- Big Chart Printing Problem
- Choose particular files from a directory
- take text from form textbox and put in cell...
- Charts in VBA
- move text from form textbox to next blank cell
- From excel - open word doc and copy form field contents to excel c
- Reading a CELL value from another Excel
- macro button
- Dynamically adjusting Vlookup
- Delete rows in multiple sheets without loop?
- runtime error '6' overflow
- Application.DisplayFormulaBar Kills CutCopyMode
- Word Or Notepad From Excel
- Web to Excel, the format run out
- Help using macro
- button to print a sheet
- Double lookup
- count / move files
- Range holding non-contiguous cells
- Date Problems
- sub script out of range problem
- program excel worksheet to automatically not print blank rows
- E-mail look up
- AutoUpdate cells with statistics
- add different button images
- Restricting Access and applying a button
- How to put the image under the text
- resize colums / rows in range
- Auto height rows
- Enable toolbar button in one specific worksheet
- How to center text in a msgbox
- Autosave:: off
- How to pass interior colours of specified range to a control.
- Re: Autosave:: off
- WEB Query + IMAGES
- Functions won't calculate without F2
- richtextbox
- close WB after clicking DISABLE MACROS
- Error Table For Excel Comparisons
- VBA & SQL: INSERT TO... problem with date
- Open new workbook
- VBA Project Window does not show file folders
- OnStartupComplete and activeworkbook
- Disable/Prevent Letters or Numbers in textbox
- If you feel that this bug is relevant you can pay me rewards....
- HELP - Tabbing Between Items
- Open a workbook in the background (like filestream)
- Check if Active Workbook is Empty
- How do I refer to other macros inside a macro code?
- Simple question on For...Next loop
- initialize form field from previous entry
- Help deleting a row
- Delete Rows with Value greater than X
- How can I make macros execute on a protected sheet?
- Saving a workbook with a variable name
- Activating sheets with same name in multiple workbooks
- Add spaces to cell
- Looping procedure calls userform; how to exit loop (via userform button)?
- POSSIBLE CORRUPTION WHEN LINKING DIALOG BOX
- Refreshed Pivot Table still have old items
- Combobox Question
- Worksheet Protect in Excel 2000
- Is there a function for closing Excel using VB?
- Saving a workbook with a variable name
- zip files
- Find Format
- Find Folder Path + file Name Length and Insert into Spreadsheet
- Saving a file to a different path
- Worksheet Calc Gets Stopped When Sheet is Clicked
- with random No's calc how can I stop two different columns predic.
- Where can I find the Function names in other languages
- If sum = 0, delete row
- working with cells and text
- Auto E-mail
- Entering Data
- ActiveWindow.ScrollRow and ScrollColumn
- I would really like to send information to your marketing group
- Delete cell with red text
- In a excel/VB macro I am trying compare cells in different workshe
- Page Break Macro
- Protecting Excel Options-Tabs
- Problem with vbext_pk_Proc
- How can I automate a macro to run in timed intervals
- Open File Dialog Box on UserForm
- can navigate through intranet site with Web Query (VB code?)?
- Microsoft Visual Basic Run-time error '1004' No cells were found
- Cell value Change Event - Need to activate macro
- Problem: Control Toolbox Control resizes when clicked
- Program for calculating a power trend line
- Named Ranges
- Strange Charting
- Need help: delete colums
- Need help with date problem.
- combine worksheet events
- Complete Newbe - Is this a MACRO function or VB ?
- VBA Macro for Solving Linear Equations
- Program for calculation a power trend line.
- Tabbed form problem
- Deleting Range Names is Erasing My PrintArea
- Copy only first row of each group.
- Macro looking to Outlook for namespace.
- Validation Problems
- Import Txt file via vba but still choose column types
- Macro to protect/unprotect with password
- Sample Size
- Buttons moving when print preview is done
- Macro to Format the Pivot Table drill down
- Swap range values
- newbie: manipulating cols & rows in named range
- Macro command
- Recording user and date of when a file is opened
- Working with Dates
- Indirect reference and worksheets with single quote in the name
- Working with web server DB
- re: Automatically Delete WorkBook 2 modules by using Workbook 1 module
- how to populate a combobox with a list of unique values?
- How to apply CLEAN func.
- Help: UDF Used in Conditional Format not Initialized
- Fitting characters of a font size in a cell width
- Changing RightClick event handling
- need help fast!
- Manipulating Strings
- Label control - suppress GetFocus
- When does ISNUMERIC point to a number?
- Vba Excel - Checking if changes were made
- Links in excell
- How to apply colouring as in Cells associated with Forumla
- MS Query links
- Find method syntax
- PivotTable Multirange Challenge
- Accessing worksheets in xla add-in file
- Loop all sheetsand delete empty rows
- worksheet calculate repeatedly calling itself
- Data from Excel to Access
- Assign macro to each item of a drop-down list or combo box - how?
- Combobox Issue
- iterazione macro
- Combobox data from Database
- What does this Code Actually do Please
- Picking up E-Mail Details
- empty autofiltered range
- Auto macro opening excel workbook
- Running Total
- Getting Value of Array element in Immediate Window
- Copying formula
- Goto "Start of Sub"
- Problem with Mail code
- Macro to read filename in cell and open new file
- Writing formulas ...
- How change cntrl toolbx radio button from T/F to numeric output?
- Getting pre edit values
- VOIP autodialer
- Help finding a "batch processing" technique for a userform???
- Public Array in a form?
- Drag & Drop !?
- VBA - Cell Assignment