microsoft.public.excel.programming

• Thread Index

---

• Re: Links
  • From: david-fielding
• Re: When is a Loop Necessary ?
  • From: Alan Beban
• Re: Inserting page break conditionally
  • From: RITCHI
• Re: Excel-How Do I prevent data conversion to date format
  • From: Gord Dibben
• Re: Excel-How Do I prevent data conversion to date format
  • From: Chip Pearson
• Re: Excel-How Do I prevent data conversion to date format
  • From: Ron Rosenfeld
• RE: Minimise unwanted windows
  • From: FSt1
• Re: Evaluate an Array Formula before inserting it in a cell
  • From: Dana DeLouis
• Re: Links
  • From: Karen53
• Re: Links
  • From: david-fielding
• Re: Links
  • From: Tim Williams
• Links
  • From: Karen53
• Re: Evaluate an Array Formula before inserting it in a cell
  • From: todd . huttenstine
• Inserting page break conditionally
  • From: RITCHI
• Re: Insert row code
  • From: Gary Keramidas
• Re: Insert row code
  • From: Gary Keramidas
• Insert row code
  • From: glenn
• Re: Copying Conditional Formatting from one cell to another
  • From: Peter T
• Re: Custom VBA Code
  • From: FSt1
• Minimise unwanted windows
  • From: Francis Hookham
• Re: Incrementing a string
  • From: Francis Hookham
• Re: How Determine, cell has got reference.
  • From: Peter T
• Re: Evaluate an Array Formula before inserting it in a cell
  • From: Dana DeLouis
• RE: Extract several variables from textbox content
  • From: LuisE
• Links
  • From: david-fielding
• Re: Could I jump to another Sheet by clicking on a cell
  • From: JLGWhiz
• Re: Evaluate an Array Formula before inserting it in a cell
  • From: todd . huttenstine
• RE: convert all formulas on a worksheet to aray formulas
  • From: SteveC
• Re: Tag/Identify Cells
  • From: joe . engel
• Re: saving an excel file with a serially increnmenting number
  • From: rd
• Re: Find last cell with matching value
  • From: Bernd P
• RE: Find last cell with matching value
  • From: Gary''s Student
• Re: Rounding Up & Down
  • From: Harald Staff
• Re: Find last cell with matching value
  • From: Bob Phillips
• RE: Disabling a forms 1.0 button
  • From: Will Finkle
• Re: Could I jump to another Sheet by clicking on a cell
  • From: Jean
• Re: Could I jump to another Sheet by clicking on a cell
  • From: Jean
• RE: Disabling a forms 1.0 button
  • From: Will Finkle
• Named Range
  • From: Gautam
• Re: Could I jump to another Sheet by clicking on a cell
  • From: Ron Coderre
• Re: Could I jump to another Sheet by clicking on a cell
  • From: Gord Dibben
• Could I jump to another Sheet by clicking on a cell
  • From: Jean
• RE: Disabling a forms 1.0 button
  • From: OssieMac
• RE: Disabling a forms 1.0 button
  • From: Anant Basant
• Re: Custom VBA Code
  • From: Little Penny
• Re: Avoiding Redundancy (.Find Method)
  • From: Smartin
• Re: Custom VBA Code
  • From: Little Penny
• RE: Avoiding Redundancy (.Find Method)
  • From: Anant Basant
• Re: Values from a range in one cell, seperated
  • From: Anant Basant
• Avoiding Redundancy (.Find Method)
  • From: Smartin
• Re: can an excel file compiled on a Windows PC be used on a Mac co
  • From: JE McGimpsey
• Re: Custom VBA Code
  • From: PY & Associates
• Re: VLOOKUP cell Address
  • From: Dave Peterson
• Re: can an excel file compiled on a Windows PC be used on a Mac computer?
  • From: JE McGimpsey
• can an excel file compiled on a Windows PC be used on a Mac computer?
  • From: aaronep@xxxxxxxxxxx
• RE: Extract several variables from textbox content
  • From: OssieMac
• Re: Values from a range in one cell, seperated
  • From: jgmiddel
• Re: Custom VBA Code
  • From: FSt1
• Re: Custom VBA Code
  • From: Little Penny
• Re: I want to format a worksheet based on values in another worksheet
  • From: Bill Renaud
• Re: Create a macro which takes a column name and width and sets th
  • From: Joel
• Re: I want to format a worksheet based on values in another worksheet
  • From: Bill Renaud
• RE: saving an excel file with a serially increnmenting number
  • From: OssieMac
• Re: Create a macro which takes a column name and width and sets the co
  • From: Ag
• saving an excel file with a serially increnmenting number
  • From: rd
• RE: Custom VBA Code
  • From: FSt1
• Re: Tag/Identify Cells
  • From: Bill Renaud
• Re: Create a macro which takes a column name and width and sets the co
  • From: Ag
• Re: Values from a range in one cell, seperated
  • From: Gord Dibben
• Re: Custom VBA Code
  • From: Little Penny
• Re: Copy Worksheets Into Master Workbook
  • From: Chip Pearson
• Re: VLOOKUP cell Address
  • From: Ron Luzius
• Re: Values from a range in one cell, seperated
  • From: jgmiddel
• RE: Custom VBA Code
  • From: Joel
• Re: Check SpecialCells(xlCellTypeBlanks) for >0 blanks
  • From: Dave Peterson
• Create a macro which takes a column name and width and sets the column width to what it should be
  • From: Ag
• Re: Copying select data frm one workbook to multiple workbooks & s
  • From: Ron de Bruin
• Re: Copying select data frm one workbook to multiple workbooks & s
  • From: Pman
• Re: How Determine, cell has got reference.
  • From: Tim Williams
• Re: Code for deleting rows?
  • From: Bill Renaud
• Re: Any ideas of integrating Unix with Excel?
  • From: Tim Williams
• Re: Rounding Up & Down
  • From: Ron Coderre
• RE: Values from a range in one cell, seperated
  • From: Anant Basant
• Re: Executing an FTP call
  • From: Leith Ross
• Custom VBA Code
  • From: Little Penny
• Re: Email question
  • From: Ron de Bruin
• RE: Values from a range in one cell, seperated
  • From: Anant Basant
• Re: Copying Conditional Formatting from one cell to another
  • From: bstobart
• Re: Want to use Excel to parse a text file
  • From: RB Smissaert
• Re: Want to access the SUBTOTAL of a list from within a worksheet
  • From: Ron Coderre
• Re: Check SpecialCells(xlCellTypeBlanks) for >0 blanks
  • From: Dave Peterson
• RE: works and doesn't work
  • From: Curt
• I want to format a worksheet based on values in another worksheet
  • From: Ag
• RE: Change color of an autoshape
  • From: Ly
• RE: works and doesn't work
  • From: JLGWhiz
• Re: Deleting characters to the right in a column....
  • From: Gary Keramidas
• Values from a range in one cell, seperated
  • From: jgmiddel
• Any ideas of integrating Unix with Excel?
  • From: Michael
• Executing an FTP call
  • From: Mac Lingo
• Want to access the SUBTOTAL of a list from within a worksheet
  • From: Michael
• Re: Want to use Excel to parse a text file
  • From: Michael
• Import data from Microsoft SQL Server into Microsoft Excel
  • From: Joe K.
• Re: Deleting characters to the right in a column....
  • From: Zone
• Tag/Identify Cells
  • From: joe . engel
• Deleting characters to the right in a column....
  • From: J.W. Aldridge
• Re: How to reference variable worksheets and variable row
  • From: Tomcat
• Re: Rounding error???
  • From: Ron Rosenfeld
• Re: Rounding error???
  • From: Andrew Taylor
• Re: Insert row on multiple sheets
  • From: Dave Peterson
• Re: If function with average fomula to be tru or false
  • From: JE McGimpsey
• Rounding error???
  • From: oggy
• Re: How to reference variable worksheets and variable row
  • From: JE McGimpsey
• Re: create a series
  • From: JE McGimpsey
• Re: how do I make the title bar disapppear
  • From: Bob Phillips
• RE: complicated search and extract.... i think
  • From: mike
• How to reference variable worksheets and variable row
  • From: glenn
• Re: Programmatically signing Excel VBA Macro
  • From: Mike
• Re: How Determine, cell has got reference.
  • From: Peter T
• create a series
  • From: Jeff
• Re: How Determine, cell has got reference.
  • From: Peter T
• Re: Disable 2003 VB code for users using older Excel
  • From: Ron de Bruin
• Re: Excel cannot complete this task with available resources
  • From: ssGuru
• Re: Start a macro when click on tab sheet
  • From: Gord Dibben
• Re: Start a macro when click on tab sheet
  • From: Gary Keramidas
• RE: Start a macro when click on tab sheet
  • From: Jean
• Re: iif() function
  • From: Ron Rosenfeld
• RE: Code problem working with QueryTable
  • From: Joel
• RE: 1004 error - can't find text file to refresh ...
  • From: Joel
• Re: Disable 2003 VB code for users using older Excel
  • From: Doug Glancy
• Re: Excel cannot complete this task with available resources
  • From: Robin Hammond
• Re: Disable 2003 VB code for users using older Excel
  • From: Gord Dibben
• Re: Disable 2003 VB code for users using older Excel
  • From: Gord Dibben
• 1004 error - can't find text file to refresh ...
  • From: LeAnn
• Re: Dates: How to check if date value is 10 months and or 1 year o
  • From: Ron Coderre
• Re: Macro Removes Cell Borders
  • From: Thomas M.
• Re: Macro Removes Cell Borders
  • From: Thomas M.
• Re: Dates: How to check if date value is 10 months and or 1 year old?
  • From: Ron Coderre
• Re: Activating Javascript with excel Part 2
  • From: Tim Williams
• Start a macro when click on tab sheet
  • From: Nancy
• RE: Textbox Value Changes
  • From: Karen53
• AVERAGE, STDEV, SEM with criteria
  • From: robotman
• Code problem working with QueryTable
  • From: Billy B
• Re: Single quote in sheet name
  • From: Dave Peterson
• Re: Single quote in sheet name
  • From: Ron de Bruin
• Re: Single quote in sheet name
  • From: Ron Coderre
• Re: Save copies in different places
  • From: Dave Peterson
• Single quote in sheet name
  • From: ankur
• Re: Checking cells for value
  • From: dan dungan
• Re: Evaluate an Array Formula before inserting it in a cell
  • From: todd . huttenstine
• RE: Textbox Value Changes
  • From: Karen53
• Re: format all column width
  • From: JLGWhiz
• restricting other applications from being opened when running a macro
  • From: mobin . thomas
• Re: Using DEC2BIN(range,6) in VBA Code
  • From: Paul Black
• RE: Textbox Value Changes
  • From: Tom Ogilvy
• Re: format all column width
  • From: Daniel
• Re: Add a character to all cells in a column
  • From: Steve Yandl
• divide and copy rows
  • From: glenn
• Re: Cut button is disabled
  • From: Asif
• Re: Add a character to all cells in a column
  • From: Don Guillett
• Re: insert an ICON in a cell
  • From: Ron de Bruin
• Re: Searching and storing Column Number
  • From: rita . michail
• Re: Help with building a formula based on cell values
  • From: jfrick100
• Add a character to all cells in a column
  • From: glenn
• Re: format all column width
  • From: Otto Moehrbach
• Re: Cut button is disabled
  • From: Ron de Bruin
• Re: Cut button is disabled
  • From: Tom Ogilvy
• Re: Help with SQL and ODBC Text Driver
  • From: RB Smissaert
• Re: Code for deleting rows?
  • From: Phillip
• Re: Cut button is disabled
  • From: Asif
• RE: HYPERLINK TO FILES IN A FOLDER
  • From: Gary''s Student
• Re: use a variable for a worksheet name in a formula
  • From: jfrick100
• RE: Help with building a formula based on cell values
  • From: Gary''s Student
• Re: Deleting Values in a Row based on a Certain Criteria
  • From: cardan
• Re: Save copies in different places
  • From: J.W. Aldridge
• RE: Help with building a formula based on cell values
  • From: Tom Ogilvy
• RE: Help, One form Closes another Form when closing itself...
  • From: Tom Ogilvy
• Re: wrong calculation ?
  • From: Helmut Weber
• Re: Searching and storing Column Number
  • From: Dave Peterson
• Help with building a formula based on cell values
  • From: jfrick100
• Re: How can I remove leading zeros?
  • From: Dave Peterson
• RE: Help, One form Closes another Form when closing itself...
  • From: MikeZz
• Re: Evaluate an Array Formula before inserting it in a cell
  • From: todd . huttenstine
• Deleting Values in a Row based on a Certain Criteria
  • From: cardan
• Re: tracking updates
  • From: Pam M
• Re: Cut button is disabled
  • From: Ron de Bruin
• Re: Searching and storing Column Number
  • From: rita . michail
• Re: Cut button is disabled
  • From: Asif
• Re: Macro Copying Rows That Change Dynamically
  • From: Gord Dibben
• Re: Want to get text entered in a Userform TextBox after hitting T
  • From: Steve Yandl
• Re: tracking updates
  • From: Otto Moehrbach
• Re: Copying select data frm one workbook to multiple workbooks & s
  • From: Ron de Bruin
• RE: complicated search and extract.... i think
  • From: JRForm
• Re: Cut button is disabled
  • From: Ron de Bruin
• Re: How can I remove leading zeros?
  • From: AccessHelp
• Re: Additem to ComboBox using the Column Property
  • From: JW
• Re: insert an ICON in a cell
  • From: Ron de Bruin
• Re: Cut button is disabled
  • From: Asif
• Re: Copying select data frm one workbook to multiple workbooks & s
  • From: Pman
• Re: Searching and storing Column Number
  • From: JW
• Re: Save copies in different places
  • From: Dave Peterson
• Re: Ws Selection Change Event Code, Copy a Cell problem
  • From: Dave Peterson
• Re: insert an ICON in a cell
  • From: Ron Coderre
• Re: Excel cannot complete this task with available resources
  • From: ssGuru
• Re: Cut button is disabled
  • From: Ron de Bruin
• Re: On File Open
  • From: JE McGimpsey
• Re: Ws Selection Change Event Code, Copy a Cell problem
  • From: Neal Zimm
• Re: How to hold Macro running?
  • From: Bill Renaud
• Re: Cut button is disabled
  • From: Ron de Bruin
• Searching and storing Column Number
  • From: rita . michail
• Re: "Run application" based on condition...
  • From: Limey
• RE: Help, One form Closes another Form when closing itself...
  • From: JRForm
• Re: Managing objects in VBA ( specifically good practices with destruction)
  • From: Tom Med
• Re: Trouble exporting using Chip Pearson's export
  • From: dan dungan
• Re: Cut button is disabled
  • From: Asif
• RE: VBA to autofill next blank cell in same column
  • From: manfareed
• RE: VBA to autofill next blank cell in same column
  • From: manfareed
• Re: Range or Array?
  • From: Alan Beban
• Re: Hyperlink created with a macro, altered on save.
  • From: Dave Peterson
• Re: Cut button is disabled
  • From: Ron de Bruin
• Re: Cut button is disabled
  • From: Equiangular
• Save copies in different places
  • From: J.W. Aldridge
• RE: UFD to change color based on string
  • From: Mitch
• How does data validation work
  • From: Dean
• Re: "Run application" based on condition...
  • From: J.W. Aldridge
• Re: Using or loading external code
  • From: RB Smissaert
• Re: HYPERLINK TO FILES IN A FOLDER
  • From: Ron Coderre
• Re: Using or loading external code
  • From: GDCobra
• Re: AutoRun Macro with a delay to give user the choice to cancel the macro
  • From: wanderlust
• Professional Excel Development Chapter 5
  • From: greg . bieber
• Re: Delete Rows if any cell in Column H is blank but do not Delete Fir
  • From: Ron de Bruin
• Re: Question about Pivot Tables
  • From: danmyers01
• Re: Need help on Excel macro.
  • From: robin thobiyas
• Re: "Run application" based on condition...
  • From: J.W. Aldridge
• Re: Progmatically set "Application.Dialogs(xlDialogFormulaFind)" o
  • From: Rick S.
• Re: Using or loading external code
  • From: RB Smissaert
• Re: Progmatically set "Application.Dialogs(xlDialogFormulaFind)" o
  • From: Rick S.
• Re: Sorting on more than one column
  • From: Brian
• Re: "Run application" based on condition...
  • From: Limey
• Re: Sorting on more than one column
  • From: Gary Keramidas
• Re: Want to get text entered in a Userform TextBox after hitting T
  • From: MikeZz
• "Run application" based on condition...
  • From: J.W. Aldridge
• Re: Need help on Excel macro.
  • From: Matthew Pfluger
• Re: Calling a Public Function
  • From: Jim Cone
• Re: Activating Javascript with excel Part 2
  • From: Andrew Taylor
• Re: Excel Hyperlink to Open an External File
  • From: Mike Fogleman
• Re: Managing objects in VBA ( specifically good practices with destruc
  • From: RB Smissaert
• Re: AutoRun Macro with a delay to give user the choice to cancel the macro
  • From: Andrew Taylor
• RE: Creating 1 row from n rows using concatenate and if then state
  • From: VBA_Newbie79
• Re: Using or loading external code
  • From: RB Smissaert
• Re: Hiding rows
  • From: JRForm
• Re: Managing objects in VBA ( specifically good practices with destruc
  • From: Jon Peltier
• Re: Managing objects in VBA ( specifically good practices with destruction)
  • From: Jon Peltier
• Calling a Public Function
  • From: David
• Re: Delete Empty Series from Chart
  • From: Jon Peltier
• AutoRun Macro with a delay to give user the choice to cancel the macro
  • From: wanderlust
• Re: generating a #VALUE
  • From: Dave Peterson
• Re: More Efficient IF
  • From: Tom Ogilvy
• RE: Creating 1 row from n rows using concatenate and if then state
  • From: VBA_Newbie79
• Re: Want to get text entered in a Userform TextBox after hitting T
  • From: MikeZz
• Re: find word initial then final......
  • From: Dave Peterson
• Re: wrong calculation ?
  • From: Helmut Weber
• Re: Password Protection
  • From: Dave Peterson
• Re: Look for cell containing "Initial" then if the next cell after equals "Final" then delete both rows.
  • From: Dave Peterson
• Re: Using DEC2BIN(range,6) in VBA Code
  • From: Paul Black
• RE: Look for cell containing "Initial" then if the next cell after equ
  • From: Tom Ogilvy
• RE: Insert row on multiple sheets
  • From: HartJF
• Re: find word initial then final......
  • From: amorrison2006@xxxxxxxxxxxxxx
• Re: More Efficient IF
  • From: Joel
• Re: wrong calculation ?
  • From: Helmut Weber
• Re: Ws Selection Change Event Code, Copy a Cell problem
  • From: Dave Peterson
• RE: Visual Basic Editor Layout
  • From: Tom Ogilvy
• Re: More Efficient IF
  • From: Andrew Taylor
• Re: wrong calculation ?
  • From: Chip Pearson
• Re: wrong calculation ?
  • From: Ron Rosenfeld
• Re: 2 Dim Arrays & List Box
  • From: Incidental
• Re: wrong calculation ?
  • From: Helmut Weber
• Re: Excel Hyperlink to Open an External File
  • From: tkt_tang
• Re: More Efficient IF
  • From: Incidental
• Re: wrong calculation ?
  • From: Helmut Weber
• Re: wrong calculation ?
  • From: Andrew Taylor
• RE: FieldInfo
  • From: Joel
• Re: Activating Javascript with excel Part 2
  • From: jason36
• Re: find word initial then final......
  • From: David
• find word initial then final......
  • From: amorrison2006@xxxxxxxxxxxxxx
• Re: Need help on Excel macro.
  • From: robin thobiyas
• More Efficient IF
  • From: David
• Re: Hiding rows
  • From: Roger Govier
• Re: Using DEC2BIN(range,6) in VBA Code
  • From: Paul Black
• Re: Can't right click embedded objects
  • From: Peter T
• RE: OLE Link bug introduced in Excel 2003 SP3
  • From: Sounds Logical
• Re: More Efficient IF
  • From: papou
• Re: More Efficient IF
  • From: Rick Rothstein \(MVP - VB\)
• Re: Hiding rows
  • From: Saintsman
• More Efficient IF
  • From: David
• Password Protection
  • From: Len
• Look for cell containing "Initial" then if the next cell after equals "Final" then delete both rows.
  • From: amorrison2006@xxxxxxxxxxxxxx
• Can't right click embedded objects
  • From: Nick_F
• Re: protection,distribution
  • From: rishi
• Re: Activating Javascript with excel Part 2
  • From: Tim Williams
• Re: Hidden formulas.2
  • From: Tim Williams
• Re: CopySheet After
  • From: Doug Glancy
• Problem: Workbook contents vanish
  • From: VanS
• Re: CopySheet After
  • From: Doug Glancy
• Ws Selection Change Event Code, Copy a Cell problem
  • From: Neal Zimm
• Re: Limitations to Excel Add-Ins
  • From: danmyers01
• Re: Comparing 2 files on date/time stamp, and based time difference do a subroutine
  • From: Robin Hammond
• Re: VBA Forms
  • From: Gary Keramidas
• Re: Excel cannot complete this task with available resources
  • From: Robin Hammond
• Re: sorting by Contract #'s
  • From: Dave Peterson
• Re: How to hold Macro running?
  • From: mark
• Re: How to hold Macro running?
  • From: Bill Renaud
• Re: sorting by Contract #'s
  • From: Eric
• Re: Use Custom Document Property to identify xls files not yet process
  • From: Leith Ross
• Comparing 2 files on date/time stamp, and based time difference do a subroutine
  • From: info
• Re: Question about Pivot Tables
  • From: Little Penny
• Re: Trouble exporting using Chip Pearson's export
  • From: Joel
• Re: VBA Forms
  • From: JW
• RE: UserForm with ListBox
  • From: Jean
• VBA Forms
  • From: frost
• Re: CopySheet After
  • From: Karen53
• Re: Formatting after Importing
  • From: Gord Dibben
• Re: Conditional Combo Boxes
  • From: Leith Ross
• Re: CopySheet After
  • From: Doug Glancy
• Re: Want to get text entered in a Userform TextBox after hitting Tab o
  • From: Steve Yandl
• System Call Failed
  • From: Joe Gottman
• Re: Checking cells for value
  • From: Gord Dibben
• calculateing cells on demand
  • From: Lars Schouw
• Formatting after Importing
  • From: mcse_instructor
• Re: change values in a column
  • From: guy
• Re: change values in a column
  • From: guy
• Re: Limitations to Excel Add-Ins
  • From: RB Smissaert
• Re: UserForm & listBox
  • From: Bob Phillips
• Re: Excel- find the last filled cells in column with empty cells
  • From: Steve Yandl
• Re: Checking cells for value
  • From: dan dungan
• Re: Want to use Excel to parse a text file
  • From: RB Smissaert
• Re: Adding "Add-Ins..." control to custom tooolbar
  • From: Jim Cone
• Re: Button to change view location
  • From: dan dungan
• Re: Evalute Array Formula in VBA code
  • From: todd . huttenstine
• Re: Question about Pivot Tables
  • From: danmyers01
• Re: Update Pivot from datasheet in different folder
  • From: J.W. Aldridge
• Re: Want to use Excel to parse a text file
  • From: Michael
• Re: VLOOKUP cell Address
  • From: Dave Peterson
• Re: How can I remove leading zeros?
  • From: Dave Peterson
• Limitations to Excel Add-Ins
  • From: danmyers01
• Question about Pivot Tables
  • From: Little Penny
• Re: Append character to cell
  • From: Dave Peterson
• Re: UserForm & listBox
  • From: Dave Peterson
• Re: Using vLookup function in VBA
  • From: Dave Peterson
• Re: Trouble exporting using Chip Pearson's export
  • From: dan dungan
• VLOOKUP cell Address
  • From: Ron Luzius
• Re: Append character to cell
  • From: Steve Yandl
• Re: How can I remove leading zeros?
  • From: Dave Peterson
• Re: Find Multiple Values, Copy Entire Row & Paste
  • From: RyGuy
• Re: sorting by Contract #'s
  • From: Dave Peterson
• Adding "Add-Ins..." control to custom tooolbar
  • From: Sandusky
• Re: Last Row in Formula
  • From: Bob Phillips
• Re: Load Value into textbox
  • From: Bob Phillips
• Excel- find the last filled cells in column with empty cells
  • From: sde_us
• Re: Progmatically set "Application.Dialogs(xlDialogFormulaFind)" optio
  • From: Bob Phillips
• RE: Creating 1 row from n rows using concatenate and if then state
  • From: FSt1
• Re: sorting by Contract #'s
  • From: Eric
• Re: changing active printer for Word.
  • From: Steve Yandl
• Evalute Array Formula in VBA code
  • From: todd . huttenstine
• Re: Restrict area where I can use button with macro
  • From: Rafael_SP
• Re: Countif to changing range
  • From: davegb
• RE: Creating 1 row from n rows using concatenate and if then statement
  • From: Joel
• Re: Solver Iterations-how to change number
  • From: Mark Lincoln
• Re: Button to change view location
  • From: Keith-NB
• Append character to cell
  • From: glenn
• Re: Want to use Excel to parse a text file
  • From: RB Smissaert
• Last Row in Formula
  • From: Steve
• Re: Finding Duplicates in a list
  • From: RadarEye
• RE: Finding Duplicates in a list
  • From: Gary''s Student
• Re: Export worksheet to .csv
  • From: Omar
• RE: Error handling help
  • From: cottage6
• RE: Creating 1 row from n rows using concatenate and if then state
  • From: VBA_Newbie79
• trying to use PasteAndFormat method in Excel VBA is not working
  • From: AdamLeeeee
• RE: Creating 1 row from n rows using concatenate and if then statement
  • From: FSt1
• changing active printer for Word.
  • From: navin
• Re: Button to change view location
  • From: dan dungan
• Re: Use a Piece of Data for File Name
  • From: RB Smissaert
• Re: Using DEC2BIN(range,6) in VBA Code
  • From: Paul Black
• Re: Use a Piece of Data for File Name
  • From: AccessHelp
• Re: Managing objects in VBA ( specifically good practices with des
  • From: RB Smissaert
• Re: tracking updates
  • From: Pam M
• Re: Trouble with Sharing Addins
  • From: M. Authement
• Re: Managing objects in VBA ( specifically good practices with des
  • From: Tom Med
• Re: Managing objects in VBA ( specifically good practices with des
  • From: Tom Med
• Vlookup in another workbook
  • From: Luis A. Vázquez
• Re: Use a Piece of Data for File Name
  • From: RB Smissaert
• Re: Help in connecting to MS Access
  • From: GysdeJongh
• Re: Button to change view location
  • From: Keith-NB
• Re: Export worksheet to .csv
  • From: Ron de Bruin
• RE: Using vLookup function in VBA
  • From: Jim Thomlinson
• Re: Export worksheet to .csv
  • From: Ken
• Re: UserForm & listBox
  • From: JW
• Re: change values in a column
  • From: JW
• Re: Button to change view location
  • From: dan dungan
• RE: Error handling help
  • From: Tom Ogilvy
• Re: Display message if "find" command comes up blank ??
  • From: vrzimmerm
• Re: change values in a column
  • From: JW
• Re: How can I remove leading zeros?
  • From: AccessHelp
• Re: UserForm & listBox
  • From: Bob Phillips
• Re: Trouble exporting using Chip Pearson's export
  • From: Joel
• Re: Use a Piece of Data for File Name
  • From: AccessHelp
• Re: tracking updates
  • From: Otto Moehrbach
• Re: Countif to changing range
  • From: JW
• Re: Want to use Excel to parse a text file
  • From: RB Smissaert
• Export worksheet to .csv
  • From: Omar
• RE: Using vLookup function in VBA
  • From: Dale Fye
• RE: Last Row in Column not working
  • From: Terry
• Re: Find a string
  • From: Francis Hookham
• Re: Find a string
  • From: Francis Hookham
• Re: Want to use Excel to parse a text file
  • From: Jim Cone
• Re: Trouble exporting using Chip Pearson's export
  • From: dan dungan
• Re: Want to use Excel to parse a text file
  • From: RB Smissaert
• Re: Optional Arguments in Custom Fuctions
  • From: eggman
• Re: Activate macro after clicking on a particular cell
  • From: Don Guillett
• Re: How can I remove leading zeros?
  • From: Gary Keramidas
• Re: Find Multiple Values, Copy Entire Row & Paste
  • From: Otto Moehrbach
• RE: Activate macro after clicking on a particular cell
  • From: Self-Calling Problem
• Re: How can I remove leading zeros?
  • From: Gary Keramidas
• Countif to changing range
  • From: davegb
• Re: Incrementing a string
  • From: Rick Rothstein \(MVP - VB\)
• RE: Copy multiple values into a single cell
  • From: Suzanne
• Re: Want to use Excel to parse a text file
  • From: Jim Cone
• Re: Use a Piece of Data for File Name
  • From: RB Smissaert
• Re: Managing objects in VBA ( specifically good practices with des
  • From: RB Smissaert
• Help in connecting to MS Access
  • From: phong.lee@xxxxxxxxx
• Re: Want to use Excel to parse a text file
  • From: RB Smissaert
• Flex grid microsoft
  • From: Franco Cazzola
• Re: Managing objects in VBA ( specifically good practices with des
  • From: Tom Med
• Re: Find Multiple Values, Copy Entire Row & Paste
  • From: Otto Moehrbach
• RE: Workbook contents disappear
  • From: VanS
• Re: change values in a column
  • From: Bill Renaud
• Update Pivot from datasheet in different folder
  • From: J.W. Aldridge
• RE: Workbook contents disappear
  • From: Ralph
• Re: How can I remove leading zeros?
  • From: AccessHelp
• RE: Workbook contents disappear
  • From: VanS
• Creating 1 row from n rows using concatenate and if then statement
  • From: VBA_Newbie79
• Re: Display message if "find" command comes up blank ??
  • From: vrzimmerm
• Re: Display message if "find" command comes up blank ??
  • From: JE McGimpsey
• Re: Find Multiple Values, Copy Entire Row & Paste
  • From: ryguy7272
• RE: help statement unfinished
  • From: Tom Ogilvy
• Re: Button to change view location
  • From: Keith-NB
• Re: Display message if "find" command comes up blank ??
  • From: JW
• Re: Use a Piece of Data for File Name
  • From: AccessHelp
• Re: help statement unfinished
  • From: JW
• Display message if "find" command comes up blank ??
  • From: vrzimmerm
• Re: Workbooks.Open Fails
  • From: Ron de Bruin
• Re: Find Multiple Values, Copy Entire Row & Paste
  • From: Tom Ogilvy
• change values in a column
  • From: guy
• Re: Find a string
  • From: Don Guillett
• Re: Want to use Excel to parse a text file
  • From: RB Smissaert
• Re: Want to use Excel to parse a text file
  • From: RB Smissaert
• Re: Find Multiple Values, Copy Entire Row & Paste
  • From: ryguy7272
• Find a string
  • From: Francis Hookham
• Want to use Excel to parse a text file
  • From: Michael
• Re: Optional Arguments in Custom Fuctions
  • From: Rick Rothstein \(MVP - VB\)
• Re: Incrementing a string
  • From: Francis Hookham
• RE: Error handling help
  • From: cottage6
• Re: Optional Arguments in Custom Fuctions
  • From: Chip Pearson
• Re: Use a Piece of Data for File Name
  • From: RB Smissaert
• RE: Optional Arguments in Custom Fuctions
  • From: Tom Ogilvy
• Re: Use a Piece of Data for File Name
  • From: AccessHelp
• Re: Use a Piece of Data for File Name
  • From: RB Smissaert
• RE: UserForm with ListBox
  • From: JLGWhiz
• RE: Protecting validation
  • From: Asif
• Re: Use a Piece of Data for File Name
  • From: AccessHelp
• Re: Button to change view location
  • From: dan dungan
• Re: Find Multiple Values, Copy Entire Row & Paste
  • From: Tom Ogilvy
• Re: Making calculations with times.
  • From: Dave D-C
• Re: Use a Piece of Data for File Name
  • From: RB Smissaert
• Re: Find Multiple Values, Copy Entire Row & Paste
  • From: Otto Moehrbach
• Re: Use a Piece of Data for File Name
  • From: AccessHelp
• Re: Managing objects in VBA ( specifically good practices with des
  • From: RB Smissaert
• Re: How can I remove leading zeros?
  • From: AccessHelp
• Re: Copy, Paste Special Values all sheets in workbook
  • From: Ron de Bruin
• Re: How can I remove leading zeros?
  • From: Dave Peterson
• Re: How can I remove leading zeros?
  • From: AccessHelp
• RE: Error handling help
  • From: Tom Ogilvy
• RE: Lists from other worksheets
  • From: Tom Ogilvy
• Re: Automating Excel Macros
  • From: Alok
• Re: Use a Piece of Data for File Name
  • From: RB Smissaert
• Re: dynamic value not copying correctly
  • From: JE McGimpsey
• Re: Use a Piece of Data for File Name
  • From: AccessHelp
• RE: Find Multiple Values, Copy Entire Row & Paste
  • From: Tom Ogilvy
• RE: Find Multiple Values, Copy Entire Row & Paste
  • From: Michael
• Re: Managing objects in VBA ( specifically good practices with des
  • From: Tom Ogilvy
• Re: Button to change view location
  • From: Keith-NB
• Find Multiple Values, Copy Entire Row & Paste
  • From: ryguy7272
• RE: Delete variable # of rows depending on conditions
  • From: Pman
• Re: Combined text and variable in a message box
  • From: Incidental
• Re: dynamic value not copying correctly
  • From: Tom Ogilvy
• Re: Combined text and variable in a message box
  • From: JW
• Re: dynamic value not copying correctly
  • From: JW
• Re: Email
  • From: Richard
• Combined text and variable in a message box
  • From: vrzimmerm
• Re: Use a Piece of Data for File Name
  • From: RB Smissaert
• Re: Use a Piece of Data for File Name
  • From: AccessHelp
• RE: Problem with script, please help
  • From: Joel
• Re: dynamic value not copying correctly
  • From: GrahamR
• RE: Use a Piece of Data for File Name
  • From: AccessHelp
• RE: Problem with script, please help
  • From: Les
• Re: Email
  • From: Bob Phillips
• RE: Problem with script, please help
  • From: Joel
• Re: Use a Piece of Data for File Name
  • From: RB Smissaert
• Re: Email
  • From: Richard
• Re: Use a Piece of Data for File Name
  • From: AccessHelp
• Re: dynamic value not copying correctly
  • From: JW
• Need help on Excel macro.
  • From: robin thobiyas
• Re: Protect Code
  • From: JW
• Re: File format conversion on server
  • From: Richard Bond
• Re: File format conversion on server
  • From: crferguson@xxxxxxxxx
• Re: Name of Added Worksheet
  • From: papou
• RE: Copy multiple values into a single cell
  • From: ryguy7272
• Re: Name of Added Worksheet
  • From: Dave Peterson
• Re: Name of Added Worksheet
  • From: Don Guillett
• Re: Name of Added Worksheet
  • From: Chip Pearson
• Re: VBA6 cores when hitting Reset button on the VBA IDE
  • From: RB Smissaert
• Re: File Link
  • From: Dave Peterson
• Re: Can this be Done?
  • From: Dave Peterson
• RE: Problem with script, please help
  • From: Les
• Re: Copy multiple values into a single cell
  • From: crferguson@xxxxxxxxx
• Re: Managing objects in VBA ( specifically good practices with destruc
  • From: RB Smissaert
• Re: VBA6 cores when hitting Reset button on the VBA IDE
  • From: Tom Med
• Re: Managing objects in VBA ( specifically good practices with destruction)
  • From: Tom Med
• RE: replay from a database through RTD
  • From: John.Greenan
• Re: Travel through no of sheets in a workbook.
  • From: crferguson@xxxxxxxxx
• Re: File format conversion on server
  • From: crferguson@xxxxxxxxx
• RE: Problem with script, please help
  • From: Joel
• Re: Managing objects in VBA ( specifically good practices with destruction)
  • From: Tom Med
• Re: Travel through no of sheets in a workbook.
  • From: Raj
• RE: Copy multiple values into a single cell
  • From: Matthew Pfluger
• Re: Managing objects in VBA ( specifically good practices with destruc
  • From: Tom Med
• Re: Managing objects in VBA ( specifically good practices with destruction)
  • From: RB Smissaert
• Re: Travel through no of sheets in a workbook.
  • From: crferguson@xxxxxxxxx
• Re: Travel through no of sheets in a workbook.
  • From: JW
• Copy multiple values into a single cell
  • From: Suzanne
• Travel through no of sheets in a workbook.
  • From: Raj
• Re: Managing objects in VBA ( specifically good practices with destruction)
  • From: Jon Peltier
• Re: VBA6 cores when hitting Reset button on the VBA IDE
  • From: RB Smissaert
• Re: Managing objects in VBA ( specifically good practices with destruc
  • From: sali
• Re: CopyFromRecordSet extremely slow
  • From: arno
• Re: VBA6 cores when hitting Reset button on the VBA IDE
  • From: Tom Med
• Re: CopyFromRecordSet extremely slow
  • From: sali
• Problem with script, please help
  • From: Les
• Re: What are {}, how do you use them in IF statements
  • From: Roger Govier
• Re: Hiding rows
  • From: Roger Govier
• Re: VBA6 cores when hitting Reset button on the VBA IDE
  • From: RB Smissaert
• File Link
  • From: Ola2B
• Re: Copy, Paste Special Values all sheets in workbook
  • From: Joel
• RE: What are {}, how do you use them in IF statements
  • From: Paul
• Re: Copy, Paste Special Values all sheets in workbook
  • From: sharon_hutchison
• RE: What are {}, how do you use them in IF statements
  • From: Joel
• RE: Moving up one cell
  • From: Hans Dummer
• Re: VBA6 cores when hitting Reset button on the VBA IDE
  • From: Tom Med
• Re: Copy, Paste Special Values all sheets in workbook
  • From: sali
• Re: Writing hex numbers to a binary file
  • From: sali
• CopyFromRecordSet extremely slow
  • From: arno
• RE: Synchronous execution using shell function
  • From: Stefi
• Re: selectionchanged event
  • From: Bob Phillips
• Copy, Paste Special Values all sheets in workbook
  • From: sharon_hutchison
• Re: UserForms - how to return a value?
  • From: Bob Phillips
• Re: Clear data in a FORM row
  • From: Incidental
• Managing objects in VBA ( specifically good practices with destruction)
  • From: Tom Med
• Re: VBA6 cores when hitting Reset button on the VBA IDE
  • From: RB Smissaert
• Re: VBA6 cores when hitting Reset button on the VBA IDE
  • From: Tom Med
• Re: Email
  • From: Bob Phillips
• Re: ADO connection Open failure
  • From: alexhatzisavas
• RE: Right mouse paste
  • From: GDCobra
• RE: Can this be Done?
  • From: Halim
• Re: copy unique values to validation list
  • From: buattis
• Re: protection,distribution
  • From: JE McGimpsey
• RE: Can this be Done?
  • From: Jason Zischke
• Can i hide specific data series in an excel chart yet show the values in the legend???
  • From: tony__77
• Re: Extract Data
  • From: Len
• RE: Can this be Done?
  • From: Halim
• protection,distribution
  • From: rishi
• Re: Sub to clear range above n below diagonal
  • From: Max
• Re: supress display during execution of an excel macro
  • From: Trevor Shuttleworth
• SQL doubts
  • From: vijee04
• RE: UserForm with ListBox
  • From: Jean
• Re: Sub to clear range above n below diagonal
  • From: Marcus Schöneborn
• replay from a database through RTD
  • From: Gary . Middlemiss
• Re: Worksheet Calculate
  • From: Bill Renaud
• load .xla addin's when open Excel sheet.
  • From: Lars Schouw
• Re: How to zero out non-contiguous ranges
  • From: Bill Renaud
• Re: Activating Javascript with excel Part 2
  • From: Tim Williams
• Re: Hidden formulas.2
  • From: Tim Williams
• Re: Datagrid-Flexgrid
  • From: Robin Hammond
• Excel cannot complete this task with available resources
  • From: Robin Hammond
• RE: Delete variable # of rows depending on conditions
  • From: Joel
• RE: Extract Data
  • From: Joel
• RE: Delete variable # of rows depending on conditions
  • From: Charles Chickering
• Re: Need help in creating dynamic drop down list in userform
  • From: kiwis
• UserForm with ListBox
  • From: Jean
• RE: Delete variable # of rows depending on conditions
  • From: Joel
• Extract Data
  • From: Len
• RE: Select next Cell Down
  • From: Joel
• Re: Identify Last Cell and autofill last column
  • From: ssGuru
• Re: Trouble exporting using Chip Pearson's export
  • From: Joel
• Re: Access VBA outside of Excel
  • From: Joel
• Re: Sub to clear range above n below diagonal
  • From: Max
• Select next Cell Down
  • From: RyGuy
• Re: double click macros
  • From: jack
• Re: Workbooks.Open Fails
  • From: Ed_P via OfficeKB.com
• RE: Simple Excel VBA Question
  • From: JMB
• RE: Use a Piece of Data for File Name
  • From: eliano
• Re: Trouble exporting using Chip Pearson's export
  • From: Don Guillett
• Re: How to zero out non-contiguous ranges
  • From: Dean
• RE: Delete variable # of rows depending on conditions
  • From: Charles Chickering
• Re: Button to change view location
  • From: dan dungan
• Re: XValues series breaks on disjoint ranges - but works fine in Excel 2007
  • From: laneer
• RE: Web Queries
  • From: mark
• Re: Beforesave - Save copy on my desktop
  • From: J.W. Aldridge
• Re: Use a Piece of Data for File Name
  • From: RB Smissaert
• Re: Access VBA outside of Excel
  • From: dan dungan
• Re: Use a Piece of Data for File Name
  • From: dan dungan
• Re: Use a Piece of Data for File Name
  • From: AccessHelp
• Re: How can I remove leading zeros?
  • From: Gary Keramidas
• Trouble exporting using Chip Pearson's export
  • From: dan dungan
• Re: How can I remove leading zeros?
  • From: AccessHelp
• Re: How can I remove leading zeros?
  • From: AccessHelp
• Re: supress display during execution of an excel macro
  • From: Trevor Shuttleworth
• Web Queries
  • From: mark
• Re: Use a Piece of Data for File Name
  • From: RB Smissaert
• Re: How can I remove leading zeros?
  • From: Chip Pearson
• Re: Beforesave - Save copy on my desktop
  • From: Chip Pearson
• Re: How can I remove leading zeros?
  • From: Gary Keramidas
• supress display during execution of an excel macro
  • From: Stu Littleton
• Re: How can I remove leading zeros?
  • From: AccessHelp
• Re: button macro
  • From: Ron de Bruin
• Re: How can I remove leading zeros?
  • From: Gary Keramidas
• Re: Popluating data from ms access
  • From: Piotr Kurowski
• Re: button macro
  • From: dmshurley
• How can I remove leading zeros?
  • From: AccessHelp
• Beforesave - Save copy on my desktop
  • From: J.W. Aldridge
• Re: Lookup Code
  • From: rleavitt
• Re: Workbooks.Open Fails
  • From: Ron de Bruin
• Re: Popluating data from ms access
  • From: Ron de Bruin
• Popluating data from ms access
  • From: phong.lee@xxxxxxxxx
• RE: Button to change view location
  • From: Keith-NB
• Re: Access VBA outside of Excel
  • From: rleavitt
• Delete variable # of rows depending on conditions
  • From: Pman
• Re: Trouble with Sharing Addins
  • From: Randy Harmelink
• Re: Restrict area where I can use button with macro
  • From: JW
• RE: Workbook contents disappear
  • From: Ralph
• RE: How to Set Focus a row - Option Button Click
  • From: Joel
• Re: VBA6 cores when hitting Reset button on the VBA IDE
  • From: RB Smissaert
• Re: Worksheet Calculate
  • From: Karen53
• Restrict area where I can use button with macro
  • From: Rafael_SP
• Re: hide vba code
  • From: Dave Peterson
• How to Set Focus a row - Option Button Click
  • From: Lisab
• Re: show / hide chart data
  • From: Jim
• Re: How to zero out non-contiguous ranges
  • From: Bill Renaud
• Re: check for last day of month
  • From: Ron Rosenfeld
• Re: Slow Calculating and optimizing
  • From: Roger Govier
• Re: counting weeks and days between dates
  • From: Peter T
• Re: Input box to allow user to select column
  • From: Marcusdmc
• Lookup Code
  • From: HAlssaqaf
• Re: Worksheet Calculate
  • From: Bill Renaud
• Re: FORM Drop Down issues
  • From: Dave
• Re: check for last day of month
  • From: Ron Rosenfeld
• Re: Writing hex numbers to a binary file
  • From: Fan924
• Re: Trouble with Sharing Addins
  • From: M. Authement
• Re: Loop to specific rows
  • From: Don Guillett
• Access VBA outside of Excel
  • From: rleavitt
• Re: VBA6 cores when hitting Reset button on the VBA IDE
  • From: Tom Med
• RE: Help! creating code for time to decimal calculations
  • From: Tom Ogilvy
• RE: Please help with Loop
  • From: AccessHelp
• Re: Excel creates massive files on calling vba workbook.save method
  • From: Bill Renaud
• Re: Accessing data stored in the worksheet (named range) in .xla file
  • From: JW
• Re: Using DEC2BIN(range,6) in VBA Code
  • From: Paul Black
• Re: Formulas not working
  • From: JW
• Re: counting weeks and days between dates
  • From: JW
• Help! creating code for time to decimal calculations
  • From: DW
• Re: Adding New Workbook
  • From: Bob Phillips
• Re: FORM Drop Down issues
  • From: Bob Phillips
• Re: FORM Drop Down issues
  • From: JW
• Re: Variable coding
  • From: Bob Phillips
• VBA6 cores when hitting Reset button on the VBA IDE
  • From: Tom Med
• Re: Using DEC2BIN(range,6) in VBA Code
  • From: Paul Black
• Re: Loop to specific rows
  • From: Omar
• Workbooks.Open Fails
  • From: Ed_P
• Re: counting weeks and days between dates
  • From: pilgrimm
• Variable coding
  • From: Dave
• RE: count if and format ranges
  • From: Matthew Pfluger
• Re: How to zero out non-contiguous ranges
  • From: Dean
• Re: counting weeks and days between dates
  • From: JW
• Re: counting weeks and days between dates
  • From: JW
• Re: Sub to clear range above n below diagonal
  • From: Marcus Schöneborn
• Re: Determine Workbook Mode
  • From: JW
• Help. Converting word to PDF
  • From: navin
• Re: Loop to specific rows
  • From: HI
• Re: Loop to specific rows
  • From: Don Guillett
• RE: Copy specific range from files in folder => enhancements needed
  • From: Joel
• counting weeks and days between dates
  • From: pilgrimm
• Re: VBA access to call stack
  • From: JE McGimpsey
• Re: ADO connection Open failure
  • From: Norman Yuan
• Re: Slow Calculating and optimizing
  • From: Jim Thomlinson
• Re: Rename an Array
  • From: Bob Phillips
• Re: LEFT(D2,3) but no spaces
  • From: yovation
• Re: Loop to specific rows
  • From: Omar
• RE: Simple Excel VBA Question
  • From: Dave
• Re: LEFT(D2,3) but no spaces
  • From: Don Guillett
• Re: Loop to specific rows
  • From: Don Guillett
• Re: LEFT(D2,3) but no spaces
  • From: JW
• Re: Loop to specific rows
  • From: Don Guillett
• LEFT(D2,3) but no spaces
  • From: yovation
• Re: Application.Caller Problems
  • From: Bob Phillips
• RE: How do I Import a spreed sheet
  • From: Joel
• Re: Adding leading zeroes to selected alphanumeric cells
  • From: TheObstacleIsThePath@xxxxxxxxx
• Adding leading zeroes to selected alphanumeric cells
  • From: TheObstacleIsThePath@xxxxxxxxx
• Re: Rename an Array
  • From: Bob Phillips
• Copy specific range from files in folder => enhancements needed
  • From: markx
• Re: Sub to clear range above n below diagonal
  • From: Max
• Re: Loop to specific rows
  • From: Omar
• Re: Worksheet Calculate
  • From: Bill Renaud
• Re: How to zero out non-contiguous ranges
  • From: Bill Renaud
• RE: copy unique values to validation list
  • From: Gary''s Student
• Re: Please help me find veryhidden sheets
  • From: J.W. Aldridge
• Re: Sub to clear range above n below diagonal
  • From: Marcus Schöneborn
• Re: Loop to specific rows
  • From: Omar
• RE: How do I Import a spreed sheet
  • From: jln via OfficeKB.com
• Re: Date Query
  • From: David
• Re: Sub to clear range above n below diagonal
  • From: Max
• Re: Loop to specific rows
  • From: Don Guillett
• Re: Loop to specific rows
  • From: HI
• Loop to specific rows
  • From: Omar
• Excel creates massive files on calling vba workbook.save method
  • From: Tom Med
• Re: Date Query
  • From: Bob Phillips
• Re: Using DEC2BIN(range,6) in VBA Code
  • From: Tom Ogilvy
• Re: userid in macro
  • From: mmccoog
• RE: Input box to allow user to select column
  • From: Tom Ogilvy
• Date Query
  • From: David
• Re: Using DEC2BIN(range,6) in VBA Code
  • From: Peter T
• RE: Syntax problems
  • From: Tom Ogilvy
• Re: Code for deleting rows?
  • From: fpd833
• Re: show / hide chart data
  • From: Jon Peltier
• Re: Using DEC2BIN(range,6) in VBA Code
  • From: Paul Black
• Re: Using DEC2BIN(range,6) in VBA Code
  • From: Tom Ogilvy
• RE: Need thoughts on integration approach
  • From: Matthew Pfluger
• RE: Syntax problems
  • From: penguat
• Input box to allow user to select column
  • From: Marcusdmc
• Re: Using DEC2BIN(range,6) in VBA Code
  • From: Paul Black
• Re: show / hide chart data
  • From: Jim
• Re: Using DEC2BIN(range,6) in VBA Code
  • From: Tom Ogilvy
• Re: Using DEC2BIN(range,6) in VBA Code
  • From: Tom Ogilvy
• RE: count if and format ranges
  • From: SLW612
• RE: How do I Import a spreed sheet
  • From: Joel
• Re: How to select Cell address between Specified Range
  • From: JW
• linking data from text file on ftp server to excel file
  • From: thread
• Re: Random Number Genarator
  • From: Bernd P
• Re: Using DEC2BIN(range,6) in VBA Code
  • From: Paul Black
• Re: Using DEC2BIN(range,6) in VBA Code
  • From: Paul Black
• Re: I want to Split & save the data in different workbook
  • From: T K
• Re: Slow Calculating and optimizing
  • From: Tom Ogilvy
• Using DEC2BIN(range,6) in VBA Code
  • From: Paul Black
• Re: Slow Calculating and optimizing
  • From: Roger Govier
• RE: Syntax problems
  • From: Tom Ogilvy
• RE: How do I Import a spreed sheet
  • From: jln via OfficeKB.com
• Slow Calculating and optimizing
  • From: kurt
• Sub to clear range above n below diagonal
  • From: Max
• Re: Sub Vs. Function
  • From: Chip Pearson
• Need thoughts on integration approach
  • From: Mr. Smith
• Re: Check overlap sunday/weekend
  • From: Bob Phillips
• Re: ADO connection Open failure
  • From: alexhatzisavas
• Re: Check overlap sunday/weekend
  • From: newbie@xxxxxxxxx
• Re: Remove VBA code
  • From: Bob Phillips
• Re: Check overlap sunday/weekend
  • From: Bob Phillips
• Check overlap sunday/weekend
  • From: newbie@xxxxxxxxx
• Re: Writing hex numbers to a binary file
  • From: sali
• copy unique values to validation list
  • From: buattis
• RE: VBA VLookup or equivalent
  • From: MuppetBaby
• Remove VBA code
  • From: andrew . stevens
• Re: Hidden formulas.2
  • From: Tim Williams
• Re: Automating Excel Macros
  • From: Tim Williams
• Re: double click macros
  • From: Mike
• Re: Writing hex numbers to a binary file
  • From: Fan924
• Re: double click macros
  • From: jack
• Re: Writing hex numbers to a binary file
  • From: JW
• Highlight a row
  • From: ABCD
• Re: double click macros
  • From: Alok
• double click macros
  • From: jack
• Re: Automating Excel Macros
  • From: Alok
• Re: how to change 1 line of data to multiple rows again...
  • From: Alok
• Automating Excel Macros
  • From: Alok
• Re: How to zero out non-contiguous ranges
  • From: Dean
• Writing hex numbers to a binary file
  • From: Fan924
• RE: Match two excel spread sheet using Macro
  • From: OssieMac
• how to change 1 line of data to multiple rows again...
  • From: Daniel M
• Re: How to zero out non-contiguous ranges
  • From: Bill Renaud
• Re: Finding the first blank cell in a row..in column "A"
  • From: JW
• How to zero out non-contiguous ranges
  • From: Dean
• Re: Please help with my code
  • From: Mark Ivey
• Re: Please help with my code
  • From: Mark Ivey
• Re: Worksheet Calculate
  • From: Bill Renaud
• Re: Please help me find veryhidden sheets
  • From: Dave Peterson
• Re: Please help me find veryhidden sheets
  • From: Dave Peterson
• Re: Worksheet Calculate
  • From: Doug Glancy
• Re: Range or Array?
  • From: Alan Beban
• Re: Open all workbooks inside a folder, run macro and save them?
  • From: Bill Renaud
• Re: Calculation state
  • From: Bill Renaud
• Re: AutoFit - Merged Cells
  • From: Bill Renaud
• Re: AutoFit - Merged Cells
  • From: Gord Dibben
• Re: button macro
  • From: Gord Dibben
• Re: Finding the first blank cell in a row..in column "A"
  • From: Gord Dibben
• Re: Browser Functions Problem - Solved!
  • From: Jaemun
• Re: Macro to stop data entry errors
  • From: dan dungan
• RE: Please help me find veryhidden sheets
  • From: OssieMac
• Re: Browser Functions Problem
  • From: Jaemun
• RE: Please help with Loop
  • From: OssieMac
• Re: Browser Functions Problem
  • From: Jaemun
• Browser Functions Problem
  • From: Jaemun
• Re: Can I "hide" the database login info?
  • From: RB Smissaert
• Re: Object varaible or With block variable not set?
  • From: Rick S.
• Re: Office (Excel) 2007 & 2003
  • From: Chip Pearson
• Re: Range or Array?
  • From: Chip Pearson
• Re: need macro to add 100 years to a selected range.
  • From: Chip Pearson
• Re: userid in macro
  • From: Chip Pearson
• Re: sorting column order
  • From: Otto Moehrbach
• Re: Open all workbooks inside a folder, run macro and save them?
  • From: Bill Renaud
• Re: Object varaible or With block variable not set?
  • From: Chip Pearson
• Re: Browser Functions Problem
  • From: Chip Pearson
• Re: Array Pointer
  • From: Chip Pearson
• Please help me find veryhidden sheets
  • From: J.W. Aldridge
• RE: count if and format ranges
  • From: SLW612
• Re: button macro
  • From: Ron de Bruin
• Re: Browser Functions Problem
  • From: Jaemun
• Re: Save Textbox "" value
  • From: JW
• Re: Finding the first blank cell in a row..in column "A"
  • From: Ron de Bruin
• Re: UserForms - how to return a value?
  • From: Jon Peltier
• RE: count if and format ranges
  • From: Matthew Pfluger
• Re: show / hide chart data
  • From: Jon Peltier
• RE: How do I Import a spreed sheet
  • From: Joel
• Re: ADO connection Open failure
  • From: Norman Yuan
• Re: ADO connection Open failure
  • From: Norman Yuan
• Re: Finding the first blank cell in a row..in column "A"
  • From: JW
• Re: Finding the first blank cell in a row..in column "A"
  • From: JW
• Re: Finding the first blank cell in a row..in column "A"
  • From: JW
• Re: Finding the first blank cell in a row..in column "A"
  • From: Gord Dibben
• EVALUATE Method and arguments
  • From: lumpus
• Object varaible or With block variable not set?
  • From: Rick S.
• Re: preserve last row while looking through a column of duplicate information
  • From: JW
• Finding the first blank cell in a row..in column "A"
  • From: Anthony B .
• Re: Access to hidden sheets
  • From: J.W. Aldridge
• Re: sorting by Contract #'s
  • From: Dave Peterson
• Re: Arrays and deletion
  • From: Dave Peterson
• Re: macro save as delete original file
  • From: Ron de Bruin
• Re: Browser Functions Problem
  • From: Chip Pearson
• preserve last row while looking through a column of duplicate information
  • From: Marcusdmc
• RE: VBA VLookup or equivalent
  • From: Carlos
• Re: Macro with input box to Select a column on active sheet
  • From: Marcusdmc
• Re: Random Number Genarator
  • From: JE McGimpsey
• How do I Import a spreed sheet
  • From: jln via OfficeKB.com
• RE: File Exist
  • From: jnf40
• Re: Code for deleting rows?
  • From: Ron de Bruin
• Re: Form
  • From: Bob Phillips
• Re: How can I lock the header cell so it's not alphabetized?
  • From: Gord Dibben
• RE: File Exist
  • From: Joel
• RE: Access to hidden sheets
  • From: PJFry
• RE: count if and format ranges
  • From: SLW612
• RE: for each next question
  • From: lumpus
• RE: Simple Macro task driving inexperience user crazy
  • From: ybkusz
• Re: Access to hidden sheets
  • From: J.W. Aldridge
• Re: INVOLVED - I Suck With User Forms...
  • From: RayportingMonkey
• Re: Macro with input box to Select a column on active sheet
  • From: Marcusdmc
• Re: Import binary file and convert to HEX data
  • From: Fan924
• Re: Sort columns by color
  • From: Bob Phillips
• Re: Sort columns by color
  • From: Gord Dibben
• Re: button macro
  • From: Gord Dibben
• Re: Browser Functions Problem
  • From: Chip Pearson
• Re: sorting by Contract #'s
  • From: Eric
• RE: File Exist
  • From: jnf40
• Re: Application inputbox, Range versus Cancel
  • From: Neal Zimm
• Access to hidden sheets
  • From: J.W. Aldridge
• Re: Printing with restrictions - VB
  • From: JE McGimpsey
• Re: button macro
  • From: Ron de Bruin
• Re: INVOLVED - I Suck With User Forms...
  • From: JW
• Re: Printing with restrictions - VB
  • From: Ron de Bruin
• Re: Need help with For-Next block
  • From: Nobody
• Re: INVOLVED - I Suck With User Forms...
  • From: RayportingMonkey
• Re: how do I get donor names to list by alphabet
  • From: Gord Dibben
• Re: Application inputbox, Range versus Cancel
  • From: Dave Peterson
• Re: INVOLVED - I Suck With User Forms...
  • From: JW
• Re: Formula to capture Document Properties
  • From: Gord Dibben
• Re: What is the #define equivalent?
  • From: Bob Phillips
• What is the #define equivalent?
  • From: Sing
• RE: Using validation to move cells
  • From: Michael
• Re: INVOLVED - I Suck With User Forms...
  • From: JW
• Redim with string input (MATLAB Zeros function)
  • From: Matthew Pfluger
• RE: Programmatically signing Excel VBA Macro
  • From: Thibaut Blanchin
• Re: MultiPage Control
  • From: Peter T
• Re: Remove Modules
  • From: Gord Dibben
• RE: INVOLVED - I Suck With User Forms...
  • From: RayportingMonkey
• RE: Programmatically signing Excel VBA Macro
  • From: bow
• Re: Remove Modules
  • From: RB Smissaert
• Re: how to copy first 2 characters only from prior cell
  • From: Don Guillett
• RE: Programmatically signing Excel VBA Macro
  • From: Thibaut Blanchin
• INVOLVED - I Suck With User Forms...
  • From: RayportingMonkey
• Re: Userform design - keyboard to move controls?
  • From: sebt
• Re: Detecting user cancel out of "File Open" input box
  • From: JW
• Re: Userform design - keyboard to move controls?
  • From: JW
• Userform design - keyboard to move controls?
  • From: sebt
• Re: command button on form to open sheets
  • From: JW
• Re: Application inputbox, Range versus Cancel
  • From: Neal Zimm
• Re: Please help with my code
  • From: AccessHelp
• Re: Detecting user cancel out of "File Open" input box
  • From: vrzimmerm
• Re: Arrays and deletion
  • From: Marcusdmc
• Re: Delete Rows based on cell values.
  • From: JW
• Re: Need Help Sorting
  • From: Dave Peterson
• Re: Delete Rows based on cell values.
  • From: Don Guillett
• Re: sorting by Contract #'s
  • From: Dave Peterson
• Delete Rows based on cell values.
  • From: Little Penny
• Re: printing list box in the user form
  • From: Dave Peterson
• Re: Detecting user cancel out of "File Open" input box
  • From: JW
• RE: Need help with For-Next block
  • From: Bob
• Re: Need help with For-Next block
  • From: Mike H
• Re: Arrays and deletion
  • From: Dave Peterson
• Re: Need help with For-Next block
  • From: JW
• Detecting user cancel out of "File Open" input box
  • From: vrzimmerm
• RE: Need help with For-Next block
  • From: Mike H
• Re: Arrays and deletion
  • From: Marcusdmc
• Re: Arrays and deletion
  • From: Marcusdmc
• RE: Keep User Form Active
  • From: Joel
• Re: Activating javascript with excel
  • From: jason36
• Re: Need help with For-Next block
  • From: JW
• Re: Displaying different worksheets based on user input
  • From: David
• Re: Displaying different worksheets based on user input
  • From: JW
• Re: Huge problem with comparing cells in different ranges and shee
  • From: Don Guillett
• Re: check for last day of month
  • From: JW
• RE: COUNTIF Query
  • From: Ladymuck
• Displaying different worksheets based on user input
  • From: David
• ADO connection Open failure
  • From: alexhatzisavas
• RE: COUNTIF Query
  • From: OssieMac
• Re: Copying Conditional Formatting from one cell to another
  • From: Peter T
• Re: how to change 1 line of data to multiple rows
  • From: Daniel M
• Re: check for last day of month
  • From: JW
• RE: COUNTIF Query
  • From: Ladymuck
• RE: Keep User Form Active
  • From: Brian
• Re: Keep User Form Active
  • From: Bob Phillips
• Re: combobox multiple columns
  • From: Bob Phillips
• Re: Remove Modules
  • From: RB Smissaert
• Re: Need help in creating dynamic drop down list in userform
  • From: Incidental
• Re: Using Excel VBA to run C function in DLL
  • From: lightaiyee
• Need help in creating dynamic drop down list in userform
  • From: kiwis
• Re: Displaying a Userform
  • From: David
• Re: Displaying a Userform
  • From: Bob Phillips
• Re: Convert excel formulas from worksheets into standalone ie. databas
  • From: Bob Phillips
• Re: Displaying a Userform
  • From: David
• Re: UserForms - how to return a value?
  • From: Bob Phillips
• Re: Displaying a Userform
  • From: Brotherwarren
• Interpreting some code in C
  • From: Laurence Lombard
• Displaying a Userform
  • From: David
• sorting column order
  • From: Brotherwarren
• RE: Simple Macro task driving inexperience user crazy
  • From: OssieMac
• Re: strange range access
  • From: tom taol
• Re: strange range access
  • From: Tim Williams
• Re: vba code to show specified sheets in list box
  • From: cavasta
• Re: Java Script
  • From: Tim Williams
• Re: Huge problem with comparing cells in different ranges and shee
  • From: Monoxito
• strange range access
  • From: tom taol
• Re: Pause Until Mouseclick?
  • From: Doug Glancy
• Re: ADDIN TOOLS
  • From: Randy Harmelink
• Re: how to change 1 line of data to multiple rows
  • From: Gary Keramidas
• Last Cell
  • From: Little Penny
• Re: Range or Array?
  • From: Alan Beban
• how to change 1 line of data to multiple rows
  • From: Daniel M
• VST"A" with Excel
  • From: anandb
• Re: UserForms - how to return a value?
  • From: Jon Peltier
• Re: printing list box in the user form
  • From: baha17@xxxxxxxxx
• RE: for each next question
  • From: JLGWhiz
• Re: Please help with my code
  • From: Mark Ivey
• Re: Using Excel VBA to run C function in DLL
  • From: Chip Pearson
• Re: How do I find all zip codes from the web?
  • From: JW
• Re: Compare and Highlight Differences
  • From: Mike Fogleman
• Re: Text Property of the Range Object
  • From: Gary''s Student
• Re: Range or Array?
  • From: Alan Beban
• RE: Worksheet.Change macro doesn't run in 2007
  • From: David Walker
• Re: UserForms - how to return a value?
  • From: Bob Phillips
• Re: Range or Array?
  • From: Bob Phillips
• RE: Import binary file and convert to HEX data
  • From: Joel
• Re: Excel Hyperlink to Open an External File
  • From: Mike Fogleman
• Re: check for last day of month
  • From: JW
• Re: check for last day of month
  • From: JW
• Re: Text Property of the Range Object
  • From: Charles Williams
• Workbook_Open not executing in Excel 2007
  • From: seanymac
• Re: XValues series breaks on disjoint ranges - but works fine in Excel 2007
  • From: Jon Peltier
• RE: Control buttons missing
  • From: Salah Gulay
• Re: UserForms - how to return a value?
  • From: Jon Peltier
• RE: Refreshing External Data Ranges
  • From: FSt1
• Re: show / hide chart data
  • From: Jon Peltier
• Re: need to stuff the array with the nth number of service groups
  • From: Janis
• RE: File Exist
  • From: Joel
• RE: Refreshing External Data Ranges
  • From: PJFry
• Re: In Excel 2007 how to switch off macro with a macro
  • From: Greg Lovern
• Re: need to stuff the array with the nth number of service groups
  • From: Rick Rothstein \(MVP - VB\)
• Re: need to stuff the array with the nth number of service groups
  • From: Rick Rothstein \(MVP - VB\)
• Re: check for last day of month
  • From: Don Guillett
• Re: The fastest way to count values in a range
  • From: Bob Phillips
• Re: check for last day of month
  • From: Don Guillett
• Re: check for last day of month
  • From: JW
• RE: Please help with my code
  • From: AccessHelp
• Re: Range or Array?
  • From: Alan Beban
• Re: How do I find all zip codes from the web?
  • From: IntricateFool
• need to stuff the array with the nth number of service groups
  • From: Janis
• RE: how to fill an array with the nth number in a list
  • From: Janis
• Re: In Excel 2007 how to switch off macro with a macro
  • From: Otto Moehrbach
• Re: How do I find all zip codes from the web?
  • From: JW
• RE: how to fill an array with the nth number in a list
  • From: Janis
• RE: how to fill an array with the nth number in a list
  • From: Janis
• Re: need to add 24 rows to each service group
  • From: Janis
• RE: File Exist
  • From: jnf40
• Re: vba code to show specified sheets in list box
  • From: JW
• Re: Text Property of the Range Object
  • From: JW
• Re: need to add 24 rows to each service group
  • From: Janis
• RE: how to fill an array with the nth number in a list
  • From: Janis
• Re: need to add 24 rows to each service group
  • From: JW
• how to fill an array with the nth number in a list
  • From: Janis
• Re: run-time error 1004 (How to FIll Down a Formula in a List)
  • From: Bill Renaud
• vba code to show specified sheets in list box
  • From: cavasta
• Re: The fastest way to count values in a range
  • From: avi
• Re: printing list box in the user form
  • From: baha17@xxxxxxxxx
• Re: need to add 24 rows to each service group
  • From: Janis
• Import binary file and convert to HEX data
  • From: Fan924
• Re: The fastest way to count values in a range
  • From: Bob Phillips
• Re: need to add 24 rows to each service group
  • From: Dave Peterson
• The fastest way to count values in a range
  • From: avi
• Re: printing list box in the user form
  • From: Dave Peterson
• Re: find entire string then row background red
  • From: amorrison2006@xxxxxxxxxxxxxx
• Re: Vlookup in multiple sheets
  • From: JW
• Re: countif using multiple criteria
  • From: Marcusdmc
• Re: Making all past dates bold, looping
  • From: JW
• Re: Making all past dates bold, looping
  • From: JW
• Re: XValues series breaks on disjoint ranges - but works fine in Excel 2007
  • From: laneer
• Macro to stop data entry errors
  • From: dan dungan
• Re: Sorting Backwards
  • From: Eric
• Re: VBA Event to Restore Lost Public Variables
  • From: M. Authement
• printing list box in the user form
  • From: baha17@xxxxxxxxx
• RE: Run-time error '1004'
  • From: Jim Thomlinson
• Re: countif using multiple criteria
  • From: Bernard Liengme
• countif using multiple criteria
  • From: Marcusdmc
• Vlookup in multiple sheets
  • From: Luis A. Vázquez
• Re: Determining if certain row # is blank
  • From: JE McGimpsey
• Re: Determining if certain row # is blank
  • From: Gary Keramidas
• RE: File Exist
  • From: Joel
• Re: Late Binding Problem between Excel and Project
  • From: Peter T
• Using Excel VBA to run C function in DLL
  • From: Sing
• Re: Late Binding Problem between Excel and Project
  • From: Jim Thomlinson
• Re: Open all workbooks inside a folder, run macro and save them?
  • From: Pman
• OLE Link bug introduced in Excel 2003 SP3
  • From: malcolm . nntp
• Re: Check Input for Valid Month
  • From: SLW612
• Re: How to check for duplicate values within a column
  • From: Onkl
• Re: Range or Array?
  • From: Alan Beban
• Re: Change cell reference type
  • From: Bob Phillips
• Re: Check Input for Valid Month
  • From: Bob Phillips
• RE: for each next question
  • From: lumpus
• Re: Open all workbooks inside a folder, run macro and save them?
  • From: Dave Peterson
• Re: Open all workbooks inside a folder, run macro and save them?
  • From: Pman
• list box based query
  • From: thread
• for each next question
  • From: lumpus
• Re: Cannot close a workbook in VBA due to Run-Time error '1004'
  • From: Tom Med
• Re: Open all workbooks inside a folder, run macro and save them?
  • From: Bob Phillips
• Re: userid in macro
  • From: Gary Keramidas
• How to check for duplicate values within a column
  • From: Andrew
• Re: userid in macro
  • From: Gary Keramidas
• Re: How can I insert a row in MS Excel using a formula?
  • From: Pman
• Re: Saving file when path is unknown
  • From: vrzimmerm
• Re: Range or Array?
  • From: Arvi Laanemets
• Re: Saving file when path is unknown
  • From: vrzimmerm
• Re: label control from macro
  • From: Bob Phillips
• Re: Huge problem with comparing cells in different ranges and shee
  • From: Don Guillett
• Cannot close a workbook in VBA due to Run-Time error '1004'
  • From: Tom Med
• Re: label control from macro
  • From: Peter T
• Re: Using a workbook name
  • From: JW
• Re: Using a workbook name
  • From: Bob Phillips
• Re: UserForms - how to return a value?
  • From: Bob Phillips
• Re: Range or Array?
  • From: Bob Phillips
• Re: How to get the mouse scroll-wheel to work in Excel VBA IDE?
  • From: Jon Peltier
• Re: label control from macro
  • From: Bob Phillips
• Re: UserForms - how to return a value?
  • From: Jon Peltier
• Re: label control from macro
  • From: Peter T
• Saving file when path is unknown
  • From: vrzimmerm
• Re: Nth Day Of Week For A Month
  • From: Niek Otten
• Re: label control from macro
  • From: sali
• Re: label control from macro
  • From: Peter T
• Re: Can macro return me to cell edit mode
  • From: Zone
• Re: label control from macro
  • From: sali
• Re: label control from macro
  • From: Bob Phillips
• Re: label control from macro
  • From: sali
• Re: label control from macro
  • From: Peter T
• Re: efficiency
  • From: Bob Phillips
• Re: UserForms - how to return a value?
  • From: Marcus Schöneborn
• Re: When I type an H in Excel, I need to to change to the colour red?
  • From: Peter T
• Re: comparing text strings
  • From: Bob Phillips
• Re: Colour Coded Shapes
  • From: Peter T
• Re: Creating a macro that reformats data in excel
  • From: Bob Phillips
• Re: label control from macro
  • From: Bob Phillips
• Re: UserForms - how to return a value?
  • From: Bob Phillips
• comparing text strings
  • From: CG Rosén
• label control from macro
  • From: sali
• Functions for manipulating arrays
  • From: Alan Beban
• Re: Moving Average of Array : Can use built-in functions?
  • From: Alan Beban
• UserForms - how to return a value?
  • From: Marcus Schöneborn
• Re: Colour Coded Shapes
  • From: Tim Williams
• Re: Incrementing a string
  • From: Rick Rothstein \(MVP - VB\)
• Colour Coded Shapes
  • From: brrahimah
• RE: Hidden formulas
  • From: Mick
• Re: Function breaker tool
  • From: Leung
• Re: Excel Hyperlink to Open an External File
  • From: tkt_tang
• Re: referencing a cell in a hidden sheet
  • From: Otto Moehrbach
• RE: Hidden formulas
  • From: JLGWhiz
• Re: efficiency
  • From: Otto Moehrbach
• Re: efficiency
  • From: Gary Keramidas
• Re: Cummulative Totals
  • From: Carlee
• Re: Cummulative Totals
  • From: Don Guillett
• Re: Cummulative Totals
  • From: Carlee
• Re: Cummulative Totals
  • From: Don Guillett
• Re: What is the Cause of this Error Q
  • From: Dave Peterson
• Re: Application inputbox, Range versus Cancel
  • From: Dave Peterson
• Cummulative Totals
  • From: Carlee
• Re: MultiPage Control
  • From: Patrick C. Simonds
• Re: MultiPage Control
  • From: Patrick C. Simonds
• Re: MultiPage Control
  • From: Peter T
• Re: Restrict Copy to Values only?
  • From: mepetey
• Re: Huge problem with comparing cells in different ranges and sheets
  • From: Don Guillett
• Re: Application inputbox, Range versus Cancel
  • From: Neal Zimm
• Re: VBA Code to Delete Part of Row with Data
  • From: manfareed
• Re: MultiPage Control
  • From: Patrick C. Simonds
• Re: VBA Code to Delete Part of Row with Data
  • From: Don Guillett
• Re: Incrementing a string
  • From: Rick Rothstein \(MVP - VB\)
• Re: VBA Code to Delete Part of Row with Data
  • From: manfareed
• Re: Incrementing a string
  • From: Rick Rothstein \(MVP - VB\)
• Re: On Error Resume Next question
  • From: Steve Yandl
• Re: Email button
  • From: Sean
• Re: Huge problem with comparing cells in different ranges and sheets
  • From: Don Guillett
• Re: Moving Average of Array : Can use built-in functions?
  • From: RB Smissaert
• Re: I need to suggest a value
  • From: Rick Rothstein \(MVP - VB\)
• Re: What is the Cause of this Error Q
  • From: Sean
• Re: What is the Cause of this Error Q
  • From: Dave Peterson
• Re: Very Simple Copy and Paste Sheet - Error
  • From: JLGWhiz
• Re: Double-Click to Change Interoir Color
  • From: Bill Renaud
• Re: On Error Resume Next question
  • From: my-wings
• Re: Moving Average of Array : Can use built-in functions?
  • From: Randy Harmelink
• Re: On Error Resume Next question
  • From: my-wings
• Re: MultiPage Control
  • From: Peter T
• Re: insert named cell in header
  • From: Gord Dibben
• MultiPage Control
  • From: Patrick C. Simonds
• Re: I need to suggest a value
  • From: Rick Rothstein \(MVP - VB\)
• Re: Incrementing a string
  • From: Francis Hookham
• Re: Incrementing a string
  • From: Francis Hookham
• Re: Color macro
  • From: Rick Rothstein \(MVP - VB\)
• Re: What is the Cause of this Error Q
  • From: Sean
• Re: determine the name of the selected pivot table
  • From: Debra Dalgleish
• Re: Double-Click to Change Interoir Color
  • From: Don Guillett
• Re: Simple If statement encounter error
  • From: Dave Peterson
• Re: What is the Cause of this Error Q
  • From: Dave Peterson
• RE: Entering a value into a cell with a formula or by tying the va
  • From: Gary''s Student
• determine the name of the selected pivot table
  • From: Tim879
• Re: Double-Click to Change Interoir Color
  • From: Little Penny
• Re: ARRAY QUERY
  • From: JingleRock
• Re: Moving Average of Array : Can use built-in functions?
  • From: Sing
• Re: Color macro
  • From: Little Penny
• RE: Double-Click to Change Interoir Color
  • From: Gary''s Student
• Re: Color macro
  • From: Rick Rothstein \(MVP - VB\)
• Re: Moving Average of Array : Can use built-in functions?
  • From: Randy Harmelink
• Double-Click to Change Interoir Color
  • From: Little Penny
• Re: Very Simple Copy and Paste Sheet - Error
  • From: Sean
• Re: Copy and Remame Sheet in active Workbook
  • From: Don Guillett
• Re: What is the Cause of this Error Q
  • From: Sean
• Re: What is the Cause of this Error Q
  • From: Dave Peterson
• Re: What is the Cause of this Error Q
  • From: Sean
• Re: How to delete CONSECUTIVE duplicate Rows
  • From: Bob Phillips
• Re: Simple If statement encounter error
  • From: Dave Peterson
• RE: Additem problem
  • From: OssieMac
• Re: What is the Cause of this Error Q
  • From: Dave Peterson
• Re: Additem problem
  • From: Dave Peterson
• Simple If statement encounter error
  • From: Sing
• Very Simple Copy and Paste Sheet - Error
  • From: Sean
• Re: remove items from listbox together with add item
  • From: Dave Peterson
• What is the Cause of this Error Q
  • From: Sean
• Re: Operator is in excel cells, how to reference it
  • From: Peter T
• Re: Late Binding Problem between Excel and Project
  • From: Peter T
• Moving Average of Array : Can use built-in functions?
  • From: Sing
• Additem problem
  • From: CG Rosén
• Re: A Property or Collection?
  • From: Bob Phillips
• Re: Incrementing a string
  • From: Bob Phillips
• Re: ARRAY QUERY
  • From: Alan Beban
• Re: Getting Started with Excel Programming
  • From: Bob Phillips
• Re: Worksheet events inactive
  • From: Bob Phillips
• Re: ARRAY QUERY
  • From: Alan Beban
• Re: ARRAY QUERY
  • From: JingleRock
• ARRAY QUERY
  • From: JingleRock
• Re: Color macro
  • From: Peter T
• Re: Color macro
  • From: Peter T
• Incrementing a string
  • From: Francis Hookham
• Re: remove items from listbox together with add item
  • From: baha17@xxxxxxxxx
• Re: MultiTab userform question
  • From: OssieMac
• Operator is in excel cells, how to reference it
  • From: hittingtime
• Re: How to use operator in cells
  • From: hittingtime
• Re: How to use operator in cells
  • From: hittingtime
• Re: How to use operator in cells
  • From: Gary Keramidas
• How to use operator in cells
  • From: hittingtime
• Re: Total number of cells
  • From: Gary Keramidas
• Total number of cells
  • From: seanbtrini
• Re: MultiTab userform question
  • From: Doug Glancy
• Re: Turning pages into PDF
  • From: Bill Renaud
• Re: run-time error 1004 (How to FIll Down a Formula in a List)
  • From: Bill Renaud
• Re: Turning pages into PDF
  • From: Dean
• Re: Turning pages into PDF
  • From: Dean
• Re: run-time error 1004
  • From: Bill Renaud
• Re: Color macro
  • From: Rick Rothstein \(MVP - VB\)
• Re: Turning pages into PDF
  • From: Bill Renaud
• Re: How to declare global variable in Excel VBA?
  • From: Jim Cone
• Re: MultiTab userform question
  • From: Patrick C. Simonds
• Re: How to get the mouse scroll-wheel to work in Excel VBA IDE?
  • From: Gary Keramidas
• How to get the mouse scroll-wheel to work in Excel VBA IDE?
  • From: Sing
• How to declare global variable in Excel VBA?
  • From: Sing
• Re: Use Keyboard with KeyDown and KeyUp
  • From: Leith Ross
• Re: Color macro
  • From: Dave Peterson
• Re: Clear Blank Cells
  • From: Dave Peterson
• Re: Turning pages into PDF
  • From: Dean
• Re: printing to a computed column
  • From: Dean
• Re: Color macro
  • From: Chip Pearson
• Re: Color macro
  • From: Gord Dibben
• Color macro
  • From: Little Penny
• MultiTab userform question
  • From: Patrick C. Simonds
• Re: Application inputbox, Range versus Cancel
  • From: Dave Peterson
• Re: Application inputbox, Range versus Cancel
  • From: Neal Zimm
• Re: save textbox as number wth Cint?
  • From: Karen53
• Re: Copy and Remame Sheet in active Workbook
  • From: Bjoern
• RE: Removing duplicate rows
  • From: Fred
• Re: Copy and Remame Sheet in active Workbook
  • From: Bjoern
• Re: Copy and Remame Sheet in active Workbook
  • From: Bjoern
• Re: Copy and Remame Sheet in active Workbook
  • From: Gord Dibben
• Re: How can I detect that the user canceled a close?
  • From: Doug Glancy
• Re: Copy and Remame Sheet in active Workbook
  • From: Don Guillett
• Copy and Remame Sheet in active Workbook
  • From: Bjoern
• Re: On Error Resume Next question
  • From: Dana DeLouis
• Re: Hiden sheet code - need access
  • From: Marcus Schöneborn
• Re: Chapter 5 professional Excel Development
  • From: Bob Phillips
• Re: How can I detect that the user canceled a close?
  • From: TomThumb
• Re: VBA Code to Delete Part of Row with Data
  • From: Don Guillett
• Re: How can I detect that the user canceled a close?
  • From: TomThumb
• Re: remove items from listbox together with add item
  • From: Dave Peterson
• Re: How can I detect that the user canceled a close?
  • From: TomThumb
• Use Keyboard with KeyDown and KeyUp
  • From: Donny
• Re: How to return a value from a function?
  • From: Sing
• Re: VBA Code to Delete Part of Row with Data
  • From: manfareed
• Re: remove items from listbox together with add item
  • From: baha17@xxxxxxxxx
• Re: Hiden sheet code - need access
  • From: Gary Keramidas
• Re: Hiden sheet code - need access
  • From: J.W. Aldridge
• Re: Find a string in a column
  • From: Don Guillett
• Re: How can I detect that the user canceled a close?
  • From: Doug Glancy
• Find a string in a column
  • From: Francis Hookham
• Re: How can I detect that the user canceled a close?
  • From: Doug Glancy
• Re: remove items from listbox together with add item
  • From: Dave Peterson
• Re: Hiden sheet code - need access
  • From: Gary Keramidas
• Re: Save copy on close ?
  • From: james . billy
• RE: Help with text length of cells
  • From: JLGWhiz
• Hiden sheet code - need access
  • From: J.W. Aldridge
• Re: How to return a value from a function?
  • From: Dana DeLouis
• Re: How to return a value from a function?
  • From: RB Smissaert
• How to return a value from a function?
  • From: Sing
• Save copy on close ?
  • From: J.W. Aldridge
• Re: Cell Value
  • From: seanbtrini
• Cell Value
  • From: seanbtrini
• Re: remove items from listbox together with add item
  • From: baha17@xxxxxxxxx
• Re: Changing For...Next index
  • From: Dana DeLouis
• Re: remove items from listbox together with add item
  • From: Dave Peterson
• Re: Application inputbox, Range versus Cancel
  • From: Dave Peterson
• Re: Change Cell contents
  • From: Dave Peterson
• remove items from listbox together with add item
  • From: baha17@xxxxxxxxx
• Re: How can I detect that the user canceled a close?
  • From: TomThumb
• Re: Apply macro
  • From: tomi12619
• Re: How can I detect that the user canceled a close?
  • From: Peter T
• Re: On Error Resume Next question
  • From: Trevor Shuttleworth
• Re: Late Binding Problem between Excel and Project
  • From: JJ
• Re: OpenText Method with "StartRow" as a variable
  • From: JingleRock
• Re: Chapter 5 professional Excel Development
  • From: lumpus
• RE: Help with text length of cells
  • From: Mike
• Re: VBA Event to Restore Lost Public Variables
  • From: Tim Zych
• Re: Writing array data to range object always writes 0's on worksheet
  • From: eholz1
• RE: Automated Search and Replace; Sheet2 to Sheet1
  • From: Joel
• Re: Writing array data to range object always writes 0's on worksheet
  • From: Gary Keramidas
• Re: Pivot Table Data format
  • From: Debra Dalgleish
• Re: Writing array data to range object always writes 0's on worksheet
  • From: eholz1
• Re: Creating a toolbar that works in Excel 2000 and 2007
  • From: Jon Peltier
• Re: XValues series breaks on disjoint ranges - but works fine in Excel 2007
  • From: Jon Peltier
• Re: VBA Event to Restore Lost Public Variables
  • From: Tim Zych
• Re: Writing array data to range object always writes 0's on worksheet
  • From: eholz1
• RE: Automated Search and Replace; Sheet2 to Sheet1
  • From: OssieMac
• Re: adding multiple spreadsheets onto one to sum up values
  • From: Jim Cone
• Re: Activating javascript with excel
  • From: Tim Williams
• Re: Writing array data to range object always writes 0's on worksheet
  • From: Jim Cone
• XValues series breaks on disjoint ranges - but works fine in Excel 2007
  • From: laneer
• Re: On Error Resume Next question
  • From: Steve Yandl
• Re: save textbox as number wth Cint?
  • From: Bob Phillips
• Writing array data to range object always writes 0's on worksheet
  • From: eholz1
• Re: On Error Resume Next question
  • From: night_writer
• Re: On Error Resume Next question
  • From: night_writer
• Re: Address Referencing
  • From: Chip Pearson
• Re: save textbox as number wth Cint?
  • From: Karen53
• Re: On Error Resume Next question
  • From: Trevor Shuttleworth
• Re: On Error Resume Next question
  • From: Bob Phillips
• Re: Chapter 5 professional Excel Development
  • From: Bob Phillips
• Re: Validation List
  • From: Doug Glancy
• Re: VBA Event to Restore Lost Public Variables
  • From: Bob Phillips
• Re: Import Web Page
  • From: Don Guillett
• Re: reference a cell within the header
  • From: Doug Glancy
• Re: Copy and Past Macro
  • From: Don Guillett
• Pivot Table Data format
  • From: Little Penny
• Re: Chapter 5 professional Excel Development
  • From: Don Guillett
• Re: save textbox as number wth Cint?
  • From: Bob Phillips
• Re: reference a cell within the header
  • From: NikkiB
• Re: Displaying A custom menu as a popup menu
  • From: Sandro
• Re: Clear print preview dotted lines?
  • From: Dave Peterson
• Re: Displaying A custom menu as a popup menu
  • From: Sandro
• Re: clear cells containing specific values
  • From: andresg1975
• Re: reference a cell within the header
  • From: Doug Glancy
• Re: clear cells containing specific values
  • From: JW
• On Error Resume Next question
  • From: night_writer
• Re: Displaying A custom menu as a popup menu
  • From: JW
• Chapter 5 professional Excel Development
  • From: lumpus
• Re: Copy and Past Macro
  • From: J.W. Aldridge
• Re: clear cells containing specific values
  • From: JW
• Re: Validation List
  • From: Doug Glancy
• Re: Change filename & auto_open
  • From: JW
• Re: clear cells containing specific values
  • From: JW
• Re: clear cells containing specific values
  • From: JW
• Re: How can I insert a row in MS Excel using a formula?
  • From: Don Guillett
• Re: VBA - array or collection literals?
  • From: Marcus Schöneborn
• Re: VBA Code to Delete Part of Row with Data
  • From: Don Guillett
• Re: printing to a computed column
  • From: Dave Peterson
• RE: macro for arranging by Contract #
  • From: Eric
• Re: code is not selecting correct range
  • From: Bob Umlas
• Re: complex IF statement
  • From: Alain Vaillancourt
• Re: save textbox as number wth Cint?
  • From: Dave Peterson
• printing to a computed column
  • From: Dean
• Re: Macro to delete rows
  • From: Tasha
• Re: save textbox as number wth Cint?
  • From: Bob Phillips
• Re: Copy and Past Macro
  • From: Bob Phillips
• Copy and Past Macro
  • From: J.W. Aldridge
• Aligning buttons
  • From: Keith
• Import Web Page
  • From: DaveM
• Re: Identify Last Cell and autofill last column
  • From: Leith Ross
• Re: select listbox item
  • From: Leith Ross
• Re: Validation List
  • From: Doug Glancy
• Re: reference a cell within the header
  • From: Doug Glancy
• Re: Validation List
  • From: Bob Phillips
• Re: How can I detect that the user canceled a close?
  • From: Doug Glancy
• Re: Pick value off sheet list for VBA code determination
  • From: Bill (Unique as my name)
• Type-ahead on multi-column combobox?
  • From: cwrm4
• Re: Turning pages into PDF
  • From: Bill Renaud
• Re: complex IF statement
  • From: JE McGimpsey
• Re: convert multicolumn/multirow table into two structured/formatt
  • From: Joel
• Re: complex IF statement
  • From: Alain Vaillancourt
• Re: Please help with coping cells
  • From: Bill Renaud
• Re: How can I detect that the user canceled a close?
  • From: Doug Glancy
• Re: Late Binding Problem between Excel and Project
  • From: Jim Thomlinson
• Pick value off sheet list for VBA code determination
  • From: Bill (Unique as my name)
• Re: How can I detect that the user canceled a close?
  • From: Peter T
• Can't set Application.Interactive
  • From: Josh Sale
• Re: How can I detect that the user canceled a close?
  • From: Peter T
• RE: Code modification?
  • From: fpd833
• Re: Macro to lock project from viewing
  • From: Dave Peterson
• Re: VBA Code to Delete Part of Row with Data
  • From: manfareed
• Re: Protected Object
  • From: Dave Peterson
• Re: VBA - array or collection literals?
  • From: Chip Pearson
• Re: How can I insert a row in MS Excel using a formula?
  • From: Pman
• RE: Code modification?
  • From: Barb Reinhardt
• Re: How can I detect that the user canceled a close?
  • From: TomThumb
• Re: How can I insert a row in MS Excel using a formula?
  • From: Don Guillett
• Code modification?
  • From: fpd833
• Re: Please help with coping cells
  • From: Al
• Re: How can I detect that the user canceled a close?
  • From: Doug Glancy
• Re: How can I insert a row in MS Excel using a formula?
  • From: Pman
• Re: Format affects precision?
  • From: Charles Williams
• Re: password protect a macro on a command button
  • From: Chip Pearson
• Macro to log .xls file names
  • From: vrzimmerm
• Re: convert multicolumn/multirow table into two structured/formatt
  • From: markx
• Re: Is there a formula to transpose numbers, e.g. change 36 to 63
  • From: RB Smissaert
• Macro to lock project from viewing
  • From: CH
• Format affects precision?
  • From: Caveman
• pivot cache in VBA
  • From: BenKoeppen
• Re: Is there a formula to transpose numbers, e.g. change 36 to 63
  • From: RB Smissaert
• Re: VBA Code to Delete Part of Row with Data
  • From: Don Guillett
• Re: Macro doesn't work when sheet protected
  • From: excel-chump
• Re: Coding Formula
  • From: Don Guillett
• Re: password protect a macro on a command button
  • From: dave caizley
• Re: Protected Object
  • From: Dave Peterson
• Re: collapse conditional formatting?
  • From: Dave Peterson
• Pivot Table Macro
  • From: Little Penny
• Re: Late Binding Problem between Excel and Project
  • From: Dave Peterson
• Re: Protected Object
  • From: JW
• RE: Array?
  • From: Joel
• Re: VBA Code to Delete Part of Row with Data
  • From: Symbiosis
• Re: Restrict Copy to Values only?
  • From: nickm687
• Re: Excel Hyperlink to Open an External File
  • From: Mike Fogleman
• Re: Array?
  • From: Symbiosis
• Re: password protect a macro on a command button
  • From: Chip Pearson
• Re: Macro to delete rows
  • From: Bob Phillips
• Array?
  • From: Symbiosis
• collapse conditional formatting?
  • From: Marcus Schöneborn
• Re: range names in macros - syntax again
  • From: Dean
• Re: Issue with mail merge date field
  • From: macropod
• Re: Calculating Counter
  • From: Roger Govier
• VBA - array or collection literals?
  • From: Marcus Schöneborn
• RE: Still struggling... how make a hyperlink not hot!
  • From: Darin Kramer
• Calculating Counter
  • From: kurt
• Re: range names in macros - syntax again
  • From: Rick Rothstein \(MVP - VB\)
• Re: How can I detect that the user canceled a close?
  • From: Peter T
• Re: Delete Data in Range -macro
  • From: ra
• Re: Checkboxes are duplicated over and over as emf in the Temp fol
  • From: Essenga_Tom
• RE: Change color of an autoshape
  • From: Joel
• Re: How can I detect that the user canceled a close?
  • From: Doug Glancy
• Which one is most powerful for developing a Excel Application
  • From: LeighSword
• Re: Interest Rate Help
  • From: Dana DeLouis
• Re: range names in macros - syntax again
  • From: Gary Keramidas
• Re: Please help with coping cells
  • From: Bill Renaud
• Re: range names in macros - syntax again
  • From: Dean
• RE: Change color of an autoshape
  • From: Ly
• RE: Change color of an autoshape
  • From: Ly
• Re: Turning pages into PDF
  • From: Bill Renaud
• Re: Interest Rate Help
  • From: lawdoggy
• Re: range names in macros - syntax again
  • From: JW
• Re : Excel Hyperlink to Open an External File
  • From: tkt_tang
• Re: run-time error 1004
  • From: Bill Renaud
• Re: Adding up unique numbers in a column
  • From: Alan Beban
• Re: Using 'i' to calculate public variables
  • From: Tim Williams
• range names in macros - syntax again
  • From: Dean
• Re: run-time error 1004
  • From: Bill Renaud
• Re: Is there a formula to transpose numbers, e.g. change 36 to 63
  • From: Gary Keramidas
• Re: Adding up unique numbers in a column
  • From: eliano
• Re: Late Binding Problem between Excel and Project
  • From: Dave Peterson
• Re: Using .AutoFill with a CELLS() reference
  • From: Dave Peterson
• Re: Need help by smart people!!!
  • From: Dave Peterson
• Re: Fin End of Used Range
  • From: ryguy7272
• Re: OpenText Method with "StartRow" as a variable
  • From: Jim Cone
• Late Binding Problem between Excel and Project
  • From: JJ
• Re: How can I detect that the user canceled a close?
  • From: TomThumb
• Re: Insert Row *below* button position - no need to copy formulas
  • From: Mike Fogleman
• Re: Still struggling... how make a hyperlink not hot!
  • From: JE McGimpsey
• Re: Passing a variable to UserForm_activate() event
  • From: Bob Phillips
• Re: Fin End of Used Range
  • From: Bob Phillips
• Re: How can I detect that the user canceled a close?
  • From: Peter T
• Re: Macro doesn't work when sheet protected
  • From: eliano
• Re: Need help by smart people!!!
  • From: Alain Vaillancourt
• Re: Mammoth Insert Formula
  • From: Bob Phillips
• Re: Need help by smart people!!!
  • From: Alain Vaillancourt
• Re: Is This Possible?
  • From: Corey
• Re: Time formats in A form AND in a worksheet
  • From: Corey
• Re: Using .AutoFill with a CELLS() reference
  • From: Greg Glynn
• Re: Finding the last one
  • From: Boris
• RE: Save Textbox into Named Range
  • From: Karen53
• Re: Simple Excel VBA Question
  • From: Bernd P
• Re: Advancing Cursor
  • From: Jim Cone
• Re: Simple Excel VBA Question
  • From: JE McGimpsey
• RE: calculate a correlation with ranges
  • From: Paco
• RE: Nested Do Until Loop
  • From: PJFry
• Re: Worksheet name with space problem
  • From: Dave Peterson
• Re: PasteSpecial Constant
  • From: JE McGimpsey
• Re: ot- link to fixes in office 2003 sp3
  • From: Jon Peltier
• Looping through different comboboxes in an excel sheet
  • From: steven . wright
• Re: Excel 2003 Macro in Excel 2000 Environment
  • From: Jon Peltier
• Re: how create pie chart reflecting data from multiple worksheets?
  • From: Jon Peltier
• Re: ot- link to fixes in office 2003 sp3
  • From: Gary Keramidas
• New Tips Website For Excel
  • From: AP
• Adding up unique numbers in a column
  • From: cebukid70
• OpenText Method with "StartRow" as a variable
  • From: JingleRock
• RE: calculate a correlation with ranges
  • From: Tom Ogilvy
• Wild Card?
  • From: fpd833
• Re: OK, I simplified my problem a bit, smart people sound off!!!!!
  • From: Joel
• Re: ot- link to fixes in office 2003 sp3
  • From: Jon Peltier
• Re: OK, I simplified my problem a bit, smart people sound off!!!!!
  • From: rfusee
• Re: Finding the last one
  • From: carlos_ray86
• Re: How can I insert a row in MS Excel using a formula?
  • From: Don Guillett
• Re: Organizing the VBE
  • From: Jim Cone
• Re: Avoiding a range in recalculation
  • From: Tom Ogilvy
• Re: Organizing the VBE
  • From: Dave Peterson
• Odd behavior of ActiveX ComboBox on worksheet
  • From: Greg Lovern
• Re: Delete Data in Range -macro
  • From: Tom Ogilvy
• Re: Programming a pivot table
  • From: Dick Kusleika
• Re: Checkboxes are duplicated over and over as emf in the Temp fol
  • From: Dave Peterson
• Re: Arrays and deletion
  • From: Dave Peterson
• Re: Still struggling... how make a hyperlink not hot!
  • From: james . billy
• Re: Batch deleting invalid defined names from a workbook
  • From: Dave Peterson
• Re: How do I round a date?
  • From: Dave Peterson
• Re: Still struggling... how make a hyperlink not hot!
  • From: james . billy
• Re: OK, I simplified my problem a bit, smart people sound off!!!!!
  • From: Joel
• Re: Still struggling... how make a hyperlink not hot!
  • From: Darin Kramer
• Re: Different results when running macro vs stepping into macro
  • From: Tim Williams
• Re: Still struggling... how make a hyperlink not hot!
  • From: JE McGimpsey
• Re: Character Limits within an Array?
  • From: Tim Williams
• Organizing the VBE
  • From: Randy
• Re: Activating javascript with excel
  • From: Tim Williams
• Re: Still struggling... how make a hyperlink not hot!
  • From: Darin Kramer
• Re: Avoiding a range in recalculation
  • From: james . billy
• Re: Excel automation: connecting to Excel
  • From: Tim Williams
• Re: Default Formats
  • From: Jim Cone
• Re: Code for deleting rows?
  • From: fpd833
• Re: Worksheet name with space problem
  • From: smxdev
• Re: Finding the last one
  • From: Boris
• Re: Find values over a certain amount
  • From: Captain Snuggles
• Re: Still struggling... how make a hyperlink not hot!
  • From: james . billy
• Re: Arrays and deletion
  • From: Marcusdmc
• Re: Importing an Excel file and prompting user for input
  • From: james . billy
• Re: OK, I simplified my problem a bit, smart people sound off!!!!!
  • From: james . billy
• Re: Arrays and deletion
  • From: Dave Peterson
• Still struggling... how make a hyperlink not hot!
  • From: Darin Kramer
• Re: Find values over a certain amount
  • From: Boris
• Re: Checkboxes are duplicated over and over as emf in the Temp fol
  • From: Tim Zych
• Finding the last one
  • From: carlos_ray86
• Find values over a certain amount
  • From: Captain Snuggles
• Re: Activating javascript with excel
  • From: Randy Harmelink
• Re: Delete Data in Range -macro
  • From: eliano
• Re: Delete Data in Range -macro
  • From: ra
• RE: Converting Hyperlink formulae to real hyperlink
  • From: Darin Kramer
• RE: Changing default menu item behavior
  • From: Tom Ogilvy
• Re: Delete Data in Range -macro
  • From: ra
• Re: convert multicolumn/multirow table into two structured/formatt
  • From: Joel
• Re: Font size and rows height for whole sheet
  • From: Peter T
• Re: time function
  • From: Dana DeLouis
• Re: Delete Data in Range -macro
  • From: JE McGimpsey
• RE: Refer to a specific element of a UDF created array in another
  • From: Laurie
• Re: Round to nearest month
  • From: Niek Otten
• Worksheet name with space problem
  • From: smxdev
• Re: Checkboxes are duplicated over and over as emf in the Temp folder
  • From: Tim Zych
• Re: Delete multiple rows
  • From: PJ Usher
• RE: Changing default menu item behavior
  • From: Mehul
• RE: CLICK THEN GO TO NAME ON SEPARATE WORKSHEET
  • From: dmshurley
• RE: Toggle Between SheetVeryHidden and SheetVisible
  • From: DBavirsha
• Delete Data in Range -macro
  • From: ra
• Re: Avoiding a range in recalculation
  • From: JE McGimpsey
• Re: Arrays and deletion
  • From: Marcusdmc
• Re: convert multicolumn/multirow table into two structured/formatt
  • From: markx
• RE: time function
  • From: catrrmg
• Solution: Calculating Time Elapsed Between Two Dates
  • From: crferguson@xxxxxxxxx
• Re: How do I round a date?
  • From: Bernard Liengme
• Re: Delete multiple rows
  • From: Gary Keramidas
• Re: How can I insert a row in MS Excel using a formula?
  • From: Pman
• Delete multiple rows
  • From: PJ Usher
• Re: GOTOs
  • From: Dana DeLouis
• Re: Interest Rate Help
  • From: Dana DeLouis
• Re: Regular expressions
  • From: Dick Kusleika
• Re: Different results when running macro vs stepping into macro
  • From: JE McGimpsey
• Re: Different results when running macro vs stepping into macro
  • From: Gary Keramidas
• Re: Different results when running macro vs stepping into macro
  • From: Marcus Schöneborn
• Different results when running macro vs stepping into macro
  • From: Ken Steinhoff
• ot- link to fixes in office 2003 sp3
  • From: Gary Keramidas
• Re: Font size and rows height for whole sheet
  • From: Zone
• Re: Want to change color based on Text, NOT using Conditional Form
  • From: Mitch
• Re: Font size and rows height for whole sheet
  • From: Zone
• Re: Auto Capitalization annoyance
  • From: Dave Peterson
• Re: Using .AutoFill with a CELLS() reference
  • From: Dave Peterson
• find "Cancellation" in column "A" and copy all data from Columns B-F onto another Sheet
  • From: bjohnson
• Re: Using .AutoFill with a CELLS() reference
  • From: Greg Glynn
• Re: Excel automation: connecting to Excel
  • From: Dave Peterson
• Re: Force VBA countif to find string, not value
  • From: c mateland
• Macro to Select
  • From: tc
• Re: F1 Help key in VBE problem...
  • From: c mateland
• Re: "How do I un/protect sheet by macro program with password
  • From: JE McGimpsey
• Shift+Del buffer
  • From: John Svendsen
• Re: "How do I un/protect sheet by macro program with password
  • From: JW
• Re: Using .AutoFill with a CELLS() reference
  • From: Greg Glynn
• RE: Creating a new column through a column sub-header
  • From: Joel
• Re: How can I detect that the user canceled a close?
  • From: Peter T
• RE: Change color of an autoshape
  • From: Joel
• Re: Passing a variable to UserForm_activate() event
  • From: Beertje
• Auto Capitalization annoyance
  • From: Tom Med
• Re: convert multicolumn/multirow table into two structured/formatt
  • From: Joel
• Re: Using .AutoFill with a CELLS() reference
  • From: Mike Fogleman
• Re: Using .AutoFill with a CELLS() reference
  • From: Bob Phillips
• RE: Inputbox used for password
  • From: Les Stout
• Re: Passing a variable to UserForm_activate() event
  • From: Bob Phillips
• Re: convert multicolumn/multirow table into two structured/formatted columns
  • From: markx
• Using .AutoFill with a CELLS() reference
  • From: Greg Glynn
• Re: VBE Coding tools
  • From: Bob Phillips
• Re: Auto run a macro
  • From: Zone
• Inputbox used for password
  • From: Les Stout
• Re: Time formats in A form AND in a worksheet
  • From: Rick Rothstein \(MVP - VB\)
• Re: SQL
  • From: Tim Zych
• Re: Excel automation: connecting to Excel
  • From: Jack
• Re: Is This Possible?
  • From: Corey
• Time formats in A form AND in a worksheet
  • From: Corey
• Re: Excel automation: connecting to Excel
  • From: Tim Williams
• Creating a new column through a column sub-header
  • From: naz
• RE: Worksheet.Change macro doesn't run in 2007
  • From: Jialiang Ge [MSFT]
• Re: If then, adding more choices
  • From: Tim Williams
• Excel automation: connecting to Excel
  • From: Jack
• Re: "How do I un/protect sheet by macro program with password
  • From: JW
• Re: Creating a toolbar that works in Excel 2000 and 2007
  • From: Jon Peltier
• Re: Conditional Formatting
  • From: JW
• Re: Lookup function in VBA
  • From: Fred Smith
• Re: Conditional Formatting
  • From: JW
• Re: from a cell to my textbox
  • From: JW
• Re: External Reference Data Updates.
  • From: Randy Harmelink
• Re: Regular expressions
  • From: Ron Rosenfeld
• Default Formats
  • From: meh2030
• Re: if fill color = this, then increment this cell by one
  • From: forbes
• Conditional Formatting
  • From: Newbrier
• Re: Regular expressions
  • From: Ron Rosenfeld
• Re: How to create a UDF to return an array of values with input variab
  • From: Chip Pearson
• Is this type of VBA Logic possible? Delete Unique Row
  • From: yms . yfki
• Re: Lookup function in VBA
  • From: Dave Peterson
• Re: Help with TEXTBOX control
  • From: Dave Peterson
• Re: Need help by smart people!!!
  • From: Dave Peterson
• RE: CLICK THEN GO TO NAME ON SEPARATE WORKSHEET
  • From: Gary''s Student
• RE: Worksheet.Change macro doesn't run in 2007
  • From: David Walker
• Re: Regular expressions
  • From: Ron Rosenfeld
• Re: Regular expressions
  • From: Dick Kusleika
• Re: Interest Rate Help
  • From: Chuck
• Re: Error - SendKeys in between a macro
  • From: Dave D-C
• RE: CLICK THEN GO TO NAME ON SEPARATE WORKSHEET
  • From: dmshurley
• Lookup function in VBA
  • From: Fred Smith
• Re: External Reference Data Updates.
  • From: Dick Kusleika
• Re: Programming a pivot table
  • From: Dick Kusleika
• Re: Changing For...Next index
  • From: Alan Beban
• Re: How to refer to the specified sheet in the workbook?
  • From: Dick Kusleika
• Re: Need help by smart people!!!
  • From: Dave Peterson
• Re: How to create a UDF to return an array of values with input variab
  • From: Dick Kusleika
• Re: Drop Down Lists
  • From: Otto Moehrbach
• Re: if fill color = this, then increment this cell by one
  • From: Dick Kusleika
• Re: Need help by smart people!!!
  • From: Dick Kusleika
• Re: Concatenation prob
  • From: Dick Kusleika
• Re: Need help by smart people!!!
  • From: Moose
• Re: Code for deleting rows?
  • From: Ron de Bruin
• Re: GOTOs
  • From: Otto Moehrbach
• Re: Auto number formatting
  • From: Gord Dibben
• if fill color = this, then increment this cell by one
  • From: forbes
• Re: Want to change color based on Text, NOT using Conditional Formatin
  • From: JW
• Re: Data validation list type
  • From: Darren Hill
• Re: Insert Varying # Rows
  • From: JW
• How to refer to the specified sheet in the workbook?
  • From: Jack
• Re: How do I Run Macro on Opening if user is not the "Last Saved B
  • From: Bob Phillips
• Re: Changing For...Next index
  • From: Bob Phillips
• RE: ListBox & TextBox Save
  • From: Karen53
• UDF Not Calculating Properly
  • From: Darren Hill
• Iseries - Transfer to
  • From: revinfo
• Re: Odd Lookup Formula
  • From: Gary Keramidas
• RE: ListBox & TextBox Save
  • From: Joel
• Re: Changing For...Next index
  • From: Alan Beban
• Re: Navigation
  • From: bodhisatvaofboogie
• Re: Odd Lookup Formula
  • From: Steve
• Re: GOTOs
  • From: joeu2004
• ListBox & TextBox Save
  • From: Karen53
• Re: Generate list of numbers between start and end value
  • From: Dana DeLouis
• Re: Arrays and deletion
  • From: Dave Peterson
• RE: VBA help w/ look & fill in data
  • From: Cam
• Re: Odd Lookup Formula
  • From: Steve
• Excel cores when trying to close a workbook after exporting+removing VBA modules
  • From: Tom Med
• RE: Nested Do Until Loop
  • From: Jim Thomlinson
• Re: Nested Do Until Loop
  • From: Bob Phillips
• RE: VBA help w/ look & fill in data
  • From: Cam
• Re: Copying select data frm one workbook to multiple workbooks & save
  • From: Ron de Bruin
• Re: Odd Lookup Formula
  • From: Steve
• Re: Odd Lookup Formula
  • From: JW
• RE: Nested Do Until Loop
  • From: Jim Thomlinson
• Re: Navigation
  • From: bodhisatvaofboogie
• Re: Interest Rate Help
  • From: Ron Rosenfeld
• Re: Removing with formula
  • From: Bob Phillips
• Odd Lookup Formula
  • From: Steve
• Re: Save only the code from a Sheet?
  • From: Bob Phillips
• RE: convert multicolumn/multirow table into two structured/formatted c
  • From: Joel
• Re: How do I Run Macro on Opening if user is not the "Last Saved B
  • From: Steve Yandl
• Re: finding first empty cell
  • From: Tom Ogilvy
• Re: Looping thru multiple files to produce a consolidated summary by Code
  • From: Zone
• Removing with formula
  • From: yovation
• Re: find entire string then row background red
  • From: Tom Ogilvy
• RE: Help with insert a row
  • From: Al
• Re: Converting WeekNumber to Weekday
  • From: Rick Rothstein \(MVP - VB\)
• Re: Converting WeekNumber to Weekday
  • From: Ron Rosenfeld
• RE: Dynamic sorting and selection of data
  • From: Joel
• RE: Dynamic sorting and selection of data
  • From: Joel
• Re: On File Open
  • From: JE McGimpsey
• RE: Execute Worksheet_Change before recalculation
  • From: BigJimmer
• RE: format date
  • From: Vergel Adriano
• macro cell add a comma
  • From: BrianMultilLanguage
• Re: Data validation list type
  • From: Ron Coderre
• Re: How do I Run Macro on Opening if user is not the "Last Saved B
  • From: MikeZz
• RE: Dynamic sorting and selection of data
  • From: Joel
• Re: Execute Worksheet_Change before recalculation
  • From: JE McGimpsey
• Open csv file with all values as text
  • From: bony_tony
• Re: How do I Run Macro on Opening if user is not the "Last Saved B
  • From: MikeZz
• Opening Hyperlinks
  • From: Nicki
• Re: solver add in / excel solver / vba
  • From: Dana DeLouis
• Arrays and deletion
  • From: Marcusdmc
• Re: finding first empty cell
  • From: JW
• Re: Compare Rows on different Worksheets and Output Difference's t
  • From: Tom Ogilvy
• Re: find entire string then row background red
  • From: JW
• Re: GOTOs
  • From: JE McGimpsey
• Replacing a module by coding in VBA
  • From: mathieu936
• GOTOs
  • From: Otto Moehrbach
• Re: Interest Rate Help
  • From: Ron Rosenfeld
• format date
  • From: ABCD
• Re: Problems with Pasting Array contents in cells
  • From: Otto Moehrbach
• RE: Converting Hyperlink formulae to real hyperlink
  • From: Darin Kramer
• Re: How can I insert a row in MS Excel using a formula?
  • From: Pman
• Interest Rate Help
  • From: lawdoggy
• Re: How can I insert a row in MS Excel using a formula?
  • From: Don Guillett
• Re: Compare Rows on different Worksheets and Output Difference's to ot
  • From: dids72
• Re: Excel coredumps with each call to a dll - for function RegQueryValueExA in advapi32.dll
  • From: Tom Med
• convert multicolumn/multirow table into two structured/formatted columns => feasible?
  • From: markx
• Re: How can I insert a row in MS Excel using a formula?
  • From: Pman
• RE: find entire string then row background red
  • From: Tom Ogilvy
• Re: match two excel spread sheet using macro
  • From: Otto Moehrbach
• Find cell contents within a data matrix
  • From: vrzimmerm
• Re: Macro with input box to Select a column on active sheet
  • From: Marcusdmc
• Re: Reference for German Code
  • From: Jim Rech
• Re: Macro with input box to Select a column on active sheet
  • From: Marcusdmc
• Reference for German Code
  • From: robkiolbasa
• RE: Macro with input box to Select a column on active sheet
  • From: Tom Ogilvy
• Re: Remove Item from Listbox by Item Name
  • From: Doug Glancy
• Re: workbook level name vs worksheet level name
  • From: Charles Williams
• RE: Dynamic sorting and selection of data
  • From: Reluctant_Programmer
• RE: Compare Rows on different Worksheets and Output Difference's to ot
  • From: Tom Ogilvy
• find entire string then row background red
  • From: amorrison2006@xxxxxxxxxxxxxx
• Re: VBA way to access of the cell being calculated?
  • From: Marcus Schöneborn
• Macro with input box to Select a column on active sheet
  • From: Marcusdmc
• Re: finding first empty cell
  • From: Tom Ogilvy
• Compare Rows on different Worksheets and Output Difference's to other Worksheets.
  • From: dids72
• Opening a Hyperlink using macros
  • From: prutherford18
• Re: finding first empty cell
  • From: vrzimmerm
• Re: finding first empty cell
  • From: Charles Chickering
• VBA way to access of the cell being calculated?
  • From: Marcus Schöneborn
• RE: FileSearch error 1004
  • From: OssieMac
• RE: FileSearch error 1004
  • From: Charles Chickering
• Re: finding first empty cell
  • From: JW
• Re: if todays date is in the month of january, then specific drop down list, if feb, another list, etc
  • From: Dave Peterson
• finding first empty cell
  • From: vrzimmerm
• Re: Looping thru multiple files to produce a consolidated summary by Code
  • From: u473
• Re: F2 Cells in a column
  • From: JW
• Converting Hyperlink formulae to real hyperlink
  • From: Darin Kramer
• Re: Flickering screen while processing macro
  • From: Ron Coderre
• Re: Looping thru multiple files to produce a consolidated summary
  • From: u473
• Re: File freezing - Trust access to Visual Basic Project setting
  • From: Jim Rech
• Restrict Copy to Values only?
  • From: nickm687
• if todays date is in the month of january, then specific drop down list, if feb, another list, etc
  • From: bjohnson
• Re: Grouping function in VBA Excel
  • From: Mike Fogleman
• Error - SendKeys in between a macro
  • From: Dileep Chandran
• Re: Full proof UK postcode validation
  • From: Rick Rothstein \(MVP - VB\)
• Re: Change document properties
  • From: Bob Phillips
• Re: Changing For...Next index
  • From: Bob Phillips
• RE: Worksheet.Change macro doesn't run in 2007
  • From: Jialiang Ge [MSFT]
• Re: Change document properties
  • From: Suter
• RE: Converting Text to a hyperlink
  • From: Darin Kramer
• Re: Change document properties
  • From: Zone
• Re: Full proof UK postcode validation
  • From: Ed Peters
• Re: Full proof UK postcode validation
  • From: Ed Peters
• Change document properties
  • From: Suter
• Re: data on top
  • From: k743911@xxxxxxxxx
• RE: Converting Text to a hyperlink
  • From: Darin Kramer
• Re: Open "Find" Userform
  • From: Axel
• Open "Find" Userform
  • From: Axel
• Re: Remove Item from Listbox by Item Name
  • From: Randy
• Open "Find" Userform
  • From: Axel
• Re: Turning pages into PDF
  • From: Dean
• Re: Remove Item from Listbox by Item Name
  • From: Doug Glancy
• Remove Item from Listbox by Item Name
  • From: Randy
• RE: VBA help w/ look & fill in data
  • From: Joel
• Re: Generate list of numbers between start and end value
  • From: excelent
• Re: Changing For...Next index
  • From: Alan Beban
• RE: Worksheet.Change macro doesn't run in 2007
  • From: David Walker
• Re: Subtract 5 minutes from Now()
  • From: Chuck
• Re: Subtract 5 minutes from Now()
  • From: Chuck
• Re: Need macro to add 100 years to a cell's date
  • From: JE McGimpsey
• RE: Excel phone number formula
  • From: Michael Bowers
• Re: Changing For...Next index
  • From: Jim Thomlinson
• Re: Changing For...Next index
  • From: Alan Beban
• Print to PDF file in Excel or Access
  • From: maximilianchu
• Re: Spread macro
  • From: Jim Cone
• Re: Here's one for the masters
  • From: Dave Peterson
• Re: Subtract 5 minutes from Now()
  • From: Ron Coderre
• Re: Subtract 5 minutes from Now()
  • From: Ron Coderre
• Re: Subtract 5 minutes from Now()
  • From: Don Guillett
• Subtract 5 minutes from Now()
  • From: Chuck
• Re: How can I insert a row in MS Excel using a formula?
  • From: Mike Fogleman
• Re: Count?
  • From: Mike Fogleman
• Re: Count?
  • From: Steve Yandl
• Re: How can I insert a row in MS Excel using a formula?
  • From: Don Guillett
• Excel automation: Problem with inserting an array of formulas into a range
  • From: mariuskrogh
• Re: Full proof UK postcode validation
  • From: Rick Rothstein \(MVP - VB\)
• Re: Using VBA - create array - parse values - find differences
  • From: eholz1
• Re: Changing For...Next index
  • From: Tim Zych
• RE: Using VBA - create array - parse values - find differences
  • From: Charles Chickering
• Re: match two excel spread sheet using macro
  • From: Lillian Lian
• Re: match two excel spread sheet using macro
  • From: Lillian Lian
• Re: match two excel spread sheet using macro
  • From: Lillian Lian
• Frequent Crashes with User Forms
  • From: Randy
• Re: Changing For...Next index
  • From: Bob Phillips
• Using VBA - create array - parse values - find differences
  • From: eholz1
• Re: Excel coredumps with each call to a dll - for function RegQueryValueExA in advapi32.dll
  • From: Chip Pearson
• Changing For...Next index
  • From: Alan Beban
• Re: Histogram
  • From: Mike Middleton
• Re: VLookup Function in VB
  • From: DG
• Re: Listbox Formating
  • From: Dave Peterson
• Re: VLookup Function in VB
  • From: DG
• Re: VLookup Function in VB
  • From: Bob Phillips
• Re: Delete row
  • From: JW
• Re: VLookup Function in VB
  • From: Dave Peterson
• RE: Coding needed for shaded cells
  • From: Keithlo
• Re: Opening .xls files
  • From: Jim Rech
• Re: Opening .xls files
  • From: JW
• Re: F2 Cells in a column
  • From: Darin Kramer
• RE: VBA help w/ look & fill in data
  • From: Joel
• RE: Coding needed for shaded cells
  • From: JCarter
• Re: F2 Cells in a column
  • From: JW
• Re: Disable Right Click
  • From: JW
• Re: Full proof UK postcode validation
  • From: Ed Peters
• VLookup Function in VB
  • From: DG
• Re: Generate list of numbers between start and end value
  • From: Sinner
• Re: F1 Help key in VBE problem...
  • From: George Nicholson
• RE: Coding needed for shaded cells
  • From: Keithlo
• Re: Generate list of numbers between start and end value
  • From: Sinner
• RE: VBA help w/ look & fill in data
  • From: Cam
• Opening .xls files
  • From: vrzimmerm
• Re: Opening Hyperlink
  • From: prutherford18
• Converting Text to a hyperlink
  • From: Darin Kramer
• Re: Opening Hyperlink
  • From: prutherford18
• Re: Unique data...!
  • From: Thyag
• Re: match two excel spread sheet using macro
  • From: Otto Moehrbach
• Re: Looping thru multiple files to produce a consolidated summary by Code
  • From: u473
• Re: Save only the code from a Sheet?
  • From: christopher.allen
• Re: Excel coredumps with each call to a dll - for function RegQueryValueExA in advapi32.dll
  • From: Tom Med
• Delete row
  • From: ABCD
• RE: Coding needed for shaded cells
  • From: JCarter
• RE: VBA help w/ look & fill in data
  • From: Joel
• Re: match two excel spread sheet using macro
  • From: Lillian Lian
• Re: Excel coredumps with each call to a dll - for function RegQueryValueExA in advapi32.dll
  • From: Tom Med
• RE: move offsetting values
  • From: Don S
• RE: Coding needed for shaded cells
  • From: Keithlo
• Re: Disable Right Click
  • From: Jim Rech
• Checking which row is selected
  • From: John in Wembley
• Excel coredumps with each call to a dll - for function RegQueryValueExA in advapi32.dll
  • From: Tom Med
• RE: Coding needed for shaded cells
  • From: JCarter
• RE: move offsetting values
  • From: Keithlo
• Excel 2007 - Using a Named Ranges in lieu of Cell References
  • From: Rgreenspan
• RE: VBA help w/ look & fill in data
  • From: Cam
• RE: Unique data...!
  • From: Jim Thomlinson
• Re: Changing Chinese Font in Excel (The Answer!)
  • From: Bill Renaud
• To Do List
  • From: Luis A. Vázquez
• RE: move offsetting values
  • From: Don S
• Re: Unique data...!
  • From: Bob Phillips
• Re: permutations/combinations
  • From: Bernard Liengme
• Pivot Tables - DisplayEmptyColumn question
  • From: Henry
• Re: Macro to delete rows
  • From: Tasha
• Re: Copy only basic number without dollar sign or commas (or cell form
  • From: StargateFanFromWork
• F1 Help key in VBE problem...
  • From: c mateland
• Re: Run Time Error 6028: Help?
  • From: Jim Cone
• RE: move offsetting values
  • From: Keithlo
• permutations/combinations
  • From: joe . engel
• Re: Delete Row 22 in all Sheets
  • From: Don Guillett
• Unique data...!
  • From: Thyag
• Re: Deleting Blank rows as a result of a formula
  • From: Bob Phillips
• Re: Deleting Blank rows as a result of a formula
  • From: Don Guillett
• Re: Save only the code from a Sheet?
  • From: Bob Phillips
• Re: Macro to delete rows
  • From: Bob Phillips
• Re: F2 Cells in a column
  • From: Darin Kramer
• Copy a File 'n' Times, New Filenames are "File_n.xls"
  • From: zwestbrook
• Save only the code from a Sheet?
  • From: christopher.allen
• Re: Changing Chinese Font in Excel
  • From: Bill Renaud
• Re: Combobox on Quick Access Toolbar
  • From: Randy
• Re: Delete Row 22 in all Sheets
  • From: Randy
• Re: No cancel on input
  • From: Luis A. Vázquez
• Re: Macro to delete rows
  • From: Bill Renaud
• Re: Changing Chinese Font in Excel
  • From: Zone
• Re: solver add in / excel solver / vba
  • From: Jon Peltier
• Delete Row 22 in all Sheets
  • From: Sean
• Use loop to re-arrange:
  • From: Ardy
• Re: Run Time Error 6028: Help?
  • From: Jim Cone
• Re: vba
  • From: Otto Moehrbach
• Re: match two excel spread sheet using macro
  • From: Otto Moehrbach
• RE: CLICK THEN GO TO NAME ON SEPARATE WORKSHEET
  • From: dmshurley
• Re: If then, adding more choices
  • From: Philip Reece-Heal
• Re: If then, adding more choices
  • From: JW
• Re: Count if begins with AAA
  • From: JW
• Re: Disable Right Click
  • From: JW
• Re: Disable Right Click
  • From: JW
• RE: VBA help w/ look & fill in data
  • From: Joel
• Re: Full proof UK postcode validation
  • From: Peter T
• Re: match two excel spread sheet using macro
  • From: Lillian Lian
• Re: Macro Using Cell Data for .Log name
  • From: JW
• Opening Hyperlink
  • From: Nicki
• Re: Macro Using Cell Data for .Log name
  • From: JW
• RE: UsedRange and Ctrl-Shift-End Mystery
  • From: Jim Thomlinson
• Re: Run Time Error 6028: Help?
  • From: Jim Cone
• Re: Macro Using Cell Data for .Log name
  • From: JE McGimpsey
• Selection
  • From: tc
• RE: VBA help w/ look & fill in data
  • From: Cam
• Re: F2 Cells in a column
  • From: JW
• Re: Compound IF statement
  • From: Di
• Re: Macro to delete rows
  • From: Tasha
• Re: No cancel on input
  • From: JW
• RE: F2 Cells in a column
  • From: Darin Kramer
• vba
  • From: paul
• Re: F2 Cells in a column
  • From: JW
• Re: Save As
  • From: JW
• Re: Save As
  • From: JW
• RE: UsedRange and Ctrl-Shift-End Mystery
  • From: LarryP
• RE: need help with nested for-next loops
  • From: rpw
• Save As
  • From: tc
• RE: data on top
  • From: Gary''s Student
• F2 Cells in a column
  • From: Darin Kramer
• RE: UsedRange and Ctrl-Shift-End Mystery
  • From: Jim Thomlinson
• No cancel on input
  • From: Luis A. Vázquez
• RE: Need help using date as an index
  • From: Vergel Adriano
• Re: match two excel spread sheet using macro
  • From: Otto Moehrbach
• Re: Generate list of numbers between start and end value
  • From: Dana DeLouis
• Re: Compound IF statement
  • From: Otto Moehrbach
• Re: Copy only basic number without dollar sign or commas (or cell form
  • From: JE McGimpsey
• Re: UsedRange and Ctrl-Shift-End Mystery
  • From: PCLIVE
• 'BeforeClose' code problems:book won't close if more than one book is open
  • From: Ed from AZ
• Re: Scripting Dictionary to hold User Defined Type
  • From: Dana DeLouis
• Re: Copy only basic number without dollar sign or commas (or cell form
  • From: StargateFanFromWork
• Re: Importing CSV just like Excel opening CSV
  • From: Bob
• Re: Hide rows if...
  • From: JE McGimpsey
• Re: Scripting Dictionary to hold User Defined Type
  • From: Jim Rech
• Re: Call a file name from within string
  • From: JE McGimpsey
• Re: weird bug - Excel 2007
  • From: Ilia
• data in a column
  • From: ABCD
• Re: match two excel spread sheet using macro
  • From: Lillian Lian
• Re: Full proof UK postcode validation
  • From: Rick Rothstein \(MVP - VB\)
• Scripting Dictionary to hold User Defined Type
  • From: billbell52
• data on top
  • From: k743911@xxxxxxxxx
• File open - .xls not recognized as spreadsheet
  • From: vrzimmerm
• Re: Formula for the last day of the month
  • From: Bob Phillips
• Re: Last day of the month
  • From: Bob Phillips
• Re: Password protect worksheets
  • From: Jock
• Re: Generate list of numbers between start and end value
  • From: excelent
• Re: Importing CSV just like Excel opening CSV
  • From: papou
• Re: Full proof UK postcode validation
  • From: Mike H
• Looping thru multiple files to produce a consolidated summary by Code
  • From: u473
• Re: Help with insert a row
  • From: Al
• Re: Call a file name from within string
  • From: etradeguru
• Re: Looping thru multiple files to produce a consolidated summary by Code
  • From: Zone
• Compare multiple column rows on different worksheets.
  • From: dids72
• Re: Password protect worksheets
  • From: Dave Peterson
• Re: Call a file name from within string
  • From: JE McGimpsey
• Re: Date Format
  • From: Dave Peterson
• Re: Compound IF statement
  • From: Di
• Re: How do I stop 2nd row deletion
  • From: Jon Peltier
• Re: Looping thru multiple files to produce a consolidated summary
  • From: Joel
• Re: solver add in / excel solver / vba
  • From: Jon Peltier
• Re: Looping thru multiple files to produce a consolidated summary
  • From: OssieMac
• RE: Looping thru multiple files to produce a consolidated summary by C
  • From: Joel
• Call a file name from within string
  • From: etradeguru
• Re: Looping thru multiple files to produce a consolidated summary by Code
  • From: Zone
• Re: Looping thru multiple files to produce a consolidated summary by Code
  • From: u473
• Re: Extracting numbers from text string
  • From: Ron Rosenfeld
• Re: Error on E-Mailing Q
  • From: Sean
• Re: Looping thru multiple files to produce a consolidated summary by Code
  • From: Zone
• RE: vba coding
  • From: Joel
• Re: caption of Triplestate buttons
  • From: Mike Fogleman
• Re: Changing Chinese Font in Excel
  • From: Zone
• vba coding
  • From: paul
• Excel app as web app
  • From: Peter Hemmingsen
• Re: Full proof UK postcode validation
  • From: Rick Rothstein \(MVP - VB\)
• Re: Histogram
  • From: avi
• Re: new version# when opening file
  • From: Bob Phillips
• Histogram
  • From: rajeevbhatt17
• Re: Date Format
  • From: rajeevbhatt17
• Re: Full proof UK postcode validation
  • From: Bob Phillips
• Re: Full proof UK postcode validation
  • From: Peter T
• Date Format
  • From: cstang999
• Re: Alignment of Figures
  • From: Paul Black
• Re: Changing Chinese Font in Excel
  • From: Bill Renaud
• Re: Deleting Duplicate Rows
  • From: Alan Beban
• Re: Generate list of numbers between start and end value
  • From: Sinner
• Re: Help with insert a row
  • From: Bill Renaud
• Re: Help on Macro
  • From: Bill Renaud
• Re: Generate list of numbers between start and end value
  • From: Dana DeLouis
• Re: Summing while hiding?!
  • From: Bill Renaud
• Re: Generate list of numbers between start and end value
  • From: Sinner
• Re: How do I display cell name with Msgbox?
  • From: Bill Renaud
• Re: data validation with indirect ref to dynamic range
  • From: Doug Glancy
• Re: data validation with indirect ref to dynamic range
  • From: Debra Dalgleish
• Re: How to write code for find a word in excel?
  • From: Mx
• Re: How do I stop 2nd row deletion
  • From: ssGuru
• Re: Full proof UK postcode validation
  • From: Doug Glancy
• Re: Testing if Commandbar exists
  • From: Dave Peterson
• Re: Generate list of numbers between start and end value
  • From: excelent
• Re: Testing if Commandbar exists
  • From: Doug Glancy
• Re: Can you limit the amount typed in a cell in Excel 2003?
  • From: Dave Peterson
• Re: data validation with indirect ref to dynamic range
  • From: Doug Glancy
• Re: data validation with indirect ref to dynamic range
  • From: Ron Coderre
• Re: Testing if Commandbar exists
  • From: Leith Ross
• RE: need help with nested for-next loops
  • From: Joel
• data validation with indirect ref to dynamic range
  • From: Doug Glancy
• Re: Auto number formatting
  • From: Randy
• Re: Auto number formatting
  • From: Randy
• Testing if Commandbar exists
  • From: Farrar > Tweety
• Re: Compare xls & mpp files against a master file register then flag m
  • From: Roger
• Re: Sheets("sheet1").Copy
  • From: Dave Peterson
• Re: Sheets("sheet1").Copy
  • From: Little Penny
• Re: Can you limit the amount typed in a cell in Excel 2003?
  • From: Gary''s Student
• Re: Can you limit the amount typed in a cell in Excel 2003?
  • From: Dave Peterson
• Looping thru multiple files to produce a consolidated summary by Code
  • From: u473
• RE: need help with nested for-next loops
  • From: rpw
• RE: need help with nested for-next loops
  • From: rpw
• Importing CSV just like Excel opening CSV
  • From: Bob
• Re: How do I Run Macro on Opening if user is not the "Last Saved B
  • From: Gary''s Student
• Combobox on Quick Access Toolbar
  • From: Randy
• Re: how do you set up the simpsons rule on excel?
  • From: Ed from AZ
• Re: How do I Run Macro on Opening if user is not the "Last Saved By" U
  • From: Steve Yandl
• Re: How do I Run Macro on Opening if user is not the "Last Saved By" U
  • From: Bob Phillips
• Re: Full proof UK postcode validation
  • From: Rick Rothstein \(MVP - VB\)
• Re: Full proof UK postcode validation
  • From: Bob Phillips
• Re: Generate list of numbers between start and end value
  • From: Sinner
• Re: Loop until finished
  • From: Otto Moehrbach
• Re: PageSetup changes not working in VBA
  • From: david.j.winfield@xxxxxxxxx
• Re: manipulating controls
  • From: Dave Peterson
• Re: Protecting & Unprotecting worksheet
  • From: Alain Vaillancourt
• Re: Can you limit the amount typed in a cell in Excel 2003?
  • From: Dave Peterson
• RE: need help with nested for-next loops
  • From: rpw
• Re: Compare xls & mpp files against a master file register then flag m
  • From: Dave Peterson
• Re: AutoFilter
  • From: Dave Peterson
• Print preview creates problems in macro heavy reporting tool
  • From: mustermania
• Re: Loop until finished
  • From: David A.
• Full proof UK postcode validation
  • From: Ed Peters
• Re: Coding to remove and import Module
  • From: mathieu936
• Re: How do I write code to "Workbook_Open" from within a VBA?
  • From: mathieu936
• Re: How do I write code to "Workbook_Open" from within a VBA?
  • From: Ron de Bruin
• Re: Coding to remove and import Module
  • From: Chip Pearson
• Re: Macro to Paste at next blank row
  • From: Ron de Bruin
• Re: AutoFilter
  • From: pgarcia
• Re: Generate list of numbers between start and end value
  • From: Otto Moehrbach
• Re: Loop until finished
  • From: Otto Moehrbach
• Re: Macro to Paste at next blank row
  • From: Per Erik Midtrød
• RE: Macro Running Twice
  • From: Arnie
• Re: match two excel spread sheet using macro
  • From: Otto Moehrbach
• Re: How do I stop 2nd row deletion
  • From: ssGuru
• Re: Loop until finished
  • From: David A.
• RE: need help with nested for-next loops
  • From: Joel
• Coding to remove and import Module
  • From: mathieu936
• Re: Loop until finished
  • From: Otto Moehrbach
• RE: Macro - Share with Users on a shared network drive
  • From: Vicki
• Re: Compare xls & mpp files against a master file register then flag m
  • From: Roger
• Generate list of numbers between start and end value
  • From: Sinner
• Re: Compound IF statement
  • From: Otto Moehrbach
• Multiple selection (range or individual) capability in a drop down list
  • From: richard . alexander
• Re: Dates and Conditional Formatting
  • From: Dermot
• Re: Cal formula upon sorting
  • From: DonLi2006
• Re: Compound IF statement
  • From: Di
• Re: List Modules in a user form
  • From: Chip Pearson
• Re: Instead of the word "dropped" could I use an arrow?
  • From: pgarcia
• Re: Multiple Search Criteria - One works other does not.
  • From: mrmunka@xxxxxxxxx
• name validation
  • From: Luis A. Vázquez
• Multiple Search Criteria - One works other does not.
  • From: mrmunka@xxxxxxxxx
• Re: Compound IF statement
  • From: Otto Moehrbach
• Re: Easy Syntax Question - refer to current row & column to pull a
  • From: Lisab
• Re: Easy Syntax Question - refer to current row & column to pull a
  • From: Lisab
• RE: Auto-correct macro or VBA
  • From: Jack_Feeman
• Re: How to Disable a special button
  • From: Jim Rech
• RE: Auto-correct macro or VBA
  • From: paul.hobin@jus.gov.on.ca
• Loop until finished
  • From: David A.
• Re: Command Bars - working with the built in buttons
  • From: Jim Rech
• Re: Sheets("sheet1").Copy
  • From: Dave Peterson
• Re: Help with VBA date
  • From: Dave Peterson
• Re: Instead of the word "dropped" could I use an arrow?
  • From: Dave Peterson
• Re: Protecting & Unprotecting worksheet
  • From: Bill Renaud
• Re: Excel 2007 autoopen shift key doesn't work
  • From: Jim Rech
• Re: Stamp a Cell with Time Q
  • From: Bill Renaud
• Re: Easy Syntax Question - refer to current row & column to pull a val
  • From: Ron de Bruin
• Sheets("sheet1").Copy
  • From: Little Penny
• Re: Easy Syntax Question - refer to current row & column to pull a val
  • From: Tim Zych
• Re: Import data from a secure website to Excel
  • From: Randy Harmelink
• Re: Instead of the word "dropped" could I use an arrow?
  • From: pgarcia
• RE: Auto-correct macro or VBA
  • From: Jack_Feeman
• RE: Import from MS Access - Lose the drive letter..link only to dr
  • From: Cyhill
• Re: Modified McCauley Duration From VBA?
  • From: PeteCresswell
• Re: Paste Column Width Language
  • From: paul.hobin@jus.gov.on.ca
• RE: Auto-correct macro or VBA
  • From: paul.hobin@jus.gov.on.ca
• PageSetup changes not working in VBA
  • From: david.j.winfield@xxxxxxxxx
• Looping thru multiple files to produce a consolidated summary by Cod
  • From: u473
• Re: Variable type
  • From: Alan Beban
• SetText Format in Excel sheet Cell
  • From: sasikumark
• Re: Paste Column Width Language
  • From: Ron de Bruin
• Re: How do I stop 2nd row deletion
  • From: Jon Peltier
• Re: Macro to Unlock All Protected Worksheets
  • From: ssGuru
• Re: Help with VBA date
  • From: FortisChet@xxxxxxxxx
• RE: Auto-correct macro or VBA
  • From: Jack_Feeman
• How do I stop 2nd row deletion
  • From: ssGuru
• RE: Auto-correct macro or VBA
  • From: paul.hobin@jus.gov.on.ca
• Re: Any way to enable the 2007 pivot table option Defer Layout Update with VBA?
  • From: GollyJer
• Re: Password protect worksheets
  • From: Dave Peterson
• Re: Modified McCauley Duration From VBA?
  • From: PeteCresswell
• Re: Type Mismatch Error
  • From: Ayo
• RE: VB Help/Request? Compare and insert to different data in colum
  • From: TroyT
• Help with insert a row
  • From: Al
• Re: Help on Macro
  • From: Dave Peterson
• Re: Help with VBA date
  • From: Dave Peterson
• Re: Filtering on String Length
  • From: Keith Wilby
• RE: highlight a column
  • From: Mitchell_Collen via OfficeKB.com
• Re: Type Mismatch Error
  • From: Dave Peterson
• Re: What happen when a row is hidden?
  • From: Dave Peterson
• Modified McCauley Duration From VBA?
  • From: PeteCresswell
• Re: Macro to Unlock All Protected Worksheets
  • From: Chip Pearson
• Re: Filtering on String Length
  • From: Ron Coderre
• Help with VBA date
  • From: FortisChet@xxxxxxxxx
• RE: highlight a column
  • From: Mitchell_Collen via OfficeKB.com
• Re: Type Mismatch Error
  • From: Ayo
• Re: Summing while hiding?!
  • From: Gary Keramidas
• Re: Type Mismatch Error
  • From: Gary Keramidas
• Re: Summing while hiding?!
  • From: Jo
• why doesnt my VSTO SE addin work?
  • From: DrRocket
• Re: How to determine type of function argument?
  • From: JE McGimpsey
• Re: Summing while hiding?!
  • From: Haldun Alay
• RE: If Range("J1").Text...Then
  • From: ryguy7272
• Re: Type Mismatch Error
  • From: papou
• Macro to Modify a Macro?
  • From: ChadDiesel
• Re: Dates and Conditional Formatting
  • From: Rick Rothstein \(MVP - VB\)
• Re: Summing while hiding?!
  • From: papou
• highlight a column
  • From: Mitchell_Collen via OfficeKB.com
• Filtering on String Length
  • From: Keith Wilby
• RE: If Range("J1").Text...Then
  • From: Vergel Adriano
• Summing while hiding?!
  • From: Jo
• What happen when a row is hidden?
  • From: Jo
• What happen when a row is hidden?
  • From: Jo
• What happen when a row is hidden?
  • From: Jo
• Re: Auto number formatting
  • From: Gord Dibben
• Re: Macro to expire after a specified date
  • From: Chip Pearson
• Re: Is there a way to make the text blink on and off using Excel VB?
  • From: Ron Coderre
• Listing all cell references
  • From: Karra
• Re: Import data from a secure website to Excel
  • From: Matheus
• Re: Finding chart on worksheet - THANKS!
  • From: papou
• Re: Call VB6 DLL from VBA wrapper
  • From: Chip Pearson
• Re: Finding chart on worksheet
  • From: papou
• Re: Compound IF statement
  • From: Di
• Re: MsgBox with Two Questions
  • From: Dave Peterson
• Updating Data between workbooks
  • From: jneaves
• RE: Run Time Error 6028: Help?
  • From: Dan the Man
• Re: Find a substring
  • From: Bob Phillips
• Find a substring
  • From: cirudinezidane@xxxxxxxxx
• Re: Alignment of Figures
  • From: Paul Black
• Re: Macro not running when it is supposed too
  • From: Girkers
• Re: Export a chart in a GIF file. Run-time error '1004': Application-defined or object-defined error;
  • From: Peter T
• Re: Save creating enormous temp files
  • From: Tom Med
• RE: Run Time Error 6028: Help?
  • From: Tom Ogilvy
• Re: Kill Error Message
  • From: Bob Phillips
• RE: delete blank rows and remove blanks from dropdown
  • From: Tom Ogilvy
• RE: transpose Copyfromrowset
  • From: Newman Emanouel
• Re: Cal formula upon sorting
  • From: Joel
• Re: Macro to expire after a specified date
  • From: Dileep Chandran
• Re: How do I display cell name with Msgbox?
  • From: I.R;))
• Re: How do I display cell name with Msgbox?
  • From: nomail1983@xxxxxxxxxxx
• Re: Stamp a Cell with Time Q
  • From: Sean
• Save creating enormous temp files
  • From: tom . medland
• Alignment of Figures
  • From: Paul Black
• Re: How do I display cell name with Msgbox?
  • From: I.R;))
• Re: MsgBox with Two Questions
  • From: Paul Black
• How do I display cell name with Msgbox?
  • From: nomail1983@xxxxxxxxxxx
• Re: Fill Cell with Asterix
  • From: Paul Black
• Re: How to determine type of function argument?
  • From: nomail1983@xxxxxxxxxxx
• Re: Call VB6 DLL from VBA wrapper
  • From: Bob Phillips
• Re: How to determine type of function argument?
  • From: Bob Phillips
• Re: Macro to expire after a specified date
  • From: I.R;))
• Macro to expire after a specified date
  • From: Dileep Chandran
• Re: number to words
  • From: Rick Rothstein \(MVP - VB\)
• Call VB6 DLL from VBA wrapper
  • From: jbscotland
• How to determine type of function argument?
  • From: nomail1983@xxxxxxxxxxx
• Re: How can I access Directory Names?
  • From: Leith Ross
• Re: Import data from a secure website to Excel
  • From: Randy Harmelink
• Re: Is Worksheet Empty?
  • From: JMB
• How can I access Directory Names?
  • From: Mac Lingo
• Re: Adding class object to collection repeats same object through collection?
  • From: Erazmus
• Re: Auto number formatting
  • From: Randy
• Issue with mail merge date field
  • From: Boog
• Re: Cal formula upon sorting
  • From: DonLi2006
• delete blank rows and remove blanks from dropdown
  • From: stewart
• How to remove single quotes
  • From: hon123456
• Re: Auto number formatting
  • From: Gord Dibben
• VBA/Macros in Cell Edit mode / Formula text selectio
  • From: bulk88
• Re: named range as rowsource
  • From: Karen53
• Re: number to words
  • From: Bernard Liengme
• Re: Define Range Dynamically
  • From: Randy
• RE: Worksheet.Change macro doesn't run in 2007
  • From: Jialiang Ge [MSFT]
• Re: Define Range Dynamically
  • From: Gary Keramidas
• Re: Define Range Dynamically
  • From: Tim Zych
• Re: Adding class object to collection repeats same object through collection?
  • From: Chip Pearson
• Re: Define Range Dynamically
  • From: Randy
• Re: Define Range Dynamically
  • From: Tim Zych
• Re: Variable type
  • From: Chip Pearson
• Adding class object to collection repeats same object through collection?
  • From: Erazmus
• Re: sumif question
  • From: Gary Keramidas
• Define Range Dynamically
  • From: Randy
• Re: Is Worksheet Empty?
  • From: JMB
• sumif question
  • From: Gary Keramidas
• Re: Auto number formatting
  • From: Randy
• Re: named range as rowsource
  • From: Dave Peterson
• Variable type
  • From: Alan Beban
• Re: Finding the nearest match without reusing results
  • From: David Hilberg
• RE: What is Runtime Error 6028 and how can it be resolved?
  • From: Joel
• Re: Improving the code from a recorded macro
  • From: Gary Keramidas
• Compare xls & mpp files against a master file register then flag missing.
  • From: Roger from Auckland
• Re: Cal formula upon sorting
  • From: DonLi2006
• Re: Auto number formatting
  • From: Gord Dibben
• Re: Stamp a Cell with Time Q
  • From: Bill Renaud
• Re: end if without block if error
  • From: stewart
• RE: Save it giving as a name the content of a cell
  • From: Joel
• Re: Improving the code from a recorded macro
  • From: Bob Phillips
• Re: Import data from a secure website to Excel
  • From: Randy Harmelink
• What is Runtime Error 6028 and how can it be resolved?
  • From: Dan the Man
• Re: Auto number formatting
  • From: Randy
• Re: Export a chart in a GIF file. Run-time error '1004': Application-defined or object-defined error;
  • From: cschiffers
• Run Time Error 6028: Help?
  • From: Dan the Man
• Re: Counting elements of array and range type data
  • From: Alain Vaillancourt
• Re: Export a chart in a GIF file. Run-time error '1004': Application-defined or object-defined error;
  • From: Peter T
• Re: Workbooks.Add = Macro Regression in 2007
  • From: Bill Renaud
• Re: Find a Number and Date - VBA
  • From: mrmunka
• RE: form population macro
  • From: Joel
• RE: Find a Number and Date - VBA
  • From: Joel
• Re: Is Worksheet Empty?
  • From: Zone
• Re: Compound IF statement
  • From: Otto Moehrbach
• Re: Counting elements of array and range type data
  • From: Alan Beban
• Re: all open workbooks
  • From: Otto Moehrbach
• Re: Help with For Each ... Next and control
  • From: Leith Ross
• Re: Is Worksheet Empty?
  • From: Otto Moehrbach
• Re: named range as rowsource
  • From: Karen53
• RE: Changing a two-dimensional, one row array to one-dimensional
  • From: Joel
• Re: named range as rowsource
  • From: Karen53
• Re: named range as rowsource
  • From: Dave Peterson
• Find a Number and Date - VBA
  • From: mrmunka
• pivot table running total problem
  • From: shripaldalal
• Re: named range as rowsource
  • From: Karen53
• Re: Counting elements of array and range type data
  • From: Alain Vaillancourt
• Stamp a Cell with Time Q
  • From: Sean
• RE: form population macro
  • From: Pam
• Re: named range as rowsource
  • From: Dave Peterson
• Re: row index number in a hlookup formula
  • From: Don Guillett
• Re: Data Validation Macro
  • From: Rick Rothstein \(MVP - VB\)
• Re: named range as rowsource
  • From: Karen53
• Re: Fill Cell with Asterix
  • From: Dave Peterson
• Re: named range as rowsource
  • From: Dave Peterson
• Re: named range as rowsource
  • From: Dave Peterson
• Re: MsgBox with Two Questions
  • From: Dave Peterson
• Re: Make shortcut to Excelfile on desktop
  • From: excelent
• Re: Export a chart in a GIF file. Run-time error '1004': Application-defined or object-defined error;
  • From: cschiffers
• Re: Make shortcut to Excelfile on desktop
  • From: Steve Yandl
• Re: named range as rowsource
  • From: Karen53
• Data Validation Macro
  • From: Little Penny
• Re: all open workbooks
  • From: Filips Benoit
• Re: Auto number formatting
  • From: Gord Dibben
• Re: Is Worksheet Empty?
  • From: Zone
• Re: end if without block if error
  • From: Don Guillett
• Re: Export a chart in a GIF file. Run-time error '1004': Application-defined or object-defined error;
  • From: Jon Peltier
• Re: end if without block if error
  • From: stewart
• Re: end if without block if error
  • From: Rick Rothstein \(MVP - VB\)
• Re: Is Worksheet Empty?
  • From: Otto Moehrbach
• Re: all open workbooks
  • From: Otto Moehrbach
• Re: Selective Worksheet printing
  • From: Zone
• Re: Return Value from MsgBox
  • From: Gary Keramidas
• Re: Dates and Conditional Formatting
  • From: Rick Rothstein \(MVP - VB\)
• Export a chart in a GIF file. Run-time error '1004': Application-defined or object-defined error;
  • From: cschiffers
• all open workbooks
  • From: Filips Benoit
• Re: Is Worksheet Empty?
  • From: Zone
• end if without block if error
  • From: stewart
• Re: Return Value from MsgBox
  • From: Mike Fogleman
• Re: MsgBox with Two Questions
  • From: Paul Black
• Re: Custom Ribbon example in Walkenbach's "Excel 2007 Power Programming with VBA"
  • From: Jim Rech
• Re: Is Worksheet Empty?
  • From: Zone
• Re: Copy Module to new Workbook
  • From: Little Penny
• Re: select data from dropdown menu
  • From: Don Guillett
• RE: Macro function to read text file
  • From: Joel
• Re: named range as rowsource
  • From: Dave Peterson
• Re: select data from dropdown menu
  • From: khushi . kotian
• Is Worksheet Empty?
  • From: Zone
• Re: named range as rowsource
  • From: Dave Peterson
• Re: Table Live
  • From: Dave Peterson
• Re: "view page breaks"
  • From: Dave Peterson
• Re: Selective Worksheet printing
  • From: Zone
• RE: Help- It's only a tiny change
  • From: Joel
• Selective Worksheet printing
  • From: Colin Telfer
• RE: form population macro
  • From: Joel
• Re: Cal formula upon sorting
  • From: Joel
• Re: Tidying Recorded Macro Code
  • From: Dave Peterson
• Custom Ribbon example in Walkenbach's "Excel 2007 Power Programming with VBA"
  • From: Greg Lovern
• Re: Auto number formatting
  • From: Randy
• Re: Two related Data Validation lists
  • From: Franz Verga
• Re: Xlusrgal
  • From: Jon Peltier
• Re: Cal formula upon sorting
  • From: DonLi2006
• Re: Make shortcut to Excelfile on desktop
  • From: Steve Yandl
• Re: Tidying Recorded Macro Code
  • From: Big H
• RE: can't activate chart
  • From: JLGWhiz
• RE: Cal formula upon sorting
  • From: Joel
• Re: Counting elements of array and range type data
  • From: Alan Beban
• Re: Copy Module to new Workbook
  • From: Joel
• Re: MsgBox with Two Questions
  • From: Dave Peterson
• Re: Tidying Recorded Macro Code
  • From: Dave Peterson
• Re: Counting elements of array and range type data
  • From: Alain Vaillancourt
• Re: Hide all toolbars/menu bar when open file
  • From: Incidental
• Re: linked cells not updating
  • From: Bill Renaud
• MsgBox with Two Questions
  • From: Paul Black
• Re: value of one cell in a named range
  • From: Alan Beban
• Re: Copy Module to new Workbook
  • From: Little Penny
• Re: Tidying Recorded Macro Code
  • From: Big H
• Re: Tidying Recorded Macro Code
  • From: Don Guillett
• Re: Macro to delete rows
  • From: Bill Renaud
• Cal formula upon sorting
  • From: DonLi2006
• Re: Xlusrgal
  • From: Bill Renaud
• Re: Tidying Recorded Macro Code
  • From: Big H
• RE: Copy Module to new Workbook
  • From: Joel
• Re: Null Value
  • From: Dave Peterson
• Re: Tidying Recorded Macro Code
  • From: Dave Peterson
• Re: allcaps option in excel like word
  • From: Bill Renaud
• Re: Tidying Recorded Macro Code
  • From: Joel
• RE: VB Help/Request? Compare and insert to different data in colum
  • From: Joel
• can't activate chart
  • From: matthias . rother
• Re: Application.Volatile not working
  • From: Bill Renaud
• RE: VB Help/Request? Compare and insert to different data in colum
  • From: TroyT
• Copy Module to new Workbook
  • From: Little Penny
• Re: Tidying Recorded Macro Code
  • From: Don Guillett
• Re: Tidying Recorded Macro Code
  • From: Otto Moehrbach
• RE: Tidying Recorded Macro Code
  • From: Joel
• Re: creating a formula with a loop
  • From: Gary Keramidas
• Re: Auto number formatting
  • From: Gord Dibben
• Re: Auto number formatting
  • From: Rick Rothstein \(MVP - VB\)
• Re: Auto number formatting
  • From: Rick Rothstein \(MVP - VB\)
• creating a formula with a loop
  • From: Gary Keramidas
• Re: How do I create a pulldown value list for data entry?
  • From: Gord Dibben
• Re: Auto number formatting
  • From: Gord Dibben
• Re: Xlusrgal
  • From: Jon Peltier
• Tidying Recorded Macro Code
  • From: Big H
• Re: Fixed Width Layout
  • From: Little Penny
• Re: Accessing the text of a form command button from underlying macro
  • From: Chrisso
• Re: Macro to change font
  • From: minditservices
• Re: Finding the nearest match without reusing results
  • From: Bernd P
• Re: Accessing the text of a form command button from underlying macro
  • From: Andy Pope
• Re: Macro to change font
  • From: Dave Peterson
• Re: Macro to change font
  • From: Dave Peterson
• Macro to change font
  • From: minditservices
• Re: Accessing the text of a form command button from underlying macro
  • From: Chrisso
• Re: UDF using Dates
  • From: Dave Peterson
• Accessing the text of a form command button from underlying macro
  • From: Chrisso
• Re: select data from dropdown menu
  • From: Don Guillett
• Re: UDF using Dates
  • From: Jim Dean
• select data from dropdown menu
  • From: khushi . kotian
• Re: Invoke Edit Mode
  • From: Zone
• Re: Invoke Edit Mode
  • From: David Hilberg
• Re: Error in Insert Row command.
  • From: shahzad4u_ksa
• Error on E-Mailing Q
  • From: Sean
• Re: Finding the nearest match without reusing results
  • From: David Hilberg
• RE: Build whre statement
  • From: Joel
• Re: Saving / Reading dynamic arrays to / from disk
  • From: Mike
• Re: Macro to delete rows
  • From: Bob Phillips
• Re: Finding the nearest match without reusing results
  • From: David Hilberg
• Re: Finding the nearest match without reusing results
  • From: Bernd P
• Re: Finding the nearest match without reusing results
  • From: Bernd P
• Re: Invoke Edit Mode
  • From: David Hilberg
• Re: Invoke Edit Mode
  • From: Zone
• Invoke Edit Mode
  • From: Zone
• Re: Finding the nearest match without reusing results
  • From: David Hilberg
• Changing a two-dimensional, one row array to one-dimensional
  • From: Alan Beban
• Re: Using an Array to Speed-Up Range Copy
  • From: Bill Renaud
• Re: Counting elements of array and range type data
  • From: Alan Beban
• RE: transforming poll data from rows to colums
  • From: ulfb
• RE: How do I create a pulldown value list for data entry?
  • From: OssieMac
• Re: Counting elements of array and range type data
  • From: Alain Vaillancourt
• How do I create a pulldown value list for data entry?
  • From: Kompu Kid
• RE: Find a Number and Date ...
  • From: Joel
• Re: Auto number formatting
  • From: Randy
• RE: Merging Data from Two Different Workbooks on a Common Key
  • From: JLatham
• How to write code for find a word in excel?
  • From: Mx
• Pivot Table Custom Filters
  • From: Avi
• Re: Counting elements of array and range type data
  • From: Alan Beban
• RE: Merging Data from Two Different Workbooks on a Common Key
  • From: Luther
• Re: VBA to say IF cell = any one of 3 values,then do something
  • From: Dana DeLouis
• Find a Number and Date ...
  • From: mrmunka
• Re: Set Class1Var = New Class1
  • From: Dave D-C
• Re: AutoFilter
  • From: Dave Peterson
• Re: Set Class1Var = New Class1
  • From: Dave D-C
• Re: Fixed Width Layout
  • From: Joel
• Re: Capturing Listbox Selections
  • From: Randy
• Re: Capturing Listbox Selections
  • From: George Nicholson
• Re: How to print out matching names?
  • From: Tom
• Pivot Tables - DisplayEmptyColumn question
  • From: Henry
• Re: Finding the path of a folder
  • From: Anne Schouten
• Re: Fixed Width Layout
  • From: Little Penny
• RE: Getting file name and Modified date
  • From: urkec
• Re: Using an Array to Speed-Up Range Copy
  • From: JingleRock
• Re: AutoFilter
  • From: Dave Peterson
• RE: VBA help w/ look & fill in data
  • From: Joel
• Re: Key combinations not used by Excel to use in macro keyboard shortc
  • From: Dave Peterson
• Re: Locat a cell
  • From: pgarcia
• Capturing Listbox Selections
  • From: Randy
• Re: Conditional Formatted numbers add based on color?
  • From: Jim Rech
• Re: Counting Worksheets
  • From: Mike Fogleman
• Re: Not Enough Memory to run Microsoft Office Excel.
  • From: Peter T
• Re: Run-time error
  • From: Mike
• Re: Counting elements of array and range type data
  • From: TomLegado
• Re: running Access procedure from Excel
  • From: savalou
• Re: Finding the path of a folder
  • From: Jim Rech
• Re: Key combinations not used by Excel to use in macro keyboard shortc
  • From: StargateFanFromWork
• Re: Copy only basic number without dollar sign or commas (or cell form
  • From: StargateFanFromWork
• Re: Counting elements of array and range type data
  • From: Alain Vaillancourt
• Re: Run-time error
  • From: Chip Pearson
• Re: Not Enough Memory to run Microsoft Office Excel.
  • From: Mike
• Finding the path of a folder
  • From: Anne Schouten
• if questions
  • From: mattG
• Re: Run-time error
  • From: Jim Thomlinson
• Re: running Access procedure from Excel
  • From: savalou
• Any way to enable the 2007 pivot table option Defer Layout Update with VBA?
  • From: GollyJer
• Re: Locat a cell
  • From: JW
• Re: running Access procedure from Excel
  • From: JW
• Re: Counting elements of array and range type data
  • From: Alan Beban
• Re: What's the fastest way to push this data around?
  • From: GollyJer
• Re: Run-time error
  • From: Francis Hookham
• RE: VBA help w/ look & fill in data
  • From: Cam
• Re: Finding the nearest match without reusing results
  • From: goofy11
• Re: Using an Array to Speed-Up Range Copy
  • From: JingleRock
• Re: Macro to delete rows
  • From: Tasha
• Re: Fill Cell with Asterix
  • From: Dave Peterson
• Re: Key combinations not used by Excel to use in macro keyboard shortc
  • From: Dave Peterson
• Re: Macro to delete rows
  • From: Bob Phillips
• Re: type mismatch error when passing collection byRef
  • From: Tara H
• Re: Fill Cell with Asterix
  • From: Steve G
• Re: Saving / Reading dynamic arrays to / from disk
  • From: Mike
• Re: type mismatch error when passing collection byRef
  • From: George Nicholson
• Re: Fill Cell with Asterix
  • From: Robert Bruce
• Re: Locat a cell
  • From: pgarcia
• Run-time error
  • From: Francis Hookham
• Re: Find error!!!! Is there any other way to do this?
  • From: carlos_ray86
• Re: Hide all toolbars/menu bar when open file
  • From: Incidental
• running Access procedure from Excel
  • From: savalou
• Re: Key combinations not used by Excel to use in macro keyboard shortc
  • From: StargateFanFromWork
• RE: VBA help w/ look & fill in data
  • From: Joel
• Re: Fill Cell with Asterix
  • From: Incidental
• Re: Counting elements of array and range type data
  • From: TomLegado
• RE: Find error!!!! Is there any other way to do this?
  • From: Jim Thomlinson
• Re: Counting elements of array and range type data
  • From: Alain Vaillancourt
• Re: Fill Cell with Asterix
  • From: Mike Fogleman
• Re: Hide all toolbars/menu bar when open file
  • From: Mike Fogleman
• Re: Answer msgbox with macro
  • From: HI
• Re: Instead of the word "dropped" could I use an arrow?
  • From: Dave Peterson
• Re: Not Enough Memory to run Microsoft Office Excel.
  • From: Peter T
• Fill Cell with Asterix
  • From: Paul Black
• RE: VBA help w/ look & fill in data
  • From: Cam
• Re: Instead of the word "dropped" could I use an arrow?
  • From: pgarcia
• Re: Answer msgbox with macro
  • From: Mike Fogleman
• Re: Hide all toolbars/menu bar when open file
  • From: Incidental
• Re: Find error!!!! Is there any other way to do this?
  • From: carlos_ray86
• Re: Help on some simple code
  • From: Dana DeLouis
• Re: Find error!!!! Is there any other way to do this?
  • From: carlos_ray86
• Answer msgbox with macro
  • From: HI
• Copy Command Button Code.
  • From: ianmacinnis
• Re: Set Class1Var = New Class1
  • From: Chip Pearson
• Re: Not Enough Memory to run Microsoft Office Excel.
  • From: Norra
• Re: Find error!!!! Is there any other way to do this?
  • From: carlos_ray86
• Changing Numeric value to text
  • From: tc
• Re: Not Enough Memory to run Microsoft Office Excel.
  • From: Peter T
• Re: TreeView1
  • From: Chip Pearson
• RE: transforming poll data from rows to colums
  • From: Joel
• Re: array data to cells
  • From: anduare2
• Key combinations not used by Excel to use in macro keyboard shortcuts?
  • From: StargateFanFromWork
• Re: Copy only basic number without dollar sign or commas (or cell form
  • From: StargateFanFromWork
• Find error!!!! Is there any other way to do this?
  • From: carlos_ray86
• Find error!!!! Is there any other way to do this?
  • From: carlos_ray86
• Re: Set Class1Var = New Class1
  • From: Dave D-C
• Re: Set Class1Var = New Class1
  • From: Dave D-C
• Re: Sheets("Sheet").Copy problem
  • From: Jon Peltier
• RE: transforming poll data from rows to colums
  • From: ulfb
• Re: supress message
  • From: Don Guillett
• Re: UDF using Dates
  • From: Dave Peterson
• Re: Preventing corruption of dynamic range names on cell deletion
  • From: JE McGimpsey
• RE: transforming poll data from rows to colums
  • From: Joel
• Re: Check a workbook exists before opening
  • From: Symbiosis
• Preventing corruption of dynamic range names on cell deletion
  • From: Chrisso
• Re: UDF using Dates
  • From: Jim Dean
• Re: UDF using Dates
  • From: Jim Dean
• Re: check control names
  • From: stewart
• Re: Check a workbook exists before opening
  • From: Bob Phillips
• Re: Columns limit 512
  • From: Bob Phillips
• RE: Conversion from columnwise to rowwise
  • From: Frank Situmorang
• Re: TreeView1
  • From: Chip Pearson
• RE: Conversion from columnwise to rowwise
  • From: Frank Situmorang
• Re: Check a workbook exists before opening
  • From: papou
• RE: Check a workbook exists before opening
  • From: OssieMac
• Check a workbook exists before opening
  • From: Symbiosis
• Re: Getting file name and Modified date
  • From: papou
• Re: Conditional formatting based on what function is used in a cell.
  • From: Bob Phillips
• Re: Workbooks.Add = Macro Regression in 2007
  • From: Bill Renaud
• Re: Using an Array to Speed-Up Range Copy
  • From: Bill Renaud
• Re: Set Class1Var = New Class1
  • From: Bill Renaud
• Re: How to print out matching names?
  • From: Bill Renaud
• Re: Columns limit 512
  • From: Gary Keramidas
• Re: Excel error message
  • From: Bill Renaud
• Re: Hide rows and prevent unhiding
  • From: Bill Renaud
• Re: VBA Question - Delete set if any member meets criteria
  • From: Bill Renaud
• Using an Array to Speed-Up Range Copy
  • From: JingleRock
• Set Class1Var = New Class1
  • From: Dave D-C
• Re: align left and right in listbox
  • From: Tim Williams
• Matching two worksheet?
  • From: SF
• Re: Auto number formatting
  • From: Gord Dibben
• RE: excel 2003 Reading workbook properties / details from an XLA how d
  • From: Joel
• Re: Excel error message
  • From: Tim Williams
• Re: Auto number formatting
  • From: Rick Rothstein \(MVP - VB\)
• Re: sql
  • From: Tim Williams
• Re: Auto size named range by .Net or VBA
  • From: Dale
• Re: Fixed Width Layout
  • From: Joel
• RE: Auto size named range by .Net or VBA
  • From: Dale
• RE: Deleting Rows if certain criteria isnt met
  • From: Joel
• Re: check control names
  • From: Dave Peterson
• How to print out matching names?
  • From: Tom
• Re: Fixed Width Layout
  • From: Little Penny
• Re: supress message
  • From: cubbybear3
• RE: VBA Question - Delete set if any member meets criteria
  • From: Joel
• Re: check control names
  • From: stewart
• Re: Auto number formatting
  • From: Gord Dibben
• Re: macro to color all text red in worksheet if within certain date
  • From: Gary Keramidas
• Re: macro to color all text red in worksheet if within certain date
  • From: Dave Peterson
• Re: check control names
  • From: Dave Peterson
• Re: Instead of the word "dropped" could I use an arrow?
  • From: Dave Peterson
• Re: Draw Entries
  • From: Sebation
• check control names
  • From: stewart
• Deleting Rows if certain criteria isnt met
  • From: Big H
• RE: Sheets("Sheet").Copy problem
  • From: JLatham
• Re: Is there a code to clear clipboard to prevent pasting on mouse
  • From: Carl
• RE: Is there a way to run a procedure before the paste command?
  • From: Carl
• excel 2003 Reading workbook properties / details from an XLA how do you do it?
  • From: brad
• excel 2003 Reading workbook properties / details from an XLA how do you do it?
  • From: brad
• Auto number formatting
  • From: Randy
• Hide rows and prevent unhiding
  • From: david.j.winfield@xxxxxxxxx
• Re: Active worksheet problem
  • From: Mike Fogleman
• RE: VBA help w/ look & fill in data
  • From: Joel
• Re: Finding the nearest match without reusing results
  • From: David Hilberg
• RE: copy checkbox to multiple cells?
  • From: RD
• Re: Finding the nearest match without reusing results
  • From: David Hilberg
• Re: Use cell values as object names
  • From: Chip Pearson
• Re: Instead of the word "dropped" could I use an arrow?
  • From: eliano
• Re: VBA code to email 1 worksheet in a workbook
  • From: Ron de Bruin
• Re: Calendar with weeknumber?
  • From: Rick Rothstein \(MVP - VB\)
• Re: code reopens file
  • From: Jim Rech
• RE: Is there a way to run a procedure before the paste command?
  • From: Carl
• Re: Finding the nearest match without reusing results
  • From: goofy11
• Re: Active worksheet problem
  • From: Mike Fogleman
• Re: Calendar with weeknumber?
  • From: Ron de Bruin
• Re: Removing Blank Rows for Excel VB Newb
  • From: Ron de Bruin
• RE: Is there a way to run a procedure before the paste command?
  • From: Carl
• RE: Best way to import .csv
  • From: cottage6
• Re: Tab printing Macro
  • From: Luis A. Vázquez
• Re: Saving / Reading dynamic arrays to / from disk
  • From: Mike
• RE: Is there a way to run a procedure before the paste command?
  • From: Tom Ogilvy
• Re: Update Protected Links
  • From: hurlbut777
• RE: copy checkbox to multiple cells?
  • From: Joel
• Re: Grouping Checkboxes in a UserForm
  • From: Otto Moehrbach
• RE: Two Parter: filter list and search for a match for the passwo
  • From: RyGuy
• Re: Macro acting wierd with Zip Codes
  • From: Dave Peterson
• Re: What's the fastest way to push this data around?
  • From: Dave Peterson
• RE: Best way to import .csv
  • From: Tom Ogilvy
• Copy only basic number without dollar sign or commas (or cell formatting)?
  • From: StargateFanFromWork
• RE: Two Parter: filter list and search for a match for the passwo
  • From: RyGuy
• Tab printing Macro
  • From: Luis A. Vázquez
• RE: Two Parter: filter list and search for a match for the passwo
  • From: Tom Ogilvy
• Macro acting wierd with Zip Codes
  • From: Stick With Hair
• Re: ComboBox won't display more than 1000 items in Excel 2007
  • From: Meera
• Re: did you find a solution
  • From: Alain Vaillancourt
• RE: Two Parter: filter list and search for a match for the passwo
  • From: RyGuy
• Re: hide sheet
  • From: JW
• Re: display cell contents
  • From: JW
• Re: Worksheet Change event code, but retain Undo?
  • From: JE McGimpsey
• Re: display cell contents
  • From: Bill Renaud
• Code to Print single cells
  • From: ianmacinnis
• RE: Flag me if macro errors
  • From: Tom Ogilvy
• Re: Is there a code to clear clipboard to prevent pasting on mouse
  • From: Carl
• Worksheet_Change
  • From: zimfrancis
• Re: Copy-pasting from Excel to Word
  • From: Ed from AZ
• Re: Sheet CodeNames
  • From: Bill Renaud
• Grouping Checkboxes in a UserForm
  • From: Otto Moehrbach
• Re: this code crashes excel. How come?
  • From: Nolaughmtr
• Re: this code crashes excel. How come?
  • From: JE McGimpsey
• Re: Worksheet Change event code, but retain Undo?
  • From: JE McGimpsey
• Re: this code crashes excel. How come?
  • From: Peter T
• RE: VBA help w/ look & fill in data
  • From: Cam
• Re: Flag me if macro errors
  • From: JE McGimpsey
• Re: Finding the nearest match without reusing results
  • From: goofy11
• Re: UDF won't refresh - please help
  • From: TarrynG
• Re: Sheet CodeNames
  • From: Bill Renaud
• Re: Worksheet Change event code, but retain Undo?
  • From: JE McGimpsey
• Re: Flag me if macro errors
  • From: Bob Phillips
• If Then statement comparing date values
  • From: ll
• Re: Is there a code to clear clipboard to prevent pasting on mouse
  • From: Carl
• Re: Can VBA Code change itself?
  • From: JW
• Why does VBA mess up
  • From: carlos_ray86
• Re: Batch deleting invalid defined names from a workbook
  • From: Dave Peterson
• Re: Copy-pasting from Excel to Word
  • From: raphiel2063
• Re: How do I pass a value in a range command
  • From: mopgcw
• Re: Excel cannot complete this task with available resources. choo
  • From: JNW
• Re: How do I pass a value in a range command
  • From: mopgcw
• Code to Create a Command Button
  • From: ianmacinnis
• RE: help with this loop macro
  • From: Nolaughmtr
• RE: Trach Changes Without sharing the workbook
  • From: bstobart
• Re: Shortcut keys not working .... <grrrr>
  • From: StargateFanFromWork
• Re: Copy-pasting from Excel to Word
  • From: Ed from AZ
• RE: IMPORTING WORD TO EXCEL
  • From: gwbdirect
• Re: Location of Cell with Value in Merge Area
  • From: Ken Johnson
• Re: update file list code for excel 2007
  • From: Martin Brown
• Re: CallByName() doesn't
  • From: christopher.allen
• Re: Printing to Local Printer and the not the default printer.
  • From: I.R;))
• Printing to Local Printer and the not the default printer.
  • From: ianmacinnis
• Re: Finding Embedded Object Type in Worksheet
  • From: papou
• Re: Finding Embedded Object Type in Worksheet
  • From: Jim Rech
• Re: Locat a cell, unrelated, again
  • From: JW
• Re: Show Tabs by date
  • From: JW
• Re: use a variable for a worksheet name in a formula
  • From: Gary Keramidas
• Re: supress message
  • From: Don Guillett
• Re: UDF won't refresh - please help
  • From: Dave Peterson
• Re: Refreshing external data
  • From: Dave Peterson
• How to create a time log sheet
  • From: Ram
• Re: Excel cannot complete this task with available resources. choose l
  • From: ashish . kare
• Re: defined name with formula as source in VBA
  • From: Bob Phillips
• Re: Conversion from columnwise to rowwise
  • From: Bob Phillips
• Re: Export and Import Userform from Excel-file to another Excel-file
  • From: papou
• Re: opening a file from a cell reference
  • From: papou
• Excel cannot complete this task with available resources. choose less data or close other applications
  • From: ashish . kare
• RE: Summary Sheet from range specified in a worksheet
  • From: Jas
• opening a file from a cell reference
  • From: sfielder78@xxxxxxxxx
• Re: can't transfer to worksheet
  • From: stewart
• Re: Error in Insert Row command.
  • From: shahzad4u_ksa
• RE: Sheets("Sheet").Copy problem
  • From: Brian
• RE: Summary Sheet from range specified in a worksheet
  • From: Joel
• Re: Dynamically change the database a PivotTable references
  • From: daxmiller@xxxxxxxxx
• Re: Conversion from columnwise to rowwise
  • From: Frank Situmorang
• Using Shape's OnAction property in C#
  • From: abhimanyu
• RE: Conversion from columnwise to rowwise
  • From: Joel
• Re: Finding the nearest match without reusing results
  • From: David Hilberg
• Re: Hiding Columns
  • From: glimmer23
• Re: Auto size named range by .Net or VBA
  • From: Jialiang Ge [MSFT]
• Re: Code Needed For a Macro
  • From: Bob Phillips
• Re: Excel macros
  • From: Bob Phillips
• Re: Conversion from columnwise to rowwise
  • From: Bob Phillips
• RE: Trach Changes Without sharing the workbook
  • From: Gav123
• Error in Insert Row command.
  • From: shahzad4u_ksa
• Re: VBA Help downloadable ?
  • From: Bob Phillips
• RE: Summary Sheet from range specified in a worksheet
  • From: Jas
• Re: UDF won't refresh - please help
  • From: TarrynG
• RE: Formulas
  • From: Sincere
• Find function using chr
  • From: gazza67
• Re: Finding the nearest match without reusing results
  • From: David Hilberg
• Track Changes History sheet (Who changed the last cell)
  • From: ankur
• Code Needed For a Macro
  • From: kalyan
• RE: help with this loop macro
  • From: Joel
• Re: Fixed Width Layout
  • From: Joel
• Re: Hiding Columns
  • From: glimmer23
• Re: Hiding Columns
  • From: glimmer23
• Re: Hiding Columns
  • From: Bill Renaud
• Re: Hiding Columns
  • From: glimmer23
• Re: Hiding Columns
  • From: glimmer23
• Selection.Replace What and double quotes
  • From: Ed Peters
• Re: Sheet CodeNames
  • From: Bill Renaud
• did you find a solution
  • From: Curtis Gaylord
• did you find a solution
  • From: Curtis Gaylord
• Re: Hiding Columns
  • From: Bill Renaud
• Hiding Columns
  • From: glimmer23
• Re: Split first name and Surname
  • From: Gary Keramidas
• Re: Finding the nearest match without reusing results
  • From: David Hilberg
• Re: Can you do an Autofilter on defined names in a worksheet?
  • From: Fiona
• Re: supress message
  • From: cubbybear3
• Formatting the excel window
  • From: Asim
• Re: Worksheet.Change macro doesn't run in 2007
  • From: David Walker
• RE: Worksheet.Change macro doesn't run in 2007
  • From: David Walker
• RE: HOW TO???
  • From: Robin Hood
• Re: if database exists... MS Query
  • From: savalou
• RE: Auto size named range by .Net or VBA
  • From: FSt1
• Re: Arrays [Why does this not work?]
  • From: Gary Keramidas
• Re: Auto size named range by .Net or VBA
  • From: Dale
• Re: Option Explicit when install Essbase
  • From: Jim Cone
• RE: Worksheet.Change macro doesn't run in 2007
  • From: Jialiang Ge [MSFT]
• Re: Arrays [Why does this not work?]
  • From: Dave Peterson
• Re: Arrays [Why does this not work?]
  • From: Gary Keramidas
• Re: Option Explicit when install Essbase
  • From: Dave Peterson
• Re: Option Explicit when install Essbase
  • From: Dave Peterson
• Re: can't transfer to worksheet
  • From: Dave Peterson
• Re: array data to cells
  • From: Dave Peterson
• Re: Arrays [Why does this not work?]
  • From: Dave Peterson
• Re: Fixed Width Layout
  • From: Little Penny
• Re: VBA Help downloadable ?
  • From: tianung
• can't transfer to worksheet
  • From: stewart
• Re: Excel 2007: Macros not working in password-protected workbooks
  • From: rfooks
• Re: How do they do that?
  • From: Josh Sale
• Re: Macro not running when it is supposed too
  • From: Girkers
• Re: TRANSPOSE and INDEX limit in Excel2007
  • From: Alan Beban
• How do they do that?
  • From: Josh Sale
• Re: Show Tabs by date
  • From: JE McGimpsey
• Re: Arrays [Why does this not work?]
  • From: Mike Fogleman
• Macro not running when it is supposed too
  • From: garth . kirkwood
• RE: help with this loop macro
  • From: Nolaughmtr
• Re: Arrays [Why does this not work?]
  • From: AshofMind@xxxxxxxxx
• Re: Arrays [Why does this not work?]
  • From: Gary Keramidas
• RE: help with this loop macro
  • From: Joel
• Re: Show Tabs by date
  • From: Dana DeLouis
• Re: Arrays [Why does this not work?]
  • From: Dave Peterson
• Re: Arrays [Why does this not work?]
  • From: Dave Peterson
• Re: Arrays [Why does this not work?]
  • From: AshofMind@xxxxxxxxx
• Re: Arrays [Why does this not work?]
  • From: Gary Keramidas
• Re: Search all worksheets
  • From: Dave Peterson
• Re: CHANGING FONT SIZE
  • From: Dave Peterson
• Re: Refreshing external data
  • From: Dave Peterson
• Re: Find first empty cell in column J. Copy, paste special, value
  • From: Dave Peterson
• Arrays [Why does this not work?]
  • From: AshofMind
• Re: Nested IF problem
  • From: Jim Rech
• if database exists... MS Query
  • From: savalou
• Re: Nested IF problem
  • From: azu_daioh@xxxxxxxxx
• Re: Specifying a range within an array
  • From: Alan Beban
• Nested IF problem
  • From: azu_daioh@xxxxxxxxx
• Re: TRANSPOSE and INDEX limit in Excel2007
  • From: Jim Rech
• TRANSPOSE and INDEX limit in Excel2007
  • From: Alan Beban
• Re: Open a read only file as a writable file
  • From: Jim Rech
• Re: Named range reference in VBA for Excel 2007
  • From: Jim Rech
• Convert numbers to text (from product id # to name of product)
  • From: arran . mckay
• Search all worksheets
  • From: jneaves
• Search all worksheets
  • From: jneaves
• Re: Find first empty cell in column J. Copy, paste special, value
  • From: zzxxcc
• Re: End(XlDown).Row - Problem if only 1 row
  • From: David Hilberg
• Re: PasteSpecial method of Range class failed
  • From: David Hilberg
• Re: End(XlDown).Row - Problem if only 1 row
  • From: RB Smissaert
• List Worksheet Names in a Dialog
  • From: coreygallon@xxxxxxxxx
• Re: How to read a string from a variant array ?
  • From: Bill Renaud
• Re: CHANGING FONT SIZE
  • From: JE McGimpsey
• Re: Moving data if cell is empty
  • From: Ed Peters
• End(XlDown).Row - Problem if only 1 row
  • From: Ed Peters
• Re: How to read a string from a variant array ?
  • From: JE McGimpsey
• Named range reference in VBA for Excel 2007
  • From: Mike
• Re: Specifying a range within an array
  • From: Alan Beban
• RE: IMPORTING WORD TO EXCEL
  • From: gwbdirect
• Re: Formulas
  • From: Bernard Liengme
• RE: VBA or VBE
  • From: Louis
• Re: Call macro in worksheet from userform?
  • From: Ed from AZ
• RE: Help saving file; exporting as .csv
  • From: cottage6
• Re: Formulas
  • From: Bernard Liengme
• Automatically Creating a Command Button
  • From: ianmacinnis
• Re: Specifying a range within an array
  • From: Alan Beban
• Re: Convert to HTML and e-mail selection as the body of the e-mail
  • From: Ron de Bruin
• Re: Reference offset cell (Additional Instructions)
  • From: Bill Renaud
• Change PivotTable Field By Code
  • From: Curious
• Re: Add Custom Button to Quick Access Toolbar
  • From: Ron de Bruin
• Call macro in worksheet from userform?
  • From: Ed from AZ
• Re: Add Custom Button to Quick Access Toolbar
  • From: Randy
• Re: Show Tabs by date
  • From: JE McGimpsey
• Copy a range of cells to all workbooks in a folder?
  • From: harteorama@xxxxxxxxxxxxxx
• Re: File save As
  • From: Dave Peterson
• Re: Reference offset cell
  • From: Bill Renaud
• Re: UDF won't refresh - please help
  • From: Dave Peterson
• RE: IMPORTING WORD TO EXCEL
  • From: Tom Ogilvy
• Re: Refreshing external data
  • From: Dave Peterson
• Get the Data Type of a Property
  • From: DrRocket
• Re: Update Protected Links
  • From: Dave Peterson
• Re: Protected sheet question -- way to allow user to change text align
  • From: Dave Peterson
• Re: Find first empty cell in column J. Copy, paste special, value
  • From: Dave Peterson
• Re: Converting a Column of Numbers Displayed as Text to Numbers
  • From: cardan
• Re: Deleting Rows Based on Column Critieria
  • From: Ron de Bruin
• Re: Update Protected Links
  • From: hurlbut777
• Re: Wrong code?
  • From: Don Guillett
• RE: IMPORTING WORD TO EXCEL
  • From: gwbdirect
• Re: Using dedicated spreadsheet
  • From: Jack
• Re: Replace with an Offset?
  • From: Steve
• Re: Compare two worksheets and Highlight duplicates in each
  • From: Bill Renaud
• Re: Wrong code?
  • From: Mark
• Re: Convert to HTML and e-mail selection as the body of the e-mail.
  • From: Ron de Bruin
• RE: Help saving file; exporting as .csv
  • From: Joel
• RE: Having trouble with this code
  • From: Nolaughmtr
• RE: IMPORTING WORD TO EXCEL
  • From: Tom Ogilvy
• Re: Replace with an Offset?
  • From: Jim Thomlinson
• Re: Replace with an Offset?
  • From: Steve
• Solution: Actual Row Count
  • From: crferguson@xxxxxxxxx
• Re: Replace with an Offset?
  • From: PCLIVE
• Re: Deleting Rows Based on Column Critieria
  • From: blackmanofsteel40
• Replace with an Offset?
  • From: Steve
• Shortcut keys not working .... <grrrr>
  • From: StargateFanFromWork
• Deleting Rows Based on Column Critieria
  • From: blackmanofsteel40
• Re: Referencing an add-in in VBA
  • From: Nobody
• RE: Sheets("Sheet").Copy problem
  • From: JLatham
• Re: CallByName() doesn't
  • From: Jim Rech
• Re: ADO Recordset to Msgbox
  • From: Paul Faulkner
• Re: Get cell address from Lookup function results
  • From: papou
• Enhanced Inputbox
  • From: John Svendsen
• Re: ADO Recordset to Msgbox
  • From: RB Smissaert
• Re: Counting data
  • From: Don Guillett
• Re: Protected sheet question -- way to allow user to change text align
  • From: StargateFanFromWork
• Re: Find first empty cell in column J. Copy, paste special, value
  • From: zzxxcc
• Re: Trach Changes Without sharing the workbook
  • From: JE McGimpsey
• Re: Show Tabs by date
  • From: JW
• Re: Delete Cells when error
  • From: JW
• Re: Show Tabs by date
  • From: JE McGimpsey
• Re: Referencing an add-in in VBA
  • From: JW
• Re: Remove Command Bar when excel file closes
  • From: JW
• Re: Locat a cell, unrelated, again
  • From: JW
• CallByName() doesn't
  • From: christopher.allen
• Re: Locat a cell
  • From: JW
• Re: Counting data
  • From: Don Guillett
• Re: Counting data
  • From: Don Guillett
• Re: Copy and past using a lookup
  • From: Dave Peterson
• Re: UDF using Dates
  • From: Dave Peterson
• Re: Mandatory Field in Excel 2002
  • From: Dave Peterson
• RE: Fixed Width Layout
  • From: Joel
• Re: Update Links after Closing Linked File
  • From: Dave Peterson
• Remove Command Bar when excel file closes
  • From: carlos_ray86
• Re: Show Tabs by date
  • From: JW
• Re: Passing contents of a cell to a macro
  • From: Ken
• Re: Edit/Replace from table or named range?
  • From: JW
• Re: Fixed Width Layout
  • From: Dave Peterson
• Re: add multiple controls
  • From: Dave Peterson
• Re: Find first empty cell in column J. Copy, paste special, value
  • From: Dave Peterson
• Referencing an add-in in VBA
  • From: Nobody
• RE: Counting data
  • From: Hassan
• RE: Counting data
  • From: Mike H
• Re: add multiple controls
  • From: stewart
• Re: UDF using Dates
  • From: Jim Dean
• RE: Counting data
  • From: Hassan
• RE: Counting data
  • From: Mike H
• RE: copy certain data in a excel to another excel
  • From: Joel
• RE: Counting data
  • From: Hassan
• Re: add multiple controls
  • From: stewart
• RE: Counting data
  • From: Mike H
• RE: Counting data
  • From: Hassan
• RE: Counting data
  • From: Mike H
• RE: Counting data
  • From: Hassan
• Re: Using dedicated spreadsheet
  • From: Mike Fogleman
• Re: ADO Recordset to Msgbox
  • From: Bob Phillips
• Re: UDF using Dates
  • From: Bob Phillips
• Re: Adding an appointment to Outlook
  • From: Keith74
• Return names
  • From: Ivica Lopar
• Re: Application.StatusBar not refreshing after ThisWorkbook.Close
  • From: Peter T
• Copy and past using a lookup
  • From: christie . taru
• Re: Converting a Column of Numbers Displayed as Text to Numbers
  • From: christie . taru
• Re: VBA Help downloadable ?
  • From: Bob Phillips
• Re: Application.StatusBar not refreshing after ThisWorkbook.Close
  • From: LEOT
• Re: UDF using Dates
  • From: Bob Phillips
• Re: Copy Paste from Excel to specified word document
  • From: raphiel2063
• Re: Find first empty cell in column J. Copy, paste special, value
  • From: zzxxcc
• Re: On_timer Q
  • From: Sean
• Re: Storing flag values at worksheet level (Property or Properties
  • From: Bill Renaud
• VBA Help downloadable ?
  • From: tianung
• Re: Converting a Column of Numbers Displayed as Text to Numbers
  • From: Gary Keramidas
• Re: Unable extract data from WEB query
  • From: Vijay Kotian
• Re: branching macro
  • From: JE McGimpsey
• Re: Unable extract data from WEB query
  • From: Tim Williams
• Re: Worksheet_SelectionChange allow multiple ranges to be selected
  • From: Bill Renaud
• Textbox font color change (update, but still not quite there)
  • From: Phrank
• Fixed Width Layout
  • From: Little Penny
• copy certain data in a excel to another excel
  • From: ^^
• Re: Worksheet_SelectionChange allow multiple ranges to be selected
  • From: Bill Renaud
• Re: Converting a Column of Numbers Displayed as Text to Numbers
  • From: Ron Coderre
• Re: weird bug - Excel 2007
  • From: Jim Cone
• RE: Insert Formula
  • From: Karen53
• Using dedicated spreadsheet
  • From: Jack
• Re: making a function usable in every sheet
  • From: Nick Revak
• Re: Storing flag values at worksheet level (Property or Properties
  • From: Bill Renaud
• Converting a Column of Numbers Displayed as Text to Numbers
  • From: cardan
• xl2007 limits on TRANSPOSE and INDEX functions?
  • From: Alan Beban
• Re: Having trouble with this code
  • From: Bill Renaud
• Re: Having trouble with this code
  • From: Bill Renaud
• Re: Storing flag values at worksheet level (Property or Properties)
  • From: Bill Renaud
• Re: Having trouble with this code
  • From: Dave Peterson
• Re: Use the autofilter result on one workbook to filter the next list on another workbook
  • From: Mike Fogleman
• Re: Having trouble with this code
  • From: Bill Renaud
• Re: weird bug - Excel 2007
  • From: Bill Renaud
• Re: weird bug - Excel 2007
  • From: Bill Renaud
• Re: Edit/Replace from table or named range?
  • From: Steve
• RE: Having trouble with this code
  • From: OssieMac
• Re: If cell equals anything then
  • From: Don Guillett
• Re: Having trouble with this code
  • From: Bob Phillips
• RE: Having trouble with this code
  • From: JLGWhiz
• RE: Having trouble with this code
  • From: Nolaughmtr
• RE: Having trouble with this code
  • From: Joel
• RE: Having trouble with this code
  • From: OssieMac
• RE: VBA help w/ look & fill in data
  • From: Joel
• Making a selection while using a formula in case of redundant records?
  • From: Ruud Trietsch
• Re: vlookup - Multiple references
  • From: Dave Peterson
• Re: worksheet change problems
  • From: Gary Keramidas
• Re: supress message
  • From: Don Guillett
• Re: add multiple controls
  • From: Dave Peterson
• worksheet change problems
  • From: Gary Keramidas
• Re: Add Custom Button to Quick Access Toolbar
  • From: Randy
• Re: Selectiemenu in Excel
  • From: Otto Moehrbach
• Re: If cell equals anything then
  • From: bpotter
• weird bug - Excel 2007
  • From: ilia
• Re: FileDialog question
  • From: RB Smissaert
• Re: On_timer Q
  • From: Sean
• If cell equals anything then
  • From: bpotter
• Re: FileDialog question
  • From: RB Smissaert
• Re: On_timer Q
  • From: Bob Phillips
• Selectiemenu in Excel
  • From: Ruud Trietsch
• On_timer Q
  • From: Sean
• Re: Reference offset cell
  • From: Bill Renaud
• Re: Reference offset cell
  • From: Bill Renaud
• Re: add multiple controls
  • From: stewart
• Re: Compare two worksheets and Highlight duplicates in each
  • From: Bill Renaud
• Re: branching macro
  • From: ppsa
• Re: supress message
  • From: cubbybear3
• Re: Add Custom Button to Quick Access Toolbar
  • From: Ron de Bruin
• Re: Show Tabs by date
  • From: JE McGimpsey
• Re: branching macro
  • From: JE McGimpsey
• Re: supress message
  • From: cubbybear3
• Re: Compare two excel spread sheet with macro
  • From: Rodrigo Ferreira
• Re: branching macro
  • From: Jim Thomlinson
• Add Custom Button to Quick Access Toolbar
  • From: Randy
• Re: branching macro
  • From: JNW
• Re: branching macro
  • From: Bob Phillips
• Re: branching macro
  • From: Bob Phillips
• Re: Copy/Paste Column Issue Using a Range
  • From: JE McGimpsey
• Re: How do I pass a value in a range command
  • From: Bob Phillips
• RE: Menus with sub menus...
  • From: mark
• Re: Compare two excel spread sheet with macro
  • From: Lillian Lian
• Re: Excel issue ...
  • From: Michael
• Re: branching macro
  • From: Jim Cone
• RE: Compare two worksheets and Highlight duplicates in each
  • From: Jim Thomlinson
• Excel issue ...
  • From: Dell
• RE: Compare two worksheets and Highlight duplicates in each
  • From: Lisab
• Re: branching macro
  • From: Jim Thomlinson
• Re: Compare two excel spread sheet with macro
  • From: Rodrigo Ferreira
• RE: VBA help w/ look & fill in data
  • From: Cam
• RE: procedure too large
  • From: ppsa
• RE: procedure too large
  • From: ppsa
• Re: branching macro
  • From: ppsa
• Re: Why is my variable assignment not working?
  • From: Bill Renaud
• Re: Why is my variable assignment not working?
  • From: Bill Renaud
• Re: Find & Replace Whole Words
  • From: John Svendsen
• Re: Compare two worksheets and Highlight duplicates in each
  • From: Bill Renaud
• RE: procedure too large
  • From: DB74
• Re: Combining 2 arrays side-by-side
  • From: Alan Beban
• RE: procedure too large
  • From: DB74
• RE: procedure too large
  • From: ppsa
• Re: Passing contents of a cell to a macro
  • From: LivingIn32751
• Re: How do I pass a value in a range command
  • From: mopgcw
• Re: Saving / Reading dynamic arrays to / from disk
  • From: Mike
• Re: Compare two worksheets and Highlight duplicates in each
  • From: JW
• Re: Dynamic dropdown?
  • From: Ron Coderre
• Re: branching macro
  • From: JW
• Re: Edit/Replace from table or named range?
  • From: JW
• Re: Show Tabs by date
  • From: JE McGimpsey
• Re: Show Tabs by date
  • From: JW
• Edit/Replace from table or named range?
  • From: Steve
• RE: Refering to new sheet name
  • From: Arnie
• Re: Personal.xls in Office 2007 and Office 2000
  • From: Jessica
• Re: Passing contents of a cell to a macro
  • From: Ken
• Re: Need help writing output to a file without <cr><lf> carriage contr
  • From: Dave D-C
• Re: Class struggle
  • From: George Nicholson
• Re: RON DE BRUIN: Help with CDO Please
  • From: Ron de Bruin
• Re: Personal.xls in Office 2007 and Office 2000
  • From: Jim Rech
• Re: Help required
  • From: Dave D-C
• Re: Help required
  • From: Franz Verga
• Re: Application.StatusBar not refreshing after ThisWorkbook.Close
  • From: Peter T
• Re: SumProduct If?
  • From: Steve
• Re: Formula JLI
  • From: JE McGimpsey
• Re: Personal.xls in Office 2007 and Office 2000
  • From: Jessica
• Re: Application.StatusBar not refreshing after ThisWorkbook.Close
  • From: Peter T
• Re: Class struggle
  • From: David Gerstman
• Re: Formula JLI
  • From: Gord Dibben
• RE: Refering to new sheet name
  • From: barnabel
• Re: Update Protected Links
  • From: Dave Peterson
• Re: Using stored variable in a formula
  • From: JE McGimpsey
• Re: Class struggle
  • From: George Nicholson
• Re: Is this posible to do?
  • From: pgarcia
• Re: Locat a cell
  • From: pgarcia
• Re: Class struggle
  • From: Jim Rech
• RE: Update Protected Links
  • From: hurlbut777
• Re: Protected sheet question -- way to allow user to change text align
  • From: StargateFanFromWork
• Re: Personal.xls in Office 2007 and Office 2000
  • From: Jim Rech
• Re: Renaming modules
  • From: Gord Dibben
• RE: Refering to new sheet name
  • From: Joel
• Re: WorkSheet customproperties
  • From: Jim Rech
• Re: Newbie: Problem with 'Select Case' testing syntax
  • From: Thomas Toth
• Re: Date Issue in excel vba
  • From: phong.lee@xxxxxxxxx
• Refering to new sheet name
  • From: Arnie
• Re: SumProduct If?
  • From: JE McGimpsey
• Re: Web Query
  • From: Randy Harmelink
• Using stored variable in a formula
  • From: tc
• Re: Application.StatusBar not refreshing after ThisWorkbook.Close
  • From: LEO@KCC
• Unable extract data from WEB query
  • From: Vijay Kotian
• Re: supress message
  • From: Don Guillett
• Re: Find & Replace Whole Words
  • From: LEO@KCC
• Re: Macro to record sheet name
  • From: Don Guillett
• Re: Find & Replace Whole Words
  • From: John Svendsen
• SumProduct If?
  • From: Steve
• Re: Find & Replace Whole Words
  • From: Dave Peterson
• Re: Find & Replace Whole Words
  • From: LEO@KCC
• Macro to record sheet name
  • From: tc
• Re: Application.StatusBar not refreshing after ThisWorkbook.Close
  • From: Peter T
• Re: Code help
  • From: Daveo
• Re: Macro to search for a text string
  • From: tc
• Re: Personal.xls in Office 2007 and Office 2000
  • From: Dave Peterson
• Re: Newbie: Problem with 'Select Case' testing syntax
  • From: Dave Peterson
• Re: Find & Replace Whole Words
  • From: Mike H
• Re: Find first empty cell in column J. Copy, paste special, value
  • From: Dave Peterson
• Re: Protected sheet question -- way to allow user to change text align
  • From: StargateFanFromWork
• Re: Find & Replace Whole Words
  • From: John Svendsen
• Re: evaluate contents and select correct column
  • From: Tim Miller
• Re: Newbie: Problem with 'Select Case' testing syntax
  • From: Thomas Toth
• Re: Macro to search for a text string
  • From: JW
• Re: Find & Replace Whole Words
  • From: LEO@KCC
• Macro to search for a text string
  • From: tc
• RE: Macros for WEB Query with password protected site
  • From: Vijay Kotian
• Re: Excel Macros work in Webpage ?
  • From: Jim Rech
• Re: Old Excel 2000 macro won't run under Windows XP
  • From: Jim Rech
• Re: evaluate contents and select correct column
  • From: JW
• Re: Newbie: Problem with 'Select Case' testing syntax
  • From: Thomas Toth
• Re: evaluate contents and select correct column
  • From: JW
• Application.StatusBar not refreshing after ThisWorkbook.Close
  • From: LEO@KCC
• Re: Find first empty cell in column J. Copy, paste special, value
  • From: zzxxcc
• Re: Macro to AutoAnswer
  • From: JW
• Re: Macro to AutoAnswer
  • From: papou
• Re: Newbie: Problem with 'Select Case' testing syntax
  • From: papou
• Macro to AutoAnswer
  • From: tc
• evaluate contents and select correct column
  • From: Tim Miller
• Re: Can you do an Autofilter on defined names in a worksheet?
  • From: Peter T
• Re: Newbie: Problem with 'Select Case' testing syntax
  • From: Thomas Toth
• Re: Newbie: Problem with 'Select Case' testing syntax
  • From: Thomas Toth
• Find & Replace Whole Words
  • From: John Svendsen
• Re: Run-time error '9': Subscript out of range
  • From: Dave Peterson
• Re: Find first empty cell in column J. Copy, paste special, value
  • From: Dave Peterson
• Re: Problems designing combo boxes in forms in Excel 2003
  • From: Dave Peterson
• RE: Newbie: Problem with 'Select Case' testing syntax
  • From: OssieMac
• RE: Newbie: Problem with 'Select Case' testing syntax
  • From: Mike H
• Re: Run-time error '9': Subscript out of range
  • From: Little Penny
• RE: Worksheet.Change macro doesn't run in 2007
  • From: Jialiang Ge [MSFT]
• RE: Moving data if cell is empty
  • From: Joel
• Newbie: Problem with 'Select Case' testing syntax
  • From: Thomas Toth
• RON DE BRUIN: Help with CDO Please
  • From: Newbike
• Re: How do I pass a value in a range command
  • From: Bob Phillips
• RE: programme run help
  • From: Mike H
• RE: programme run help
  • From: barnabel
• How do I pass a value in a range command
  • From: mopgcw
• Re: Code help
  • From: Bob Phillips
• programme run help
  • From: paul
• Code help
  • From: Daveo
• RE: Moving data if cell is empty
  • From: Joel
• Re: Macro to go to the last value
  • From: papou
• Re: Rows hidden by Autofilter vs hidden by changing the Hidden pro
  • From: LEO@KCC
• Macro to go to the last value
  • From: tc
• Re: Stop Data being sorted
  • From: mlm198
• VBA Userform Textbox help
  • From: Joey_83
• Macro to Search
  • From: tc
• Re: Worksheet.Change macro doesn't run in 2007
  • From: Bill Renaud
• Re: Help on some simple code
  • From: Bill Renaud
• Re: Tools/Macro/Visual Basic Editor
  • From: Bill Renaud
• Re: how to set the zoom property
  • From: LetMeDoIt
• Re: splitting text in one column into multiple columns
  • From: Flaminstar
• Re: splitting text in one column into multiple columns
  • From: Gary Keramidas
• RE: Moving data if cell is empty
  • From: Joel
• RE: ado connection sql script select via listbox
  • From: Tom Ogilvy
• Worksheet.Change macro doesn't run in 2007
  • From: David Walker
• RE: Intentionally not validate Sub or Function
  • From: Troubled User
• RE: HOW TO???
  • From: Tom Ogilvy
• Re: splitting text in one column into multiple columns
  • From: Flaminstar
• RE: ado connection sql script select via listbox
  • From: Newman Emanouel
• RE: Intentionally not validate Sub or Function
  • From: Tom Ogilvy
• RE: Set focus on field not on active page of a multipage
  • From: Tom Ogilvy
• Re: add multiple controls
  • From: Dave Peterson
• Re: Run-time error '9': Subscript out of range
  • From: Dave Peterson
• Copy Selected Range to new sheet
  • From: richie c
• Excel Macros work in Webpage ?
  • From: tianung
• RE: Macro Removes Cell Borders
  • From: Tom Ogilvy
• Re: Can you do an Autofilter on defined names in a worksheet?
  • From: Fiona
• Re: Export file as a fixed width file
  • From: Dave Peterson
• RE: HOW TO??? - File 1 of 1 - Next Number.xls (1/1)
  • From: Robin Hood
• RE: HOW TO???
  • From: Robin Hood
• RE: HOW TO???
  • From: Robin Hood
• RE: Run-time error '9': Subscript out of range
  • From: Tom Ogilvy
• Re: Problems designing combo boxes in forms in Excel 2003
  • From: Dave Peterson
• Re: Is this posible to do?
  • From: Dave Peterson
• Re: date reverts to serial number
  • From: stewart
• add multiple controls
  • From: stewart
• RE: Run-time error '9': Subscript out of range
  • From: OssieMac
• Re: how to set the zoom property
  • From: LetMeDoIt
• RE: Run-time error '9': Subscript out of range
  • From: Barb Reinhardt
• Re: Locat a cell
  • From: JW
• Re: splitting text in one column into multiple columns
  • From: Ferris
• Run-time error '9': Subscript out of range
  • From: Little Penny
• Re: cycle thru controls
  • From: Bob Phillips
• Re: cycle thru controls
  • From: cwrm4
• Re: Combining 2 arrays side-by-side
  • From: Alan Beban
• Re: End routine by clicking 'X' on Userform
  • From: Peter T
• Re: Date Issue in excel vba
  • From: phong.lee@xxxxxxxxx
• Re: Combining 2 arrays side-by-side
  • From: RB Smissaert
• Set focus on field not on active page of a multipage
  • From: cwrm4
• Re: Use the autofilter result on one workbook to filter the next list on another workbook
  • From: Kathy Houtami
• Re: Combining 2 arrays side-by-side
  • From: Jim Rech
• Protected sheet question -- way to allow user to change text alignment and font style?
  • From: StargateFanFromWork
• Re: Help on some simple code
  • From: Tim
• Re: Macro Removes Cell Borders
  • From: Don Guillett
• Re: Locat a cell
  • From: pgarcia
• Macro Removes Cell Borders
  • From: Thomas M.
• Export file as a fixed width file
  • From: Ed Peters
• Re: Utility by a MVP for comparision
  • From: Arnie
• Re: Help with Vlookup a date
  • From: Blondie
• Moving data if cell is empty
  • From: Ed Peters
• Re: Build a Macro that uses keystrokes
  • From: JW
• Re: Can you do an Autofilter on defined names in a worksheet?
  • From: Peter T
• RE: Loop - Tabs
  • From: Tom Ogilvy
• Re: End routine by clicking 'X' on Userform
  • From: Arnie
• Help with Vlookup a date
  • From: Jim
• Re: Locat a cell
  • From: JW
• Re: Is this posible to do?
  • From: pgarcia
• Re: Does file name contain the characters XYZ
  • From: JW
• Re: Inserting a "row" in an array
  • From: Alan Beban
• Re: Build a Macro that uses keystrokes
  • From: JW
• Does file name contain the characters XYZ
  • From: Ed Peters
• Re: Opening a workbook to a certain sheet
  • From: alpine7411
• Re: set print area for variable number of columns
  • From: JW
• Re: A message without the box?
  • From: Steve Yandl
• Re: Opening a workbook to a certain sheet
  • From: JW
• Re: Date Issue in excel vba
  • From: JW
• Opening a workbook to a certain sheet
  • From: alpine7411
• Re: Build a Macro that uses keystrokes
  • From: JW
• Re: Date Issue in excel vba
  • From: phong.lee@xxxxxxxxx
• Re: Date Issue in excel vba
  • From: JW
• Re: Date Issue in excel vba
  • From: phong.lee@xxxxxxxxx
• Re: Date Issue in excel vba
  • From: JW
• Re: Custom Toolbar Icons Ugly in Excel 2007
  • From: Greg Lovern
• Re: Date Issue in excel vba
  • From: phong.lee@xxxxxxxxx
• Re: How to leave form displayed
  • From: JW
• Re: Loop - Tabs
  • From: JohnUK
• Re: VBA to say IF cell = any one of 3 values,then do something
  • From: JE McGimpsey
• Re: Date Issue in excel vba
  • From: JW
• Re: Inserting rows
  • From: JW
• Date Issue in excel vba
  • From: phong.lee@xxxxxxxxx
• Re: Loop - Tabs
  • From: Gary Keramidas
• Re: Copy Paste from Excel to specified word document
  • From: JW
• Re: VBA to say IF cell = any one of 3 values,then do something
  • From: PCLIVE
• Re: Created list of worksheet names but need list to be hyperlinke
  • From: maijiuli
• Re: VBA to say IF cell = any one of 3 values,then do something
  • From: Bill Renaud
• Printing Macro
  • From: tc
• Re: Tools/Macro/Visual Basic Editor
  • From: Bill Renaud
• Re: Created list of worksheet names but need list to be hyperlinked to
  • From: JW
• Re: VBA to say IF cell = any one of 3 values,then do something
  • From: JE McGimpsey
• Re: Created list of worksheet names but need list to be hyperlinked to
  • From: JE McGimpsey
• Re: Adding and Deleting custom commandbars
  • From: JE McGimpsey
• Re: Compare two excel spread sheet with macro
  • From: Rodrigo Ferreira
• Re: Stop Data being sorted
  • From: Mark Lincoln
• VBA to say IF cell = any one of 3 values,then do something
  • From: PCLIVE
• Re: VBA Excel
  • From: phong.lee@xxxxxxxxx
• Re: Adding and Deleting custom commandbars
  • From: Robert Bruce
• Re: Can you do an Autofilter on defined names in a worksheet?
  • From: Fiona
• Re: Array Pointer
  • From: Gary Keramidas
• RE: Checkbox variable number
  • From: Tom Ogilvy
• RE: Inserting a "row" in an array
  • From: Bob
• RE: Worksheet_SelectionChange allow multiple ranges to be selected
  • From: Graham Y
• Re: Count number of sheets
  • From: JE McGimpsey
• Count number of sheets
  • From: tc
• RE: Worksheet_SelectionChange allow multiple ranges to be selected
  • From: Tom Ogilvy
• RE: VBA References
  • From: Kevin
• Re: Persistent Data Structures in VBA
  • From: tom . medland
• Re: Rows hidden by Autofilter vs hidden by changing the Hidden propert
  • From: LEO@KCC
• RE: VBA References
  • From: Tom Ogilvy
• Stop Data being sorted
  • From: mlm198
• RE: VBA References
  • From: Kevin
• Re: Copy and Paste LAST ROW of data
  • From: Sam via OfficeKB.com
• RE: VBA References
  • From: JLGWhiz
• VBA References
  • From: Kevin
• Rows hidden by Autofilter vs hidden by changing the Hidden property
  • From: LEO@KCC
• Re: date reverts to serial number
  • From: papou
• RE: HOW TO???
  • From: Tom Ogilvy
• Re: Array Pointer
  • From: Mike H.
• Filling up Forms
  • From: tc
• exporting the result of the SQL sentence(query) to excel
  • From: thread
• Re: Array Pointer
  • From: Gary Keramidas
• Re: Array Pointer
  • From: Mike H.
• Re: Persistent Data Structures in VBA
  • From: Robert Bruce
• Re: Copy and Paste LAST ROW of data
  • From: Tom Ogilvy
• Re: Persistent Data Structures in VBA
  • From: tom . medland
• replacement for filesearch in excel 2007
  • From: LWhite
• Re: Array Pointer
  • From: Mike H.
• Re: Delete last row from range
  • From: Barb Reinhardt
• Re: Check duplicates
  • From: Bernard Liengme
• Run vbacode if OLE-update from Word, but not on 'Workbook_Open'?
  • From: tskogstrom
• Re: Page Break Save
  • From: Dave Peterson
• Re: Beginner - Loop
  • From: Zone
• Re: Use the autofilter result on one workbook to filter the next list on another workbook
  • From: Mike Fogleman
• Persistent Data Structures in VBA
  • From: tom . medland
• Beginner - Loop
  • From: ra
• Re: date reverts to serial number
  • From: stewart
• Page Break Save
  • From: tc
• Re: Utility by a MVP for comparision
  • From: Bob Phillips
• error 336 (visual basic) ActiveX component not correctly registered
  • From: Jose Luis
• Re: Time Format
  • From: Roger Govier
• Re: copy formula
  • From: I.R;))
• Re: Dynamically change the database a PivotTable references
  • From: Roger Govier
• Re: copy formula
  • From: Trevor Shuttleworth
• RE: macro writing formula
  • From: Patrick Bateman
• Utility by a MVP for comparision
  • From: Madiya
• Re: using a cell reference is Vloopup to access external workbooks
  • From: Carl
• Dynamically change the database a PivotTable references
  • From: daxmiller@xxxxxxxxx
• Re: conditionla format based on cursor location
  • From: Trevor Shuttleworth
• UserForm TextBox Font Size
  • From: AussieDave
• Re: Set rng for Column A only (ignores other columns)
  • From: Aria
• how to set the zoom property
  • From: LetMeDoIt
• HOW TO???
  • From: Robin Hood
• Re: Use the autofilter result on one workbook to filter the next list on another workbook
  • From: Kathy Houtami
• Re: Set rng for Column A only (ignores other columns)
  • From: Dave Peterson
• Re: Set rng for Column A only (ignores other columns)
  • From: Aria
• Re: How to have textbox font color change?
  • From: Phrank
• Re: 2 dimensional array (variant)
  • From: Jon Peltier
• going to Today's date with a macro
  • From: Jim
• Re: Insert blank space
  • From: L. Howard Kittle
• Re: Set rng for Column A only (ignores other columns)
  • From: Dave Peterson
• add controls
  • From: stewart
• Set rng for Column A only (ignores other columns)
  • From: Aria
• Re: conditionla format based on cursor location
  • From: Trevor Shuttleworth
• Re: Copy and Paste LAST ROW of data
  • From: Sam via OfficeKB.com
• Re: Excel and HLLAPI
  • From: eBob.com
• Re: Tools/Macro/Visual Basic Editor
  • From: AL2000
• Re: date reverts to serial number
  • From: stewart
• Re: Help on some simple code
  • From: Dana DeLouis
• Re: Help on some simple code
  • From: Bill Renaud
• Excel and HLLAPI
  • From: juncampos
• Re: Tools/Macro/Visual Basic Editor
  • From: AL2000
• Re: Tools/Macro/Visual Basic Editor
  • From: Bill Renaud
• Re: APIs FindWindow and GetWindowText
  • From: Dave D-C
• Re: Tools/Macro/Visual Basic Editor
  • From: JLGWhiz
• date reverts to serial number
  • From: stewart
• Re: ShowAllData doesn't work with Protection
  • From: Dave Peterson
• RE: Help on some simple code
  • From: Joel
• RE: Help on some simple code
  • From: p45cal
• excel 2007 windows class name
  • From: carlos
• Re: Tools/Macro/Visual Basic Editor
  • From: AL2000
• Re: Tools/Macro/Visual Basic Editor
  • From: Bernard Liengme
• Re: ShowAllData doesn't work with Protection
  • From: JTreks
• Re: ShowAllData doesn't work with Protection
  • From: Dave Peterson
• Re: A message without the box?
  • From: Steve Yandl
• How to call this DLL?
  • From: Paul Lenz
• Re: Compare two spreadsheet
  • From: Joel
• Re: Copy and Paste LAST ROW of data
  • From: Mike Fogleman
• End routine by clicking 'X' on Userform
  • From: Arnie
• VB.NET & Excel, Inserting and Sizing Pictures (An Answer)
  • From: eBob.com
• RE: J can't delete old macronames on the list
  • From: Claus Højlund
• Re: Excel 2007: Macros not working in password-protected workbooks
  • From: Jim Rech
• Re: Compare two spreadsheet
  • From: sub . gnav
• Re: Compare two spreadsheet
  • From: sub . gnav
• Re: Open WORD doc from EXCEL using VBA
  • From: Norman Yuan
• Re: Need a time stamp on Pivot Table refresh event
  • From: here@xxxxxx
• RE: Compare two spreadsheet
  • From: Joel
• Re: Copy and Paste LAST ROW of data
  • From: Sam via OfficeKB.com
• Re: macro code to open a file dated yesterday
  • From: Dave Peterson
• Re: ShowAllData doesn't work with Protection
  • From: Dave Peterson
• Re: Need a time stamp on Pivot Table refresh event
  • From: Dave Peterson
• Re: Need a time stamp on Pivot Table refresh event
  • From: here@xxxxxx
• Re: Spreadsheet performance
  • From: saitohajime308
• Re: Need a time stamp on Pivot Table refresh event
  • From: Shah Shailesh
• Re: Need a time stamp on Pivot Table refresh event
  • From: here@xxxxxx
• Compare two spreadsheet
  • From: sub . gnav
• Re: Need a time stamp on Pivot Table refresh event
  • From: Mike Fogleman
• Re: ADO SQL Query, Possible to leave the Recordset open outside it
  • From: RB Smissaert
• udf
  • From: Ian Bartlett
• Re: ADO SQL Query, Possible to leave the Recordset open outside it
  • From: SaeOngJeeMa
• Re: how to export data from excel to visual basic
  • From: RB Smissaert
• Re: APIs FindWindow and GetWindowText
  • From: Peter T
• Re: Find arguments
  • From: Zone
• Re: APIs FindWindow and GetWindowText
  • From: RB Smissaert
• RE: VBA help w/ look & fill in data
  • From: Joel
• RE: VBA help w/ look & fill in data
  • From: Cam
• Need a time stamp on Pivot Table refresh event
  • From: here@xxxxxx
• RE: Help with code
  • From: nowhereman
• RE: APIs FindWindow and GetWindowText
  • From: Tom Ogilvy
• RE: Help a Swim Team, worksheet function issue
  • From: Tom Ogilvy
• Re: APIs FindWindow and GetWindowText
  • From: Dave D-C
• RE: Help using TextBox Value
  • From: Tom Ogilvy
• RE: Help with code
  • From: Tom Ogilvy
• Re: 2 dimensional array (variant)
  • From: Rick Rothstein \(MVP - VB\)
• Excel to Access create new record
  • From: Little Penny
• Help a Swim Team, worksheet function issue
  • From: Todd
• APIs FindWindow and GetWindowText
  • From: Dave D-C
• RE: Help using TextBox Value
  • From: Ayo
• RE: Help using TextBox Value
  • From: Tom Ogilvy
• RE: Help using TextBox Value
  • From: Ayo
• RE: XL03 - Cell Text value not saved
  • From: Tom Ogilvy
• Help with code
  • From: nowhereman
• Re: Copy and Paste LAST ROW of data
  • From: Tom Ogilvy
• Re: Copy and Paste LAST ROW of data
  • From: Tom Ogilvy
• RE: Help using TextBox Value
  • From: Tom Ogilvy
• How to have textbox font color change?
  • From: Phrank
• Re: Supressing MsgBox poop-ups from VBA
  • From: Jon Peltier
• Re: 2 dimensional array (variant)
  • From: Jon Peltier
• Re: Excel 2007 COM: Using SaveAs from PowerShell
  • From: Marco Shaw
• XL03 - Cell Text value not saved
  • From: Robin
• Re: 2 dimensional array (variant)
  • From: Rick Rothstein \(MVP - VB\)
• Re: Custom Menu
  • From: Dave Peterson
• Re: Find arguments
  • From: Dave Peterson
• Saving / Reading dynamic arrays to / from disk
  • From: Mike
• Re: 2 dimensional array (variant)
  • From: RB Smissaert
• Re: 2 dimensional array (variant)
  • From: Chip Pearson
• Custom Menu
  • From: luis.a.roman@xxxxxxxxx
• Re: 2 dimensional array (variant)
  • From: RB Smissaert
• Excel 2007: Macros not working in password-protected workbooks
  • From: rfooks
• Re: Find arguments
  • From: JMB
• RE: For Each Next, Case Select
  • From: Hal
• RE: For Each Next, Case Select
  • From: Joel
• Re: Find arguments
  • From: Dave Peterson
• Re: Copy and Paste LAST ROW of data
  • From: Sam via OfficeKB.com
• Re: Find arguments
  • From: Zone
• Re: Find arguments
  • From: Rick Rothstein \(MVP - VB\)
• Re: Find arguments
  • From: Rick Rothstein \(MVP - VB\)
• Re: Copy and Paste LAST ROW of data
  • From: Mike Fogleman
• Re: Find arguments
  • From: Zone
• Re: Find arguments
  • From: Rick Rothstein \(MVP - VB\)
• Re: Find arguments
  • From: Dave Peterson
• Re: Find arguments
  • From: Zone
• Re: Find arguments
  • From: Rick Rothstein \(MVP - VB\)
• Delete range rows if all cells blank (Was: Re: add new row)
  • From: Dallman Ross
• RE: grade book
  • From: Steve in Columbia
• Excel crash when exiting with the Workbook open
  • From: Alain Vaillancourt
• Re: Excel 2007 COM: Using SaveAs from PowerShell
  • From: Jim Rech
• Re: Last Numeric in a Column?
  • From: RB Smissaert
• Re: Delete last row from range
  • From: condotta
• Re: Copy and Paste LAST ROW of data
  • From: Sam via OfficeKB.com
• Re: Copy and Paste LAST ROW of data
  • From: Sam via OfficeKB.com
• Re: Copy and Paste LAST ROW of data
  • From: Mike Fogleman
• Re: Copy and Paste LAST ROW of data
  • From: Mike Fogleman
• RE: grade book
  • From: Gary''s Student
• Re: Insert blank space
  • From: Ed Peters
• Find arguments
  • From: Zone
• Re: Copy and Paste LAST ROW of data
  • From: Mike Fogleman
• Re: Concatenation prob
  • From: Ron Rosenfeld
• RE: Copy and Paste LAST ROW of data
  • From: Sam via OfficeKB.com
• Copy and Paste LAST ROW of data
  • From: Sam via OfficeKB.com
• Re: Programatically Extend The Formila In A Cell
  • From: John Marshall, MVP
• Re: Concatenation prob
  • From: Ron Rosenfeld
• Re: Concatenation prob
  • From: Equiangular
• Re: Open Workbook, Go To Worksheet ABC, Find XYZ In Column B
  • From: Zone
• Re: Programatically Extend The Formila In A Cell
  • From: Steve
• Protect and Share
  • From: dubo
• Last Numeric in a Column?
  • From: Jeff
• Programatically Extend The Formila In A Cell
  • From: Steve
• Re: Can you do an Autofilter on defined names in a worksheet?
  • From: Peter T
• Open Workbook, Go To Worksheet ABC, Find XYZ In Column B
  • From: Steve
• Re: Insert blank space
  • From: Chip Pearson
• Re: Insert blank space
  • From: Helmut Weber
• Insert blank space
  • From: Ed Peters
• Re: Getting values from desired sheet for printing.
  • From: JLatham
• Re: Contract VBA Programmer
  • From: KC VBA Qns
• Re: Can you do an Autofilter on defined names in a worksheet?
  • From: Fiona
• Re: find cell address of first non empty cell in a row
  • From: eliano
• Re: ADO SQL Query, Possible to leave the Recordset open outside it
  • From: RB Smissaert
• Re: find cell address of first non empty cell in a row
  • From: eliano
• RE: Macro to re-number data
  • From: Joel
• Re: Macro to re-number data
  • From: Dave Peterson
• RE: Best way to make column lists out of row of cells?
  • From: Joel
• Re: Finding data links
  • From: Gary Keramidas
• Delete last row from range
  • From: condotta
• Macro to re-number data
  • From: Little Penny
• RE: VBA help w/ look & fill in data
  • From: Joel
• Re: Macro to Export to a Fixed Width txt file
  • From: Little Penny
• Re: ADO SQL Query, Possible to leave the Recordset open outside it
  • From: SaeOngJeeMa
• RTD C# implementation on vs2005
  • From: Sheldon
• Re: Replace 1 word without opening Files
  • From: Steved
• Re: ADO SQL Query, Possible to leave the Recordset open outside its Su
  • From: RB Smissaert
• ADO SQL Query, Possible to leave the Recordset open outside its Su
  • From: SaeOngJeeMa
• Re: using a cell reference is Vloopup to access external workbooks
  • From: Dave Peterson
• Re: Position of X-Axis (Top, Left)
  • From: jlaufs
• Re: How to run an AS400 macro from an Excel macro
  • From: cubbybear3
• Re: [OT] Norman Jones?
  • From: pippo
• Re: The 101 ROMANTIC SECRETS and TECHNICS
  • From: Don Guillett
• Re: find cell address of first non empty cell in a row
  • From: Steve Yandl
• Re: Locat a cell
  • From: pgarcia
• Re: Locat a cell
  • From: Tom Ogilvy
• Re: Adding custom icons to toolbars
  • From: Ron de Bruin
• RE: Linking Cells
  • From: Barb Reinhardt
• Re: Locat a cell
  • From: pgarcia
• RE: Custom Toolbar Icons Ugly in Excel 2007
  • From: PJ
• Macro help
  • From: NeedExcelHelp07
• Re: Locat a cell
  • From: Barb Reinhardt
• Re: The 101 ROMANTIC SECRETS and TECHNICS
  • From: Rick Rothstein \(MVP - VB\)
• Re: The 101 ROMANTIC SECRETS and TECHNICS
  • From: Rick Rothstein \(MVP - VB\)
• Re: Code to Ignore Certain Cases in a Looping Function
  • From: Rick Rothstein \(MVP - VB\)
• Re: Change offset to same row...
  • From: J.W. Aldridge
• [OT] Norman Jones?
  • From: pippo
• Linking Cells
  • From: alpine7411
• Re: using a cell reference is Vloopup to access external workbooks
  • From: Tom Ogilvy
• Re: Windows XP zip problem
  • From: Ron de Bruin
• Re: VBA Excel
  • From: phong.lee@xxxxxxxxx
• Re: Windows XP zip problem
  • From: Tom Ogilvy
• Re: VBA Excel
  • From: Tom Ogilvy
• Re: Cell input to automatically divide itself
  • From: Don Guillett
• Re: Locat a cell
  • From: pgarcia
• Re: Transposing rows/columns in an array
  • From: Alan Beban
• Best way to make column lists out of row of cells?
  • From: Ed from AZ
• Re: Inputbox with a drop down?
  • From: RB Smissaert
• Re: Locat a cell
  • From: Tom Ogilvy
• Re: VBA Excel
  • From: phong.lee@xxxxxxxxx
• Re: Excel 2003 Bug regarding autofilter
  • From: Dave Peterson
• RE: VBA Excel
  • From: Tom Ogilvy
• VBA help w/ look & fill in data
  • From: Cam
• Re: Windows XP zip problem
  • From: Ron de Bruin
• Re: Cell input to automatically divide itself
  • From: Tom Ogilvy
• Re: Windows XP zip problem
  • From: Tom Ogilvy
• Re: Inputbox with a drop down?
  • From: JW
• Re: Error with macro after recording
  • From: JW
• Re: VBA Excel
  • From: phong.lee@xxxxxxxxx
• Re: Web quieries and memory
  • From: Don Guillett
• Re: Transposing rows/columns in an array
  • From: Alan Beban
• Re: Windows XP zip problem
  • From: Mark Driscol
• Excel 2003 Bug regarding autofilter
  • From: lars . knutus
• Re: VBA Excel
  • From: Don Guillett
• Re: Rename and save without overwriting the exisiting file
  • From: Thulasiram
• Re: Replace 1 word without opening Files
  • From: Ron de Bruin
• Re: Change offset to same row...
  • From: J.W. Aldridge
• Re: Can you do an Autofilter on defined names in a worksheet?
  • From: Peter T
• Re: Supressing MsgBox poop-ups from VBA
  • From: JW
• Web quieries and memory
  • From: J.W. Aldridge
• Re: Is this posible to do?
  • From: Dave Peterson
• Re: SumProduct Function
  • From: Dave Peterson
• Re: Locat a cell
  • From: JW
• Excel 2007 COM: Using SaveAs from PowerShell
  • From: Marco Shaw
• Re: Windows XP zip problem
  • From: Ron de Bruin
• Re: A tricky one: anything like an array of functions?
  • From: Charles
• Re: using a cell reference is Vloopup to access external workbooks
  • From: Dave Peterson
• Re: VBA Excel
  • From: phong.lee@xxxxxxxxx
• Re: Change offset to same row...
  • From: Don Guillett
• Re: Change offset to same row...
  • From: J.W. Aldridge
• Re: A tricky one: anything like an array of functions?
  • From: Robert Bruce
• Re: The 101 ROMANTIC SECRETS and TECHNICS
  • From: Don Guillett
• Re: SumProduct Function
  • From: Don Guillett
• Re: Cell input to automatically divide itself
  • From: Don Guillett
• Re: Change offset to same row...
  • From: Don Guillett
• Re: Change offset to same row...
  • From: J.W. Aldridge
• Re: Before Change Event?
  • From: Don Guillett
• Re: A tricky one: anything like an array of functions?
  • From: Charles
• Re: Change offset to same row...
  • From: Don Guillett
• Re: How to sort data w/ formulas?
  • From: Speedmaster
• Re: Insert two lines each time a value in Column L changes
  • From: Don Guillett
• RE: macro writing formula
  • From: Michael
• Re: VBA Excel
  • From: JW
• VBA Excel
  • From: phong . lee
• Re: macro writing formula
  • From: JW
• Change offset to same row...
  • From: J.W. Aldridge
• Re: Cell input to automatically divide itself
  • From: Don Guillett
• Re: Select for printing
  • From: Saintsman
• Re: Highlight/remove duplicate rows
  • From: Joel
• Re: A tricky one: anything like an array of functions?
  • From: Charles
• Re: Windows XP zip problem
  • From: Mark Driscol
• Re: Can you do an Autofilter on defined names in a worksheet?
  • From: Peter T
• Re: A tricky one: anything like an array of functions?
  • From: Ron Rosenfeld
• Re: Supressing MsgBox poop-ups from VBA
  • From: Steve Yandl
• Re: A tricky one: anything like an array of functions?
  • From: Don Guillett
• RE: Windows XP zip problem
  • From: Tom Ogilvy
• A tricky one: anything like an array of functions?
  • From: Charles
• How to sort data w/ formulas?
  • From: Speedmaster
• Re: Insert two lines each time a value in Column L changes
  • From: Don Guillett
• Re: Highlight/remove duplicate rows
  • From: Blasting Cap
• RE: running varibiables into vba
  • From: Tom Ogilvy
• Re: More Excel 2007 Speed Issues
  • From: Bahali Bali
• RE: Collating data from two or more "Workbooks" into another "Workbook
  • From: Tom Ogilvy
• RE: J can't delete old macronames on the list
  • From: Claus Højlund
• Highlight/remove duplicate rows
  • From: Blasting Cap
• running varibiables into vba
  • From: paul
• Windows XP zip problem
  • From: Mark Driscol
• Re: macro to disable auto refresh
  • From: Jason
• Re: Set Range with Variable
  • From: Allen Geddes
• Re: Position of X-Axis (Top, Left)
  • From: Jon Peltier
• Re: Passing variables back to main procedure
  • From: Jon Peltier
• Re: Supressing MsgBox poop-ups from VBA
  • From: Jon Peltier
• Re: Set Range with Variable
  • From: Chip Pearson
• Re: Set Range with Variable
  • From: Zone
• Re: Supressing MsgBox poop-ups from VBA
  • From: JW
• Re: Find Multiple Occurence Of Text In A Column
  • From: JW
• Supressing MsgBox poop-ups from VBA
  • From: Chrisso
• Re: Best practice for deploying a VBA system used in multiple locations?
  • From: Zone
• Re: Getting values from desired sheet for printing.
  • From: Sinner
• VBA WMI Intermittent Error
  • From: david . richards
• Re: macro to run go to
  • From: Dave Peterson
• Re: add new row
  • From: Dallman Ross
• Re: using a cell reference is Vloopup to access external workbooks
  • From: Dave Peterson
• Re: Data lookup on 2nd excel sheet.
  • From: radink
• Re: Can you do an Autofilter on defined names in a worksheet?
  • From: Dave Peterson
• Re: Copy a Sheet & Rename based on Cell Value Q
  • From: Sean
• Re: Copy / Paste Value
  • From: Dave Peterson
• Re: Copy / Paste Value
  • From: Dave Peterson
• Best practice for deploying a VBA system used in multiple locations?
  • From: Chrisso
• Re: Copy a Sheet & Rename based on Cell Value Q
  • From: Jim Cone
• Copy a Sheet & Rename based on Cell Value Q
  • From: Sean
• Re: Use the autofilter result on one workbook to filter the next list on another workbook
  • From: Mike Fogleman
• RE: Sorting Data
  • From: Joel
• Re: Copy / Paste Value
  • From: I.R;))
• Re: inserting pictures in Excel 2007 different than in Excel 2003
  • From: akyhne
• RE: Unpredictable results with Macro and VBA
  • From: joesf16
• Re: Procedure Too Large
  • From: Peter T
• Re: Incrementing numbers
  • From: neal
• Re: Incrementing numbers
  • From: Viquar
• Re: case
  • From: Snake Plissken
• Sorting Data
  • From: christie . taru
• Re: Incrementing numbers
  • From: neal
• Re: Rename and save without overwriting the exisiting file
  • From: Thulasiram
• Re: Rename and save without overwriting the exisiting file
  • From: Thulasiram
• RE: Rename and save without overwriting the exisiting file
  • From: OssieMac
• Can you do an Autofilter on defined names in a worksheet?
  • From: Fiona
• Re: Finding Start Date
  • From: Rick Rothstein \(MVP - VB\)
• Re: Filter on Color
  • From: ssGuru
• Rename and save without overwriting the exisiting file
  • From: Thulasiram
• Re: HELP.. Is it possibe???
  • From: Jim Rech