- Losing data during transfer
- Problem calling macro from a commandbar
- How do I detect and commit the current cell edition?
- need help with macro for 400 worksheets!
- Remove decimal from price to show straight number
- Replace all Pivot table data fields using VBA
- Excel Pivot tables connecting to sql
- Simple If Blank Statement
- check cell contents
- macro to copy cells that meet criteria (mattour)
- macro to copy cells that meet criteria (mattour)
- macro to copy cells that meet criteria (mattour)
- union with multiple sheets
- Row Grouping
- How do i grab a table value to fill a cell?
- Repetition of Code
- New to VBA - Help with Deleting Macro's
- Identify a single word amongst many within a cell
- Button programming Run-time error '1004' with range
- loop Statement
- adding a code to a cell?
- can I set row/column label as variants?
- Two sets of radio buttons on a worksheet?
- Automatic Calculation
- List items determined by content of previous cell
- Searching one cell
- Check Box
- Look for Errors
- Adding Sheets with names from a list.
- Macro to import delimeter file
- Red X close box
- Pasting an unknown range
- Else no If
- User Name via 1. API, 2. Enviornment, 3. WScript.Network
- Can I import/translate a Visual Basic project to Excel?
- Blank portions of the worksheet after the data
- Workbook Name
- using vells that fulfill a certain criteria
- how do I put today's date and other dates in macro condition?
- How do I Make a macro in exel to just open the "open" screen?
- Compare and count
- sum numbers is a column
- need some code
- WorkbookAfterClose Event
- Formatting and Worksheet_Change
- save Workbook
- Simple Macro
- Consol
- Consolidating Data
- Option Private Module
- Error with protected cells "Excel 2000 SP2"
- ADO Connect Access
- How to delete Radio buttons
- XLA not opening properly (Repost)
- inputbox uk date
- Application.OnKey Macro Cannot be found
- Update a record in the recordset
- Userforms
- PDF document with VBA?
- BeforeUpdate Event triggers twice
- How to create a PDF document with VBA?
- Use an entire row as "recordset"
- Customised Toolbar Specific to only 1 Worksheet
- After printing, macro runs slow???
- New to VBA, getting unexpected error 1004
- Error problem
- show customer based on Weekday
- Get data from Access to Excel Combobox
- Finding empty cell in list
- match some fields & write new file
- delete content of one sheet off another sheet
- How to restore a Custom menu if a user presses Cancel after selcting exit
- Adding - sign(-)
- Checks for duplicate entries
- Help needed
- Disabling old VBA Macro's with .NET
- Loading Userform Errors 1004
- visual basic .net and excel problem
- Create named range
- macro activation
- Rendered XML
- assigning value to option button
- Setting an option control
- Need macro help
- run macro on selection change
- Find Last Column??
- format text in cell
- Intialize a checkbook
- Stubborn Date Format
- insert combination of random letters and numbers - an example
- Date Reminders
- Help: Javascript to Excel VBA?
- Excel problem with dynamic matrix with a name
- Help with forumula to change text cell
- New to Excel Error 1004 basic chart programming
- determinig datatype in excel
- Object doesn't support this property or method (Node Function)
- DAte problem again
- User Form
- Catching errors
- Copy Values from WorkSheet back to Another Workbook Replacing Values in Worksheet
- Newbie needs help!
- Default printer selection in Excel macro
- Average of last 3 columns
- is there a macro I can write to email an Excel document
- CSV File with double quotes
- almost got it, but need help- pulling data from other workbooks
- Surely there's a better way....
- Update combobox
- ADO and pivot tables
- Hide all columns that span a merged cell?
- How to tell if Replace() did a replacement?
- passing a comboxbox result into sheets.select
- call code for all sheets
- macro buttons confused
- Trouble with 2 range definitions ...
- Can you remove redundant date entry?
- Save emails using only part of subject line
- Creating a new worksheet by checking for blank values in a range
- Weird calc behavior - Guru challenge?
- Using Cell Ranges
- insert random letters into selection - an example procedure
- object browser office 2000
- FitWidth not working in XML description
- Unprotect not working
- referring to worksheets by name in a vba fourier transform
- VBA Question - Is there a better approach?
- Footer-changing page numbers
- Refreshing a userform/listbox
- Macro stopping for one user out of 14
- Runtime Error 1004: Application defined or object defined error
- Worksheet_Calculate Running on Every Sheet
- Calling another workbook
- vlookup macro pasting
- Summing Rows With Date Filter
- Help with Application.OnTime
- How do i keep Leading zeros in .CSV file saved as from .xls file
- discover format of Excel Cell using VBA
- Form a circle (ie. color specific cells) given specific radius
- use an input box to select a range and copy to another worksheet
- How to create a PDF document with VBA?
- Average Without Zeroes
- Sequential number within excel
- How to write VBA code to solve this problem
- Posible to speed up query update with Apllication.screenupdating?
- Save Worksheet at .txt
- Find
- Unselect Cells
- View Locked Cells
- How to open up 2 file in excel using macros
- Formula or makro help
- How can i shorten this macro?
- Advance function of excel to get sorted data
- concatenate formulas
- Export data problem
- entering text into organizational charts
- listbox
- Restore Borders Automatically
- Macro to delete certain cells
- VBA Availability?
- Re: VBA ADO Major error
- Copied range from excel to word (but not in table-form)
- List wallpapers Windows XP & Vista
- copy multiple cells
- Min and Max value in TextBox
- Personal vba - interaction xls/xlt
- Ms query 2000
- CommandBars vs CommandBars(1).Controls
- Application-defined or object-defined error Please Help
- Assigning a macro to a button
- Insert calender into a cell
- Insert calender into a cell
- Re: Error in Excel 2000, but not 2002 and 2003
- Strange Pane
- Problems using chinese Excel
- Hide Zeros
- How do I make a macro automatically select Yes when a yes/no box appears?
- Problem collecting Range Values
- Search Tool
- ComboBox Code Problems
- Parse string
- LisBox Column Width
- scrollbar changes size
- Macro to enter record number in column A
- insert entire row for new data, external data range doesnt work
- How can I loop through all Formula in a workbook?
- Matching Text
- Protect with AllowFiltering
- printing a form
- Select Case Query??
- Selecting a dropdown option to display records
- text box for displays of information in excel cells
- RIGHT function in VBA
- Mandatory cell - display message
- Evaluate Custom Expression
- Line of Code to set references
- Compare Values
- Remote module call
- Macro template
- Cell Value in one sheet using SUM formula in another
- What is the connect string between Oracle & Excel?
- Works at one place but not another?
- workbook.open throws 1004 error
- Incrementing Cell Numbers
- c# RTD Server, IRTDUpdate Object
- Sorting Rows
- Split function to get a relative path
- How many decimal places can a cell display?
- Correct Format for formula
- Pop up code not working
- Extracting values from a table
- Paste value from another workbook and multiply by constant
- Full folder path from BrowseForFolder
- Sorting Data Colums
- return a value from a range
- regarding list object
- mouse wheel
- sort items of listboxes with multiple columns
- Merge txt files
- help with strange behaviour of macro
- Insert function - custom function name preceded by module name
- Copy data from above
- Use Variable In CheckBox Name
- Retaining focus on a textbox / listbox item pair after validation = false.
- code to copy a range of cells to another sheet
- Macro Query
- Listboxes and changing colors
- HTTP link in Excel
- mouse cursor to a button using api
- Macro - Loop or Next
- Clear Sheet
- Workbook Menu screen tips?
- Generate PDF from Excel & Attach to Email
- I'm trying to figure out what would work best for data entry and retreval.
- error with macro
- Set Group and Outline settings...
- Printer.Print Not Working?
- Setting Range in Graph
- Why Is Conditional Format Failing?
- Clipboard Event Handler?
- go to the same path of the excel file being launched
- Delete worksheets and the code sheets remain?
- Data validation - error alerts
- Update Range from User Form
- smoothly linking two presentations
- Corrupt Excel file - £10 to fix!
- copy and paste
- Who can make a chart of this?
- Preventing duplicates when adding records to list
- Birthdays
- adding userform command buttons
- Hiding functions in add-in
- VBA and VSTO
- need a macro for arranging the data
- VBA Calender Formatting Date Problems
- Re: Help with a closing WB w/o activity!
- Merge blank cell with cell above
- Detect if file exists
- Macro to open another file
- Change names of Files in a folder
- How to start a Macro when I open Excel
- how can I make an exe or dll file out of an excel book?
- need help with array
- Saving all open workbooks
- Copy Files to other folder
- A question about data entry on forms and tables.
- Need Code
- Automatically generating a specified number of new rows (records)
- getting value of selected list item in a textarea
- eMoovie - a new company - we need sponsors
- Conditional Format Macro fails to set interior color - HELP!!!
- Need to program a find only in one column
- Copy new data to worksheet
- Shape Name and Location Report - an example
- Inserting lines into tables
- Using Address in Range Definition??
- Classes containing Classes
- Change Read-Only Recommended Prompt
- count rows with data
- Interacting with web page
- VBA for intersection of two named ranges
- VBA ADO Major error
- Edit Find
- VBA -vs- VB
- Pop Up Box for company name
- Loop thru lines of text in a cell and extract specific values: please help?
- I want to trap an error I get in a macro
- Remove Duplicate Pairs(2 Columns)
- Do Until Loop Question, for Printing
- CurDir
- Transferring data between listboxes
- Formula question
- SaveAs Dialogue Box
- IF Statement
- Can system variables be used inside Excel
- VLOOKUP USING INDEX, MATCH, AND IF PLEASE HELP
- Excel Comments
- Copy and paste 2 excel sheets in message body of email
- lookup finds the next higher number in a range
- how do i set column widths
- macro recording
- Excel 97 - Add-IN - On windows terminal server - Second user is locked
- how do I reference data from a Combo Box?
- Turn off undo
- Data Validation Formula
- Run Time Error
- Populate Drop-Down Listbox from Query?
- Local Directory File Access
- What does this mean?
- Message box based on date in Excel
- Using Cell Variables to Specify Cell Range
- Pivot table problem multiple columns and headers
- Combo Box
- Telling a website what to do!!
- defining a formula
- Emphasis of this NG
- Find and Paste
- Trendline points
- Working with cells and images
- Progress Bar
- Auto exe inserted audio file in word
- Fill ComboBox with all dates between two ranges.
- Deleting sheets
- Grouping Rows
- Convert to Hyperlink
- Silly Problem with Variable
- ADO assist
- Sheet activate method in beforesave event
- Sheet Activate method in beforesave event
- Sheet Activate method in beforesave event
- Remove Comment Indicators
- How do I format a sheet using a copy macro?
- I have a dream...about userforms and data management.
- Deleting contents of cells in non contiguous ranges
- insert elemnts from cells into array, create a userform with values checkboxes
- Excel Add-in for AS: Named Sets
- problems with .EntireRow function
- Can I program this needed format conversion AFTER pivot table
- Mutually exclusive values
- loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook
- Cell reference in Workbook_BeforeSave macro
- Stop Command Button being copied to new Workbook
- irrelevant msgs
- conversion to formula of string contaning IF clause
- Capture the range a user selects and put in textbox.
- Sharing variables between Excel and Word
- check if a file is open
- UDF second range-input incorrect
- Saving Worksheet Picture on desktop using VBA??
- count using multiple criteria
- move mouse pointer to a default button(Enter) in messagebox
- Dates exported as text
- filling combox box with same logic in 2 <> forms
- Application.FindFile or .GetOpenFileName?
- End of Record symbol
- How to access date from Oracle Databace to Excel
- Cant open a workbook!
- pasting data from an array
- Macro and probabilities
- conditional formatting
- Mutliple selection in MSFlexgrid
- Userform not displaying correctly
- If range F1:K1 are blank, then L1 is "other"
- Disguised Password
- Compare values
- Nested IF Formula Evaluation Pls
- Microsoft query won't allow parameters
- Look for cells with same value in different columns
- copy rows from one spreadsheet to another
- Copying an entire row
- Excel Macro
- Still looking for a solution for renaming worksheets
- Add another criteria
- Coloring a cell if it does not match on another worksheet
- Copy the format of a cell reference
- Error capture mechanism, then 'End' or 'Exit Sub'?
- sorting vertically.
- Using dates with autofilter
- Insert Row Problem
- VBa code to select from worksheet
- VBA automatically updating variable names
- Clear contents macro
- CAN ANYONE HELP WITH A SPECIFIC FORMULA I NEED?
- Referering sheet name of a named cell
- How do I change a numerical value to a string value ?
- Detecting cells that have InconsistentFormula error
- Restrict Data Entry, data validation
- Reference to a different Sub
- Repeating columns except a couple
- Hide or Unhide Column Based on Cell Value
- Increment down 1 row at a time, copy cell contents to another workbook
- Concatenate problems
- ComboBox with MatchEntry
- Need a conditional drop-down list (list contents)
- Import from Excel
- Conditional Formatting
- How do I stop people from saving a workbook as a particular file name?
- MsgBox Text
- Run macro when excel workbook gains focus
- How do I determine the Range that was pasted
- variable print area?
- Array to File
- Date Filename Save as Dialog Macro Thingy!!!!!!
- application.match question
- Comment and Tab character
- Select Multi in Listbox -> Event Click not working
- Code for all workbooks
- Scheduling - Automatic Selections..?
- Can CheckBox PopUP
- Problem running macro across worksheets within workbook
- Text Box
- Macro to update values on a Microsoft Equation 3.0
- Function exists prematurely
- Displaying a random image (or control) on a userform?
- Timeout Expired
- Object vs. New File in beforeSave event
- how to convert a figure in words?
- PasteSpecial Method of Range Class Failed Error
- delete from text box using command button
- Page Breaks
- referencing cell address
- worksheet_change question
- Dancing Gif
- multiple if
- getting filenames
- Auto Upper on certain cells.
- Getting Range whilst looping through files in directory
- Excel To web
- Why do I get prompt 'Not enough system resources to display comple
- sum sub levels.
- IsCellVisible(range) or VisibleCellRange(wks) needed.
- Delete specific row + others
- sum sub levels only.
- Moving data Based on critera.
- Can an addin save an array or UDT's to workbooks
- Can I add a new worksheet using a template
- Re: Aligment of DropDownList
- Aligment of DropDownList
- why do i have to click my 2nd command button twice
- Macro copying info/data in multiple excel files into one summary file.
- Creating an access log
- linking pivot tables by page fields
- SpecialCells & AddressLocal
- a mortage calulator where can I finf one?
- does the calendar control differ for the US?
- sheet name as variable
- Cell is locked but still editable...
- Searching for files below current directory
- "WinForm Application" to act as "RTD Server" using .Net
- Showing Userform Problem
- Repetitive IF statement
- set cursor position to that last character
- CREATE NEW WORKBOOKS BASED ON ACTIVECELL & BUTTON CLICK
- VBA Function not refresh
- Formula with the last spreadsheet of workbook
- Renaming worksheets
- Highlighting The Active Cell
- conditional calculating
- Format the sum cell
- Groups of controls
- moving data
- Loop every 26 rows and if..
- I need data to copy to the next available cell in a column from a macro
- difference Close and Nothing in query
- Number sorting
- When I change a cell a macro will autorun BUT..
- Sort and filter macro
- signal for incoming mails in outlook express
- Delete grouped shapes?
- Expanding the F9 functionality
- How to call a sub from UserForm Module
- Alternating Changing Color of Cells (a Range) across a Spreadsheet
- Why 'Unprotect' works for 2003 but not 2000?!
- Clearing the Values in a Drop - Down List
- Copy from one Spreadsheet to existing spreadsheet
- Change Event Range Help
- Declare a public variabl
- vba macro open password protected workbook
- creating a list of letters in a column
- Converting Numeric Columns to Excel Alpha Notation
- finding min with currency
- Restricting use of Calendar Control
- code to highlight max value in a range
- Search routine needs a little work
- Print embedded Word docs from Excel
- Inhibiting cross spreadsheet custom-menu functionality.
- Button to add 1 to selected cell
- protect a macro
- Setting Print options from a VB6 program
- Saving Data In a Macro
- Average data from different spreadsheets
- Array Formula creates error if too may cell chosen
- How to create a new folder using Excel VBA?
- Autofill down without range
- XLA not loading properly on start-up
- How can I get network userid in a cell in excel?
- IF Statement in Macro
- Overflow error - same code, different sheet
- Macro won't run in Excel 2000 when workbook opened via URL
- Textbox format question
- macro to print the first two pages of every tab in excel?
- OLEDB on x64 2.0 framework
- Combining data in multiple textboxes
- Macro Problem
- Protection and Formats
- Search Column - Find Multiple Entries - Sum Then Delete to Single Entry
- Adding VB code to worksheet programatically
- pasting copied cells
- Can't Raise Error twice
- Runtime error 1004
- Manipulation of Selection.Address
- Hide rows based on a condition
- Two conditions in one IF statement
- Saving a spreadsheet without saving the Macro
- Auto sort
- ForEach statement problem
- adding a sheet and renaming
- coding for changes....
- Open MS Outlook with Message
- Have the macro run automatically
- Another Problem
- Weibull paper in Excel - how?
- I lost my customized toolbars!
- select range next to activecell
- Populate Excel Chart Data from Access
- how to find a value in one column that is not in another column in
- write a macro that changes format of selected cells
- Saving email attachments
- Question about Concatenate and IIF
- Change Event
- Error Won't Debug
- programatically entering a CSE formula
- AutoFilter on one sheet filters same on other sheets?
- how to conver #n/a's to 0
- Referencing
- Personal.xls and Workbook_BeforeClose
- How can I streamline this repetitious piece of code?
- limit on cell contents
- Counting rows with criteria
- Coverting 1 letter codes into a sum value?
- Trouble opening embedded Excel in PPT
- Protecting Selected Sheets
- hiding cells via macro
- sort question
- Identifying & Selecting an Unknown Range?
- Clear cells
- Search For Multiple Entries - Combine and Sum
- Set Legend of a Chart from VBA?
- Copy paste from one worksheet to other.
- Pivot Table Page Area selections in a macro
- Printing behavoir changed PCL-PS printers
- Creating ThisWorkbook Event Procedures
- Can I assign a macro to an autoshape using VBA?
- Seek ODBC only VBA example
- Copying only new data to another worksheet
- Calling subroutines and passing variables
- External Data Via VBA was working - now not so much
- Calling subroutines and passing variables
- Selecting first empty row in column
- print macro for a list
- How to detect if cells text go on other column ?
- NETWORKDAYS Calculation Problem
- Copy Visible Sheets into one Workbook
- Macro - save_file
- chaniging a date in a url!!
- Copy File into Worksheet
- Using vba to generate xy scatter plots in excel
- Checkbox arrays
- UK Excel User Conference - July 19-21
- Module Names11
- Move cursor to textbox in a userform
- do while, "and function"
- GetObject with Password
- Running code by clicking on a hyperlink cell
- Colour and Pattern Formatting Cells
- How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook?
- Does anybody have code to do this?
- ListBox/ComboBox Acting as Macro/Hyperlink Tool
- Continue executing code while saving file
- Can We Do It In Excel ?
- CopyFromRecordset text to numeric
- preventing Application.EnableEvents = False
- prevent page printout
- Save as Macro working for one computer but not the other?
- Variable value from named cell
- How do I suppress user dialog in File Save As?
- Wait with calculation of other sheet references after edit a cell?
- How do I create a formula that will do YTD calculations?
- look up
- public function having array passing out to a sub dropdown
- reference adjacent cells in formulae
- run-time error, method 'paste' of object - worksheet failed.
- UK Excel User Conference - July 19-21
- Offset concern
- Finding Range of one Workheet used in another
- Extracting word from phrase within column
- Loop or condition? To check down the rows
- Relatively simple problem (I hope)
- how to solve this?
- Passing arguments to VB Function
- Write macro don't ask to save when exit excel
- Linking checkboxes between userforms
- Protect with "SaveCopyAs"
- Can't select field in ADO with Text Driver
- Insert Tab Space
- Calculating dates based on the current date
- Macro code to test for blank row and insert blank row if false
- How to replace a text with another
- Change the format of a cell Programmatically
- pivot tables criteria vba
- Compare String in Cell to an Array
- Question...
- CAN YOU CREATE A PATHWAY OF CELLS LIKE A PROGRAM
- Exporting values from many worksheets
- Need code to exporting Charts & table
- Should I use VB 2005 instead
- Calendar Control
- Setting several variables at the same time
- Automatically updating chart to include new column with VBA
- Code Help
- Excel 2003 XML mapping question
- Office Web Componet
- Application Icon
- Unable to insert a page break
- Command Buttons Location
- Checkboxes, AND, OR statements
- PasteSpecial and Offset
- How do I temporarily turn off messages in Excel
- I need to filter and delete rows of information between 2 dates
- pivot table based on multiple ptables?
- Return to current worksheet
- VB to color text
- How do I find a blank row and delete it?
- Look up
- listing objects
- Personal.XLS
- Help with Selecting Ranges in Pivot Table
- opening Excel 2003-Compile error in hidden module: Autoexcel new?
- opening Excel 2003-Compile error in hidden module: Autoexcel new?
- xl SS to query an Access database query
- Formula1 Property of Validation Object to refer to function name
- Delete row if no date exist
- Event when a user form is loaded
- Make the next cell active
- LTrim imported text
- AppActivate Error
- Copy and Paste between Spread Sheets
- Excel vba - passing a 3-dimensional array to a subroutine
- Userform; text restrictions
- Track entries and events spreadsheet,
- Quotation template whith automatic increments quote ref
- Error - file already exists.
- Way keep track of edits and editors
- Range.Select
- Replace words from ADO recordset
- Cell Format to Dialog Box in Chart
- Date problem
- Explorer Window.
- Import partial txt file using VBA
- Adding new sheet problem-Macro
- Copy test to form
- How to use MATCH with a vector in VBA?
- Formatting street address's for comparison
- how do I set the position to a specific cell location in excel
- Referential Copy and Past
- Hide and show a group of worksheets
- Updating SQL Server via Excel
- Using Arrays as source data for charts
- Re-Populate User Forms
- System Lock Event on excel
- A security issue???
- Matching duplicate entries between two columns
- Analysing a list of dates
- Place chart at specific cell location
- Problem with MATCH function
- open word from excel...file does not exist error
- Continue executing code
- Can an addin save variables or arrays to a workbook
- Help with filename search
- Making a macro universal to create multiple worksheets
- Copy cells to a txtbox
- Download a CSV file from an internet site
- Sorting excel sheets
- removing old stuff from xls
- Using CDO with Outlook
- If the Value in S is <> to E round off to its Value
- dlookup in excel vba....
- Advice on simple mod Req
- XL2003 open .CSV problem
- Excel automation
- Listing of contents within CHM file
- change yes/no buttons
- Problem with default file path
- refer to same cell in other worksheet
- workbook protection
- Userform shown in windows other than Excel
- Different Path Selection
- Best research method
- Counting variable ranges and auto-summing variable ranges
- Menu Title code is where?
- How do I do a VBA comparison to a financial value (i.e. $10000)
- Saving File
- Need UNIQUE values for Data Validation List
- Time Formula
- How to open Access recordset via Query in Excel VBA???
- loop and delete
- Urgent ! CSV double quotation problem ?
- Open all Text files in a folder
- Rename a worksheet
- Addin Name
- How do I install a hyperlink to 'My Pictures' to display a pix
- Loop printing
- solver macros in protected worksheets
- Populating combobox in custom toolbar
- Disable save box
- Moving Data from one tab to another when a check box is checked.
- Pivot table - show detail
- Range Loop
- count of items that results from two "IF" statements
- Listbox Cell Selection
- Copy cell query
- Debug suggestions?
- Macro Hangs
- Help my little brother
- Adding a delimiter when importing a txt file
- VBA Code to Return Text Embeded in the VLOOKUP Function
- Sort Selection
- VLOOKUP in a macro??
- Easy question: Have macro ignore #N/A
- Microsoft Common Dialog Control
- user form - data range
- Sorting by two column and bringing third along.
- Code to create a Histogram
- ActiveControl again
- Auto close read-only, question boxes?
- How do i insert a picture in merged cels, with autom. resizing ?
- Create muliple sheets using querytable
- Loop time seems dependent on unrelated workbook - Why?
- Excel 97 runtime Issue
- Conditional display - IF cell is blank, display next used row!
- Transferring Data from Excel to PP
- VBA: returning subtotal range of pivot tables?????
- Copy, Transpose and Paste Values for a Large Data Set
- Compare 2 columns to a 3rd with a twist.
- Pasting data from Excel to PP
- Copy worksheet colors to every open sheet
- How do I assign a toolbar button to a custom number format I creat
- How to test to see if a given sheet from is in a workbook from ano
- macro to select cells containing specific text and delete all cells but these