microsoft.public.excel.programming
- Re: Dynamic Range
- RE: dilemma with getting sql data
- Re: Can not access MS Visual Basic Documentation
- Re: Data Validation and a Clear Button
- Re: RE: Where to put code
- Re: Data Validation and a Clear Button
- Re: Data Validation and a Clear Button
- Re: Named Range Formula
- Re: can't select worksheet
- Linked Data Validation(s)
- RE: Convert Columns to Rows based upon a duplicate value
- Re: Dynamic Range
- Re: Data Validation and a Clear Button
- RE: Convert Columns to Rows based upon a duplicate value
- Re: RE: Where to put code
- Re: can't select worksheet
- RE: Convert Columns to Rows based upon a duplicate value
- RE: Need help with Macro
- Re: Dynamic Range
- Need help with Macro
- RE: dilemma with getting sql data
- computer programming
- Re: dilemma with getting sql data
- Re: Unloading /Closing all userforms
- Re: Named Range Formula
- Re: Unloading /Closing all userforms
- Re: Data Validation and a Clear Button
- Re: Array formula acting as it shuld ... but
- RE: dilemma with getting sql data
- Re: Data Validation and a Clear Button
- Re: Data Validation and a Clear Button
- Re: Named Range Formula
- Re: COMBINE TWO MACROS INTO ONE
- Re: Array formula acting as it shuld ... but
- Re: Split ActiveCell.Value and delete element if.........
- From: Rick Rothstein \(MVP - VB\)
- Array formula acting as it shuld ... but
- Re: COMBINE TWO MACROS INTO ONE
- From: Rick Rothstein \(MVP - VB\)
- Re: can't select worksheet
- Re: Data Validation and a Clear Button
- Re: How to evaluate string form of numeric expression in VBA?
- Re: delete rows
- Data Validation and a Clear Button
- Re: Split ActiveCell.Value and delete element if.........
- Re: COMBINE TWO MACROS INTO ONE
- Re: COMBINE TWO MACROS INTO ONE
- From: Rick Rothstein \(MVP - VB\)
- Re: HOW TO MIX TWO MACRO CODES
- Re: Searching online behind the scenes
- Re: COMBINE TWO MACROS INTO ONE
- Re: How to evaluate string form of numeric expression in VBA?
- Re: RE: Where to put code
- RE: COMBINE TWO MACROS INTO ONE
- Re: Insert Date in correct cell
- Re: Insert Date in correct cell
- COMBINE TWO MACROS INTO ONE
- Re: Ignore breakpoint when running a macro
- Re: Ignore breakpoint when running a macro
- Named Range Formula
- Re: can't select worksheet
- Re: How to evaluate string form of numeric expression in VBA?
- Re: Insert Date in correct cell
- RE: can't select worksheet
- Re: toggle borders
- Re: can't select worksheet
- Re: Match function in VBA
- Re: Dynamic Range
- Re: How to evaluate string form of numeric expression in VBA?
- Re: Don't want backup copy in XLSTART
- Re: Dynamic Range
- Re: Workable Scatter Plot Data Points
- Re: Match function in VBA
- Re: RE: Where to put code
- Re: Problems with autofiltering and dates I think
- Re: Enable Excel Speech
- RE: can't select worksheet
- .formula property bug?
- Re: HOW TO MIX TWO MACRO CODES
- HOW TO MIX TWO MACRO CODES
- Insert Date in correct cell
- RE: can't select worksheet
- RE: From Column to Row without blank cells
- Re: toggle borders
- Re: toggle borders
- From: Rick Rothstein \(MVP - VB\)
- Re: listbox remove item according to the value
- toggle borders
- listbox remove item according to the value
- Re: Run macro when file closes
- Re: How to evaluate string form of numeric expression in VBA?
- Run macro when file closes
- Re: Problems with autofiltering and dates I think
- Re: Split ActiveCell.Value and delete element if.........
- From: Rick Rothstein \(MVP - VB\)
- Re: Match function in VBA
- Re: Split ActiveCell.Value and delete element if.........
- RE: Split ActiveCell.Value and delete element if.........
- Re: Split ActiveCell.Value and delete element if.........
- From: Rick Rothstein \(MVP - VB\)
- Re: Don't want backup copy in XLSTART
- Re: Dynamic Range
- Re: Problems with autofiltering and dates I think
- Dynamic Range
- Re: Don't want backup copy in XLSTART
- Re: Problems with autofiltering and dates I think
- Where to put code
- RE: Drawing across Data from different workbook using long list.
- Re: How to evaluate string form of numeric expression in VBA?
- Re: Don't want backup copy in XLSTART
- RE: Drawing across Data from different workbook using long list.
- How to evaluate string form of numeric expression in VBA?
- Re: Endless Loop - Shortcut Key To Stop Code?
- Re: Endless Loop - Shortcut Key To Stop Code?
- Re: assign macro to button programmatically
- Re: assign macro to button programmatically
- assign macro to button programmatically
- Re: Speed the macro works
- Re: Problems with autofiltering and dates I think
- Re: Don't want backup copy in XLSTART
- Re: Enable Excel Speech
- Re: Enable Excel Speech
- Re: Problems with autofiltering and dates I think
- Enable Excel Speech
- RE: From Column to Row without blank cells
- Re: Macros in Formulas
- Problems with autofiltering and dates I think
- Re: Endless Loop - Shortcut Key To Stop Code?
- RE: Drawing across Data from different workbook using long list.
- Re: Can not access MS Visual Basic Documentation
- RE: Drawing across Data from different workbook using long list.
- RE: Drop List
- RE: Drawing across Data from different workbook using long list.
- Drop List
- Re: recalling named ranges as must fill cell
- Re: Need help with userform vb code, any help would be appreciated.
- From: HammerJoe@xxxxxxxxx
- RE: Football Pool Fun HELP
- From: JamesInNeedFootballInDeed
- RE: Football Pool Fun HELP
- Re: Macro Path
- RE: solve for a variable
- Re: Macro Path
- RE: Need help with userform vb code, any help would be appreciated.
- Re: Importing Data - 2
- Re: protect sheet with password
- Re: Having difficulty with scroll bar in VB
- Re: Having difficulty with scroll bar in VB
- recalling named ranges as must fill cell
- RE: Macros in Formulas
- Drag-n-Drop_XLA_Install (VB Script)
- RE: Football Pool Fun HELP
- From: JamesInNeedFootballInDeed
- Drawing across Data from different workbook using long list.
- RE: Excel Form HELP
- Re: Importing Data - 2
- From: Angelika & Rocky Mckinley
- RE: Importing data
- Re: Zoom to fit the page width
- RE: xl probs.
- Importing data
- xl probs.
- RE: check criteria and run macro
- Re: Having difficulty with scroll bar in VB
- RE: Formula / Football Pool / HELP
- check criteria and run macro
- Re: how to make a function(vb script) global (as in used from every w.
- Re: Use lookup to write to cell
- Re: Having difficulty with scroll bar in VB
- go and check on spesific page and then run macro
- RE: protect sheet with password
- RE: Match function in VBA
- Re: Automated Build -- auto import of .BAS module into XLS or XLT?
- Re: Changing font color based on positive or negative number
- Re: Cell formating
- Re: Having difficulty with scroll bar in VB
- Re: Automated Build -- auto import of .BAS module into XLS or XLT?
- Re: Having difficulty with scroll bar in VB
- Re: code to choose tab color?
- Re: Userform - need to access data from a particular sheet
- Re: Speed the macro works
- Re: Function To Combine two 3-D arrays
- Automated Build -- auto import of .BAS module into XLS or XLT?
- Re: Function To Combine two 3-D arrays
- RE: Search code help needed??
- IF Condition in Excel
- Function To Combine two 3-D arrays
- Re: Speed the macro works
- Re: Cell formating
- RE: Search code help needed??
- Cell formating
- Re: Alternatives to "WorksheetFunction.VLookup"
- Re: Alternatives to "WorksheetFunction.VLookup"
- Re: Displaying YTD for each Month Selected
- RE: Search code help needed??
- Re: Displaying YTD for each Month Selected
- Re: Speed the macro works
- RE: Search code help needed??
- Re: small easy userform
- RE: Search code help needed??
- Opening explorer using VB
- RE: Search code help needed??
- Re: Macros in Formulas
- Re: small easy userform
- RE: Excel Form HELP
- Re: small easy userform
- Re: Speed the macro works
- RE: Excel Form HELP
- Re: Speed the macro works
- Re: Speed the macro works
- Re: Use lookup to write to cell
- RE: Updating time made by macro in excel
- Re: delete rows
- Re: Updating time made by macro in excel
- Re: delete rows
- Re: Use lookup to write to cell
- Re: if then else
- Excel Form HELP
- Re: how do I add vba reference to Microsoft Forms 2.0 Object Library?
- Re: small easy userform
- Re: if then else
- Re: how do I add vba reference to Microsoft Forms 2.0 Object Library?
- Re: if then else
- RE: if then else
- Re: how do I add vba reference to Microsoft Forms 2.0 Object Library?
- Re: how do I add vba reference to Microsoft Forms 2.0 Object Library?
- Re: Alternatives to "WorksheetFunction.VLookup"
- From: Rick Rothstein \(MVP - VB\)
- Re: For Each Ctl In Me.Controls
- RE: if then else
- RE: if then else
- Re: small easy userform
- RE: if then else
- Re: if then else
- For Each Ctl In Me.Controls
- Re: Userform - need to access data from a particular sheet
- Re: delete rows
- if then else
- Re: Alternatives to "WorksheetFunction.VLookup"
- RE: delete rows
- delete rows
- Re: Alternatives to "WorksheetFunction.VLookup"
- Re: Creating PDF from Excel Using PrintToFile
- Re: automating import of several text files from specified folder
- Re: Alternatives to "WorksheetFunction.VLookup"
- Re: Alternatives to "WorksheetFunction.VLookup"
- RE: Alternatives to "WorksheetFunction.VLookup"
- Alternatives to "WorksheetFunction.VLookup"
- RE: automating import of several text files from specified folder
- Re: Hiding rows with zero values
- Re: excel macro in '97 does not work in Vista
- Re: Use lookup to write to cell
- Re: In Access Can't Run Excel Macro Through Automation
- RE: Search code help needed??
- RE: Search code help needed??
- Re: Hiding rows with zero values
- Hiding rows with zero values
- Re: Extract Cell Contents to String
- Re: Help with find/replace
- Need help with userform vb code, any help would be appreciated.
- From: HammerJoe@xxxxxxxxx
- Re: Macro Path
- RE: Search code help needed??
- Re: vb add-in manager is empty
- RE: Search code help needed??
- Re: Macro Path
- Re: Macro Path
- Re: Macro Path
- Re: RE: Deletions
- Re: Macro Path
- Re: Need help creating a formula
- Re: Macro Path
- RE: Search code help needed??
- Re: Format sheet programmaticlly??
- Re: Search worksheet from add-in
- RE: Help with find/replace
- Re: Format sheet programmaticlly??
- Re: Macro Path
- Help with find/replace
- RE: Search code help needed??
- RE: Search code help needed??
- Re: Macro Path
- Macro Path
- Re: Adding to text's togther in a data value in a chart
- From: ryan . fitzpatrick3
- Re: Change Text size on focus
- Re: Adding to text's togther in a data value in a chart
- From: ryan . fitzpatrick3
- Re: Change Text size on focus
- Re: Change Text size on focus
- RE: Pivot Table Macro
- RE: Change Text size on focus
- RE: Pivot Table Macro
- RE: Pivot Table Macro
- Re: Need help creating a formula
- Re: Displaying YTD for each Month Selected
- Re: Displaying YTD for each Month Selected
- RE: how to format a date to be used in sqlstring in excel 2007- contd
- Re: Need help creating a formula
- RE: Pivot Table Macro
- RE: Search code help needed??
- Re: Copy date from row 1 to last row next sheet
- RE: Search code help needed??
- how to format a date to be used in sqlstring in excel 2007- contd
- RE: Search code help needed??
- RE: Deletions
- RE: Search code help needed??
- Re: Deletions
- RE: Search code help needed??
- RE: Search code help needed??
- Re: Need help creating a formula
- Deletions
- RE: Search code help needed??
- Re: Adding to text's togther in a data value in a chart
- Re: Need Text box value to be $5,000.00 not 5000
- Re: Shapes(Count)
- Re: Copy date from row 1 to last row next sheet
- RE: Search code help needed??
- Shapes(Count)
- Search code help needed??
- Re: Adding to text's togther in a data value in a chart
- From: ryan . fitzpatrick3
- Re: Need help creating a formula
- Re: Copy date from row 1 to last row next sheet
- RE: Drag & Drop in ListBox Ctrl: Find pointer position on mouse up
- Macro Path
- Re: Adding to text's togther in a data value in a chart
- From: ryan . fitzpatrick3
- Re: RibbonX: Problem with OnLoad
- Re: SpecialCells(Formula) --> Value
- Re: Need Text box value to be $5,000.00 not 5000
- Re: In Access Can't Run Excel Macro Through Automation
- Re: Need Text box value to be $5,000.00 not 5000
- Re: SpecialCells(Formula) --> Value
- Re: Creating PDF from Excel Using PrintToFile
- Re: SpecialCells(Formula) --> Value
- Re: Autofilter +Create Sheets
- Re: RibbonX: Problem with OnLoad
- Re: copy WB without VBA: copied sheets link back to source WB
- Re: Certificate not trusted
- SpecialCells(Formula) --> Value
- Re: How to: if a range is not empty don't allow close?
- Re: copy WB without VBA: copied sheets link back to source WB
- Re: Code replacement
- copy WB without VBA: copied sheets link back to source WB
- Code replacement
- Re: Spell checking textbox on a userform
- Re: Spell checking textbox on a userform
- How to close All Workbooks
- Re: Peter T's Copy WorkBook Contents Copy
- Re: Spell checking textbox on a userform
- Autofilter +Create Sheets
- Re: Chart transparency
- Re: Simpler way for nested If statements (VBA)
- RibbonX: Problem with OnLoad
- Re: Unique values in a macro
- Re: Chart transparency
- RE: Displaying Text on a Forms 2 Form
- Re: Need help creating a formula
- RE: Automate Excel download of csv file without proper URL?
- Re: Please Macro or Formula Help needed
- Re: Displaying YTD for each Month Selected
- RE: Macro malfuntion
- Re: Macro malfuntion
- Re: Please Macro or Formula Help needed
- Unique values in a macro
- Re: Please Macro or Formula Help needed
- RE: Displaying Text on a Forms 2 Form
- Re: Spell checking textbox on a userform
- Re: Use lookup to write to cell
- Re: Please Macro or Formula Help needed
- RE: tricky password
- RE: conjugating 2 sheets. pleae help i'm already late for the dead
- Re: Please Macro or Formula Help needed
- Re: display cell only if it contains a value
- Re: Overcoming an Error Message Q
- Re: Please Macro or Formula Help needed
- Re: Use lookup to write to cell
- Overcoming an Error Message Q
- Re: Please Macro or Formula Help needed
- Re: Use lookup to write to cell
- Re: Extract Cell Contents to String
- Re: Use lookup to write to cell
- Re: Displaying YTD for each Month Selected
- RE: Subscript Out of Range ... Setting Page Breaks
- Re: Please Macro or Formula Help needed
- Re: Please Macro or Formula Help needed
- Re: Please Macro or Formula Help needed
- Re: Please Macro or Formula Help needed
- Subscript Out of Range ... Setting Page Breaks
- Re: Please Macro or Formula Help needed
- Re: Please Macro or Formula Help needed
- RE: Simulation
- Re: Please Macro or Formula Help needed
- Re: List all internet explorer (or other) windows (and close them)
- Re: Please Macro or Formula Help needed
- Re: I want If and Vlookup together in one cell
- Re: Please Macro or Formula Help needed
- RE: Please Macro or Formula Help needed
- Re: Please Macro or Formula Help needed
- Please Macro or Formula Help needed
- Displaying Text on a Forms 2 Form
- Re: Default commandbutton
- From: Rick Rothstein \(MVP - VB\)
- Save a shared file as webpage
- Re: Empty a cell if the values equal to "IN" , "MC" or "PP"
- Re: Creating PDF from Excel Using PrintToFile
- Re: IF and OR Functions
- RE: Return Rows of Selected Range in a Pivot
- RE: Return Rows of Selected Range in a Pivot
- RE: Simulation
- Re: Auto Populate multi cells
- RE: Return Rows of Selected Range in a Pivot
- Re: Sub to copy n paste as values based on an "instructions" table
- RE: Simpler way for nested If statements (VBA)
- Re: Creating PDF from Excel Using PrintToFile
- Re: How to: if a range is not empty don't allow close?
- Re: How to: if a range is not empty don't allow close?
- RE: How to: if a range is not empty don't allow close?
- RE: How to: if a range is not empty don't allow close?
- RE: Error code 13
- RE: Error code 13
- Re: Dynamically Building List
- Re: Delete rows containing same value in two columns
- RE: Error code 13
- How to: if a range is not empty don't allow close?
- Re: Error code 13
- RE: Error code 13
- Re: Delete rows containing same value in two columns
- RE: Automation performance degradation in Excel 2007
- RE: Delete rows containing same value in two columns
- Re: Create macro to load custom toolbar
- Re: Simpler way for nested If statements (VBA)
- RE: Macro to grap certain cells and copy.....
- RE: Error code 13
- RE: Macro to grap certain cells and copy.....
- RE: Simpler way for nested If statements (VBA)
- Delete rows containing same value in two columns
- RE: Error code 13
- Re: Create macro to load custom toolbar
- From: Jose Ruben Gonzalez-Baird
- RE: Error code 13
- RE: Simpler way for nested If statements (VBA)
- Re: Simpler way for nested If statements (VBA)
- Re: User Form
- RE: Error code 13
- Re: Create macro to load custom toolbar
- Help with code: Security and web queries
- RE: Create macro to load custom toolbar
- Re: User Form
- Simpler way for nested If statements (VBA)
- Re: User Form
- RE: conjugating 2 sheets. pleae help i'm already late for the deadline
- Re: conjugating 2 sheets. pleae help i'm already late for the deadline
- Re: User Form
- RE: Call a Control_Click Event when UserForm is Initialized
- RE: User Form
- RE: Error code 13
- User Form
- Re: Error: can't find project or library
- RE: Error code 13
- Re: Need help creating a formula
- RE: Shared Excel worksheet
- Re: Error: can't find project or library
- Re: Need help creating a formula
- Re: Error: can't find project or library
- RE: Error: can't find project or library
- RE: Drag & Drop in ListBox Ctrl: Find pointer position on mouse up?
- Re: Drag & Drop in ListBox Ctrl: Find pointer position on mouse up?
- RE: parameter to open file name in macro
- Re: Adding to text's togther in a data value in a chart
- Re: Chart transparency
- Re: Dynamically Building List
- RE: Error: can't find project or library
- RE: Error: can't find project or library
- Automate Excel download of csv file without proper URL?
- Error: can't find project or library
- Re: Select Cell and open UserForm
- Re: Need Help with Pivot Table
- Re: how do i get word conversion number to text in excel (100 = "hundr
- Re: Pivot Table Calculated Field
- Re: copy to next blank cell in colum
- RE: how do i get word conversion number to text in excel (100 = "hundr
- Re: copy to next blank cell in colum
- RE: Macro to grap certain cells and copy.....
- Re: Select Cell and open UserForm
- Re: Help with code creation
- Chart transparency
- MACRO TO GET BALANCE FIGURE
- Re: Peter T's Copy WorkBook Contents Copy
- Re: In Access Can't Run Excel Macro Through Automation
- RE: Macro to grap certain cells and copy.....
- Re: range.address, replace characters
- Re: Automatically Excuting a Macro in a different workbook ?
- Macro to grap certain cells and copy.....
- Re: Need help creating a formula
- Re: Automatically Excuting a Macro in a different workbook ?
- Re: Test if a file is password protected
- Re: Refresh workbook changes without saving
- Re: Refresh workbook changes without saving
- Re: Test if a file is password protected
- Re: complicated change to formula (conintuous)
- Series function& protect sheet in excel 2007
- Re: Peter T's Copy WorkBook Contents Copy
- Re: In Access Can't Run Excel Macro Through Automation
- Re: Automatically Excuting a Macro in a different workbook ?
- Re: Disable Menu (CommandBar) if not workbook is opened
- Re: Automatically Excuting a Macro in a different workbook ?
- Re: Automatically Excuting a Macro in a different workbook ?
- RE: XML and DOMDocument
- Test if a file is password protected
- Re: XML and DOMDocument
- Re: Macro to Find a specific data set and do a count
- Re: XML and DOMDocument
- RE: Paste and Paste Special options are disabled
- Re: IF and OR Functions
- RE: Shared Excel worksheet
- Re: Peter T's Copy WorkBook Contents Copy
- Re: Peter T's Copy WorkBook Contents Copy
- XML and DOMDocument
- Re: Automatically Excuting a Macro in a different workbook ?
- Re: Peter T's Copy WorkBook Contents Copy
- Re: Peter T's Copy WorkBook Contents Copy
- RE: Simulation
- Re: Sub to copy n paste as values based on an "instructions" table
- Re: In Access Can't Run Excel Macro Through Automation
- RE: Shared Excel worksheet
- Re: Automatically Excuting a Macro in a different workbook ?
- Re: Need help creating a formula
- Re: Simulation
- RE: rotation of an arrow created by an drawing object
- Re: Paste and Paste Special options are disabled
- Re: userform from scratch
- Re: Peter T's Copy WorkBook Contents Copy
- Re: Peter T's Copy WorkBook Contents Copy
- Re: excel
- Re: Custom Function Desired
- Re: Open Workbook Assignment
- Re: Custom Function Desired
- Re: Custom Function Desired
- Re: Custom Function Desired
- Re: how do i get word conversion number to text in excel (100 = "hundr
- Re: add new worksheet after specific sheet
- Re: Open Workbook Assignment
- Re: Need help creating a formula
- Open Workbook Assignment
- Re: userform from scratch
- Re: Custom Function Desired
- Paste and Paste Special options are disabled
- Paste and Paste Special options are disabled
- Paste and Paste Special options are disabled
- Re: Keydown event on a userform
- Re: etract unique data from multiple workbooks after extracting data
- Re: Help with search code
- Re: Need help creating a formula
- Scrolbars
- Re: Need help creating a formula
- Form ScrollBar Help
- RE: Dynamically Building List
- Need help creating a formula
- Re: retrieve data from Access Database
- RE: rotation of an arrow created by an drawing object
- Re: Automatically Excuting a Macro in a different workbook ?
- In Access Can't Run Excel Macro Through Automation
- RE: Simulation
- Re: Macro to Find a specific data set and do a count
- Re: Dynamically Building List
- Dynamically Building List
- Re: Macro to Find a specific data set and do a count
- Re: Assigning a hotkey to run only from a given range
- Re: Sub to copy n paste as values based on an "instructions" table
- Re: Saving a file every fifteen minutes
- Re: Automatically Excuting a Macro in a different workbook ?
- Re: Showing text on A Userform
- Re: VB/VBA to read Task Manager
- Macro to Find a specific data set and do a count
- RE: delete checkboxs
- Add records to sheets based on a variables table
- Re: VB/VBA to read Task Manager
- Re: VB/VBA to read Task Manager
- Re: etract unique data from multiple workbooks after extracting data
- XL Odd behavior interaction between dynamic range and Sheet_Deactivate macro
- RE: delete checkboxs
- Re: Truncate Left Characters in Cell Value
- VB/VBA to read Task Manager
- VB/VBA to read Task Manager
- VB/VBA to read Task Manager
- Re: Truncate Left Characters in Cell Value
- RE: Pivot Table based on data in protected cells
- RE: delete checkboxs
- Re: range.address, replace characters
- From: Rick Rothstein \(MVP - VB\)
- Re: range.address, replace characters
- From: Rick Rothstein \(MVP - VB\)
- Re: Add record to end of list, variables table
- Re: Truncate Left Characters in Cell Value
- Re: Truncate Left Characters in Cell Value
- From: Rick Rothstein \(MVP - VB\)
- RE: delete checkboxs
- Re: Copying data
- RE: Excel Justify
- Re: Remove extra space within text
- Re: Remove extra space within text
- From: Rick Rothstein \(MVP - VB\)
- Re: Worksheet Change Event Does Not Work When Reopening Excel
- Re: A "chessboard" problem
- RE: delete checkboxs
- RE: delete checkboxs
- RE: Excel Justify
- RE: delete checkboxs
- RE: Excel Justify
- RE: range.address, replace characters
- Re: Passing Variables between Workbooks
- Re: Passing Variables between Workbooks
- Re: Macro to expire after a specified date
- RE: range.address, replace characters
- RE: range.address, replace characters
- RE: Excel Justify
- RE: range.address, replace characters
- Re: range.address, replace characters
- Re: Remove extra space within text
- Adding to text's togther in a data value in a chart
- From: ryan . fitzpatrick3
- Re: A "chessboard" problem
- Re: List all internet explorer (or other) windows (and close them)
- range.address, replace characters
- Re: Copying data
- Re: Copying data
- Re: Copying data
- Re: Renaming files in a directory
- RE: toggle between autofilter Criteria1:= "*" and "all"
- Re: Worksheet Change Event Does Not Work When Reopening Excel
- Re: Last Used Cell in a row??
- Re: Last Used Cell in a row??
- From: Rick Rothstein \(MVP - VB\)
- Re: refreshing a multipage
- RE: Keydown event on a userform
- Re: Odd macro performance. Explanation?
- Re: Last Used Cell in a row??
- RE: Last Used Cell in a row??
- Re: How to change the default caption of a workbook to the full pathname?
- Re: Last Used Cell in a row??
- Re: Change Event duplicating action
- Re: A "chessboard" problem
- Re: Last Used Cell in a row??
- Last Used Cell in a row??
- Re: Change Event duplicating action
- Re: How to change the default caption of a workbook to the full pathname?
- Re: refreshing a multipage
- Re: Error Application Defined or Object Defined
- Re: A "chessboard" problem
- RE: Error Application Defined or Object Defined
- Re: Change Event duplicating action
- RE: date format conversion
- Error Application Defined or Object Defined
- Re: refer to an object in a group
- Re: Change Event duplicating action
- Re: Peter T's Copy WorkBook Contents Copy
- How to change the default caption of a workbook to the full pathname?
- Re: Peter T's Copy WorkBook Contents Copy
- Re: Peter T's Copy WorkBook Contents Copy
- Re: Assigning a hotkey to run only from a given range
- Re: Remove extra space within text
- Re: Peter T's Copy WorkBook Contents Copy
- Re: Peter T's Copy WorkBook Contents Copy
- Displaying YTD for each Month Selected
- Re: load & unload
- RE: Sub to copy n paste as values based on an "instructions" table
- Re: Worksheet Change Event Does Not Work When Reopening Excel
- Re: Saving a file every fifteen minutes
- RE: setting page breaks based on value & printing to and from value
- Sub to copy n paste as values based on an "instructions" table
- Re: Disable Menu (CommandBar) if not workbook is opened
- Re: Disable Menu (CommandBar) if not workbook is opened
- Keydown event on a userform
- Re: Run Excel macro from XP shortcut menu
- Re: Text Box Enter and Exit Events
- Showing text on A Userform
- Re: naming my worksheet
- RE: 2 userforms, 2 UserForm_Initialize()
- Re: Error retrieving data from closed workbook
- RE: Simulation
- RE: Simulation
- Re: Disable Menu (CommandBar) if not workbook is opened
- Re: Disable Menu (CommandBar) if not workbook is opened
- Re: Add record to end of list, variables table
- Re: zoom problem ??
- RE: Simulation
- Re: Separate Numeric Values
- Re: excel security
- Re: Personal.xls file with multiple Excel versions
- Re: Worksheet Change Event Does Not Work When Reopening Excel
- Re: Error retrieving data from closed workbook
- Re: Assigning a hotkey to run only from a given range
- Re: public variables, 2 userforms
- RE: A "chessboard" problem
- Re: public variables, 2 userforms
- Re: Worksheet Change Event Does Not Work When Reopening Excel
- Re: A "chessboard" problem
- Re: A Little More Advanced Range Fill-In
- RE: Simulation
- Worksheet Change Event Does Not Work When Reopening Excel
- RE: setting focus to particular textbox
- Re: A Little More Advanced Range Fill-In
- RE: etract unique data from multiple workbooks after extracting data
- Assigning a hotkey to run only from a given range
- RE: Simulation
- Re: Run Excel macro from XP shortcut menu
- Re: Run Excel macro from XP shortcut menu
- Re: Error retrieving data from closed workbook
- Peter T's Copy WorkBook Contents Copy
- Re: Error retrieving data from closed workbook
- Re: Excel 2007 Craches when closing via macro code
- etract unique data from multiple workbooks after extracting data
- Re: making a different sheet active
- Re: making a different sheet active
- From: Rick Rothstein \(MVP - VB\)
- Re: making a different sheet active
- Re: Separate Numeric Values
- From: Rick Rothstein \(MVP - VB\)
- Re: Error retrieving data from closed workbook
- Re: Run Excel macro from XP shortcut menu
- Re: Separate Numeric Values
- Re: Run Excel macro from XP shortcut menu
- Re: Help with code creation
- RE: rotation of an arrow created by an drawing object
- Re: retrieve data from Access Database
- Re: worksheets
- Re: A Little More Advanced Range Fill-In
- RE: Simulation
- RE: Server Calculated Members in Excel 2007
- Re: urgent ?
- Error retrieving data from closed workbook
- rotation of an arrow created by an drawing object
- Re: worksheets
- Re: Userforms, switching sheets
- Re: worksheets
- RE: Simulation
- Re: Remove extra space within text
- RE: Automation performance degradation in Excel 2007
- RE: Userforms, switching sheets
- Re: Userforms, switching sheets
- Re: combobox data doesn't take affect right away
- Userforms, switching sheets
- Re: Ok try agian. User form LastRow
- Re: A Little More Advanced Range Fill-In
- RE: Ok try agian. User form LastRow
- Re: Removing vowels from words...
- Re: changing value on a userform
- Re: A Little More Advanced Range Fill-In
- Re: A Little More Advanced Range Fill-In
- Re: OPENFILENAME A P I. User cancels ?
- Re: about check boxes
- From: Rick Rothstein \(MVP - VB\)
- Re: Saving a file every fifteen minutes
- How di I make an XML file from this unusual xls...
- Re: zoom problem ??
- OPENFILENAME A P I. User cancels ?
- Re: zoom problem ??
- Re: Remove extra space within text
- From: Rick Rothstein \(MVP - VB\)
- Re: Fiind the newest file
- From: Rick Rothstein \(MVP - VB\)
- Re: Remove extra space within text
- RE: Fiind the newest file
- Re: Getopenfile
- Re: open and printing workbook with vba
- Re: Remove extra space within text
- Re: Remove extra space within text
- Re: Remove extra space within text
- Re: Remove extra space within text
- From: Rick Rothstein \(MVP - VB\)
- Re: A #NAME? problem with a transferred function
- From: Rick Rothstein \(MVP - VB\)
- Re: Getopenfile
- From: jln via OfficeKB.com
- Re: Remove extra space within text
- Re: Fiind the newest file
- Re: Remove extra space within text
- Re: Separate Numeric Values
- Re: A #NAME? problem with a transferred function
- Re: Separate Numeric Values
- RE: Fiind the newest file
- From: jln via OfficeKB.com
- Re: A #NAME? problem with a transferred function
- Re: Image popup (as comment) when you mouse over.
- Re: Saving a file every fifteen minutes
- Re: Getopenfile
- Separate Numeric Values
- RE: Fiind the newest file
- Re: Detect page break preview
- Re: A #NAME? problem with a transferred function
- Re: A #NAME? problem with a transferred function
- Re: Remove extra space within text
- Re: A #NAME? problem with a transferred function
- Re: A #NAME? problem with a transferred function
- Fiind the newest file
- From: jln via OfficeKB.com
- Getopenfile
- From: jln via OfficeKB.com
- Re: Image popup (as comment) when you mouse over.
- Re: User Defined Password
- Re: Detect page break preview
- Re: zoom problem ??
- Detect page break preview
- RE: “Merge” data from 2 Excel files
- Re: Remove extra space within text
- Re: Passing Array Formula result to a variable in VBA (Leo)
- Re: change color of command button problem
- Re: Named ranges scope / workbook/worksheet level named ranges- change
- Re: Remove extra space within text
- Re: Add a period to name initials
- RE: Named ranges scope / workbook/worksheet level named ranges- change
- Re: Named ranges scope / workbook/worksheet level named ranges- changes with variable use...
- Named ranges scope / workbook/worksheet level named ranges- changes with variable use...
- RE: A Little More Advanced Range Fill-In
- Re: Saving a file every fifteen minutes
- RE: Simulation
- Saving a file every fifteen minutes
- RE: “Merge” data from 2 Excel files
- Re: Excel VBA Evaluation of FormatConditions(1).Formula1
- RE: Simulation
- “Merge” data from 2 Excel files
- How to get printable area of the page
- Re: Remove extra space within text
- RE: Server Calculated Members in Excel 2007
- Re: Remove extra space within text
- From: Rick Rothstein \(MVP - VB\)
- Re: Convert Text into Numbers
- Re: how to make a userform like the built in Data form
- Re: Remove extra space within text
- From: Rick Rothstein \(MVP - VB\)
- Re: Name of Current TextBox on Userform
- Re: Add a period to name initials
- Re: Add a period to name initials
- Re: Name of Current TextBox on Userform
- From: Rick Rothstein \(MVP - VB\)
- Re: Automatically Update Workbook Links as part of AutoOpen Macro?
- RE: Simulation
- Re: Macro Conversion To Relative Cells
- A Little More Advanced Range Fill-In
- Macro Conversion To Relative Cells
- Re: Add a period to name initials
- Re: Add a period to name initials
- Image popup (as comment) when you mouse over.
- Re: do...loop with timer problem
- Re: do...loop with timer problem
- Re: finding only numeric values in a worksheet using vb.net?
- From: Rick Rothstein \(MVP - VB\)
- Re: Passing Array of User Defined Type to Form
- Re: finding only numeric values in a worksheet using vb.net?
- RE: do...loop with timer problem
- RE: do...loop with timer problem
- Re: finding only numeric values in a worksheet using vb.net?
- Re: caculations letters
- From: Rick Rothstein \(MVP - VB\)
- Re: finding only numeric values in a worksheet using vb.net?
- From: Rick Rothstein \(MVP - VB\)
- Re: caculations letters
- Re: Multi Workbook Data Extraction
- Re: Ribbonx - how to create two ribbons?
- Re: finding only numeric values in a worksheet using vb.net?
- Re: Ribbonx - how to create two ribbons?
- Re: A #NAME? problem with a transferred function
- Re: Ribbonx - how to create two ribbons?
- Re: Ribbonx - how to create two ribbons?
- Re: finding only numeric values in a worksheet using vb.net?
- finding only numeric values in a worksheet using vb.net?
- Ribbonx - how to create two ribbons?
- Re: Listbox load event
- Re: Multi Workbook Data Extraction
- Re: about .exe file
- Re: A #NAME? problem with a transferred function
- From: Rick Rothstein \(MVP - VB\)
- Re: Automatically Update Workbook Links as part of AutoOpen Macro?
- Re: Ron de Bruin's code "Copy a range from all files in a folder and subfolders (optional)" ???
- Re: Ron de Bruin's code "Copy a range from all files in a folder and subfolders (optional)" ???
- Re: toggle borders macro
- Re: how to make a userform like the built in Data form
- Re: unprotect sheet failure
- Re: A #NAME? problem with a transferred function
- Re: A #NAME? problem with a transferred function
- RE: Simulation
- Re: How to change the color of a page
- RE: Openform event
- Re: Ron de Bruin's code "Copy a range from all files in a folder and subfolders (optional)" ???
- Re: Search Directories/SubDirectories UserForm
- RE: Openform event
- Re: Multi Workbook Data Extraction
- RE: toggle borders macro
- Re: Ron de Bruin's code "Copy a range from all files in a folder and subfolders (optional)" ???
- Re: Multi Workbook Data Extraction
- Re: refer to an object in a group
- refer to an object in a group
- Re: reference to external ranges
- Re: Multi Workbook Data Extraction
- Re: How do I start a Process I can then communicate with from VBA
- reference to external ranges
- Re: How to tell if sheet exists in closed workbook
- Re: moving controls in X & Y axis
- How do I start a Process I can then communicate with from VBA
- RE: Openform event
- Re: unprotect sheet failure
- toggle borders macro
- Re: moving controls in X & Y axis
- From: Rick Rothstein \(MVP - VB\)
- Re: moving controls in X & Y axis
- From: Rick Rothstein \(MVP - VB\)
- Re: Lots of REM lines an easy way?
- From: Rick Rothstein \(MVP - VB\)
- Re: moving controls in X & Y axis
- Re: moving controls in X & Y axis
- From: Rick Rothstein \(MVP - VB\)
- Re: Can I open an Outlook dialog box from Excel?
- Re: Listbox load event
- From: Rick Rothstein \(MVP - VB\)
- Re: Pharsing string from the right to the first space
- Re: how to make a userform like the built in Data form
- Re: Lots of REM lines an easy way?
- Re: How to change the color of a page
- Re: parsing data
- RE: Simulation
- Re: How to tell if sheet exists in closed workbook
- Re: Can I open an Outlook dialog box from Excel?
- Re: How to change the color of a page
- Re: How to tell if sheet exists in closed workbook
- Re: Variable Help
- Re: How many pages will be printed?
- Re: create macro "merge selected cells"?
- Re: How to iterate through columns?
- How to iterate through columns?
- Re: expanding numbers?
- From: Rick Rothstein \(MVP - VB\)
- Re: expanding numbers?
- Copy range
- Re: VBA to select the cells next to the result of a find & combine the
- From: Rick Rothstein \(MVP - VB\)
- RE: VBA to select the cells next to the result of a find & combine
- How to tell if sheet exists in closed workbook
- Re: create macro "merge selected cells"?
- Re: rotate highlighting colors macro
- From: Rick Rothstein \(MVP - VB\)
- Re: rotate highlighting colors macro
- rotate highlighting colors macro
- Re: parsing data
- unprotect sheet failure
- Re: Open with Openform; Workbook not visible
- RE: Worksheet_BeforeClose conditional Worksheet change
- Re: parsing data
- Re: Pharsing string from the right to the first space
- From: Rick Rothstein \(MVP - VB\)
- Re: create macro "merge selected cells"?
- Re: Passing Array of User Defined Type to Form
- From: Rick Rothstein \(MVP - VB\)
- Re: Ron de Bruin's code "Copy a range from all files in a folder and subfolders (optional)" ???
- Re: Pharsing string from the right to the first space
- Re: Pharsing string from the right to the first space
- Re: Ron de Bruin's code "Copy a range from all files in a folder and subfolders (optional)" ???
- Re: Convert Text into Numbers
- From: Rick Rothstein \(MVP - VB\)
- RE: Worksheet_BeforeClose conditional Worksheet change
- Re: Convert Text into Numbers
- Re: Ron de Bruin's code "Copy a range from all files in a folder and subfolders (optional)" ???
- Re: create macro "merge selected cells"?
- Re: sort issue: Excel seems to be treating my column of numbers "a
- Re: deleting multiple rows
- Re: date confusion
- Re: Change name of pictures in worksheet
- RE: expanding numbers?
- Re: Custom List
- Re: Passing Array of User Defined Type to Form
- Custom List
- Re: Ron de Bruin's code "Copy a range from all files in a folder and subfolders (optional)" ???
- Re: Chart label questions
- Re: getting the active chart/chartobject's name
- Re: getting the active chart/chartobject's name
- Re: Convert Text into Numbers
- From: Rick Rothstein \(MVP - VB\)
- Re: Turn formula into Select
- Re: Ron de Bruin's code "Copy a range from all files in a folder and subfolders (optional)" ???
- Re: Ron de Bruin's code "Copy a range from all files in a folder and subfolders (optional)" ???
- Re: Convert Text into Numbers
- Re: Determine if a PivotField is visible?
- Re: Determine if a PivotField is visible?
- Re: Passing Array of User Defined Type to Form
- From: Rick Rothstein \(MVP - VB\)
- RE: cut and paste with loop macro
- Convert Text into Numbers
- Re: Selecti Page in Userform by Name not Number
- Re: Selecti Page in Userform by Name not Number
- RE: cut and paste with loop macro
- Ron de Bruin's code "Copy a range from all files in a folder and subfolders (optional)" ???
- RE: cut and paste with loop macro
- xls size doubles
- Re: excel - inserting a formula in a cell (using =) fails
- RE: data type mismatch error
- Re: sort issue: Excel seems to be treating my column of numbers "alphabetically"
- RE: data type mismatch error
- Re: Excel VBA Evaluation of FormatConditions(1).Formula1
- RE: data type mismatch error
- Re: xlWorkbookDefault
- RE: Opening a file command doesn't work
- Re: xlWorkbookDefault
- Re: xlWorkbookDefault
- Re: Help with debugging
- RE: data type mismatch error
- Re: Turn formula into Select
- From: Rick Rothstein \(MVP - VB\)
- RE: sort issue: Excel seems to be treating my column of numbers "alpha
- Re: date confusion
- Re: deleting multiple rows
- From: Rick Rothstein \(MVP - VB\)
- Re: Speeding up execution of a Macro
- Re: week function in vba?
- From: Rick Rothstein \(MVP - VB\)
- Re: sort issue: Excel seems to be treating my column of numbers "alphabetically"
- data type mismatch error
- Re: Select different data label range (as values)
- RE: Maximum number of controls on a user form
- RE: Maximum number of controls on a user form
- Re: getting the active chart/chartobject's name
- sort issue: Excel seems to be treating my column of numbers "alphabetically"
- From: adeviantsubcultureof1
- Re: atpbaen.xla
- Re: Turn formula into Select
- From: Rick Rothstein \(MVP - VB\)
- Re: Maximum number of controls on a user form
- Re: date confusion
- Re: Speeding up execution of a Macro
- Re: getting the active chart/chartobject's name
- date confusion
- RE: Turn formula into Select
- Re: Determine if a PivotField is visible?
- getting the active chart/chartobject's name
- Re: Onkey Key Codes for ADD and SUBTRACT keys in earlier Excel ver
- Change name of pictures in worksheet
- Re: Determine if a PivotField is visible?
- Re: Username and password login.
- Re: Select different data label range (as values)
- parsing data
- Re: Speeding up execution of a Macro
- Re: Activating an open file with a variable name
- Re: How many pages will be printed?
- Re: ExecuteExcel4Macro("GET.DOCUMENT(50)")
- RE: Speeding up execution of a Macro
- Re: Activating an open file with a variable name
- Re: Write Additional Data within a txt File
- From: Rick Rothstein \(MVP - VB\)
- Sheet problem???
- Re: pop up calender in a userform
- From: Rick Rothstein \(MVP - VB\)
- Select different data label range (as values)
- Re: pop up calender in a userform
- From: Rick Rothstein \(MVP - VB\)
- Re: Activating an open file with a variable name
- Re: Activating an open file with a variable name
- RE: Retriving value from multiple sources
- Re: ComboBox.visible = False or True
- Re: Using variable to identify a workbook
- Chart label questions
- From: ryan . fitzpatrick3
- Re: ComboBox.visible = False or True
- Re: ComboBox.visible = False or True
- Re: combobox doesn't load cell value at startup
- Re: Variable Case issue
- Re: Variable Case issue
- From: Rick Rothstein \(MVP - VB\)
- Re: Variable Case issue
- From: Rick Rothstein \(MVP - VB\)
- Re: Variable Case issue
- Re: Variable Case issue
- Re: Sumif function problem
- Re: Using variable to identify a workbook
- Re: moving to next cell without keyboard
- Re: How many pages will be printed?
- Re: ExecuteExcel4Macro("GET.DOCUMENT(50)")
- Re: Username and password login.
- Re: Username and password login.
- Re: Sumif function problem
- Re: autofilter row count
- RE: Automation performance degradation in Excel 2007
- Re: ExecuteExcel4Macro("GET.DOCUMENT(50)")
- Re: Username and password login.
- autofilter next and previous record problem
- Sumif function problem
- Re: autofilter row count
- Re: autofilter row count
- Re: How many pages will be printed?
- Re: Username and password login.
- autofilter row count
- RE: Error 55 File Already Open
- Re: Username and password login.
- Re: Determine if a PivotField is visible?
- Re: Username and password login.
- Re: add lines to a order list
- RE: Error 55 File Already Open
- Re: Username and password login.
- Re: splitting a file into two before importing it to excel
- Re: Single stepping gives different result
- RE: Need a faster way to update values selected by advanced filter
- Re: Using variable to identify a workbook
- Using variable to identify a workbook
- splitting a file into two before importing it to excel
- Re: On Error problem
- Re: Removing vowels from words...
- RE: Need a faster way to update values selected by advanced filter
- Superscrpts in Excel 2007 Text boxes
- RE: Copy Columns to New Sheet
- Re: Excel VBA Evaluation of FormatConditions(1).Formula1
- Re: Modify function for another workbook
- Re: Write Additional Data within a txt File
- Fastest way to save workbook
- Re: Excel VBA Evaluation of FormatConditions(1).Formula1
- Re: Excel VBA Evaluation of FormatConditions(1).Formula1
- Re: Removing vowels from words...
- Re: Macro for user defined Solver changing cells.
- Re: changing value on a userform
- Re: if then else problem
- Re: User defined - conditional between statement???
- Re: Can I have code executed after Save?
- Re: Can I have code executed after Save?
- Re: Consolidating data from various worksheet of same excel file
- Re: Named ranges disappearing in Excel 2007
- Re: Difference between 2 times
- Re: Consolidating data from various worksheet of same excel file
- Re: combobox data doesn't take affect right away
- Re: Consolidating data from various worksheet of same excel file
- Re: combobox data doesn't take affect right away
- Re: Background color change, by using the formula.
- Re: combobox data doesn't take affect right away
- Re: compile error in hidden module: sheet1
- Re: Copy data
- Re: combobox data doesn't take affect right away
- Re: creating a userform
- Copy data
- Re: copy foo.xls whilst it's opened by Excel - are there problems ?
- copy foo.xls whilst it's opened by Excel - are there problems ?
- Re: pasting from one sheet to another
- Re: Array Memory Size
- From: Rick Rothstein \(MVP - VB\)
- Re: Macro for user defined Solver changing cells.
- Re: Bias in rand for excel 07
- Re: Graphing by seconds
- Re: Selecti Page in Userform by Name not Number
- From: Rick Rothstein \(MVP - VB\)
- RE: Set Page Break Lines using VBA
- Re: Selecti Page in Userform by Name not Number
- Re: Selecti Page in Userform by Name not Number
- From: Rick Rothstein \(MVP - VB\)
- Re: Selecti Page in Userform by Name not Number
- Re: changing size of characters in a selectionbox and date in a textbox
- Re: Write Additional Data within a txt File
- From: Rick Rothstein \(MVP - VB\)
- Re: Removing vowels from words...
- Re: Write Additional Data within a txt File
- From: Rick Rothstein \(MVP - VB\)
- Re: BeforeClose running twice
- pasting from one sheet to another
- Re: Text boxs
- From: Rick Rothstein \(MVP - VB\)
- Re: if then else problem
- Re: Array Memory Size
- Re: Write Additional Data within a txt File
- Re: Array Memory Size
- Re: Onkey Key Codes for ADD and SUBTRACT keys in earlier Excel version
- Re: Onkey Key Codes for ADD and SUBTRACT keys in earlier Excel version
- Re: Putting large array into a worksheet
- Text boxs
- From: ryan . fitzpatrick3
- Re: add lines to a order list
- Re: Named ranges disappearing in Excel 2007
- Re: LoadPicture compile error
- Re: VBA "sheet" NOT to minimize while working on worksheet
- Re: Create a calendar in VB with excel 2007??
- Re: Determine if a PivotField is visible?
- Re: if then else problem
- Re: set focus to form
- From: Rick Rothstein \(MVP - VB\)
- Re: set focus to form
- Re: Bias in rand for excel 07
- From: Rick Rothstein \(MVP - VB\)
- Re: Bias in rand for excel 07
- Re: Redefine UsedRange property of Worksheet Object
- From: Rick Rothstein \(MVP - VB\)
- Re: Redefine UsedRange property of Worksheet Object
- Re: Putting large array into a worksheet
- Re: Putting large array into a worksheet
- Re: Security Concerns using interop excel
- RE: Looping through and array with three possible decisions to make
- Re: Putting large array into a worksheet
- Re: ExecuteExcel4Macro("GET.DOCUMENT(50)")
- Re: Worksheet copy without user interaction
- Re: excel - inserting a formula in a cell (using =) fails
- Re: excel - inserting a formula in a cell (using =) fails
- add lines to a order list
- Re: excel - inserting a formula in a cell (using =) fails
- Re: Array Memory Size
- excel - inserting a formula in a cell (using =) fails
- Re: Number Value Check Question
- Re: Security Concerns using interop excel
- RE: offset from combobox on userform
- Re: Difference between 2 times
- Re: Putting large array into a worksheet
- Re: On Error problem
- Re: Putting large array into a worksheet
- Re: Format sheets w/varying ranges
- Re: Array Memory Size
- Re: Graphing by seconds
- LoadPicture compile error
- Re: Using a form to edit data
- Re: ExecuteExcel4Macro("GET.DOCUMENT(50)")
- Re: if then else problem
- Re: ExecuteExcel4Macro("GET.DOCUMENT(50)")
- Graphing by seconds
- if then else problem
- Re: Combo box change event fires twice
- From: Rick Rothstein \(MVP - VB\)
- Re: On Error problem
- Re: ExecuteExcel4Macro("GET.DOCUMENT(50)")
- Re: Customized menues
- Re: set focus to form
- From: Rick Rothstein \(MVP - VB\)
- Re: set focus to form
- From: Rick Rothstein \(MVP - VB\)
- Re: "Sheet(1)" Syntax
- Re: Using a form to edit data
- Re: advanced filter, goto next line(record)
- Re: Automatically copy formulae to next empty row
- Customized menues
- RE: Retriving value from multiple sources
- Re: Array Memory Size
- On Error problem
- RE: offset from combobox on userform
- Re: Counta with CountIf
- Re: Referencing a cell in VBA from a different worksheet
- Re: Referencing a cell in VBA from a different worksheet
- Re: Open a form from an Add-In
- RE: Please help with my code
- RE: Copy Columns to New Sheet
- Re: Counta with CountIf
- Re: Counta with CountIf
- Referencing a cell in VBA from a different worksheet
- RE: Copy Columns to New Sheet
- Re: set focus to form
- RE: offset from combobox on userform
- Re: Putting large array into a worksheet
- Retriving value from multiple sources
- Re: Search Directories/SubDirectories UserForm
- Re: Macro for user defined Solver changing cells.
- Re: Sheet Code Name vs. Sheet Name
- Re: Simple Multiplication Formula
- Counta with CountIf
- Re: Open a form from an Add-In
- RE: getting behind the Hyperlink
- Re: Open a form from an Add-In
- Re: Putting large array into a worksheet
- Re: Bias in rand for excel 07
- RE: offset from combobox on userform
- Re: Array Memory Size
- RE: offset from combobox on userform
- Re: Macro for user defined Solver changing cells.
- Re: Macro for user defined Solver changing cells.
- Re: Easy One - do math with Textbox values
- Re: Open a form from an Add-In
- Re: Automatically copy formulae to next empty row
- Re: Removing vowels from words...
- Re: load data to cell comments
- Re: Automatically copy formulae to next empty row
- getting behind the Hyperlink
- Re: Mixing Fonts in a single text cell
- Putting large array into a worksheet
- Array Memory Size
- Re: macros... again
- Re: o -t does anyone see and speed increase after office 2007 sp1 is installed?
- Re: Macro for user defined Solver changing cells.
- Re: Active Sheet
- Re: macros... again
- Re: Active Sheet
- Re: macros... again
- Re: advanced filter, goto next line(record)
- Re: if not isempty combobox does not work ?
- macros... again
- Re: Active Sheet
- Re: copy worksheets between workbooks - including named ranges
- RE: about check boxes
- Re: advanced filter, goto next line(record)
- Re: Allow Edit doesn't forget
- Re: copy worksheets between workbooks - including named ranges
- Inconsistent Code?
- Re: Active Sheet
- Allow Edit doesn't forget
- macros
- Re: macros
- Re: Indirect in Conditional Formatting
- copy worksheets between workbooks - including named ranges
- RE: Insert rows in many sheets
- Re: run macro although blinking cursor is active in an active cell
- Re: Modify function for another workbook
- Re: Active Sheet
- macros
- Re: Automatically copy formulae to next empty row
- Re: Generate ongoing database of results via Macro
- Re: Generate ongoing database of results via Macro
- Re: advanced filter, goto next line(record)
- Re: BeforeDoubleClick
- Re: Add record to end of list, variables table
- Modify function for another workbook
- run macro although blinking cursor is active in an active cell
- Re: changing size of characters in a selectionbox and date in a textbox
- Re: object disconnected from client error message
- Re: Excel VBA Evaluation of FormatConditions(1).Formula1
- Re: Excel VBA Evaluation of FormatConditions(1).Formula1
- Re: Excel VBA Evaluation of FormatConditions(1).Formula1
- Re: Simple Multiplication Formula
- Re: Progress bar that is constantly updating
- RE: Excel Validataion listbox
- Re: Excel 2007 Craches when closing via macro code
- Re: VBA and Colorwheel
- RE: Server Calculated Members in Excel 2007
- Re: changing font size in an activex label
- Re: Addin Macro Call
- Re: Sheet Code Name vs. Sheet Name
- Re: Combo box change event fires twice
- Re: replace blanks with values above
- Re: Indirect in Conditional Formatting
- Re: Indirect in Conditional Formatting
- Excel VBA Evaluation of FormatConditions(1).Formula1
- Re: Generate ongoing database of results via Macro
- Re: replace blanks with values above
- Re: replace blanks with values above
- Re: replace blanks with values above
- Re: Combo box change event fires twice
- Re: replace blanks with values above
- Re: Workbook_Open() of locked project causing errors
- Re: o -t does anyone see and speed increase after office 2007 sp1 is installed?
- Re: replace blanks with values above
- Re: replace blanks with values above
- Re: replace blanks with values above
- Re: Combo box change event fires twice
- From: Rick Rothstein \(MVP - VB\)
- Re: How do i copy a cell from a workbook to another workbook?
- replace blanks with values above
- Combo box change event fires twice
- Re: Excel 2007 Craches when closing via macro code
- Re: How do i copy a cell from a workbook to another workbook?
- Re: VBA and Colorwheel
- Re: How do i copy a cell from a workbook to another workbook?
- Re: VBA and Colorwheel
- Re: Easy One - do math with Textbox values
- Re: Easy One - do math with Textbox values
- From: Rick Rothstein \(MVP - VB\)
- Re: Easy One - do math with Textbox values
- Re: Percentage formating in macro
- RE: Automation performance degradation in Excel 2007
- Re: Easy One - do math with Textbox values
- Re: Easy One - do math with Textbox values
- Re: Clear Range
- Re: Clear Range
- Re: Open a form from an Add-In
- Open a form from an Add-In
- Re: Percentage formating in macro
- Re: set focus to form
- From: Rick Rothstein \(MVP - VB\)
- Re: set focus to form
- From: Rick Rothstein \(MVP - VB\)
- Re: How to obtain the names of all installed fonts
- Workbook_Open() of locked project causing errors
- How to obtain the names of all installed fonts
- Re: set focus to form
- From: Rick Rothstein \(MVP - VB\)
- Clear Range
- Re: VBA and Colorwheel
- Re: Percentage formating in macro
- Re: Copy and Paste Macro
- RE: offset from combobox on userform
- Re: Removing vowels from words...
- RE: offset from combobox on userform
- Re: Percentage formating in macro
- Re: Copy and Paste Macro
- offset from combobox on userform
- RE: Copy and Paste Macro
- Re: Copy and Paste Macro
- Re: VBA and Colorwheel
- Re: VBA and Colorwheel
- Re: set focus to form
- Re: VBA and Colorwheel
- RE: Attaching Macros To Items In a List Box
- Re: Simple Multiplication Formula
- RE: Keep Timer Going While Altering Workbook
- Copy and Paste Macro
- RE: called macro
- Excel 2007 Craches when closing via macro code
- Re: Simple Multiplication Formula
- Re: set focus to form
- From: Rick Rothstein \(MVP - VB\)
- Re: VBA and Colorwheel
- Re: set focus to form
- Re: Simple Multiplication Formula
- Re: convert excel to VBA
- Re: set focus to form
- From: Rick Rothstein \(MVP - VB\)
- Re: Attaching Macros To Items In a List Box
- Re: Close workbook without being prompted to save in VBA
- Re: Sheet Code Name vs. Sheet Name
- RE: set focus to form
- Re: PrintPreview error when run from VBA
- RE: called macro
- Re: Close workbook without being prompted to save in VBA
- Re: called macro
- PrintPreview error when run from VBA
- Re: set focus to form
- From: Rick Rothstein \(MVP - VB\)
- Updating values using advanced filter - VBA
- RE: Sheet Code Name vs. Sheet Name
- Re: set focus to form
- From: Rick Rothstein \(MVP - VB\)
- Re: Populate one cell with an offset cells contents
- Re: Simple Multiplication Formula
- Re: Close workbook without being prompted to save in VBA
- Re: set focus to form
- From: Rick Rothstein \(MVP - VB\)
- Sheet Code Name vs. Sheet Name
- Re: Automation stumble - Got it!!
- Re: VBA to Select Cells with Conditional Formats
- Re: Compatibility question
- Re: is there a "switch p, case 1 2 3 ...." flow control in Excel?
- Re: VBA to Select Cells with Conditional Formats
- if not isempty combobox does not work ?
- Re: Row Number
- Re: Module Name
- Re: is there a "switch p, case 1 2 3 ...." flow control in Excel?
- Re: Progress bar that is constantly updating
- Re: Locking cells after the user has entered values in protected w
- Re: Simple Multiplication Formula
- Re: Macro for user defined Solver changing cells.
- Re: Progress bar that is constantly updating
- Re: If or Case help - Which to use
- VBA to Select Cells with Conditional Formats
- Re: advanced filter, goto next line(record)
- RE: VBA Date Format Cell Check
- Re: Compatibility question
- Re: Case Statement for Changing Font AND Background Color
- Re: Progress bar that is constantly updating
- Re: Simple Multiplication Formula
- Simple Multiplication Formula
- Compatibility question
- Re: UserForms to populate cells in a worksheet
- Re: Selecting multiple tabs in VB
- Re: add listbox item for all sheet same range
- Re: is there a "switch p, case 1 2 3 ...." flow control in Excel?
- RE: Y doens't this work?
- Re: Selecting multiple tabs in VB
- Re: Y doens't this work?
- RE: Y doens't this work?
- Re: Selecting multiple tabs in VB
- Re: Variable count and bound random numbers
- Re: new formula after condition met
- Re: Selecting multiple tabs in VB
- Re: Easy One - Syntax for variables in TextBox & Label names
- Re: Indirect in Conditional Formatting
- Re: UserForms to populate cells in a worksheet
- Re: Easy One - Syntax for variables in TextBox & Label names
- Mixing Fonts in a single text cell
- Re: Inputbox to return range from another workbook
- Progress bar that is constantly updating
- RE: "Find all" and show the cell addresses in a MsgBox
- Re: Counting ranges
- Re: Automatically copy formulae to next empty row
- Re: Last Item in Column
- Re: "Find all" and show the cell addresses in a MsgBox
- Re: Applying the target formatting
- Re: Case Statement for Changing Font AND Background Color
- Re: Case Statement for Changing Font AND Background Color
- Re: I need template for day trading
- Re: Macro for user defined Solver changing cells.
- Re: Checking Column Constraints
- Re: Case Statement for Changing Font AND Background Color
- Re: Case Statement for Changing Font AND Background Color
- Re: Running a Macro Without Apparent Code
- Applying the target formatting
- Re: Generate ongoing database of results via Macro
- Re: Print 2-Up
- Re: Case Statement for Changing Font AND Background Color
- Re: Selecting multiple tabs in VB
- Re: BeforeDoubleClick
- Re: compile error in hidden module: sheet1
- RE: Excel Validataion listbox
- Re: add listbox item for all sheet same range
- Re: Blocking a Windows Message
- Re: Case Statement for Changing Font AND Background Color
- Re: Case Statement for Changing Font AND Background Color
- Re: Removing vowels from words...
- Re: Selecting multiple tabs in VB
- Re: Running a Macro Without Apparent Code
- Re: add listbox item for all sheet same range
- Re: Macro for user defined Solver changing cells.
- Re: add listbox item for all sheet same range
- Re: System Error &H8007007E (-2147024770) The specified module cou
- Re: Macro for user defined Solver changing cells.
- Re: How to count number of red font cells or rows
- Re: How to count number of red font cells or rows
- Re: Inputbox to return range from another workbook
- Re: System Error &H8007007E (-2147024770) The specified module cou
- RE: How to count number of red font cells or rows
- Re: How to count number of red font cells or rows
- Re: Automatically copy formulae to next empty row
- Re: advanced filter, goto next line(record)
- add listbox item for all sheet same range
- Re: Excel Validataion listbox
- Re: Indirect in Conditional Formatting
- Re: Limit textbox to 255 characters
- Re: Last Item in Column
- Re: Removing vowels from words...
- Re: Worksheet_Calculate fires for every worksheet in book?
- Re: Removing vowels from words...
- Re: Toolbar macro re-named
- Re: Last Item in Column
- advanced filter, goto next line(record)
- Re: Removing vowels from words...
- Removing vowels from words...
- Last Item in Column
- Re: Indirect in Conditional Formatting
- RE: Generate ongoing database of results via Macro
- Re: compile error in hidden module: sheet1
- Re: area code
- Re: area code
- Re: "Find all" and show the cell addresses in a MsgBox
- Re: "Find all" and show the cell addresses in a MsgBox
- area code
- Re: comparing amounts
- Re: Ressources about controlling html from VBA
- Re: Selecting multiple tabs in VB
- Re: changing size of characters in a selectionbox and date in a textbox
- RE: Generate ongoing database of results via Macro
- Re: how to split 2 or 3 pieces name in 1 cell into 2 or 3 cells
- Re: Selecting multiple tabs in VB
- Re: probably a relatively easy macro question....
- Re: probably a relatively easy macro question....
- Re: Running a Macro Without Apparent Code
- Re: Running a Macro Without Apparent Code
- probably a relatively easy macro question....
- Re: Running a Macro Without Apparent Code
- Re: Declaring subs Public vs Private
- Re: Running a Macro Without Apparent Code
- Re: Case Statement for Changing Font AND Background Color
- Re: Toolbar macro re-named
- Re: Toolbar macro re-named
- Re: Case Statement for Changing Font AND Background Color
- Re: Open a workbook with Notify option
- Re: how do i empty the clipboard from within an excel macro
- Re: Locking cells after the user has entered values in protected w
- Re: how do i empty the clipboard from within an excel macro
- Re: Indirect in Conditional Formatting
- Re: Populate one cell with an offset cells contents
- Re: Case Statement for Changing Font AND Background Color
- Re: Combobox problem, please help this novice!
- Case Statement for Changing Font AND Background Color
- Re: Simple Question about combobox
- Re: Check for directory then create
- RE: Replace a cell (I2) with a cell (H2) if I2 = "a"
- Re: Range help
- Re: TMOO - Mood tag
- From: crferguson@xxxxxxxxx
- Re: how to split 2 or 3 pieces name in 1 cell into 2 or 3 cells
- Re: Selecting multiple tabs in VB
- Re: BeforeDoubleClick
- Re: If - End if problem
- Simple Question about combobox
- From: ryan . fitzpatrick3
- RE: Variable count and bound random numbers
- Re: Selecting multiple tabs in VB
- Excel copies graphics from one sheet to another arbitrarily
- Re: (Reverse Union) Randomly draw address from Range
- Re: Method 'Columns' of object '_Global' failed
- RE: Variable count and bound random numbers
- RE: Help with calling word reference from excel vba
- RE: Form/Input box
- Re: Combobox help.....really easy I imagine
- From: ryan . fitzpatrick3
- Re: (Reverse Union) Randomly draw address from Range
- Re: how do i empty the clipboard from within an excel macro
- RE: Help with calling word reference from excel vba
- Re: Importing Text File into Excel loses leading zero on some fields.
- Re: If - End if problem
- From: Rick Rothstein \(MVP - VB\)
- Re: Macro for user defined Solver changing cells.
- RE: Help with calling word reference from excel vba
- RE: Method 'Columns' of object '_Global' failed
- RE: Help with calling word reference from excel vba
- Re: If - End if problem
- Method 'Columns' of object '_Global' failed
- RE: Help with calling word reference from excel vba
- Variable count and bound random numbers
- Re: Automation performance degradation in Excel 2007
- Solution ... Screen "Flickers" When macro Starts !!
- RE: Help with calling word reference from excel vba
- RE: Importing Text File into Excel loses leading zero on some fields.
- RE: Listbox horizontal scrollbar problem
- RE: Help with calling word reference from excel vba
- RE: Hiding sheets using code
- Re: Importing Text File into Excel loses leading zero on some fields.
- Re: Limiting Size of Excel 2007 Spreadsheet
- Re: how do i empty the clipboard from within an excel macro
- Re: Naming Cells - need help
- Re: Importing Text File into Excel loses leading zero on some fields.
- Re: (Reverse Union) Randomly draw address from Range
- Re: BeforeDoubleClick
- Re: BeforeDoubleClick
- RE: Hiding sheets using code
- Re: Declaring subs Public vs Private
- Re: Automation performance degradation in Excel 2007
- RE: Excel template usage???
- Re: BeforeClose running twice
- Re: Declaring subs Public vs Private
- Re: Change PasteSpecial
- Re: BeforeDoubleClick
- Re: object disconnected from client error message
- Re: Problem with If-Then-Else Statement
- Importing Text File into Excel loses leading zero on some fields.
- Re: Worksheet_Calculate fires for every worksheet in book?
- Re: Macro to copy values from a table
- Re: Problem with If-Then-Else Statement
- Listbox horizontal scrollbar problem
- RE: Worksheet_Calculate fires for every worksheet in book?
- Re: Problem with If-Then-Else Statement
- Re: Pls explain this VBA oddity
- Re: Pls explain this VBA oddity
- Re: BeforeClose running twice
- Re: ListBox Column Widths
- Re: Pls explain this VBA oddity
- Re: Long running operations
- Re: ListBox Column Widths
- Worksheet_Calculate fires for every worksheet in book?
- Re: Find Chart Sheets in workbook
- Re: Ressources about controlling html from VBA
- Re: Generating Graphs (XY scatter Plot)
- Re: Type Mismatch
- Re: XLA Deployment
- Re: Type Mismatch
- Re: Inputbox to return range from another workbook
- Re: Declaring subs Public vs Private
- Re: Declaring subs Public vs Private
- Re: Copy Sheets to another workbook
- Re: Pls explain this VBA oddity
- Re: Type Mismatch
- Re: Inputbox to return range from another workbook
- Re: object disconnected from client error message
- Re: Turn Off Circular Reference Message
- Re: auto date
- Inputbox to return range from another workbook
- Re: How to Call Functions in the Personal Workbook?
- Macro for user defined Solver changing cells.
- How to Call Functions in the Personal Workbook?
- Re: How to retrieve text from the textframe of an oval shape in Excel?
- Re: Problem with saving documents as .csv file
- Re: Conditional Formatting...
- Copy Sheets to another workbook
- Re: How do I write a macro for keeping time?
- Re: Conditional Formatting...
- Re: BeforeClose running twice
- Re: ListBox Column Widths
- Re: BeforeClose running twice
- Problem with saving documents as .csv file
- RE: Hiding sheets using code
- how can I put the data from the second sheet in the first sheet?
- Re: Hiding sheets using code
- Re: Is it a bug? in VBA, FileName (with "[", "]") changes after o
- Re: Is it a bug? in VBA, FileName (with "[", "]") changes after o
- Re: ListBox Column Widths
- Re: Blocking a Windows Message
- Pivot Table changing sum values using VB
- Re: How do i seperate colums when special pasting information
- Re: New to Macros
- Re: BeforeClose running twice
- Macro for Solver with user defined changing cells
- Re: BeforeClose running twice
- New to Macros
- Re: BeforeClose running twice
- Re: how to split 2 or 3 pieces name in 1 cell into 2 or 3 cells
- Re: Pls explain this VBA oddity
- Re: BeforeClose running twice
- Re: how to split 2 or 3 pieces name in 1 cell into 2 or 3 cells
- Re: how to split 2 or 3 pieces name in 1 cell into 2 or 3 cells
- Re: how to split 2 or 3 pieces name in 1 cell into 2 or 3 cells
- Re: changing size of characters in a selectionbox and date in a textbox
- Re: how to split 2 or 3 pieces name in 1 cell into 2 or 3 cells
- Re: how to split 2 or 3 pieces name in 1 cell into 2 or 3 cells
- Re: Pls explain this VBA oddity
- Re: how to split 2 or 3 pieces name in 1 cell into 2 or 3 cells
- Re: how to split 2 or 3 pieces name in 1 cell into 2 or 3 cells
- RE: Automation performance degradation in Excel 2007
- Re: changing size of characters in a selectionbox and date in a textbox
- Re: how to split 2 or 3 pieces name in 1 cell into 2 or 3 cells
- Re: Pls explain this VBA oddity
- changing size of characters in a selectionbox and date in a textbox
- Re: Pls explain this VBA oddity
- Pls explain this VBA oddity
- Re: how to split 2 or 3 pieces name in 1 cell into 2 or 3 cells
- Re: how to split 2 or 3 pieces name in 1 cell into 2 or 3 cells
- mouse focusing in close button in preview window
- Re: creating a userform
- Re: cell.formula returns value
- VBA Programmer Wanted for Short, Paid Contract
- RE: Run Code on Activate Sheet
- RE: Run Code on Activate Sheet
- Re: Run Code on Activate Sheet
- Re: Run Code on Activate Sheet
- RE: Not resetting all cells
- RE: Run Code on Activate Sheet
- RE: Run Code on Activate Sheet
- Re: Bias in rand for excel 07
- Re: efficient / easy way to convert an Excel.Range to a double[,]
- Re: If - End if problem
- RE: Not resetting all cells
- Re: Macro to copy values from a table
- XLA Deployment
- Re: Accessing ranges with integer variables
- Re: referencing commandbuttons as OLEObjects
- Combobox help.....really easy I imagine
- From: ryan . fitzpatrick3
- Re: If - End if problem
- Re: one per day password
- Re: Variable Series in graphs
- Variable Series in graphs
- Re: click in a workbook
- "Compile error in hidden module: This WorkBook" only appears when project locked
- Re: Check for directory then create
- Re: Accessing ranges with integer variables
- Re: if an element in a row is true then copy whole row to another
- From: Rick Rothstein \(MVP - VB\)
- Re: Check for directory then create
- RE: Accessing ranges with integer variables
- Re: Check for directory then create
- click in a workbook
- Generating Graphs (XY scatter Plot)
- Re: need a alternating password
- Accessing ranges with integer variables
- Copy doesn't copy in Sub Extr10L
- Re: Bias in rand for excel 07
- Check for directory then create
- Re: Bias in rand for excel 07
- Re: Find Chart Sheets in workbook
- RE: Not resetting all cells
- Re: if an element in a row is true then copy whole row to another
- Re: is there a "switch p, case 1 2 3 ...." flow control in Excel?
- Re: Combobox problem, please help this novice!
- ActiveWorkbook.ConflictResolution
- Re: Combobox_Change event fires on workbook close
- Re: Not resetting all cells
- Re: End(x1Left) to column a
- Re: End(x1Left) to column a
- Re: CSV line feed delimitter
- From: Rick Rothstein \(MVP - VB\)
- Re: Converting a GPS waypoint from decimal to degrees, minutes and sec
- Re: CSV line feed delimitter
- RE: conditional formatting in excel vba
- Re: Auto/Manual Calculation
- Re: Automatically copy formulae to next empty row
- Re: Excel Properties() collection
- conditional formatting in excel vba
- Re: Converting a GPS waypoint from decimal to degrees, minutes and sec
- Re: Bias in rand for excel 07
- Re: What can we use as an equivalent to "Sleep()" in vb?
- From: StargateFanFromWork
- Re: Floating textbox/label
- Re: Floating textbox/label
- From: Rick Rothstein \(MVP - VB\)
- Re: Copy excel chart as picture to a particular ppt slides
- Re: code not working
- From: Rick Rothstein \(MVP - VB\)
- Re: Screen "Flickers" When macro Starts !!
- Re: Screen "Flickers" When macro Starts !!
- Re: Copy Rows using criteria
- ((((((((xmas hot sell)))))))) toys and gifts
- Re: Condense ISERROR(VLOOKUP(MATCH())) to VBA function.
- Re: Screen "Flickers" When macro Starts !!
- Copy Rows using criteria
- Re: Bias in rand for excel 07
- From: Rick Rothstein \(MVP - VB\)
- Re: problems recording macro_value or formula?
- RE: application or object defined error on print to file
- RE: another code not working
- Re: Screen "Flickers" When macro Starts !!
- RE: another code not working
- RE: another code not working
- RE: another code not working
- another code not working
- Re: Is it a bug? in VBA, FileName (with "[", "]") changes after opene
- application or object defined error on print to file
- Re: Excel template usage???
- Re: Combobox_Change event fires on workbook close
- Re: Combobox_Change event fires on workbook close
- Re: Screen "Flickers" When macro Starts !!
- RE: Importing from another file of unknown name
- Re: Bias in rand for excel 07
- HOW TO CHANGE RANGE
- Re: Excel Properties() collection
- Calendar not in a cell
- Re: choos one of two comboboxes
- Re: Combobox problem, please help this novice!
- Re: Bias in rand for excel 07
- From: Rick Rothstein \(MVP - VB\)
- RE: Excel template usage???
- Re: profit/loss calculator
- Re: LOOKUP VALUES FROM OTHER SHEET
- Re: From HKBN
- Re: LOOKUP VALUES FROM OTHER SHEET
- Re: Problem with multiple error handling
- Re: code not working
- Re: Floating textbox/label
- Re: code not working
- Re: What can we use as an equivalent to "Sleep()" in vb?
- Re: code not working
- Re: What can we use as an equivalent to "Sleep()" in vb?
- Re: LOOKUP VALUES FROM OTHER SHEET
- Re: What can we use as an equivalent to "Sleep()" in vb?
- What can we use as an equivalent to "Sleep()" in vb?
- Re: NEED CORRECTION IN MACRO
- Re: Is it a bug? in VBA, FileName (with "[", "]") changes after opene
- RE: NEED CORRECTION IN MACRO
- Re: LOOKUP VALUES FROM OTHER SHEET
- Re: Bias in rand for excel 07
- NEED CORRECTION IN MACRO
- Re: Combobox problem, please help this novice!
- RE: Data Consolidation using dynamic path
- Re: choos one of two comboboxes
- Re: choos one of two comboboxes
- Copy excel chart as picture to a particular ppt slides
- Re: Combobox problem, please help this novice!
- ConnectCode's new productivity tool automates removal of duplicate entries in Excel
- choos one of two comboboxes
- Re: Bias in rand for excel 07
- How Do I Use DispCallFunc with IMLangCodePages::GetCharCodePages
- Re: problems recording macro_value or formula?
- Re: Bias in rand for excel 07
- From: Rick Rothstein \(MVP - VB\)
- Re: error in setting chart area width
- Re: Problems with Hiding/Showing Modeless Userforms
- Re: Default Cell Formatting
- Re: Problems with Hiding/Showing Modeless Userforms
- Problems with Hiding/Showing Modeless Userforms
- Combobox problem, please help this novice!
- RE: Fill down function
- Re: Bias in rand for excel 07
- Re: Formatting not updating inside a function
- Re: one per day password
- Re: Formatting not updating inside a function
- Data Consolidation using dynamic path
- Formatting not updating inside a function
- Combobox_Change event fires on workbook close
- Re: Refreshing External Data
- Screen "Flickers" When macro Starts !!
- Re: Bias in rand for excel 07
- Re: Default Cell Formatting
- Re: Bias in rand for excel 07
- Re: Default Cell Formatting
- From: Rick Rothstein \(MVP - VB\)
- Default Cell Formatting
- Re: Bias in rand for excel 07
- Re: LOOKUP VALUES FROM OTHER SHEET
- Re: Delete Matched Cells
- Re: profit/loss calculator
- Comment disapears
- Re: profit/loss calculator
- Re: profit/loss calculator
- Re: Macro to Lookup Exact Value
- Re: Bias in rand for excel 07
- LOOKUP VALUES FROM OTHER SHEET
- Re: Bias in rand for excel 07
- Re: correction needed
- Refreshing External Data
- Re: correction needed
- Re: Delete Matched Cells
- Re: Macro to Lookup Exact Value
- Re: Delete Matched Cells
- Re: correction needed
- Re: Delete Matched Cells
- Re: Bias in rand for excel 07
- RE: Bias in rand for excel 07
- RE: Macro to Lookup Exact Value
- Delete Matched Cells
- Macro to Lookup Exact Value
- Re: Where did Tools>Reference go?
- Re: dates in macros
- Re: dates in macros
- Re: correction needed
- Re: Need Help: Strange, Strange Behavior ( Not Me. My Model! )
- Re: dates in macros
- Re: correction needed
- Re: Name limits
- Re: NEED MACRO FOR COLOUR BY CONDITIONAL FORMATTING
- Re: Need Help: Strange, Strange Behavior ( Not Me. My Model! )
- Re: NEED MACRO FOR COLOUR BY CONDITIONAL FORMATTING
- correction needed
- Re: NEED MACRO FOR COLOUR BY CONDITIONAL FORMATTING
- Re: UDF that works under Excel 2003 but not under Excel 2007
- Re: NEED MACRO FOR COLOUR BY CONDITIONAL FORMATTING
- Re: add a dropdown calendar to a worksheet?
- Re: add a dropdown calendar to a worksheet?
- Re: NEED MACRO FOR COLOUR BY CONDITIONAL FORMATTING
- Re: dates in macros
- Re: add a dropdown calendar to a worksheet?
- Re: NEED MACRO FOR COLOUR BY CONDITIONAL FORMATTING
- Re: dates in macros
- Re: NEED MACRO FOR COLOUR BY CONDITIONAL FORMATTING
- Re: Horisontal scroolbars problems
- Re: NEED MACRO FOR COLOUR BY CONDITIONAL FORMATTING
- Re: add a dropdown calendar to a worksheet?
- RE: NEED MACRO FOR COLOUR BY CONDITIONAL FORMATTING
- RE: makro to log info in Access
- Re: Name limits
- Re: Name limits
- profit/loss calculator
- Re: Excel Properties() collection
- NEED MACRO FOR COLOUR BY CONDITIONAL FORMATTING
- Re: I want If and Vlookup together in one cell
- Re: dates in macros
- Re: set range error in add sheet
- Re: one per day password
- Re: one per day password
- Re: Copying dada from multiple workbooks into 1 workbook
- Re: difficulty with percentage from worksheet as seen by VBA
- difficulty with percentage from worksheet as seen by VBA
- Re: Copying dada from multiple workbooks into 1 workbook
- Re: TMOO - Mood tag
- From: crferguson@xxxxxxxxx
- Re: dates in macros
- Re: Copying data from multiple workbooks into 1 workbook
- Copying dada from multiple workbooks into 1 workbook
- Re: Range Question
- Need Help: Strange, Strange Behavior ( Not Me. My Model! )
- Re: Formatting a single column
- Re: Formatting a single column
- From: Rick Rothstein \(MVP - VB\)
- Re: Formatting a single column
- From: Rick Rothstein \(MVP - VB\)
- Re: Formatting a single column
- From: Rick Rothstein \(MVP - VB\)
- Re: Formatting a single column
- Re: Formatting a single column
- From: Rick Rothstein \(MVP - VB\)
- Formatting a single column
- Help with Userform/Autofilter/VBA
- Re: compile error in hidden module: sheet1
- Re: Error Message
- Re: copy rows to next sheet
- Re: Please Help
- Re: copy rows based on cell colour by conditional formating
- Re: Name limits
- GetFromClipboard help needed please
- Re: enter text in cell just by selecting cell
- Re: Please Help
- Re: copy rows based on cell colour by conditional formating
- Re: Please Help
- Re: enter text in cell just by selecting cell
- Re: Please Help
- Re: Please Help
- Re: Error Message
- Re: copy rows based on cell colour by conditional formating
- Re: dates in macros
- Re: Please Help
- Re: Please Help
- Re: indirect?
- Re: dates in macros
- Re: Fill down function
- Re: Error Message
- dates in macros
- indirect?
- Re: copy rows based on cell colour by conditional formating
- Re: Error Message
- Please Help
- Re: Error Message
- copy rows to next sheet
- Error Message
- Re: copy rows based on cell colour by conditional formating
- Re: copy rows based on cell colour by conditional formating
- Re: Public variable not storing
- Re: Tab Name
- Tab Name
- Re: information message
- Re: copy rows based on cell colour by conditional formating
- Re: Dumping Data Into Excel
- Re: Name limits
- information message
- Re: find numbers in text and put value in another worksheet
- copy rows based on cell colour by conditional formating
- TMOO - Mood tag
- Re: ADO 2.7 recordset problem
- ADO 2.7 recordset problem
- Re: Row Insert Function
- Re: Public variable not storing
- Re: Syntax again for DA
- Re: Compare values of cells in a range
- Re: Name limits
- Re: Add worksheet to workbook of calling procedure
- Re: problems recording macro_value or formula?
- Re: Add worksheet to workbook of calling procedure
- compile error in hidden module: sheet1
- Re: If - End if problem
- labels
- Re: Column label based on column index
- Name limits
- Re: If - End if problem
- Re: If - End if problem
- Re: Add worksheet to workbook of calling procedure
- Re: Remove passwords from many workbooks
- Re: If - End if problem
- From: Rick Rothstein \(MVP - VB\)
- Re: Problem with multiple error handling
- Re: Remove passwords from many workbooks
- Re: MsgBox Help
- Re: If - End if problem
- Re: If - End if problem
- Re: Add worksheet to workbook of calling procedure
- RE: Launching Standalone Program from within Excel.
- Re: Add worksheet to workbook of calling procedure
- Re: highlight a list
- Re: If - End if problem
- From: Rick Rothstein \(MVP - VB\)
- Re: If - End if problem
- Re: If - End if problem
- Re: Problem running VBA 2000 code in Excel 2003
- Re: Problem running VBA 2000 code in Excel 2003
- Re: if an element in a row is true then copy whole row to another
- From: Rick Rothstein \(MVP - VB\)
- Re: Remove passwords from many workbooks
- Re: Excel Properties() collection
- Problem running VBA 2000 code in Excel 2003
- Re: macro to move data to new column
- Re: if an element in a row is true then copy whole row to another
- Re: if an element in a row is true then copy whole row to another
- From: Rick Rothstein \(MVP - VB\)
- Re: Add worksheet to workbook of calling procedure
- Re: copy & paste columns to new worksheet
- Re: if an element in a row is true then copy whole row to another
- From: Rick Rothstein \(MVP - VB\)
- Re: Excel Properties() collection
- Re: Remove passwords from many workbooks
- Re: if an element in a row is true then copy whole row to another
- Re: UDF that works under Excel 2003 but not under Excel 2007
- Re: Add worksheet to workbook of calling procedure
- Re: workbook sharing entries at the same time
- getting current procedure name
- Re: if an element in a row is true then copy whole row to another
- From: Rick Rothstein \(MVP - VB\)
- Re: Remove passwords from many workbooks
- From: adambush4242@hotmail.com
- Re: if an element in a row is true then copy whole row to another
- Re: Add worksheet to workbook of calling procedure
- copy & paste columns to new worksheet
- RE: Offset & Range
- Re: Fill down function
- From: Rick Rothstein \(MVP - VB\)
- Re: Dumping Data Into Excel
- From: Ronald R. Dodge, Jr.
- Re: Remove passwords from many workbooks
- Re: Column label based on column index
- Re: Problem with multiple error handling
- RE: Please help with my code
- Re: lookup
- Re: Remove passwords from many workbooks
- From: adambush4242@hotmail.com
- Re: Add worksheet to workbook of calling procedure
- Re: Excel Properties() collection
- Re: Problem with multiple error handling
- Re: Add worksheet to workbook of calling procedure
- RE: Please help with my code
- Re: highlight a list
- Dumping Data Into Excel
- From: Ronald R. Dodge, Jr.
- RE: Please help with my code
- Add worksheet to workbook of calling procedure
- RE: PopUpMenu in Flexgrid - Excel2002
- Re: if an element in a row is true then copy whole row to another shee
- From: Rick Rothstein \(MVP - VB\)
- Re: Getting unnecessary 2nd Page
- RE: Please help with my code
- Re: Getting unnecessary 2nd Page
- Re: Compare values of cells in a range
- Re: Remove passwords from many workbooks
- Re: if an element in a row is true then copy whole row to another shee
- Re: Getting unnecessary 2nd Page
- Re: Remove passwords from many workbooks
- Re: if an element in a row is true then copy whole row to another shee
- Re: Launching Standalone Program from within Excel.
- RE: Launching Standalone Program from within Excel.
- Re: Excel 2003 VBA Help me complete this Search script
- RE: Macro formats field with value
- RE: Please help with my code
- RE: Sort worksheet tabs based on ASCII values.
- Re: Activate Range for Workbooks Already Open
- RE: Sort worksheet tabs based on ASCII values.
- RE: Please help with my code
- Re: Disable the Close button on a Userform
- Re: Excel Properties() collection
- Re: ConnectionString Timeout After 60 seconds
- Re: Excel 2007 is a Joke
- Re: Excel 2007 is a Joke
- Re: worksheet range qualifier
- From: sugargenius@xxxxxxxxx
- Re: delete columns
- Re: delete columns
- RE: Excel 2007 is a Joke
- Re: Excel Properties() collection
- Re: disable copy and save as
- Re: Disable the Close button on a Userform
- Re: Disable the Close button on a Userform
- PopUpMenu in Flexgrid - Excel2002
- Re: Compare values of cells in a range
- Re: Compare values of cells in a range
- Re: Disable the Close button on a Userform
- Re: Compare values of cells in a range
- Re: worksheet range qualifier
- Re: lookup
- Re: Activate Range for Workbooks Already Open
- Excel Properties() collection
- Re: lookup
- Re: Disable the Close button on a Userform
- worksheet range qualifier
- From: sugargenius@xxxxxxxxx
- Re: delete columns
- workbook sharing entries at the same time
- PopMenu in Flexgrid (with Excel 200)
- Re: Decimal Places
- Re: Decimal Places
- Re: problems recording macro_value or formula?
- Re: Decimal Places
- Re: excel VBA programmer, what is the value of adding access for data
- Decimal Places
- Re: Automation stumble
- Re: checkbox to hide/show row
- Re: Convert column data to trim all characters and leave the last
- Re: excel VBA programmer, what is the value of adding access for data
- Re: VBA versus VSTO (fundamentally excell based)
- Re: Automation stumble
- Re: excel VBA programmer, what is the value of adding access for data
- Re: UDF that works under Excel 2003 but not under Excel 2007
- Re: How to ORDERBY Alphabets in ascending order?
- Re: How can I make arrow keys skip over cells?
- Re: SaveAs without closing original workbook
- Re: quick Conditional Format question <--rookie here
- Re: Macro to Enter text
- From: Rick Rothstein \(MVP - VB\)
- Re: quick Conditional Format question <--rookie here
- Re: quick Conditional Format question <--rookie here
- Re: Macro to Enter text
- From: Rick Rothstein \(MVP - VB\)
- Re: remove macros
- Re: Macro to Enter text
- quick Conditional Format question <--rookie here
- Re: Macro to Enter text
- From: Rick Rothstein \(MVP - VB\)
- Re: VB error
- Re: Macro to Enter text
- From: Rick Rothstein \(MVP - VB\)
- Re: Macro to Enter text
- Re: Macro to Enter text
- From: Rick Rothstein \(MVP - VB\)
- Re: VBA to sort blank cells to bottom <--help please :o)
- Re: Macro to Enter text
- Re: Macro to Enter text
- Re: VBA to sort blank cells to bottom <--help please :o)
- Re: MsgBox Help
- From: Rick Rothstein \(MVP - VB\)
- RE: Return To Last Active Sheet
- Re: Return To Last Active Sheet
- Re: Excel Calculations through VBA
- Re: Dot Trailers '...' in Cells where text is too long...
- Re: Macro to Enter text
- From: Rick Rothstein \(MVP - VB\)
- Re: macro to copy to another workbook
- Re: Saving to Intranet Site
- Re: Using comma inside the comma delimited text in Data Validation
- Re: Macro to Enter text
- Re: Macro to Enter text
- From: Rick Rothstein \(MVP - VB\)
- Re: Macro to Enter text
- From: Rick Rothstein \(MVP - VB\)
- Re: Prime numbers
- Re: How can I make arrow keys skip over cells?
- Re: Macro to Enter text
- Re: VBA to sort blank cells to bottom <--help please :o)
- Re: hiding sheets using a form
- Re: Macro to Enter text
- Re: lookup
- Re: Naming Workbook
- From: ViViC via OfficeKB.com
- Re: VBA to sort blank cells to bottom <--help please :o)
- Re: Excel to Powerpoint - Text Box Properties
- checkbox to hide/show row
- VBA to sort blank cells to bottom <--help please :o)
- Macro to Enter text
- Re: Odd macro performance. Explanation?
- Re: MsgBox Help
- Re: MsgBox Help
- Re: MsgBox Help
- How can I make arrow keys skip over cells?
- RE: Return To Last Active Sheet
- Re: Activate Range for Workbooks Already Open
- Re: Return To Last Active Sheet
- RE: Excel 2003 VBA Help me complete this Search script
- Re: copy rows based on cell colour
- Re: Limit on Range Object
- Re: Application.FileSearch in 2007
- Re: Code for sending Outlook email with attachments using a list
- Re: adding worksheet with macro but need to get back to 1st sheet
- Re: Locking cells after the user has entered values in protected works
- Excel 2003 VBA Help me complete this Search script
- Re: copy rows based on cell colour
- Excel to Powerpoint - Text Box Properties
- Re: UDF that works under Excel 2003 but not under Excel 2007
- Code for sending Outlook email with attachments using a list
- Re: Prime numbers
- copy rows based on cell colour
- Re: Application.FileSearch in 2007
- Re: Limit on Range Object
- Re: adding worksheet with macro but need to get back to 1st sheet
- copy rows based on cell colour
- Re: Sampling in excel
- From: FortisChet@xxxxxxxxx
- Re: adding worksheet with macro but need to get back to 1st sheet
- adding worksheet with macro but need to get back to 1st sheet
- Re: Dot Trailers '...' in Cells where text is too long...
- RE: question on excel 2007
- RE: Using MATCH function in VBA
- Re: Finding a value in one of two columns
- From: Rick Rothstein \(MVP - VB\)
- RE: Prime numbers
- Excel Calculations through VBA
- Re: Adjust series order in Excel 2007
- Re: Display contents of text file in a listbox or textbox on Excel for
- From: Rick Rothstein \(MVP - VB\)
- Re: SaveAs without closing original workbook
- Re: Macros missings
- Re: Import data from multiple excel files in one folder
- Re: Macro That Deletes Rows Extremely Slow
- RE: Need assistance with code issue??
- wholesale ugg,vans,boots,nike,timberland,dc,sandals,bakers,puma,crocs,adidas
- Re: Macro That Deletes Rows Extremely Slow
- Re: Import data from multiple excel files in one folder
- Re: Odd macro performance. Explanation?
- RE: excel to CSV
- RE: Display contents of text file in a listbox or textbox on Excel for
- Re: Odd macro performance. Explanation?
- Re: Rounding formulas
- RE: Lookup
- Re: Import data from multiple excel files in one folder
- Re: UserInterfaceOnly not being recognised
- Re: Import data from multiple excel files in one folder
- Re: Range analisys
- Re: Month to Number format
- From: crferguson@xxxxxxxxx
- RE: Problem asttaching macro to form button
- Re: Paste data into another workbook but not overwriting original data
- From: crferguson@xxxxxxxxx
- RE: Lookup
- Re: Find Last Used Row
- RE: Rounding formulas
- Re: Import data from multiple excel files in one folder
- Re: Adjust series order in Excel 2007
- RE: Change all Links
- Re: Find Last Used Row
- Re: SaveAs without closing original workbook
- Re: Macro That Deletes Rows Extremely Slow
- RE: Problem asttaching macro to form button
- RE: Find Last Used Row
- Re: Copy certain rows from one worksheet to another
- RE: Problem asttaching macro to form button
- Re: Find Last Used Row
- Re: Efficient paste from web page; also bring Excel to front
- UDF that works under Excel 2003 but not under Excel 2007
- Re: Odd macro performance. Explanation?
- Re: Macro That Deletes Rows Extremely Slow
- RE: Macro That Deletes Rows Extremely Slow
- Re: deleting cells
- Unicode strings and Excel 2003
- Problem asttaching macro to form button
- Re: Excel Interop DLL problem 2003
- deleting cells
- Re: Update Custom Toolbar Buttons
- RE: Saving to Intranet Site
- delete cells
- Re: lookup
- Re: Application.Iteration in UDF
- Re: Open , Save, and Close Macro
- tlbimp vs. primary in VS project file
- Re: howto replace the order of adress ?
- Excel Interop DLL problem 2003
- RE: Saving to Intranet Site
- Re: Update Custom Toolbar Buttons
- Re: lookup
- Macros missings
- How to diagnose a COM addin that fails to load?
- Re: UserInterfaceOnly not being recognised
- Re: Copy a part of worksheet with active x elements
- Re: SaveAs without closing original workbook
- RE: Change all Links
- Re: Moving data makes unwanted change to formula
- Re: SaveAs without closing original workbook
- Re: lookup
- Age old business day with holiday entry
- From: Darrell_Sarrasin via OfficeKB.com
- RE: Importing from another file of unknown name
- Re: UserInterfaceOnly not being recognised
- RE: copying if value in cell from range of cells
- RE: Textboxes not Calculating properly
- Re: Select Case and If...Then Statements in UserForm not Calculati
- Re: Application.Iteration in UDF
- Re: Application.Iteration in UDF
- Re: Select Case and If...Then Statements in UserForm not Calculati
- Re: Application.Iteration in UDF
- Re: Automation stumble
- RE: Textboxes not Calculating properly
- Re: UDF Optional variables become required in Add-In
- Re: Copy a part of worksheet with active x elements
- Automation stumble
- Automation stumble
- Automation stumble
- Drawing on a Chart
- Re: UDF Optional variables become required in Add-In
- Re: Dot Trailers '...' in Cells where text is too long...
- Re: activating a page of a multipage control
- Re: Using comma inside the comma delimited text in Data Validation
- Importing from another file of unknown name
- Re: Application.Iteration in UDF
- Re: right click menu
- Re: pop-up calculator
- RE: Please help with my code
- Re: UDF Optional variables become required in Add-In
- right click menu
- Re: UDF Optional variables become required in Add-In
- Re: HELP & Commercial
- Re: HELP & Commercial
- Re: find numbers in text and put value in another worksheet
- HELP & Commercial
- Re: Conditional counting with multiple criteria
- Conditional counting with multiple criteria
- Moving data makes unwanted change to formula
- Re: Simple Excel formula
- UDF Optional variables become required in Add-In
- Re: Unique ID on different sheets
- Re: VB error
- Re: Simple Excel formula
- Re: Selection.* not work
- Simple Excel formula
- Re: Limit on Range Object
- Re: Limit on Range Object
- Re: VB error
- Re: VB error
- From: Rick Rothstein \(MVP - VB\)
- Re: VB error
- Re: Limit on Range Object
- Re: Range analisys
- VB error
- Re: Using comma inside the comma delimited text in Data Validation/Sou
- Re: VBA Excel Conditional Formatting <--rookie here
- Re: Dot Trailers '...' in Cells where text is too long...
- Re: Simple VBA Macro to import Data
- Re: Insert Formula in Range
- Re: VBA Excel Conditional Formatting <--rookie here
- Re: lookup
- Re: Limit on Range Object
- Re: Insert Formula in Range
- From: sjoo.kwak@xxxxxxxxx
- Insert Formula in Range
- Re: lookup
- RE: Userform Frames Occasionally Disappear When Form is Activated
- RE: VBA Excel Conditional Formatting <--rookie here
- Re: adding combo/list box to msgbox/inputbox
- Re: VBA Excel Conditional Formatting <--rookie here
- Re: lookup
- Re: Copy certain rows from one worksheet to another
- From: azu_daioh@xxxxxxxxx
- Userform Frames Occasionally Disappear When Form is Activated
- Re: Right() error changing columns in macro
- adding combo/list box to msgbox/inputbox
- VBA Excel Conditional Formatting <--rookie here
- Re: Right() error changing columns in macro
- Re: Refresh Data on hidden worksheet <--help please
- RE: RE-Post Max Function not working properly on 2D Array
- Re: Refresh Data on hidden worksheet <--help please
- RE: Elapsed period between dates
- RE-Post Max Function not working properly on 2D Array
- RE: Elapsed period between dates
- RE: Change all Links
- RE: Elapsed period between dates
- Re: Refresh Data on hidden worksheet <--help please
- Re: Export VBA Modules
- RE: CurrentRegion issue (attempt 2)
- RE: Refresh Data on hidden worksheet <--help please
- RE: CurrentRegion issue (attempt 2)
- Re: Right() error changing columns in macro
- Refresh Data on hidden worksheet <--help please
- Re: Right() error changing columns in macro
- From: Rick Rothstein \(MVP - VB\)
- Re: Copy certain rows from one worksheet to another
- From: azu_daioh@xxxxxxxxx
- Re: Export VBA Modules
- Re: Need some VBA help
- Re: What am I missing here???
- Re: CurrentRegion issue (attempt 2)
- Re: Right() error changing columns in macro
- Re: Dialog Box
- RE: Replace worksheet
- Re: add "paste values" to right click menu
- How to Copy a sum of a column from different Excel sheets to a single master excel sheet?
- Re: Subtotal
- Re: Right() error changing columns in macro
- Re: macro to move data to new column
- Re: Range analisys
- Re: What am I missing here???
- Re: Right() error changing columns in macro
- RE: Unique ID on different sheets
- Re: Mouse Scroll event in listbox kills Excel
- Re: Right() error changing columns in macro
- Re: Range analisys
- RE: Please help with my code
- Re: CurrentRegion issue (attempt 2)
- macro to move data to new column
- Checking a setting on startup
- From: bluegrassstateworker
- RE: Range analisys
- Re: Find blank cells and clear adjacent range
- Re: What am I missing here???
- Re: Right() error changing columns in macro
- Re: Right() error changing columns in macro
- Re: Right() error changing columns in macro
- Re: Efficient paste from web page; also bring Excel to front
- Re: Efficient paste from web page; also bring Excel to front
- RE: Read text file and UNIX end of line
- RE: Read text file and UNIX end of line
- RE: Textboxes not Calculating properly
- Re: Right() error changing columns in macro
- RE: Please help with my code
- Range analisys
- RE: Date Format code with error now
- Re: Hiding Rows from VBA
- Re: Need some VBA help
- Re: Macro to extract data from webpage
- RE: Please help with my code
- RE: Please help with my code
- Read text file and UNIX end of line
- Re: Right() error changing columns in macro
- From: Rick Rothstein \(MVP - VB\)
- RE: Please help with my code
- Re: activating a page of a multipage control
- Re: User Defined Function Opens Improperly - Round III
- Re: Right() error changing columns in macro
- Re: Reading values into an array of User Defined Types
- RE: Please help with my code
- RE: Please help with my code
- Re: VBA code, delete worksheets
- RE: Please help with my code
- Re: Right() error changing columns in macro
- Re: Right() error changing columns in macro
- Re: Copy certain rows from one worksheet to another
- Re: Right() error changing columns in macro
- Date Format code with error now
- RE: Please help with my code
- Re: Need some VBA help
- Re: Right() error changing columns in macro
- Re: Help with C. Pearsons code to VBE
- Re: Please help with my code
- Re: Right() error changing columns in macro
- RE: Please help with my code
- Re: Right() error changing columns in macro
- Re: Please help with my code
- Re: Date Question
- RE: Textboxes not Calculating properly
- RE: What am I missing here???
- Re: Hiding Rows from VBA
- Re: Please help with my code
- Re: Need some VBA help
- Re: Please help with my code
- RE: Right() error changing columns in macro
- Re: Right() error changing columns in macro
- RE: Right() error changing columns in macro
- What am I missing here???
- RE: Input Box only if a cell is blank
- RE: I have a query about loops and random numbers
- Re: Help with C. Pearsons code to VBE
- RE: Select Case and If...Then Statements in UserForm not Calculati
- Keyboard Macros
- Re: Repeat
- From: Rick Rothstein \(MVP - VB\)
- Re: Excel default workbook
- RE: I have a query about loops and random numbers
- Remove Pivot CommandBars from right click menu
- Right() error changing columns in macro
- Re: removing special characters
- Re: Date Question
- Re: Convert column data to trim all characters and leave the last
- Very long code execution time problem
- Re: Select Case and If...Then Statements in UserForm not Calculating
- From: Rick Rothstein \(MVP - VB\)
- I have a query about loops and random numbers
- Re: Select Case and If...Then Statements in UserForm not Calculating
- RE: removing special characters
- Date Question
- Re: VBA code, delete worksheets
- RE: Select Case and If...Then Statements in UserForm not Calculating
- RE: Please help with my code
- Re: Please help with my code
- Re: Please help with my code
- RE: VBA code, delete worksheets
- Re: VBA code, delete worksheets
- removing special characters
- RE: Determine if the sheet has been changed
- VBA code, delete worksheets
- Please help with my code
- Using comma inside the comma delimited text in Data Validation/Sou
- Re: Macro to extract data from webpage
- Re: Excel default workbook
- Help with user interface for charts
- Re: Freezing Top and Bottom Rows
- Re: Highlight cells containing words of a given type
- Select Case and If...Then Statements in UserForm not Calculating
- Re: Reading values into an array of User Defined Types
- Re: Dot Trailers '...' in Cells where text is too long...
- Excel default workbook
- Re: Hiding Rows from VBA
- Re: Need some VBA help
- Re: Changing chart data ranges from VBA code
- Re: o -t does anyone see and speed increase after office 2007 sp1 is installed?
- Re: Which is faster, copying range to another set of ranges or copying to memory?
- Re: Repeat
- Re: Highlight cells containing words of a given type
- Re: Dot Trailers '...' in Cells where text is too long...
- Re: Highlight cells containing words of a given type
- Re: Help with C. Pearsons code to VBE
- Help required with 'FOR' Loop and Userforms
- Re: Help with C. Pearsons code to VBE
- Re: Dot Trailers '...' in Cells where text is too long...
- Re: Help with C. Pearsons code to VBE
- Re: How can I make an executable program from excel?
- Re: Highlight cells containing words of a given type
- Re: activating a page of a multipage control
- Re: Help with C. Pearsons code to VBE
- RE: Textboxes not Calculating properly
- Re: Hide and Unhide Rows button
- Re: Hide and Unhide Rows button
- Re: Hide and Unhide Rows button
- Re: Help with C. Pearsons code to VBE
- Hide and Unhide Rows button
- Re: Help with C. Pearsons code to VBE
- Re: Help with C. Pearsons code to VBE
- Re: VBA, copy unique values
- Re: Help with C. Pearsons code to VBE
- VBA, copy unique values
- Re: Help with C. Pearsons code to VBE
- Re: Highlight cells containing words of a given type
- Re: Problem with macros
- From: Rick Rothstein \(MVP - VB\)
- Re: Help with C. Pearsons code to VBE
- Re: Help with C. Pearsons code to VBE
- Re: Problem with macros
- Re: Problem with macros
- Re: Problem with macros
- Re: Set Named Range with Last Row
- Re: Set Named Range with Last Row
- Re: Problem with macros
- Problem with macros
- Re: Hiding Formulas
- Re: Sorting a Column in ascending order in excel vba
- Re: More Excel 2007 Speed Issues
- coding for excel programming
- Re: Naming Workbook
- Re: problems recording macro_value or formula?
- Re: problems recording macro_value or formula?
- Re: Split Cells?
- From: Rick Rothstein \(MVP - VB\)
- Re: o -t does anyone see and speed increase after office 2007 sp1 is installed?
- Naming Workbook
- From: ViViC via OfficeKB.com
- Re: VBA Code Optimization
- Split Cells?
- RE: Textboxes not Calculating properly
- Re: Hiding Rows from VBA
- RE: Textboxes not Calculating properly
- WorksheetFunction
- Re: Reading values into an array of User Defined Types
- Textboxes not Calculating properly
- Re: Reading values into an array of User Defined Types
- Re: Reading values into an array of User Defined Types
- Re: Input Box only if a cell is blank
- Re: Input Box only if a cell is blank
- Re: Input Box only if a cell is blank
- Re: Reading values into an array of User Defined Types
- Hiding Rows from VBA
- Re: Reading values into an array of User Defined Types
- Re: Input Box only if a cell is blank
- Re: Disregard conditional formatting if cell is blank
- RE: Input Box only if a cell is blank
- RE: Input Box only if a cell is blank
- Reading values into an array of User Defined Types
- Re: Seems easy
- Re: Multi Line Transpose Excel VBA code
- Re: o -t does anyone see and speed increase after office 2007 sp1 is installed?
- Re: Multi Line Transpose Excel VBA code
- Re: Multi Line Transpose Excel VBA code
- o -t does anyone see and speed increase after office 2007 sp1 is installed?
- Re: How can I make an executable program from excel?
- Re: Multi Line Transpose Excel VBA code
- Copy certain rows from one worksheet to another
- From: azu_daioh@xxxxxxxxx
- Re: Find blank cells and clear adjacent range
- Re: Subtotal
- Re: add "paste values" to right click menu
- Re: Changing chart data ranges from VBA code
- Re: Subtotal
- Multi Line Transpose Excel VBA code
- Re: Efficient paste from web page; also bring Excel to front
- Re: Min Function on 2D Array
- Re: Sampling in excel
- Re: Min Function on 2D Array
- Re: Delete Rows Between Border Lines
- Re: Subtotal
- Re: Min Function on 2D Array
- RE: Subtotal
- Re: Find blank cells and clear adjacent range
- Re: Find blank cells and clear adjacent range
- Re: Min Function on 2D Array
- Re: Subtotal
- Re: With .Controls.Add(msoControlPopup)
- Re: Find blank cells and clear adjacent range
- From: Rick Rothstein \(MVP - VB\)
- Re: How can I make an executable program from excel?
- Re: Min Function on 2D Array
- Re: Can't copy
- Re: Seems easy
- Re: Condense ISERROR(VLOOKUP(MATCH())) to VBA function.
- Subtotal
- Re: Condense ISERROR(VLOOKUP(MATCH())) to VBA function.
- RE: Setting a cell format based on a function operation
- Can't copy
- Re: Problem with Deletion
- Re: Min Function on 2D Array
- Re: Install Analysis ToolPak
- Sampling in excel
- From: FortisChet@xxxxxxxxx
- Re: Problem with Deletion
- Seems easy
- Re: Problem with Deletion
- Re: Install Analysis ToolPak
- RE: How to pass selected cells into a delimited text string?
- Re: .find not finding corect value
- Best thing you can do
- Re: Please help with Count
- Re: Extracting proper range address from multiple cell selections
- Re: reset my format cell properties
- Re: Find blank cells and clear adjacent range
- Condense ISERROR(VLOOKUP(MATCH())) to VBA function.
- Re: reset my format cell properties
- Re: Please help with Count
- Re: Please help with Count
- Re: Please help with Count
- Re: With .Controls.Add(msoControlPopup)
- RE: Copy Cells
- Re: Highlight cells containing words of a given type
- .find not finding corect value
- Re: Excel & Word Password Protection
- Re: Refer to Public Variable from Another Workbook
- Re: Refer to Public Variable from Another Workbook
- Re: Deleting Columns - Causes Code Changes
- Re: fill external data in specific cells of various sheet
- From: crferguson@xxxxxxxxx
- Re: Freezing Top and Bottom Rows
- Re: Deleting Columns - Causes Code Changes
- From: crferguson@xxxxxxxxx
- Re: Prompt box when emailing via VBA
- Re: Row Insert Function
- Re: carrage return
- Re: Set Named Range with Last Row
- Re: Which is faster, copying range to another set of ranges or copying to memory?
- Re: Prompt box when emailing via VBA
- Re: Set Named Range with Last Row
- Re: Making Application.CommandBars.ExecuteMso method work in 2007
- Re: Deleting Columns - Causes Code Changes
- From: rick@xxxxxxxxxxxxxx
- Re: Min Function on 2D Array
- Re: Excel 2007 Buttons
- Re: Find blank cells and clear adjacent range
- From: Rick Rothstein \(MVP - VB\)
- Re: Set Named Range with Last Row
- RE: New to userforms - can you help with this code?
- Re: Find blank cells and clear adjacent range
- From: Rick Rothstein \(MVP - VB\)
- Set Named Range with Last Row
- Re: Find blank cells and clear adjacent range
- From: crferguson@xxxxxxxxx
- Re: Changing chart data ranges from VBA code
- Re: Find blank cells and clear adjacent range
- Re: Min Function on 2D Array
- From: crferguson@xxxxxxxxx
- Re: Min Function on 2D Array
- From: crferguson@xxxxxxxxx
- Re: Excel & Word Password Protection
- From: crferguson@xxxxxxxxx
- Re: Prompt box when emailing via VBA
- From: crferguson@xxxxxxxxx
- Find blank cells and clear adjacent range
- Re: Deleting Columns - Causes Code Changes
- From: crferguson@xxxxxxxxx
- ID3v2 MP3 Tag Reading Class
- From: crferguson@xxxxxxxxx
- Changing chart data ranges from VBA code
- Deleting Columns - Causes Code Changes
- From: rick@xxxxxxxxxxxxxx
- Which is faster, copying range to another set of ranges or copying to memory?
- Re: Extracting proper range address from multiple cell selections
- RE: New to userforms - can you help with this code?
- RE: New to userforms - can you help with this code?
- Re: VBA Code Optimization
- Re: Extracting proper range address from multiple cell selections
- RE: New to userforms - can you help with this code?
- problems recording macro_value or formula?
- RE: VBA Code Optimization
- Automation error from RTD
- Re: Syntax Error ?. Execution does not enter the Select Case
- Re: Determine ActiveControl on a multipage (tab) control
- From: Rick Rothstein \(MVP - VB\)
- Re: Freezing Top and Bottom Rows
- VBA Code Optimization
- Re: Check box problem Excel 2003
- Re: Determine ActiveControl on a multipage (tab) control
- RE: New to userforms - can you help with this code?
- Re: Extracting proper range address from multiple cell selections
- Re: findnext error in loop
- Re: Unique ID on different sheets
- RE: New to userforms - can you help with this code?
- RE: findnext error in loop
- RE: Display the current value of an Options setting
- Importing DBF with large number of fields
- Re: Extracting proper range address from multiple cell selections
- RE: Display the current value of an Options setting
- Re: Determine ActiveControl on a multipage (tab) control
- From: Rick Rothstein \(MVP - VB\)
- RE: Display the current value of an Options setting
- Re: Determine ActiveControl on a multipage (tab) control
- From: Rick Rothstein \(MVP - VB\)
- RE: New to userforms - can you help with this code?
- Re: Check box problem Excel 2003
- Re: Efficient paste from web page; also bring Excel to front
- RE: Delete Rows Between Border Lines
- Re: Macro programing in excell
- Excel 2007 Buttons
- RE: New to userforms - can you help with this code?
- Re: Syntax Error ?. Execution does not enter the Select Case
- RE: Setting a cell format based on a function operation
- RE: New to userforms - can you help with this code?
- Re: Unique ID on different sheets
- RE: New to userforms - can you help with this code?
- RE: Unique ID on different sheets
- Syntax Error ?. Execution does not enter the Select Case
- New to userforms - can you help with this code?
- Re: copying if value in cell from range of cells
- RE: Delete Rows Between Border Lines
- Re: Access wab page with excel VBA
- RE: Unique ID on different sheets
- RE: Delete Rows Between Border Lines
- Re: Very Slow
- Re: Access wab page with excel VBA
- Highlight cells containing words of a given type
- RE: Create a Macro to update File and Worksheet References in Formulas
- Re: Macro for numbers duplication
- Re: VB code needed
- Re: Access wab page with excel VBA
- RE: format numeric data in pivot table
- Re: Excel's Refreshable Web Query & Javascript...
- Re: How to get the number of Line/Column used in Excel sheet ?
- Re: Selection.* not work
- Re: Selection.* not work
- Re: How to get the number of Line/Column used in Excel sheet ?
- Re: referring to the button that triggered the macro
- Re: Code to Slooooooow
- How to get the number of Line/Column used in Excel sheet ?
- referring to the button that triggered the macro
- Re: unlocking merge cells
- Re: Excel's Refreshable Web Query & Javascript...
- Re: Code to Slooooooow
- Selection.* not work
- Re: VLOOKUP Error N/A
- Re: VLOOKUP Error N/A
- Re: Syntax again for DA
- Excel's Refreshable Web Query & Javascript...
- Code to Slooooooow
- Re: Extracting proper range address from multiple cell selections
- Re: tab to select combo box instead of field?
- Re: Multiple Excel File Import
- Re: Please Help Splitting data
- From: Rick Rothstein \(MVP - VB\)
- Re: tab to select combo box instead of field?
- RE: Setting a cell format based on a function operation
- Re: public sub worksheet_change ever possible?
- Re: Adding UserForm Data to Worksheet
- Re: Any way to word search in a Text Box?
- RTD Server deployment
- RE: Multi Page Scroll Bar
- public sub worksheet_change ever possible?
- Re: Adding UserForm Data to Worksheet
- RE: Multi Page Scroll Bar
- Re: Userform Question
- Re: Please Help Splitting data
- Re: Row Insert Function
- RE: Finding row number with .find()
- Re: carrage return
- Re: Query multiple database platforms from Excel
- From: deepakvenkatesan123@xxxxxxxxx
- RE: Copy Cells
- Re: carrage return
- Re: PageSetup Performance Question
- RE: Finding row number with .find()
- Setting a cell format based on a function operation
- RE: format numeric data in pivot table
- Re: complicated change to formula (conintuous)
- Re: xls file becomes larger
- Re: Modifying J Walkenbach's data entry userform
- Re: Adding UserForm Data to Worksheet
- Re: Query multiple database platforms from Excel
- Re: Array function
- PageSetup Performance Question
- Finding row number with .find()
- Re: transfer range of cells from excel to Acess using vba
- Re: Determine ActiveControl on a multipage (tab) control
- From: Rick Rothstein \(MVP - VB\)
- Re: carrage return
- Re: Modifying J Walkenbach's data entry userform
- Re: how can i crack password prottected workbook
- Re: Determine ActiveControl on a multipage (tab) control
- From: deepakvenkatesan123@xxxxxxxxx
- Re: carrage return
- Re: Create a Formula
- Re: Array function
- Re: Sort and Match Cells
- Re: Please Help Splitting data
- From: Rick Rothstein \(MVP - VB\)
- Re: Determine ActiveControl on a multipage (tab) control
- From: deepakvenkatesan123@xxxxxxxxx
- Re: Macro to validate is cell is not empty and copy the line
- Query multiple database platforms from Excel
- From: deepakvenkatesan123@xxxxxxxxx
- Re: New to VBA - What does this code mean?
- Re: Macro to validate is cell is not empty and copy the line
- Re: Making Application.CommandBars.ExecuteMso method work in 2007
- Re: Extracting proper range address from multiple cell selections
- Re: Please Help Splitting data
- setNumberFormat in custom excel function
- Re: New to VBA - What does this code mean?
- Re: PDF help!
- From: Marlene.Sawhney@xxxxxxxxx
- Re: New to VBA - What does this code mean?
- Re: Pass control to a function/subroutine
- New to VBA - What does this code mean?
- Re: Multiline Messagebox in VBA
- From: Rick Rothstein \(MVP - VB\)
- Re: Making Application.CommandBars.ExecuteMso method work in 2007
- Modifying J Walkenbach's data entry userform
- Re: summing by color
- Re: Pass control to a function/subroutine
- Re: yet another Obj var not set
- Re: yet another Obj var not set
- Re: summing by color
- Re: how to launch VBA in 2007
- Re: Pass control to a function/subroutine
- Re: Pass control to a function/subroutine
- Re: Sort and Match Cells
- Re: summing by color
- Re: yet another Obj var not set
- yet another Obj var not set
- 2008air jordan nike puma prada gucci shoes hot selling !!!(www.nikewoo.com)
- Re: how can i crack password prottected workbook
- Re: Printing envelopes based on Excel table contents
- Re: selecting range over multiple sheets
- RE: Multi Page Scroll Bar
- Macro to validate is cell is not empty and copy the line
- Re: Please Help Splitting data
- Re: summing by color
- Re: Efficient paste from web page; also bring Excel to front
- Re: Sort and Match Cells
- Re: If or Case help - Which to use
- Re: Multiline Messagebox in VBA
- New Forum For People Who Love To Discuss On Technical Topics
- Re: Access wab page with excel VBA
- RE: PDF help!
- Referencing Worksheets from Cell Values
- Re: Row Insert Function
- Re: ERROR problem with Formula
- Re: Extracting proper range address from multiple cell selections
- PDF help!
- From: Marlene.Sawhney@xxxxxxxxx
- Re: transfer range of cells from excel to Acess using vba
- Re: ERROR problem with Formula
- Re: Sort and Match Cells
- Re: Sort and Match Cells
- Re: ERROR problem with Formula
- Re: Sort and Match Cells
- Re: Changing formula to Upper case
- Re: ERROR problem with Formula
- Re: Storing variables in a macro and using those variables to perform calculations.
- From: greg.moberg@xxxxxxxxx
- Re: Speed test results if interested
- Re: transfer range of cells from excel to Acess using vba
- Re: ERROR problem with Formula
- Re: Help with FindNext error
- Re: Extracting proper range address from multiple cell selections
- RE: Help with FindNext error
- Re: Please Help Splitting data
- Re: VBA Programming Enviornment & Intellipoint
- Re: ERROR problem with Formula
- Changing formula to Upper case
- RE: Please Help Splitting data
- Re: Sort and Match Cells
- RE: transfer range of cells from excel to Acess using vba
- ERROR problem with Formula
- Re: Storing variables in a macro and using those variables to perform calculations.
- Re: unlocking merge cells
- Re: Sort and Match Cells
- RE: Storing variables in a macro and using those variables to perform
- transfer range of cells from excel to Acess using vba
- Help with FindNext error
- Please Help Splitting data
- Sort and Match Cells
- Re: VB code needed
- Re: Help !, problem updating data through userform !
- Re: unlocking merge cells
- Storing variables in a macro and using those variables to perform calculations.
- From: greg.moberg@xxxxxxxxx
- fill external data in specific cells of various sheet
- fill external data in specific cells of various sheet
- Re: Counting a subset
- Re: focusing mouse pointer to the specific button in a userform
- Re: VB code needed
- Re: VB code needed
- Re: VB code needed
- Re: Accessing a C# dll from vba
- unlocking merge cells
- Accessing a C# dll from vba
- Re: Excel 2003 - Macro for Deleting Rows
- Re: Combining text in a cell with a named cell value
- Re: Combining text in a cell with a named cell value
- Combining text in a cell with a named cell value
- Re: Getting list of named ranges
- Re: Codename passing
- Re: subtotal
- Re: Excel 2003 - Macro for Deleting Rows
- Re: Excel 2003 - Macro for Deleting Rows
- Access wab page with excel VBA
- Re: Codename passing
- Re: Worksheet Codenames Passing to Function
- Re: Out of Context
- Re: Worksheet Codenames Passing to Function
- Re: Worksheet Codenames Passing to Function
- Re: Freezing Top and Bottom Rows
- Re: subtotal
- Re: Worksheet Codenames Passing to Function
- Re: Worksheet Codenames Passing to Function
- Re: tab to select combo box instead of field?
- Help !, problem updating data through userform !
- Worksheet Codenames Passing to Function
- Help - Routine to screencapture and save image?
- Re: Workbook Open?
- Re: Macro to create seperate sheets
- Re: Getting list of named ranges
- Re: Multiline Messagebox in VBA
- From: Rick Rothstein \(MVP - VB\)
- Re: tab to select combo box instead of field?
- Getting list of named ranges
- Re: Multiline Messagebox in VBA
- Re: tab to select combo box instead of field?
- Re: Multiline Messagebox in VBA
- Re: Macro for Fill Down where number of rows differs and without having to hardcode column ranges
- Multiline Messagebox in VBA
- Re: Can Excel modify data in a Query?
- Re: tab to select combo box instead of field?
- Re: Extracting proper range address from multiple cell selections in V
- RE: Problem in using Chart.ApplyCustomType for Excel 2007
- Re: Help with messy formula
- Help with messy formula
- Re: subtotal
- Re: focusing mouse pointer to the specific button in a userform
- Odd macro performance. Explanation?
- Find and Replace
- Re: Can multiple selection available to copy to new Workbooks ?
- Re: Custom Menu
- RE: Any way to word search in a Text Box?
- Re: Custom Menu
- Re: Custom Menu
- RE: MultiPage Scroll Bar
- Re: Custom Menu
- Re: Custom Menu
- Re: Custom Menu
- Re: Custom Menu
- Re: Excel 2003 - Macro for Deleting Rows
- Re: Any way to word search in a Text Box?
- Re: focusing mouse pointer to the specific button in a userform
- focusing mouse pointer to the specific button in a userform
- Re: VBA Programming Enviornment & Intellipoint
- Re: Repost: Is Workbook already open?
- Re: Finding row
- Re: Easy way to test range as single cell
- Re: Easy way to test range as single cell
- Re: Is there a way for a idMso button to display a custom image?
- Re: Is there a way for a idMso button to display a custom image?
- Re: how can i crack password prottected workbook
- Re: HELP: How to call UDF defined in another workbook?
- Re: Is there a way for a idMso button to display a custom image?
- HELP: How to call UDF defined in another workbook?
- Re: VBA Programming Enviornment & Intellipoint
- Any way to word search in a Text Box?
- Re: Is there a way for a idMso button to display a custom image?
- Re: Can Excel modify data in a Query?
- Re: How do I make all rows 7,...23 exactly 8 pixels higher ?
- From: Rick Rothstein \(MVP - VB\)
- RE: Finding row
- RE: Combobox.additem (No Repeats)
- Re: custom view to display specific toolbars
- Re: Easy way to test range as single cell
- Re: An error occurred while loading image with relationship ID ...
- Re: Easy way to test range as single cell
- Re: Easy way to test range as single cell
- Re: An error occurred while loading image with relationship ID ...
- Easy way to test range as single cell
- Re: HELP: How to restore Immediate Window to original state?
- Re: Combobox.additem (No Repeats)
- Finding row
- Re: Excel 2003 - Macro for Deleting Rows
- Re: Using a TextBox in a Userform
- Re: Loading an Array
- Re: Excel 2003 - Macro for Deleting Rows
- Re: Multiple sheet #REF
- Re: Use VB array as as argument for worksheet function
- Re: VBA Programming Enviornment & Intellipoint
- Re: Loading an Array
- Re: Loading an Array
- Re: ReDim Preserve on 2D Array not working
- Loading an Array
- Re: Use VB array as as argument for worksheet function
- Re: Use VB array as as argument for worksheet function
- Re: Use VB array as as argument for worksheet function
- Re: Use VB array as as argument for worksheet function
- Re: Use VB array as as argument for worksheet function
- Re: complicated change to formula (conintuous)
- Re: Use VB array as as argument for worksheet function
- Re: complicated change to formula (conintuous)
- Re: Use VB array as as argument for worksheet function
- Re: complicated change to formula (conintuous)
- Re: Use VB array as as argument for worksheet function
- Re: Code for Subtotals
- Re: subtotal
- how can i crack password prottected workbook
- Re: VB Right
- From: Rick Rothstein \(MVP - VB\)
- Re: subtotal
- RE: automatically hiding a cell when value changes
- Re: custom view to display specific toolbars
- Re: HELP: How to restore Immediate Window to original state?
- Re: HELP: How to restore Immediate Window to original state?
- Re: HELP: How to restore Immediate Window to original state?
- Re: HELP: How to restore Immediate Window to original state?
- Re: what object var should I use for the following code
- Re: what object var should I use for the following code
- Re: what object var should I use for the following code
- Re: Code for Subtotals
- Re: Continue to have issue with array in Subtotals automation
- Re: Editing MS Project File from Excel VBA
- Re: Speed test results if interested
- Re: HELP: How to restore Immediate Window to original state?
- Re: HELP: How to restore Immediate Window to original state?
- Re: HELP: How to restore Immediate Window to original state?
- Re: custom view to display specific toolbars
- Re: HELP: How to restore Immediate Window to original state?
- Re: Passing a value from one userform to another (multiple) form
- Re: HELP: How to restore Immediate Window to original state?
- Re: Is there a faster way
- Re: HELP: How to restore Immediate Window to original state?
- RE: custom view to display specific toolbars
- Re: Is there a faster way
- Re: HELP: How to restore Immediate Window to original state?
- HELP: How to restore Immediate Window to original state?
- custom view to display specific toolbars
- Re: Passing a value from one userform to another (multiple) form
- Re: MOVING WITH A RANGE-TAB
- Re: find string in web page
- Re: Is there a faster way
- RE: COLOR INDEX UPDATING & FOR CONDITIONAL FORMATTING!
- Re: COLOR INDEX UPDATING & FOR CONDITIONAL FORMATTING!
- Re: Continue to have issue with array in Subtotals automation
- Excel RTD,SQL Server and persisting range
- Re: Setting Column Widths
- Continue to have issue with array in Subtotals automation
- Re: pivot table using vba problem
- Re: Specific Macros
- Re: Specific Macros
- Re: Is there a faster way
- Replace value in cell with value from a table/array?
- Re: Editing MS Project File from Excel VBA
- Re: Excel 2003 - Macro for Deleting Rows
- Re: Specific Macros
- Re: Userform to show and update data problem
- Re: find string in web page
- Re: Is there a faster way
- Re: Excel Converter Using C++
- Re: Specific Macros
- Re: Passing a value from one userform to another (multiple) form
- Re: Is there a faster way
- Re: Error Trapping Issue? WorksheetFuntion.Search
- Re: Printing envelopes based on Excel table contents
- Re: Setting Column Widths
- Re: Lock formatting
- Re: Printing envelopes based on Excel table contents
- Re: Printing envelopes based on Excel table contents
- Printing envelopes based on Excel table contents
- Re: Can Excel modify data in a Query?
- Re: Excel 2003 - Macro for Deleting Rows
- Re: Try Again... copy a row if another worksheet cell <>null
- Re: Excel 2003 - Macro for Deleting Rows
- Re: Excel 2003 - Macro for Deleting Rows
- Workbook Sharing
- Re: Editing MS Project File from Excel VBA
- Re: Out of Context
- Re: Excel 2003 - Macro for Deleting Rows
- Code for combining text and deleting row for c10 thru entire range
- Out of Context
- Userform to show and update data problem
- Re: Passing a value from one userform to another (multiple) form
- Re: Userform Question
- Re: Can I format cell to autonumber everytime I enter spreadsheet?
- Re: Userform Question
- Re: Speed test results if interested
- Re: Error renaming Worksheets when addin is loaded
- Re: Error renaming Worksheets when addin is loaded
- RE: Help with a form
- RE: Help with a form
- RE: Help with a form
- Re: macro to copy to another workbook
- Re: Excel 2003 - Macro for Deleting Rows
- Re: Excel 2003 - Macro for Deleting Rows
- Re: Finding the difference...
- Re: Is there a faster way
- Re: Finding the difference...
- Re: Userform Question
- Finding the difference...
- Re: Excel 2003 - Macro for Deleting Rows
- Re: Excel 2003 - Macro for Deleting Rows
- Re: find string in web page
- Excel 2003 - Macro for Deleting Rows
- Re: How to copy VBA array into range of cells?
- Editing MS Project File from Excel VBA
- From: andrew . littlefield
- Re: Excel 2003 - Macro for deleting rows
- RE: Setting Column Widths
- Re: Is there a faster way
- Re: Crashing Bug in Solver.XLAM for Excel 2007???
- Try Again... copy a row if another worksheet cell <>null
- Do function on worksheet open
- Re: Is there a faster way
- Re: Excel 2003 - Macro for deleting rows
- Re: Correct me if I'm wrong but...
- Re: Excel 2003 - Macro for deleting rows
- Re: Userform and Worksheets
- Re: Is there a faster way
- Re: Convert text to numbers
- Re: Convert text to numbers
- RE: Convert to Number
- find string in web page
- Re: Excel 2003 - Macro for deleting rows
- Re: How to copy VBA array into range of cells?
- Re: sql stmt issue
- RE: Copy formula if other worksheet cell <> null
- Re: Make sense of Arrays after Transpose
- RE: Pivottable filter
- Convert text to numbers
- Search 1 worksheet then another for data in large workbook
- Re: Workbook name - got it at last
- Re: Excel 2003 - Macro for deleting rows
- Re: Excel 2003 - Macro for deleting rows
- Re: macro to hide # of columns based on value
- RE: This used to work...
- RE: Controlling cursor w/ macro
- RE: Custom Menu
- Re: Make sense of Arrays after Transpose
- Error Trapping Issue? WorksheetFuntion.Search
- Re: copy data from worksheet in folder a to worksheet in folder b
- Re: How to Capture log of Activities on each worksheet of a Workbo
- Re: VBA Commands
- RE: Pivottable filter
- Unwanted Sub Exit, Ws in page break preview View
- Re: How to copy VBA array into range of cells?
- Pivottable filter
- RE: Find value, perform function, search for next value
- Re: Need some VBA help
- Re: Excel 2003 - Macro for deleting rows
- Excel 2003 - Macro for deleting rows
- RE: Find value, perform function, search for next value
- Re: copy data from worksheet in folder a to worksheet in folder b
- Re: Find value, perform function, search for next value
- RE: Find value, perform function, search for next value
- Re: Is there a faster way
- Re: Linking Forms across seperate addins
- vba/macro recognizing other worksheets open
- Re: Excel VBA Bug
- Re: How to list items meeting conditions?
- Re: How to Capture log of Activities on each worksheet of a Workbo
- Re: Is there a faster way
- RE: Question for Userform Excel Wrksht vs Access DB
- RE: Is there a faster way
- Excel VBA Bug
- Re: Linking Forms across seperate addins
- RE: Find value, perform function, search for next value
- Re: UDF with user help
- Re: Passing worksheet as an argument
- Re: ReDim Preserve on 2D Array not working
- Re: Make sense of Arrays after Transpose
- Re: If problem...
- Re: macro to copy to another workbook
- Re: UDF with user help
- Re: macro to copy entire workbook to another.
- Re: Microsoft Office 2007 Compatibility Pack troubles
- How to copy VBA array into range of cells?
- Re: UDF with user help
- Re: Ambiguous Name detected?
- RE: Ambiguous Name detected?
- Speed test results if interested
- RE: ReDim Preserve on 2D Array not working
- Ambiguous Name detected?
- Re: How to list items meeting conditions?
- Re: Crashing Bug in Solver.XLAM for Excel 2007???
- Re: Crashing Bug in Solver.XLAM for Excel 2007???
- Re: ReDim Preserve on 2D Array not working
- Re: Automatically close file
- Automatically close file
- Range("A1").Interior.ColorIndex=xyz does not work
- Re: ReDim Preserve on 2D Array not working
- ReDim Preserve on 2D Array not working
- Re: Error handling on Workbooks.Open
- GOT IT Re: how to call statistic / analysis funtions from vba (Histogramm)
- RE: Sheets.copy problem
- Re: Make sense of Arrays after Transpose
- RE: Match excel spread sheet with macro
- Re: Crashing Bug in Solver.XLAM for Excel 2007???
- RE: Sheets.copy problem
- From: jln via OfficeKB.com
- Re: Array help
- Re: Crashing Bug in Solver.XLAM for Excel 2007???
- Re: Newbie attempting VBA Scripting
- RE: Sheets.copy problem
- Re: UDF with user help
- RE: NumFormat problems when exchanging dot to comma
- RE: Sheets.copy problem
- From: jln via OfficeKB.com
- RE: NumFormat problems when exchanging dot to comma
- RE: Custom Menu
- Re: Microsoft Office 2007 Compatibility Pack troubles
- RE: Sheets.copy problem
- Re: Linking Forms across seperate addins
- RE: Sheets.copy problem
- From: jln via OfficeKB.com
- Re: UDF with user help
- Sheets.copy problem
- From: jln via OfficeKB.com
- Re: How to list items meeting conditions?
- Re: Range Prompt
- How to list items meeting conditions?
- Re: Two decimals
- Re: Delete non weekdays
- Copy from one work to another
- From: jln via OfficeKB.com
- Re: selecting range over multiple sheets
- Re: Hide/Unhide Sheet using VB
- Re: Send multiple cell values to multiple cells
- Two decimals
- RE: Auto sort
- Re: Need some VBA help
- RE: Delete non weekdays
- RE: NumFormat problems when exchanging dot to comma
- Re: How to prevent change Numeric value to date format ?
- Re: Delete non weekdays
- Copy a part of worksheet with active x elements
- Re: HOW TO IMPROVE PERFORMANCE FOR VB
- Re: Aggregation on Column Value (groub by logic)
- Re: sub-range
- Re: Is there a faster way
- RE: Send multiple cell values to multiple cells
- RE: automatically hiding a cell when value changes
- Send multiple cell values to multiple cells
- Re: slow .Clear in 2007
- Re: UNDO
- Re: Function or sub (add-in)
- From: Rick Rothstein \(MVP - VB\)
- Re: setting label properties
- Re: Custom Menu
- Re: Function or sub (add-in)
- Re: Function or sub (add-in)
- From: Rick Rothstein \(MVP - VB\)
- Re: How to find out if an excel spreadsheet is already open
- Re: How to control recalculation in VBA?
- Can multiple selection available to copy to new Workbooks ?
- Last saved by
- Re: How to prevent change Numeric value to date format ?
- Re: Double Click on cell to goto - Help needed please
- Range Prompt
- Re: Double Click on cell to goto - Help needed please
- Re: Double Click on cell to goto - Help needed please
- Re: Syntax again for DA
- Double Click on cell to goto - Help needed please
- Re: setting label properties
- How to find out if an excel spreadsheet is already open
- Re: How to Capture log of Activities on each worksheet of a Workbo
- RE: Programming Macro - Sheet Specific
- Re: Copy a part of worksheet with active x elements
- Re: Can I draw an arrow at form using word macro?
- RE: How to prevent change Numeric value to date format ?
- Re: Programming Macro - Sheet Specific
- Re: Macro unexpectedly jumps to other macros and functions Options
- Can I draw an arrow at form using word macro?
- RE: Create Output CSV File Worksheet
- RE: Programming Macro - Sheet Specific
- How to prevent change Numeric value to date format ?
- How to control recalculation in VBA?
- Re: Add Column Names to VBA script
- Re: How to get Properties Generate tab Location value
- Re: Sort Column
- Re: Sort Column
- Re: Filter Macro that can work for any column/active cell
- RE: Custom Menu
- RE: Populating dates
- RE: Match excel spread sheet with macro
- Re: Protect Selected Sheets
- RE: Populating dates
- Re: Filter Macro that can work for any column/active cell
- Protect Selected Sheets
- Re: Sort Column
- Re: adding a page number in a cell (Print Multiple Page Worksheet
- Microsoft Office 2007 Compatibility Pack troubles
- Re: Entering a Sum Formula in VBA with variables
- Re: Make sense of Arrays after Transpose
- Re: Need some VBA help
- Re: Convert column data to trim all characters and leave the last 6
- RE: Find doesn't find...what the !@#$
- Re: Entering a Sum Formula in VBA with variables
- Re: macro to hide # of columns based on value
- Re: Entering a Sum Formula in VBA with variables
- Populating dates
- A Macro to change various cells with a condition
- Re: Code for dealing with #REF
- Find doesn't find...what the !@#$
- Re: Code for Subtotals
- Convert column data to trim all characters and leave the last 6
- Add Column Names to VBA script
- RE: Copy Contents From Worksheet to Another Worksheet
- Make sense of Arrays after Transpose
- Re: Sub add-ain
- RE: Create Output CSV File Worksheet
- Re: how to recycle through cells in a selected range
- Re: adding a page number in a cell (Print Multiple Page Worksheet
- Re: How will we create UDF's on 64 bit OS after support for VBA is
- Re: Code for dealing with #REF
- Re: Better way to find matches across multiple cells?
- RE: RefreshAll pivot tables but query
- Re: Conditional Formatting
- Re: Code for dealing with #REF
- Re: Code execution has been interrupted
- RE: Create Output CSV File Worksheet
- Re: Workbook name did not work
- RE: Create Output CSV File Worksheet
- Re: summing by color
- RE: summing by color
- Re: summing by color
- Re: Newbie attempting VBA Scripting
- Conditional Formatting
- Re: summing by color
- Re: Input box password
- Re: Sub add-ain
- Re: Workbook name
- Re: Workbook name
- RE: Check if cell content changed
- RE: Create Output CSV File Worksheet
- automatically hiding a cell when value changes
- Re: Find text string within a named range
- Re: Need some VBA help
- RE: Help with "Doubleclick event"
- Re: Customize Addin
- Re: Find text string within a named range
- Re: ActiveWorksheet vs Worksheets.Item(1)
- Re: fomula comes to next row on click
- Re: PivotTable from a ADODB.Recordset ?
- Re: Need some VBA help
- Re: Excel hangs on Save As
- Re: Code execution has been interrupted
- From: ryan . fitzpatrick3
- fomula comes to next row on click
- RE: Help with VBA loop, lookup and calculate problem
- Re: Find text string within a named range
- when exiting combobox, this code moves the selected cell down two rows instead of one
- Re: Excel hangs on Save As
- RE: Help with VBA loop, lookup and calculate problem
- Re: Need some VBA help
- Re: Add-in
- Re: ActiveWorksheet vs Worksheets.Item(1)
- Re: Find text string within a named range
- Re: Loose formating of linked cells
- Multithreading, of a sort. Or is it interrupts?
- RE: Concatenate unique items
- RE: Help with VBA loop, lookup and calculate problem
- RE: Code execution has been interrupted
- Re: macro to copy to another workbook
- Re: ActiveWorksheet vs Worksheets.Item(1)
- RE: Help with VBA loop, lookup and calculate problem
- Re: How to Capture log of Activities on each worksheet of a Workbook
- Re: adding a page number in a cell (Print Multiple Page Worksheet with Page Number in a Cell)
- Customize Addin
- Re: Workbook name
- Re: adding a page number in a cell (Print Multiple Page Worksheet with Page Number in a Cell)
- RE: Help with VBA loop, lookup and calculate problem
- Code execution has been interrupted
- From: ryan . fitzpatrick3
- Re: ActiveWorksheet vs Worksheets.Item(1)
- Re: how to call statistic funtions from vba (Histogramm)
- Loose formating of linked cells
- RE: Help with VBA loop, lookup and calculate problem
- RE: Atoumate the counting of Net Finance
- RE: Help with VBA loop, lookup and calculate problem
- RE: Help with VBA loop, lookup and calculate problem
- RE: Help with VBA loop, lookup and calculate problem
- ActiveWorksheet vs Worksheets.Item(1)
- Workbook name
- Re: Email - Outmail - From
- Re: Failed Comparison... why?
- Re: Find text string within a named range
- RE: flash cell colours from white to red and back again
- RE: Help with VBA loop, lookup and calculate problem
- RE: flash cell colours from white to red and back again
- Re: how to call statistic funtions from vba (Histogramm)
- RE: flash cell colours from white to red and back again
- Re: PivotTable from a ADODB.Recordset ?
- Re: Failed Comparison... why?
- RE: flash cell colours from white to red and back again
- how to call statistic funtions from vba (Histogramm)
- RE: flash cell colours from white to red and back again
- RE: flash cell colours from white to red and back again
- Re: UserName Property
- Re: Cell Reference with Hyperlinks
- Re: Checking if worksheet exsits
- Atoumate the counting of Net Finance
- RE: Open File, pause macro until file is selected
- RE: flash cell colours from white to red and back again
- RE: Email - Outmail - From
- Net Financing
- Re: Get count of active (non-empty) rows and columns
- Macro unexpectedly jumps to other macros and functions Options
- RE: Statusbar
- Cannot set the row property
- RE: Statusbar
- help me excel coding
- Re: Passing a value from one userform to another (multiple) form
- Re: 2003: Slow Response on ClearContents
- Indian SUCKS SUCKS SUCKS
- RE: Concatenate unique items
- Re: closing excel file through code
- Re: closing excel file through code
- Re: Entering a Sum Formula in VBA with variables
- Re: How to get Properties Generate tab Location value
- Re: Add-in
- Re: Complie error
- Re: Complie error
- Re: Retrieving List of Macros in Workbook
- How to get Properties Generate tab Location value
- Re: Code for Subtotals
- Complie error
- Re: closing excel file through code
- How to search for ceratin word in a web site using excel macro
- vanishing buttons
- Email - Outmail - From
- Re: Macro to record history of Excel files
- Re: Finding xla
- Re: Auto sort
- closing excel file through code
- Macro to record history of Excel files
- From: Excel_VBA programmer
- RE: Concatenate unique items
- Re: adding a page number in a cell
- commands have been grayed out
- pivot table using vba problem
- RE: PivotTable from a ADODB.Recordset ?
- RE: Concatenate unique items
- RE: Best way to find repeated matches?
- Re: Retrieving List of Macros in Workbook
- Re: From variable to excel constant
- Re: Finding xla
- Re: How will we create UDF's on 64 bit OS after support for VBA is
- Re: Copy range from one workbook to another
- Re: Data Validation Macro
- Finding xla
- Re: Data Validation Macro
- Re: How will we create UDF's on 64 bit OS after support for VBA is
- RE: Concatenate unique items
- Re: UserName Property
- Re: How to generate random number sets
- How to generate random number sets
- Re: how to get the value of a text box in a sub or function
- Re: Data Validation Macro
- Re: MenuMaker
- Re: Better way to find matches across multiple cells?
- Re: Data Validation Macro
- Re: MenuMaker
- Re: Better way to find matches across multiple cells?
- Re: Failed Comparison... why?
- Data Validation Macro
- RE: Concatenate unique items
- RE: PivotTable from a ADODB.Recordset ?
- RE: Concatenate unique items
- Re: Data entry commitment without hitting Enter key
- RE: PivotTable from a ADODB.Recordset ?
- RE: Statusbar
- RE: Concatenate unique items
- Re: Code for dealing with #REF
- Can Excel modify data in a Query?
- Re: Code for Subtotals
- RE: SQL Syntax Error in Query
- Better way to find matches across multiple cells?
- Re: UserName Property
- Best way to find repeated matches?
- Re: Failed Comparison... why?
- Re: Failed Comparison... why?
- Re: Failed Comparison... why?
- Re: filename as variable
- Re: listing a column in reverse order
- Re: Failed Comparison... why?
- RE: Find File
- From: jln via OfficeKB.com
- Re: Date on UserForm
- Re: "Unable to get the Hlookup property" VBA
- Cell Reference with Hyperlinks
- RE: listing a column in reverse order
- Re: Newbie attempting VBA Scripting
- Re: macro to copy to another workbook
- RE: summary of values for a period of time
- Re: Newbie attempting VBA Scripting
- RE: Find File
- From: jln via OfficeKB.com
- Re: Newbie attempting VBA Scripting
- Statusbar
- Re: Convert timespan d:hh:mm:ss to number
- Find File
- From: jln via OfficeKB.com
- Re: Getting names of files in subdirectories
- Re: slow .Clear in 2007
- Using ADO with Pivot Tables
- Re: converting numbers
- RE: Dynamically declare and populate variables
- Re: Locating end of used range- not returning expected value
- RE: Dynamically declare and populate variables
- Re: Locating end of used range- not returning expected value
- Re: Failed Comparison... why?
- RE: Locating end of used range- not returning expected value
- Re: Locating end of used range- not returning expected value
- filename as variable
- Re: Userform Multipage
- RE: Dynamically declare and populate variables
- Re: Manipulating Arrays
- RE: Getting names of files in subdirectories
- RE: Locating end of used range- not returning expected value
- Re: macro to copy to another workbook
- Locating end of used range- not returning expected value (additional info)
- RE: Locating end of used range- not returning expected value
- Re: How to Capture log of Activities on each worksheet of a Workbook
- RE: UserName Property
- Re: Lookup function, but then a bit complicater
- Locating end of used range- not returning expected value
- Getting names of files in subdirectories
- Re: Macro Autofill Question
- Re: Save only a range from an excel file to another
- Re: Insert comment in a cell Excel
- RE: Dynamically declare and populate variables
- Re: Substitute worksheet function considered harmful: can create unopenable workbooks with cell values greater than 32k
- Re: Substitute worksheet function considered harmful: can create unopenable workbooks with cell values greater than 32k
- Re: Manipulating Arrays
- RE: Dynamically declare and populate variables
- RE: UserName Property
- Re: Save only a range from an excel file to another
- Re: Break Mode
- Re: Save only a range from an excel file to another
- Re: RANGE SELECTION
- Re: Send data from Excel in email from specific email address
- Re: slow .Clear in 2007
- RE: Adding a named formula in VBA
- Re: slow .Clear in 2007
- Re: Controls on Chart Forget assigned Macros.
- Re: macro to copy entire workbook to another.
- Re: MOVING WITH A RANGE-TAB
- Re: UserName Property
- Re: Save only a range from an excel file to another
- Re: phantom 'Task Pane' problem
- Re: UserName Property
- RE: Adding a named formula in VBA
- RE: DV Issues with IF statements. Call function instead?
- RE: Adding a named formula in VBA
- Re: UserName Property
- Re: UserName Property
- Re: phantom 'Task Pane' problem
- Re: Save only a range from an excel file to another
- Re: converting numbers
- Macro Autofill Question
- Save only a range from an excel file to another
- Re: Failed Comparison... why?
- Re: Failed Comparison... why?
- RE: DV Issues with IF statements. Call function instead?
- Re: Failed Comparison... why?
- Re: copy data from worksheet in folder a to worksheet in folder b
- Re: Find last row with data in set range
- Re: Code Execution Has Been Interrupted
- Re: Find last row with data in set range
- RE: SQL Syntax Error in Query
- Re: Find last row with data in set range
- phantom 'Task Pane' problem
- Re: project protecting
- Re: Find last row with data in set range
- Re: Dynamic selection of a range
- Re: Loop Within a Loop Problem
- Re: Reference workbook name to cell reference
- Re: Putting a variable value into the Clipboard
- Re: Find last row with data in set range
- SQL Syntax Error in Query
- Re: Controls on Chart Forget assigned Macros.
- Re: Textbox1.Value Question
- RE: DV Issues with IF statements. Call function instead?
- Re: Find last row with data in set range
- Re: project protecting
- RE: DV Issues with IF statements. Call function instead?
- Re: How will we create UDF's on 64 bit OS after support for VBA is dro
- Reference workbook name to cell reference
- Re: project protecting
- RE: DV Issues with IF statements. Call function instead?
- Re: Find last row with data in set range
- RE: DV Issues with IF statements. Call function instead?
- Re: Textbox1.Value Question
- Re: Failed Comparison... why?
- RE: DV Issues with IF statements. Call function instead?
- RE: DV Issues with IF statements. Call function instead?
- Re: Copy embedded chart with updated data request
- Re: Find last row with data in set range
- Textbox1.Value Question
- Re: Copy embedded chart with updated data request
- Re: Error 1004
- Re: Putting a variable value into the Clipboard
- Re: Checking if worksheet exsits
- Find last row with data in set range
- Re: Code Execution Has Been Interrupted
- RE: LAST value of loop to be a variable
- Data entry commitment without hitting Enter key
- Re: Dynamic selection of a range
- Re: Code for Subtotals
- Re: Syntax again for DA
- Re: Retrieving List of Macros in Workbook
- Re: Lookup function, but then a bit complicater
- Copy embedded chart with updated data request
- Re: Delet certain row in a sheets in workbook
- Re: Userform Multipage
- command bar
- Re: SQL on Column with Text and Numbers
- Re: Lookup function, but then a bit complicater
- Send data from Excel in email from specific email address
- Re: Command Button Naming
- Excel to Powerpoint - copy/paste text box
- Re: Command Button Naming
- Re: POSITION OF ErrorHandler?
- Re: POSITION OF ErrorHandler?
- Re: "Unable to get the Hlookup property" VBA
- Re: adding a page number in a cell
- Putting a variable value into the Clipboard
- Re: Failed Comparison... why?
- Re: "Unable to get the Hlookup property" VBA
- Re: How could I deal with the concurrency in my project ?
- Re: Slow Opening Excel Workbook from Access
- Ideas for a menu
- RE: How do I use check boxes to determine which worksheets to prin
- RE: How do I use check boxes to determine which worksheets to prin
- Re: Add additional logic to my code
- Re: Sheets.Copy breaking the links
- Re: Multiple Excel File Import
- Re: Code for Subtotals
- Sheets.Copy breaking the links
- Re: Code for Subtotals
- Re: Syntax again for DA
- Re: Using a variable as an argument
- Re: How to write a macro to jump from 1 input field to the next?
- Re: Two Question
- Re: copy method problem
- Re: Splitting variables with a comma error with slashes
- Re: How will we create UDF's on 64 bit OS after support for VBA is dro
- Re: "Unable to get the Hlookup property" VBA
- Re: Failed Comparison... why?
- Re: "Unable to get the Hlookup property" VBA
- Re: Slow Opening Excel Workbook from Access
- copy method problem
- Re: set range error in add sheet
- Re: copy data from worksheet in folder a to worksheet in folder b
- Wait for refresh/calc before proceeding
- Tab to and from combobox
- Re: Using Countif on Array
- How will we create UDF's on 64 bit OS after support for VBA is dro
- excel sheet opening as web page
- Re: How to Define and Use a Dynamic Array
- Re: "Unable to get the Hlookup property" VBA
- Re: Splitting variables with a comma error with slashes
- Re: XL 2003 / IE 6.00.2900 - Macro menu unavailable
- Re: naming a tab based on a cells value
- naming a tab based on a cells value
- Re: Counting from one column by specific identifier
- Re: Counting from one column by specific identifier
- Failed Comparison... why?
- Re: Checking if worksheet exsits
- RE: Checking if worksheet exsits
- Re: Find an exact word in a cell with many words
- RE: Code Execution Has Been Interrupted
- Checking if worksheet exsits
- Re: i think there is a problem with my loop
- Re: Using Worksheet_change module in protected workbook.
- Re: Modifying chart source range using variable
- Re: Easy question, I think
- Re: Retrieving List of Macros in Workbook
- Using Countif on Array
- Re: Find an exact word in a cell with many words
- Re: empty
- Counting a subset
- Re: empty
- Re: Slow Opening Excel Workbook from Access
- looking for a Excel consultant
- i think there is a problem with my loop
- Re: empty
- Re: Splitting variables with a comma error with slashes
- empty
- Code Execution Has Been Interrupted
- Splitting variables with a comma error with slashes
- Re: Find an exact word in a cell with many words
- RE: help with code
- Re: Find an exact word in a cell with many words
- Re: Syntax again for DA
- RE: help with code
- Re: help with code
- RE: how do I create a macro that will activate other macros?
- Re: Userform Initialize
- Re: help with code
- Re: Identify number of numeric sets in a long string of numbers
- Re: Additional controls in Office 2007
- Re: fx button shows ... for a UDF
- Re: Can't see macros in .xla file
- Re: copy data from worksheet in folder a to worksheet in folder b
- RE: Set focus on field not on active page of a multipage
- Re: Retrieving List of Macros in Workbook
- Re: fx button shows ... for a UDF
- Re: set range error in add sheet
- Re: manual/auto calculation toggle button
- Re: Array problem
- SQL on Column with Text and Numbers
- From: Ed_P via OfficeKB.com
- Re: Identify number of numeric sets in a long string of numbers
- Re: Array problem
- RE: macro for copying between Workbooks
- Re: Identify number of numeric sets in a long string of numbers
- RE: How to Define and Use a Dynamic Array
- RE: How to Define and Use a Dynamic Array
- VB code to copy and past a row or set of cells...
- Retrieving List of Macros in Workbook
- SolverSolve function exits abnormally
- Re: Accessing individual items in an array returned by a function
- RE: How to Define and Use a Dynamic Array
- Accessing individual items in an array returned by a function
- Re: office 3 calender
- Excel error connecting to sqlserver using ADODB, but can thru Data menu
- Re: Lookup function, but then a bit complicater
- Re: Using Worksheet_change module in protected workbook.
- Re: project protecting
- Writing tabular data from excel to sql server using VBA
- Re: Subtotal with more than one Function
- Array problem
- Re: Size comment box
- Re: Lookup function, but then a bit complicater
- Re: Further to my last thread - Check for worksheet in a closed file
- Re: Lookup function, but then a bit complicater
- Re: vlookup
- Re: SENDKEYS COMMAND
- Re: multipage
- Re: Further to my last thread - Check for worksheet in a closed file
- Re: Controls on Chart Forget assigned Macros.
- Re: Help with code please
- RE: macro for copying between Workbooks
- Re: Help with code please
- Lookup function, but then a bit complicater
- Re: Add-in - add a custom function to a custom group.
- Further to my last thread - Check for worksheet in a closed file
- Help with code please
- Re: Identify number of numeric sets in a long string of numbers
- Add-in - add a custom function to a custom group.
- Re: Subtotal with more than one Function
- Setup your VS debugging environment for a COM add-in (Excel 2003)
- Re: How to parse UDF arguments? (separators are localized)
- RE: use the range value from a cell to update the cell with data
- Can't see macros in .xla file
- RE: use the range value from a cell to update the cell with data
- Re: Add additional logic to my code
- Re: Custom commandbar (1 works, 1 doesn't)
- Re: Printing
- Re: Custom commandbar (1 works, 1 doesn't)
- Printing
- Re: How to parse UDF arguments? (separators are localized)
- Re: Problem with varaible dates in SQL query
- Re: How to parse UDF arguments? (separators are localized)
- Re: coping a entire tab to a new tab
- How to parse UDF arguments? (separators are localized)
- Re: Identify number of numeric sets in a long string of numbers
- RE: coping a entire tab to a new tab
- Re: Userform Initialize
- Re: Syntax again for DA
- Re: Subtotal with more than one Function
- Insert Blank row at change in a given Column
- Re: SENDKEYS COMMAND
- Re: Syntax again for DA
- Re: coping a entire tab to a new tab
- Subtotal with more than one Function
- Re: Automation Add In, functions parameters as Range
- Re: Identify number of numeric sets in a long string of numbers
- Problem loading DLL: Error
- Re: Syntax again for DA
- Re: Controls on Chart Forget assigned Macros.
- Re: EAN-13 checksum
- Re: Code for Subtotals
- Re: Command Button Naming
- RE: Link input cells on user form to macro
- Syntax again for DA
- Re: Wanna earn Money very easy ??
- Wanna earn Money very easy ??
- From: 7thsense . solutions
- Re: Next and Back Buttons
- Re: Automation Add In, functions parameters as Range
- Re: Workbook_BeforeSave behaviour
- Re: Userform Initialize
- Re: Built-in Commandbar, can't find the right one
- Re: XL 2003 / IE 6.00.2900 - Macro menu unavailable
- RE: Link input cells on user form to macro
- Re: MACRO in a Loop Problem
- Re: Custom commandbar (1 works, 1 doesn't)
- Re: Automation Add In, functions parameters as Range
- Re: How could I deal with the concurrency in my project ?
- Re: How could I deal with the concurrency in my project ?
- Re: Add additional logic to my code
- Re: Custom commandbar (1 works, 1 doesn't)
- Re: Identify number of numeric sets in a long string of numbers
- Re: Macro for "Next" Button on User Form?
- Re: Help pLease... Creating a Usage Log
- Re: Add additional logic to my code
- Macro for "Next" Button on User Form?
- RE: If and vlookup in macro
- Help pLease... Creating a Usage Log
- RE: Link input cells on user form to macro
- Re: Autofilter
- RE: Built-in Commandbar, can't find the right one
- Re: Memory problem: Am I hitting the 64K segment boundary?
- Re: Find an exact word in a cell with many words
- Re: Custom commandbar (1 works, 1 doesn't)
- Re: Named ranges in the VBE
- Re: Code to auto update a footer
- Re: Question on User Forms and Command Buttons
- Re: Custom commandbar (1 works, 1 doesn't)
- Re: set range error in add sheet
- Re: set range error in add sheet
- RE: Link input cells on user form to macro
- RE: Loop in a Macro
- RE: Loop in a Macro
- RE: Link input cells on user form to macro
- RE: If/Then Macro For Each Visible Worksheet
- Searching and Then Copy Cell to word
- RE: Conditonal listbox
- Re: Searching only Column A
- If/Then Macro For Each Visible Worksheet
- Re: Searching only Column A
- Re: Searching only Column A
- Re: Undo a scroll action
- Re: Searching only Column A
- Re: Undo a scroll action
- Conditonal listbox
- Loop in a Macro
- Re: Find an exact word in a cell with many words
- set range error in add sheet
- Re: VB6 and Excel question
- Re: VB protect sheet but allow certain options
- Re: Searching only Column A
- RE: Searching only Column A
- RE: How to Synchronize page fields for two or more than 2 pivot tables
- Re: VB protect sheet but allow certain options
- Re: Searching only Column A
- Re: Run-time error '1004'
- Re: Counting Unique Values
- Re: conditional list boxes
- RE: use the range value from a cell to update the cell with data
- Re: conditional list boxes
- Re: Question on User Forms and Command Buttons
- Automation Add In, functions parameters as Range
- Re: VB6 and Excel question
- RE: Built-in Commandbar, can't find the right one
- Re: Problem with varaible dates in SQL query
- Re: Question on User Forms and Command Buttons
- Re: user Forms Question
- How to Synchronize page fields for two or more than 2 pivot tables?
- conditional list boxes
- Built-in Commandbar, can't find the right one
- Searching only Column A
- Re: VB6 and Excel question
- Custom commandbar (1 works, 1 doesn't)
- RE: Excel Formula
- Re: Find an exact word in a cell with many words
- VB6 and Excel question
- Ensure macros enabled - C. Pearson's sheet visibility method
- From: Horatio J. Bilge, Jr.
- RE: Add additional logic to my code
- Unwanted Hyperlink
- Re: Check for worksheet in closed workbook
- Worksheet copy to another workbook
- Re: Autofill until last cell in a row
- Re: Check for worksheet in closed workbook
- RE: If and vlookup in macro
- Re: slow .Clear in 2007
- Re: Check for worksheet in closed workbook
- Re: Question on User Forms and Command Buttons
- slow .Clear in 2007
- SetLinkOnData only fires once?
- Add additional logic to my code
- Re: Using a 2 dimensional string array variable like a lookup function
- Re: Check for worksheet in closed workbook
- Re: multipage
- RE: Date reformat and export
- Re: UserForm.Show error
- From: Horatio J. Bilge, Jr.
- Autofill until last cell in a row
- Re: Date search and date extract
- Re: Going To The Last Empty Row and Pasting Special (Values).
- RE: Date reformat and export
- Date reformat and export
- Re: Controls on Chart Forget assigned Macros.
- Re: Automatic Cell Locking
- Re: Automatic Cell Locking
- Re: Double clicking on a pivot table
- Re: Gantt Chart with VBA
- Re: How can I calculate the minimum value of a VBA array?
- Re: How can I calculate the minimum value of a VBA array?
- Re: switch the "scroll" led with vba
- Automatic Cell Locking
- Re: Going To The Last Empty Row and Pasting Special (Values).
- Formatting Problem
- Re: How do a sort a multidimensional array(1000,2) in Excel-VBA?
- RE: Doing nothing when pressing Cancel on InputBox
- Re: Doing nothing when pressing Cancel on InputBox
- Re: Password security problem: view of the hiden worksheet in xlsm and xlsx file !?
- Re: Date search and date extract
- Re: Date search and date extract
- Re: How do a sort a multidimensional array(1000,2) in Excel-VBA?
- Re: Memory problem: Am I hitting the 64K segment boundary?
- Re: Question on User Forms and Command Buttons
- Re: How can I calculate the minimum value of a VBA array?
- Re: Going To The Last Empty Row and Pasting Special (Values).
- Re: Date search and date extract
- Re: Going To The Last Empty Row and Pasting Special (Values).
- Re: Multiple Excel File Import
- RE: How can I calculate the minimum value of a VBA array?
- Re: Value Returned in Message Box Q
- Date search and date extract
- Double clicking on a pivot table
- Re: CAN files be accessed with a macro when closed
- How could I deal with the concurrency in my project ?
- Re: Going To The Last Empty Row and Pasting Special (Values).
- Re: MACRO in a Loop Problem
- Re: Question on User Forms and Command Buttons
- How can I calculate the minimum value of a VBA array?
- Re: Question on User Forms and Command Buttons
- Re: Slow Opening Excel Workbook from Access
- Re: Help with FOR LOOP and and Advance Filter
- RE: Slow Opening Excel Workbook from Access
- RE: Conditional Formatting using Dates but excluding weekends
- From: PRIV via OfficeKB.com
- Re: Counting Unique Values
- Re: Function cannot obtain cell values
- Re: Counting Unique Values
- Re: Help with FOR LOOP and and Advance Filter
- Function cannot obtain cell values
- Re: Help with FOR LOOP and and Advance Filter
- RE: Slow Opening Excel Workbook from Access
- RE: Slow Opening Excel Workbook from Access
- RE: How to Evaluate Values in the filter used range
- How to Evaluate Values in the filter used range
- Re: Suppressing ODBC Login Prompt
- Re: Need help with FOR NEXT LOOP
- Re: Need help with FOR NEXT LOOP
- Re: Need help with FOR NEXT LOOP
- Re: event integration
- Re: Need help with FOR NEXT LOOP
- Re: Update Sheet code using VBA - question for Chip Pearson
- Re: VB Import/Export CSV
- PivotTable with Server Page Field Leaves MS Query Application Window Open After Refresh.
- Re: File Properties
- Re: Add ins for outlook object 11.0
- Re: File Properties
- File Properties
- Re: Excel hangs on Save As
- Re: looping
- From: Rick Rothstein \(MVP - VB\)
- Re: Gantt Chart with VBA
- Re: event integration
- Re: VB Import/Export CSV
- Re: Value Returned in Message Box Q
- Re: Value Returned in Message Box Q
- Value Returned in Message Box Q
- macro
- Re: defined names in conditional-formatting don't work
- From: michelratipho@xxxxxxxx
- switch the "scroll" led with vba
- Re: defined names in conditional-formatting don't work
- Re: defined names in conditional-formatting don't work
- Re: Change CellA.
- Re: defined names in conditional-formatting don't work
- Re: defined names in conditional-formatting don't work
- Re: Memory problem: Am I hitting the 64K segment boundary?
- defined names in conditional-formatting don't work
- Re: Memory problem: Am I hitting the 64K segment boundary?
- Re: Update Sheet code using VBA - question for Chip Pearson
- RE: User Form and database
- Re: Memory problem: Am I hitting the 64K segment boundary?
- Re: Range to VLOOKUP as a Variable (range in another file)
- Re: Update Sheet code using VBA - question for Chip Pearson
- Re: Gantt Chart with VBA
- Re: Export VBA Modules
- Re: 2003: Slow Response on ClearContents
- Re: Gantt Chart with VBA
- Re: looping
- Re: Export VBA Modules
- Re: Run-time error '1004'
- Re: Getting a celldata from another excel worksheet
- RE: Change CellA.
- Export VBA Modules
- Re: event integration
- Change CellA.
- Re: Pop up Box that displays files sheets Q
- Re: Run-time error '1004'
- Re: Memory problem: Am I hitting the 64K segment boundary?
- Re: looping
- Re: looping
- Re: 2003: Slow Response on ClearContents
- Re: Excel XLL versus DLL
- Pop up Box that displays files sheets Q
- Re: filesystemobject
- Re: looping
- Re: looping
- Re: How to propagate xlErrNull back to Excel formula?
- Re: looping
- RE: Gantt Chart with VBA
- Re: Memory problem: Am I hitting the 64K segment boundary?
- Re: Range to VLOOKUP as a Variable (range in another file)
- Re: 2003: Slow Response on ClearContents
- Re: Deleting Part of a cell value
- Re: Relative adress in recored macro
- Re: Referencing worksheet
- Re: Range to VLOOKUP as a Variable (range in another file)
- Re: How to propagate xlErrNull back to Excel formula?
- Re: Select Case
- Re: Memory problem: Am I hitting the 64K segment boundary?
- VBE windows, zoom, ActiveX controls: Just one hit on memory, or many?
- Excel XLL versus DLL
- Re: Determine if clipboard is empty
- How to propagate xlErrNull back to Excel formula?
- RE: pLeAsE hELp! format function in excel visual basic editor
- Update Sheet code using VBA - question for Chip Pearson
- Re: Gantt Chart with VBA
- RE: pLeAsE hELp! format function in excel visual basic editor
- Re: event integration
- RE: Run-time error '1004'
- Re: Run-time error '1004'
- Gantt Chart with VBA
- RE: Link input cells on user form to macro
- Run-time error '1004'
- Re: percentages
- Re: activate/deactivate the scroll button by vba
- Re: Hide Macro from View Q
- Re: 2003: Slow Response on ClearContents
- Re: activate/deactivate the scroll button by vba
- Re: Relative adress in recored macro
- Re: Counting Unique Values
- RE: event integration
- Re: Please Help in this Compound Interest UDF
- RE: Link input cells on user form to macro
- Re: Hide Macro from View Q
- Re: Please Help in this Compound Interest UDF
- Please Help in this Compound Interest UDF
- RE: pLeAsE hELp! format function in excel visual basic editor
- Re: Hide Macro from View Q
- Re: Counting Unique Values
- Re: Hide Macro from View Q
- Re: VB Import/Export CSV
- RE: Looping
- Re: Make the charecters in a cell to equal a certain quanity
- From: Rick Rothstein \(MVP - VB\)
- Re: Make the charecters in a cell to equal a certain quanity
- Re: Counting Unique Values
- Re: Counting Unique Values
- Re: Counting Unique Values
- Re: filesystemobject
- Re: VB Import/Export CSV
- Re: 2003: Slow Response on ClearContents
- Re: Hide Macro from View Q
- Re: Suppressing ODBC Login Prompt
- Make the charecters in a cell to equal a certain quanity
- Hide Macro from View Q
- Deleting Part of a cell value
- How to access functions in .xll file using VBA?
- event integration
- Re: Have A1 in Top left corner of screen Q
- Re: Have A1 in Top left corner of screen Q
- Re: Finding words with capital letters and numbers in them
- Have A1 in Top left corner of screen Q
- Re: Code to Change Sheet Name
- Re: Code to Change Sheet Name
- Re: Code to Change Sheet Name
- Re: traveling days
- Re: Help! Jumping ListViews!
- Code to Change Sheet Name
- Re: Select Case
- Re: Memory problem: Am I hitting the 64K segment boundary?
- RE: Copy and paste only values
- Re: Copy and paste only values
- Re: Gotta be some more Efficient code
- RE: Copy tab ? times
- RE: Copy tab ? times
- Re: Gotta be some more Efficient code
- Re: percentages
- Re: Fomatting a row based on style of a cell within the same row
- Re: Gotta be some more Efficient code
- Re: Finding words with capital letters and numbers in them
- From: Rick Rothstein \(MVP - VB\)
- Re: Gotta be some more Efficient code
- Re: Merge Macro Excel 2007
- RE: Link input cells on user form to macro
- RE: activate/deactivate the scroll button by vba
- Re: VBA help
- Re: Select Case
- Re: Select Case
- Re: Select Case
- Re: Replace all non-operators from string
- Re: Chart Seriew Values
- Re: Select Case
- Re: Worbook increases in size, slows down too much
- Re: Worbook increases in size, slows down too much
- Re: VB Import/Export CSV
- Merge Macro Excel 2007
- From: Angel Rodriguez-Ayala
- Re: Newbie to VSTO basic question about what to buy
- Re: Personal.xls file with multiple Excel versions
- Re: Personal.xls file with multiple Excel versions
- Re: Replace all non-operators from string
- From: Rick Rothstein \(MVP - VB\)
- Re: Error with MarcoOptions method, add a new category
- Re: Personal.xls file with multiple Excel versions
- Looking for consultant to do some Excel macro programming
- Re: Error with MarcoOptions method, add a new category
- Re: Mirror Workbook
- Re: Personal.xls file with multiple Excel versions
- Re: Find and Replace in a Macro
- Re: Personal.xls file with multiple Excel versions
- Re: VB protect sheet but allow certain options
- Re: Undo a scroll action
- Re: Find and Replace in a Macro
- Re: Command Button disappears
- Re: Personal.xls file with multiple Excel versions
- Re: Find and Replace in a Macro
- Re: Undo a scroll action
- Re: Memory problem: Am I hitting the 64K segment boundary?
- Re: VB protect sheet but allow certain options
- Re: Macro to select a row that has max value and paste it in an em
- Find and Replace in a Macro
- manual/auto calculation toggle button
- Re: Easy question, I think
- Re: Easy question, I think
- Re: Command Button Naming
