- Macro which inserts a column and cut and pastes data
- Macro which inserts a column and cut and pastes data
- password protect
- operator statements, shorting when reusing one of the statements?
- goto function
- offset?
- Where's the Documentation for the APIs?
- should I use Excel or Access fo this?
- New project, not sure where to start
- Database maintenance and Database Administration?
- create detail from summary data
- portable code...
- Create logical custom drop down list
- copy heading to row
- Arrays and cell values
- temporarily disable on-load virus scan
- Range manipulation
- Mod Function Returning Long
- Toolbars not appearing
- copy heading to each row
- Launching a macro by double-clicking on active cell
- replacing help
- Macro - worksheets to new workbook
- Moving files between folders using VBA in Excel
- Data Validation: items in one list relate to items in another
- Range issue...
- VBA programs
- I want to use a oleDragDrop in an Excel VBA Userform
- Re: Formula Help Needed - Tracking Responses.xls (1/1)
- how to move the pointer in a filtered selection
- excel chart export error runtime 1004
- macro only prints out first and last line of document
- formula
- Error inserting formulas into a range object
- Automatically overwriting files
- VB simple questions
- Closing a workbook and printing a non-active page
- Query Refresh message box on opening
- What function in a formula will pull the text used in a Tab name?
- Clear cells with #N/A
- Re: Intercepting Save and Exit menu command in Excel
- How do I set up an APR calculation in Excel?
- How to batch create / generate and print invoices from Excel data?
- calling all pro's!!! macro that can modify dates in odbc connection to mysql
- Disable 3rd party macros at startup?
- ParseCellData\Copy
- macro for import of csv .txt file?
- function need to return value and update one cell value
- in Excel, how do I set up an alert popup when the file is opened?
- Print to PDF Driver
- To Delete the specific rows when blank is found on column A
- Application.GetOpenFilename vs Application.Dialogs(xlDialogsOpen)
- RE: Nesting Problems
- chart help please
- vbok caption
- Macro Help!! 10 mins of your time need PLEASE!
- Re: Help Needed w/ IF statement using dates
- collect data from some files
- Re: Help Needed w/ IF statement using dates
- RE: Nesting Problems
- Conditional Formatting
- Re: Help Needed w/ IF statement using dates
- Get Stock Quotes Via Cell Look Up
- Macro Errors
- Range Manupilation
- Custome menu question
- Sorting with variable number of sort fields
- speed up printing job
- csv file with special separator
- Really Easy But having a mental Blank
- Find a specific text item and manipulate cells surrounding
- Registry Key for Macro Security Level?
- Running updates reports automatically
- Re: vba webbrowser HELP!
- SendKeys command to select an OptionButton
- Copy table information and paste sorted based on specific field.
- Online reference available for x-fering functions into VB?
- RemoveLeadingSpace
- Get macro to copy one row from excel to a text file. Possible?
- VBA to extract web data
- Selection as String
- compile error problem
- Using VB6.0, check if Excel / Specific Excel Programmes are open
- Printing Problems with Spreadsheet
- Send Email from Excel
- Conditional Format? - color if cell is modified by user
- Checkbox macro
- Need help importing a text file
- Function which adds all green cells
- Help please with coding a macro
- Qusetion about the function
- Workbook_BeforeClose change event not running correctly
- Error in Formula
- Incorrect Formual
- Error in Formula
- macros or input box
- Date in VBA Code Printout
- UsedRange Count for each column
- User Defined Function
- Passing Strucutres from VBA to DLL and back
- Reposting to get some answers......
- unzipping files
- Pivot Table - Trigger event on drill down
- Delete from named range based on Combo Box selection
- Sumproduct Problem
- VB backwards compatability
- moving to next worksheet
- Combing and Adding Data in Multiple Rows
- worksheetfunction.vlookup error
- Finding a string within a cell value
- RefEdit updating Current Cell location
- save sheet as "sheetname.txt"
- Problem when hitting an empty cell
- Copy Row and row above to new sheet
- Group values and sum using loop
- Iserror change cell color
- Macro to replace a VBA module?
- # of letters in a string
- Pop up warning message!
- combobox
- can we get the cell address from the name.
- run time error '424' when I run this code
- Get External Data Macro
- Checkcell macro problem XL97
- Visual Basic Macro(VBA) for a password protected file?
- Combing and Adding Data in Multiple Rows (Macro Needed)
- Combine Columns in Macro
- Macro Use Counter
- Countif
- Add to a cell if a row has a date and a column has a department
- Error when closing workbooks after running .net code
- Msg Box - User Entry Validation
- Invoke exclusive excel process on opening this file
- Running Excel macros through DOS
- ADO / Excel & Access: User ID and Password
- copy website to worksheet
- Problems with For Each
- How to run an ADD IN using VBA
- Vlookup
- How to sum PNs/Quantities overmultiple worksheets
- Array Formulas. Hardest Question Ever. PLEASE HELP
- Reading RGB background color from cell
- Defined Names
- Re: HELP : Excel 4 macros not working any more
- Validation List - Word and Numeric Association
- How to change the font size of Validation List?
- Userform TYpe
- Repost Excel Server Problem
- Help with Count Function
- Worksheet menu bar
- Vlookup and date format problem
- 2 small problems
- VB simple Questions
- Substring check within VBA
- One Excel Form for All worksheets Lists
- Sort a multi column listbox in userform
- Showing criteria in custom filter
- excel / word problem
- Scope of Subs?
- Compare,copy and paste if true
- VBA to change Button Macro assignment
- Can't paste the second time around
- Don't display row if cell value is greater than zero
- Making sure that cells within a row in a database aren't blank
- how do i activate tabstop on excel?
- Concatenate
- Dialogs SaveAs with different directory
- Purge file of VBA code and macros.
- Changing text size in option buttons on a userform
- Unable to sum range variable
- Patse Rows from one Sheet to another with a Twist
- sumproduct indirect
- Merged Cells Value
- graph function
- Automatic tab name change
- Test for first time a workbook is opened
- web query
- colorindex = xlnone on condition of month of year
- Combo Box or List Box colour
- Send Keys
- Personal workbook opens and messes up workbooks(i)
- Excel conditional formating
- Moving a Variant to Array
- Loop Training: Password Finder
- VBA - Set
- VBA - Selecting Based on Criteria
- if condition is true than send info to another work sheet
- Export/Import Question
- Identifying the selected Shape
- Gridline Question
- Select row (with offset) from VB formula result
- newbie question
- Newbie Q: What does "On error goto 0" mean?
- What is wrong with this?
- code loops 1024 times not what i ask
- Two Feilds in a combo box
- smart & tidy code for many checkBox_Change()
- Variable problem
- VBA output to text editor
- Multiple Lookups
- Waiting...
- Header and Heading Problems
- Vlookup but also consider equal to or greater than a valu
- How to test if a DLL (library) exists
- Stop Excel from updating external links when copying in VBA
- Programmatically add shapes to a selection
- Progress Indicator
- Excel Form annoyance
- Combobox ctrl on worksheet
- get subtotals results as a variable
- Help in writing an Excel equation
- How do you look for two distinct patterns (RegExp)
- Looping Checkboxes on Worksheet
- smart tag tutorial
- Auto Open
- Parsing a text file to a excel or word form
- Code to delete a Line in a another code
- run code on opening workbook and apply code to certain sheets
- Need help with complicated use of count background color of Cell
- Changing Series Name
- Show picture with transparencies in Image
- can I use WorksheetFunctions ON arrays from VBA??
- Negative Currency
- How to get the name of a range i deternimed
- Password Setting
- how to get the formula shown in linked cell's names
- edit certain hyperlink after a worksheet is protected
- Security Signing of VBA Code
- Excel Forms-Can i set the modal property?
- Read SourceData from Chart
- using excel with asp.net
- Chart option to suppress zero values??
- Creating a new Excel chart type
- logic problem: help needed
- Help with a copy function
- Finding the last row in a sheet in a closed workbook.
- how to display a found xml's and its bytes on its rows?
- Help needed to solve printing error
- toggle button text colour
- Range Object Misunderstanding
- find specific data in row and select and copy entirerow
- Checking for blank rows in database - with apologies to Norman Jon
- Selection Data from a Range
- Excel Objects error in ASP pages
- Pivot Table Events
- MERGE CELLS
- Auto filling using macros
- Counting cells with a specific range
- Displaying date/time!
- Protecting New File
- Programming code to new object
- New Object - programm code
- Type mismatch on If rng.Value < "0" Then
- FORMAT CELLS
- Find Text File Import Cell
- interfacing Excel to nonOffice application via DDE
- ExcelCharts with c#
- poulating multiple fields
- Undo Acting Weird
- Looking for an event
- Hide row loop
- User proofing an entry
- Hide/Unhide column based on cell value
- Insert SUM Formula using VBA (Range Varies)
- Registered Type Libraries
- How to give escape sequence in Excel string literals...
- Command help
- Download broken
- Please help. I beg!!
- select a range through last cell question
- find a value
- Auto_Close() not running
- Changing the comma for a semicolon when creating a CSV file
- extract parameter VALUE form a user-defined function..
- Time Formating
- Use Excel as DCOM object
- Looping issue
- Copy via code from a dynamic range using offeset
- Anchor chart source data?
- Capturing timed Data with RSLinx
- Macros inside of Macros
- Missing Command Buttons
- Excel is RightToLeft?
- How create a nonblank source for a verification list with a mix of filled & empty cells?
- Looping with Hidden and Protected Sheets/Ranges
- Macro fails when not performing "step into"
- ComboBox to show a range
- Macro inside of Macro
- .find =< function
- read data element from XML file
- Re: Get macro to copy one row from excel to a text file. Possible?
- Re: VBA - averaging the difference of 2 arrays, ignoring blanks
- Re: VBA - averaging the difference of 2 arrays, ignoring blanks
- come on, somebody must know how to do this
- RE: VBA - averaging the difference of 2 arrays, ignoring blanks
- Help with a Macro
- Form.Show problem
- automated print to pdf
- assining a varaible to the value in another sheet.
- get a list of sheet names onto a listbox on a form
- Concatenation in VB
- Remove ThisWorkbook code via VBA
- difficulty with permutations, please help!
- PivotTable CurrentPage
- SheetChange event restore old value
- SheetSelectionChange Event find out previosly selected cell
- Excel's ODBC driver's field limit
- Help: Nested If/And Function formula to VB code
- Full path in taskbar
- Macro help to move around spreadsheet
- Copy range from one wksheet to another
- html form to update excel file on server.
- Nesting Find and FindNext
- "one time" Link Cell
- Regional options support for currency
- Macro Help - Bolding info
- RefEdit control
- Delete Entire Row - Date
- Microsoft Calendar Control French
- RefEdit control
- Is there a way to do this on a worksheet?
- Macro keyboard shortcuts
- Weird result
- String concatenation
- Tab name = Referenced Cell
- Code does a continous loop
- Hide a series
- Lab Management Program
- Excel Browser Hidden
- vlookup question
- Use same On Error twice
- send group emails
- Why my selection is lost with MsgBox?
- Reading to a 1-D array...Error
- Excel control layout
- Text to Columns
- vba: Loop to load webpage
- VBE(Visual Basic Editor) Keep focus in VBE
- How to ascertain path of file in adjacent directory hierarchy
- Daily Interest Calculator
- Update data at other sheet
- Add Next and Previous methods to CustomViews collection
- Link problem with named range
- League Ladder refinement of Sorting.
- Help: VB Excel Problem
- Excel macro takes focus from other programs
- formula for inserting rows
- Copy conditional formatting
- Run macro automatically when a cell in a dynamic range changes
- update older workbook
- work with ADO or DAO
- Formatting text of Forms.OptionButton (radio button)
- Optimising portfolios with solver?
- how to using Function update cell value
- Error 57
- toggle box print if value is true
- How do I embed a commandbutton from VisualBasic into Excel
- Update VB refs on insert cells
- Splash screen
- Please Help With Chart Code
- macro_change font style
- dialog box for active cell task to speed repeditive task
- Re: macro_change font style
- Protection property of the VBA project
- Strikethrough Red and Underline Blue Macro
- Insert a new row with data from previous row
- Copy and paste from ie to excel using macro
- button with hyperlink properties
- optimization
- Calender problem
- Deleting a sheet
- Table Intersection
- Apply LEN result to string?
- Copy range from one wksheet to another
- excel cell placement by cursor
- complete notes on AccessXP in format bashirson@hotmail.com
- OT -Google group support
- Run a MS Access Procedure from Excel
- intersection with linear range as true argument
- Can't set cell value with VBA
- Problems returning Collection object
- Disabling the personal Workbook?
- Retrieving Exchange Rate Data from a Website
- Check for date
- How to set formula with cell reference with a variable
- there is any limitation for text field when using ADO +SQL
- Filecopy - Do you need to specify Destination Filename?
- Macro error 2
- Copying Range Names and values from one tab to another
- color row based on table
- Copy range from one wksheet to another
- Display message: Processing....
- Checking for changes.
- Create Summary Sheet
- Define Page Setup for whole workbook
- How to stop template worksheet visibility
- How to attach a code module to a group of workbooks?
- thanks very much
- there is any limitation for text field when using ADO +SQL
- Compact
- How to Advance a For Next Loop prior to the Next Statement
- Code to Delete Empty Rows in a Word Table
- copy from one workbook to another?
- Autofilter - Applying changes
- User Interface in VBA
- Query from ms sql server question
- Excel VBA Help Gripe
- opentext command
- A rude awakening to STATIC variable
- How do I restore the LookIn, LookAt, SearchOrder in FIND
- InStr
- Transpose Function not Working with Long Array Elements
- Detect Value change of a Cell
- lists without listbox
- Publishing to web..Macro issue
- Compare two sets of data
- xl2003/vba and Acrobat 6.0
- Populating Userform ComboBox with worksheet names in XL2003
- VBA to Adjust an Excel Chart Embedded into PPT while in SlideShow
- Copy range from one wksheet to another
- Number of elements in an array
- spellnumber twice
- Newbie : Oracle Data to Excel
- Creating named ranges.....Error
- Lookup & then paste cells
- Using a collection as a property
- Using If and Validation to turn a cell on one way or another
- how do i start excel and have it use a template automatically?
- Automatically Send E-Mail
- Phantom Of The Open workbook.
- code and formulas... Can any one help?
- Regression
- Re: Please see the file attached.
- Re: Please see attached file
- Migrating to Excel 2002
- Save workbook needs to be added Please
- "Compile Error Can't find project or library."
- call a VBA function for data validation?
- Question
- Load UserForm1 on sheet tab selection
- cell splitting
- displaying yy instead of yyyy
- Cell Types
- How to specify a tab character in excel vba...
- LeadingZeros\CSV
- a weird question
- question about ClearContents
- Newbie : Oracle to Excel Part 2. RDO or ADO?
- Dynamic Selection Find Function
- used range between two cells...
- Replace characters from cell values
- auto Refresh MS Query SQL Server
- VB code for Moving Rows up and down
- adding & Subtracting date & time in VBA
- Write Line problem when writing simplified chinese characters
- Lables that Change with Names for Games...
- Help on Coumting Unique records
- combing cells with same data
- Populating listbox based on two (or more) criteria
- How do I,implement a recurssive loop using Microsoft Excel ?
- Interpret HTML in excel worksheet
- Linking to an active cell
- Dynamic PageField Items
- Thank you for sharing - VLOOKUP array
- Sorting Data before close in shared workbook?
- Avoid Control Cell changing.
- Code to show current hour minute and seconds in a cell
- What is fastest for this? Small VBA or many worksheet formulas...?
- Embedding Excel in IE and Firefox
- Runtime error with sheets.add
- Looking up a country name and copying to column 2
- Select row by first cell's contents, then past in values.
- Question
- lookup for repeated PN
- macro password
- Newbie - Input Form Question
- Using "Find" in a macro
- Unusual Sharing Error???
- Unusual Sharing Error???
- Combobox with a dynamic list
- CSV File - Date Formats
- Is COM over? - what are my options?
- Macro creates additional datafiles when saving copies of workbook
- Undo Borders
- Update Format of cells in multiple worksheets
- On Error Resume Next
- On Error Resume Next ?
- Color of worksheet Tab
- Help With Forms
- Control Array Help...
- Sudoku Program Help
- line charts - error in series should not plot (empty)
- Snap Object to cell borders
- Using an Array instead of a Vlookup to improve speed
- user form export
- How to display current row number in fixed cell?
- Excel process doesn't close?
- References remembered
- References remembered
- Copy range from loop
- Question of updates
- Help !! - Create files using VBA code
- DropDown
- CLOSE ALL macro for XL2K (but with prompt to save for each file)?
- open as read only
- Goto Specific Textbox in Userform
- Getting chart templates
- Remove addin available from list
- Help writting a macro
- troubles not bringing in the first row of a ado query to another spreadsheet...
- Excel print area size
- Macro Error 3
- Re: Hide Certain Sheets based on Cell Data
- adding a formula in macro
- Array for clearing checkboxes
- using this forum...bookmarks? misc??
- Filter With VB Code
- Run a macro on exit
- Macro freezes up Excel
- !! Can you do this !!
- Send Mail - Code to test whether Lotus Notes / Outlook is used
- DropDown rephrased
- Using a drop down list -- Autojump to first letter
- Finding values in hidden cells?
- FileName
- Macro help?
- Advanced Filter - Unique Values
- Is there any way we can clear everything..
- Macro help
- Cannot paste Toolfaces
- testing whether the ActiveCell is in a given range
- Excel Conditional Combo Box
- Is there any way we cna clear everything..
- IF statement with formula
- opening an excel page without the toolbars
- run-time error '1004': Application-defined or object-deifined error
- Proportional Chart
- Copying worksheet error
- Application.Transpose and Range of dates/data
- Not to display Macro list
- Filtering a Date Range
- checking data
- Using arrays to create Combobox items
- reporting based on spreadsheet data
- no duplication please
- Find Match and count order
- macro help for subtotal at top of column
- Deleting menu (xla)
- check if worksheet exists
- Forms > Combo Box > Invalid Propery Error
- Changing Macro Security settings does not work
- Insert a number of rows based on a value in a cell on active row
- check active cell column
- Cell strings as cells
- Tab name matches cell
- Drop down - required field
- Alternative to Copy and paste values in VBA
- Error Handle
- Writing a macro to copy first cell down until next cell has data
- command disabling
- Web Page Printing
- what is "\" standard for
- Row Conditional Formatting
- Insert Quatation Mark "
- generating a whole random # from a list
- Compare 2 lists and merge
- Pivot Table Refresh
- macro that calculates average
- [Help Needed] Custom Lookup Function
- Code occurrences between rows
- How to use row and column number instead of "E1" designation?
- Error 13 with combobox
- Excel Bug Moves Cmd Buttons When Print
- If-then font bold language
- How can enable and disable menuitems based on the type of sheet.
- numbers contain hyphens to dates
- Reinstalled excel, macros broken
- Excel XML - Formating Dates
- Macro to force Excel to close after a given timeframe of inactivit
- Retrieve the key (strings) in a Collection
- Copy Data into new worksheet
- VBA - VLookup ?
- Concatinating cells
- How export all Names to another workbook?
- Can you use VBA forms in different applications (VB app and Excel)???
- how to sum a complete colum on another sheet in VBA
- For each next
- Macro to copy text upon entry into cell
- Weekday() result differs from one computer to another ???
- no way to import user form into vb6?
- Paste Array into worksheet
- Suspend Execution
- Launch Web Query from Macro
- cell color adjustment using vba
- Excel97: Show UserForm while running code?
- Converting Excel Worksheet to PDF using VBA
- Combo Boxes built with Control Toolbox on a Worksheet
- request code for right align and percentage
- need macro for renaming bunch of excel files
- BeforeSave Event Question
- BeforeSave Problem
- second line
- pls reply Patrick Molly
- Help with returning a Range
- cells that start with "Slot"
- Re: Help with returning a Range
- how to insert a + sign permanently??
- exit excel within vba
- open copy paste
- Macro to import data
- Copying ranges
- Delete duplicate headings
- Can I get a hyperlink to run a macro?
- Filter Total
- copy passbook data into new worksheet
- ToggleFormsDesign
- Saving Data for future use
- How to find specific subfolders
- matrixed table out of pivot
- pass workbook name to sub
- Check spelling in a single cell AND spellchecking values only
- Selecting and copying a dynamic range of cells
- Currency Amounts
- problem assigning range returned by function, to combobox rowsource
- Only a genius can help with this 7 Nested If that doesn't fill down
- Array error
- Network Drives
- Macro: MonthName Function, runtime error 424
- Data Validation
- Printing at certain times of a day
- worksheet saveas workbook
- Cell color
- Microsoft CDO 1.21 library
- WAV FILE
- A MACRO ON SUBTOTAL
- custom help files
- XMLData\Mapping
- paste method of worksheet class failed
- very hard deleting rows issue
- GetObject Function On Text Files
- Update Code to work between 2 files
- Adding a new function to values in the status bar
- Scrollbar
- How to add new sheet with certain name?
- Saving Excel file w/o any data
- Emailing Workbooks
- How protect with password the access of a spreadsheet ?
- How do I sum variable rows in a macro?
- Pass value from form to form
- IF Statement not Displaying FILLDOWN results Automatically
- Exporting xml problems
- use Excel2000 as web interface to collect user input?
- Inserting a row in all sheets at the same time
- Rows & Cols - copy formulas in Col A to # rows in Col B
- Problems using Application.IgnoreRemoteReferences
- setting print areas, and not printing 'hidden' cells
- Changing order of embedded charts
- What should my calculation settings be?
- restrict scrolling
- #N/A - 2 options
- scroll with wheel mouse
- Copy Sheet Values to new WB
- Removing Empty Rows and selecting Specific Rows
- Selection order problem with code for shapes connection
- Control disabled
- Please HELP
- I don'T know how to code in VBA
- saving sheet as new workbook
- Refresh spreadsheet from database through ODBC
- Control Break in Excel
- Trouble with copy of xlSheetVeryHidden
- Does Range("A1,B2,C3,etc") have a max number of cells?
- Accessing the Desktop
- Help with defining a Range
- mouse pointer as a hand
- Do anyone know how to implement the function?
- run time error 1004 on protected worksheet when I try to run macro
- Exclude blank cells from a range?
- Macro to create chart
- add pages in a multipages programming error 217417418
- Code to get a Range RECTangle or PT
- an excel template to split costs on a group outing
- Select cells based on named Range and a column heading
- VBA - Counting Characters in Cell
- +++Help me with a loop... I have no idea what code I need!
- Macro to add a variable list
- Formula Help Needed
- keeping a toolbar attached to a workbook
- is this vba code correct or is there a more simple way to do this ?
- Run a .xla as a independent application
- Find function in VBA
- detect and remove apostrophe
- sideways sort
- numbers contain hyphens(norman jones)
- Last Saved Date and Time
- Closing a spreadsheet?! Please HELP!
- Indication outside an defined area
- Two menus appears in commandbar(Cells)
- Ignore values in a particular row for Grand Total
- Trouble sorting data by cell value
- Using EXCEL with .NET
- Macros in excel 2000
- To clear apostrophes
- my saveas macro date problem
- Make a Trial Date Macro ?
- Charts not updating in 2002,2003 but working in 2000
- value between min and max
- Disable Shortcut Menus / Alt-F8
- Use a keyboard button to run a macro
- Values assigned to variables staying in memory when procedure stop
- Find out WHO has a file opened for editing
- how to create sub menu items in Excel?
- Customized VBA Editor Format Save Location
- How can I paste formulas only an not values
- What have I done wrong with this Macro???
- HOW TO ASSIGN 2 DIMENSION ARRAY VALUES FROM 2 COLUMNS?
- Faster Way of looping through cells
- delete rows if value in column D is repeated
- Selection.End(xlToLeft).Select
- Pivot Tables and Cells.Find
- Auto Fill
- Have empty cell unless result of formula isn't value of "0"?
- application run problem?
- How to use variables to define range
- Create a subtotal if either of 2 chg
- Protecting Specific Cells In Excel
- Help on combining declared variable and cell formula
- Help on combining declared variable and cell formula
- Create a Window without a Form ... !!!
- Excel VBA If statement question
- Referencing previous worksheets in formula
- Hyperlink target should equal parent
- Add-In - OnAction Can't Find Macro & Subs Doesn't Affect Current Wkb
- What different between "sheets" and "worksheets"
- Should Be Easy
- How do you capture events?
- UserForm for each Worksheet
- how do I rearrange a column into a series of columns?
- Getting rid of extra space after cell contents?
- Error:Can't find project or library
- Excel: how do I set page3 to be locked until page 1, 2 are solved
- sum if dates conditional
- ActiveCell.Address question
- String array issues. Need help...
- Buttons won't work
- Arrange a list in ComboBox
- NoFill range of cells
- Looping a loop?
- mouse pointer question
- Change cell fill color from function