Microsoft Excel VBA

Below are archived posts from the MrExcel Message Board about Microsoft Excel VBA. You will find lots of tips and tutorials for using visual basic in Excel. Check out the MrExcel tutorials for more information on how to properly use Excel VBA.

• ' character
• 2 questions -Macro Command & Paste Problem
• Books on UserForms
• Does not recognize Unload Userform1
• macro needs to access a file which currently does not exist .
• Start Programs with macro
• tabstops in userforms
• # of records
• #DIV/0!
• "activewindow.close" How do I tell it not to save?
• "Add Series" Loop for Graphs
• "ADD VALUE FROM DAY TO MONTH"
• "ADDING DAILY VALUE TO MONTHLY VALUE"
• "auto-executing" Excel macro's
• "Calculation incomplete. Recalculate before saving?"
• "Carriage Return" Macro
• "enable macros"
• "File Save As" Macro
• "Find" in VB
• "FOR" loop to march through cells
• "grayed out" options on userform...
• "Left" "Trim" function errors in VBA
• "MultiplyTimes1000" macro
• "new" and "open" buttons on the standard menu
• "Not Enough Memory" message when running a specific macro.
• "Please Wait" message box with progress indicator
• "Save As" dialog box in macro
• "Save As" Macro
• "Save As" macro using a cell's value
• "Select method of Range class failed" error
• "Use Relative References" in Excel 2000
• "Workbook 1" Macro delete "Workbook 2"?
• ...not as simple as I thought - or is it?
• .csv to .xls with intelligence to scan name
• .Find method w/ Dates
• .fittopages wide & .fittopagestall commands
• .gif in a cell?
• .prn file in Excel
• /SelectCopy/Paste multiple cells depending on the data in other range
• ? to change long list of Hyperlinks to URL's?
• ?? on an Archive2 post re: Save file name = contents of a cell
• ?type mismatch in if statement
• [making a macro] Almost there but....
• [Q.] How in a Macro to select range to paste in.
• [Still need] VBA help with Range and Cells methods
• =if(A1>100,"RUN MACRO") What is the command for "RUN MACRO"
• >--<
• 1. Hide but still print 2. Hide,lock and e-mail.
• 1st window determines 2nd
• 2 marcos into one
• 2 More ListBox Questions
• 2 problems
• 2 questions inside..
• 2nd try - Tweak code
• 3 sheets. Solution= VBA/Macros/something - I have a headache
• 3-fold macro problem
• 97 / 2000 VBA code compatibility question
• A bug in my macro
• A couple of toughies...
• A follow up intended for Dave Hawley. Just a detail...
• a hard one: asking the name to computer. Protecting macros
• A macro putting data in a closed workbook?
• A Macro Case for a Good helper
• A macro that would...
• A macro to coninue a macro?
• A Macro to create and save a new workbook with the first few sheets of the current workbook?
• a macro to download a spreadsheet into Access
• A MACRO TO RUN AFTER X SECONDS
• A simple macro request
• A simple VBA question (I think)
• a toggle button on a userform
• A true basic question....
• A VBA equivilent of "shift, ctl + down"?
• A workbook w/formulas need a CODE to find & Protect them
• AARRGGHH!! HELP ME. Creating and deleting folders
• Absolute / relative button while macro recording
• Absolute vs. Relative reference
• Access a user ID Windows NT
• Accessing a Database from VBA
• Accessing a proteced workbook/sheet from VBA
• Accessing Excel From VB
• Accessing file using macro
• Accessing the Last Saved Date
• Accidentally deleted my Tools Menu
• accumulate values in a single cell
• action on Double Click
• Activate a Macro With Only One Clic
• Activate sheet being copied
• Activate the other file depending on the input value from the input button
• activate/deactivate open workbooks?
• Activating macro from cell text
• Activating the built in Data Form
• Active Cell Command
• Active Cell Selector
• Active Cell within a set range
• Active Range
• Active Sheet Tab
• Active Workbook Directory/Path
• ActiveCell
• ActiveRow
• activesheet.calculate
• ActiveSheet.PrintOut
• Activesheet.ShowAllData
• ActiveWorkbooks.SaveAs FileName
• Activive sheet -2.select?
• Add a row at each change in time
• add cell into a range based on criteria
• Add command to toolbar
• Add list of Font Names to ComboBox
• add or subtract popup box
• add sheets and nammed
• Add TextBox - determine position
• Add-in function dialog boxes
• addin question
• Adding a
• Adding a clock to an Excel User Form
• Adding a macro to Excel from VB
• Adding a number to itself
• adding a row after a certain word
• Adding bold values
• Adding cells of a certain colour
• Adding cells that are a certain colour
• Adding colored cells
• Adding Help file .hlp to Excel Macro
• Adding hrs in a timesheet only if hrs worked span a time range
• adding lines to a line database
• Adding Macro Button to Toolbar
• Adding menus items to menus
• Adding Menus through the VBA editor?
• Adding non-adjacent rows
• adding range items to a listbox upon initialization
• Adding ranges within VBA
• adding row after comparison
• Adding rows
• adding rows
• Adding Sheet Question, again :)
• Adding Sheets with VBA??
• Adding Tabs to a VBA Form
• Adding to a cell's previous value (Cell1+Cell2=Cell2New)
• Adding to a macro
• adding to a macro with a macro
• Adding to existing data
• Adding values with code
• ADD-INS
• ADD-INS (a macro haven)
• Add-ins / Autosave
• additem
• additional addition oops
• Addup column with macro
• Adjust VBA code to paste in a specific area, depending on the sheet that called it
• Adjusting Chart Source Data in VBA
• Advanced Filter using text in Comment box?
• Advanced Question: How to "Gray out" Print Preview Button
• After copy & paste show message box
• After macro
• Aging Macro
• AH HA!! I Think I Have The Ultimate Challenge?
• Aladin Akyurek
• Aladin Akyurek Please come in
• Aladin..plz check your mail..coz i've sent you the file about the conditional formating problem :-) thanks (NM)
• Alert Message
• Alexia, this is the code for a listbox with foldernames
• Align all worksheets to same cell & window position
• Align charts on worksheet using VBA
• All Sheets in book protect macro
• All the combinations possible
• Alladin, Ivan, anyone! Ive done something stupid..PLEASE help...
• Allocating a hot key to a macro in VBA
• Allow Print, but not Copy or Save?!?!?
• alphabetical numbering
• Alt + S recording problem
• Alt+F11? Print-area macro
• Altering The Code to Highlight an Entire Row
• Always save as date
• Ambigous name detected Private Sub Worksheet_Change
• An Application/Macro problem for you.
• An automated daily balance sheet
• An easy one I know but it's driving me nuts ! Please help me.
• An original entry in VBA code
• Analyze directory contents from Excel macro
• Anchoring chart to certain place
• And the struggle continues : ref: Ben 12:05:50 09/21/01
• ANIA: Getting rid of macros
• Animation Query
• Annoying Pop-up Dialogue Boxes
• Another Citrix question
• Another Find and Replace macro help please!
• Another odd question
• Another question
• Another simple VBA question
• Another timed macro question
• Answering a dialog box within a macro
• Any ideas why this Function won't work?
• any way i can re-write this?
• Any way to speed up this macro for large sheets?
• ANY1 INTERESTED WITH PASSWORDS FOR : Template XLT IN EXCEL 2000. MAIL ME. MY EMAIL INSIDE ..ALSO I CAN HACK VBA PW AND ALSO..SHEET PASSWORD..WHAT I CANNNOT DO IS THE OPEN PASSWORD THAT CAME WITH SAVE AS-OPTION-GENERAL..
• Anybody who like a workbook that contains macro but dont know their password, u can mail me
• API - "SendMessage" - in Excel
• Append entered data to a range
• Append results
• Application & Workbook Command Buttons
• Application Window State Event
• Application.Calculation
• Application.Filesearch more opts for .LastModified
• Application.GetOpenFilename
• Application.InputBox
• application.quit...
• application.screenupdating = false' - stopped working
• Apply a condition after the due date
• Applying a function to part of an array w/o loosing data
• Appreciate previous input, but still stuck on Launching Word from Excel
• Archive of cells
• Are you a VBA expert... Macro Protection Box
• Argh! Varied SUM ranges! Please help!
• array formula question
• Array Functions in VBA
• Array of sheets
• Array variables in VBA
• Ask for Data, Hide non-matches, Report, unhide with Macro
• Assign a macro to toolbar
• Assign a unique number to a Excel Template
• Assign a value to a number of Variables
• Assign active cell to a variable
• Assign contents of active cell to a variable
• assigning a macro
• Assigning a macro to a button (or key) using VBA
• Assigning a value to a row
• Assigning Array to Non-Contiguous Range
• Assigning Macros to Drop Down Boxes.
• Assigning Numeric Values to Letter Grades (& vice versa)
• assigning sheet names to a combo box
• Attach a Macro to a Radio Button?
• Attach a macro using another macro.
• Attaching Macros to Form ComboBox Control
• Attaching Macros to Message Boxes
• Attn Juan Pablo, ty very much for the macro... I think I'm using it incorrectly?
• Attn. Richie Turner - Re:Workbook_Open Active Sheet Unprotect not working.
• Attn: Faster
• Attn: Help with code please! Code GURUS!
• Auotomatically Enable Macros by a macro
• Auto answer a Message box
• Auto Answer message boxes
• auto carriage return
• auto close - give user the option to keep file open
• Auto column width
• Auto date insertion to a cell
• Auto delete duplicated sheets?
• Auto Deleting file (contents) after 6 months.
• Auto Emailing
• Auto enable and auto end macros.
• Auto Enter into a cell
• auto exec macros
• Auto Execute On Focus
• Auto Fill
• AUTO FILL MACRO
• Auto Filter - VBA Code doesn't work with Dates!
• auto fire a macro
• Auto Macro
• Auto Macro
• Auto Macro?
• Auto Macros
• auto naming sheet
• Auto number for an invoice
• Auto open and auto close Macros
• Auto Open Macro and Disable Warning Message
• Auto Open Macro to test for a user ID
• auto print range
• Auto Refresh
• Auto Refresh.....Come On Guru's...Can i do this
• Auto Replace File
• Auto running a macro HELP!
• auto sorting data
• Auto start of macro on file open
• Auto starting an Excel macro - Help!
• Auto_open vs Workbook_open
• Auto_Open() and OnEntry Problem - please help!
• Autocapture User info
• autoclose
• Autofill
• autofill
• Autofill & max calculation problem
• AUTOFILL / COPY & PASTE HELP
• Autofill a Column to last row of data
• Auto-insert rows
• AutoMacro to change cell formats on printing
• Automate a macro - help please!
• Automate a Vlookup with a macro
• Automate export...?
• Automate Find & Replace
• Automate macro to run when opening sheet
• Automate Opening PW Protected Workbook
• automate pivot table with macro
• Automatic alternate row colour
• automatic autofill
• Automatic Capitalization
• Automatic exit without saving a workbook
• automatic file naming
• Automatic Hyperlink?
• Automatic links message
• Automatic macro
• automatic macro
• Automatic macro like tip006 but for a single Cell Reference
• Automatic macros
• Automatic Macros
• Automatic Macros
• Automatic Macros
• Automatic MAcros???
• Automatic Page Setup
• automatic prompt for save as on open
• Automatic range finder??
• Automatic Row creation
• automatic window sizing to screen resolution
• Automatically adding macro code to existing spreadsheets
• Automatically Click OK during macro?
• Automatically copy formulas and formats when inserting rows.
• Automatically Delete Rows that contain a certain word?
• Automatically dividing entered number by 12
• Automatically embedded date of creation in file
• Automatically execute a macro when Excel file is opened
• Automatically executing a macro when opening Excel
• automatically insert filename into cell
• Automatically Loading...
• Automatically removing an file by using a macro
• automatically removing auto_open macro from template
• Automatically Saving a worksheet in it respective folder according to the selection in a combo box
• automatically saving with a password
• automatically sorting without a macro
• automatically starting a dialog
• Automatically turn off autocalc when opening specific woorkbook?
• automaticly deleting or omitting rows based on values
• Automating cell naming
• Automating Data Refesh In Excel 97
• Automating Excel to run a certain macro at startup
• Automating going from tab to tab, in the same cell
• Automating Macros
• Automating Macros
• automating multiple runs of solver across worksheets
• Automating Table Population
• Automating tasks based on date
• Automating the creation of a scenario
• auto-run a macro when an entry is made on the worksheet
• AutoRun macro
• Autorun Macro from a range of cells
• Autorun Macro Machine dependant
• Autosave macro
• autoselect userform
• autosort?
• Autostart Macro
• Autostart macro
• Autosumming
• autowrap - excel 2000
• average in macros
• Averages
• Averaging Cells Across Spreadsheets, Skipping Zero Values
• Avoiding Prompts in Macros
• Backdoor routine
• Backdoor routine - the sequel
• Background color change on button in Userform
• Barrie Bariloche
• Barrie can you figure this one out?
• Barrie! VB me
• Barrie! VB me Again, just starting it off up here.
• Barrie, still have problems that I am not able to resolve, would appreciate your help.
• Barrie, more help with that code you wrote?
• Barrie....you stated "if you must use VBA".....can you think of another way?
• Barrie...I'm running with the VBA suggestion, but have small problem
• Basic question.... please answer
• Basic VBA
• Basing Macro Code on Cell Values
• Batch find/replace?
• been fighting with this one...time to ask an expert!!
• BeforeClose Event does not run
• BeforeDelete key event???
• Begginer's question
• Beginner needs help stopping a macro
• Beginner VBA help - Please help quickly
• Beginner's problems with Workbook_Open
• Ben - or anyone! Comboboxes and rowsourcing
• Ben: More Conditional Row Selection
• Best way to get automatic stock quotes?
• bet noboby knows!...lol
• Better way?
• Bizarre slowing down of macro
• Blank result of IF statement
• Blank Rows to be found - Urgent
• Blank/Null Cells
• Block users macro needed
• Box will popup and you can run macro from it?
• Boy oh Boy...Is this baby Slow!
• Breaking a reference, keeping the value
• Brilliant people & nobody can paste special for value in VB?
• browse button
• Build an Excel file from one-line text file.
• Building a better mouse trap
• BuiltInDocumentProperties Query
• Button names in VB
• Button to launch macro
• Button to print "Sheet2" with formatting
• Button to sort column of numbers
• Buttons
• buttons for macros
• Buttons for Macro Sorting
• buy Excel
• By Pass Message Box
• Cake - ComboBox VBA create and fill
• Calculate Event
• Calculations in large spreadsheets
• Calendar results
• Call 1 Macro from Another
• Call a macro from a Cell
• Call a macro from another sheet
• Call a Method of a Add-In
• Call another macro under Workbook Auto_open?
• Call another program from excel
• Call Excel and open new worksheet in existing instance?
• Call Private Macros
• calling a macro to run on several sheets at once
• calling a macro without referencing the module
• Calling all Excel Pros! Help!
• Calling all Macro and VBA experts- the answer is simple but what?
• calling all VBA heads
• calling macro from hyperlink
• Calling macro in an IF function ??
• Calling MACROS from Excel ADD-IN
• Calling Procedures on a Sheet
• Calling SaveAs dialogue box from UserForm or Macro
• Can a Macro be run from a value returned to a cell?
• Can A Macro delete the macro button used to run it?
• Can a macro with input boxes do this?
• Can a VBE project be networked???
• Can anybody recommend a VBA for Excel manual for beginners?
• Can anyone help me with this????
• Can anyone help me?
• Can anyone help with E-mail macro
• Can cell tab order be set in a protected worksheet?
• Can excel dial phone numbers?
• Can Excel find the last row on a PAGE?
• Can excel or VB tell you when and where a change occurs in a defined range? (By the way, Thanks D.H. For helping me on the cell refrence thing it worked great!)
• Can filenames for a Save As command come from a cell?
• can i access the call stack from VBA?
• Can I add a button from XLStart\Personal.xls?
• Can I automatically run a macro when I open a workbook?
• Can I change screen size from 800x600 to 1024x768 in VB ?
• Can i customize my toolbars so that only my workshhet will have the new menu bar and all the other .xls will have the original menu settings...?
• Can I disable macros in archived workbooks
• Can I display a "Working" dialog box while a macro is running?
• Can i hve two target as range?
• Can I make a macro in excel for a date stamp
• Can I save without saving the macro?
• Can I turn off the Help shortcut key in Excel?
• Can I use "Case" instead of this repeating macro?
• Can it be Done or have I found an Excel Shortcoming?!
• Can Macros split up and save documents ?
• Can not save File
• Can only run macro by opening file a certain way
• Can somebody help me with...
• Can someone help me speed up this code???
• Can someone PLEASE help me fix this macro?
• Can someone please help me on this?
• Can someone translate this to VB for me?
• Can the color of a cell have a value?
• Can the print area of one worksheet be copied into another worksheet? (using VBA)
• Can this be done?
• Can VB display the "Save As" box?
• Can VB identify & select dynamic ranges??
• Can VBA draw user-defined lines on an Excel chart created? Pls help.
• Can VBA make a bar which simulates the files opening?
• can we prevent user using the "save as" function in excel 97..but they still can use the "save" function..thanks
• can you delete cells within a Macro?
• Can you get a macro to pause until a page has printed
• Can you please tell me how to get the ActiveWorkbook name/path from inside an XLL?
• can you put an "if then" in a" for each" loop in a macro?
• Can you start a macro from a function?
• Can you undo a macro?
• Cancel
• Cancel out of a quit process (I will clarify)
• Cannot change my VBA in my Excel file?!?!?!
• Cannot save macro in Personal Macro Workbook in the XLStart folder
• Can't figure it out
• Can't find project or libruary
• Can't get macro to work
• Can't remove Macro from file
• Can't retrieve value from cell
• Can't use classes from other workbooks
• Capitalizing a Variable from an Input Box
• capitilze all cells on a workshhet?
• CAPS?
• cascading combo boxes
• Case Changing
• Case sensitive string
• Celia - HELP! Re: Flash SubProgram
• Celia -- Last filled row
• Celia please...
• Celia, Thanks for the help ...
• Cell addition
• Cell change to Accumulator total
• Cell Comparison
• cell data used in macro
• Cell editing macro
• Cell Editing Macro
• Cell Entry Color
• Cell Justification Using a Macro (VBA)
• Cell links through FTP secure server
• cell moving (New to this)
• Cell redirect to sheet!
• cell reference
• cell reference headers
• Cell Reference in a Footer
• Cell Reference Macro
• cell references in headers
• Cell References in lookups that refer to other sheets
• Cell Search
• Cell Security
• Cell that counts when opening a workbook
• cell to change color
• Cell with automatic numeration
• Cells
• cell's
• Cells containing macros are not updated
• Cells or column
• Cells with required entry
• centering text on the page vs. centering text in a column
• Centering the Active Cell in the Center of the Screen
• Centralized code for multiple workbooks
• Challenge Question of the week 10 Points !
• CHALLENGE: Importing a txt file with a macro!!!!
• Challenging! How to record changing values in a cell
• Change a specific text value every spot it appears in a workbook.
• Change caption of button in VB from range in sheet
• Change Configuration On Exit
• Change dates to text
• Change Formula to macro
• Change from Absolute to Relative references
• Change macro on save
• Change picture of commandbar item
• Change Range Size
• change row colour dependent on cell
• change tab to cell name
• Change the "Record Macro" Description.
• Change the scrollbar
• Change the type of document to save in File Save As
• Change value of Named Range in VB
• Change VBA Project Properties via VBA Code?
• Changing a 4x1024 spreadsheet into a single column of 4096
• Changing a row to a different color
• Changing a spreadsheet, row, or column into all caps.
• changing active cells
• changing back to excel after starting (shell) program from Macro/VB
• Changing between pages in Excel
• changing border style
• changing cell color but not border
• Changing cell color by single click
• Changing cell color with SelectionChange
• Changing cell colour on entry & exit
• Changing Cell Range in a Macro
• Changing cell references from Relative to Absolute
• Changing default directory to a network directory.
• Changing Excel's default Automatic Color from Black
• Changing font color depending on cell contents
• Changing footer w/ macro
• changing format of number
• Changing individual cells based on entries in adjacent cells
• Changing locked cells on a protected worksheet
• Changing Lower Case to Upper Case
• Changing macro's to reflect hidden sheets
• Changing numerical entries to text.
• Changing Printers in Excel with VBA
• Changing series reference in a macro
• Changing the file name by 1 everytime i open the file
• Changing the order of the columns
• changing upper case to lower and vice versa
• Changing Window Size From Within Macro
• chaning a checkbox value with a macro
• Chaning the name in comments box.
• Check box control
• Check Boxes in Multiple Rows
• Check for a Excel file name, if not exist save as todays date???
• Check for Open Workbooks
• Check if Blue
• check if file exists?
• Check to see if a certain cell is empty or blank
• Check to See if Worksheet Exist
• Checkbox Code - Help!
• Checkbox shows backcolor when clicked??
• Checkbox value = false to activate macro or code????
• Checking a range
• Checking a range of cells for a value
• checking dim on return arrays
• Checking directory to save a file
• Checking For Open Files Including Path
• Checking for valid worksheet in macro
• Checking if a directory exists
• Checking if other workbooks are open
• Checking to see if a workbook is open
• Checking which menu item has been selected from a custom commandbar
• Choise if Control Tip Text are shown in VBA form?
• Choose a directory & file
• Choosing a Printer
• choosing worksheets in VB code?
• Circular Reference
• Circular Reference or not? And how?
• clear a cell with command button?
• Clear cells macro
• Clear Clipboard with VBA
• Clear range on another sheet
• clear text box values
• Clear the Content
• Clearing all data in a worksheet using VB
• Clearing Cells
• Clearing Clipboard
• Clearing contents
• Clearing Form Fields after data has been submitted...
• Clearing from a certain row all the way to the bottom using VB
• Clearing the clipboard?
• close a form without exiting the workbook(quit running MACRO)
• Close ALL excel windows
• close entire excel application
• Close File and Skip save changes window
• Close file without saving changes
• Close workbook after a period of inactivity-
• CLOSE WORKBOOK AND EXCEL TOO!
• Close workbook without saving data
• Closing a workbokk discarding changes
• Closing Excel
• closing Excel
• closing excel
• Closing Excel
• Closing Excel After Marco Executes
• Closing Excel from a Macro
• Closing Excel from VBA
• Closing files
• closing files
• Closing Other Subs Within A Userform
• Closing other subs within a userform
• C'mon you Excel gurus, help me please!
• Code for "14 points in a row Alternating"
• Code for Aladin - Dropdown list dependent on another ...Here is the code.
• Code for updating values from Input boxes
• Code getting ahead of itself
• Code in macro to return to previously active sheet
• Code in one macro to open 3 files if not already open
• Code modification
• Code not working
• code that cleans up after itself...
• Code to Add Toolbar Button
• Code to delete row's contents based on one blank cell
• Code to name a range ....
• Code to prompt "password" to view sheets
• Code to set paper size for any Excel document opened?
• codenames; reply to Damon Ostrander
• Coding a path in the footer.
• Collapsing Data (URGENT)
• Collapsing the data
• Collection of worksheets
• Color Index
• Color Index for Excel VB
• Color Index macro bug
• Coloring Specific Letters in a Spreadsheet
• colors
• colour change after time..
• Colouring cells
• Column alignment
• Column and Row Viewing Help
• column averages
• Column Filter
• Column letter instead of number
• COLUMN WIDTH
• Column Widths
• column() function in vba
• ColumnWidths in code
• combine two files
• COMBINING CELLS
• Combining If Not Is Nothing
• combo box
• Combo Box
• Combo Box
• combo box linked cell value
• Combo Box Matching text
• Combo Box on User Form
• Combo Box Problem
• Combo Box Selection in a Macro
• Combo Box to output test
• Combo box with all unique entries
• combo box write in option
• Combo Box/List
• Combo Boxes - Dates
• Combo Boxes and VBA
• Combo/List/Text boxes...
• combo_box with macro properties
• combobox
• combobox & lookup
• combobox & lookup
• ComboBox displaying number instead of date
• COMBOBOX in VBA: how reset the default value????
• ComboBox or DrowDown Selection to ActiveCell
• Combobox question?? Can I set a tab order on a worksheet (NON-VBA combo boxes)?
• Comboboxes embedded in a worksheet
• Comma Delimited ASCII "SaveAs" File
• Command button
• command button macro
• Command Buttons
• Command Buttons - VBA
• command line
• Command line arguments?
• CommandBar Size
• Comment defaults
• comments
• Comments - using find and replace
• Commission calculations
• Commission code
• Common Module
• compare column data
• Compare Excel sheets
• compare then copy to next page
• Compare to find duplicates within worksheet
• Compare two ranges of cells and return the value into one of the ranges
• COMPARE TWO SPREADSHEETS AND HIGH LIGHT THE DIFFERENCES
• Comparing a range
• Comparing formulae in a column
• Comparing Spreadsheets
• comparing two list ranges in two workbooks
• comparing two lists, finding the discrepancies
• Compilation of data from different files.
• Compile Error - VBA
• COMPILE ERROR-HELP!!
• Compile or not to compile?
• compiling
• Complete Macro
• Complex summing/counting of array - possible w/o macro?
• Complicated Macro - Help !
• Compressing multiple sheets onto one...
• Concantenation
• Concatenate
• Concatenate
• Concatenate Rows?????????
• Concatenate telephone nos. from cells in a column.
• Concatenating after running a Macro.
• Concatenating two cell addresses
• Concatenation Problem
• CONCLUSION: No one knows about EVENT CLASS proccedures
• Concurrency and VBA
• Condition by user name
• condition formatting based on presence/absence of formula in cell
• Conditional action on cell entry
• Conditional array - If a text string is met in one cell, display result in another cell?
• COnditional Cell locking, Tom Urtis
• Conditional cell locking....
• Conditional Compilation
• Conditional copying a row and inserting a new row
• Conditional Copying of cells
• Conditional delete row macro
• Conditional font formatting based on whether another cell is bold
• conditional format greater than 3
• Conditional format in VBA
• conditional format(dave I need your help again)
• Conditional formating for more than 3 conditions
• conditional formats(Dave can you explan the code you gave me)
• Conditional Formatting
• Conditional formatting
• Conditional Formatting
• Conditional Formatting - Need more than 3 formats
• Conditional Formatting in a macro
• conditional formatting macro
• Conditional Formatting or VBA question
• Conditional Formatting with Macro
• Conditional Formatting, I think
• Conditional formatting, need macro?
• Conditional Locking/Unlocking of cells
• Conditional ok
• Conditional Row Delete
• Conditional Row Selection
• Conditional select range in a macro
• Conditionally hide worksheets
• Confused!
• Confused, please help
• Consecutive Form Numbering?
• Consolidating many workbooks into one
• Contact tracking & option button questions
• contents of cell in footer
• continual running of a macro
• Continuation of old question
• Control Arrays in VBA???
• Control Freak!! User Forms
• Controlling the sequence of when Macros are run
• Controlling the SUM of RANDOM numbers
• Conversion of a simple Lotus macro to Excel
• convert
• Convert .xls to .csv
• Convert Excel 2000 line in macro to 97
• Convert files from wr1. to xls
• Converting a recorded Macro into a Generic One
• CONVERTING ADDIN TO MACRO
• Converting an entire worksheet to caps
• Converting lotus macro to excel
• Converting Lotus macros to Excel 2000
• Converting Lotus macros to Excel 2000
• Converting numbers to a word string
• Converting strings to numbers using Excel VBA
• Coping multiplw worksheets into one
• Copy & Paste
• Copy & paste 2 anthr sheet-same wrkbook-next empty row
• Copy & Paste macro
• Copy & Paste Special
• Copy / Paste Userform
• Copy + pates VBA
• Copy a column & paste into consecutive rows
• Copy a macro
• Copy a range and have it transposed and inserted into another file with VBA
• Copy a Range into a new Excel-Sheet
• Copy a Range to another worksheet
• Copy a range, have it tranposed and inserted into another file in VBA
• Copy and paste code
• copy and paste from one sheet to another
• Copy and Paste Macro
• Copy and Paste Macro help
• Copy and Paste Problem
• Copy and Paste with macro
• copy and paste with v basic code
• Copy Cells On Double Click
• copy contents of a cell and paste to another sheet
• copy data from one workbook to another using macro
• Copy duplicate data to new worksheet
• copy every fifth row and paste
• copy files (not .xls) using an excel macro
• copy from cell and insert in other cell automatically
• Copy from Excel and paste special in word
• Copy from Excel, then open and run a macro in Word template
• Copy last row in File 1 to next available blank row in File 2
• Copy list to every next WS
• Copy Macro
• Copy macro with blank cells
• Copy Macros from Disk to Excel
• Copy method in a click event
• Copy method of worksheet class failed ?
• Copy named range from 1 file to another
• Copy non-excel-file with vba
• copy paste
• Copy prevention technique??
• Copy Question
• Copy Question Variation
• Copy range names from a workbook to another workbook
• Copy Range of cells
• copy row a specific number times
• Copy Rows
• Copy rows to specific ranges, depending on the contents of the row.
• Copy sheet from another workbook through VBA
• Copy Sheets to a New Workbook based on Cell Contents
• copy specific cells from a row in 1 sheet to different cells in 1 row in another sheet
• Copy the new line...
• Copy to last used row
• Copy to the first empty cell by use of a macro??????????
• Copy values from worksheet to worksheet
• Copy Workbooks & Macros
• copy, save-as disables
• Copy,paste macro from multiple sheets
• Copy/Move/Insert row/columns into multiple worksheets
• Copy/Past Question
• Copy/paste non-contiguous cells-but same row -- into diff wrksht,sme workbk - nxt empty row
• Copy/paste only cells>0--Celia I have a case simmilar with the one you solved for Mac P.-Please help
• copying (an anchored col) and pasting to incremental colum
• Copying a background with a 'sheet.copy' macro
• Copying a macro
• Copying a range to another workbook range/rows
• Copying a Range using Variables
• Copying an exsisting Worksheet
• Copying and Pasting Cells
• COPYING AUTO-CORRECT ENTRIES.
• Copying certain cells of data in a row - Barry Davidson
• Copying certain cells to another worksheet
• copying contents of most recent cell visited
• Copying Data - Simple for you experts!
• Copying data from an Userform
• Copying data from one sheet to another and "IF" ....
• Copying data from one workbook to another?
• Copying formula to top of a table which varies in size
• Copying Macros
• Copying Multiple Rows
• Copying multiple spreadsheets to a new workbook
• Copying Named Ranges/Cells
• copying only last row data
• Copying Ranges to different Workbooks
• Copying row if value in column G is greater than 0.
• Copying rows and also running macro on open
• Copying same range from multiple sheet to a new sheet
• Copying to another workbook via finding sheets
• Copying Unique items from a range, with VBA
• Copying Workbook Event Procedure Programatically
• Copying/Pasting worksheet data from one workbook to another
• Copying/Renaming Sheets (Excel 2000)
• Correct Statment in VB?
• correct syntax in VBA
• correction: Get a value from cell D3 and use that value as a new filename
• Correction: Save completed worksheet in the same folder as original
• Could I do this with a macro?
• Could somebody check out this code and tell me whats wrong?
• Could someone please fix this code for me...
• Could someone tell me what's wrong with this code?
• Count Lines in a Text File
• Count on one sheet list on other?
• Count Unique Records
• Countdown timer
• Countdown Timer.
• Counter for Number of times a document is opened
• Countif (A1:A5) has formula using the good TypeF function suggested by Ivan Moala
• Counting
• Counting
• Counting and displaying Macros Dynamically
• Counting blanks
• Counting Cells with a certain fill colo(u)r
• Counting colour filled cells
• Counting Colours
• counting delete rows
• Counting down the number of cells moved
• Counting Duplicate enties within a Date
• Counting duplicate numbers
• Counting Hidden Cells
• Counting how many times data is entered
• Counting letters in a string
• counting ranges of rows/cells
• Counting Shaded Cells
• Counting Shades
• Counting values of the same cell in numerous sheets excluding values that are 0
• Counting Workbooks
• Coverting to all caps
• Create a comment when a cell is changed . . .
• create a formula that performs a calculation when a # is entered
• Create a macro button that will filter / sort, then print out a report.
• Create a Macro to strip out HTML coding from cells in a worksheet
• Create a new Excel Object through VBA applying existing XLT template.
• Create a new folder using a variable
• Create a pause within a macro
• Create a Pop-up warning box
• Create and rename new sheets using VBA.
• Create click event on another userform while executing event from another userform
• Create CommanButton in Code
• create dir if doesen't exist
• Create Folder
• Create new Excel file / folders in VBA
• Create new macro
• Create Sheet
• Create worksheet from cell content
• CREATEDATE in Excel
• Creatin a Macro to Insert the File name into a spreadsheet
• Creating "dead" chart with VBA
• creating a "," every 2nd character through a string of text???
• Creating a custom data type
• creating a list from repeated one cell entry
• Creating a log file to find out who is using the file
• Creating a macro
• Creating a Message Box
• Creating a message box to take an X, Y, Z and perform Sum of Squares
• Creating a new folder
• Creating a Non-Contiguous Range
• Creating a password for a macro
• Creating a post-script file using Excel
• Creating a salutation from a postal title
• Creating a variable size array
• Creating a Warning message
• Creating an exception report through EXCEL macro
• Creating an if/then loop which terminates at a blank cell
• Creating Excel through Javascript
• Creating File Lists
• Creating folders.
• Creating listboxes in VBA
• creating square cell
• creating text files.
• Creating Worksheets Using a Macro
• Creation Date
• Creation date vs today's date
• Cross Reference Inventory Pricing
• CSV and Macros
• Ctrl + f, "Find Object"
• cummulitive totals
• Cumulative Macro
• Cumulative macro
• cumulative total in a cell
• Cumulative Total Within Cells
• Cumulative total, here I go again...
• Current Page and Pivot Tables
• current path in footer
• Current running macro's workbook or worksheet name
• Cursor "box" on active cell
• Cursor Movement Macro
• Cursor Position
• Custom Colour Code VBA
• custom dialog box
• Custom Footer
• Custom Function
• Custom Functions in modules
• Custom Help Message for a Cell
• Custom Menu Problems with Macros
• Custom menus
• Custom Number Format - Figures to Words
• Custom number format problem
• Custom Right Click -->Kinda like a modified menu command
• customize right-click menu
• Customize standard toolbar for specific files
• customizing right click menu
• cut and paste macro - using active cell as start point...
• cut/paste a chart with a Macro?
• Cut/Paste variable
• CutCopyMode Property
• Cutomised Headers
• Cutomized Macro Button paths
• Cutting down returned results???
• Cutting up Workbooks
• Cycle through all worksheets?
• cycling through worksheets collection w/VBA
• Damon Ostrander
• Damon Ostrander
• DAO CopyFromRecordSet
• Data - Get External Data - Import Text File
• Data Copy & File Save As in a Sequence
• Data from one Workbook automatically go into another
• Data Input Box
• Data input halts in macros
• Data Manipulation in VB
• DATA REQUIRED IN CERTAIN CELLS
• data validatie in UserForm
• data validatie in userform
• Data Validation - URGENT PLEASE HELP
• Database access
• Database values Protection
• Date - time - number - problem
• Date format error macro
• Date formats
• Date protection
• Date saved stamp
• Date stamp column
• Dave - Followup questions for GetOpenFilename
• Dave - In That Case - I still wasn't clear
• Dave can you have another look at my generating controls on userform post
• Dave Hawley
• Dave Hawley - VBA Date Filter - Still Not Working
• Dave Hawley (or anyone else for that matter), HELP!!!
• Dave Hawley Help Again!!
• Dave Hawley, about your external link macro (take a look)
• Dave Hawley, Salvatore. Are you there?
• Dave....Help Again
• Dave..plz help me with this macros..
• Dave/Aladdin Help! Impossible Puzzler!
• Dave: Question about "Save as" macro
• Dave: Question about Find/Delete Row and Row Above
• David- adding find and goto buttons
• David Hawley (Compare-copy, From: Andonny
• DAX - ColorIndex based on value
• DAX ! This is Jill ! I still need your help !
• DAX???
• dd/mm/yy from general format
• DD/MM/YY to MM/DD/YY
• DDE links in Excel 2000 - how to run a macro
• Deactivating Auto_Open Macro's
• decimal format
• decimal zero in label and textbox of userform
• declare function (API in VB)
• Declare Variables for CheckBos Object
• Declaring all variables as modulewide w/o listing them one by one
• declaring variables
• default last line
• Default macro startup file
• Default Printer?
• Defaults for active cell on opening a file
• Defining a range name w/ VBA
• Defining range names
• Defining Range Names using Vba
• Delay between running macros
• Delet PageBreaks in VB
• Delete a file using the SHELL function
• Delete a file...
• Delete a row that the active cell is in
• Delete a row that the active cell is in
• Delete all blank rows macro
• Delete ALL Named Ranges on ACTIVE Worksheet?
• delete blank columns macro needed
• Delete cells after searching for a value
• delete cells depends on another values
• Delete columns
• delete columns
• Delete duplicate rows?
• Delete Empty Rows
• Delete headings
• Delete Hidden Columns
• Delete Hidden Columns
• Delete Hidden Columns
• Delete IF !
• Delete in macro
• Delete macro but still get macro virus warning msg
• DELETE MACRO'S / MODULES????
• Delete Modules Or Macro's By Running A Macro
• delete old used rows
• Delete row based on cells in different columns
• delete row/column and maintain borders/formatting
• Delete Rows in VBA
• delete rows, saving the setting
• Delete sheet
• Delete Sheet in VBA
• Delete sheet macro?
• Delete toolbar if it exists
• deleteing contents of one cell based on contents of another
• Deleteing duplicate info
• Deleting A Line
• Deleting a line with a key word in it
• Deleting a Macro
• deleting a range after sorting
• DELETING A ROW
• Deleting a row
• Deleting a sheet without that annoying popup
• Deleting a tab without getting a warning
• Deleting a temp file.
• Deleting a workbook from c: drive
• Deleting All Blank Cells after importing a text file
• Deleting almost duplicates?
• Deleting blank rows
• Deleting button "remnants"...
• deleting cells
• DELETING CELLS AFTER SEARCHING
• deleting code
• Deleting CUSTOM REPORT VIEWS thru VBA.
• Deleting Double Info
• Deleting dupes
• Deleting Duplicate Enteries
• Deleting Duplicate Rows
• deleting duplicated rows from a mailing list
• Deleting Duplicates
• Deleting Dups
• Deleting every other column (variable range)
• Deleting every other row
• Deleting Hidden Rows. Beginner needs help
• deleting highlighted cells
• Deleting lines in a txt file
• deleting macros
• Deleting Macros with VBA
• Deleting Modules & Macros with Code
• Deleting Modules & Macros with Code
• deleting multicolumn duplicate rows via a macro
• Deleting Multiple Sheets in Macro
• DELETING OBJECTS FROM A WORKSHEET
• Deleting of rows
• Deleting range names using a macro
• Deleting Rows
• Deleting rows based on a value in that row
• Deleting rows below the end of a list that changes in length
• Deleting rows if a cell value = "x"
• Deleting rows if a particular cell is blank
• Deleting Rows in Excel
• Deleting sheets
• Deleting sheets with VBA
• Deleting sheets, without ok prompt
• Deleting Solver Constraints in VBA
• deleting zero balances
• Deleting/Moving another workbook from inside a workbook
• Deselecting after copy-paste
• DESPERATELY NEEDING HELP! "Range Class" method failing!
• Detecting Changes in a Worksheet
• Detecting version of Excel upon opening
• determining the Visible value of a worksheet
• diabling the delete dialog
• Dialog Box interferes with spreadsheet display
• dialog while macro is running
• DIfference between Module and Class Module ?
• Difference function or macro
• Difficult macro for a VBA novice (info in 1st post got messed up)
• Difficult Question: Modifying Setting of VB Editor with Macro!
• DIM help
• dimension statements and public variables
• directory and drivelist to Dave
• Directory Browser within a macro?
• Directory Validation
• Disabel scrolling
• Disable - "Enable/Disable Macro Warning"
• Disable "Cut" command
• Disable "X" on userform..
• Disable / Enable Macro's
• Disable a macro of Excel
• Disable A Module/Userform
• DISABLE CLOSE "X" BUTTON, AND LOCK FORM POSITION
• Disable Custom Toolbar Buttons
• disable cut mode
• Disable F1
• disable macro virus warning in excel
• Disable Macro Warning
• Disable macro warnings on Citrix
• disable macros
• Disable Macros
• Disable macros in a workbook
• Disable menu functions
• disable mouse right click
• disable new and open menu icons
• Disable Print and save in VBA Excel
• disable print preview
• disable right click
• disable right click menu
• Disable the close button in Excel
• Disable the Shift ket at startup
• Disabled Save As
• Disabling Ctrl+Break
• Disabling macro alertt
• Disabling macros once a commandbutton is clicked
• Disabling Message Box Prompts
• Disabling the Cut function
• Disabling the the enable or disable macro dialog box
• Disapearing macro toolbar
• DISPLAY A MSG WHEN RUNNING A MACRO
• Display available printers with vba
• Display Last Modified Date
• Display message when processing lengthy operations
• display number as words
• Display of "Modified Date" in workbook
• Display of Warning Messages in macros
• Display 'Paste Options' smart tag via VBA
• Display Scenario Name
• display time in the textbox of a user form
• display userform when opening a spreadsheet
• displayalerts
• DisplayAlerts -- How NOT to accept the default
• Displaying a custom toolbar
• Displaying a number as words
• Displaying all sheets in a workbook using a combo box
• Displaying Dates in a Text Box
• Displaying filenames automatically by default
• Displaying full paths in custom footers
• DISPLAYING LAST MODIFIED/SAVED TIME AND DATE ON A WORKSHEET
• Displaying Nested Subtotals
• displaystatusbar method ????
• Distributing macros
• Do I link or share
• Do same thing to all sheets in workbook
• Do Until statement for finding first empty cell (gets harder)
• Do you know a good site for macro examples?
• Document properties placed in a cell
• Does a macro always have to be "assigned" to a specific spreadsheet?
• DOES ANY KNOW HOW I CAN GET A MACRO TO REFRESH EVERY HOUR...?
• Does any1 know a good free online VBA Tutorial
• Does anybody know why this sheet code is ignored by Excel?
• Does Excel VBA allow you to use Collections like VB
• Does text exist in range? (I feel silly asking, but . . .)
• DoEvents
• Doing a Simple Sum in VBA
• Don't allow Esc to stop macro
• Don't display formula
• DOu Until or something else? Heres a bit of a challenge
• Dragging files iknto Excel
• Drawing rectangles from within a macro
• Drivelist and directorylist
• Drop arrow and List Box
• Drop Down Boxes in Cells
• Drop down list macro
• Drop down lists
• Drop down menu for running macros
• Drop Down Menu Problems
• Dropdown nightmare!
• DropDown x 2
• dropping down a line
• DTPicker values
• Dumb Macro Question
• Dumb Question: How do I make Excel go back to the active cell after a macro runs?
• Duplex Printing
• duplicate checking
• Duplicate Entries
• Duplicate entries
• Duplicate removal via macro
• Duplicate Values
• Duplicates added to listbox
• duplicates in list
• Duplicating information.....hellllllp!!!
• Dynamic Colums and Summing
• Dynamic formula
• Dynamic Print Range Macro?
• Dynamic textbox backcolor change in a userform
• Dynamically Changing Row Heights based on cell values
• Dynamically finding a range in Excell with VBA
• Dynamically generate a new Excel sheet
• Dynamically Opening All Files in a Directory
• Each Cell to have a comma added to it's data
• Easier one...Select Case
• Easier way to do Macro
• Easy macro problem PLEASE HELP ME!!!!!!!!!!!!!!!!!!
• Easy one ... How to cut and paste rows between sheets?
• Easy question ASAP: VBA to Activate/ Run a Dialog Sheet
• Easy Question. What code will open up a MS Word document while in Excel?
• Easy question...visual basic cell offsetting from cell entry
• Easy VBA ComboBox Question - I Hope!
• ecxel macro paste special
• Edit macro to make it run on open
• Edit macro to protect/unprotect multiple sheets
• Editing a Macro
• Editing a new total
• Editing a protected Sheet
• Elapsed Time calculations
• eliminating duplicates
• ElseIf
• Email (inter office) w/o saving to main file.
• Email and display a worksheet
• E-mail for certain day
• Email from excel with outlook..code win00 XL00
• Email in VB
• e-mail macro
• Email Macro Not working right.
• Email Macro Problem
• e-mail Notification of a Change in an Excel document
• email only certain sheets
• Email w/o Saving "Cont"
• Emailing a file automatically using LOTUS NOTES
• emailing a single worksheet from a workbook
• E-mailing a Worksheet.
• Emailing with Application.Dialogs(xlDialogSendMail).Show
• E-mailing workbook using a macro
• Emailing worksheets
• Enable / disable macros prompt
• Enable Macro Message but no macros involved
• Enable Macros
• enable/disable based on check box
• EnableSelection = xlUnlockedCells, but then can't change locked cells
• End home
• End If $ Else without block If error
• End If, Exit Sub problem
• End Macro Question
• End this macro
• Error checking help
• Error in Paste Macro
• Error messages
• Error on Macro that Sends email through Outlook
• Error proofing macros
• escape key
• Essentially "alt-tab" to other spreadsheet with macro, to close it
• Euro Conversion in VBA
• EURO CONVERT
• Evaluating cell content and then doing one of two things.
• Evaluating content of cell then doing one of two things in cell
• Event coding in VBA
• event doesn't fires when a cell value is changed.
• Event for Sheet_Delete ?
• Event Handler Problem
• Event Handlers
• excel
• Excel
• Excel
• Excel
• excel
• Excel macro to send excel worksheet
• Excel - Macros - Lookups
• Excel -> Regression-> How to write a macro with variable dataset sizes
• Excel 2000 - Slow When Executing VBA Codes
• Excel 2000 Macro not changing value in cell
• Excel 2000 Macro/Virus warning
• Excel 2000 Pivot Chart & compatability with 97 VBA macro
• Excel 2002
• Excel 4 macro
• Excel 4.0 Macro
• Excel 95 events
• Excel 97
• EXCEL 97 a couple of problems Questions
• Excel 97 Macros
• Excel 97, get with VBA the date of creation of a workbook
• excel 98 for macintosh
• excel 98 for macintosh
• Excel Aborts in copy/paste macro
• Excel Active Cell Indicator Format
• Excel Addition Formula Question
• excel advice
• excel and access integration
• Excel and VBA
• Excel automatically capitalize text in a column
• Excel Automation - Challenge
• Excel Automation from COM+ (VB) - "Method ~ of ~ failed"
• Excel builtindocumentproperties
• Excel cannot shift nonblank cells off the worksheet
• Excel cell formating
• excel circular reference
• Excel color palette
• excel columns
• Excel Data validation lists from within VB
• Excel date formula
• Excel Email Macro
• Excel Field Format
• Excel file awareness in VB
• excel file crashed while executing a macro
• Excel font change
• Excel forms/Macros
• Excel Formula Help!
• Excel freezes when pasting to “event procedure” cells
• Excel Functions in VBA
• Excel Global Color Change Macro?
• Excel graphs and VBA
• excel gurus, need help with this code please!
• Excel Highlight Macro
• EXCEL Illegal Operation.
• Excel Macro
• Excel Macro
• Excel Macro
• Excel Macro
• Excel macro
• excel macro
• Excel Macro
• excel macro
• Excel Macro
• EXCEL macro
• excel macro
• Excel macro - print to file
• excel macro and "shift+end+down"
• excel macro comand
• Excel Macro edited w/VB, Add cells in columns
• Excel Macro fails 'Subscript out of Range' but works in Debug mode!
• Excel macro issue
• Excel Macro Programming
• excel macro relative reference problem?
• Excel Macro Save As Link
• excel macro to fill cell with information in above cell
• Excel macro to munipulate a text file
• Excel macro/VBA
• Excel Macros
• Excel macros
• excel macros
• Excel Macros
• Excel macros and VB
• Excel mail to Lotus Notes
• Excel Match Data Macro
• Excel Message Box (VB)
• Excel Message Box : Yes - No
• Excel message crashes macro
• Excel migrating data from a spreadsheet into a custom form
• Excel Msg Suppression
• Excel Name Macro
• Excel name range - help
• Excel not saving the active workbook
• Excel opens blank workbook
• excel problem
• Excel Problems
• Excel prog trial time limit. Need advanced help.
• Excel Programming with Macro
• Excel ranges, events and naming
• Excel Recorded Macro gets Run Time Error
• excel rows
• Excel Save As Macro
• Excel scrollbar linked to a range of values that changes
• excel scrolling
• Excel selection macro
• Excel sheet in word?? Macro?
• excel summary sheet
• Excel Timer
• EXCEL TO ACCESS
• Excel Validation
• excel vb - pressing a button to add to a cell incrementally
• Excel VB Macros
• Excel VBA
• Excel VBA (Ending A Process)
• Excel VBA code help please
• Excel VBA Events: Print?
• Excel VBA Looping Problem
• Excel VBA Macro's
• Excel VBA Protection/Unprotection
• Excel VBA-summing 3 columns by codes
• Excel Version info from macro
• Excel wont access to MS Word from Excel using automation
• Excel Work Sheet
• Excel, I need a cell to update with the last day modified.
• Excel, VBA, Word..... fancy a challenge?
• Excel. How do I insert a new row by hitting enter.
• Excel/Access/VBA Macro Chat somewhere? Linktips plz ;-)
• Excel2000 crashes when searching a networked drive
• excel4 macro warning
• Excel97 Copy Method
• Excell copy macro
• Excell Macro
• excell macro
• Excell Macro
• Excell menu options
• Excel's Ability to Apply Serial Numbers
• Execute Excel Macros From Access?
• Executing another Sub
• Executing time of 'Find'method and looping
• exit button on forms
• exit sub
• Exit without saving
• Exiting The Debugger
• Ex-Lotus Macro User Question on Selecting an 'Unknown' Range
• Expert help needed! I'm stumped...
• Explaining soem code...
• Export and import individual sheet from workbook.
• Export Sheet to new workbook?
• Export to a csv file
• Exporting Excel spreadsheets to MS Access thro code
• Exporting part of spreadsheet as a Text File
• Exporting to a multiline flat text file.
• Exporting to a text file
• External Data on diff worksheets
• Extract data from another excel file using a macro
• Extract List of SubDirectories or list of files.
• Extract text from Comments
• Extracting Data from an Excel Table
• Extracting data from multiple files
• Extracting data Macro
• Extracting numbers from text.
• extracting the year out of a date variable
• faceid question
• Factors of a Number
• FAST CUT and PASTE
• Fast Data Entry
• File | close Save=no
• File date in a cell
• File Date Time function
• File Name for E-mailed workbook
• File name from VBA
• File Name Macro
• file name=existing filename + 1
• file open error
• File Path
• file path in report footer
• File save as with path statement
• File save with macro, pick the file name from named cell on spreadsheet
• File Saving Macro?
• Fill Combo with files from folder
• Filters on a protected worksheet
• Find
• Find / Search Function
• Find activecell value in a range
• Find all rows that = X and copy to other sheet? Only finds first?
• Find and Delete Macro
• Find and Move a specific cell
• find and replace
• find and replace based on a column in another sheet
• find and replace help needed formula or macro
• find and replace macro
• Find by value
• Find command with macro doesn't work
• Find Dates
• Find duplicates in worksheet
• Find file path to link to access db
• find fixed string in cell and delete the row
• find function
• FIND GAP IN NUMBER SEQUENCE
• Find if array is already defined
• Find last cell with xlup
• Find last filled cell in column, simple dialog box
• Find last row based on cell contents
• Find Last Row To Sort On
• find next blank column
• Find result without use of macro
• Find right-most occurence of charcter
• Find string then replace with string 1
• Find text - delete the row it's on
• Find the last cell in a column, get a count and paste the value to the top
• find value in cell
• Find/Delete Row and Row Above
• find/replace macro
• Find/Search Excel Macro
• FindControl ID#s
• Finding a (Changing)value and cutting all data to a new sheet
• Finding a PaqeBreak using VBA for Excel
• FINDING A ROW THAT MEETS TWO CONDITIONS
• Finding an exact match
• Finding and Copying
• Finding and Deleting a specified worksheet
• Finding and replacing the tab character
• Finding Automatic Links
• Finding first and last cells containing data
• Finding Highest Number and Selecting Adjacent Cell
• Finding Numeric Cells
• Finding out the cell using VBA
• Finding places that Macros are Called From
• Finding Sheets in a workbook
• Finding the addres of a cell
• Finding the bottom of a sheet in Macro
• Finding the last column in a row using VBA
• Finding the start of a row
• Finish a list of numbers
• Fire a mail message
• first day of month&las day of month
• First Empty Row
• first macro
• First Null Cell in a Column
• Fix a macro ( or spot the dumb mistake I made)
• flash cards
• Flash SubProgram
• FLASHER
• Flickering forms
• Flickering of sheets during save...Please help me..
• Follow up question on Printing Word Document from Excel Macro...
• Following calculation, a macro returns to the next cell
• Followup ? to message#17881
• Footer macro
• footer on last page of document
• Footers
• For Barrie Davidson
• For Barrie Davidson
• For Dave Hawley...
• For everyone who wants to delete duplicates in a column
• For Next Loop Problem
• for x = file1 to file5000 ??? next file please.
• For...Next question for userform update
• For...Next trouble
• FORCE a file to Save ??
• Force a user to follow our insrtuctions
• Force uppercase into a cell from a textbox
• Forcing a macro to run
• Forcing a sheet to calculate when automatic calculation is turned off for the workbook
• Forgot my password to my VBA file
• Forgot VBA project password.....
• Form changes size
• Form load
• Form_Load()
• Format
• format a report using VBA & add totals & subtotals
• Format cell for different colored text...
• Format date in header
• Formatting a Concatenated Value
• Formatting after Importing a Text File
• Formatting as text/string in macro
• Formatting cell to thousands
• Formatting Cells
• Formatting data in Excel
• Formatting numbers
• Formatting problem with vb
• Formatting text using activecell offset
• Formatting using the hide feature
• form-based macro for checkboxes on a sheet
• Formula
• Formula and Possible Macro Help
• Formula for Date ranges
• Formula help.
• Formula in macro
• Formula or VBA Code
• Formula that changes based on active row
• Formula that returns address of active cell?
• Formula to test for bold text or not
• formula to VBA
• FormulaArray problem in VBA
• FORMULAS
• formulas for volume and/or area
• Forward a cell's contents
• Frame hides controls on UserForm
• Freebee - Numbers as Text
• Freeze panes using shortcut keys
• freezing the Today() function in macro
• from a VB Macro how to save a excel worksheet as text file
• From ActiveCell (Row-1 and Column = A)
• From excel need to open access form or database
• From UserForm to a cell
• from workbook2 switch to workbook3 and run a macro
• full file path in the footer
• Full path on printed footer
• function not functioning
• Function variable
• Function VBA Name changes in worksheet!!
• functions breaking up/stopping VBA code
• functions....VBA
• General help
• General question about macros
• General VBA Question, non technical
• Generating controls on a userform
• Generic Chart Macro
• generically moving cells around
• Get a value from cell D3 and use that value as a new filename
• Get cell address with VBA without absolute address
• get dir list or open files sequentialy
• Get list of sub-directories
• Get results onto spreadsheet instead of listbox
• Get rid of "Enable Macros" and "Don;t Update Links"?
• Get rid of macro warning, since there is no macro
• Get the column address in alphabets - i.e. A, B, C .. etc
• Get user id from Windows 2000 - Tough question?
• Get user initials from user name.
• Get value of a cell before it is deleted.
• GetADate from user.
• GetObject
• GetOpenFilename takes to long to list directory contents
• GetOpenFileName??
• Getting a cell to default
• Getting a Cell's Color using a macro
• Getting a range from a userform to use in VBA code
• Getting around macro protection?
• Getting away from SENDKEYS
• Getting data from a big list into several smaller lists, based on criteria
• Getting data from outlook and excecuting excel vba
• getting excel to automatically update on the 1st of each month
• Getting Excel to Display Cells Which can add up to a given number
• Getting highlighted address range in VB
• getting mode of a column of strings
• Getting Outlook contact info from an Excel Macro
• Getting Ranges from spreadsheet into a Text Box?
• Getting Rid of #DIV/0! errors on a massive scale
• getting rid of activate macro message box
• getting rid of saving warnings from VBA
• Getting rid of words in a cell in a Workbook
• Getting text in a UserForm to flash
• Getting the Auto List in VBA
• Getting the calculator
• Getting VBA to answer Name Conflict dialog box automatically with Yes
• Ghost Macros
• GLOBAL REPLACE
• Globally Highlight Current Row in Color
• goal seek help
• Going to Specified Folderr
• Golf PS
• Got a couple of questions
• Goto Dialog Box via VBA
• GOTO Macro Function
• GOTO Macro Trouble
• Graph - Macro
• graphically scaling dimensional arrows
• Graphing Macro
• Group Editing (VBA)
• Grouping worksheets for global format changes
• Guru Help needed - offset cell problem
• Handbooks
• Handling seperators(commas, periods) in long numbers in VBA
• Hard Returns in Macro
• Have Excel Open spreadsheet 'A' when you open spreadsheet 'B'
• Having a macro run automatically every 15 minutes
• Having problems with Variables within my macro.
• Having trouble closing Excel from macro...need help.
• having trouble w/ following macro and need help!!!
• having trouble with Workbook_BeforePrint(Cancel as Boolean)
• HELLLLLLLLPPPPPPPPPPPPPPPPPPPPPPPPPPPPP!
• Hello again...need help with identical changes to 62 different workbooks...
• Hello Dave..how about clear all vb macros too..i mean delete vb macro on certain dates..any ideas..thanks
• Hello Robb, bother yu again.......
• HELP
• Help
• Help
• HELP - NEED CELL DATA DELETING MACRO
• HELP - DELETE ALL CHECKBOXES FROM A SHEET
• HELP - NEED "FIND" MACRO
• HELP - NEED FIND AND FIND NEXT MACRO
• HELP - NEED MACRO TO ELIMINATE "#DIV/0!" VALUE IN CELLS
• HELP - ROW MACRO NEEDED
• Help - Syntax Error
• Help !!! Macro, Formula, or ? - Thanks in Advance for Your Help
• Help calling macros from custom add-in
• help calling up another sub when targets in a certain range ( can someone let me know if this is posible)
• Help combining cells till blank
• Help controling cell selection navigation with macros!
• help creating a timer
• HELP DELETE TEXT FROM TEXT BOXES ALL AT ONCE
• help desperate, array not found in excel
• Help extracting Macros from Excel
• HELP FAST--How to do a text search for a column so that it indicates if it is a duplicate entry.
• Help fix macro
• Help me please! Shortening some VBA code
• Help me Robb
• Help me! Tricky problem with a deadline!
• Help my brain has disappeared and i can't figure out this stupid answer aaaaaaahhhhhh!!!!
• Help my slow looping process
• HELP NEED MACRO TO DELETE DATA IN SPECIFIED ROWS
• Help on Pictures
• help out the new girl
• Help part 2 - (thanks Dank)
• help please
• Help Please
• Help PLEASE
• HELP PLEASE- SELECTING A RANGE
• Help Please! Execute Excel Macro on Workbook Close
• HELP REQUEST: How to 'Protect' Certain Cells from Changes?
• help selecting a cell
• help selecting a cell
• Help showing all permutations of values in two ranges
• HELP sorting a protected worksheet
• help speed up code (the code copies info from userform to sheet)
• HELP VISUAL BASIC FOR APPLICATIONS EXTENSIBILITY!!!!
• help w/ vba code
• Help With - Private Sub Worksheet_Change(ByVal Target As Excel.Range)
• Help with a button on a spreadsheet
• Help with a Macro
• Help with a save as macro command
• help with a variable
• Help with code...EASY...
• Help with custom sort macro
• help with databases
• help with end(xlup)
• Help with find macro
• Help with getting marco to run
• help with List !!!!!
• HELP WITH MACRO
• HELP WITH MACRO
• help with macro
• help with macro
• Help with macro to sort, subtotal, total
• help with macro to synch values in 2 documents based on label in a specific column
• Help with macros
• Help with Marco
• help with numbers
• Help with Offset function
• Help with plot area ASAP !!!
• Help with Range and Cells methods
• Help with Range objects please!
• Help with Row Delete Macro
• help with selecting cell groups with variable
• Help with text boxes on User form
• HELP WITH THIS MACRO
• Help with user form
• help with VBA Syntax - Text File Import (long)
• Help writing macro/VBA
• HELP! How do I import files with > 65K lines?
• HELP! Auto calculating start times and time values
• Help! Colour count...why does not work?
• Help! Filename Checking Routine
• Help! with macro loop please, merge range loop
• Help!! macro unprotect
• Help!! - Automate PDF printing in VBA
• HELP!! NEED TO SELECT DYNAMIC RANGE? !!!!!!!
• HELP!! TEXT FILE OPEN MACRO SNAG AT DELIMIT FUNCITON.
• HELP!!! Inserting cell values
• HELP!!!!! VB Question
• HELP!** ...Sharing XLA files - VISUAL BASIC... **HELP!
• Help, Using VB to Open a certain type of File
• Help..I need code..Don't know much about VB..Help
• Help; I need a way to highlight across columns in a single row.
• HELP? Formula to Figure Split Commissions But Not Retroactive
• HELP-deleting a MACRO but is still there
• Help-How do I Insert a row
• HELP---Loading an excel files by macros
• Helpp! possessed macro!
• HELPPPP USING ADDRESS PROPERTY
• Here’s a conundrum for you!
• HH:MM code
• hidden cells
• hidden columns
• Hidden Sheet
• Hidden Sheets & Macros
• Hide - Unhide - Hide Bars
• Hide #NUM from a sheet using excel VBA
• hide / disable formula bar on"workbook_open"
• Hide all Command Bars on open
• Hide all toolbar , open always on the same sheets and hide some of the sheets..inside..
• Hide Blank Rows
• Hide Formula & auto forwad to certain cell
• Hide formula box
• Hide Menu On Opening - Unhide on Close
• Hide row based on values in two different columns
• Hide Sheet
• hide spreadsheets
• Hide unwanted rows and and Columns
• Hide Worksheets
• hiding a column
• Hiding a dialog box before continuing the next called macro
• Hiding a Selection
• Hiding and unhiding
• Hiding another workbook with vba...
• Hiding Buttons in Macro
• Hiding certain rows in a worksheet
• Hiding empty rows before printing..
• Hiding macros
• Hiding macros
• Hiding Macros
• Hiding Pivot Table Items- VBA -An Excel Bug?
• Hiding Rows
• Hiding Rows Given a Condition
• Hiding rows in a worksheet.
• Hiding rows with VBA ??
• Hiding rows...
• Hiding sequential rows during a macro
• Hiding Specific Items in a Menu Bar
• Hiding Specific Items in a Menu Bar
• Hiding Tabs
• Hiding then Showing Different Toolbars
• Hiding toolbars
• Hiding VBA Code
• Hiding VBA Code
• Hiding visible macro movement until finished
• Hiding WorkBook without specifying a file name
• Hiding Worksheets
• Hiding Worksheets with VBE
• Hiding/Unhiding Graph Sheets
• Highlight a cell when a user overrides its formula
• highlight a range using a variable
• Highlight Cells Macro
• Highlight entire row when cell selected
• Highlight Rows/Columns
• Highlighted Cells (Colors)
• highlighting a row in a macro
• Highlighting active cell
• Highlighting cells that are over 48hrs old
• highlighting rows and columns when selecting a cell - how?
• HIGHLIGHTING TEXT - In A TextBox
• Hit Counter
• hmm..need help with this one..a GURU needed for this one.
• Hope you VB wizards can help here -- should've took VB in school
• Horns of a dilemma!
• How ???
• how can I e-mail a single sheet from a work book?
• how can a macro be triggered by the entry of certain figures in a cell.
• How can design my own Form
• How can I automatically add the last 30 days of a row?
• How can I calculate using a background/fill colour ?
• How can I call an Excel Function in VBA?
• How can I copy non Excel files
• how can I determine if an excel file contains macros or not?
• how can I determine if an excel file contains macros or not?
• How can I eliminate duplicate data in a column?
• how can i fill a combo box with values from a file?
• how can I find and delete . . .
• How can I get 2 first characters from string?
• How can I get current position of "cursor"?
• How can I get current position of cell ?
• How can I globalize a macro?
• How can I input the last time the file was saved or modified into a cell?
• How can i keep a log of deleted cells
• How can I make a 2-way cross-link between cells from diff. worksheets?
• How can I make the save as box pop up with code
• How can I pass a variable from Excel to a MSQuery condition?
• How can I print a word document in middle of excel macro?
• How can I print the file name & patch in the footer?
• How can i protect the worksheet using VBA codes after a solver run?
• How can I refer to the currently active userform?
• How can I sort an array() ?
• How can I start a word macro from excel macro
• how can i store data of a sheet into a list box then i
• How can I unstring a Cell using a MACRO
• How can my macro go to the last active cell without using Range:
• How can you put 'beforedoubleclick' code into a new worksheet that you add ed
• How could I solve the Cint( ) if the string is a 6-digit figure??
• How do I access an excel macro in visual basic?
• How do I assign a macro to a command button
• How do I attach a toolbar I made to only ONE workbook?
• How do I change all text to CAPS?
• How do I check for the end of a row in Cell O and jump to the next row to Insert a New Record?
• How do I check if a worksheet file is open in VB?
• How do I check values of variables in a macro?
• How do I count rows highlighted with color fill?
• How do I create a macro that writes the current time in a cell when the value of a function changes?
• How do I delete subtotals that are 0.
• How Do I Deliver this VBA Customized Workbook
• how do i eliminate message boxes in my macro run
• How do I empty the clipboard in excel via VBA?
• How do I end/exit a macro?
• How do I execute a .bat file using Excel VBA?
• How do I execute a macro every time a particular cell is changed.
• How do I figure out last activecell? I can't figure this out.
• how do i force a integer to a textbox?
• How do I get a File / Open prompt in VBA?
• How do I get a line accross the sheet when a certain value is reached
• How do I get a Macro to Auto Run?
• How do I get a macro to run automatically
• How do I get an InputBox to run from within a Macro?
• How do I hide sheets within a workbook
• How do I launch a file open dialog box from within a macro?
• How do I loop through a spreadsheet just once?
• How do I make a single column of data go to multiple columns?
• How do I make Add in from Macro?
• How do I make my macro finish when it can no longer find copy in column H?
• How Do I Make Pop-up Windows in Excel?
• How do I minimize a userform?
• How do I move to a range with a button
• How do I open up power point in excel
• How do I overcome the maximum of "7 if loops" in Excel 97
• How do I pass text from a label in a user form by clicking an option to a text box in another user form?
• How do I paste data into the 'next row down'?
• How Do I Prevent a Macro From Being Viewed or Edited?
• how do I protect a macro in excel?
• How do I protect indivdiual cells?
• How Do I Put A User Input "Pause" In A Macro?
• How do I rename a module?
• How do I replace a text string with a line break?
• How do I run macro WHENEVER a file is saved?
• How do I save Date values in Excel-sheets????
• How do I say "Yes" to "Empty Clipboard?" in VBA?
• How do I send email from Excel Macro
• How do I set a Listbox's Rowsourse (within Word) to an Excel range?
• How do I shorten and optimize this code
• how do I sort more than 3 columns?
• How do I start a VBA procedure when selecting a cell????
• How do I Stop Do Loop.......
• How do I trigger a macro a cell in updated
• HOW DO I USE THE VLOOKUP AS A FUNCTION IN VBA CODE
• How do you change the comment box when inserting a comment using VBA?
• How do you code to find the next empty row...
• How do you do a conditional test to see if more than one sheet is selected?
• How do you get Visual Basic to either recognize text as a cell reference or to update its cells automatically?
• How do you loop to the next column
• How do you save a macro as an add-in?
• how do you sort multiple colums at once?
• How do you stop a macro working more then once?
• how do you stop the ontime macro application
• HOW LOOP through the textboxes? Please Help.
• how run a macro when enter is hit from a certain cell
• How to "freeze" the display while a macro is running
• How to activate a macro when delete a sheet?
• How to add a clear forms button to a spreadsheet
• How to add and name a workshheet
• How to add new value to values already in a cell
• How to answer a ? in VBA
• How to automate moving specific info from one spreadsheet to another
• how to automatically open another work upon the opening of one workbook
• How To Automatically Update When Records Are Changed
• How to call an external executable file (.exe) from within Excel 2000
• how to call in VBA a Worksheets whit variable?
• How to call subroutine from 1 module from another module
• how to clear contents of all input cells at once
• How to close a file when closing excel
• How to code right mouse click events into a macro
• how to collect some blocks into one block
• How to convert macro to add in
• How to convert numbers to text through macro
• How to copy/paste only cells>0 from a range
• How to count buttons in a sheet ?
• How to create a directory if it can already exists?
• How to create a macro that moves to bottom of list?
• How to create a Macro to delete selected data?
• how to decipher an Excel macro function?
• How to delete active column?
• How to Delete rows based on multiple criteria
• How to detect an empty cell ?
• How to determine the ID of a submenu item clicked?
• How to Disable Macro Prompt
• How to disable macro with VBA?
• How to dismiss macro warning.
• How to display all popup menus on right click in excel 97
• How to do conditional formatting with different font size
• How to Edit a Formula Used to Specify a Cell Range Name
• How to eliminate spaces in imported data?
• How to email excel spread sheet using macro?
• How to embed a macro in a cell formula
• How to enable macros without the prompt
• How to enter new data and change also the cell color?
• How to excute a macro on opening a worksheet?
• How to Exit a "Do While" Loop
• How to find a cell with underlined text in it (in xlm)
• How to formulate the following.....
• How to get a cell ref when selected?
• how to get a macro to run at a specific time
• How to get rid of macro warning without disabling message?
• How to grab every 10th row
• how to hide a worksheet menu bar so user can see full screen display.any ideas or something like code
• How to Hide Document Properties
• How to hide macro name in menu
• How to hide macro name in menu
• How to identify changed cell
• How to import data from a web page using a macro
• How to import text file and use VBA to perform INDEX & MATCH
• How to input text?
• how to insert relative cell references into a vb macro
• How to let a combobox appear?
• How to let user select directory, but macro assign file name on a saveas
• How to loop through a specific folder of workbooks
• How to make a button that pastes the current time in a cell?
• How to make a macro display all available fonts including true type fonts
• How to make a window-like file browser to faciliate opening of files in Excel?
• How to make an online form unscrollable
• how to make cells in excel 97 blink
• how to make changes to multiple files/macros
• How to make Excel recalculate every ??? seconds
• how to make global changes to comment fonts
• How to make letters bigger in MsgBox() prompt?
• how to make macro automatically run after modifying spreadsheet
• How to make Macro that prompts for user input and deletes a row that contains that value?
• How to make reference in VBA to a column that has a defined name
• How to make the shortcut key CTRL + s work for saving
• How to NOT save changes on exit? Before_close?
• How to open specific sheet at book open?
• how to optimize this?
• How to overwrite existing file without prompting?
• How to pass variables from one macro to another?
• How to pause a Macro
• How to Prevent Debug on Macro Error????
• How to Prevent from the workbook to pop up??
• How to print one page multiple times .....
• How to produce a beep when a person enters a wrong entry in a cell
• How to programatically delete lines in a module ?
• how to prompt for pw in Protect sheet macro?
• How to protect a workbook....
• How to protect/unprotect a VBA Project using macro
• How to read # of total pages in Excel Worksheet?
• how to reference a sheet using a variable
• How to refresh a macro in every minutes?
• How to remove 'hidden' macros
• How to remove newlines (carriage returns) by search and replace
• How to remove numbers below 6 in a very large sheet?
• How to reposition the default data form with code?
• How to represent Currency in textbox on VB Form
• How to return many edit box values in a loop?????
• How to run a Macro when cell is clicked on
• How to run macro without opeing excel file?
• How to run Windows calculator with a macro in Excel'97
• How to Save a File using a Cell Value as the Name
• How to save an Excel workbook without macro code
• How to Save As from VBA
• How to save copy of file on desktop?
• How to save file as next workday???
• How to select 1 cell and the cell above when condition=true
• How to select a range of cells using macro
• How to select ranges with variables
• How to set Reference in VBA
• How to set the default path that is used for opening files (in macro VBA)?
• how to set two conditions for each select case
• How to shutdown Excel from within a macro
• How to speedup a macro.....
• How to start and run an Excel macro from command line?
• How to stop a user from closing a window
• How to stop user disabling Macro's on start up?
• How to Suppress Dialog-Boxes while saveas text ??
• How to suppress the prompt for macro Enable/Disable
• how to switch names from Last, First to First Last
• How to tell if worksheet is protected?
• How to test for Existence of a WorkSheet (in Macro).
• How to Trap or TEST for "#REF" error?
• How to turn off excel warning at startup..
• How to unlock a locked VBA project?
• How to use Excel 2000 Addin With VB
• How to use FREQUENCY function in VBA?
• How to use multiselect in GetOpenFilename
• How to use the Validation... function from VBA?
• How to use VBA to add a menu to the worksheet menu bar?
• How to use VBA to display a Pivot Item- Aladin?
• How to view content of a cell containing a very long string?
• How to write to the Status Bar in Excel97-VBA
• HTML
• Hyperlink
• Hyperlink Base value
• Hyperlink Macro Help!!
• Hyperlinking, Lookup, VBA.........Sort of
• Hyperlinks
• I am sure this has been asked but I have basic UserForms question
• I am trying to format text one column into diffrent rows & columns
• I can find the Last Row -- How about the last column??
• I can't make the damned macro starts on I change cell A1 on Sheet "Calendar" please help
• I can't seem to get this VBA to work...:(
• I got lost in the shuffle.
• I have a macro to hide rows depending on value but it won't loop through each row????
• I have written a simple VBA timesheet program in Xl2000 but I need to use it on some office 97 machine.......
• i know i must be repeating the question - but for some reason i can't find the answer
• I lose my page breaks when I write a Macro to print a report
• I need a macro to do the "advances filter" function, how can I do ?
• I Need a Method of Saving a Filename with the Current Date embedded into it and then saving the file elsewhere...
• I NEED ANOTHER GURU AGAIN FOR THIS ONE!! MACROS!
• I need code that loops to see if...Please Help
• I NEED HELP ON MODIFING A MACRO FOR FIND/REPLACE.
• I need help with a macro
• I need ideas on a macro.....
• I need some help with copying and pasting through VBA
• I need to convert a string into an array of number in Excel 97
• I need to open the first file in a directory.
• I need to trigger an event macro, but can't work out how
• I purposely deleted my Macros but Excel still thinks I have them.
• I should know this one..........
• I should know this, but... How to run macro when cell is activated
• I still cant get any sleep Jerid
• I still need help please!!!!
• I STILL NEED HELP!!! -(simple macro in excel prob)
• I wanna import data from a text file....
• I want my form to be visible, but allow access to sheet
• I want to share this info with everyone!!! It could be useful
• I want to split a data dump into multiple files.......
• I was wondering if there is a way to write a macro that will insert a page break everywhere it finds a certain word...
• Icon for putting DATE into cell
• Identify Invalid Dates
• Identify Missing Records
• Identify multiple selected cells
• Identify Textcolor
• identifying last entry in a column
• If "File is open" then...
• If (big or small)
• If cell H21 >$1000.00, blink text??
• If column V="0" , delete the entire row????
• If Date = Expire then run macro
• if is a match, then subtract
• If loops including Cell numbers
• IF statement Problems
• If statement does not give desired results.
• if statement in macro
• If statements added to macros
• If statements within macros
• If the mouse clicks a cell
• IF THEN ...STUCK
• If Then in VB
• IF THEN LOOP WHICH ENDS WHEN A COLUMNS NEXT CELL IS BLANK
• if then statements, I think
• If workbook not found terminate macro
• If worksheet exists
• If, then macro deletes contents in another column
• I'm going cray with this paste proc - please help, i'm new to this
• I'm having a problem with VBA
• Im Stuck VBA UDF Formatting
• I'm stuck. Need help with a conditional statement.
• I'm sure this is obvious...
• Imported cell hell
• IMPORTING .TXT file
• Importing a CLS file into a macro.
• Importing a text file using VBA
• importing data on workbook_open
• importing data on workbook_open
• importing from a unix database
• Importing Specific Fields in Excel to Access
• Importing Text Files
• Importing text from another file into Excel list boxes
• importing text into excel
• Importing TXT file with Macro displays dialog, how to stop?
• Importing/copying filenames into an excel sheet?
• Impossible Request!
• In Macro, saving files as...when file already exists
• In VB - Find Command
• In vba go to a specific cell
• In VBA, I want to call the Click event of a control on another worksheet...
• include worksheet in macro
• Including path with file name
• Increased file size after running Excel macros.
• Increment the vaule (number) in a cell based upon a condition
• incrementing a range through a loop
• Incrementing the active cell between iterations
• Indexing a CD in Excel?
• Indexing an added sheet.
• INDIRECT ref. to another file ?
• individual subtotals
• Inhibit auto-calculate for *some* cells
• Initial setup when recording a macro.
• Initializing Add-Ins as Excel is Opening
• Input And File Save
• input box - colour
• Input Box for Cell References - Someone Must Know!!!
• INput box help
• Input box needs cancel macro
• Input Box to allow a user to choose a cell to delete
• Input Box Value Match
• Input Box with picture
• input boxes
• Input boxes in VBA
• Input data via user form.
• Input Number of Worksheets
• Input/Message/List box style that goes to sheet
• InputBox
• inputbox
• Inputbox
• Inputbox cancel
• inputbox concatenation
• Inputbox Error
• InputBox Macro, Maybe?
• InputBox pops up, but won't display text in worksheet
• Inputbox prompt before closing excel asking for ===>
• Inputing Data
• Inputting data from text boxes into different worksheets of a workbook.
• inputting sequential numbers
• Inputting text in subsequent columns
• Insert Row depending of value of cell?
• insert a blank row after every row
• Insert a line
• Insert a variable into SQL code within a macro
• Insert Blank Rows after change in text
• Insert data in special way
• Insert date when given value is true, then don't update.
• Insert Graphics in Cell by condition
• insert into next cell if occupied
• insert muliple line breaks fast
• Insert new worksheet from template in macro
• Insert Row
• insert row every fifth space
• insert row variation
• Insert rows & values.
• Insert rows by macros/Formulas
• insert rows when cell above equals cell below
• Insert SUM value on varying row
• Insert worksheet after last irrespective of name
• Insert worksheet column from a commonad button
• INSERTing (not copying!) a WORKSHEET
• Inserting a cell If....
• Inserting a cell value into a header
• Inserting a Link to a summary
• Inserting a new worksheet into a workbook...
• Inserting a PATH into the footer...
• Inserting a pop-up text box
• Inserting a pre-formatted row
• Inserting a row
• inserting a row
• inserting a row on sheet 2...
• inserting a row -with a twist? help
• Inserting a sound or beep when a cell increases by 1 digit.
• INSERTING BLANK ROWS
• Inserting blank rows
• INSERTING Calender Option into Cells
• Inserting cells based on values in that cell
• Inserting current time
• Inserting duolicate lines with a macro
• Inserting filenames into worksheets with a macro
• Inserting Formala in a Userform TextBox
• Inserting formuals around linked cell by macro
• Inserting HPagebreaks in excel thru. VB
• Inserting many sheets via macro causes premature memory problem
• Inserting Multiple Rows Between List
• inserting rows conditionally
• Inserting rows macro help
• Inserting rows w/formulas
• Inserting rows with a macro
• Inserting textbox contents into a spreadsheet
• inserting vbLf (line feed)
• INSERTING WORKSHEETS
• interactive macro
• Interesting problem?
• Interesting VBA Question
• INTERSECT function
• Interupt close
• Invalid Qualifier
• inventory help!!! I need to get some sleep...
• Invoice Macro - How can I load stock numbers & link to product description
• Is a custom sort possible
• Is a specific cell contained in the current range?
• Is a specific workbook open?
• is it possibke to run a macro when a cell in a range is cliked on
• is it possible copy a range of single cell to merged cell
• Is it possible for macro to pause for cell reference?
• Is it possible to concatenate a range of data??
• is it possible to find out which row a page break is on using code
• Is it possible to identify if column or row has been selected.
• is it possible to make reference to a xla file using vba ?
• is it possible to run a Macro from a Cell with formula, Ex. =IF($B21="","",MACRO)
• Is it possible to send just a worksheet, rather than the whole book, through a macro
• Is it possible to write a macro that emails a specific person a spreadsheet when run?
• Is it possible?
• Is possible to copy the code of a macro 1, open macro2, delete part of macro2 and paste macro1 code?
• Is the ActiveSheet locked or not?
• Is there a Dialog or simple Userform to allow a user to choose a directory (not a file!)?
• Is there a Dialog or simple userform to allow a user to choose a filename (not a directory!)?
• IS THERE A IF THEN RULE FOR THE FOLLOWING?.....
• Is there a limit on Formula length in a macro? Or is this a bug?
• Is there a Macro that will create a list?
• is there a message board as good as this one for word macros????
• IS THERE A Simple means of converting a PERL script into VBA?
• Is there a way of diplaying a message while an excel spreadsheet is opening?
• Is there a way of diplaying a message while an excel spreadsheet is opening?
• Is there a way of showing the date a cell was last changed?
• Is there a way to hide Excel menu bar?
• Is there a way to move a sheet tab to the end or begining of the sheets
• Is there a way to run time dependant macros?
• Is there a way to stop the "Enable Macros" dialog when opening Excel files?
• Is there another way other than Data Validation?
• is there any code that can make workbook perform self destruction..inside.
• is there any code that can make workbook perform self destruction..inside..
• is there any difference when naming variables?
• is there any macros that can prompt for passwords whenever......
• Is there any way to do a footnote in Excel 97?
• Is there any way...
• Is there anyway I can capture the previous activecell prior to the one im on?
• Is there code to pause a macro?
• Is there something obvious I'm missing here??! Please help.
• Is there something similar to NewSheet but
• is there way to lock view percent in excel97..
• Is this possible
• Is this possible
• is this possible....
• Is this such a difficult problem for Excel connoisseurs?
• Is workbook open?
• IsBlank in Macro
• Iteration answer from Bariloche - Question
• Iteration until one cell equals another
• Ivan about message http://www.mrexcel.com/wwwboard/messages/18095.html
• Ivan Moala re email from Macro
• Ivan or some1.plz help ...(repost )
• Ivan Paste in VBA
• Ivan VBA
• Ivan, can you please help me with this small problem!
• Ivan, more help with saving arrays please please please!!
• Ivan, please answer about formulas in headers with VBA
• Ivan: Thanks for all the help...Could you look at this?
• Jacob
• JACOB - About your answer to my question...
• Jacob are you still online?
• Jacob, another question
• JAF a question for you ! Import TXT in xls with macro: 50 column limit ?
• JERID - Quick question for you (or anyone else)!
• Juan Pablo
• Jumping like a frog
• keep sheets from showing
• Keeping automation XL files "invisible"
• Keeping function calc within its own sheet
• key board
• Kill All VBA
• Kill Macro Warning
• Kill Warning Message
• Label issues
• Labels and currency
• Large copying
• Last column
• last column used
• last date modified
• Last one for today. Macro for moving a file.
• last post went astray please assisted
• Last sheet select
• Last Update
• last updated date
• Launch External Executable Application by Macro
• launching (opening) .xlt as .xls...
• Launching a location-specific application
• launching an external application from excel
• learning macros please help
• Learning to write MACROS
• len user defined function
• LET A MACRO CHECK AND CREATE A DIRECTORY!!!
• Let macro perform an action on 'excel close'
• LET MESSAGE DISAPPEAR!!!
• Like to run macro once on sheet activation
• Like to run macro once, whoops forgot to send macro
• Limit the size of the spreadsheet
• Line break in a message box??
• Line feed in footer
• Line in Macro to set paper orientation
• Linking an Excel Workbook Tab name to a cell
• Linking cells
• Linking drop down boxes
• Linking formats
• linking images to cell address
• Linking input cells of macros to other pages of workbook.
• Linking list/combo box selections to macros
• Linking option buttons to cells
• Linking textbox data to a cell or column
• Linking to files
• Linking values and attributes between cells
• Linking Workbooks via Macros question
• Links in the file
• list box help please please please
• List Box in a Form
• List Box Macro problem
• List Box or Combo Box
• List Box using VBA
• List Files in a Folder
• List of worksheet names
• List Validation...
• listbox help
• listbox items in different colors
• Listbox Number Format
• Listbox or combobox on Form to run macros
• Listbox Problems - There might be something I'm Missing
• Listbox question
• Listing all files in a directory
• listing files
• listing files in a folder
• Listing sheet names on worksheet.
• Load a UserForm from a macro
• Loading a file into excel by macro
• Loading CSV files into Worksheets
• Locating last row of data in worksheet
• Locating Macros in an Excel Spreadsheet
• Lock a userform in place
• Locking a cell
• Locking an excel file to be use in certain computers
• Locking Cell Reference
• Locking Down
• Locking Excel Page Scroll
• Locking information in cells
• Locking window whilst running macro.
• Locking/Unlocking cells based on value in another cell
• Logging the use of a macro
• long macros (stop and start)
• Look at the name and give data out of another column!
• Looking for Refresh Pivot table Macro
• Looking for Today
• Looking information in list....... URGENT!!!!!
• Lookup
• lookup-type of macro
• Loop Help
• Loop If statment. Can this work? Please check.
• Loop problem
• Loop through range of cells
• Loop through range of cells
• loop through sheet 2 - sheet n
• Loop through sheet and protect
• Loop through sheet formatting columns while column C is true?
• Looping
• Looping a command in Visual Basic
• Looping a copy and paste macro from a dir. of files?!?!
• Looping Structure - "For-Each" statements
• Looping through a range(column) and checking to see it contains a "Y"
• Looping through rows of data
• Looping through rows of data (continued)
• Looping through selected cells
• Looping Through Sheets
• Looping to compare values in different worksheets?
• loops
• Loopy over a loop that works (please help)
• LOSING FORMULAS WHEN I INSERT
• lost input box code
• Lost messages
• LOST! macro works in xls, not in xla !? losing sanity...!!!
• Macor
• Macro
• macro
• Macro
• Macro
• Macro
• MACRO
• macro
• macro
• Macro - Auto select to last active cell
• Macro - breaks list of values into ranges
• Macro - Error Message
• Macro - performing simple calc. on ever-changing data
• Macro - Run Time Error '1004'
• Macro - Save as
• Macro & Conditional formatting error
• macro advanced filter / remove advanced filter
• Macro almost works, please help
• Macro around the Histogram function
• Macro array maximum?
• Macro assigned for an Icon problem
• macro assignment to custom toolbar button
• Macro Availability
• Macro based on Focus
• Macro button ...
• Macro Buttons-how to print out?
• Macro Challenge
• Macro changes formula in Excel
• macro code
• Macro code to display "Save as" dialog box in three locations
• Macro Conditions
• Macro Copy
• Macro Copy Cells
• Macro copying Buttons
• Macro copying colours? Can this be done?
• Macro Copying to a cell referenced by a string in a cell
• Macro crashes Excel unless Stepped Through
• macro creation
• MACRO DELETE
• Macro deleted by itself or another macro
• Macro deletes top line copied data
• Macro dialogue/message boxes answering
• Macro Directory Question
• Macro Disables Fixed Decimal Format
• Macro dosn't recognize the value in a cell?
• macro enable/disable button
• Macro Error
• Macro error message 'procedure is too large'
• Macro Execute Counter?
• Macro falls over at the end
• Macro fever
• Macro finishes before External data fetch completes
• Macro for "Save As"
• Macro for "Set Print Area".
• Macro for a button by code
• Macro for adding columns up to the blank field
• Macro for Adding Rows
• Macro for checking existance of a specific file on disk
• Macro for Comment
• Macro for coping a range of cells?
• Macro for deleting sheets
• Macro For Emailing Worksheets
• Macro for Excel
• Macro for Excel line formatting
• Macro for external data
• macro for finding & copying
• Macro for finding values < 1 and adding "Roundup" formula
• macro for form
• Macro for Hidding a Column??
• Macro for input of variables and calculations
• Macro for inserting a row for every change in a record
• MACRO FOR INSERTING ROWS AND PASTING VALUES
• macro for inserting text
• Macro for multiple files???
• macro for page setup
• Macro for Pivot Table
• Macro for Pivot Table
• macro for printing? problems
• Macro for refresh PivotTable not working
• Macro for reporting exceptions
• Macro for saving Documents
• Macro for Saving FIle as
• Macro for sorting sheets by a cell's value
• Macro for sorting worksheets
• Macro for sorting worksheets alphabetically by name
• Macro for summing certain numbers???
• Macro for transposing
• Macro for turning screenpicture upside-down??
• Macro for" moving selection after Enter" to another cell.
• Macro formatting
• Macro from Excel 97 not working in Excel 2000
• macro from excel to wordpad
• Macro go to last cell w/ data
• Macro Hell - Highlight Row Given Condition
• Macro help
• macro help
• Macro Help
• Macro Help
• macro help
• Macro help
• Macro help
• Macro help
• macro help
• Macro Help - Clearing Cell Contents
• Macro help from Barrie or anyone please! :)
• macro help needed for worksheet to worksheet copy/paste
• Macro help needed!!!!!!!
• macro help! 255 character limit
• Macro help, simple this time
• Macro Implementation
• Macro import of BIG text file
• Macro in current or personnal workbook?
• Macro in Excel
• macro in excel (VB) convert amt figures in words (spellnumbers)
• Macro in Excel to Create a Outlook Task
• Macro in Word
• Macro looping for each sheet in workbook
• Macro mania - needs to be progressive
• Macro mapping/location macro changing
• macro msg box
• Macro Multiplying Cells Depending on Data Validation
• Macro needed to select an "incomplete" range
• Macro offset, but need to anchor to newly pasted data
• Macro on Cell Change (Again)
• Macro or VBA to Hide rows if a blank cell
• Macro or what?
• Macro or?
• Macro posting Excel data to Access database...
• Macro Printer Select
• Macro Problem
• Macro problem
• Macro Problem
• Macro Problem
• Macro problem - won't go away
• Macro problem driving me crazy
• Macro problem for VB for Extra! emulator for IBM mainframe
• Macro problems, automatic bordering
• Macro Programing Help
• Macro Protection
• Macro protection (Re posting 12/6/01)
• Macro protection override?
• Macro Question
• Macro question
• Macro Question
• Macro question
• Macro question
• macro question
• Macro Question
• Macro Question
• Macro Question
• Macro question
• Macro question??
• Macro quit running!
• macro recorder
• MACRO RECORDER
• Macro Recording
• Macro recording, selecting rolls based on found data
• macro refuses to run on open
• Macro relative references button
• macro removal
• Macro Run Error Without Compiler Error
• macro run problems
• macro run problems
• macro run when cell contents change
• macro runned when certain cells are changed
• Macro runs when address entered?
• Macro runtime
• Macro selects current worksheet
• Macro selects current worksheet
• macro start
• Macro stops
• Macro stuff
• Macro SUMIF range increases by one if run from cell below
• macro that adds sheets and names them
• Macro that adds the number in on cell to another
• Macro that can take a value entered by a User and search for it w/in spreadsheet
• Macro that Convert...
• Macro that enter todays date into custom autofilter
• Macro that gets data out of the File Name
• Macro that inserts a date
• Macro that operates from Combo Box result
• Macro that selects from dropdown???
• Macro that uses DATEDIF
• Macro that will continue down the spreadsheet
• Macro that works 90% of the time
• Macro Timer
• Macro to "SaveAS" File to Same Name
• Macro to activate specific sheet through user input?
• Macro to add a cell using autofill
• Macro to Add Name Referring to Current Selection
• Macro to adjust template
• Macro to ask the user for data.
• Macro to attach spreadsheet to new email
• Macro to auto write complete path to footer of workbook
• Macro to automate 'find' function
• Macro to automate printing
• Macro to automatically move down 1 cell,run macro
• Macro to avoid all kind of formula error.....
• Macro to border cells, Shift Cells xldown, instead of Shift EntireRow xldown
• Macro to change a Macro
• Macro to Change British Pound Sign to $ Sign
• Macro to change colour of a row and move to next cell in Column
• Macro to clear values only
• macro to close file after saving ??
• Macro to close its own workbook?
• Macro to combine multiple spreadsheets into 1 workbook
• Macro to convert formulas to "IF(ISERROR)
• Macro to convert multiple cells from one currency to another
• Macro to convert range of Cells to Comments?
• Macro to copy a range that is constantly changing
• Macro to Copy from worksheet and paste to Word Document
• macro to copy values
• macro to copy workbook
• Macro to Create New Folder & Save File
• macro to create pivot table from worksheets of different sizes
• Macro to create variable folder names
• Macro to cut and paste
• Macro to cut from one spreadsheet and paste to another
• Macro to cut row from one worksheet/paste in another
• Macro to delete
• Macro to delete a file
• macro to delete a row or column
• Macro to Delete a Worksheet
• Macro to delete NAMES in a workbook...
• Macro to delete subtotal amount
• Macro to delete/insert text into formulas
• MACRO TO DISABLE ALL SHORT CUTS
• Macro to display Save As dialog box for designated directory
• macro to do a loop
• Macro to edit cell data
• Macro to edit formula
• Macro to E-mail a sheet
• macro to e-mail excel workbook using Lotus Notes
• Macro to erase all data and formating in a named range except background color.
• Macro to exit Excel
• Macro to extract data from multiple files?
• Macro to Find and Delete Rows
• Macro to find if certain number appears in formula text
• Macro to find missing numbers
• Macro to Find Names of All open workbooks
• Macro to find values of each cell referenced in a formula
• macro to force user to input data in a range
• Macro to force user to return to defined range
• Macro to force user to return to designated range?
• Macro to format - view & page setup
• Macro to format footer/header
• Macro to get a cell value and if true run another macro
• Macro to get Data from Access, create a Diagram and save as HTML.
• Macro to Get Out of Edit Mode
• macro to get sub-totals
• macro to go from D1 to A2, D2 to A3, ...and so on
• Macro to go to the top of the screen
• Macro to hide empty columns within a range
• Macro to Hide Excel Sheet + Macro to create a Default sheet
• Macro to Hide Rows
• Macro to hide rows
• Macro to hide rows based on column value
• Macro to hide rows based on value of 0
• Macro to hide rows READ ME please
• Macro to hide rows with no data
• Macro to Hide/unhide a row
• Macro to Import file daily
• macro to input data in a closed file
• Macro to insert link or formula in another sheet
• Macro to insert row, sort list and insert sheet with corresponding name, help?
• Macro to lock all worksheets
• Macro to make Border formatting stay with a cell after sorting
• Macro to move all sheets in book
• Macro to move cells to new column?
• Macro to move down a list until a new item is found?
• Macro to Open another workbook in the same dir!
• Macro to open as read only
• macro to open files
• Macro to open VB Editor
• Macro to paste only formulas instead of contents from one worksheet to another
• Macro to perform a formula function
• Macro to print
• Macro to print
• Macro to print selected pages - doesn't print last page
• Macro to protect/unprotect sheets w/ password
• Macro to pull stock quote via web query
• Macro to put date at the end of a row
• Macro to put zeroes in front of "text" numbers
• Macro to re-format Excel BOM output from PCB or Schematic Design Software
• Macro to rename sheet as a cell value
• Macro to resize a comment box
• macro to resolve copying/pasting dilemma
• Macro to retrieve and insert columns
• Macro to return rows with subtotals and ditch other data
• Macro to ride rows
• macro to run 1 time between sequences
• Macro to run every 15 minutes while file is open
• Macro to run if unhide sheet option selected
• Macro to run if unhide sheet option selected
• Macro to run under change/select condition in the same sheet
• Macro to save a diagram as html.
• Macro to save a file as file name from cell contents
• Macro to save current file from cells
• Macro to save file in different location
• macro to save file?
• Macro to save filename with password?
• Macro to save just one sheet.
• Macro to save to LAN using cell reference for file name.
• MACRO to save worksheets as seperate files ?
• Macro to seach all sheets
• macro to search for an variably input field...
• Macro to select certain cells & move data over 2 columns
• Macro to select file
• Macro to send email from excel
• Macro to send mail in Lotus Notes
• Macro to send to multiple email addresses
• Macro to set print area
• macro to shade cell
• Macro to Spread Costs Evenly
• Macro to switch between spreadsheets
• Macro to to copy from AS400 to Excel
• Macro to toggle toolbar
• Macro to totalize a number of values under condition of a data validation.
• Macro to unhide the nest row
• Macro to unhide the top row of many hidden rows
• Macro to unlock VBA Project?
• Macro to Unprotect and Protect Password Protected Sheet
• Macro to Use "Proper" function on column of all cap text
• Macro to VB
• Macro to VB
• Macro to VB
• Macro to zip documents
• Macro troubles
• macro tutorials?
• Macro use of Select (Replace) variant to extend a range
• Macro using Command Button Vs. Ctrl Key
• Macro using IF statement
• macro- variable-cell reference hell
• macro virus
• Macro Warning
• Macro warning error
• Macro warning message won't go away
• macro warning when opening a sheet
• Macro which enter zeros is slow; need help to speed it up
• Macro will not run
• Macro with Autosum
• macro with button...
• Macro with save as that does not change workbook name
• macro within a macro
• Macro won't go away
• macro won't pick up apostrophe used in name out of textbox
• Macro, auto run, create
• Macro, Function , or other option?
• macro, make a button for printing cells c3:g10?
• Macro/database capture
• Macro/Formula - Week commencing calculation
• Macro: Delete a range of rows based on changing variables
• Macro: Select cells A:K in the 'next row down'
• Macro:Move up 2 rows to 1st non-blank cell, add 1
• Macro??
• Macro???
• Macro1 runs Macro2
• Macroing AutoFilter
• Macroing problem
• Macros
• Macros
• Macros
• Macros
• Macros
• Macros
• macros
• Macros
• Macros
• Macros
• Macros
• Macros
• macros
• Macros
• Macro's
• Macro's
• Macro's
• Macros
• MACROS - AND ADDING A NEW LINE.....
• Macros & pivot tables
• macros and formulae
• macros and wizards
• Macros for making all worksheets visible and all but one invisible
• Macros in worksheet
• Macros interupted by excel events...
• Macros not working in Excel 2000 ?????
• macros not working on other computers.
• Macros not working when sheets being refrenced are hidden
• Macros on a protected sheet
• macro's on weekdays.
• Macro's Stopping
• Macros stopping on errors
• Macros that recognize if cells have moved?
• Macros to change background of a combobox
• Macros to protect/unprotect multiple worksheets
• Macros to set options on every sheet
• Macros to VB
• macros when none exist
• Macros/toolbar won't stay put
• Macros????
• Macros-editing worksheet without editing macro
• Major Formula Problem
• Major Housekeeping problem - Here's a real challange
• Make a column "xlVeryHidden"
• Make a macro a function
• Make bold & Insert blank space
• make cell active based on value - copy row it belonf to and paste to another row
• MAKE CELL LOCKED
• Make it better
• make Label name on UserForms take on cell value from worksheet
• Make macro run only if data in a particular cell
• Make the worksheet run in full screen mode on open
• Make Workbook Open At Table Of Contents?
• making a call from form code
• making a cell recalculate as data is entered in rows
• Making a copy of a sheet within an ADDIN
• Making a macro run automatically
• Making a macro that runs itself
• making area of graph semi-transparent?
• Making changes to a Excel xls file
• Making changes to a hidden worksheet
• Making macros work from shortcut keys
• Making Multiple cells Flash in Excel 97
• Making the first cell on row the ActiveCell
• Making unused cells unclickable
• Making VBA in Excel pause for Web Query response
• Making VBA userforms full screen???
• Mandatory fields - David Megnin and Me too
• Mandatory fields in user form.
• Mandatory input in cells -?
• Marco for borders
• Marco help
• Marco that will delete pictures,but not command buttons
• Marco to copy and paste special value
• Marco to delete rows
• Mark W. - Autonumber Question
• marro Save_As
• Mask a spreasheet
• Masking Password in input box
• Massive Macro - Very Complicated !!! - Help !!!
• match and Index in Vba
• Matching cells
• Max/Min Buttons missing & Window won't max
• Maximise/minimise button on userform
• Maximising Excel on Opening
• Maximize
• Maximizing Excel and the workbook in it
• May be a simple question - UserForm condition
• Maybe this quetion is to Dax and Ivan..how to make a cell flash and also how to make a picture do animation in excel.thanks
• Me command
• Menu Bars etc. setting.
• Merge and center across from VBA
• Merge Sheets Together
• Merge Worksheets????HELP
• Merge/DeMerge Prompt
• Merged Cells
• Merging a variety of workbooks/sheets together
• Merging rows....!!
• Merging to input boxes
• Merging worksheets
• Message box
• Message Box
• Message box for birthday
• Message Box HELP
• Message box instead of debbuger!!
• Message box that display what is in cells
• Message for Rick E or Juan Pablo or anyone mad enough to tackle the problem
• Message for Robb-Thank you, one more question.
• Message number found
• MessageBox
• Messagebox
• Messagebox Help
• MESSAGEBOX!!! HELP PLEASE!!!
• MessageBox???
• Method failed when I try to set the DefaultFilePath
• Minimizing Excel
• Minimizing Excel while using VBA...
• Minor Sort Problem
• mirroring cell contents on another sheet
• Mismatch Error
• Missed that line asking for a workaround :/
• Missing dialog to enable/disable macros???
• Missing Dialogs???
• missing library
• Missing VBA Reference
• modified Sort
• Modify Macro to run on opening of Workbook
• Modifying every item in a column
• Modules calling code in other modules
• More difficult questions, this time VBA Forms.
• More help needed on updating summary spreadsheet with data from files
• More help please dave
• more than 3 conditional formating
• more than 3 conditional formats
• More Than 3 Conditional Formats
• more than one column in a list box
• More than one line in a Message Box
• Mother do you think the print will work?
• Mouse
• Mouse control with VBA
• Mouse Pointer
• Move each sheet in workbook to new workbook
• move each sheet to an open workbook based on name
• Move Items Between List Boxes
• move Listbox item to specific area in worksheet
• Move rows
• Move Sheet to Another Workbook
• move text using vba
• move to
• Move up a cell in code
• moveing from Lotus 123 to Excel 2000 how do I...
• Moving (Selected) sheets to a new Workbook
• moving 1 cell down
• moving a macro
• Moving about macro
• MOVING AROUND IN A SPREADSHEET W/LOCKED CELLS
• Moving between files in VBA during a macro....
• Moving down a cell??
• Moving Macro Button
• Moving rows to a sheet
• Moving to a visible cell in a Range with hidden rows
• Moving workbooks in code to next workbook
• MSDos
• msgbox
• MsgBox - Change Default Button
• msgbox & inputbox
• msgbox exit from a loop
• MsgBox Question
• msgbox questions
• Mulit selections in a listbox - help me pleaseeee!!!!
• Multi Conditional Formats - Still Stuck (Dave Hawley)
• Multi Page Control -Setting Focus
• Multi Page Controls
• Multi-Column Sort (Using more than 3 Columns)
• Multidimensional Array
• MULTIPAGE - HOW DO I SET FOCUS TO TEXTBOX ON FIRST PAGE OF CONTROL
• Multipages
• Multiple .txt file
• Multiple charts Macro
• Multiple column problem
• multiple commandbuttons on a form....
• Multiple fill color buttons
• Multiple search with sum function
• Multiple SheetClearContents
• Must Save warning
• my excel file gettting bigger and bigger
• My macro sets old dates to 2002-more date issues
• My ugly as sin/ clumsy macro
• My VB Code doesn't work when workbook is protected/shared
• Mysterious Shrinking Column Widths
• Mystery Macros - How do you get rid of them??
• Mystery Macros part II
• Name
• name = Workbooks("remedyData.xls").Sheets("Sheet3").Range("b5").Value
• name a range which varies in size
• Name at top of excel window
• Name Excel Charts using VBA
• Name of open workbooks?
• Names
• Naming a List Fill range for a drop down box
• naming a new scenario with a macro
• Naming a range
• naming a relative range
• Naming a sheet by a date
• Naming a variable cell that changes daily
• Naming a workbook based on Cell Reference
• Naming cell regions dynamically from VB
• Naming individual data points on a graph
• Naming Modules
• Naming Ranges w/ a Macro
• naming workbook with text from two cells
• Naming worksheets as the date created
• nearest neighbor
• Need "Last Updated" entry for pricing
• Need a formula to reverse text
• Need a hand with a macro
• Need a little macro morsel
• Need a macro
• Need a macro
• Need a Macro to alphabetize Spreadsheet names
• need a macro to search all of the sheets in a workbook
• Need a Macro, or something...
• Need a popup "are you sure" query to run from a button to prevent accidental use
• Need Code attached to Command Button
• Need code to automatically open another workbook?
• Need code to ignore merged cells in a macro.
• Need Excel macro to run at startup...
• Need faster macro
• Need find \ replace macro?
• Need formula for bolding value if >0
• Need formula/code for "selection falls within set range"
• need function ' BLINK() '
• NEED HELP
• need help assigning one range to another range
• Need help coding a "FileName" "SaveAs" to a specific serving location
• Need help fast!!! Worksheet keeps closing!
• NEED HELP IN MODIFING MACRO FOR FIND AND REPLACE
• Need help matching up lists using Dave Hawley ‘s Macro
• Need Help Moving And Copying Data Creating An Archive Of Values
• Need help on a VBA project...PLEASE!!!
• Need help on add picture into Excel via VBA
• NEED HELP ON CREATING DELETE MACRO FOR TWO COLUMNS
• Need help on macro command
• Need Help Printing a Word Document from an Excel Macro...
• Need help to write a macro to do copy and paste in a number of worksheets
• Need Help w/ Charting Macro
• Need help w/VB code
• Need help with a couple simple VBA macros for Excel 97.
• Need Help With a Macro Using Excellink For Matlab
• Need help with a PivotTable Macro
• Need help with a VB function
• Need help with Access form and Stamping date/time/user id
• Need HELP with an auto-filter macro
• Need help with cyntax when using Range to define plot range
• Need help with macros
• Need help with Macros and VB
• need help with script comparing values of two different workbooks
• Need help with select case
• Need Help with something to do with macros
• Need help with starting macros! PLEASE HELP ASAP
• Need help with this code - baaadly!!!
• need help with this piece of code for a list box
• Need help with this project - Deadlines Suck!!
• Need help with userform textboxes please.
• Need help writing a macro
• Need help!
• Need Help!! - How to hide rows based upon specific criteria
• Need Macro for Adding Rows
• need macro to automatically search for cell contents after cell is changed
• Need Macro to unprotect worksheet, sort, then protect worksheet
• Need modification to code....
• need more help!
• NEED MORE INFO, DAVE OR IVAN!!!
• Need simple help with multiple ranges, array maybe?
• Need some serious help!!!!!!!!
• Need the REPLACE string function in Excel VBA!
• need to activate specific sheet upon opening file
• Need to add IF/THEN statement to Macro
• need to change a whole column by 10 %
• Need to compress some rows...is Auto Filter the best way?
• Need to copy the format of a cell only if that cell is filled color
• Need to filter a table by using formulas, not Sort or AutoFilter or VBA
• Need to know if I can delete repetitive cells
• Need to match items on two different lists, then copy and paste matches
• need to modify all selected cells at once
• Need to Protect/Hide Macro/Modules
• Need to remove characters that aren't letters or numbers
• Need to save 1 sheet out of workbook and VBA or macro to import it.
• Need to Stop Execution if INPUTBOX is Cancelled
• Need to turn off dialog boxes
• Need VBA code to create a list of macros in personal.xls
• Need VBA to convert "5757-" text to "$ (5,757)"
• Need VBA to rename a file on my directory-URGENT
• Needed ASAP-Lotus/Excel Macro
• needing to run macro on open BEFORE pompted to update links
• Needs some VBA advice from the gurus
• Neo, I need some additional help (Re: Macros on protected document)
• Nested For Each...I thought this would work
• nested For loops
• Nested VLOOKUP or MACRO?
• nesting loops in macros
• Network browse Box
• Networkdays and Workdays aren't enough
• new line in VB
• New to Excel
• new to macros
• Newbie Help
• newbie question
• Newbie report questions
• No duplicate cells in a column
• No Home on the Range
• Non Case Sensitive
• NOT ALLOWING A WORKBOOK TO CLOSE
• Not looping copy & paste, find each X, paste to new sheet?
• not such a toughie...
• Notify when opened
• novice macro user
• Nth Select
• Null-Type command
• Num Lock key
• number 2
• Number keys on a userform
• Number of functions in a worksheets
• Number of pages in print
• Number of Sheets
• Number of worksheet added that day.
• Number validation
• Numbering a worksheet
• numbering increase by 1 automatically
• numbering invoices
• Object required error (Excel VBA)
• ODBC & VBA
• ODBC with variable
• Offset in VBA
• Oh-My, now this is a problem
• Ok, heres one for you guys.
• Okay kids, this will probably be simple
• Okay, So here is my question...
• Old Lotus Macro Guy Problem
• Old Macros have an evidently simple problem
• Old question.. can you sort by colour ?
• OLE to Excel
• On cell change - run macro
• On Cell Click Run Macro
• on Error Goto
• On error... errors
• OnAction help needed...
• one click macro in menu bar.
• One Excel spreadsheet accessing another using VBA
• One for u VBA / Macro guys - Making an auto filter on two cells values - via a button
• One macro calling another
• one shortcut key to produce two colors
• One step workbook consolidation and calculation?
• OnEntry property
• Onevent action when data entered in colum A
• OnKey - Key values
• Only counts first two items?
• ONtime with addin disaster. please help
• Open a textfile in vba
• Open a workbook but not activating or selecting it
• Open a worksheet to a specific work sheet
• Open Acrobat from Excel 95
• Open an EXCEL file for FILEOUTPUT? Can it be done?
• Open book on certain sheet and cell
• Open Dialog Box
• open every file one at a time
• Open Excel from VB without running excel Macros
• Open Excel then Run Macro and Close on Schedule
• Open Excel Workbook
• Open Explorer with VBA Excel to get the directory of a file
• open file
• Open File --- macro stops
• Open File box in VB
• Open file to specific sheet
• open files
• Open helpfiles (.hlp) using VB?
• Open internet explorer and go to webpage
• Open multiple text files
• Open PDF file
• open sheet in same excel workbook
• Open specific word document using excel macro
• Open with 2 windows visible
• open workbook always on the same sheet..please help me...
• Open workbook macro
• open workbooks
• Open/Close Excel using VBA
• Opening / executing / utilizing non-Microsoft programs from VBA ?
• Opening 2 copies of Excel (again)
• opening a large file
• Opening a password protected Excel sheet using VB code
• opening a powerpoint presentation inside excel.
• Opening a Spreadsheet with VBA
• Opening a word file from an Excel macro
• Opening a workbook from within another workbook
• opening a workbook with a macro without starting up the macro's of the new workbook
• Opening all text files and saving as .xls
• opening an existing Excel file in Visual Basic
• Opening an MS Word doc from Excel file.
• Opening and saving a file from a macro
• Opening CSV files (or Excel files) via a Macro
• opening current worksheet in macro
• Opening Excel Workbook at first worksheet.
• Opening Files
• Opening Multiple Comma separated files
• Opening multiple files
• Opening multiple files from folder
• Opening Multiple text files
• Opening multiple workbooks
• opening password protected workbook with viusal basic
• Opening two workbooks at the same time
• Opening Workbooks with macros programmatically.
• Option button / txtbox - Visible/enabled
• option button group name ( can some tell me if this is posible)
• option button loop
• Option Explicit
• Out of Memory
• out of memory running a macro...
• Outlook
• Outlook and VBA Excel
• Outlook message from Excel
• output cell range to text file
• Output in VBA Forms
• Output Retention Question!
• page break in VBA
• Page Breaks
• Page Format
• Page Formatting
• Page numbers on multiple copies of 1 page
• Pagebreak/Cell Problem
• Parameters to open a specifice worksheet within a workbook from a command line.
• parsing the value of the Target variable...
• Pass a parameter to .OnAction macro
• Passing Parameters
• Passing a value to a range
• passing a variable to a macro
• Passing Combobox as a parameter to a function
• Passing ranges to VB routines
• passing values in an array to corresponding tabs
• Password for a group of cells
• password help
• Password Macro
• Password Problem
• Password Problem
• password protect macros
• Password protect my macro
• Password protect my macro
• Password protect single worksheet
• password protect vb code
• Password Protect VBA Code
• Password protect viewing of single worksheet
• password protected VBA module in excel
• PassWord Protected Worksheet for End User
• Password to disable a userform for being run
• Password to run a Macro?
• Password??
• PasswordChar help
• Passwords
• Passwords For Dave Hawley
• Passwords in macros
• Passwords in Macros
• passwords on multiple sheets
• passwords!!!
• paste into Save As... box
• Paste special macro
• Paste upon command
• Paste value only
• paste values as numbers not text
• Pasteing
• PasteSpecial
• pastespecial
• PAsting a selection, but only if complete row is empty
• Pasting to merged cells
• Paswords...VB...and input boxes
• Path and file name in header
• path in headers ie (c:\my documents\filename.xls
• Path of File
• Path to Windows Desktop
• Pathname in footer
• Pause a Macro
• Pause a macro to get a User Defined Range.
• Pause between SendKeys
• Pause for entry
• pause macro when variable = some value?
• Pausing a macro
• pausing an Excel macro
• Pausing in a Macro
• Pausing macro
• PC deterioraton with macro with big sorts
• Performing a sub only if cells A100-Z100 are all filled in: how then?
• Perminations question
• Permutations
• Pick From List in VBA
• Picture in VB (again)
• Pivot cache range/Source data.. Pls help me out.
• Pivot table and graphing problems????
• Pivot Table and sheet Protection problem
• Pivot Table in a Macro version 2000
• Pivot Table in Macro
• Pivot Table Macros in VBA Won't Work.
• pivot tables in Excel/macros
• Pivot Tables in VBA
• Place contents of list box into active cell.
• Place Value From Input Box to Cells
• Play music when your worbook opens
• playing a wavefile via VBA
• Please Advise "Worksheet_Change"
• Please fix this easy code for me...
• Please Help
• Please Help - How can I assign an Image to a custom Toolbar
• Please Help !!! How do you make a cell change the background color when clicked on
• Please Help !!!! - STATUS BAR
• Please Help 3rd Post
• Please help me learn a little more VBA for custom function
• Please help me on converting a figure in digits to a figure in words.
• Please HELP Save my Marriage!!!
• Please help with hyperlink "problem".
• Please help with macro -
• Please help with Macro delaring variables
• PLEASE help with VB macro fix????
• Please help with Worksheet Name=A1
• Please help with xldown
• Please help! Excel data logging question
• please help!!
• Please help...This is turning into a nightmare
• Please I need help to make this macro smarter-Offset problem
• Please need help with last row with data
• Please Please Please Help Me
• Please please please help me to count how many cells in a range have the SUM function
• please point me in ttthe right direction
• please read me with this annoying macro...
• PLEASE TAKE A LOOK AT THIS CODE- MY BOSS IS AFTER MY HEAD FOR THIS FORM
• Please wait screen when macro is running
• Please, help me now with this
• please. i need macro to find blank cell and delete it
• PLEASE..URGENT..Shared Workbook DisEnabled Macros
• Pop up box to add qty. to cell ? ? ?
• Pop UP user form
• Populate list box from a range in Add-In Sheet
• Populating an Array
• Populating an excel cell with the current date and time on a value change in another cell
• Populating UserForm.Listbox
• Pop-up calander within a cell
• Possible to bypass event if called by specific macro?
• Posting Current Days Date in VBA Text Box
• Preceed with zero and Concatenate
• Pre-format to eliminate lines with zero values
• Preserving PageBreaks - I believe that Ivan did this once.
• Pressing Esc Terminates the Macro
• Prevent "Do you want to Save" when Read Only
• Prevent automatic updating of links to external workbooks
• Prevent bypass of WorkbookOpen code?
• Prevent Cell Selection/Copy
• Prevent duplicate entry
• Prevent file OVERWRITE warning while using VBA
• Prevent Microsoft Excel information Balloon on VB sheet delete?
• prevent people from use save as function in my workbook....please help me
• Prevent Users from Unfreezing Panes
• Prevent worksheet deletion
• Preventing Duplicate records from being entered into a spreadsheet
• Preventing E-mail messages with blank "To" line
• Preventing user from closing Window
• Previous Worksheet
• Price listing
• Prime numbers
• Prime Numbers
• Prime numbers
• Print # Statement & Boolean data
• print area
• Print Area property not working
• print button
• PRINT BY USING A MACRO
• Print Code
• Print Comments -and- No/ Comments Macro's
• Print Macro
• Print Macro
• Print Macro for Range Names
• Print macro runs slowly
• Print of userform on another printer
• Print to File Macro
• Print user form
• Printing a report
• Printing a UserForm
• Printing A1 to last non blank cell in F (but may contain formula)
• Printing date values in footers
• Printing every other page
• printing excel from the web?
• Printing Formula
• Printing from another app - networkdays won't calculate?
• Printing in a loop
• Printing List of Names of Excel Files in My Briefcase
• Printing macro code
• Printing Several Ranges with one Macro
• Printing Sheets Macro
• printing to an excel cell
• printing with macro
• Printing/viewing restrictions
• PrintOut
• Printpreview help
• printpreview is messing up my Sub Workbook_BeforePrint(Cancel As Boolean) macro
• Private Sub Workbook_Open
• Private Sub Workbook_SheetChange
• Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
• Private Subs
• PROBLEM CLOSING A USER FORM
• Problem importing a file. File not completly loaded.
• Problem in my macro....help please!
• Problem linking contiguous cells to noncontiguous cells.
• Problem moving several columns of data to the right by one column
• Problem of Auto Select for Printer By VBA
• Problem opening file from a macro
• Problem passing a string array
• problem redim an array
• Problem using a For loop with Step to read to the end of file
• problem w/ code
• Problem When Scrolling Area
• Problem with a macro
• Problem with a variable
• Problem with cells format
• Problem with date formatting
• Problem with Event Coding for user Forms in VBA
• Problem with Excel Macro using WINWORD.exe
• Problem with Hiding Worksheets
• Problem with Interior.ColorIndex
• problem with macro for creating new sheets
• problem with macro running ms query - external data ranges
• Problem with multiple XLS files ..........
• Problem with object variable in vba
• problem with sheets
• Problem with sorting data on a protected sheet..inside..
• Problem with userform as a menu
• Problem: Flashing Screen.
• Problems entering a negative macro on invoice template
• Problems with autosort while userform is visible.
• Problems with find
• processing ranges in a macro
• Programatically copy a row to the next blank row of a worksheet
• programatically copying worksheet from one workbook to another
• Programmatically add borders
• Programmatically deleting sheets
• Programming
• Programming Array Formulas using VBA
• progress barr
• Progress Display
• Progress Indicator
• progressbar on a userform
• Progression Indicator Bar (Barrie Davidson)
• Prompt for filename MACRO
• Properties: Attributes "Read only" vs."Archive"
• Protect - Work Sheet / Book
• Protect and unprotect worksheet using macros/VBA
• Protect certain cells if sheet not protected
• Protect different sheets with different passwords...
• Protect Sheet Macro
• protect VBA code from inside code
• Protect w/ passwords in Macro
• Protect w/ passwords in Macro
• protect worksheet vs. application.Goto Reference
• protect/ password issue
• Protect/Unprotect a group of worksheets
• Protected Cell Message
• Protected sheet
• Protected spreadsheets
• Protecting & Unprotecting worksheet
• protecting a cell
• Protecting an Excel Document using a Macro
• Protecting and Sorting Cells
• Protecting and Unprotecting All Workbook Sheets
• protecting and unprotecting using a macro
• protecting cells
• protecting cells
• Protecting cells
• Protecting Cells In Shared Spreadsheets
• Protecting cells in VBA
• Protecting cells with data validation
• Protecting Multiple Sheets with a Macro
• Protecting My Macros
• protecting or hiding excel macros
• Protecting VBA code!!!
• Protecting Worksheet/Workbook
• Protection
• Protection
• protection
• protection against user update
• ProtectSharing Method
• PS : Celia please read inside...
• public variables lose value after userform
• Pull values from many Excel files
• Pulling up the standard "File Open" dialog box
• Pusing a macro
• putting a different formula in column F depending on the number in column C
• Putting zeroes in blank cells in a macro
• Query Macro will Not Return a Query
• Question
• Question about Dim statement
• Question about macros
• QUESTION Return to my last workbsheet - FOR PEOPLE WHO REALLY KNOW EXCEL
• Quick Question
• Quick Question: How to close a file in VBA...
• Quick workspace question...
• Quit Method
• Quiting Excel97 from a worksheet macro
• R1C1 Cell References in Macros
• r1c1 referencing in macros
• random database text picks, no or only one duplicate
• random highlighting
• Range & variable problem
• Range class error?
• Range class error?
• Range Error
• Range in a Macro
• Range name - how did this get in there
• Range name for source data in charts
• Range NAme Macro
• Range Names
• range names
• Range Naming Macro, Please Help
• Range Objects in Vba
• range problems
• Range Referencing Problem
• Range Selection
• Range Selection
• Range/ Rows question
• RE: I can write a macro to hide columns, but
• Re: AutoMacro to change cell formats on printing
• Re: Capitalization
• RE: Change Event in UserForms
• Re: CONCLUSION: No one knows about EVENT CLASS proccedures
• RE: Need a simple macro to SaveAs
• Re: PassWord Cracker Add in?
• Re: Run Macro on cell change - problem with Tip006 on Mr Excel
• Re: Using all my resources!
• re:how to delete macros&worksheet automatically before saving
• re:resetting form after printing, macro needed-thank alladin for the prev answer
• Real Challenge
• Re-arrange a date using VB Macro
• re-calc option
• Recognizing blank cells in Excel
• Record current time
• Recording a Macro
• Recording Macros in Absolute vs Relative mode
• Recording of macros
• Recording Time as tooltip
• REDS WORTH ZERO
• refedit control in vba
• Reference / Range hidden...Must find...Must Kill!
• Reference Excel cell in Page Header
• Reference linking to several worksheets automatically
• reference worksheet names
• referencing a cell of an Access table with VB
• Referencing a closed workbook
• Referencing a unique identifer from another worksheet.
• referencing in the R[ ]C[ ] format
• referencing to a variable sized row
• refering to file location
• Refresh external data through macro in office 97
• Refreshing a form?
• Regarding password protection in Excel
• Relative Addressing---Need a Simple Solution
• Relative moving the active row in a macro
• Relative Reference
• Relative reference to a worksheet...
• Relatively Simple Array question providing me big headache
• Remove blank rows and text
• Remove code from file after running
• Remove macro from file received from client
• Remove spaces
• Remove spaces at the end of a cell
• Remove specified characters from a text string
• Remove the negative sign
• remove unwanted macros
• removing automatic page breaks with VBA code
• Removing blank rows
• Removing blank rows via VBA
• removing characters from a string variable...
• removing delimiters
• Removing duplicate entries within a column
• Removing duplicate entries within a column
• Removing Excel promits from a macro
• Removing Macro from Saved file
• removing macros
• removing macros
• Removing macros and protecting the worksheet once saved (or placed on an intranet).
• Removing macros once saved
• removing macros when finished
• Removing Rows from Spreadsheet
• Removing spaces at the start of a cell
• Rename excel workbook sheet in macro
• Rename Sheets
• rename worksheet in vba
• Renaming a module
• Renaming a sheet based on a cell value in that sheet!
• Renaming a worksheet
• renaming files using excel
• renaming files with macros
• Renaming Sheets
• Renaming Worksheets to Original Name
• Reordering a List
• Repeat macro automatically each 10 min
• Repeating Macros
• Repeating Rows and Columns
• Repeating same number in a column
• Replace commands in excel
• Replace formulas with values on each sheet in workbook
• replace information in one column only
• Replace Macro HELP!!!!!!!!
• Replace Range with variable
• replacing multiple strings
• Replacing Numeric Values With Text
• Report Manager
• REPOST: Easy question...visual basic cell offsetting from cell entry
• Repost: Custom Color VBA
• REPOST: NEED VB CODE TO AUTO END AND AUTO ENABLE MACRO.!!!
• Request for input
• REQUIRED DATA IN CERTAIN CELLS
• required field entry
• Requiring Password to Save File
• reset extent of page/scroll bars
• Resolution changer.
• Restricted Saving of workbook
• Restricting ability to add or delete columns and rows
• Restricting cell input
• Restricting operator to specific input cells
• Resubmitted my cell evaluation question from earlier, forgot the macro or formula
• Retaining values on multiple VBA forms.
• Retrieve data from an Access database
• retrieving data from adjacent columns
• retrieving the contents of a cell using visual basic macro
• Return a cell address used by a ComboBox
• Return File info from a directory
• Return interior fill color
• Return of cell loaction - row and column
• Return RELATIVE Cell Reference
• Return smallest values
• Return the worksheets name
• Return to first worksheet
• Return to original active sheet at end of macro
• Return to original sheet/activecell after looping thro' worksheets
• Return to Original Workbook
• Returning a fraction w/correct format?
• returning a range obj from function
• Returning a value if a check box is click to return a value from another worksheet
• Returning an array from a VBA function to Excel spreadsheet
• returning contents of cells
• Returning Data to sheet using a UserForm
• returning focus to Excel
• Returning to Main Tab
• Returning User Logon ID in a Cell
• Returning values instead of function in Transpose Macro
• Revolving interest
• Rewritting of macro
• Right-Click events
• Robb - Reposting my question.
• Robb- Almost working
• Robb or anyone
• Robb or anyone
• Robb or anyone :) Macro Question
• Robb or anyone, again :)
• Robb or anyone, macro button question
• Robb????
• rolling date
• Roman numerals
• Rotate column headings to row headings; visa versa
• Rotation number on a form
• Rounding Formula or Macro
• Rounding Function using current cell value as number
• Rounding problem regarding significant figures.
• Rounding using VBA
• Routines do not display when list macros
• Row copy question
• Rows(a:b).Select - Variables
• RowSource Property
• run a macro in all excel file in a folder
• Run a Macro automatically when opening a file
• Run a Macro automatically when opening a file
• Run a Macro from a cell value becoming "1"
• Run a macro from a hyperlink
• run a macro from workbook
• Run a macro on close/exit of a spreadsheet.
• Run a macro when a workbook is opened
• Run a macro when cell is changed
• Run a macro when document is closed! Help!!
• Run a macro with a variable
• Run a macro without seeing the sheets swapping?
• run a user form from a macro.
• run batch file from macro
• Run macro
• Run macro AFTER worksheet has printed
• Run Macro based on value in a cell
• Run Macro Confirmation
• run macro dependent on value in cell a1
• Run Macro From Start Excel
• Run macro if specific cell changes
• Run macro in another workbook?
• Run macro just once
• Run Macro on computer time
• Run Macro on Opening of Workbook
• Run macro on opening workbook
• run macro question
• Run Macro to filter data based on Data Validation
• Run macro when ANY cell in Column A is changed
• Run macro when any of the cells in range...
• Run Macro when opening another sheet
• Run macro when SPECIFIC cell is changed
• Run on close
• Run Time Error, help!
• Run Word Macro from excel, HELP!
• Runaway Macro!!!
• Running a macro
• Running a Macro automatically upon opening workbook
• Running a Macro from a formula
• Running a macro from an IF statement
• Running a macro from validation box
• Running a Macro if specific text is entered?
• Running a macro in one worksheet on another.
• Running a macro on all open worksheets.
• Running a macro on excel open...
• running a macro when a wrbk opens
• Running a macro when the active excel window changes to another application window
• running a macro with only showing a progressbar
• Running a stored procedure in a macro
• Running a VB module on new spreadsheets
• Running code on multiple sheets
• Running into problems
• Running MAcro at a set time
• Running macro from IF function
• Running macro in another project
• Running macro on computer time
• Running Macro using a formula
• Running Macros
• Running Macros at timed intervals
• Running macros off IF statements when a cell changes????
• Running macros on protected worksheets
• Running Macros that refer to hidden worksheets
• Running macros when opening an excel file
• Running Total - Bariloche
• Running Totals
• Run-Time Error 1004 - Excel 97
• Runtime Error 1004, out of range with simple addshape macro
• Ryan - Application Level Event?
• Ryan you may be able to help.
• RYAN.. here is my example.. i need to add a line to delete rows containing 25
• Same action on all but one worksheets
• Same Header/Footer on multiple sheets
• Same Key Stroke without cell reference
• Same userform for multiple sheet entries?
• Save a file as a cell reference
• Save and exit Excell after a certain amount of time.
• Save As
• Save As
• Save As & email via Outlook with VBA???
• Save As and Replace
• Save As Button
• save as cell reference
• save as dailog box
• Save as dialogue box
• Save As Filename (Macro)
• Save as message boxes
• save as PRN
• Save As problems
• Save As Prompt
• Save As...
• Save As: Today's Date
• save changes on exit
• Save Changes Window
• Save changes?
• Save Date in Footer
• Save directory
• save file as unix text file using VBA
• Save file name = contents of a cell
• Save individual sheets from workbook.
• Save Macro?
• SAVE MACRO??
• Save one sheet?
• Save Operation
• Save selected cells to text file?
• SAVE TO EMPTY CELL
• save workbook as cell contents and as .htm
• save worksheets as text
• SaveAs
• SaveAs macro
• SaveAs MaCRO
• Saveas problem
• SaveAs Question
• Saving a file as two cell reference ???
• Saving a file using 2 cells as filename
• Saving a file using a variable as a name
• Saving a range of data as a new file
• Saving a workbook on opening .....
• Saving a workbook to website by macro
• Saving a worksheet
• Saving a Worksheet as a Text File?
• Saving an Excel macro as a .VBS file
• saving an excel worksheet
• Saving changes to workbook with password
• Saving copy without macro
• saving excel file
• Saving File With Month in Filename
• Saving macro
• Saving multiple Files with a User Form
• saving multiple worksheets as seperate formatted text(space delimited )files
• saving only the worksheet
• saving selecting columns to a txt file
• Saving spreadsheet with file name and current date
• Saving upon exiting
• saving xls as html
• Saving Zoom & Freeze Panes Settings on Multiple Worksheets Within a File
• Scenario Manager Question
• Screen size
• Screen Updates
• ScreenUpdating = False ???
• Script for Deleting Cols from a SS
• Scroll bar active area is too big
• Scroll bar code
• Scrollbars that control values in a Worksheet Change procedure
• Scrolling
• Scrolling ??
• Scrolling text in VB
• Search &, replace several values
• search and replace
• Search cell by cell
• search for something like.....
• Search for text within a column
• search multiple files
• Search two columns for an item count
• Search using a Userform
• search value in a worksheet
• search workbook
• Search workbooks containing same sheet name
• SEARCH() in a macro
• Search/Replace across multiple files
• searched posts, little help, can any1 help with what I have so far?
• searching
• Searching A Worksheet
• Searching for color in cells
• Searching for filenames or FOLDERnames containing keyword using...
• Searching for values and the adding other values
• searching multiple sheets
• Searching over multiple worksheets
• Searching through data by certain "headers"
• Searching through excel documents
• SEARCHING WITH EXCEL AND A MACRO
• Select 1st data cell after a filter
• Select a range of rows based on a column value
• select active cell
• Select All Test in Excel?
• select and delete cells based on current location
• select case not able to run module?
• Select cells for copy on the fly
• Select column & format
• Select column in a list
• Select from a common row between 2 columns
• Select method of Range class failed
• Select Network Printer from VBA
• select next empty cell
• Select Next Sheet and check if value in cell
• select range within macro
• Select Range??
• Select rows using variables
• Select sheet by name in cell
• Select the active cell's entire row
• select worksheets in a workbook without knowing the sheet name
• Select.End()
• Select/AutoFit Column
• selected cells in Listbox get selected on spreadsheet
• selecting & deleting all pictures in VBA
• selecting a cell by counting rows...
• Selecting a cell range in hidden worksheet
• Selecting a cell that is at the end of a range?
• Selecting a given number of columns using VBA
• selecting a range of data only
• Selecting all formulae with a given reference and pasting contents as values
• Selecting all sheets
• Selecting alternate rows
• Selecting cells in a formula based on the format of the cell
• Selecting Cells in A Macro
• Selecting cells in Macros
• Selecting cells protected by a macro.
• Selecting Chart Name with a macro
• Selecting colored cells
• Selecting entire row for special cells
• Selecting entire row or column
• selecting first available blank row in column
• Selecting Form Controls in Chart using VBA
• Selecting multiple offset ranges?!?
• Selecting multiple rows using two variables for the row numbers.
• Selecting non-blank cells but not formula in several columns via VBA
• Selecting non-blank cells in several columns via VBA
• selecting ranges in copy / paste macro
• selecting ranges in excel using VBA
• Selecting sheets - Intelligently
• Selecting the filenames only without giving the full path name
• Selecting the same range on multiple pages...
• Selecting Worksheets
• Selection by column max of 5
• selection test
• selection.replace is doing weird things
• self-adjusting column widths (and sheet, kindof)
• send an email message when a cells value is below 20
• Send e-mail with Excel
• send the current sheet as message body
• Send To Mail Recipient Office 2000
• Send workbooks over the net
• send xl file thru email
• SENDING AN .XLS FILE TO A ROUTING RECIPIENT MACRO
• Sending An E-Mail With Excel 97
• Sending email from a macro to a cc
• Sending Email from excel dependant on a calcuted cell
• Sending MACROS to Users
• Sending mail without the sheet
• Sending or copying EXCEL spreadhseets
• Sending Shift + right arrow
• sending totals to another sheet
• sendkeys
• Sendkeys - anyone know the how to tab back?
• SendKeys AutoSUM PLEASE HELP!!
• SendMail
• SendMail Command
• SendMail Issue
• Separator between Menu Items in VBA code
• sequencial numbering in excel
• Sequencing Numbers
• Sequential numbering
• serial port
• Set a print range with a macro
• Set print area using variable
• Set Range object problem in occurrence count?
• Set range using variables - with activecell
• Set Statements in VBA
• Set TextBox value to active range
• Set Warning Off
• Setting a "tab order" for my worksheet...
• Setting a variable macro range - tricky???
• Setting Column Widths of a ListBox
• Setting Focus
• Setting Header and footer
• setting header/footer defaults in print
• Setting Monitor Resolution
• setting optionbutton
• Setting Print Area based on a calculated value in a cell
• Setting print areas
• Setting Property's to nothing or null
• setting range in macro
• Setting the Max scale by variables?
• Setting todays date in Calendar control
• setting up userform combobox?
• Setting workbook properites
• Setting Worksheet Title = Filename = cell
• Shade Visible Rows
• share a macro with others
• Shared Workbook - enble user to see only their own sheet
• Shared Workbook adds a new sheet Each time it is opened
• Sharing a macro
• Sharing a Workbook
• Sharing and linking text data across multiple worksheets
• Sheet Code
• Sheet copy problem Excel 97
• sheet count help
• sheet is already open? can't run macro.
• Sheet name - macro
• sheet name as a variable
• Sheet Names
• sheet names in cells.. also macro names came...
• Sheet Protection and Pasting in Macros
• Sheet sorting question
• sheet tab names
• Sheet tabs A-Z
• Sheet Tabs with VBA
• SheetChange event
• SheetChange Event - Gary Bailey
• Sheetname
• Sheets Array
• sheetselection.
• Shift Cells at a time
• Shift key selection behavior in VBA code
• Shifting focus during error handling
• Shortcut for renaming worksheet
• Shortcut Key Does NOT Run Macro
• Shortcuts a tough / impossible one
• Should be simple
• Shouldn't be a tough Macro but I never made one before and I need some help
• Show & hide Sheets - depending on true/false message input.
• show a form or dialog during macro processing
• show a userform every 10 minutes
• Show a userform which is in another VBA Project
• Show filesize ?
• Show tab name in A2
• Show userform for certain workbooks
• show/hide calendar control
• Showing All Shapes
• Showing percentage progress pictorially
• Showing values as currency in a form
• Shrinking Columns
• Shut Down Excel using VB
• Shuting of the sheet with the macro
• similar to below but want to open a sheet with VBA
• Simple check in VBA for Excel
• Simple combo box problem
• simple copy for stupid beginner
• Simple editing macro - struggling
• Simple Excel Macro Solution - Offering a Trade
• Simple footer question
• simple keyboard macro
• Simple Macro
• Simple Macro
• simple macro command (shift-end-down_arrow)
• Simple Macro Conversion #2
• Simple macro help...
• Simple Macro movement
• Simple macro to AutoSum
• Simple purchase order system in excel
• Simple question with a twist
• Simple VBA question
• Simple Worksheet find question
• Simulate Control Shift Enter in VBA
• Single quote in cell e.g. '1001 or 'ABCD
• Size matters, or Brother can you spare a Mega-Bite
• skip dialog boxes when using save as in a macro
• SLOW calulation of cells
• Slow down the SendKeys command
• slow print macros
• Small Bug
• Small caps font
• snap to selection in vb
• So confused!!!
• Solution for Linked cell delete in macro
• Solver as a function?
• Some beginner questions about a macro I'm doing
• some questions..
• Something Missing
• Somewhat Frivolous Graphics Question
• SORRY: LEFT OUT MACRO Changing footer w/ macro
• sort 5-digit and 9-digit zips in same column
• Sort Button on Protected Worksheet
• SORT BY COLOR
• Sort by condition
• sort data
• Sort Macro - So sort is always the same
• Sort on a protected sheet?
• Sort Orders (advanced)
• Sort sheets alphabetically
• Sort text by color??
• Sorting
• Sorting
• sorting a protected document
• Sorting and subtotalling by interior fill color
• Sorting by Color
• Sorting by Font Stlye "Bold"
• Sorting Indirect Cells?
• Sorting Macro - HELP!
• Sorting Macro using a command button
• Sorting portion of protected worksheet
• Sorting Protected rows
• Sorting Spreadsheets
• sorting tabs
• sorting variables
• sound
• Sound
• sounds
• Specify Multiple Toolbar Icons
• Specify name of new workbook
• Specifying argument with OnAction in custom menu
• Specifying that a cell has no value Numerical/text ?
• Speed Is What I Need
• speeding up macro
• SpellCheck in VBA
• Spent Hours Looking for help on this Board, but...
• SpinBox -> TextBox Time
• Spinner
• Splash screen
• Splash Screen
• Splashscreen whilst iterating & calling a sub on break in code
• Spliting variables
• Splitting Data Across Worksheets
• Splitting Text Cells
• splitting up a string in characters
• Spread values over 12 columns
• SQL Queries in VBA
• sql.request and collecting data from a database
• Start a Macro at a given time
• Start up Macro in spreadsheet
• Start/Activate File In Other Application
• Starting a macro from a formula?
• Starting a macro from a userform command button
• Starting Outlook express with macro
• startup macro
• startup macros to remove toolbars plse hlp
• startup sheet
• Statistics function macro
• Step through and print rows of data one at a time
• Still a VBA newbie. Please help.
• Still adding rows..but different
• Still adding rows..but different situation..
• STILL CANT SEEM TO GET THIS TO WORK
• still having a prob w/ my code
• Still looking for an answer
• Still trying to get rid of macros
• stock control?
• stock market days list
• Stop a sub procedure that calls other procedures & funtions...VBA'ers
• Stop excel from checking for a Macro
• stop halting of a macro
• Stop normal pasting
• Stop printing
• Stop Recording Toolbar
• Stop the echo during macro operation
• Stop user to print out our file ==>
• Stop workbook_BeforeClose From Running
• Stop WorkbookOpen and WorkbookBeforeClose Macros
• Stopping "Do you want to save the changes you made to 'filensme' "
• Stopping a Macro to enter text
• Stopping a Macro without an end sub
• Storing values after input from a user form
• storing variable globally?
• Streamlining and improving VBA Code
• Stuck on Visual Basic
• stuff characters or use a template?
• Sub CommandButton_Click()
• Sub Workbook_Open??
• Subscript error after renaming worksheet
• Substitute a variable for a row number
• sub-total code.
• Subtotal Macro please!
• Subtotal problem; Asks for label row.
• subtotaling hours
• subtotals
• Subtotals - Labels
• Subtracting Times
• suggestion or comments needed
• suitable macro
• suite to multiconditional code
• Sum
• Sum Function and protected sheet
• Sum in Code VBA
• Sum Most Recent 13 Weeks
• Sum of textboxes into label (loop?).
• Sum this - possible/impossible?
• Sum user selections in different colums
• sumif function in VBA
• Sumif on cells color
• Summing adjacent cells and starting the sum over at zeros
• Summing by colour function
• Summing columns of variable length within Macro
• summing like records
• Suppress workbook_open macro
• Suppressing "Open Read Only" Question....
• Suppressing Dialog Boxes During A Macro Run
• suppressing message boxes
• Supress Pop Up Box
• Supress Pop Up Box
• Supressing Rows with zero values
• Suprressing Footer on first page in Excel 97
• Syntax for using variables in a range
• syntax for using vlookup in an Excel Macro
• System enter & lock today's date without user input or VBA
• Tab
• Tab Names and Wildcards
• Table of Contents for worksheets
• Taking a long time to open a workbook
• Taking data from 2 different sheets
• Temperamental Excel!
• Template Macro
• Template wizard with data tracking
• test for formatting in VBA
• Test for Hidden
• test for the existence of another excel file
• test if workbook is open?
• Test String manipulatiion
• testing cell text
• Testing for #NA in VB
• testing for current cell
• Testing for existance of cell dependents for if
• testing strings with ignore case
• Testing whether any one of five checkboxes are selected
• Text and Date in a macro
• Text Boxes
• text boxes behaving badly!
• Text Case
• text file format
• Text in excel.
• Text message by selecting cell
• Text to Buttons
• Text too long for Tabs
• Textbox number validation
• Text-to-columns problem
• Thanks Celia,have 2 other ?'s.
• thanks folks!... Can you help with this?
• Thanks, Jacob, but didn't work correctly. here is my complete code I'm using.
• The code to launch a macro upon opening
• The lunatics are on the cell
• The path of a file found in a subdirectory using Filesearch...
• The right code
• The sheet code to format a column to upper case
• The top right corner icon is transparent !!
• ther must be a better way!
• There must be a more elegant way
• There must be an easier way!!
• There's got to be a simple way to :
• This is a very tough question
• This is driving me crazy!
• This is for "faster". Thanks for your suggestion, however
• This is for a pro - Automatically Insert a Number of Rows Starting Down a Specified Row
• This is probably a pretty common question. Sorry!
• This is to Goneril, yes the macro starts in next available cell
• This is too easy to post here but I need help...
• This macro works, but this doesent. Any ideas please ?
• THIS ONE IS TRICKY : How to set focus and disabling multipages or tabs in VBA
• This one will stump ya *Thanks Ivan
• This really needs a clever person.
• This sould be a simple one...(i hope)
• Three hopefully easy questions
• three-way link between cell values
• Tidy up and sort data
• Tim F-W . . . Toolbar hiding ALMOST there
• Time Excel worksheet is open?
• Time Formulas
• Time Sheet Military Time
• time stamp
• Time stamping data
• time stamping entries
• Time VBA problem
• Timed Displaying
• timed macro
• Timed macro operation needs more accuracy
• Timer
• Timing Out a Workbook
• tiny bit of VBA code needed
• Tip of The Day Function Sought in Excel!
• Tip of the week from 08 Sept 2001
• To automatically launch a macro when a file is opened.
• To hide and unhide empty rows in between rows with data in them...
• To Juan Pablo
• to know end cell through macro
• to loop or not to loop? That is the question.
• To print a variable in a Dialogue Box?
• To Whom it May Concern
• To YANECKC regarding Find and Replace
• TODAY () question
• Today()
• Toggle cell values
• Togglebutton
• Tom - Help - Workbook keeps reopening
• Tom and Richard... On the Right Track (Excel Query)
• Tom- Macro Question
• Tom Urtis, inside -->
• Tom, or anyone ... managing live data
• Tom.......that pesky E-mail thingy
• Too hard basket (comparing text strings)
• Too Many Cell Formats
• too tricky?
• Toolbar references to macros
• Toolbars - Follow-up query for Tim Francis-Wright
• Total the value from unopened workboks in an open workbook
• totals row
• Trans cell data in function VBA i guess
• Transefeering info from several cells into one sheet.
• Transfer Values
• transfer/copy text in textbox and what is selected in combobox of a userform?
• Transfering to another sheet based on input
• transferring info
• Transferring Variables among Subs
• transposing multiple records (sort of)
• Trap on Null? Combo Box?
• Trapping keystroke so that nothing happens.
• Tricky Cell Selection
• Tricky Cut & Paste combo
• Tricky problem with buttons - any thoughts
• Trigger Macro when "Save As" selected?
• Triggering a macro using a DDE linked value
• Triggering Macro on Data Refresh
• Trim and Proper
• Trim text - probably very simple
• Trouble calling macro be variable name
• Trouble setting Default Directory
• Trouble with quotation marks in VBA
• Trouble with SaveAs Filename
• true 'last cell' in worksheet
• True/False macro
• Trun off Bold
• Trying to create code that stop's saving over a file based upon an event
• Trying to create toggle button to hide a column
• trying to get rid of read only confirmation message
• Trying to hide a dialogbox on ok_click before it continues on with the macro
• trying to make a SaveAs macro to make my life easier
• Trying to put a variable in the middle of a formula in code
• Trying to Save to A: Drive
• trying to write a loop
• Turn AutoSave on or off in Macro
• Turn off all Data Validation Input Messages
• Turn off Page Flashing In Macro
• Turning nubers into words
• Turning off and / or handling of warning message boxes.
• Turning off Help displays in VBA
• Two Easy Questions
• Two Line Message Box
• two list boxes : move item from box on left to box on right??
• two questions
• Two Questions multiple ranges and to add to a spreadsheet
• Two Questions....
• Type mismatch
• Type Mismatch
• UDF
• Ugly Macro
• Unable to change Directories in Macro
• Unable to record macro
• Undo disappeares when change is made through VBA
• Undo in VBA code
• Unhide all sheets
• Unhide all sheets at one time
• Unhide Multiple Worksheets
• Unhide Rows problem
• Unhiding Sheets
• Unhiding Sheets
• Union of several ranges
• Unique column
• unique invoice number
• Unique Number
• Unloading Every Userform In A Workbook
• Unlock locked VBA Project
• Unprotect a cell if IF Statement is true
• unprotect a worksheet
• unprotect in vba
• Unprotect Macro
• Unprotect VBA module
• Unprotect/Protect in VBA
• unprotect/reprotect sheet within macro
• Unprotecting a sheet through a macro
• Unprotecting worksheet through VB macro
• Update
• Update based on created date (user input)
• Update Links dialog box
• update of info
• Updatiing Link Macro -- Better at handling errors?
• Updating a count every time a value is changed
• Updating data on sheet keeping all historical data
• Updating duplicated sheets
• Updating external data when opening file with a macro
• Updating Macro References
• Updating my journal voucher log
• Updating Pivot Tables
• Updating summary spreadsheet with data from files
• Updating values when the system date changes
• Updating worksheet data
• Upper CaseText
• Uppercase and Size
• Uppercase?
• URGENT - How do I save a workbook and make a duplicate using a name from a cell in first workbook?
• URGENT HELP NEEDED!!! AUTOMATING PICKING OUT ROWS THAT HAVE SPECIFIC CELLS MATCHING A VALUE AND COPYING THEM INTO ANOTHER SHEET
• urgent help required with a menu bar
• Urgent Please help...
• Urgent Please...Problem while pasting of data..
• URGENT- REPLACE TEXT IN A TEXTBOX
• URGENT!! Need help with inserting rows in a protected sheet.
• URGENT!!!!!!: Macro to Insert Multiple Blank Rows
• Urgent......How do customize the 'Paste'operation...
• use a general macro for different files
• Use a Macro to append one cell onto another
• Use INDIRECT as part of a cell link formula
• Use macro to delete worksheet without getting confirm message?
• Use of xlDialogSaveCopyAs
• Use VBA to play a sound (.wav) file?
• Use VLookup in vba
• Use VLOOKUP or similar function in VBA
• UsedRange always giving me problems
• useing variables as cell refrences
• User Interupt Prevention
• User Confirmation
• User Define Functions not working from Personel.xls
• User defined function using a worksheetfunction
• User Form
• User Form
• User Form - Input mask
• user form entering data into correct cells
• User form validation
• User forms
• User I.D.
• user interface
• user level security in Excel file
• user name
• User name code problem...
• User Names
• User Specified Printer
• User-Defined Functions
• UserForm - TakesFocus - LosesFocus
• UserForm / Click vs Keyboard Enter key
• userform + spredsheet
• Userform Auto_open
• Userform leaves trail of images when moved
• Userform List Box not updating
• USERFORM PRINT BUTTON
• Userform textbox - only numbers
• Userform textbox %
• UserForm that views another sheet
• Userform updating
• Userform Windows (Keeping On Top)
• Userform with MultiPages
• userform.show "in dimmed state"
• Userform.show time frame?
• Userform??
• Userforms
• UserForms - "Zen" Maybe You Can Help
• UserForms don't completely hide.
• username
• Using 2 Data validations together
• using a defined name in a macro
• Using a drop down list to select a macro to run
• Using a Filename as a variable or reference
• Using a Loop to find Numbers in a List
• Using a macro button to add however many lines I choose
• Using a macro for creating a chart
• Using a macro to close Excel itself
• Using a macro to copy a dynamic range multiple times
• Using a macro to enter a password
• Using a macro to hide empty rows
• Using a macro to open another workbook and change page orientation.
• Using a named range to update if/or in VBA
• Using a range as criteria in Countif
• Using a Userform to modify a record
• using a variable for the label numbers
• Using a variable in a range().select statement??
• Using a variable in the Range().Select statement?
• Using active cell in a formula
• Using ActiveCell address as part of range
• Using ALL my resources!
• Using AUTO_OPEN MACRO on multiple sheets
• Using Autofilter when spreadsheet is protected
• Using Cell Contents to change Path
• Using Cell rather than Range
• Using combined cell values to refer to Workbooks
• Using Components of date in vba.
• Using DAO in VB to access a password proected Excel file
• Using Day from =now() statement
• Using Excel Macro to Browse through folders and delete selectively ?
• Using file properties in a macro
• Using Font Color in a Funtion Criteria
• using formulas to transfer cell formatting and comments
• Using Go To doesn't put the cell where I want it...
• Using macro to enter value in one cell from range of cells
• using marked range on spreadsheet in a macro
• Using open file dialog to get name and path of file?
• Using Range Information
• Using SaveAs to overwrite existing files
• Using sheet name in save as
• Using sheet names in worksheet cells
• Using text in one cell as part of formula to refer to another workbook
• Using the Carriage Return
• Using the Event Handler
• using the implied buttons in open and save dialogs
• Using the Solver with VBA/Macroon Excel
• Using the Standard "Open File" dialog box
• using the sum function with data that changes
• Using Variable Sheet Name in Series Name Definition
• Using variables (maybe?) to go through rows.
• using variables in visual basic range references
• Using variables to select a range
• Using VB to hide and unhide rows in Excel
• Using VB to send an Email. Need help with options...
• Using VBA to make a conditional format so the "0" are always white
• Using VBA to process Vlookups in multiple workbooks
• Using VBA to protect & unprotect cells
• Using VBA to search a range, and return a result
• Using VBA to select a range
• Using VBA to write VBA code (create multiple buttons)
• Using VLookup with VBA
• Validating text box entries in VBA
• validation macros
• Validation Message
• Validation of Data
• value of last row in column
• Variable Autofill
• Variable from File Name?
• Variable lifetime across macros
• Variable not found
• Variable Range
• Variable scope
• variable sub call
• Variable Variable??
• Variables in a macro using a Vlookup Worksheet Function ... Please help.
• Variables in a range
• varible filename?
• Varying Named Range
• VB macro to name a worksheet by the conntents of a cell
• VB - User Forms?
• VB "or" statement?
• VB Code For ComboBox's
• VB code for exception handeling
• VB code for solver
• VB code to open the open window
• VB Code to Select Active Cells and Format a Border?
• VB copying & pasting entire Excel worksheets
• VB Easy Question
• VB Emergency!!!!!!!!!!!
• VB for selected document
• VB Guys /Gals need to concatentating 2 variables
• VB loop
• Vb macro
• VB not VBA?
• VB rowcount
• VB script to autosort a range and output to diff range
• VB SCript to Delete Zero Rows
• vb selection problem
• VB Sumif
• VB Syntax for Bypassing Dialog Boxes and Formatting Cells
• VB to Excel communication
• VB to Select Last Row to Row 2
• VB....Paste Special
• vb.net impact on Excel VBA???
• VB/E.mail with outlook...Ivan (again)/Jerrid
• VB: Destroying running Excel instance (tough question ?)
• VBA
• VBA
• VBA - " double quote within the string variable
• VBA - cell reference
• VBA - file search
• VBA - For Next Statement
• VBA - modules -vs- sheet
• VBA - Passing Values by reference; Why doesnt it work??
• VBA - Return position of text string from within a cell
• VBA - Saving a file with a filename relative to the current date (sort of)....
• VBA - sum every other row
• VBA - Worksheet Functions...
• VBA "Find" method with use of "After"
• VBA "Out of Memory" message
• VBA and Excel 2000
• VBA and Search
• VBA beginner has a problem
• VBA book recommendations
• VBA bug? spreadsheet fails to open...HEEEELLPPPP!!!!
• VBA Bug??
• VBA code
• VBA code
• VBA Code
• VBA code
• VBA Code - where does it go?
• VBA Code for "SHift+End+Down Arrow"
• VBA code for array formula
• VBA Code for Arrow
• VBA code for Clipboard Save Yes/No ???
• VBA code for Conditional numeric formats
• VBA code for moving 1 line down
• vba code for opening a .prn file
• VBA Code on how to compare the same range in two different sheets and display the result in third sheet
• VBA Code that will find and list VBA functions and procedures.
• VBA code to export/import VBA Project Modules 97
• VBA code to have a user select the directory path to save files in
• VBA code to prevent Ssheet being saved as something else?
• VBA code to subtotal.
• VBA code to transfer data between sheets doesn't work?
• VBA Code will not affect multiple sheets
• VBA Confimation
• VBA E.mail
• VBA equivalent of ISNUMBER?
• VBA Excel
• VBA Excel Class
• VBA Excel MsgBox
• VBA Excel Range Problem
• VBA Excel Search and replace text....
• vba experts - "Private Sub Workbook_BeforePrint"
• VBA for actions on one cell value or formula
• VBA for Exce 97 -- "find" method
• VBA for grouping and outlining
• Vba For Next Loop
• VBA for open a different workbook.
• VBA for PhotoDraw
• VBA Function - Thanks, but why doens't this work...
• VBA function that works with array formulas
• VBA GUYS / GALS NEEDED
• VBA Guys needed - finding the last cell + 1
• VBA Help
• VBA help - highlight "total" rows.
• VBA HELP - sheetbeforerightclick event not responding?
• VBA Help - This should be an easy one :-)
• VBA help find + delete
• VBA help for inserting/naming worksheets
• VBA help, select the next cell down
• VBA- How to select the range of non-null cells
• VBA If statement............
• VBA input box
• VBA Issue
• VBA KeyPress
• VBA Language Reference
• VBA Move or Copy Worksheets
• VBA Overwrite Existing File
• VBA Pop-up
• VBA Project Locked
• VBA Project Protection Problems
• VBA Property: "Cancel" for a command button
• VBA Question
• VBA question - re Substitute
• VBA Range Names
• VBA Range Problem-Range("srt:fnsh").Select No Good
• VBA Range select problem
• VBA ranges - I want to add a RANGE -- Perhaps like DEFINE NAMES?
• VBA Reference books
• VBA Rounding
• VBA Script for Print Setup
• VBA script to FTP information?
• VBA Scroll Areas controls
• VBA Search And Replace
• VBA Select method (Easy Question of the Year)
• VBA Sheetname Problem Might be tough
• VBA Shortcuts for DIM
• VBA Sum rounding result??
• VBA syntax question
• VBA target as range
• VBA Tidying up help
• VBA time macro running for
• VBA to change current path setting for file open
• VBA to copy dialog sheet text box contents
• VBA to copy from one sheet to another
• VBA to count sheets
• VBA to create a Pivot Table
• vba to move right then shift end down
• VBA to return the date of the Friday after a given date
• VBA to run/ show an old-style dialog sheet not a VBA userform
• VBA to search a column for text matching a named range cell.
• VBA to Select all sheets in a workbook and unhide them
• VBA to Unhide Worksheet on a tool bar custom icon
• VBA to use Refresh (F9) command when a certain cell has a #VALUE! error
• VBA UserForm question
• VBA vs macro
• VBA without using "sendmail" and without sending file attachment
• VBA works alone, but not as part of a larger macro
• VBA......
• VBA...ThisWorkbook.SaveAs
• VBA: IF / ELSE
• VBA: Date/Time function reference
• VBA: determining current conditional format for a cell
• VBA: Formula to variable as string
• VBA: hide row if cell in row is blank
• VBA: hide row if cell in row is blank
• VBA: Is there a way to write a macro to delete rows that begin with certain characters?
• VBA: Problems w/ StrComp and If...Then
• VBA: Search column A for next cell that's empty, then put data.
• VBA: using dimesioned strings in call procedures
• VBA: Wait with calculation of array function?
• VBProject
• vbYesNoCancel
• Verify
• Verify Tool
• Very Basic Question
• VERY IMPORTANT - MACRO HELP
• Very simple VB programming
• Very Unhidden
• Viewing Hidden Cells
• Vis Basic code for choosing cells with Data
• Visible property in macro?
• Visible property of object
• Visual Basic - I'm stuck
• Visual basic active cell selection
• Visual Basic code for a message box when excel opens?
• VISUAL Basic i guess copy+paste
• Visual Basic Programming on Excel...??? HOW?
• Visual Basic Question
• visual basic SaveAs
• Visual Basic Text Box
• Visual Basic Text Box
• Visual Row Highlight
• V-Lookup and Macros
• Vlookup in a Macro ?
• V-LOOKUP in English Please
• Vlookup in Procedure...I'm begging you to help...
• VLOOKUP macro needs Offset
• Vlookup problem
• Vlookup Vba increment
• Vlookup, Find or VBA
• w/ VBA Code
• Wait for File but dont hangup system
• wait until cell calculations have finished
• Walter, if you're out there...
• want a macro to run on only one worksheet?
• Want to Get All Matches for List and Cocatenate
• Want to write a data cleansing macro
• Wav files in macros
• Web Query Refresh
• What "Compile Error" have I made?
• What am I doing wrong?
• what are the point of macros?
• What does 'Sheets("MySheet").Activate' do?
• What is the code to save over an existing file with no prompt
• What is the macro command to refresh data?
• What is the most efficient way of breaking a large data set up into categories on worksheets
• what is wrong with this line?
• What macro commands can be used to take a daily workbook file that has a new name each day, copy the worksheet (new name each day) and then rename the copy. There is only one worksheet in the new file each day when it is downloaded from our application.
• What value does "cancel" have in a msgbox??
• what's going wrong
• What's that screen update command?
• Whats the code to change the display text on a checkbox?
• When I use this code...
• Who can merge txt files
• Whos the real excel guru round here??????
• Why can't I sort these rows of data ascending???
• Why can't I sum up these cells???
• Why does this fail on other computers
• Why does this Macro chop off the first number in the cell? It works fine if it is a formula though...
• Why does this work ?
• Why macro is slow? (auto_open does some page setup)
• will someone please take another look at this
• Window Handles
• Window Name - Close
• Windows Username
• Windows with "File Locations"
• windows.namefile.activate
• With VBA: activate a worksheet from a file by calling it in a macro from another file
• Word to Excel Macro Help
• Word toExcel Macro Help?
• Workbook name function
• Workbook protect all sheets
• workbook tabs false
• Workbook you are opening contains Macros...
• Workbook_before close: actions do not take place.. why?
• Workbook_BeforeSave / Cells with required entry / Catch-22
• Workbook_Open - ActiveSheet.Unprotect not working!
• Working with Date variables
• working with live data
• Works one minute, doesn't the next?
• worksheet
• worksheet
• Worksheet Activate Event doesn't fire
• worksheet always on top
• worksheet before_print event...
• Worksheet can't find macro
• Worksheet Change event
• Worksheet change event and setting target range
• Worksheet Command Buttons
• Worksheet Existance....
• Worksheet existence
• Worksheet functions on arrays in VBA
• Worksheet name list
• Worksheet Names
• Worksheet names to cell
• Worksheet Open??
• Worksheet Passwords
• Worksheet Protection
• Worksheet Selection Change
• worksheet tabs
• Worksheet Tabs
• Worksheet_Change
• Worksheet_Change() not being called when expected
• Worksheet_Change: Conditionally keeping previously entered value
• Worksheet_SelectionChange(ByVal Target As Excel.Range)
• worksheetfunction.match
• Workspace w/options?
• Worsheet Compares across workbooks VBA Code
• Would it be possible to do this...?
• Wrapping Sentences In VBA Code
• Write a macro to create a macro
• Write Cell contents in text file
• Write to a macro with a macro
• Writing "Anything but a number"
• Writing a macro that compares values from two or more columns
• Xcel Highlight Macro
• XL and log sheets...
• Xla problem
• xlDialogOpen Argument
• xlDialogSave as...Possible to change path??
• xlDialogSendMail
• XLDOWN?
• XLEnableSelection
• Year To Date Figure
• Yes it is OK!!!!!!using VBA
• Yet another question...pretty general