Archive of Mr Excel Message Board
Back to archive home
- ' 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