microsoft.public.excel.programming
- Re: Date formatiing - using code to block months together
- RE: Putting named range into sub written by Tom Olgivy DataVal
- RE: VB in Excel
- Re: Putting named range into sub written by Tom Olgivy DataVal
- why the code make the error "Overflow"?
- RE: Hyperlink from the web
- RE: Putting named range into sub written by Tom Olgivy DataVal
- Re: Date formatiing - using code to block months together
- Problems with the Close statement not releasing the database fast enough.
- Re: Date formatiing - using code to block months together
- Re: VB in Excel
- Re: Sum a Range of Cells
- VB in Excel
- Sum a Range of Cells
- Re: Image Control - MouseMove Event
- Listbox + Multiselect + Pivots
- Hyperlink from the web
- Re: Evaluating (Splitting out) a formula
- RE: Evaluating (Splitting out) a formula
- RE: Evaluating (Splitting out) a formula
- RE: Customized function
- Customized function
- Check whether text in cell contains "?"
- RE: VC use Excel?
- Using vba coding to change text
- Re: Formatting cell poulated by User Defined Function
- Re: Could someone review my first Excel VBA program?
- RE: How to stop ## showing when cell contents too wide
- RE: How to stop ## showing when cell contents too wide
- How to stop ## showing when cell contents too wide
- RE: How to print the values of cells
- Re: getImage and VBA Callback
- Re: Precedents for formulas
- Re: Excel 2007 does NOT keep vb library references ...
- Re: Can I use Excel to measure time?
- web page entries
- Re: Formula for Last Cell in a Row with a Value
- Re: Formula for Last Cell in a Row with a Value
- RE: Can I use Excel to measure time?
- RE: what does the operator ":=" mean?
- RE: How to get all info on a specific name from diferent worksheets t
- Re: Help with spreadsheet
- Re: Making a cell a color using color numbers
- Re: Date formatiing - using code to block months together
- Re: Date formatiing - using code to block months together
- Re: Precedents for formulas
- Re: I need some changes in a code
- Re: Precedents for formulas
- Modification in Recorded Macro
- Re: excel 97, VB project unable to view in another comp
- Re: Precedents for formulas
- Re: Could someone review my first Excel VBA program?
- Check whether text in cell contains "?"
- Image Control - MouseMove Event
- Re: Precedents for formulas
- Re: For without Next error
- Re: maintaining a variable's value outside of a for loop...
- Re: UBound function does not work
- Re: UBound function does not work
- Re: Matching values in different columns/workbooks
- Re: Matching values in different columns/workbooks
- Re: Excel RTD - no topics on workbook open
- RE: UBound function does not work
- Matching values in different columns/workbooks
- UBound function does not work
- Re: Precedents for formulas
- Re: excel 97, VB project unable to view in another comp
- How to check one cell value to diffrent cell
- Could someone review my first Excel VBA program?
- Re: Precedents for formulas
- Re: Extract string w/ 7 characters
- Re: Precedents for formulas
- Re: Precedents for formulas
- Re: Precedents for formulas
- Re: Precedents for formulas
- Re: Find works sometimes
- Re: Array Copy - Paste Special Add Help
- Re: Working with a Loop
- Re: Precedents for formulas
- RE: Precedents for formulas
- Re: Working with a Loop
- Re: Working with a Loop
- Re: Working with a Loop
- Working with a Loop
- Re: Find works sometimes
- Formatting cell poulated by User Defined Function
- RE: Macro to select a variable range
- Re: Macro to select a variable range
- Breaking up an array into parts
- Re: Select and copy a variable range
- RE: Comments - display on dirty
- Re: maintaining a variable's value outside of a for loop...
- Re: maintaining a variable's value outside of a for loop...
- Re: Help with spreadsheet
- Re: Show amount of RAM and Windows OS?
- Do Loops
- Re: array
- seasonal adjustment
- Re: Creating a table of random numbers
- Re: array
- array
- Re: Creating a table of random numbers
- Blanked out on path
- Re: Bolding Subtotals
- RE: Variable passed to database query
- RE: Creating a table of random numbers
- Re: small function
- RE: macro to copy/paste print area
- Re: Copy & edit formula
- Re: Event rename worksheet
- Re: adding to Context Menus in Excel 2007
- Re: Merge various cells value in one row into one cell
- Re: Merge various cells value in one row into one cell
- adding to Context Menus in Excel 2007
- XLL Functions from Excel VBA
- RE: copy multiple worksheet data from 2 different workbook
- Re: Export contents of Immediate Window?
- Re: Need help on Evaluate function
- UK Based data format in ListBoxes
- Re: Saving the same workbook uniquely
- Re: Easy one - My string contains "
- Easy one - My string contains "
- copy multiple worksheet data from 2 different workbook
- Find cell text and replace three cell in same row
- Need help on Evaluate function
- Re: Using Solver to Minimise the Result of Another Iterative Routi
- Re: how to select rows after autofilter
- RE: how to select rows after autofilter
- Re: add tick in listbox
- computer programming
- Re: "Strange ComboBox Behavior?"
- Re: Printing
- Copy & edit formula
- Printing
- how to select rows after autofilter
- Re: Formula for Last Cell in a Row with a Value
- Re: Help with spreadsheet
- RE: Load & Access a UserForm ComboBox
- RE: macro to copy/paste print area
- Re: Need to make automatic macro changes
- Load & Access a UserForm ComboBox
- Re: Adding a Zero
- From: Rick Rothstein \(MVP - VB\)
- Re: Extract string w/ 7 characters
- Problem with ScaleType propert for Axis object
- Re: Adding a Zero
- Adding a Zero
- Re: Help with spreadsheet
- Re: ExecuteExcel4Macro Error
- Code to Quit App Doesn't Work
- Windows Task Bar
- RE: userform variables
- From: pjbur2005 via OfficeKB.com
- Re: Formula for Last Cell in a Row with a Value
- From: Rick Rothstein \(MVP - VB\)
- Re: Merge various cells value in one row into one cell
- Help with spreadsheet
- Formula for Last Cell in a Row with a Value
- Re: How do display a formula
- Re: Excel 2007 does NOT keep vb library references ...
- RE: Word to excel
- Re: Strange Open behaviour
- RE: Strange Open behaviour
- Re: Excel 2007 does NOT keep vb library references ...
- Fixed width parsing with trailing minus
- Re: Excel 2007 does NOT keep vb library references ...
- Re: Lottery combinations
- RE: Limiting possible responses on multiple User Forms
- Re: Designating Sheet vs Workbook When Doing Find/Replace
- RE: Export Excel data and scheduled task
- Re: Bringing data from multiple sheets to the summary page
- Re: Loop for formula on one sheet with reference from another shee
- Re: VBA code optimization - why using long instead of integer?
- Re: Need help with syntax
- From: Rick Rothstein \(MVP - VB\)
- Re: Need help with syntax
- From: Rick Rothstein \(MVP - VB\)
- Re: Creating a double lookup
- ExecuteExcel4Macro Error
- Re: Need help with syntax
- From: Rick Rothstein \(MVP - VB\)
- RE: ActiveSheet (IF statement)
- RE: localeSpecificCellName
- RE: ActiveSheet (IF statement)
- RE: Designating Sheet vs Workbook When Doing Find/Replace
- Re: Sub parameter passing
- clearing cells
- vbyesno msgbox
- Re: Comparing Object References
- Re: Importing Word text into Excel
- Sub parameter passing
- vlookup multiple docs & add results together
- Re: Getting an Daily Avarage
- VBA code optimization - why using long instead of integer?
- Re: small function
- Re: How do display a formula
- RE: Export contents of Immediate Window?
- RE: hyperlinks
- Re: Programatically Enable VBIDE Reference?
- RE: hyperlinks
- Macro for Comment box
- Export contents of Immediate Window?
- GetValue() Does Not Work
- RE: Capture InputBox vbCancel
- RE: unwanted design mode during macro exection
- SetItem and SetValue Does Not Work
- Re: reusing code
- RE: I want to update an excel 2007 file automatically in batch mode.
- RE: Check if file exist based on list
- Re: Import Data from Multiple Sources
- RE: Database query.
- RE: Copying columns (but cells should be copied in different order) be
- Re: VARIABLES AGAIN
- RE: How to run a video clip through macro.
- RE: VARIABLES AGAIN
- Re: Working with cells that generate errors
- VARIABLES AGAIN
- Update in my blog
- Re: formula add value in 3 column
- Oris Artelier Chronograph Mens Watch 676-7547-4051MB Recommendation Discount Watches
- Re: RefEdit error message "Element not found"
- Re: Dynamic Hyperlinks
- Re: Counting in sheet
- Re: Dynamic Hyperlinks
- How to run a video clip through macro.
- Database query.
- Copying columns (but cells should be copied in different order) between two files or worksheets
- Dynamic Hyperlinks
- Re: reusing code
- Re: Immediate Window?
- Counting in sheet
- Re: How do display a formula
- Re: Import Data from Multiple Sources
- Re: How do display a formula
- From: Rick Rothstein \(MVP - VB\)
- Re: How to convert string to corresponding Excel object?
- Re: Import Data from Multiple Sources
- Re: How do display a formula
- Re: I need some changes in a code
- Re: How do display a formula
- C# AddIn that Formats Cells for Feet, Inches and Fractions of an Inch
- Re: How do display a formula
- Re: Importing Word text into Excel
- Re: Modify Macro to Include Inserted Rows
- Re: Unable to get the VLookup property - worksheet.function error
- Re: Enforcing Macro-enabled saves
- Re: Add Borderlines
- Add Borderlines
- RE: userform variables
- excel 2003 to 2007 changes document dimensions
- Re: Toggle for Macro
- From: Rick Rothstein \(MVP - VB\)
- Re: Toggle for Macro
- From: Rick Rothstein \(MVP - VB\)
- Re: Toggle for Macro
- From: Rick Rothstein \(MVP - VB\)
- Re: Round up to nearest multiple of 5
- Re: Importing Word text into Excel
- Check if file exist based on list
- How to create a confidence bar as a function.
- Re: Disable Format menu
- Re: Help novice
- Re: Help novice
- From: Rick Rothstein \(MVP - VB\)
- RE: Is there a quick way ?
- Re: help pasting data from an array
- Re: Help novice
- Re: Help novice
- Re: Help novice
- Re: Help novice
- From: Rick Rothstein \(MVP - VB\)
- RE: Having two variable's in a macro
- Re: Help novice
- RE: Help novice
- Re: Copying only cells with data in them
- From: Rick Rothstein \(MVP - VB\)
- RE: Comparing two columns
- RE: Code Stopped Working
- Code Stopped Working
- Re: small function
- From: Rick Rothstein \(MVP - VB\)
- Re: small function
- From: Rick Rothstein \(MVP - VB\)
- RE: Custom Views Applicable to the Entire Workbook
- Re: Event not firing
- Re: Event not firing
- Automatically import tables into Excel using ODBC
- Re: Select #VALUE cells
- Re: Application.VBE.CommandBars -- Compile error
- Re: help pasting data from an array
- Re: Event not firing
- Too many IF functions
- Event not firing
- RE: sum non contig cells based on hidden rows
- RE: Getting total number of used rows
- RE: sum non contig cells based on hidden rows
- RE: Getting total number of used rows
- Re: Looping through every file in a folder and opening certain one
- Re: Add-In has menu for user but not for Automation ?
- Re: Select #VALUE cells
- sum non contig cells based on hidden rows
- Getting total number of used rows
- Date problem
- Re: For each cell method, is there a much faster way?
- Re: For each cell method, is there a much faster way?
- Re: For each cell method, is there a much faster way?
- Re: Count - Coloured Cells
- Re: For each cell method, is there a much faster way?
- Re: Make the cell to be visible
- Re: Count - Coloured Cells
- Re: For each cell method, is there a much faster way?
- Re: For each cell method, is there a much faster way?
- Re: Generate date in cell on changing value in drop down list
- Re: Sum cells with specific format
- Re: Registering parameter/function help for Excel User Defined Fun
- Re: For each cell method, is there a much faster way?
- Count - Coloured Cells
- Re: For each cell method, is there a much faster way?
- Add-In has menu for user but not for Automation ?
- small function
- Select #VALUE cells
- RE: 100% RANGE
- From: FIRSTROUNDKO via OfficeKB.com
- RE: 100% RANGE
- From: FIRSTROUNDKO via OfficeKB.com
- Re: For each cell method, is there a much faster way?
- Re: Registering parameter/function help for Excel User Defined Functio
- RE: Is there a quick way ?
- Re: For each cell method, is there a much faster way?
- RE: For each cell method, is there a much faster way?
- Registering parameter/function help for Excel User Defined Functio
- Re: How to convert string to corresponding Excel object?
- Re: How to convert string to corresponding Excel object?
- Re: sumproduct/evaluate
- From: Rick Rothstein \(MVP - VB\)
- Re: A condition and a variable
- From: Rick Rothstein \(MVP - VB\)
- A condition and a variable
- Re: How to convert string to corresponding Excel object?
- How to convert string to corresponding Excel object?
- RE: Finding outside set range
- RE: Macro for Condicitional Format
- RE: Basis question about Group/Ungroup
- Re: Selecting color number to use in vba code.
- Re: Importing Word text into Excel
- sumproduct/evaluate
- Re: Selecting color number to use in vba code.
- Re: help with database
- Re: Selecting color number to use in vba code.
- Re: Selecting color number to use in vba code.
- Re: Selecting color number to use in vba code.
- Dialog Box
- Re: Putting a form into a macro string
- Re: Putting a form into a macro string
- Re: Hyperlink programing question
- Re: Hyperlink programing question
- Re: Hyperlink programing question
- Re: Importing Word text into Excel
- Re: If then, hidden rows
- From: Rick Rothstein \(MVP - VB\)
- Re: Dydnamic date in an autofilter
- If then, hidden rows
- Re: Custom Excel 2007 Tab disappears when editing an XLAM add-in f
- Re: What's wrong with this ??
- RE: Copy from File 1 to File 2
- Re: Looping through every file in a folder and opening certain one
- RE: Putting a form into a macro string
- Selecting color number to use in vba code.
- Re: Custom Excel 2007 Tab disappears when editing an XLAM add-in f
- Re: What's wrong with this ??
- From: Rick Rothstein \(MVP - VB\)
- Re: Custom Excel 2007 Tab disappears when editing an XLAM add-in f
- Re: Adding a "tool tip" comment to a button
- RE: Copy from File 1 to File 2
- What's wrong with this ??
- RE: Copy code from ThisWorkbook using VBA?
- Re: Extracting data by data difference
- From: Rick Rothstein \(MVP - VB\)
- Re: Looping through every file in a folder and opening certain ones in a spreadsheet
- Re: Looping through every file in a folder and opening certain ones in a spreadsheet
- RE: Find non blank cell in range and fill the rest with that value
- RE: Copy from File 1 to File 2
- Re: Simplified Code
- Re: Cells with Duplicate Name on Other Worksheets
- Re: Rearranging Data
- RE: Copy row on criteria
- Re: Addin Auto_Open code executes only in debug mode
- RE: Merge two worksheet with same criteria
- Re: Looping through every file in a folder and opening certain ones in a spreadsheet
- Re: Copy row on criteria
- Re: Rearranging Data
- Export Excel data and scheduled task
- Re: Looping through every file in a folder and opening certain ones in
- Re: Rearranging Data
- Re: Runtime Error '7': Out of Memory
- Changing 2 cells based on another cell
- RE: how do I correct a "run time error 1004-unable to open" problem?
- Re: Looping through every file in a folder and opening certain ones in
- Re: Using Wildcards for Folders
- Re: Generate date in cell on changing value in drop down list
- RE: Converting LOTS of xls to xlsm
- Cells with Duplicate Name on Other Worksheets
- Re: I need to intentionally set a variable to 'error' (iserror(x) = true)
- Re: Closing addin through VBA causes code to stop
- Rearranging Data
- Re: Generate date in cell on changing value in drop down list
- RE: Extracting data by data difference
- Extracting data by data difference
- Re: Using Solver to Minimise the Result of Another Iterative Routi
- Simplified Code
- Opening an Excel spreadsheet from within an Excel spreadsheet
- RE: Generate date in cell on changing value in drop down list
- Re: Adding a "tool tip" comment to a button
- Generate date in cell on changing value in drop down list
- Moving active cell in several opened windows
- RE: screenupdating and macro status
- Sheet access monitoring
- Re: how do i pick ot list from the attendance
- Re: We Required PDF to excel conversion software
- Re: Range names vs Sheet name
- Range name vs Sheet name [again Otto!]
- RE: VBA code
- RE: Copy data from Single cell to Merged cell
- Re: ADO from .xls to .xlsm file - "Unrecognized database format" e
- Re: Copy data from Single cell to Merged cell
- RE: Copy data from Single cell to Merged cell
- Copy data from Single cell to Merged cell
- Variable Filename
- Re: help with database
- Re: What is .OpenTest
- help with database
- RefEdit error message "Element not found"
- Find all Sheets !
- Modify Macro to Include Inserted Rows
- Re: Using Solver to Minimise the Result of Another Iterative Routi
- Re: Using Solver to Minimise the Result of Another Iterative Routi
- RE: Basis question about Group/Ungroup
- Re: Date range - recognise end of each month
- RE: Formating date ranges for weekends
- code to caputre time in vb in a specific cell
- Re: Range names vs Sheet name
- Date range - recognise end of each month
- RE: Using Or and And Operators
- Using Or and And Operators
- Re: Closing addin through VBA causes code to stop
- Re: How to get the value of a merged cell using c#
- Re: working with 2 or vba's on the same sheet
- Re: What is .OpenTest
- Re: Copying array into disjoint range.
- Re: working with 2 or vba's on the same sheet
- Re: Copying array into disjoint range.
- From: Rick Rothstein \(MVP - VB\)
- Re: Extend Selection Question
- Re: Select and then cut and paste rows based on a value in 1 cell of t
- Re: Copying array into disjoint range.
- What is .OpenTest
- Re: INT to ROUNDUP
- Re: INT to ROUNDUP
- Re: Five plus minutes to execute
- Re: Five plus minutes to execute
- From: Rick Rothstein \(MVP - VB\)
- RE: I need to intentionally set a variable to 'error' (iserror(x) = tr
- How to get the value of a merged cell using c#
- Re: Range names vs Sheet name
- Re: Five plus minutes to execute
- RE: Help saving workbook
- Re: Select Case by Sheetname Property-String vs Array
- RE: Help saving workbook
- Re: Select Case by Sheetname Property-String vs Array
- Help saving workbook
- RE: Error Calling A subroutine from a User Defined Function (UDF) that
- Five plus minutes to execute
- Re: screen updating file open
- Re: How to get the first day of the previous month...
- RE: screen updating file open
- RE: screen updating file open
- Re: merging sheets to master sheet in a certain order
- RE: screen updating file open
- Re: Finding/Copying Top 10 Items From A List
- RE: working with 2 or vba's on the same sheet
- RE: screen updating file open
- Extend Selection Question
- RE: Adding button in sheet & assigning it to a macro
- Re: merging sheets to master sheet in a certain order
- Re: Range names vs Sheet name
- Exception from HRESULT: 0x8004040A
- Re: Range names vs Sheet name
- Closing addin through VBA causes code to stop
- RE: screen updating file open
- Re: Finding/Copying Top 10 Items From A List
- Re: Range names vs Sheet name
- Finding/Copying Top 10 Items From A List
- Re: Marking points read for coordinates
- Value from userform to macro
- RE: Match the HEADINGS
- RE: Match the HEADINGS
- RE: Match the HEADINGS
- RE: Find Text in Cell and Copy
- need help with SUMPRODUCT
- Re: INT to ROUNDUP
- Re: Execute My Code on Menu Option
- RE: Adding button in sheet & assigning it to a macro
- RE: Match the HEADINGS
- VB Code to List all Sheets and Charts in a Workbook
- Re: Excel macro crashes if an entry in a combo box is not in the l
- Re: Excel crashes
- Re: Workbook size?
- How to setup gutter + double sided print for Excel?
- Re: Excel crashes
- INT to ROUNDUP
- Re: Using Solver to Minimise the Result of Another Iterative Routin
- Re: email macro
- Re: Excel crashes
- Re: Excel crashes
- Re: Excel crashes
- Re: Excel crashes
- RE: Passing the Value of a Cell to a VBA variable.
- Re: Paste picture on a userform control
- Re: Excel crashes
- Re: email macro
- RE: Passing the Value of a Cell to a VBA variable.
- Passing the Value of a Cell to a VBA variable.
- Re: email macro
- RE: Delete Columns
- RE: Importing Word tables into Excel
- Excel crashes
- RE: Time the Execution Speed of Procedure in Milliseconds
- Time the Execution Speed of Procedure in Milliseconds
- Error Calling A subroutine from a User Defined Function (UDF) that
- Re: Defined names
- Re: Dynamic Charts
- RE: Importing Word tables into Excel
- Re: Calendar Initialize
- From: Rick Rothstein \(MVP - VB\)
- Re: Calendar Initialize
- Importing Word tables into Excel
- Re: FOR NEXT Problems .....
- From: Rick Rothstein \(MVP - VB\)
- Calendar Initialize
- Re: Help in VBA.
- RE: Formating date ranges for weekends
- Change text in a cell from a command button on a Userform
- Re: Macro Excel to automatise the copy of data from one worksheet to another sheet
- Formating date ranges for weekends
- Macro Excel to automatise the copy of data from one worksheet to another sheet
- Re: highlight alternate row in excel
- Old VBA code modification help
- Re: Application Level Events
- Re: highlight alternate row in excel
- Application Level Events
- Re: Summing Group and insert value next to it
- highlight alternate row in excel
- Re: Activate Freeform crosshairs with code - possible?
- RE: How to automatically delete formulas in an adjacent column
- Re: How to automatically delete formulas in an adjacent column
- How to automatically delete formulas in an adjacent column
- Re: Using Solver to Minimise the Result of Another Iterative Routine
- Re: Return array of page ranges
- Summing Group and insert value next to it
- Re: Mixed format
- Activate Freeform crosshairs with code - possible?
- Re: Mixed format
- Re: Mixed format
- From: Rick Rothstein \(MVP - VB\)
- Re: Mixed format
- Re: Mixed format
- From: Rick Rothstein \(MVP - VB\)
- Mixed format
- Re: List Box Columns
- Using Solver to Minimise the Result of Another Iterative Routine
- Re: set an array of shapes visibility
- Re: FOR NEXT Problems .....
- Re: List Box Columns
- Re: VBA croaks on Nodes.Clear if TreeView is *not* Visible.
- Re: Disabling a shape object
- Re: List Box Columns
- VBA croaks on Nodes.Clear if TreeView is *not* Visible.
- Re: Disabling a shape object
- RE: Detect if spreadsheet is opened off the web
- Re: List Box Columns - Revisited
- RE: Graphing
- Re: Workbook size?
- Re: Use of CallByName()
- List Box Columns - Revisited
- Re: Workbook size?
- RE: Graphing
- Re: List Box Columns
- Re: Workbook size?
- Re: Use of CallByName()
- From: Rick Rothstein \(MVP - VB\)
- Re: List Box Columns
- Re: Help in VBA.
- Re: Use of CallByName()
- Re: Workbook size?
- VB6 Com Addin versus VBA Addin
- Re: Use of CallByName()
- From: Rick Rothstein \(MVP - VB\)
- Re: Can I copy data (Values) from one sheet to another with macro
- RE: Use of CallByName()
- Re: Auto insert a vb module to a new workbook -riv
- Use of CallByName()
- Re: Marking points read for coordinates
- Re: FOR NEXT Problems .....
- Re: FOR NEXT Problems .....
- From: Rick Rothstein \(MVP - VB\)
- Workbook Open Event Procedure
- Re: Workbook size?
- RE: Auto insert a vb module to a new workbook -riv
- Re: FOR NEXT Problems .....
- Re: Very complex Loop
- Re: Is it possible to programmatically determine where a user is?
- Re: FOR NEXT Problems .....
- Re: Is it possible to programmatically determine where a user is?
- Re: UDF ...VBA Formula built ...please help
- RE: Finding data in an area that changes
- Auto insert a vb module to a new workbook -riv
- Re: Is it possible to programmatically determine where a user is?
- RE: XL2003 VBA: Debuging...can not break or run in break/step mode.
- RE: Finding data in an area that changes
- Re: FOR NEXT Problems .....
- RE: Finding data in an area that changes
- RE: Finding data in an area that changes
- Re: UserForm Control references as variable
- FOR NEXT Problems .....
- RE: Finding data in an area that changes
- UserForm Control references as variable
- RE: Finding data in an area that changes
- RE: Finding data in an area that changes
- Re: hiding rows containing formulas which return zero values
- RE: Finding data in an area that changes
- Re: Defined names
- Re: weird listbox behavior
- Re: weird listbox behavior
- RE: copying to powerpoint...error message
- RE: copying to powerpoint...error message
- Re: How to run a macro when a form opens?
- Re: Execute My Code on Menu Option
- Re: How to get variables from worksheet code to userform code
- RE: copying to powerpoint...error message
- RE: copying to powerpoint...error message
- RE: copying to powerpoint...error message
- Re: Can I copy data (Values) from one sheet to another with macro
- Re: creating rows of colored cells from adjacent numbers
- Re: How to get variables from worksheet code to userform code
- RE: Detect if spreadsheet is opened off the web
- RE: Breaking Internal Passwords
- RE: Can't Contenate
- Re: How to run a macro when a form opens?
- RE: Macro Fails
- RE: Can't Contenate
- RE: Defined names
- Re: Can I copy data (Values) from one sheet to another with macro
- Re: Can I copy data (Values) from one sheet to another with macro
- Re: creating rows of colored cells from adjacent numbers
- Defined names
- RE: Detect if spreadsheet is opened off the web
- Re: How do I copy a formula with the cell increasing by increments
- Re: Can I copy data (Values) from one sheet to another with macro
- Re: How to run a macro when a form opens?
- Re: Storing multiple ranges using a macro
- Re: Concept question re ranges and calcs
- Can I copy data (Values) from one sheet to another with macro
- Re: Delete Empty Rows Macro
- RE: Convert Cell w/ Manual Breaks into New Rows
- RE: Convert Cell w/ Manual Breaks into New Rows
- Re: .FormulaR1C1="abc" works, .Text="abc" doesn't. WHAT the?
- RE: Unlocking Project When Condition is Met
- Re: Setting worksheets not maximized to relative size
- Re: Select Case by Sheetname Property-String vs Array
- RE: Renaming Visible Sheets Only
- RE: VBA - UserForm Reset Option
- RE: Financial Statement creation Macro from external source
- Re: Don't add to range if row already exists
- RE: Making ranges adjust automatically
- RE: Strange Excel Application Object Behavior
- RE: Strange Excel Application Object Behavior
- Re: Application.Selection and its items
- Re: Enable Macro on open
- Run Time Error 1004: Application Defined or Object Defined Error
- Custom Menus and OnAction
- Financial Statement creation Macro from external source
- Re: COPY DATA IN SPECIFIC WAY
- Re: COPY DATA IN SPECIFIC WAY
- Convert Cell w/ Manual Breaks into New Rows
- Re: Excel macro crashes if an entry in a combo box is not in the list
- From: Rick Rothstein \(MVP - VB\)
- Re: How to address elements in variant array?
- From: Rick Rothstein \(MVP - VB\)
- RE: Making ranges adjust automatically
- Re: 2007 excel formula spellnumber
- From: Rick Rothstein \(MVP - VB\)
- RE: How to address elements in variant array?
- How to address elements in variant array?
- RE: Delete Empty Rows Macro
- Making ranges adjust automatically
- RE: Excel macro crashes if an entry in a combo box is not in the list
- Re: DELETE ENTIRE ROW
- Re: COPY DATA IN SPECIFIC WAY
- Re: Formulas, Please help!!!
- Re: 2007 v 2003 compatability
- Re: DELETE ENTIRE ROW
- Re: Update Personal Workbook Macros when Workbook is opened.
- Re: Enable Macro on open
- dual Y axis
- Re: Excel2003 Control Array with CheckBoxes
- RE: Workbook updated from Access
- Re: VBA in Excel
- Workbook updated from Access
- Create directory on hard drive?
- Re: ADO from .xls to .xlsm file - "Unrecognized database format" e
- Re: VBA autofilter
- Re: .FormulaR1C1="abc" works, .Text="abc" doesn't. WHAT the?
- VBA autofilter
- Re: Marking points read for coordinates
- Re: Don't add to range if row already exists
- Click on a cell and have check mark displayed in MS Excel
- Re: Don't add to range if row already exists
- RE: Dialog Box
- RE: Delete Empty Rows Macro
- Delete Empty Rows Macro
- Formulas, Please help!!!
- Re: Update Personal Workbook Macros when Workbook is opened.
- Method ‘Add’ of object ‘CommandbarControls’ failed
- Re: Don't add to range if row already exists
- RE: Message box whilst calculating
- RE: Message box whilst calculating
- Message box whilst calculating
- How can get values from another cell relative to current?
- Re: Highlight Cells
- Re: UDF ...VBA Formula built ...please help
- RE: Controlling the file
- RE: Debug Print
- Controlling the file
- Re: Highlight Cells
- RE: Populate a cell if values in cell 1 and cell 2 match cell 3 and 4
- Re: Don't add to range if row already exists
- Re: Highlight Cells
- From: Rick Rothstein \(MVP - VB\)
- RE: Highlight Cells
- Don't add to range if row already exists
- Re: Debug Print
- From: dustinbrearton via OfficeKB.com
- Re: Marking points read for coordinates
- Populate a cell if values in cell 1 and cell 2 match cell 3 and 4
- Re: Marking points read for coordinates
- Debug Print
- Re: Compile error - Sub Function not defined
- RE: Type Mismatch error while checking range value
- RE: Compare and highlight
- RE: Help with variable ranges
- Re: Debugging a loop
- Re: Excel 2007 Macro and VB Buttons
- Link to database
- Re: Error 91 in Autofilter
- RE: Name of Module from Procedure?
- Debugging a loop
- RE: Mapping to sharepoint drive
- Re: Setting worksheets not maximized to relative size
- From: Rick Rothstein \(MVP - VB\)
- RE: Mapping to sharepoint drive
- Re: Error 91 in Autofilter
- RE: Help with variable ranges
- RE: Speedy code required
- Re: Marking points read for coordinates
- Very complex Loop
- Textbox1 color
- RE: Can workbooks be consolidated in Sharepoint using VBA?
- Re: Deleting emails AFTER sending
- RE: Delete a worksheet before closing workbook
- RE: Macros
- ADO from .xls to .xlsm file - "Unrecognized database format" error
- Re: Deleting emails AFTER sending
- RE: Copy sheets from source wkbk to another wkbk
- Deleting emails AFTER sending
- RE: ChangeLink problem
- Handling of Save Button procedure in Save As Dialog Box.
- RE: ChangeLink problem
- Copy sheets from source wkbk to another wkbk
- RE: ChangeLink problem
- RE: ChangeLink problem
- Re: On Key procedure
- Re: Excel Programming
- RE: On Key procedure
- RE: VLOOKUP Returns #NA
- On Key procedure
- Excel Programming
- Re: UDF ...VBA Formula built ...please help
- VLOOKUP Returns #NA
- finding Names in a Row
- User form and macro for search function
- RE: Positioning Active X controls
- RE: Can workbooks be consolidated in Sharepoint using VBA?
- RE: Can workbooks be consolidated in Sharepoint using VBA?
- RE: Can workbooks be consolidated in Sharepoint using VBA?
- Macro Recording Question
- Re: formula to post previous month
- Re: Get Dialog saying it cannot update links (I have created an Add-in)
- Re: vba xcel
- RE: Disable Controls
- RE: ChangeLink problem
- formula to post previous month
- RE: Covert XLS to CSV
- Re: How to Pause code untill cell contents change?
- Re: Covert XLS to CSV
- Excel 2003/Excel 2007 Add-Ins Do Not Reset after closing files
- New Hlep badly
- RE: Macros
- Re: Error 91 in Autofilter
- Covert XLS to CSV
- Re: Calling another macro?
- Re: Help with creating an ADD button...
- RE: Macros
- Re: ActiveWorkbook.Close Dont Work in Excel 2007
- Re: Help with creating an ADD button...
- From: dustinbrearton via OfficeKB.com
- Re: Macros to count cells with specific color and text
- Re: ActiveWorkbook.Close Dont Work in Excel 2007
- RE: How to Pause code untill cell contents change?
- RE: Macros
- Re: Update Personal Workbook Macros when Workbook is opened.
- Re: How to: Hide a column on multipal sheets without looping.
- From: Rick Rothstein \(MVP - VB\)
- Re: Count number of records in multiple workbooks.
- Re: Error 91 in Autofilter
- RE: Macros
- Re: Get Dialog saying it cannot update links (I have created an Add-in)
- Help with creating an ADD button...
- Re: Excel2003 Control Array with CheckBoxes
- Re: ActiveWorkbook.Close Dont Work in Excel 2007
- Re: Autofit non contiguous columns containing merged cells across columns
- Re: Email Just sheet1 in the body of the email
- Re: How to: Hide a column on multipal sheets without looping.
- Re: Autofit non contiguous columns containing merged cells across columns
- Offset Error
- Re: Calling another macro?
- Re: Macros to count cells with specific color and text
- RE: How do you use.Value with Copy Destination:=
- RE: Status of running macro
- Re: Command Button Color Palette
- From: Rick Rothstein \(MVP - VB\)
- RE: Status of running macro
- RE: How do you use.Value with Copy Destination:=
- Re: How to: Hide a column on multipal sheets without looping.
- RE: Macros to count cells with specific color and text
- Re: Calling a Worksheet Level Procedure from a UserForm Button Pro
- How to: Hide a column on multipal sheets without looping.
- Re: Count number of records in multiple workbooks.
- RE: Duplicate Worksheets error 1004
- RE: Pop-Up Calendar
- Duplicate Worksheets error 1004
- From: FIRSTROUNDKO via OfficeKB.com
- Re: Find sheet name with module name known?
- RE: Pop-Up Calendar
- Calling a Worksheet Level Procedure from a UserForm Button Procedu
- Re: Find sheet name with module name known?
- RE: Pop-Up Calendar
- RE: Pop-Up Calendar
- RE: Hyperlink to Embedded Object
- RE: ChangeLink problem
- Pop-Up Calendar
- Re: Find sheet name with module name known?
- Find sheet name with module name known?
- RE: Set the Xvalues of the chart
- RE: PPT in excel macro
- RE: PPT in excel macro
- RE: Hyperlink to Embedded Object
- RE: PPT in excel macro
- RE: ChangeLink problem
- VBA: Spreadsheet or Chart?
- Macros to count cells with specific color and text
- RE: ChangeLink problem
- RE: ChangeLink problem
- Re: How to Lock cells and have them be unlocked based on a cell be
- Re: wait before executing rest of a macro
- RE: Placing WingDings on a chart
- Re: wait before executing rest of a macro
- break one row into multiple rows for same value
- Re: Compression?
- Set the Xvalues of the chart
- Re: reformatting after importing a text file
- Re: Error 91 in Autofilter
- RE: Compiler chokes on correct syntax TreeView1_KeyDown(KeyCode As Int
- RE: reformatting after importing a text file
- RE: Compression?
- Re: Printing Userform w/ Printer Selection
- Re: Text box date format
- RE: how to search the upper and lower of a range
- Placing WingDings on a chart
- Re: Enforcing Macro-enabled saves
- Compiler chokes on correct syntax TreeView1_KeyDown(KeyCode As Integer, Shift As Integer).
- Re: need help moving files
- reformatting after importing a text file
- Re: deleting rows based on criteria
- Re: How to Modify the style of a picture with VBA
- Dynamic Charts
- Re: Hide Rows when 3 conditions are met
- need help moving files
- RE: How to write STDev formula in a macro
- RE: Really Help with existing VBA code...
- RE: How to write STDev formula in a macro
- Re: How to Modify the style of a picture with VBA
- Re: Enforcing Macro-enabled saves
- Re: Select Case by Sheetname Property-String vs Array
- Re: finding the next empty cell...
- From: Rick Rothstein \(MVP - VB\)
- Re: Help with error 53
- Re: Select Case by Sheetname Property-String vs Array
- ChangeLink problem
- RE: Same code doesn't work on multiple users' pc
- RE: How to write STDev formula in a macro
- RE: How to write STDev formula in a macro
- RE: How to write STDev formula in a macro
- Re: Command Button Color Palette
- From: Rick Rothstein \(MVP - VB\)
- Re: Select Case by Sheetname Property-String vs Array
- Re: copy the highlighted area to the clipboard
- Select Case by Sheetname Property-String vs Array
- Re: Command Button Color Palette
- Re: Help with error 53
- Compression?
- Same code doesn't work on multiple users' pc
- Re: Numbers Stored as text problem
- Re: Deleting rows
- Re: copy the highlighted area to the clipboard
- Re: Numbers Stored as text problem
- copy the highlighted area to the clipboard
- RE: SOLVER COMPILE ERROR: "CAN'T FIND PROJECT OR LIBRARY" 2003 VS 2007
- Numbers Stored as text problem
- Re: Using Wildcard in VBA IF
- Re: If/And Formula
- RE: If/And Formula
- Re: Button cell address
- If/And Formula
- Re: suggestions for parsing a string
- RE: "Combobox Info"
- RE: Button cell address
- Re: Text box date format
- Re: Button cell address
- RE: "Combobox Info"
- SOLVER COMPILE ERROR: "CAN'T FIND PROJECT OR LIBRARY" 2003 VS 2007
- Re: Text box date format
- From: Rick Rothstein \(MVP - VB\)
- Re: suggestions for parsing a string
- RE: "Combobox Info"
- Re: Text box date format
- Re: Looking at each cell when range is selected
- RE: Problem with a macro finding cell values
- RE: Button cell address
- Re: DonButton
- Re: Command Button Color Palette
- From: Rick Rothstein \(MVP - VB\)
- Re: DonButton
- RE: Button cell address
- RE: Custom Vlookup Function
- RE: Button cell address
- Re: Command Button Color Palette
- Re: Hide Rows when 3 conditions are met
- RE: Button cell address
- Re: DonButton
- Re: Count number of records in multiple workbooks.
- Re: Help with error 53
- Re: parse from txt file
- RE: finding the next empty cell...
- Re: Text box date format
- RE: Passwords and Tools / Options / Secuity
- Hide Rows when 3 conditions are met
- finding the next empty cell...
- Button cell address
- Passwords and Tools / Options / Secuity
- Count number of records in multiple workbooks.
- Re: Help with error 53
- Re: Calling another macro?
- Re: Calling another macro?
- Re: Macro lagging during loop
- Re: Autofilter code and assigning Criteria1 equal to value of workshee
- Re: Using Wildcard in VBA IF
- From: Rick Rothstein \(MVP - VB\)
- Re: Looking at each cell when range is selected
- Re: Using Wildcard in VBA IF
- Re: Using Wildcard in VBA IF
- Re: Run Macros based on cell data entry
- Printing Userform w/ Printer Selection
- RE: PPT in excel macro
- Re: parse from txt file
- From: Rick Rothstein \(MVP - VB\)
- RE: Copy Specific Cells To A New Sheet On Condition
- Re: How to Modify the style of a picture with VBA
- RE: Run Macros based on cell data entry
- RE: parse from txt file
- RE: Copy _ Destination := Range, Transpose:=True? Can it work?
- RE: Run Macros based on cell data entry
- RE: Run Macros based on cell data entry
- Re: Run Macros based on cell data entry
- From: dustinbrearton via OfficeKB.com
- RE: PPT in excel macro
- RE: Run Macros based on cell data entry
- Re: parse from txt file
- From: dustinbrearton via OfficeKB.com
- Re: parse from txt file
- From: Rick Rothstein \(MVP - VB\)
- How to Modify the style of a picture with VBA
- Re: Macro must run multiple times before completion
- From: dustinbrearton via OfficeKB.com
- RE: Problem with a macro finding cell values
- Run Macros based on cell data entry
- Re: Excel 2007 and Trusted Publishers
- Re: Macro must run multiple times before completion
- From: dustinbrearton via OfficeKB.com
- Re: wait before executing rest of a macro
- parse from txt file
- RE: Macro must run multiple times before completion
- Re: Enabling macros in Excel 2007
- Re: Macro must run multiple times before completion
- RE: Macro must run multiple times before completion
- RE: Using Wildcard in VBA IF
- RE: Looking at each cell when range is selected
- Autofilter code and assigning Criteria1 equal to value of workshee
- Re: Place wingding on specific coordinates - possible?
- Macro must run multiple times before completion
- Looking at each cell when range is selected
- Re: Cancelling AutoFilter in a macro
- Re: Command Button Color Palette
- From: Rick Rothstein \(MVP - VB\)
- Error 91 in Autofilter
- RE: #N/A isn't charting in VBA
- Re: Enabling macros in Excel 2007
- Copy Specific Cells To A New Sheet On Condition
- Re: how to search the upper and lower of a range
- RE: Custom Vlookup Function
- Re: UDF ...VBA Formula built ...please help
- Re: Macro lagging during loop
- Re: ITEM MASTER
- Re: Excel 2007 and Trusted Publishers
- Re: parsing a column of data into a single entry separated by commas
- From: Rick Rothstein \(MVP - VB\)
- Command Button Color Palette
- RE: Using Wildcard in VBA IF
- RE: Macro lagging during loop
- parsing a column of data into a single entry separated by commas
- RE: Really Help with existing VBA code...
- RE: PPT in excel macro
- RE: Add-in Already Open
- RE: Using Wildcard in VBA IF
- Re: Using Wildcard in VBA IF
- From: Rick Rothstein \(MVP - VB\)
- RE: Using Wildcard in VBA IF
- Macro lagging during loop
- Re: Open next excel file in directory and stop when no more files
- Re: Using Wildcard in VBA IF
- From: Rick Rothstein \(MVP - VB\)
- RE: Using Wildcard in VBA IF
- RE: Using Wildcard in VBA IF
- Re: Open next excel file in directory and stop when no more files
- RE: User Form Crashing Excel
- Using Wildcard in VBA IF
- Re: Excel 2007 and Trusted Publishers
- RE: User Form Crashing Excel
- Excel 2007 and Trusted Publishers
- Re: InputBox methode
- Re: Help with error 53
- Re: can I test if a variable is a member of an array
- From: Rick Rothstein \(MVP - VB\)
- Re: How to Lock cells and have them be unlocked based on a cell being
- Re: InputBox methode
- RE: Creating a Dynamic Link from Excel to Word
- Re: Help with error 53
- Re: Open next excel file in directory and stop when no more files list
- Open next excel file in directory and stop when no more files list
- How to Lock cells and have them be unlocked based on a cell being
- Deleting rows
- RE: Macro to return user to previously viewed sheet
- Re: Calling another macro?
- PPT in excel macro
- RE: Macro to return user to previously viewed sheet
- Problem with a macro finding cell values
- User Form Crashing Excel
- Macro to return user to previously viewed sheet
- can I test if a variable is a member of an array
- Re: Enabling macros in Excel 2007
- RE: Help with error 53
- Creating a Dynamic Link from Excel to Word
- RE: Help with error 53
- Copy _ Destination := Range, Transpose:=True? Can it work?
- Font size problem in text box on user form
- Re: Enabling macros in Excel 2007
- Re: Strange behaviour with replace function
- From: Rick Rothstein \(MVP - VB\)
- Re: Run the macro until activeSheet.previous.Select = Sheet2
- Re: Place wingding on specific coordinates - possible?
- Re: Why do I get an error in this code???
- Re: Prompt user to select a shape
- Re: Why do I get an error in this code???
- web browser visible state
- Why do I get an error in this code???
- Re: Calling another macro?
- Re: Putting page numbers into this macro, How??
- Re: Place wingding on specific coordinates - possible?
- Re: DonButton
- Re: Strange behaviour with replace function
- Re: Calling another macro?
- Re: Calling another macro?
- Re: Reading values from inputbox into arrays
- Re: UDF evaluate string output
- Re: UDF evaluate string output
- Creating a new worksheet from non zero values
- Re: Strange behaviour with replace function
- Re: Subtotal macro in each worksheet
- UDF evaluate string output
- Re: Calling another macro?
- Re: Need to make automatic macro changes
- Re: Putting page numbers into this macro, How??
- Need to make automatic macro changes
- Re: Remove Data Validation with macro
- Re: Calling another macro?
- Re: UDF ...VBA Formula built ...please help
- RE: how to search the upper and lower of a range
- Re: Calling another macro?
- Re: Remove Data Validation with macro
- Re: Subtotal macro in each worksheet
- Re: Remove Data Validation with macro
- Re: Variation on the protection themes
- RE: Reading values from inputbox into arrays
- Calling another macro?
- Re: Remove Data Validation with macro
- Re: Place wingding on specific coordinates - possible?
- Re: Can you someone use Copy Destination:= using a transpose element?
- From: Rick Rothstein \(MVP - VB\)
- ITEM MASTER
- Variation on the protection themes
- Re: Strange behaviour with replace function
- From: Rick Rothstein \(MVP - VB\)
- Re: Text box date format
- Can you someone use Copy Destination:= using a transpose element?
- Reading values from inputbox into arrays
- Scale my excel chart
- Re: Subtotal macro in each worksheet
- Re: Subtotal macro in each worksheet
- how to search the upper and lower of a range
- RE: How to write STDev formula in a macro
- RE: Putting page numbers into this macro, How??
- Strange behaviour with replace function
- Re: Don't move or size the button
- Re: Putting page numbers into this macro, How??
- wait before executing rest of a macro
- Remove Data Validation with macro
- Re: Place wingding on specific coordinates - possible?
- Re: Place wingding on specific coordinates - possible?
- Re: Don't move or size the button
- Don't move or size the button
- Re: using the IF statement
- Putting page numbers into this macro, How??
- Re: using the IF statement
- From: Rick Rothstein \(MVP - VB\)
- Re: using the IF statement
- From: Rick Rothstein \(MVP - VB\)
- RE: How to write STDev formula in a macro
- Re: using the IF statement
- Re: using the IF statement
- From: Rick Rothstein \(MVP - VB\)
- RE: using the IF statement
- RE: using the IF statement
- RE: While doing multiple cell copy paste the Selection.PasteSpecial ov
- RE: set cell in one workbook to find in another workbook
- RE: Countif or please advice
- RE: number/text problem
- RE: How to write STDev formula in a macro
- RE: using the IF statement
- RE: Re ordering help urgent!!!
- set cell in one workbook to find in another workbook
- RE: number/text problem
- RE: using the IF statement
- Re: Place wingding on specific coordinates - possible?
- RE: Enforcing Macro-enabled saves
- RE: Enforcing Macro-enabled saves
- using the IF statement
- number/text problem
- Re ordering help urgent!!!
- RE: Is there an object property that will return the file type?
- Unprotect Worsheet
- Re: countif or please advice
- How to write STDev formula in a macro
- Enforcing Macro-enabled saves
- Re: countif or please advice
- RE: sum a range from a starting point that varies
- Re: sum a range from a starting point that varies
- From: Rick Rothstein \(MVP - VB\)
- Re: countif or please advice
- Re: interactive column width
- From: Rick Rothstein \(MVP - VB\)
- RE: interactive column width
- sum a range from a starting point that varies
- RE: interactive column width
- RE: interactive column width
- RE: interactive column width
- Re: suggestions for parsing a string
- From: Rick Rothstein \(MVP - VB\)
- RE: interactive column width
- RE: Custom Vlookup Function
- Re: Prompt user to select a shape
- interactive column width
- Enabling macros in Excel 2007
- Re: Recorded macro fails after save, close, then reopen
- Re: suggestions for parsing a string
- irregular image map
- RE: countif or please advice
- Custom Vlookup Function
- Re: Prompt user to select a shape
- RE: Recorded macro fails after save, close, then reopen
- RE: suggestions for parsing a string
- Add-in Already Open
- RE: Is there an object property that will return the file type?
- Re: highlights cells that are not a dependents
- From: Rick Rothstein \(MVP - VB\)
- suggestions for parsing a string
- countif or please advice
- Countif or please advice
- Re: highlights cells that are not a dependents
- Re: Validation of 2 rows of cells, only 'X' or 'x' allowed.
- From: Rick Rothstein \(MVP - VB\)
- Re: Validation of 2 rows of cells, only 'X' or 'x' allowed.
- Re: assign the formatted cell value (date) to another cell?
- From: Rick Rothstein \(MVP - VB\)
- RE: Left, top, rigth and bottom points dimensions in a 3d Chart
- Re: Recorded macro fails after save, close, then reopen
- Re: Recorded macro fails after save, close, then reopen
- From: dustinbrearton via OfficeKB.com
- Re: Prompt user to select a shape
- Re: highlights cells that are not a dependents
- From: Rick Rothstein \(MVP - VB\)
- RE: Delete string if string has only one item
- RE: Object variable or with block not set Err 91
- Re: Validation of 2 rows of cells, only 'X' or 'x' allowed.
- From: Rick Rothstein \(MVP - VB\)
- RE: Prompt user to select a shape
- Re: Validation of 2 rows of cells, only 'X' or 'x' allowed.
- Re: Sorting and the Worksheet Change Event
- Re: Recorded macro fails after save, close, then reopen
- RE: Left, top, rigth and bottom points dimensions in a 3d Chart
- Re: PlayWavFile
- Re: PlayWavFile
- From: Rick Rothstein \(MVP - VB\)
- Re: Sorting and the Worksheet Change Event
- From: Rick Rothstein \(MVP - VB\)
- Re: PlayWavFile
- RE: Really Help with existing VBA code...
- RE: To get row id
- Re: Recorded macro fails after save, close, then reopen
- RE: Recorded macro fails after save, close, then reopen
- Left, top, rigth and bottom points dimensions in a 3d Chart
- Re: Place wingding on specific coordinates - possible?
- RE: Recorded macro fails after save, close, then reopen
- Recorded macro fails after save, close, then reopen
- RE: VBA - UserForm Reset Option
- Re: Sorting and the Worksheet Change Event
- Re: Validation of 2 rows of cells, only 'X' or 'x' allowed.
- From: Rick Rothstein \(MVP - VB\)
- To get row id
- Re: How to leave Selection.Sort Key open....
- Re: PlayWavFile
- Re: InputBox methode
- RE: VBA - UserForm Reset Option
- Re: PlayWavFile
- Re: Validation of 2 rows of cells, only 'X' or 'x' allowed.
- Re: Sorting and the Worksheet Change Event
- RE: excel programming
- Sorting and the Worksheet Change Event
- excel programming
- Re: InputBox methode
- While doing multiple cell copy paste the Selection.PasteSpecial over rides the protected formula cells
- Validation of 2 rows of cells, only 'X' or 'x' allowed.
- Re: Subtotal macro in each worksheet
- Insert and Copy
- Re: How to leave Selection.Sort Key open....
- Re: Run-time error when path parameter changed
- Prompt user to select a shape
- Re: Using Replace to remove part of a string
- Re: How to leave Selection.Sort Key open....
- Re: User form varible passing
- RE: How to leave Selection.Sort Key open....
- PlayWavFile
- Excel default module when opening visual basic editor
- Pulling files by the creation date
- RE: Excel Sheet Unviewable ~ able to open, but sheet proper all blue
- Saving the contents of a worksheet table to an xml document when the user closes the workbook.
- RE: Adding sount to a macro
- Passing Paramiters and UDF Question
- Re: Save as Macro
- From: dustinbrearton via OfficeKB.com
- Re: UDF ...VBA Formula built ...please help
- How to leave Selection.Sort Key open....
- RE: Adding sount to a macro
- Excel Sheet Unviewable ~ able to open, but sheet proper all blue
- Re: Using Replace to remove part of a string
- From: Rick Rothstein \(MVP - VB\)
- Re: Hide text in a cell.
- RE: Creating new workbook from different workbook
- Re: User form varible passing
- From: Rick Rothstein \(MVP - VB\)
- Re: Run the macro until activeSheet.previous.Select = Sheet2
- From: Rick Rothstein \(MVP - VB\)
- RE: Using Replace to remove part of a string
- Re: Subtotal macro in each worksheet
- RE: Using Replace to remove part of a string
- RE: User form varible passing
- RE: Really Help with existing VBA code...
- Re: Using Replace to remove part of a string
- Re: Subtotal macro in each worksheet
- Re: Subtotal macro in each worksheet
- Using Replace to remove part of a string
- Re: User form varible passing
- From: Rick Rothstein \(MVP - VB\)
- Re: Place wingding on specific coordinates - possible?
- Re: Hide text in a cell.
- From: Rick Rothstein \(MVP - VB\)
- RE: Run the macro until activeSheet.previous.Select = Sheet2
- User form varible passing
- Re: Subtotal macro in each worksheet
- RE: Save as Macro
- Re: Copy data from all the file file from a folder.
- Re: Subtotal macro in each worksheet
- Re: Disabling clipboard prompt
- Re: Subtotal macro in each worksheet
- RE: Assign a folder path to a variable
- Run the macro until activeSheet.previous.Select = Sheet2
- Re: Subtotal macro in each worksheet
- Save as Macro
- Save as Macro
- Re: Copying results to clipboard. Is there a better way ?
- Re: dictionary count is greater than number of keys?
- Re: Place wingding on specific coordinates - possible?
- Excel Form for updating records
- Re: UDF ...VBA Formula built ...please help
- Re: assign the formatted cell value (date) to another cell?
- RE: Subtotal macro in each worksheet
- Hide text in a cell.
- RE: drodown selection
- RE: drodown selection
- Re: drodown selection
- drodown selection
- Re: Place wingding on specific coordinates - possible?
- Re: Deleting columns on multiple sheets
- Re: dictionary count is greater than number of keys?
- Re: Can I abbrevate the following (would I Dim and Set it as a Range?)
- Re: Copy data from all the file file from a folder.
- RE: Subtotal macro in each worksheet
- Re: assign the formatted cell value (date) to another cell?
- Re: dictionary count is greater than number of keys?
- Re: Problem with (One location = Another location)
- Subtotal macro in each worksheet
- RE: sum values in multiple ranges
- Re: adding all the cells in a group of cells
- Re: Place wingding on specific coordinates - possible?
- assign the formatted cell value (date) to another cell?
- RE: my macro is remembering specific range instead of 1st to last
- RE: my macro is remembering specific range instead of 1st to last
- RE: my macro is remembering specific range instead of 1st to last
- sum values in multiple ranges
- my macro is remembering specific range instead of 1st to last
- dictionary count is greater than number of keys?
- Re: Have a problem with "Find" code
- Can I abbrevate the following (would I Dim and Set it as a Range?)
- RE: Copy data from all the file file from a folder.
- Re: Go to Error (what is this? Is it for findign #DIV! erros in Excel?
- RE: place cell value in header
- RE: Have a problem with "Find" code
- RE: place cell value in header
- Have a problem with "Find" code
- Re: highlights cells that are not a dependents
- Copy data from all the file file from a folder.
- place cell value in header
- Re: vba xcel
- Re: Deleting columns on multiple sheets
- Re: Deleting columns on multiple sheets
- From: Rick Rothstein \(MVP - VB\)
- Re: Deleting columns on multiple sheets
- Deleting columns on multiple sheets
- Copying results to clipboard. Is there a better way ?
- Socket component in Excel 2007
- Re: Macro to find and log all formula errors on all sheets
- Re: highlights cells that are not a dependents
- From: Rick Rothstein \(MVP - VB\)
- Re: adding all the cells in a group of cells
- RE: adding all the cells in a group of cells
- Re: highlights cells that are not a dependents
- From: Rick Rothstein \(MVP - VB\)
- adding all the cells in a group of cells
- RE: highlights cells that are not a dependents
- Re: UDF ...VBA Formula built ...please help
- Re: run time error 53
- Re: run time error 53
- Re: Place wingding on specific coordinates - possible?
- Re: run time error 53
- Re: run time error 53
- Re: VBA Auto correction Issue
- Re: run time error 53
- Re: run time error 53
- Re: run time error 53
- RE: run time error 53
- RE: Macro to insert multiple images at specific cells and resize all i
- Re: Macro Code not reliable
- RE: run time error 53
- Re: Determining which Print Button was clicked
- Macro to insert multiple images at specific cells and resize all i
- From: Mike Charlie Charlie
- disappearing querytables
- Re: Macro Code not reliable
- Re: Macro Code not reliable
- Re: Macro Code not reliable
- Re: Macro Code not reliable
- Re: Place wingding on specific coordinates - possible?
- RE: Macro Code not reliable
- Re: Text box date format
- From: Rick Rothstein \(MVP - VB\)
- Re: Requesting Help Please on Auto Worksheet Setup
- Re: Text box date format
- Re: Text box date format
- From: Rick Rothstein \(MVP - VB\)
- run time error 53
- Re: Sound files VBA programmed from Excel
- Re: Text box date format
- RE: VBA Project to the Specific Computer
- Re: Text box date format
- From: Rick Rothstein \(MVP - VB\)
- Macro Code not reliable
- Re: Text box date format
- Re: Using a value in a cell as a Reference in a formula?
- From: Rick Rothstein \(MVP - VB\)
- Re: Sound files VBA programmed from Excel
- Re: Requesting Help Please on Auto Worksheet Setup
- comprimes de acheter lipitor en France Warren acheter lipitor suisse au rabais en ligne sans prescription acheter lipitor belgique en ligne achat lipitor canada soft en ligne acheter lipitor canada lipitor de ATORVASTATINE
- Re: Save problem with multiple workbooks and event workbook_deactivate
- Re: InputBox methode
- Re: Create scripts from Excel
- RE: May I called a Programmer if...
- Re: Requesting Help Please on Auto Worksheet Setup
- RE: InputBox methode
- RE: May I called a Programmer if...
- RE: InputBox methode
- RE: May I called a Programmer if...
- InputBox methode
- Re: Requesting Help Please on Auto Worksheet Setup
- Re: May I called a Programmer if...
- Re: Text box date format
- May I called a Programmer if...
- Re: CONTROL WORD FROM EXCEL
- Re: Macro to find and log all formula errors on all sheets
- RE: Using a value in a cell as a Reference in a formula?
- Re: CONTROL WORD FROM EXCEL
- RE: Using a value in a cell as a Reference in a formula?
- Re: Using a value in a cell as a Reference in a formula?
- Using a value in a cell as a Reference in a formula?
- Re: Find Column Letter - When column header is found
- Re: Macro to insert Rows
- RE: Requesting Help Please on Auto Worksheet Setup
- RE: Save problem with multiple workbooks and event workbook_deactivate
- Save problem with multiple workbooks and event workbook_deactivate
- Re: Find Column Letter - When column header is found
- RE: Inserting a Row after finding a Name in colum
- Re: Autofill with Column as a variable
- Re: Autofill with Column as a variable
- RE: Macro to find and log all formula errors on all sheets
- Re: VB macro code does not save
- Re: Autofill with Column as a variable
- From: abu abdullah........halsaeed85@xxxxxxxxx
- Re: Text box date format
- Requesting Help Please on Auto Worksheet Setup
- Re: formula
- Re: Place wingding on specific coordinates - possible?
- RE: Create scripts from Excel
- Re: Find all in one sheet
- Re: Sound files VBA programmed from Excel
- Re: Find all in one sheet
- Re: Macro to insert Rows
- Re: Find all in one sheet
- Find all in one sheet
- Re: Find Column Letter - When column header is found
- Re: Find Column Letter - When column header is found
- RE: Add subfolders and name - Possible?
- Place wingding on specific coordinates - possible?
- RE: Add subfolders and name - Possible?
- How do I convert an Excel template to an Outlook form
- Add subfolders and name - Possible?
- Re: Text box date format
- Re: =IF Color
- Re: Text box date format
- Re: =IF Color
- RE: Autofill with Column as a variable
- Re: Ribbon visual state gets refreshed when multiple like workbooks opened
- RE: =IF Color
- Re: beforeclose
- Re: Assign Web Query Result to a Variable
- RE: Mutiple comboboxes on user form
- Re: Assign Web Query Result to a Variable
- Re: Assign Web Query Result to a Variable
- Re: Function writing cells
- RE: =IF Color
- Text box date format
- Re: Assign Web Query Result to a Variable
- Mutiple comboboxes on user form
- Re: Assign Web Query Result to a Variable
- beforeclose
- =IF Color
- Re: Tab between ActiveX controls
- Re: Function writing cells
- RE: Macro to find and log all formula errors on all sheets
- Re: Function writing cells
- Re: Assign Web Query Result to a Variable
- Create scripts from Excel
- RE: Autofill with Column as a variable
- Re: Function writing cells
- RE: Assign Web Query Result to a Variable
- Autofill with Column as a variable
- RE: Macro to find and log all formula errors on all sheets
- Re: look up
- Re: Function writing cells
- Re: Function writing cells
- Re: look up
- RE: Function writing cells
- Re: Function writing cells
- RE: Find Column Letter - When column header is found
- Assign Web Query Result to a Variable
- RE: Function writing cells
- RE: Function writing cells
- RE: Function writing cells
- Re: look up
- Re: combining several sheets together
- Function writing cells
- RE: combining several sheets together
- combining several sheets together
- Re: look up
- Ribbon visual state gets refreshed when multiple like workbooks opened
- Re: Getting new empty row ?
- From: Rick Rothstein \(MVP - VB\)
- Re: delete and replace
- Re: Getting new empty row ?
- From: Rick Rothstein \(MVP - VB\)
- Re: Changing number format to remove %
- Re: look up
- RE: Macro to find and log all formula errors on all sheets
- look up
- RE: Help with UDF to search through a table
- RE: Object variable or with block not set Err 91
- Re: Macro to insert Rows
- RE: CONTROL WORD FROM EXCEL
- Re: Command button executes without code???
- RE: Changing number format to remove %
- RE: Macro to find and log all formula errors on all sheets
- Re: Find Column Letter - When column header is found
- RE: Macro to find and log all formula errors on all sheets
- Changing number format to remove %
- Re: Find Column Letter - When column header is found
- Re: Command button executes without code???
- Re: Filtering Dates in a table with input boxes
- Re: Find Column Letter - When column header is found
- Re: Command button executes without code???
- Re: AutoFit
- RE: Inserting a Row after finding a Name in colum
- Re: Selection.Value Error when multiple cells selected
- Re: Problem with (One location = Another location)
- RE: Find Column Letter - When column header is found
- RE: Macro to find and log all formula errors on all sheets
- Inserting a Row after finding a Name in colum
- Re: AutoFit
- Re: delete and replace
- Re: AutoFit
- Re: AutoFit
- Re: AutoFit
- AutoFit
- Re: deleting rows based on criteria
- Custom function to find top sellers
- Re: automatic change cell's colour
- Find Column Letter - When column header is found
- Re: Go to Error (what is this? Is it for findign #DIV! erros in Excel?
- delete and replace
- RE: How do I Get a String... or any variable for that matter?
- Re: How do I Get a String... or any variable for that matter?
- Re: Macro to insert Rows
- Re: looking for true result if number is a %
- From: Rick Rothstein \(MVP - VB\)
- RE: How do I Get a String... or any variable for that matter?
- RE: How do I Get a String... or any variable for that matter?
- RE: How do I Get a String... or any variable for that matter?
- Re: How do I Get a String... or any variable for that matter?
- RE: How do I Get a String... or any variable for that matter?
- RE: How do I Get a String... or any variable for that matter?
- How do I Get a String... or any variable for that matter?
- RE: Macro to find and log all formula errors on all sheets
- looking for true result if number is a %
- RE: VBA - UserForm Reset Option
- Re: All macro are disabled due to encryption?
- Re: VBA Auto correction Issue
- Object variable or with block not set Err 91
- CONTROL WORD FROM EXCEL
- VBA Auto correction Issue
- Re: Getting new empty row ?
- Re: VLOOKUP!@#$%^&*
- Re: VLOOKUP!@#$%^&*
- Re: Macro for adding text from one cell to another cell
- From: Rick Rothstein \(MVP - VB\)
- RE: Chart Question Using VBA
- Re: Getting new empty row ?
- From: Rick Rothstein \(MVP - VB\)
- RE: Assign a folder path to a variable
- Help with UDF to search through a table
- Macro to insert Rows
- RE: Chart Question Using VBA
- RE: Chart Question Using VBA
- Chart Question Using VBA
- Re: multiple ranges in cell notation
- Re: Okay, want to learn this once and for all, how _do_ we get rid of zeros formulaically?
- RE: Getting new empty row ?
- Macro to find and log all formula errors on all sheets
- Sound files VBA programmed from Excel
- Re: Filtering Dates in a table with input boxes
- Re: Filtering Dates in a table with input boxes
- Re: Select method of Range Class failed
- Re: Okay, want to learn this once and for all, how _do_ we get rid
- Re: Okay, want to learn this once and for all, how _do_ we get rid of zeros formulaically?
- From: StargateFanNotAtHome
- Cannot find macro file
- Re: Okay, want to learn this once and for all, how _do_ we get rid of zeros formulaically?
- Assign a folder path to a variable
- Re: Check boxes in drop down box
- Re: Okay, want to learn this once and for all, how _do_ we get rid of zeros formulaically?
- Okay, want to learn this once and for all, how _do_ we get rid of zeros formulaically?
- From: StargateFanNotAtHome
- Re: type mismatch
- Re: Find/Delete skipping rows
- Re: Check boxes in drop down box
- RE: Run-time error when path parameter changed
- RE: run time error 1004
- Update a cell based on the pivot table refresh date
- Re: Problem with (One location = Another location)
- Re: DocumentPrperties Collection
- Re: Macro for adding text from one cell to another cell
- From: Rick Rothstein \(MVP - VB\)
- Re: Getting new empty row ?
- From: Rick Rothstein \(MVP - VB\)
- Re: Getting new empty row ?
- Re: Check boxes in drop down box
- Re: Need Help in cut/paste data from text file to another using excel macro
- RE: VBA - UserForm Reset Option
- Re: Getting new empty row ?
- From: Rick Rothstein \(MVP - VB\)
- Re: Getting new empty row ?
- From: Rick Rothstein \(MVP - VB\)
- Re: Filtering Dates in a table with input boxes
- Re: Check boxes in drop down box
- Re: Filtering Dates in a table with input boxes
- Re: Filtering Dates in a table with input boxes
- Re: Problem with (One location = Another location)
- Re: Filtering Dates in a table with input boxes
- Re: multiple ranges in cell notation
- Re: Check boxes in drop down box
- Re: Getting new empty row ?
- RE: How to store formula in Access table ?
- Re: Can you set 2 ranges to both be from the same cell?
- Re: Filtering Dates in a table with input boxes
- Re: Disabling clipboard prompt
- Can you set 2 ranges to both be from the same cell?
- Re: type mismatch
- Re: Check boxes in drop down box
- Re: Creating a table based on user input
- RE: Filtering Dates in a table with input boxes
- Re: Disabling clipboard prompt
- Re: Filtering Dates in a table with input boxes
- Getting new empty row ?
- Re: Problem with (One location = Another location)
- Re: Filtering Dates in a table with input boxes
- RE: Disable "On Open" macro
- RE: run time error 1004
- run time error 1004
- Disable "On Open" macro
- Re: Filtering Dates in a table with input boxes
- From: Rick Rothstein \(MVP - VB\)
- RE: Filtering Dates in a table with input boxes
- Run-time error when path parameter changed
- Disabling clipboard prompt
- Re: highlights cells that are not a dependents
- From: Rick Rothstein \(MVP - VB\)
- Re: type mismatch
- Re: Problem with (One location = Another location)
- Re: Sort Sheets
- RE: checkbox for commandbar
- RE: Macro for adding text from one cell to another cell
- Re: Looping though sheets in workbook
- Re: Looping though sheets in workbook
- Re: Looping though sheets in workbook
- Filtering Dates in a table with input boxes
- Re: type mismatch
- Re: highlights cells that are not a dependents
- VB macro code does not save
- Re: Selection.Value Error when multiple cells selected
- Looping though sheets in workbook
- Problem with (One location = Another location)
- Re: type mismatch
- Re: Terminology Clarification: Is It Correct For A Spreadsheet Contain
- From: dustinbrearton via OfficeKB.com
- Re: Selection.Value Error when multiple cells selected
- Re: type mismatch
- Re: Terminology Clarification: Is It Correct For A Spreadsheet Containing VBA Routines To Be Called A Macro?
- Re: Terminology Clarification: Is It Correct For A Spreadsheet Contain
- Re: email code
- Re: type mismatch
- RE: type mismatch
- Re: type mismatch
- Re: type mismatch
- RE: Terminology Clarification: Is It Correct For A Spreadsheet Contain
- Re: Terminology Clarification: Is It Correct For A Spreadsheet Containing VBA Routines To Be Called A Macro?
- Re: Find/Delete skipping rows
- type mismatch
- Check boxes in drop down box
- email code
- Re: Terminology Clarification: Is It Correct For A Spreadsheet Containing VBA Routines To Be Called A Macro?
- Re: Macro To Avoid Link Update of Open Files
- Re: Macro To Avoid Link Update of Open Files
- Re: Variable cumulative R1C1(??) notation
- Re: Terminology Clarification: Is It Correct For A Spreadsheet Containing VBA Routines To Be Called A Macro?
- Re: Terminology Clarification: Is It Correct For A Spreadsheet Containing VBA Routines To Be Called A Macro?
- RE: Adding sount to a macro
- RE: Sub before and after 'Get External Data"
- Terminology Clarification: Is It Correct For A Spreadsheet Containing VBA Routines To Be Called A Macro?
- Re: Collection of Ranges and Arrays
- Re: Go to Error (what is this? Is it for findign #DIV! erros in Excel?
- Re: Variable cumulative R1C1(??) notation
- RE: Sub before and after 'Get External Data"
- Re: Creating a table based on user input
- Re: Creating a table based on user input
- Re: Variable cumulative R1C1(??) notation
- RE: Sub before and after 'Get External Data"
- RE: automatic change cell's colour
- RE: Adding sount to a macro
- Re: Variable cumulative R1C1(??) notation
- Re: Sort Sheets
- Sub before and after 'Get External Data"
- Re: Problem formatting header font size
- Re: Creating a table based on user input
- Re: Sort Sheets
- Re: multiple ranges in cell notation
- Re: Sort Sheets
- Re: Variable cumulative R1C1(??) notation
- Problem formatting header font size
- Creating a table based on user input
- automatic change cell's colour
- Variable cumulative R1C1(??) notation
- Go to Error (what is this? Is it for findign #DIV! erros in Excel?
- Sort Sheets
- RE: Loop through files in a folder and unprotect sheets
- Re: Loop through files in a folder and unprotect sheets
- Re: WorkSheet Selecteion Chage Event to prompt Input Box
- Re: ComboBox last selection
- Re: ComboBox last selection
- Re: Adding time by a Numerical Value
- VLOOKUP!@#$%^&*
- WorkSheet Selecteion Chage Event to prompt Input Box
- Re: deleting rows based on criteria
- Re: deleting rows based on criteria
- Re: deleting rows based on criteria
- Re: deleting rows based on criteria
- Re: Selectblank cells
- Re: Determining which Print Button was clicked
- Re: Date format cannot change
- Re: Date format cannot change
- Re: vba xcel
- Re: deleting rows based on criteria
- Re: Selectblank cells
- Re: Command button executes without code???
- Re: capturing the values from a combo box into an xml file
- Re: deleting rows based on criteria
- deleting rows based on criteria
- Determining which Print Button was clicked
- Re: highlights cells that are not a dependents
- From: Rick Rothstein \(MVP - VB\)
- vba xcel
- RE: How to create a function?
- Selectblank cells
- Command button executes without code???
- Re: multiple ranges in cell notation
- Re: multiple ranges in cell notation
- Re: multiple ranges in cell notation
- Re: List Box Columns
- RE: VBA - UserForm Reset Option
- Re: List Box Columns
- Re: Find/Delete skipping rows
- Re: multiple ranges in cell notation
- Re: multiple ranges in cell notation
- RE: multiple ranges in cell notation
- RE: selecting relative ranges
- Re: multiple ranges in cell notation
- Re: Adding time by a Numerical Value
- multiple ranges in cell notation
- Re: selecting relative ranges
- Re: List Box Columns
- capturing the values from a combo box into an xml file
- From: DowningDevelopments
- Re: Adding time by a Numerical Value
- RE: Find/Delete skipping rows
- Re: Refresh Pivot Tables without refreshing functions
- Re: List Box Columns
- Re: Tab between ActiveX controls
- Re: Adding time by a Numerical Value
- Re: Adding time by a Numerical Value
- RE: VBA - UserForm Reset Option
- RE: Find Text in Cell and Copy
- RE: Find Text in Cell and Copy
- Re: Refresh Pivot Tables without refreshing functions
- RE: Find Text in Cell and Copy
- Re: List Box Columns
- RE: VBA - UserForm Reset Option
- RE: Find Text in Cell and Copy
- Re: Error when running VBA Help's Find method example
- Re: List Box Columns
- Refresh Pivot Tables without refreshing functions
- Re: List Box Columns
- Adding time by a Numerical Value
- Re: Macro not running correctly
- RE: Attn: BOB BRIDGES
- RE: Need Help
- Macro not running correctly
- Re: Find/Delete skipping rows
- RE: List Box
- RE: Assigning string values to a range - SOLVED
- Re: Restrict Prompting for Macro Security
- Attn: BOB BRIDGES
- RE: List Box Columns
- Re: Error when running VBA Help's Find method example
- Re: Code lagging with LastRow
- Find/Delete skipping rows
- RE: Code lagging with LastRow
- Re: Convert text to number
- RE: Assigning string values to a range
- Re: Error when running VBA Help's Find method example
- RE: Adding sount to a macro
- RE: Adding sount to a macro
- RE: VBA - UserForm Reset Option
- Re: Error when running VBA Help's Find method example
- Re: Show userform from another workbook
- Assigning string values to a range
- RE: Need Help
- RE: Adding sount to a macro
- Re: selecting relative ranges
- Error when running VBA Help's Find method example
- Code lagging with LastRow
- Print Area Pivot Table
- RE: Selection.Value Error when multiple cells selected
- Re: MACRO QUESTION ????
- RE: Adding sount to a macro
- selecting relative ranges
- RE: Need Help
- RE: maintaining the value of a variable outside of an if construct...
- Re: Add pdf attachment to new mail
- RE: Convert text to number
- Re: Delelting previous row
- RE: Find Column without Changing Refs in vb
- Re: MACRO QUESTION ????
- Re: Find first non-blank cell
- Re: How to use the worksheetfunction Vlookup
- RE: Sheets to new WorkBook
- maintaining the value of a variable outside of an if construct...
- RE: Delelting previous row
- RE: Sheets to new WorkBook
- Re: Expected end of statement error
- Re: Delelting previous row
- RE: Worksheet Listbox selected item?
- RE: Sheets to new WorkBook
- Expected end of statement error
- RE: VBA - UserForm Reset Option
- Re: Delelting previous row
- RE: Adding sount to a macro
- RE: Path Name issue for file opened from Z drive
- RE: Delelting previous row
- RE: Selection.Value Error when multiple cells selected
- RE: Path Name issue for file opened from Z drive
- Re: Delelting previous row
- RE: VBA - UserForm Reset Option
- Re: Delelting previous row
- Re: highlights cells that are not a dependents
- RE: highlights cells that are not a dependents
- RE: Path Name issue for file opened from Z drive
- RE: Sheets to new WorkBook
- RE: Delelting previous row
- Re: Selection.Value Error when multiple cells selected
- RE: No borders/gridlines around some cells
- Delelting previous row
- Re: Restrict Prompting for Macro Security
- RE: Selection.Value Error when multiple cells selected
- Re: Selection.Value Error when multiple cells selected
- From: dustinbrearton via OfficeKB.com
- Re: Selection.Value Error when multiple cells selected
- From: dustinbrearton via OfficeKB.com
- Re: MACRO QUESTION ????
- RE: Some Excel dates can't be imported into sql server?
- The best way to import data from Access (Performance) ??
- Path Name issue for file opened from Z drive
- RE: Adding sount to a macro
- Selection.Value Error when multiple cells selected
- RE: Macro for Opening Reuters, Opening Excel File, Closing Excel F
- Re: Copy All Workbooks Sheets(2) Formats & Values only from Folder A t
- Re: Paste year as a specific date
- Re: Paste year as a specific date
- From: Rick Rothstein \(MVP - VB\)
- Re: Inconsistent behavior when applying conditional formats
- Re: Paste year as a specific date
- Sheets to new WorkBook
- RE: Boolean Variable Definition
- Some Excel dates can't be imported into sql server?
- Re: Unload a UserForm
- Adding sount to a macro
- Re: Loop through files in a folder and unprotect sheets
- RE: Divide two numbers in data subtotal function
- Paste year as a specific date
- Re: highlights cells that are not a dependents
- From: Rick Rothstein \(MVP - VB\)
- Boolean Variable Definition
- Re: change named range
- RE: VBA - UserForm Reset Option
- Re: Loop Macro??
- RE: Loop through files in a folder and unprotect sheets
- List Box
- Re: Collection of Ranges and Arrays
- Follow hyperlink to show form
- RE: Adding sound
- RE: VBA - UserForm Reset Option
- Re: When changing document information how do you show the date an
- RE: Copy All Workbooks Sheets(2) Formats & Values only from Folder A t
- Re: When changing document information how do you show the date an
- RE: No borders/gridlines around some cells
- Re: Subtract day and time w/o weekends or holidays
- Re: excel date format problem
- RE: Adding sound
- Re: how to "synchronize" VBProjects & VBA.Userforms?
- Re: When changing document information how do you show the date and t.
- From: Rick Rothstein \(MVP - VB\)
- Re: change named range
- Adding sound
- RE: Need Help
- Re: Get rid of SaveAs prompts
- Re: MACRO QUESTION ????
- Re: Unload a UserForm
- RE: Copy Column data to Page Header
- Re: Restrict Prompting for Macro Security
- Re: userform comments
- Re: userform comments
- Re: Unload a UserForm
- RE: When changing document information how do you show the date and t.
- Re: Unload a UserForm
- Re: Loop through files in a folder and unprotect sheets
- Re: userform comments
- RE: Loop through files in a folder and unprotect sheets
- RE: Find first non-blank cell
- Re: userform comments
- Re: userform comments
- excel date format problem
- Re: Find first non-blank cell
- RE: Divide two numbers in data subtotal function
- Re: Find first non-blank cell
- RE: Graph with variable range
- Re: Restrict Prompting for Macro Security
- userform comments
- RE: Click Colored Cell -> UserForm.Show Question.
- RE: How to store formula in Access table ?
- Re: Restrict Prompting for Macro Security
- Re: Restrict Prompting for Macro Security
- Re: Unload a UserForm
- Re: MACRO QUESTION ????
- Find first non-blank cell
- RE: Graph with variable range
- Re: Vlookup and print loop
- Re: Loop through files in a folder and unprotect sheets
- Restrict Prompting for Macro Security
- Re: Loop Macro??
- Re: Loop Macro??
- Re: MACRO QUESTION ????
- Unload a UserForm
- Re: VLOOKUP Object error
- RE: Loop through files in a folder and unprotect sheets
- RE: Loop through files in a folder and unprotect sheets
- RE: Loop through files in a folder and unprotect sheets
- Re: Vlookup and print loop
- Re: Show userform from another workbook
- Re: "Compile Error: ByRef argument type mismatch" when calling my func
- Re: Rightborder
- Re: Loop Macro??
- Re: Vlookup and print loop
- Copy All Workbooks Sheets(2) Formats & Values only from Folder A to Folder B
- Re Post - Please Help (Excel WebBrowser Control)
- Re: MACRO QUESTION ????
- Divide two numbers in data subtotal function
- Re: xlDialog to select Cell/Range
- Rightborder
- Re: MACRO QUESTION ????
- RE: Loop through files in a folder and unprotect sheets
- Re: Vlookup and print loop
- RE: xlDialog to select Cell/Range
- RE: Loop through files in a folder and unprotect sheets
- Re: MACRO QUESTION ????
- RE: Copy Column data to Page Header
- RE: Copy Column data to Page Header
- Re: MACRO QUESTION ????
- Re: Date format cannot change
- Re: how to "synchronize" VBProjects & VBA.Userforms?
- Re: MACRO QUESTION ????
- No borders/gridlines around some cells
- RE: Loop Macro??
- Re: Using case
- RE: Using case
- Re: Vlookup and print loop
- Re: Get rid of SaveAs prompts
- RE: Using case
- Graph with variable range
- xlDialog to select Cell/Range
- MACRO QUESTION ????
- Using case
- Re: Vlookup and print loop
- Re: Get rid of SaveAs prompts
- Increase the number of lines buffered in the Immediate Window?
- Get rid of SaveAs prompts
- VLOOKUP Object error
- Re: Date format cannot change
- Re: Vlookup and print loop
- Re: how to "synchronize" VBProjects & VBA.Userforms?
- Re: Select method of Range Class failed
- Re: Date format cannot change
- How to store formula in Access table ?
- Show userform from another workbook
- RE: highlights cells that are not a dependents
- RE: Validation list driving macros
- RE: Copy Column data to Page Header
- RE: Macros
- how to "synchronize" VBProjects & VBA.Userforms?
- RE: Aha! I have it!
- RE: Copy Column data to Page Header
- RE: Loop through files in a folder and unprotect sheets
- highlights cells that are not a dependents
- Re: Access a Variable from the Worksheet
- Macros
- RE: Formatting columns of data with alternate font colours
- RE: Formatting columns of data with alternate font colours
- RE: filtering unique value
- RE: Need general directions
- Loop through files in a folder and unprotect sheets
- Re: Copy Destination parameter issue
- Re: Check hour format
- Re: Access a Variable from the Worksheet
- RE: Formatting columns of data with alternate font colours
- RE: Formatting columns of data with alternate font colours
- RE: Copy Destination parameter issue
- Updating path in defined name
- RE: Copy Column data to Page Header
- Formatting columns of data with alternate font colours
- Copy Destination parameter issue
- Access a Variable from the Worksheet
- Re: Using VBA to sort a column of data
- Re: Storing configuration data in XLA file
- RE: How to create a function?
- How to create a function?
- Validation list driving macros
- RE: Need general directions
- Re: ComboBox last selection
- Re: Storing configuration data in XLA file
- Re: How do I activate the visual basic editor in Excel 2007 ?
- RE: Excel to Word Macro
- Re: Splitting one single cell into pieces
- RE: Need general directions
- RE: Workbook_Open Event won't work
- RE: ComboBox last selection
- Workbook_Open Event won't work
- RE: ComboBox last selection
- Re: Saving changes to Excel file when using VSTO
- Storing configuration data in XLA file
- filtering unique value
- RE: How do I activate the visual basic editor in Excel 2007 ?
- RE: Excel to Word Macro
- Re: Copy and Paste in Macro
- Re: remove button
- From: Rick Rothstein \(MVP - VB\)
- RE: remove button
- How do I activate the visual basic editor in Excel 2007 ?
- Re: remove button
- From: Rick Rothstein \(MVP - VB\)
- Re: remove button
- From: Rick Rothstein \(MVP - VB\)
- Re: remove button
- From: Rick Rothstein \(MVP - VB\)
- RE: Date format cannot change
- Re: remove button
- Re: Add comment to command button
- From: Rick Rothstein \(MVP - VB\)
- RE: remove button
- RE: Sendkey not working
- Re: Splitting one single cell into pieces
- RE: Sendkey not working
- Re: Splitting one single cell into pieces
- Re: remove button
- From: Rick Rothstein \(MVP - VB\)
- Aha! I have it!
- Re: Copy Formula down x Number of rows
- From: Rick Rothstein \(MVP - VB\)
- Re: Add comment to command button
- Copy Formula down x Number of rows
- remove button
- RE: What am I missing - Workbooks.Open
- RE: What am I missing - Workbooks.Open
- Excel to Word Macro
- Re: FUNCTION SYNTAX
- From: Rick Rothstein \(MVP - VB\)
- RE: What am I missing (Opening Workbooks)
- RE: What am I missing - Workbooks.Open
- RE: What am I missing - Workbooks.Open
- RE: What am I missing - Workbooks.Open
- RE: Select method of Range Class failed
- Re: baffling find method problems
- RE: Find Column without Changing Refs in vb
- RE: How To Insert 3 Rows and Total
- RE: What am I missing - Workbooks.Open
- RE: What am I missing - Workbooks.Open
- Re: FUNCTION SYNTAX
- RE: What am I missing - Workbooks.Open
- RE: What am I missing - Workbooks.Open
- RE: Copy Column data to Page Header
- Need general directions
- RE: What am I missing - Workbooks.Open
- RE: What am I missing (Opening Workbooks)
- Find Column without Changing Refs in vb
- RE: Worksheet Listbox selected item?
- ComboBox last selection
- RE: VBA - UserForm Reset Option
- RE: Math and action via VBA
- VBA - UserForm Reset Option
- Re: Programmatically removing data filters
- RE: Formatting cells within VBA
- RE: Formatting cells within VBA
- RE: Worksheet Listbox selected item?
- RE: Select method of Range Class failed
- Re: Programmatically removing data filters
- RE: Formatting cells within VBA
- Re: Programmatically removing data filters
- Excel XP: sending data to SQL Server 2005
- Worksheet Listbox selected item?
- RE: "Compile Error: ByRef argument type mismatch" when calling my func
- Formatting cells within VBA
- RE: What am I missing - Workbooks.Open
- Re: Const or Variable that doesn't change
- RE: List Box Columns
- Re: baffling find method problems
- RE: OLE Question
- RE: baffling find method problems
- Re: Saving changes to Excel file when using VSTO
- "Compile Error: ByRef argument type mismatch" when calling my function from another module
- RE: baffling find method problems
- Copy Column data to Page Header
- RE: Need Help in cut/paste data from text file to another using excel
- RE: Macro for Opening Reuters, Opening Excel File, Closing Excel File
- RE: Challenging Task Ahead
- RE: Const or Variable that doesn't change
- Re: Programmatically removing data filters
- Re: Sumproduct troubleshooting (new to me)
- RE: What am I missing (Opening Workbooks)
- Re: Const or Variable that doesn't change
- Iterative process of running queries frequently abends for no clr.
- What am I missing - Workbooks.Open
- baffling find method problems
- Re: Programmatically removing data filters
- RE: Select method of Range Class failed
- RE: Const or Variable that doesn't change
- RE: Creating new workbook from different workbook
- What am I missing (Opening Workbooks)
- RE: Inserting Rows - Complicated
- RE: List Box Columns
- Const or Variable that doesn't change
- RE: OLE Question
- RE: Select method of Range Class failed
- RE: Wait time between Saving and other activity
- Re: Select method of Range Class failed
- RE: Find Cells with Specific Format
- RE: Select method of Range Class failed
- Re: how to use variable that should be in "quotes"
- Need Help in cut/paste data from text file to another using excel macro
- Re: How to use the worksheetfunction Vlookup
- Find Cells with Specific Format
- Macro for Opening Reuters, Opening Excel File, Closing Excel File
- Re: Sumproduct troubleshooting (new to me)
- Select method of Range Class failed
- RE: Inserting Rows - Complicated
- RE: Creating new workbook from different workbook
- RE: Creating new workbook from different workbook
- Re: Programmatically removing data filters
- Re: how to use variable that should be in "quotes"
- RE: Inserting Rows - Complicated
- RE: Programmatically removing data filters
- RE: Formula, quotes, and variable
- Re: VBA: How do I find a value within a selected range?
- RE: VBA: How do I find a value within a selected range?
- OLE Question
- RE: Programmatically removing data filters
- RE: Formula, quotes, and variable
- VBA: How do I find a value within a selected range?
- RE: Inserting Rows - Complicated
- RE: Click Colored Cell -> UserForm.Show Question.
- Re: Wait time between Saving and other activity
- Re: Add a name based on a number
- RE: Inserting Rows - Complicated
- Re: How to use the worksheetfunction Vlookup
- RE: Formula, quotes, and variable
- RE: Inserting Rows - Complicated
- Wait time between Saving and other activity
- RE: Trying to get worksheefunction match to work
- Re: how to use variable that should be in "quotes"
- Re:PageSetup Class
- RE: List Box Columns
- RE: Inserting Rows - Complicated
- RE: Inserting Rows - Complicated
- RE: Inserting Rows - Complicated
- Formula, quotes, and variable
- RE: Programmatically removing data filters
- RE: Programmatically removing data filters
- RE: how to use variable that should be in "quotes"
- Re: Programmatically removing data filters
- Re: Launch Excel On Event?
- RE: Creating new workbook from different workbook
- Re: Sumproduct troubleshooting (new to me)
- RE: Creating new workbook from different workbook
- RE: Programmatically removing data filters
- how to use variable that should be in "quotes"
- RE: Inserting Rows - Complicated
- Re: Why won't my loop recognize empty cells?
- RE: Click Colored Cell -> UserForm.Show Question.
- Re: How to retreive the name of a named cell in an excel macro
- Programmatically removing data filters
- Re: How to use the worksheetfunction Vlookup
- Inserting Rows - Complicated
- Filtering with VBA
- RE: Trying to get worksheefunction match to work
- Click Colored Cell -> UserForm.Show Question.
- RE: Add a name based on a number
- Importing XML through web-based query
- Re: How to use the worksheetfunction Vlookup
- Re: How to use the worksheetfunction Vlookup
- Re: Get All Files from a Directory
- Re: How to use the worksheetfunction Vlookup
- RE: Referencing Database Fields
- Re: Finding the first cell in a column that is not hidden
- Get All Files from a Directory
- RE: List Box Columns
- How to use the worksheetfunction Vlookup
- Re: Launch Excel On Event?
- RE: Something in this is causing a crash
- RE: Trying to get worksheefunction match to work
- RE: Slow spreadsheet
- Re: Problem using Copy:=Destionation across different workbooks
- RE: Add a name based on a number
- Slow spreadsheet
- RE: MATCH
- RE: Add a name based on a number
- RE: Math and action via VBA
- RE: Add a name based on a number
- RE: Sendkey not working
- RE: Trying to get worksheefunction match to work
- RE: How to retreive the name of a named cell in an excel macro
- RE: How to retreive the name of a named cell in an excel macro
- Trying to get worksheefunction match to work
- RE: How to retreive the name of a named cell in an excel macro
- Re: Tab between ActiveX controls
- Re: Sumproduct troubleshooting (new to me)
- RE: Sendkey not working
- RE: Code error to mirror data from one table to another
- Re: Why won't my loop recognize empty cells?
- From: Rick Rothstein \(MVP - VB\)
- How to retreive the name of a named cell in an excel macro
- MATCH
- Sendkey not working
- RE: Using VBA to sort a column of data
- RE: Problem using Copy:=Destionation across different workbooks
- Re: Finding the first cell in a column that is not hidden
- From: Rick Rothstein \(MVP - VB\)
- Re: REPOST: Need help with XL2007 FormatConditions, please?
- Re: How do I set an environment variable to a string
- Re: Why won't my loop recognize empty cells?
- RE: Using VBA to sort a column of data
- Combo Box Event code self triggering??
- RE: VBA in a webpage
- Re: Using VBA to sort a column of data
- Re: Problem using Copy:=Destionation across different workbooks
- Problem using Copy:=Destionation across different workbooks
- ActiveX Toggles
- Re: Why won't my loop recognize empty cells?
- Re: Trying to cobble together two bis of code (Unsuccessfully)
- RE: Application.CutCopyMode = False
- Tab between ActiveX controls
- Re: Macro To Avoid Link Update of Open Files
- Launch Excel On Event?
- RE: Application.CutCopyMode = False
- Re: How do I set an environment variable to a string
- RE: What in the edited code below makes it crash?????
- RE: Something in this is causing a crash
- Re: How do I set an environment variable to a string
- Macro To Avoid Link Update of Open Files
- Re: Finding the first cell in a column that is not hidden
- Re: Why won't my loop recognize empty cells?
- Re: Finding the first cell in a column that is not hidden
- From: Rick Rothstein \(MVP - VB\)
- Re: How do I set an environment variable to a string
- RE: VBA in a webpage
- Re: How do I set an environment variable to a string
- Using VBA to sort a column of data
- Re: Why won't my loop recognize empty cells?
- From: Rick Rothstein \(MVP - VB\)
- Using VBA to sort a column of data
- Re: Application.CutCopyMode = False
- Re: Why won't my loop recognize empty cells?
- Re: FUNCTION SYNTAX
- Finding the first cell in a column that is not hidden
- Re: Trying to cobble together two bis of code (Unsuccessfully)
- RE: command button to run an Acess query- I know this can be done
- From: chris23892 via OfficeKB.com
- RE: Subtract day and time w/o weekends or holidays
- Re: Convert macro that runs against entire column to run in current ro
- Re: How do I set an environment variable to a string
- Why won't my loop recognize empty cells?
- Re: How do I set an environment variable to a string
- RE: inverted commas
- Re: How do I set an environment variable to a string
- RE: Sorting an indeterminable range of data
- Re: Sorting an indeterminable range of data
- Re: Sorting an indeterminable range of data
- RE: Sorting an indeterminable range of data
- Re: FUNCTION SYNTAX
- From: Rick Rothstein \(MVP - VB\)
- Re: How do I set an environment variable to a string
- Something in this is causing a crash
- Re: Retrieving all worksheet names into a new worksheet
- Application.CutCopyMode = False
- RE: command button to run an Acess query- I know this can be done
- RE: For...Each loop not working
- RE: delimited text export
- Creating new workbook from different workbook
- Re: What in the edited code below makes it crash?????
- Add a name based on a number
- RE: vba pivot table sorting
- Re: FUNCTION SYNTAX
- From: Rick Rothstein \(MVP - VB\)
- What in the edited code below makes it crash?????
- Re: Trying to cobble together two bis of code (Unsuccessfully)
- Re: How do I set an environment variable to a string
- RE: Freeze the value of one cell for secs while worksheet auto upd
- Challenging Task Ahead
- Re: AdvanceFilter Problem
- Re: How do I set an environment variable to a string
- RE: Freeze the value of one cell for secs while worksheet auto upd
- RE: Find Text in Cell and Copy
- HDI capture multiple selections from a comi-box into cells?
- Re: How To Insert 3 Rows and Total
- RE: Find Text in Cell and Copy
- command button to run an Acess query- I know this can be done
- From: chris23892 via OfficeKB.com
- count unique values in a col
- RE: How To Insert 3 Rows and Total
- Re: Trying to cobble together two bis of code (Unsuccessfully)
- Re: Random Range with no duplicates
- Re: FUNCTION SYNTAX
- RE: Freeze the value of one cell for secs while worksheet auto upd
- How To Insert 3 Rows and Total
- Re: Splitting one single cell into pieces
- RE: Find Text in Cell and Copy
- Trying to cobble together two bis of code (Unsuccessfully)
- Re: Invalid name Error
- Re: Invalid name Error
- Re: Splitting one single cell into pieces
- RE: List Box Columns
- Find Text in Cell and Copy
- inverted commas
- Splitting one single cell into pieces
- how to bind access database to listview
- RE: Invalid name Error
- Re: FUNCTION SYNTAX
- Link excel 2007 chart formatting
- RE: Collection vs. Array of Arrays, nszim
- Invalid name Error
- Variant Array - Possible Bug?
- Re: If Statements
- RE: Code error to mirror data from one table to another
- Re: FUNCTION SYNTAX
- Re: If Statements
- From: Rick Rothstein \(MVP - VB\)
- If Statements
- Re: User form code question
- Re: User form code question
- RE: User form code question
- RE: Freeze the value of one cell for secs while worksheet auto updates
- Re: User form code question
- Re: User form code question
- From: Rick Rothstein \(MVP - VB\)
- Freeze the value of one cell for secs while worksheet auto updates
- User form code question
- Re: Third party .xla interferes with Worksheet_Change
- Re: FUNCTION SYNTAX
- From: Rick Rothstein \(MVP - VB\)
- Re: Prompt for cells on open
- RE: Math and action via VBA
- Prompt for cells on open
- RE: FUNCTION SYNTAX
- RE: Code error to mirror data from one table to another
- Re: Accessing Data from an oracle database on a different server using
- RE: using filename or a cell value for a custom menu
- FUNCTION SYNTAX
- using filename or a cell value for a custom menu
- Re: How do I set an environment variable to a string
- Re: AdvanceFilter Problem
- Re: How do I set an environment variable to a string
- RE: Date format cannot change
- Re: Date format cannot change
- RE: editing/deleting text
- Date format cannot change
- Re: find concatenated values question
- Re: Add comment to command button
- From: Rick Rothstein \(MVP - VB\)
- RE: find concatenated values question
- Re: Copy text box contents
- From: Rick Rothstein \(MVP - VB\)
- Re: How do I set an environment variable to a string
- Re: macro web
- Re: Add comment to command button
- RE: Substitute the value from another Workbook
- Re: find concatenated values question
- editing/deleting text
- find concatenated values question
- Re: Sumproduct troubleshooting (new to me)
- RE: List Box Columns
- Re: Excel Checkbox Help
- Substitute the value from another Workbook
- RE: Listbox problem agaie
- Vlookup to a table on a webpage
- Re: Copy text box contents
- Re: Excel Checkbox Help
- Re: Sumproduct troubleshooting (new to me)
- Re: recordset question
- Re: Call the property of a class using a variable
- RE: Copy text box contents
- RE: recordset question
- RE: recordset question
- RE: Listbox problem agaie
- RE: want to change tab color based on the info in a cell.
- RE: Paste Special, Values only
- RE: Listbox problem agaie
- Copy text box contents
- RE: List Box Columns
- RE: Math and action via VBA
- RE: List Box Columns
- Re: REPOST: Need help with XL2007 FormatConditions, please?
- Listbox problem agaie
- RE: want to change tab color based on the info in a cell.
- Re: want to change tab color based on the info in a cell.
- Re: recordset question
- RE: Code error to mirror data from one table to another
- RE: Convert macro that runs against entire column to run in current ro
- recordset question
- Convert macro that runs against entire column to run in current row
- Re: IIf Function
- From: Rick Rothstein \(MVP - VB\)
- RE: want to change tab color based on the info in a cell.
- Re: How to delete a "return" character (a "box") in cell of imported d
- Re: mod error in VBA
- Re: want to change tab color based on the info in a cell.
- want to change tab color based on the info in a cell.
- RE: Need Help
- RE: Button Problem
- RE: Math and action via VBA
- RE: How do I set an environment variable to a string
- RE: Button Problem
- RE: How do I set an environment variable to a string
- RE: Really Help with existing VBA code...
- Re: mod error in VBA
- Button Problem
- Re: IIf Function
- RE: List Box Columns
- Re: calling a routine to declare variables at start of macro
- RE: write to column A depending on which Radio button is selected.
- Need Help
- Re: Identify cells based on format
- How do I set an environment variable to a string
- How to delete a "return" character (a "box") in cell of imported d
- RE: IIf Function
- RE: List Box Columns
- RE: IIf Function
- RE: Zoom window to selection
- RE: Loop Macro??
- RE: IIf Function
- RE: cell value syntax
- RE: cell value syntax
- IIf Function
- Re: Identify cells based on format
- cell value syntax
- RE: write to column A depending on which Radio button is selected.
- Re: Userform - Return Control Clicked
- RE: Moving text from a line to a new line based on a condition
- Re: Identify cells based on format
- Re: Check hour format
- Re: mod error in VBA
- RE: Whats the difference between usign Named Range and Cells.Find
- Re: Identify cells based on format
- RE: delimited text export
- Re: Check hour format
- RE: Math and action via VBA
- Re: Assigning values from source cells
- Re: how to check if sheet has graphs?
- RE: Moving text from a line to a new line based on a condition
- RE: Eliminating commas if they are first characters in a string
- Assigning values from source cells
- how to check if sheet has graphs?
- RE: Moving text from a line to a new line based on a condition
- RE: mod error in VBA
- Re: How do you document a function (like built in functions) in VBA?
- Check hour format
- mod error in VBA
- RE: Center result on screen
- RE: Find out what windows are open
- Re: For...Each loop not working
- RE: For...Each loop not working
- Re: Eliminating commas if they are first characters in a string
- From: Rick Rothstein \(MVP - VB\)
- RE: For...Each loop not working
- Identify cells based on format
- Center result on screen
- Re: For...Each loop not working
- Re: Eliminating commas if they are first characters in a string
- Really Help with existing VBA code...
- RE: Math and action via VBA
- For...Each loop not working
- List Box Columns
- Re: Pictures in comments Sub MyPix modification ??
- Re: Eliminating commas if they are first characters in a string
- From: Rick Rothstein \(MVP - VB\)
- Re: calling a routine to declare variables at start of macro
- RE: Need assistance with Excel 2007
- Re: Zoom window to selection (further clarification)
- Re: Display Alerts
- Re: Sumproduct troubleshooting (new to me)
- Re: How do i use Xlstat for clustering data into segments
- Re: Eliminating commas if they are first characters in a string
- RE: determine dropdown value
- RE: Zoom window to selection (further clarification)
- RE: Paste Special, Values only
- RE: Eliminating commas if they are first characters in a string
- Re: Eliminating commas if they are first characters in a string
- From: Rick Rothstein \(MVP - VB\)
- RE: Eliminating commas if they are first characters in a string
- Re: Display Alerts
- Re: Eliminating commas if they are first characters in a string
- From: Rick Rothstein \(MVP - VB\)
- determine dropdown value
- RE: Eliminating commas if they are first characters in a string
- RE: Paste Special, Values only
- RE: Paste Special, Values only
- Zoom window to selection (further clarification)
- RE: Loop Macro??
- RE: Watch not working for action on other cells
- PivotTable: How to reset the CurrentPage to (All)
- RE: Moving text from a line to a new line based on a condition
- Need assistance with Excel 2007
- RE: Paste Special, Values only
- Zoom window to selection
- Pictures in comments Sub MyPix modification ??
- RE: Paste Special, Values only
- Re: Eliminating commas if they are first characters in a string
- From: Rick Rothstein \(MVP - VB\)
- How do you document a function (like built in functions) in VBA?
- write to column A depending on which Radio button is selected.
- Watch not working for action on other cells
- Paste Special, Values only
- Loop Macro??
- Re: Can't figure out formula error
- From: Rick Rothstein \(MVP - VB\)
- RE: Eliminating commas if they are first characters in a string
- RE: Eliminating commas if they are first characters in a string
- calling a routine to declare variables at start of macro
- Eliminating commas if they are first characters in a string
- Whats the difference between usign Named Range and Cells.Find
- RE: Math and action via VBA
- delimited text export
- Math and action via VBA
- RE: REPOST: Need help with XL2007 FormatConditions, please?
- Re: Sumproduct troubleshooting (new to me)
- Re: Can't figure out formula error
- Re: Third party .xla interferes with Worksheet_Change
- Re: Position a Window
- Re: Add comment to command button
- From: Rick Rothstein \(MVP - VB\)
- RE: Moving text from a line to a new line based on a condition
- Re: Display Alerts
- Re: Add comment to command button
- From: Rick Rothstein \(MVP - VB\)
- RE: Moving text from a line to a new line based on a condition
- Re: Tiered Pricing Calculations
- How do i use Xlstat for clustering data into segments
- RE: code to navigate IE7 runs on XP but not on Vista
- Find out what windows are open
- Re: Sumproduct troubleshooting (new to me)
- RE: Run Code Line by Line
- Re: Display Alerts
- RE: Concantenating Text with | and ' (vertical slash and single qo
- RE: Disable Auto Calculate w/.enablecalculation?
- RE: Run Code Line by Line
- RE: Run Code Line by Line
- RE: Disable Auto Calculate w/.enablecalculation?
- Re: Tiered Pricing Calculations
- Run Code Line by Line
- Display Alerts
- Re: Sumproduct troubleshooting (new to me)
- RE: code to navigate IE7 runs on XP but not on Vista
- Moving text from a line to a new line based on a condition
- Sumproduct troubleshooting (new to me)
- REPOST: Need help with XL2007 FormatConditions, please?
- RE: Input validation using VBA
- Re: Selecting all cells in a column between two cells
- RE: Disable Auto Calculate w/.enablecalculation?
- Input validation using VBA
- Re: Selecting all cells in a column between two cells
- Disable Auto Calculate w/.enablecalculation?
- Re: help needed with Countif....
- RE: Horizontal to vertical ( 1 row to 1 column )
- Third party .xla interferes with Worksheet_Change
- Horizontal to vertical ( 1 row to 1 column )
- Re: Tiered Pricing Calculations
- WebBrowser Control Question
- Re: paste to word
- Re: Want to delete rows based on a condition
- Re: Using Option buttons with vlookup
- Re: Add comment to command button
- Re: Add comment to command button
- RE: paste to word
- RE: Using Option buttons with vlookup
- RE: Fill a cell with abbreviated text from a list
- RE: Fill a cell with abbreviated text from a list
- RE: Accessing Data from an oracle database on a different server using
- Re: macro web
- RE: creating a function with a for loop
- RE: Creating list of duplicates
- Re: Want to auto filter with date on daily basis
- Accessing Data from an oracle database on a different server using
- AdvanceFilter Problem
- creating a function with a for loop
- From: creating a function with a for loop
- RE: Concatenate
- RE: Concatenate
- RE: Can this be done with VBA ?
- RE: Creating list of duplicates
- Concatenate
- Re: Call the property of a class using a variable
- code to navigate IE7 runs on XP but not on Vista
- Re: Tiered Pricing Calculations
- From: Rick Rothstein \(MVP - VB\)
- RE: Universal open
- Re: Delete row 2 cell criteria
- Re: Delete row 2 cell criteria
- Re: UDF ...VBA Formula built ...please help
- Re: Universal open
- Re: Delete row 2 cell criteria
- Universal open
- Re: Delete row 2 cell criteria
- Re: Delete row 2 cell criteria
- Re: Tiered Pricing Calculations
- Delete row 2 cell criteria
- Using Option buttons with vlookup
- Re: Tiered Pricing Calculations
- From: Rick Rothstein \(MVP - VB\)
- Re: UDF ...VBA Formula built ...please help
- Re: Tiered Pricing Calculations
- Re: Want to delete rows based on a condition
- Re: Can't figure out formula error
- From: Rick Rothstein \(MVP - VB\)
- Re: Add comment to command button
- From: Rick Rothstein \(MVP - VB\)
- Can't figure out formula error
- Add comment to command button
- Re: Pivot Table Refresh
- RE: paste to word
- Re: macro web
- RE: Code error to mirror data from one table to another
- RE: plotting data in separate window
- RE: Controls on Excel Sheets from Control Toolbox
- Re: Trendline color format bug/issue?
- Re: Call the property of a class using a variable
- RE: Locking Excel Sheet with Control Toolbox controls
- Locking Excel Sheet with Control Toolbox controls
- Controls on Excel Sheets from Control Toolbox
- Re: VBA process to run in intervals in Excel
- RE: Listbox problems
- Re: Find SearchOrder?
- RE: Macro
- Need help inserting formula with macro
- Re: Formatting cell base on free form or standard inputs.
- Re: Tiered Pricing Calculations
- RE: VBA store location as variable
- Re: VBA process to run in intervals in Excel
- Re: Calculate the result of an array in vba
- VBA process to run in intervals in Excel
- Import XPS file into Excel
- Calculate the result of an array in vba
- Re: help needed with Countif....
- Fill a cell with abbreviated text from a list
- Re: range.copy not working as expected
- Re: Msgbox button captions
- Re: Trendline color format bug/issue?
- Re: Sorting rows
- RE: Listbox problems
- RE: Find SearchOrder?
- RE: Listbox problems
- Macro
- RE: Msgbox button captions
- Find SearchOrder?
- Msgbox button captions
- Re: UDF ...VBA Formula built ...please help
- Listbox problems
- RE: Concantenating Text with | and ' (vertical slash and single qo
- Re: repost Split fullname into First Middle and Last
- From: Rick Rothstein \(MVP - VB\)
- Re: Split fullname into First Middle and Last
- From: Rick Rothstein \(MVP - VB\)
- Re: repost Split fullname into First Middle and Last
- Re: repost Split fullname into First Middle and Last
- repost Split fullname into First Middle and Last
- Re: Split fullname into First Middle and Last
- Sorting rows
- RE: Concantenating Text with | and ' (vertical slash and single qoute)
- Re: Split fullname into First Middle and Last
- Concantenating Text with | and ' (vertical slash and single qoute)
- Re: help needed with Countif....
- RE: Random Range with no duplicates
- vba pivot table sorting
- Re: help needed with Countif....
- Re: Using a range in a formula
- RE: Modify each cell in selection
- RE: VBA store location as variable
- Re: Tiered Pricing Calculations
- RE: OLEDBConnection Properties
- RE: Modify each cell in selection
- RE: Modify each cell in selection
- VBA: Using a range in a formula
- Modify each cell in selection
- RE: VBA store location as variable
- RE: macro running on timer fails to select proper sheet
- Subtract day and time w/o weekends or holidays
- VBA in a webpage
- help needed with Countif....
- Re: Call the property of a class using a variable
- Re: pass parm to another userform
- Re: pass parm to another userform
- Re: Call the property of a class using a variable
- Re: Tiered Pricing Calculations
- Re: Pivot Table Refresh
- Re: Copy rows based on specific criteria
- RE: 2003 Excel Windows XP to 2007 Excel Windows Vista
- Re: Call the property of a class using a variable
- Re: Tiered Pricing Calculations
- RE: Call the property of a class using a variable
- Re: Cell text color change event
- Re: pass parm to another userform
- Re: Pivot Table Refresh
- RE: Macro to add a new row if text length is over 30
- RE: Macro to add a new row if text length is over 30
- Re: pass parm to another userform
- Re: change custom view when leaving a sheet
- Macro to add a new row if text length is over 30
- RE: Compile Error: variable not defined
- Formatting cell base on free form or standard inputs.
- Re: Can this be done with VBA ?
- Re: Tiered Pricing Calculations
- From: Rick Rothstein \(MVP - VB\)
- Call the property of a class using a variable
- Re: Copy and Paste in Macro
- Re: Changing cursor outline color of active cell
- RE: VBA store location as variable
- Re: Tiered Pricing Calculations
- pass parm to another userform
- Re: A macro locates files on one PC but not another - why?
- Re: Can this be done with VBA ?
- Re: How to check Operating System?
- Re: Tiered Pricing Calculations
- Re: editing .xla files
- Re: Tiered Pricing Calculations
- Re: Tiered Pricing Calculations
- Re: Identifying last filled area ('row') of an array via VBA?
- From: Rick Rothstein \(MVP - VB\)
- Re: autofiltering question and possible logic question
- Re: How to check Operating System?
- RE: A macro locates files on one PC but not another - why?
- Re: A macro locates files on one PC but not another - why?
- From: Rick Rothstein \(MVP - VB\)
- Re: Random Range with no duplicates
- Re: autofiltering question and possible logic question
- Identifying last filled area ('row') of an array via VBA?
- Re: Tiered Pricing Calculations
- From: Rick Rothstein \(MVP - VB\)
- A macro locates files on one PC but not another - why?
- Re: Cell text color change event
- From: Rick Rothstein \(MVP - VB\)
- Re: Tiered Pricing Calculations
- RE: Named Ranged, help please
- Re: Tiered Pricing Calculations
- Cell text color change event
- RE: Random Range with no duplicates
- Can this be done with VBA ?
- RE: Named Ranged, help please
- editing .xla files
- RE: Changing cursor outline color of active cell
- RE: Changing cursor outline color of active cell
- RE: autofiltering question and possible logic question
- Re: Creating a range that indexes in a For loop
- 2003 Excel Windows XP to 2007 Excel Windows Vista
- Re: Random Range with no duplicates
- Re: Tiered Pricing Calculations
- Re: Tips to speed up VBA with several workbooks open.
- Re: Random Range with no duplicates
- Re: change custom view when leaving a sheet
- Re: Tiered Pricing Calculations
- From: Rick Rothstein \(MVP - VB\)
- RE: Mouse Click to Run Macro
- Re: change custom view when leaving a sheet
- Re: Tiered Pricing Calculations
- Re: Missing Zero
- Changing cursor outline color of active cell
- Re: UDF ...VBA Formula built ...please help
- Random Range with no duplicates
- RE: VBA store location as variable
- Pivot Table Refresh
- Disconnected Module in VB
- Re: change custom view when leaving a sheet
- Re: Array declared with the Static keyword clears itself between calls
- Re: Mouse Click to Run Macro
- Re: insert multiple cells every ### rows
- Re: change custom view when leaving a sheet
- Mouse Click to Run Macro
- VBA store location as variable
- Re: insert multiple cells every ### rows
- Re: Tiered Pricing Calculations
- Re: Tips to speed up VBA with several workbooks open.
- From: HammerJoe@xxxxxxxxx
- Re: How to check Operating System?
- Re: Tips to speed up VBA with several workbooks open.
- From: HammerJoe@xxxxxxxxx
- Range("E8:E53").FillRight how can I make this .Value?
- insert multiple cells every ### rows
- change custom view when leaving a sheet
- Re: How to check Operating System?
- Re: Split fullname into First Middle and Last
- From: Rick Rothstein \(MVP - VB\)
- Re: Selecting all cells in a column between two cells
- Interop over Portable excel
- RE: Selecting all cells in a column between two cells
- Re: SaveAs CSV - Pipe Delimited
- Re: How to check Operating System?
- Re: Two parts of the same thing
- Re: Two parts of the same thing
- Re: How to check Operating System?
- macro web
- Re: Missing Zero
- From: Rick Rothstein \(MVP - VB\)
- RE: Recorded Macro Works, Code Doesn't
- Re: Two parts of the same thing
- RE: Two parts of the same thing
- Re: How to check Operating System?
- Re: Two parts of the same thing
- RE: Label Click to open Word Document
- RE: How can I simply the following, must I keep .Select?
- Re: character.delete doesn't work
- RE: Creating list of duplicates
- Two parts of the same thing
- Re: character.delete doesn't work
- Re: What's wrong here?
- Re: Whats wrong with this? MyWBAccRep.Sheets("Volumes").Cells.Find("latest").Copy.Offset(0, 1).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- RE: Label Click to open Word Document
- Re: Label Click to open Word Document
- Re: Array declared with the Static keyword clears itself between calls
- RE: Label Click to open Word Document
- Re: How to check Operating System?
- Re: character.delete doesn't work
- RE: Named Ranged, help please
- RE: Programmatically copying array formulas
- Named Ranged, help please
- Re: character.delete doesn't work
- Re: Combo boxes go all funny!
- RE: Update Excel Objects
- Re: How to check Operating System?
- Re: Copying with .Value
- Re: character.delete doesn't work
- RE: Calendar Issue - Out of Memery
- Calendar Issue - Out of Memery
- RE: How to check Operating System?
- Re: Copying with .Value
- RE: Programmatically copying array formulas
- RE: Copying with .Value
- Re: Array declared with the Static keyword clears itself between c
- RE: How to check Operating System?
- Creating list of duplicates
- How to check Operating System?
- RE: Programmatically copying array formulas
- Re: Sum the first character in a range
- Copying with .Value
- range.copy not working as expected
- Re: Array declared with the Static keyword clears itself between calls
- Re: OnError - what generated the error?
- Programmatically copying array formulas
- Label Click to open Word Document
- Re: How do I cut/copy paste without using the clipboard?
- RE: Array declared with the Static keyword clears itself between calls
- How can I simply the following, must I keep .Select?
- Re: How do I cut/copy paste without using the clipboard?
- RE: import table access to excel
- Re: Missing Zero
- RE: How do I cut/copy paste without using the clipboard?
- Re: Protecting & Unportecting the sheet.
- How do I cut/copy paste without using the clipboard?
- Re: character.delete doesn't work
- Re: Protecting & Unportecting the sheet.
- Re: Split fullname into First Middle and Last
- Array declared with the Static keyword clears itself between calls
- Re: Split fullname into First Middle and Last
- RE: Find cells containing multiple values in random order
- Re: Protecting & Unportecting the sheet.
- Re: Split fullname into First Middle and Last
- Re: Split fullname into First Middle and Last
- Re: Whats wrong with this? MyWBAccRep.Sheets("Volumes").Cells.Find("latest").Copy.Offset(0, 1).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- Re: Split fullname into First Middle and Last
- From: Rick Rothstein \(MVP - VB\)
- Whats wrong with this? MyWBAccRep.Sheets("Volumes").Cells.Find("latest").Copy.Offset(0, 1).PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks:=False, Transpose:=False
- character.delete doesn't work
- Re: Split fullname into First Middle and Last
- From: Rick Rothstein \(MVP - VB\)
- Re: Split fullname into First Middle and Last
- RE: Find cells containing multiple values in random order
- Re: Protecting & Unportecting the sheet.
- RE: how to run macro in double click on a particular cell
- Re: Listbox how to get to appear left of cell?
- Re: Split fullname into First Middle and Last
- Re: Missing Zero
- From: Rick Rothstein \(MVP - VB\)
- RE: Macro
- RE: Macro
- Re: Macro
- Re: Macro
- RE: Protecting & Unportecting the sheet.
- Missing Zero
- Re: Split fullname into First Middle and Last
- From: Rick Rothstein \(MVP - VB\)
- Protecting & Unportecting the sheet.
- Re: Split fullname into First Middle and Last
- From: Rick Rothstein \(MVP - VB\)
- Find cells containing multiple values in random order
- Re: Split fullname into First Middle and Last
- Re: Copy rows based on specific criteria
- how to run macro in double click on a particular cell
- Excel shape changes in printing
- Re: How to disable all controls in form?
- Re: toolbars - button
- import table access to excel
- Re: Tiered Pricing Calculations
- From: Rick Rothstein \(MVP - VB\)
- Re: Tips to speed up VBA with several workbooks open.
- Re: Sum the first character in a range
- Listbox how to get to appear left of cell?
- Re: How to disable all controls in form?
- Tips to speed up VBA with several workbooks open.
- From: HammerJoe@xxxxxxxxx
- Tiered Pricing Calculations
- Re: toolbars - button
- toolbars - button
- How to disable all controls in form?
- Re: Sum the first character in a range
- Re: UDF ...VBA Formula built ...please help
- Re: Split fullname into First Middle and Last
- Re: Split fullname into First Middle and Last
- Re: How to open workbooks in different Excel?
- RE: Split fullname into First Middle and Last
- Re: How to open workbooks in different Excel?
- RE: Compile Error: variable not defined
- Split fullname into First Middle and Last
- How to open workbooks in different Excel?
- RE: running a macro in Microsoft Project
- RE: Compile Error: variable not defined
- Re: first non blank cell
- From: Rick Rothstein \(MVP - VB\)
- Re: UDF ...VBA Formula built ...please help
- running a macro in Microsoft Project
- Re: OnError - what generated the error?
- Re: pop up during calculation
- Re: first non blank cell
- Re: OnError - what generated the error?
- RE: pop up during calculation
- Re: first non blank cell
- first non blank cell
- Re: Different Results running the same macro??
- RE: Multiple pivot tables on same sheet with common report filter
- RE: pop up during calculation
- RE: OnError - what generated the error?
- Re: Vlookup
- Re: Vlookup
- Re: picture Format in excel
- RE: Vlookup
- RE: error 9 'subscript out of range' using workshhets function
- picture Format in excel
- Re: Loop through expanding range
- Re: Loop through expanding range
- RE: error 9 'subscript out of range' using workshhets function
- RE: error 9 'subscript out of range' using workshhets function
- Multiple pivot tables on same sheet with common report filter
- Re: Loop through expanding range
- error 9 'subscript out of range' using workshhets function
- Re: Loop through expanding range
- RE: Loop through expanding range
- Re: Macro to hide empty worksheets
- Loop through expanding range
- Re: A search tool to the wishlist
- Re: OnError - what generated the error?
- Re: want to change cell background using RGB data in a worksheet
- Re: A search tool to the wishlist
- Re: Sum the first character in a range
- From: Rick Rothstein \(MVP - VB\)
- Re: OnError - what generated the error?
- Re: Macro to hide empty worksheets
- OnError - what generated the error?
- From: Robeyx via OfficeKB.com
- Re: Collection of Ranges and Arrays
- RE: pop up during calculation
- Re: pop up during calculation
- Re: pop up during calculation
- pop up during calculation
- Re: Sum the first character in a range
- car domain com domainregistrierung net an der domaene anmelden domain server info domain registrieren
- Re: Macro
- RE: Code error to mirror data from one table to another
- Re: Sum the first character in a range
- Sum the first character in a range
- Re: Macro to hide empty worksheets
- Re: Macro to hide empty worksheets
- RE: Vlookup macro
- Re: Macro to hide empty worksheets
- Re: Different Results running the same macro??
- From: Rick Rothstein \(MVP - VB\)
- Re: I need help again
- Re: Pass workbook name to ActiveX DLL
- Re: VBA Library
- From: Bill_Green via OfficeKB.com
- Re: I need help again
- From: Rick Rothstein \(MVP - VB\)
- RE: I need help again
- RE: I need help again
- A search tool to the wishlist
- Re: search BuiltinDocumentProperties routine
- Re: List all macro shortcuts in Excel
- Re: Print time
- From: Rick Rothstein \(MVP - VB\)
- I need help again
- Re: Print time
- RE: Print time
- Re: Print time
- RE: want to change cell background using RGB data in a worksheet
- RE: want to change cell background using RGB data in a worksheet
- RE: want to change cell background using RGB data in a worksheet
- Print time
- RE: want to change cell background using RGB data in a worksheet
- Re: Formula = problem
- Code error to mirror data from one table to another
- Formula = problem
- want to change cell background using RGB data in a worksheet
- Re: ROW CELLS SHOULD HAVE VALUE WHEN WORKBOOK OPEN
- From: Rick Rothstein \(MVP - VB\)
- Re: UserForm Prob
- From: Rick Rothstein \(MVP - VB\)
- Re: if and help
- From: Rick Rothstein \(MVP - VB\)
- Re: Help in printing a sorted list of customers purchases
- RE: creating pages with 1 click..
- Re: Help in printing a sorted list of customers purchases
- Re: Help in printing a sorted list of customers purchases
- RE: creating pages with 1 click..
- Re: if and help
- Re: Excel Checkbox Help
- Re: if and help
- Help in printing a sorted list of customers purchases
- Re: Copy files to dbf files
- Re: if and help
- if and help
- RE: Update Excel Objects
- RE: How long to open xls ?
- RE: UserForm Prob
- Re: VBA Library
- RE: If function in Macro
- RE: If function in Macro
- RE: Excel Checkbox Help
- RE: If function in Macro
- RE: If function in Macro
- RE: If function in Macro
- RE: If function in Macro
- RE: If function in Macro
- If function in Macro
- Re: ROW CELLS SHOULD HAVE VALUE WHEN WORKBOOK OPEN
- VBA Library
- From: Bill_Green via OfficeKB.com
- UserForm Prob
- RE: ROW CELLS SHOULD HAVE VALUE WHEN WORKBOOK OPEN
- RE: Vlookup macro
- Re: find multiple or by different words
- ROW CELLS SHOULD HAVE VALUE WHEN WORKBOOK OPEN
- RE: List all macro shortcuts in Excel
- Re: automatic counting
- How long to open xls ?
- Re: Displaying the value of a string - SOLVED!
- Excel Checkbox Help
- RE: DOS output
- Re: automatic counting
- Re: Displaying the value of a string
- Re: find multiple or by different words
- Displaying the value of a string
- automatic counting
- Re: Function macro
- Re: Copy files to dbf files
- List all macro shortcuts in Excel
- Can Alt-TAB taskbar icon be changed for a Bullen FormChanger?
- RE: Vlookup macro
- DOS output
- RE: Converting Excel SS to a Web Form
- Copy files to dbf files
- Vlookup macro
- RE: Compile Error: variable not defined
- RE: Compile Error: variable not defined
- RE: different password protect for different worksheets
- creating pages with 1 click..
- Re: min and max in a text box
- min and max in a text box
- Re: Open a userform of one spread sheet with another spread sheet
- Re: min and max in a text box
- Re: Open a userform of one spread sheet with another spread sheet
- Re: Open a userform of one spread sheet with another spread sheet
- Re: Open a userform of one spread sheet with another spread sheet
- Re: Open a userform of one spread sheet with another spread sheet
- Compile Error: variable not defined
- RE: Is there an object property that will return the file type?
- Export multiple sheets to XML
- Re: Pivot tables wont work in protected sheet?
- Re: Function macro
- Re: annoying pop up windows
- RE: Delete string if string has only one item
- Re: change named range
- Re: Userform - Return Control Clicked
- Re: Function macro
- Re: Userform - Return Control Clicked
- Re: Pause between sheets
- Map XML Element
- Re: Open a userform of one spread sheet with another spread sheet
- Open a userform of one spread sheet with another spread sheet
- RE: Userform - Return Control Clicked
- Re: Pause between sheets
- Re: Pass workbook name to ActiveX DLL
- Re: Name error trying to use add-in
- Re: Pause between sheets
- Re: Pause between sheets
- Re: Pause between sheets
- RE: change named range
- Re: change named range
- RE: Name error trying to use add-in
- Re: Pause between sheets
- Re: Delete VB code
- change named range
- RE: VSTO BeforeDoubleClick edit mode
- Re: Delete VB code
- Re: Pause between sheets
- Re: Delete VB code
- Pause between sheets
- Re: Function macro
- Delete string if string has only one item
- RE: Userform - Return Control Clicked
- Re: Function macro
- From: Rick Rothstein \(MVP - VB\)
- Subject: Grid view/spreadsheet on userform. Q for the MVP's
- Re: Function macro
- From: Rick Rothstein \(MVP - VB\)
- RE: Option Button Code (Highlighting Rows)
- Re: Delete VB code
- Re: Function macro
- Running an excel sheet which uses RTD calls as a service?
- Name error trying to use add-in
- Re: Delete VB code
- RE: Is there an object property that will return the file type?
- RE: Importing Files into Excel using VBA
- Re: Function macro
- Re: Eliminate Variant Array Elements
- RE: Is there an object property that will return the file type?
- Re: Is there an object property that will return the file type?
- Re: Text box in a userform to equal a cell
- From: Rick Rothstein \(MVP - VB\)
- RE: Link: Unable to read file
- Re: annoying pop up windows
- RE: link click not working
- And the answer is ... MaintainConnection
- OLEDBConnection Properties
- Is there an object property that will return the file type?
- Re: Wrongo - Read access takes more than read
- Re: Delete VB code
- RE: Setting up a formula
- Re: Sheet Add/Delete and Build Pivot Table on the Fly
- RE: Setting up a formula
- Re: Setting up a formula
- Wrongo - Read access takes more than read
- Re: Function macro
- From: Rick Rothstein \(MVP - VB\)
- Importing Files into Excel using VBA
- Setting up a formula
- RE: Vlookup
- Vlookup
- Pass workbook name to ActiveX DLL
- RE: Text box in a userform to equal a cell
- Re: Function macro
- Re: Function macro
- From: Rick Rothstein \(MVP - VB\)
- Text box in a userform to equal a cell
- RE: Import Data - from Excel
- Re: Function macro
- From: Rick Rothstein \(MVP - VB\)
- RE: link click not working
- Re: Copy rows based on specific criteria
- RE: link click not working
- RE: Option Button Code (Highlighting Rows)
- Re: Sheet Add/Delete and Build Pivot Table on the Fly
- Re: Selecting all cells in a column between two cells
- RE: Startup code and keys to break execution
- Re: Sheet Add/Delete and Build Pivot Table on the Fly
- Re: Combo boxes go all funny!
- Re: Sorting by Date when some dates span over several days
- Re: Unable to unhide hidden columns
- RE: annoying pop up windows
- RE: Sheet Add/Delete and Build Pivot Table on the Fly
- Re: Sheet Add/Delete and Build Pivot Table on the Fly
- RE: Inserting some sort of sorting tag that doesn't display as tex
- Re: Combo boxes go all funny!
- Re: Combo boxes go all funny!
- RE: Startup code and keys to break execution
- Re: Unable to unhide hidden columns
- Userform - Return Control Clicked
- RE: annoying pop up windows
- RE: Creating a range that indexes in a For loop
- Startup code and keys to break execution
- RE: Can't get this to work
- RE: Can't get this to work
- Re: ByRef Argument Type Mismatch
- RE: ByRef Argument Type Mismatch
- RE: Combo boxes go all funny!
- RE: Can't get this to work
- RE: Can't get this to work
- RE: Inserting some sort of sorting tag that doesn't display as tex
- Multiple versions of Excel same Computer
- RE: Can't get this to work
- Sheet Add/Delete and Build Pivot Table on the Fly
- annoying pop up windows
- RE: Can't get this to work
- RE: ByRef Argument Type Mismatch
- Re: Selecting all cells in a column between two cells
- Re: Selecting all cells in a column between two cells
- Can't get this to work
- RE: Inserting some sort of sorting tag that doesn't display as text
- RE: Sorting by Date when some dates span over several days
- Inserting some sort of sorting tag that doesn't display as text
- Re: Unable to unhide hidden columns
- Sorting by Date when some dates span over several days
- Re: ByRef Argument Type Mismatch
- Creating a range that indexes in a For loop
- Re: SaveAs CSV - Pipe Delimited
- RE: ByRef Argument Type Mismatch
- Re: SaveAs CSV - Pipe Delimited
- Re: How to activate InputBox Cancel Function
- RE: Unable to unhide hidden columns
- ByRef Argument Type Mismatch
- Re: Selecting all cells in a column between two cells
- Re: search BuiltinDocumentProperties routine
- RE: SaveAs CSV - Pipe Delimited
- Re: Selecting all cells in a column between two cells
- Unable to unhide hidden columns
- Re: Selecting all cells in a column between two cells
- RE: Selecting all cells in a column between two cells
- Re: Selecting all cells in a column between two cells
- RE: Custom Range Method
- Re: Delete VB code
- Combo boxes go all funny!
- Re: Selecting all cells in a column between two cells
- SaveAs CSV - Pipe Delimited
- RE: Sorting an indeterminable range of data
- Selecting all cells in a column between two cells
- Re: IF statement Question
- RE: Custom Range Method
- Copy rows based on specific criteria
- Re: Sorting an indeterminable range of data
- RE: Custom Range Method
- Re: Custom Range Method
- Re: MsgBox without buttons
- Re: find multiple or by different words
- Re: IF statement Question
- RE: link click not working
- RE: Custom Range Method
- Custom Range Method
- Re: Request help with Arithmentic UDF
- RE: Column width & Row Height changing using macro/vb
- Re: Eliminate Variant Array Elements
- RE: Sorting an indeterminable range of data
- Re: IF statement Question
- Re: Sorting an indeterminable range of data
- RE: IF statement Question
- RE: IF statement Question
- Function macro
- Delete VB code
- RE: Request help with Arithmentic UDF
- Re: Macro
- IF statement Question
- Sorting an indeterminable range of data
- Eliminate Variant Array Elements
- Re: Click Anywhere Do Something - WinAPI?
- RE: Request help with Arithmentic UDF
- find multiple or by different words
- RE: Sorting a table of data into one column in ascending order
- Ever wondered how to work with large text imports >256 columns?
- Re: record a macro
- RE: Passing values to a string - PLEASE IGNORE
- RE: Passing values to a string
- Passing values to a string
- Re: TWO AMENDMENTS NEEDED IN MACRO - PLEASE HELP
- record a macro
- RE: Problem referencing a cell using 2 variables
- RE: link click not working
- RE: Macro
- RE: TWO AMENDMENTS NEEDED IN MACRO - PLEASE HELP
- RE: two criteria to match
- TWO AMENDMENTS NEEDED IN MACRO - PLEASE HELP
- Re: Same function in add-in and workbook module
- VBA ErrorBar method does not allow custom minusvalues
- Re: Click Anywhere Do Something - WinAPI?
- Re: Click Anywhere Do Something - WinAPI?
- Re: Saving changes to Excel file when using VSTO
- From: "Jialiang Ge [MSFT]"
- RE: Macro
- RE: Request help with Arithmentic UDF
- Macro
- Request help with Arithmentic UDF
- RE: two criteria to match
- RE: How to activate InputBox Cancel Function
- RE: How to write macro to set the chart scale min/max property?
- RE: How to activate InputBox Cancel Function
- RE: How to activate InputBox Cancel Function
- Click Anywhere Do Something - WinAPI?
- Re: Need a formula: If TIME is > or < than a cell enter TEXT
- From: Rick Rothstein \(MVP - VB\)
- RE: Need a formula: If TIME is > or < than a cell enter TEXT
- How to activate InputBox Cancel Function
- RE: Insert number of rows based on cell value, and fill
- RE: VSTO BeforeDoubleClick edit mode
- Re: Open Web page from a button on a form
- Need a formula: If TIME is > or < than a cell enter TEXT
- Re: Open Web page from a button on a form
- Open Web page from a button on a form
- Worksheet Object Protection
- RE: Option Button Code (Highlighting Rows)
- Re: Help with Application.InputBox(,,,,,8)
- Re: Vlookup funtion in Userform
- RE: Option Button Code (Highlighting Rows)
- Re: How to write macro to set the chart scale min/max property?
- RE: How to write macro to set the chart scale min/max property?
- Re: Count non-zero values in a Array
- Re: comparing rows
- link click not working
- Re: Excel is forced to close when run a marco???
- Problem referencing a cell using 2 variables
- Same function in add-in and workbook module
- Re: Different Results running the same macro??
- RE: VBA: Attach a variable to a range after executing Find command
- Form buttons and Control Command Buttons
- Insert number of rows based on cell value, and fill
- Re: Program to record where you've been?
- RE: Run-time error '1004': PasteSpecial method of Range class failed
- Re: Macro to password protect and allow autofilter
- Re: Excel is forced to close when run a marco???
- RE: Program to record where you've been?
- Re: VBA URL
- Program to record where you've been?
- Re: attach a variable name to a selected range
- RE: Excel is forced to close when run a marco???
- Excel is forced to close when run a marco???
- Run-time error '1004': PasteSpecial method of Range class failed
- Re: Different Results running the same macro??
- From: Rick Rothstein \(MVP - VB\)
- Re: Recording a macro
- VBA: Attach a variable to a range after executing Find command
- Re: Different Results running the same macro??
- Re: search BuiltinDocumentProperties routine
- Re: Count charts on Worksheet
- Re: Recording a macro
- Re: Scope of range names
- Re: Compare two sheets, identify values, calculate delta - Pls hel
- Re: convert hyperlink to email address
- Re: Recording a macro
- Re: Different Results running the same macro??
- From: dustinbrearton via OfficeKB.com
- Re: Count charts on Worksheet
- Re: Recording a macro
- From: dustinbrearton via OfficeKB.com
- RE: VSTO BeforeDoubleClick edit mode
- Different Results running the same macro??
- Re: Scope of range names
- Re: Set print area for all worksheet except first two worksheets
- Recording a macro
- Count charts on Worksheet
- RE: Column width & Row Height changing using macro/vb
- Re: Scope of range names
- Re: Splitting Paragraph into two columns w/limit of 256 characters
- Re: Error when cell A1 is not active and xlInsideVertical border format throwing error 1004
- RE: Referencing Database Fields
- Get outlook to start a userform in excel.
- Re: Splitting Paragraph into two columns w/limit of 256 characters
- .all
- Re: how to sort a row instead of a column?
- Re: formula
- Macro to password protect and allow autofilter
- Re: Changing color of a shape
- Re: search BuiltinDocumentProperties routine
- Re: how to sort a row instead of a column?
- Changing color of a shape
- Re: Splitting Paragraph into two columns w/limit of 256 characters
- Re: vba: attach a variable name to a selected range
- Re: Count non-zero values in a Array
- Re: Macro lagging when copying columns to other sheet
- Re: Scope of range names
- how to sort a row instead of a column?
- formula
- RE: Macro lagging when copying columns to other sheet
- Set print area for all worksheet except first two worksheets
- Re: Macro lagging when copying columns to other sheet
- search BuiltinDocumentProperties routine
- Re: Loop thru sheets copy and then paste in other sheet
- Re: vba: attach a variable name to a selected range
- RE: Loop thru sheets copy and then paste in other sheet
- Re: Error when cell A1 is not active and xlInsideVertical border format throwing error 1004
- RE: vba: attach a variable name to a selected range
- Re: Error when cell A1 is not active and xlInsideVertical border format throwing error 1004
- RE: paste to word
- Re: Splitting Paragraph into two columns w/limit of 256 characters
- vba: attach a variable name to a selected range
- Splitting Paragraph into two columns w/limit of 256 characters
- Re: Format a sorted character string
- Re: Error when cell A1 is not active and xlInsideVertical border format throwing error 1004
- Loop thru sheets copy and then paste in other sheet
- Grid view/spreadsheet on userform. Q for the MVP's
- Change event for multiple rows
- Re: Error when cell A1 is not active and xlInsideVertical border format throwing error 1004
- Re: MessageBox
- RE: Referencing Database Fields
- Re: OPEN EXCEL FILE ACCORDING TO CELL VALUE
- RE: Referencing Database Fields
- Re: OPEN EXCEL FILE ACCORDING TO CELL VALUE
- Macro lagging when copying columns to other sheet
- RE: Option Button Code (Highlighting Rows)
- RE: Hide VB Scripts & macro from user
- Re: MessageBox
- RE: Sorting a table of data into one column in ascending order
- RE: Referencing Database Fields
- Hide VB Scripts & macro from user
- Export to XML when closing workbook.
- Re: Scope of range names
- Re: MessageBox
- Column width & Row Height changing using macro/vb
- RE: Conditionally enable/disable a custom menu
- Re: Close almost all workbooks
- From: dustinbrearton via OfficeKB.com
- Re: Scope of range names
- Re: comparing rows
- RE: Is there a way to make the VBA code invisible to end user?
- Re: Close almost all workbooks
- Update Excel Objects
- Re: Retrieving custom document properties - Excel 2007
- RE: Conditionally enable/disable a custom menu
- RE: Conditionally enable/disable a custom menu
- RE: How do you show UDF parameters while typing in formula in Excel?
- Re: Is there a way to make the VBA code invisible to end user?
- From: Michael Downey - CarBiz, Inc.
- Is there a way to make the VBA code invisible to end user?
- From: Michael Downey - CarBiz, Inc.
- Re: comparing rows
- How do you show UDF parameters while typing in formula in Excel?
- Re: Accessing Remote registry in Excel
- Re: Compare two sheets, identify values, calculate delta - Pls hel
- Re: Close almost all workbooks
- Re: Close almost all workbooks
- From: dustinbrearton via OfficeKB.com
- RE: Conditionally enable/disable a custom menu
- Re: Scope of range names
- RE: paste to word
- OPEN EXCEL FILE ACCORDING TO CELL VALUE
- Re: MessageBox
- From: dustinbrearton via OfficeKB.com
- Re: comparing rows
- From: dustinbrearton via OfficeKB.com
- RE: Please help with simple function
- Re: Accessing Remote registry in Excel
- MessageBox
- Re: Subtotal data of various lengths without entering Sum(...) man
- Close almost all workbooks
- Please help with simple function
- Turn "spell check before sending" off in Outlook from Excel VBA
- Re: Retrieving custom document properties - Excel 2007
- RE: Excel 16 bit limitation
- Import Data - from Excel
- RE: Scope of range names
- comparing rows
- Re: Generic Macro that can rows of zeroes
- Scope of range names
- RE: Enable Copy and Paste Functions in a protected worksheet
- Re: CDO mailing from Excel
- RE: Retrieving custom document properties - Excel 2007
- RE: Run Macro from a list
- Retrieving custom document properties - Excel 2007
- Displaying a Graph
- Re: UDF ...VBA Formula built ...please help
- RE: Recorded Macro Works, Code Doesn't
- Re: Copy Tab Names from Several Sheets and Copy Last Row from Same
- Generic Macro that can rows of zeroes
- Re: Enhance sub to copy cols of variable length into 1 col to snake results into other cols
- Re: Macro to insert formula using cell reference/text - Urgent
- Re: Compare two sheets, identify values, calculate delta - Pls hel
- Re: Button on a sheet
- RE: change font color by groups with VBA
- Re: Compare two sheets, identify values, calculate delta - Pls hel
- Re: Run Macro from a list
- RE: Run Macro from a list
- RE: Run Macro from a list
- Re: UDF ...VBA Formula built ...please help
- Embedded Word Doc not printing completely
- RE: Sorting a table of data into one column in ascending order
- Run Macro from a list
- RE: Sorting a table of data into one column in ascending order
- Re: Vlookup funtion in Userform
- Re: OnChange event attached to tick box
- Re: Running a For function in a For function
- RE: Running a For function in a For function
- RE: paste to word
- RE: two criteria to match
- Re: How to write macro to set the chart scale min/max property?
- RE: How to write macro to set the chart scale min/max property?
- Re: UDF ...VBA Formula built ...please help
- Sorting a table of data into one column in ascending order
- Re: Macro to insert formula using cell reference/text - Urgent
- Re: How to write binary data to a file
- Re: Coding to choose the previous completed cell in a column
- Re: IsEmpty function in VSTO
- From: "Jialiang Ge [MSFT]"
- Re: Vlookup funtion in Userform
- How to write macro to set the chart scale min/max property?
- Macro to insert formula using cell reference/text - Urgent
- Re: Language Settings Issue
- Re: Put Value in a cell next to the active cell
- Re: VBA question create Excel Object and run XLSTART startup excel
- Re: Vlookup funtion in Userform
- Re: Help with Application.InputBox(,,,,,8)
- Re: Language Settings Issue
- Re: Making Frames Visible (or not)
- Re: UDF ...VBA Formula built ...please help
- Re: Coding to choose the previous completed cell in a column
- Re: Coding to choose the previous completed cell in a column
- Put Value in a cell next to the active cell
- Re: Compare two sheets, identify values, calculate delta - Pls hel
- RE: Help with Application.InputBox(,,,,,8)
- two criteria to match
- RE: Running a For function in a For function
- VBA question create Excel Object and run XLSTART startup excel
- Vlookup funtion in Userform
- RE: simulate clicking OK in msgbox
- Help with Application.InputBox(,,,,,8)
- Language Settings Issue
- RE: VSTO BeforeDoubleClick edit mode
- RE: How to alter the code to copy to the same exact cell destination?
- RE: Creating further drop down lists after a selection from a list
- Re: Button on a sheet
- From: Rick Rothstein \(MVP - VB\)
- Re: Button on a sheet
- From: Rick Rothstein \(MVP - VB\)
- Making Frames Visible (or not)
- Re: Button on a sheet
- Re: UDF ...VBA Formula built ...please help
- change font color by groups with VBA
- Re: UDF ...VBA Formula built ...please help
- Re: Button on a sheet
- From: Rick Rothstein \(MVP - VB\)
- Option Button Code (Highlighting Rows)
- Re: UDF ...VBA Formula built ...please help
- Re: Copy Tab Names from Several Sheets and Copy Last Row from Same
- From: Rick Rothstein \(MVP - VB\)
- Button on a sheet
- Re: UDF ...VBA Formula built ...please help
- RE: Watch not working
- Re: Subtotal data of various lengths without entering Sum(...) manuall
- From: Rick Rothstein \(MVP - VB\)
- RE: UDF ...VBA Formula built ...please help
- RE: Subtotal data of various lengths without entering Sum(...) manuall
- Re: how to open visio file by Excel VBA
- RE: Referencing Database Fields
- Re: Copy Tab Names from Several Sheets and Copy Last Row from Same
- Re: .ShortCutText in menus in 2007
- RE: VSTO BeforeDoubleClick edit mode
- RE: Recorded Macro Works, Code Doesn't
- Re: Merge 7 files to 1 workbook/7Sheets and then 1 sheet of the new workbook
- Re: Insert Rows
- Re: Accessing Remote registry in Excel
- Re: Can I set Insert Options programmatically?
- Referencing Database Fields
- Re: Can I set Insert Options programmatically?
- Re: Format a sorted character string
- From: Rick Rothstein \(MVP - VB\)
- Subtotal data of various lengths without entering Sum(...) manuall
- Re: Format a sorted character string
- RE: Macro that uses a value as the range
- RE: Insert Rows
- RE: Macro that uses a value as the range
- Re: Way to print every worksheet in a workbook except the first two
- VSTO BeforeDoubleClick edit mode
- Re: Way to print every worksheet in a workbook except the first two
- RE: 424 Error whem trying to change Visible property
- Macro that uses a value as the range
- Way to print every worksheet in a workbook except the first two
- Re: Copy Tab Names from Several Sheets and Copy Last Row from Same She
- From: Rick Rothstein \(MVP - VB\)
- RE: 424 Error whem trying to change Visible property
- Re: Add pdf attachment to new mail
- RE: Insert Rows
- RE: CAN ANY BODY PLEASE HELP
- RE: Percentile on filtered range
- Re: Formatting An Existing Open Spreadsheet With A COM Add-In
- Re: Add pdf attachment to new mail
- RE: Insert Rows
- Re: Copy chart to new location
- Re: 4-5 digit numbers to display leading zeros totalling 6 digits
- RE: Enable Copy and Paste Functions in a protected worksheet
- 424 Error whem trying to change Visible property
- RE: Excel 16 bit limitation
- UDF ...VBA Formula built ...please help
- Re: Add pdf attachment to new mail
- RE: macro help
- Re: 4-5 digit numbers to display leading zeros totalling 6 digits
- From: Rick Rothstein \(MVP - VB\)
- Re: Formatting An Existing Open Spreadsheet With A COM Add-In
- RE: Conditionally enable/disable a custom menu
- Re: Run time error 91 when trying to add controls to a collection
- RE: Run time error 91 when trying to add controls to a collection
- RE: Run time error 91 when trying to add controls to a collection
- Re: Accessing Remote registry in Excel
- Run time error 91 when trying to add controls to a collection
- Re: message box
- RE: simulate clicking OK in msgbox
- Re: Formatting An Existing Open Spreadsheet With A COM Add-In
- message box
- Error 80010108 when using FolioExportOCX from Excel 2007
- Re: Formatting An Existing Open Spreadsheet With A COM Add-In
- 4-5 digit numbers to display leading zeros totalling 6 digits
- RE: simulate clicking OK in msgbox
- Conditionally enable/disable a custom menu
- Re: Running a For function in a For function
- Re: Accessing Remote registry in Excel
- Excel 16 bit limitation
- RE: macro help
- Re: Error when cell A1 is not active and xlInsideVertical border format throwing error 1004
- RE: Copy, Paste and Print Cells from a Named Range
- RE: selection.cells(1).value
- RE: Add-in load up
- Re: simulate clicking OK in msgbox
- Re: Accessing Remote registry in Excel
- Re: Copy, Paste and Print Cells from a Named Range
- Re: Add pdf attachment to new mail
- Re: Copy Tab Names from Several Sheets and Copy Last Row from Same She
- Re: Copy Tab Names from Several Sheets and Copy Last Row from Same She
- Percentile on filtered range
- Re: Add pdf attachment to new mail
- Re: Error when cell A1 is not active and xlInsideVertical border format throwing error 1004
- RE: Copy, Paste and Print Cells from a Named Range
- Re: VBA URL
- Re: Formatting An Existing Open Spreadsheet With A COM Add-In
- Re: separating cell values deliminated by a "/"
- Re: Macros created in earlier EXCEL version, do they work in 2007?
- Re: UDF help
- RE: OPENING SEVERAL HYPERLINKS
- Re: Redimming 2D array to 1D while preserving the data?
- Watch not working
- Re: Redimming 2D array to 1D while preserving the data?
- Formatting An Existing Open Spreadsheet With A COM Add-In
- Re: separating cell values deliminated by a "/"
- RE: VBA & SQL
- From: Excel interacting dinamically to SQL Srv
- Error when cell A1 is not active and xlInsideVertical border format throwing error 1004
- Re: IsEmpty function in VSTO
- Re: Macro to create PDF
- RE: OPENING SEVERAL HYPERLINKS
- Re: Redimming 2D array to 1D while preserving the data?
- Macros created in earlier EXCEL version, do they work in 2007?
- Copy, Paste and Print Cells from a Named Range
- RE: macro help
- RE: Copy Tab Names from Several Sheets and Copy Last Row from Same She
- Re: Accessing Remote registry in Excel
- Re: IsEmpty function in VSTO
- VBA URL
- Re: Redimming 2D array to 1D while preserving the data?
- Copy Tab Names from Several Sheets and Copy Last Row from Same She
- Re: separating cell values deliminated by a "/"
- RE: Enable Copy and Paste Functions in a protected worksheet
- RE: separating cell values deliminated by a "/"
- Re: OR statement on macro
- RE: Recorded Macro Works, Code Doesn't
- Re: Accessing Remote registry in Excel
- RE: separating cell values deliminated by a "/"
- RE: Enable Copy and Paste Functions in a protected worksheet
- RE: Can I set Insert Options programmatically?
- RE: Enable Copy and Paste Functions in a protected worksheet
- RE: Enable Copy and Paste Functions in a protected worksheet
- separating cell values deliminated by a "/"
- Recorded Macro Works, Code Doesn't
- Re: Redimming 2D array to 1D while preserving the data?
- RE: Enable Copy and Paste Functions in a protected worksheet
- RE: lost macros
- Re: OR statement on macro
- RE: Enable Copy and Paste Functions in a protected worksheet
- RE: Add-in load up
- Enable Copy and Paste Functions in a protected worksheet
- RE: VBA & SQL
- RE: VBA & SQL
- Creating a graph - Screen sizes
- OR statement on macro
- IsEmpty function in VSTO
- CAN ANY BODY PLEASE HELP
- Re: Excel 2007 VBA and Text Boxes
- Insert Rows
- RE: Questions about opening a workbook in code
- RE: VBA & SQL
- From: Excel interacting dinamically to SQL Srv
- RE: How do I Designate a number with letters?
- sort by grand total in pivot table
- Re: Redimming 2D array to 1D while preserving the data?
- Questions about opening a workbook in code
- Export from VBA form to Access
- Automation C++ code works for Excel 2003, not for Excel 2007
- Add-in load up
- Can I set Insert Options programmatically?
- RE: simulate clicking OK in msgbox
- RE: Message box to prompt for file name upon save
- Remove Pivot Table Borders with Macro
- Re: Error 1004, pasting merged cells
- RE: OPENING SEVERAL HYPERLINKS
- Re: Merge 7 files to 1 workbook/7Sheets and then 1 sheet of the new workbook
- Redimming 2D array to 1D while preserving the data?
- compare rows
- RE: macro help
- Re: Automatically hide rows with 0 value....faster?
- VBA & SQL
- From: Excel interacting dinamically to SQL Srv
- RE: How do I Designate a number with letters?
- Re: copy and paste challenge
- RE: How do I Designate a number with letters?
- RE: Pop Up Message before printing
- RE: OPENING SEVERAL HYPERLINKS
- How do I Designate a number with letters?
- RE: Pop Up Message before printing
- Re: How to write binary data to a file
- Re: Pop Up Message before printing
- Re: How to write binary data to a file (solved)
- RE: Message box to prompt for file name upon save
- Pop Up Message before printing
- RE: Running a For function in a For function
- Re: Macro to create PDF
- RE: Running a For function in a For function
- Message box to prompt for file name upon save
- How to write binary data to a file
- macro help
- RE: OPENING SEVERAL HYPERLINKS
- Re: how to skip printing pages in exel by cell value
- Re: lost macros
- Re: Excel formula
- Re: locking cells
- Re: Macro to create PDF
- top 10
- Re: Automatically hide rows with 0 value....faster?
- RE: lost macros
- Running a For function in a For function
- Macro to create PDF
- lost macros
- Re: locking cells
- RE: locking cells
- RE: OPENING SEVERAL HYPERLINKS
- Converting Excel SS to a Web Form
- Re: Add pdf attachment to new mail
- Re: proper case using Microsoft Office Professional 2003
- From: charlottemudra@yahoo.com
- Add pdf attachment to new mail
- Re: Excel formula
- locking cells
- RE: blank data when using macros
- Re: Excel formula
- How to alter the code to copy to the same exact cell destination?
- Re: All Possible Combinations
- Error 1004, pasting merged cells
- Re: Coding to choose the previous completed cell in a column
- Citrix and FullName
- RE: simulate clicking OK in msgbox
- RE: OPENING SEVERAL HYPERLINKS
- Re: Coding to choose the previous completed cell in a column
- Coding to choose the previous completed cell in a column
- Re: Excel formula
- Re: PROTECT MACRO IN NEW WORKBOOK
- Re: Database Workbook
- Re: Accessing Remote registry in Excel
- Re: Excel formula
- Database Workbook
- Excel formula
- RE: Identifying a uniques entity composed of two columns
- Copying sheets to new workbook, merged cell issue?
- RE: Explain code
- RE: Identifying a uniques entity composed of two columns
- blank data when using macros
- Re: Control a Table in Word From Excel
- Re: How to Format the entered Numeric Values of a Excel sheet's column as Text
- Identifying a uniques entity composed of two columns
- Re: Control a Table in Word From Excel
- RE: simulate clicking OK in msgbox
- OPENING SEVERAL HYPERLINKS
- Re: Determining what menu item called a macro
- Re: CopyPicture on a Shapes range
- Re: Vlookup and Type Mismatch
- Re: Move Row if cell is not null
- Re: Determining what menu item called a macro
- Control a Table in Word From Excel
- different password protect for different worksheets
- Re: Compare two sheets, identify values, calculate delta - Pls hel
- PROTECT MACRO IN NEW WORKBOOK
- RE: paste to word
- Re: Compare two sheets, identify values, calculate delta - Pls help
- MsgBox FOR SELECTING WRONG FORMAT FILE
- Compare two sheets, identify values, calculate delta - Pls help
- Re: Move Row if cell is not null
- Get values from 15 sheets in a Wbook
- how to setup web service reference in excel 2007 vba?
- Re: Error filtering for unique values
- Re: Set default date on calendar control
- Re: Error filtering for unique values
- Error filtering for unique values
- How to find that Excel work book contain ActiceX control through c
- copy and paste challenge
- Re: Filter - Just like Access
- Re: Excel 2007 VBA and Text Boxes
- paste to word
- Excel 2007 VBA and Text Boxes
- Re: How to Format the entered Numeric Values of a Excel sheet's column as Text
- RE: Trigger CAPS LOCK ON When Wk Bk is Opened?
- How to Format the entered Numeric Values of a Excel sheet's column as Text
- Re: Merging Two Sheets - VLookup?
- Re: Open other applications using code
- RE: Open other applications using code
- RE: InputBox - finding the input in a range
- Re: CopyPicture on a Shapes range
- Re: CopyPicture on a Shapes range
- Re: InputBox - finding the input in a range
- From: Rick Rothstein \(MVP - VB\)
- RE: simulate clicking OK in msgbox
- Re: Vlookup and Type Mismatch
- Re: Can't call a subroutine
- Open other applications using code
- Re: Pivot tables wont work in protected sheet?
- simulate clicking OK in msgbox
- Re: Pivot tables wont work in protected sheet?
- InputBox - finding the input in a range
- Re: Can't call a subroutine
- Re: Explain code
- RE: Explain code
- RE: Explain code
- RE: Explain code
- RE: Password Protecting Sheets
- Pivot tables wont work in protected sheet?
- CommandBar image remains in Clipboard after PasteFace
- Explain code
- RE: Can't call a subroutine
- Re: VBA Project not close after file closed
- Re: VBA Project not close after file closed
- RE: Variable inside function range
- RE: Copy and Paste in Macro
- Re: Format a sorted character string
- VBA Project not close after file closed
- Can't call a subroutine
- Re: Copy and Paste in Macro
- Copy and Paste in Macro
- RE: Runtime Type mismatch Error 13 when object not found
- Re: Format a sorted character string
- From: Rick Rothstein \(MVP - VB\)
- Re: Set default date on calendar control
- Re: Format a sorted character string
- RE: Need help copying certain cells from current row
- Re: Setting PW Before Saving?
- RE: Need help copying certain cells from current row
- Re: outlook vba
- Need help copying certain cells from current row
- RE: Calculating Number of Rows for Merged Cell Text Wrap
- RE: how to dynamically get sheet name
- Re: Worksheet Event Problems
- RE: Converting LOTS of xls to xlsm
- Setting PW Before Saving?
- RE: Converting LOTS of xls to xlsm
- Re: VLOOKUP - when source empty, get "0". Change to complete emtpy?
- Font size on ActiveX controls
- RE: Publishing a Range
- Re: Asking user to continue?
- From: StargateFanNotAtHome
- Culture problem with Excel english version
- Re: Function to read text file; find string; delete same before import
- Re: Asking user to continue?
- From: StargateFanNotAtHome
- RE: Format a sorted character string
- Re: VLOOKUP - when source empty, get "0". Change to complete emtpy?
- From: StargateFanNotAtHome
- Publishing a Range
- Re: Asking user to continue?
- From: StargateFanNotAtHome
- Re: Format a sorted character string
- Set default date on calendar control
- Re: Determining what menu item called a macro
- Re: Message Boxes
- RE: Immediate textbox validation question
- Re: how to skip printing pages in exel by cell value
- Re: outlook vba
- Automate Pasting Charts from Excel to Word
- Re: How do I run code on startup before Excel re-calculates formul
- Re: random numbers but normal distribution
- Format a sorted character string
- Re: Function to read text file; find string; delete same before import
- Re: Function to read text file; find string; delete same before import
- Re: Function to read text file; find string; delete same before import
- RE: Determining what menu item called a macro
- RE: Message Boxes
- RE: Insert/Embed PDF File automatically via VBA
- Password Protecting Sheets
- RE: Auto Filter
- RE: Creation and property manipulation of Control Checkbox using V
- Message Boxes
- RE: Delete any Lables with "0%" value in pie chart
- RE: Determining what menu item called a macro
- RE: Determining what menu item called a macro
- Re: outlook vba
- RE: Auto Filter
- RE: selection.cells(1).value
- RE: Delete any Lables with "0%" value in pie chart
- RE: Macro Limitations
- Determining what menu item called a macro
- RE: Macro Limitations
- RE: remove blank cell from a range
- Macro Limitations
- Auto Filter
- selection.cells(1).value
- RE: Slightly Urgent: Problem Resetting Chart Value Ranges
- RE: Check Boxes
- Re: Count non-zero values in a Array
- RE: Copying records to another worksheet
- how to skip printing pages in exel by cell value
- Re: simple print loop crashes
- RE: Copy data automatically from another workbook
- Re: outlook vba
- From: dustinbrearton via OfficeKB.com
- Re: Merge 7 files to 1 workbook/7Sheets and then 1 sheet of the new workbook
- RE: Slightly Urgent: Problem Resetting Chart Value Ranges
- Re: simple print loop crashes
- RE: Check Boxes
- Insert/Embed PDF File automatically via VBA
- Re: Function procedure too long
- RE: Check Boxes
- Re: simple print loop crashes
- RE: Check Boxes
- Re: Using .Row help please
- Delete any Lables with "0%" value in pie chart
- RE: Check Boxes
- Re: Automatically hide rows with 0 value....faster?
- RE: Check Boxes
- Re: how to dynamically get sheet name
- simple print loop crashes
- Re: help needed. what kind of formula I need to use that I would..
- RE: Check Boxes
- Re: how to dynamically get sheet name
- RE: Check Boxes
- Re: How to zoom in VBA
- RE: Need macro to drag values down to blank cells
- Re: How do I run code on startup before Excel re-calculates formul
- RE: how to dynamically get sheet name
- RE: Pasting Selected Excel Cells into a Word Doc
- RE: How to zoom in VBA
- RE: How to zoom in VBA
- Re: How to zoom in VBA
- RE: Check Boxes
- RE: Closed File Still "Working"
- how to dynamically get sheet name
- How to zoom in VBA
- Re: If formula help
- outlook vba
- RE: Check Boxes
- Re: Worksheet Event Problems
- RE: Copy data automatically from another workbook
- RE: Check Boxes
- RE: Closed File Still "Working"
- Re: How do I run code on startup before Excel re-calculates formul
- Add Controls to Control Collection at Run Time
- Re: Count a column "unique value only"
- Pasting Selected Excel Cells into a Word Doc
- Re: help needed. what kind of formula I need to use that I would....
- RE: Check Boxes
- Check Boxes
- help needed. what kind of formula I need to use that I would....
- Re: Dates & VB
- Re: Data Entry for 50 Rows only
- Re: How do I run code on startup before Excel re-calculates formul
- Re: Update multiple textboxes on userform
- Re: Create unique 'number'
- From: Rick Rothstein \(MVP - VB\)
- Re: Using .Row help please
- Re: Calculating the R2 from a scatter chart with Power trend line
- Re: How do I run code on startup before Excel re-calculates formulas?
- RE: Dates & VB
- RE: Access from Excel ADODB.Connection
- Re: Need Help on populating a newly inserted row
- Re: Need Help on populating a newly inserted row
- RE: Dates & VB
- RE: Dates & VB
- RE: Slightly Urgent: Problem Resetting Chart Value Ranges
- Access from Excel ADODB.Connection
- RE: Dates & VB
- Re: Multiple labels on userform 2 update
- Merge 7 files to 1 workbook/7Sheets and then 1 sheet of the new workbook
- Merging Two Sheets - VLookup?
- Dates & VB
- Re: VLOOKUP - when source empty, get "0". Change to complete emtpy?
- From: StargateFanNotAtHome
- Re: Create unique 'number'
- RE: Closed File Still "Working"
- RE: How do I run code on startup before Excel re-calculates formul
- Calculating the R2 from a scatter chart with Power trend line
- From: Carrie_Loos via OfficeKB.com
- Re: Multiple labels on userform 2 update
- RE: Autofill 1 column with changing data and changing range
- Update multiple textboxes on userform
- Re: VLOOKUP - when source empty, get "0". Change to complete emtpy?
- From: StargateFanNotAtHome
- RE: Slightly Urgent: Problem Resetting Chart Value Ranges
- Re: VLOOKUP - when source empty, get "0". Change to complete emtp
- From: StargateFanNotAtHome
- Re: Automatically hide rows with 0 value....faster?
- Multiple labels on userform 2 update
- Autofill 1 column with changing data and changing range
- Re: Using .Row help please
- RE: Using .Row help please
- Print area problem
- Re: proper case using Microsoft Office Professional 2003
- RE: Need macro to drag values down to blank cells
- Re: Create unique 'number'
- From: Rick Rothstein \(MVP - VB\)
- Re: Using .Row help please
- Re: Using .Row help please
- Breaking a Reference Error
- Slightly Urgent: Problem Resetting Chart Value Ranges
- proper case using Microsoft Office Professional 2003
- From: charlottemudra@yahoo.com
- Using .Row help please
- Re: Create unique 'number'
- From: Rick Rothstein \(MVP - VB\)
- Re: Saving data in pull down lists?
- RE: How do I run code on startup before Excel re-calculates formul
- RE: Create unique 'number'
- Re: Excel 2007, I write macros in 2003 is 2007 similar for VBA? Pr
- RE: How do I run code on startup before Excel re-calculates formulas?
- Need macro to drag values down to blank cells
- RE: Closed File Still "Working"
- macro to open file
- copy/paste to new blank sheet according to criteria
- RE: Create unique 'number'
- RE: remove blank cell from a range
- RE: autoupdate macro
- remove blank cell from a range
- RE: Create unique 'number'
- UDF behaving oddly
- Printing to PDF question
- Copying records to another worksheet
- Re: vlookup function in VBA code
- How do I run code on startup before Excel re-calculates formulas?
- RE: autoupdate macro
- RE: vlookup function in VBA code
- RE: Need Help on populating a newly inserted row
- Create unique 'number'
- Re: current IE window using VBA
- Survey Software
- RE: Dcounta
- RE: Variable inside function range
- Re: Count non-zero values in a Array
- vlookup function in VBA code
- RE: run macro on pivot refresh
- Re: Count non-zero values in a Array
- RE: Closed File Still "Working"
- RE: autoupdate macro
- Re: Macro does not delete all the required rows
- Re: Count non-zero values in a Array
- Re: Page orientation - Upsidedown?
- autoupdate macro
- run macro on pivot refresh
- Re: Move Row if cell is not null
- Count non-zero values in a Array
- Re: CopyPicture on a Shapes range
- Disable or lock page field
- Dcounta
- Closed File Still "Working"
- Re: Move Row if cell is not null
- Re: Allow Edit Objects in protected sheets
- RE: Move Row if cell is not null
- Re: Error: "The specified module could not be found" but DLL is in pla
- merging tables/columns from several of workbook into one workbook
- RE: Error: "The specified module could not be found" but DLL is in pla
- Re: random numbers but normal distribution
- Need Help on populating a newly inserted row
- Re: random numbers but normal distribution
- Re: Delete values colored cells
- Re: Function procedure too long
- Re: Onclick button actions
- RE: Immediate textbox validation question
- Onclick button actions
- Error: "The specified module could not be found" but DLL is in place!
- RE: Error on password protected sheet.
- Re: CopyPicture on a Shapes range
- Re: Delete values colored cells
- Re: random numbers but normal distribution
- RE: Where have my macro links gone?
- Where have my macro links gone?
- Re: Function procedure too long
- Re: Delete values colored cells
- Using HiPortfolio 3 via VBA
- Re: random numbers but normal distribution
- Delete values colored cells
- Re: assign filter inside macro
- Re: SetFocus back to textbox after exiting
- Re: If formula help
- Re: Worksheet Event Problems
- Re: SetFocus back to textbox after exiting
- mirror table depending on cell value
- Re: Allow Edit Objects in protected sheets
- Re: redim
- Re: If formula help
- Enhance sub to copy cols of variable length into 1 col to snake results into other cols
- Re: Runtime Type mismatch Error 13 when object not found
- Re: Displayed caption font increases on each click
- Immediate textbox validation question
- RE: What is wrong with this code? Screen capture and export as image?
- Re: assign filter inside macro
- RE: Error on password protected sheet.
- RE: Runtime Type mismatch Error 13 when object not found
- date list in excell with e-mail notification
- Allow Edit Objects in protected sheets
- RE: tab colors in 2003
- Re: SetFocus back to textbox after exiting
- Re: Using a UDF within SUMPRODUCT
- Re: Workbook code to Module Code
- Re: Worksheet Event Problems
- What is wrong with this code? Screen capture and export as image?
- From: Internetdomainowner
- RE: Macro does not delete all the required rows
- RE: Runtime Type mismatch Error 13 when object not found
- Macro does not delete all the required rows
- Re: Function procedure too long
- Re: Random generator using a range with range frequency
- Re: Filter - Just like Access
- Re: Random generator using a range with range frequency
- Re: Ron de Bruin's Copy to Worksheets
- Re: Worksheet Event Problems
- Re: UserForm_Initialize is not recognized??
- RE: Worksheet Event Problems
- Re: resetting a listbox after a macro
- Try Catch errors locking Excel
- Re: Ron de Bruin's Copy to Worksheets
- Re: Automatically hide rows with 0 value....faster?
- Error on password protected sheet.
- Re: TextBox Color Red if Less than 50
- Re: TextBox Color Red if Less than 50
- From: Rick Rothstein \(MVP - VB\)
- Re: TextBox Color Red if Less than 50
- Re: Filter - Just like Access
- RE: Variable inside function range
- Re: Sum part of range passed to UDF
- TextBox Color Red if Less than 50
- Re: Sum part of range passed to UDF
- From: Rick Rothstein \(MVP - VB\)
- Re: macro
- Re: Using a UDF within SUMPRODUCT
- Re: UserForm_Initialize is not recognized??
- Re: UserForm_Initialize is not recognized??
- Re: Sum part of range passed to UDF
- Re: ShowModal, Hide Form, Print Preview Office 2007
- RE: Random generator using a range with range frequency
- The difference between the enter key and .Calculate (perhaps Evaluate?)
- removing extra spaces in excel
- Automatically hide rows with 0 value....faster?
- RE: Want to add a user defined selection
- Re: macro
- Re: What's wrong here?
- From: Rick Rothstein \(MVP - VB\)
- Dynamic Range for a Chart & Trendline
- From: Carrie_Loos via OfficeKB.com
- RE: macro
- Re: macro
- Re: Sum part of range passed to UDF
- Re: Sum part of range passed to UDF
- From: Rick Rothstein \(MVP - VB\)
- RE: Populate Cells With Range Via ComboBox
- Re: If Begins With - Not Working - Please Help
- Re: Countif array
- From: Rick Rothstein \(MVP - VB\)
- Sum part of range passed to UDF
- RE: Want to add a user defined selection
- Want to add a user defined selection
- Random generator using a range with range frequency
- Re: Initializing values in a Listbox on a Form
- Re: Using a UDF within SUMPRODUCT
- Re: Colors Palette ActiveX
- Re: Cell A1 to sheet name
- RE: help! subscript out of range error when trying to return multiple
- Re: If Begins With - Not Working - Please Help
- Re: If Begins With - Not Working - Please Help
- Re: Cell A1 to sheet name
- From: Bill_Green via OfficeKB.com
- RE: resetting a listbox after a macro
- Re: TextBox Value
- TextBox Value
- Re: Using a UDF within SUMPRODUCT
- Re: Using a UDF within SUMPRODUCT
- Re: Using a UDF within SUMPRODUCT
- Re: Page orientation - Upsidedown?
- From: dustinbrearton via OfficeKB.com
- Re: Using a UDF within SUMPRODUCT
- Re: Add Border to the right side (xlEdgeRight) of a large number o
- RE: Using a UDF within SUMPRODUCT
- Re: Using a UDF within SUMPRODUCT
- stacking data
- RE: Placing TextBox text in cell
- Re: Placing TextBox text in cell
- Re: tab indexing
- Page orientation - Upsidedown?
- Re: Add Border to the right side (xlEdgeRight) of a large number o
- Re: Placing TextBox text in cell
- From: Rick Rothstein \(MVP - VB\)
- Re: Using a UDF within SUMPRODUCT
- Placing TextBox text in cell
- Re: Cell A1 to sheet name
- From: Rick Rothstein \(MVP - VB\)
- Re: help! subscript out of range error when trying to return multiple values from function (as variant array)
- Re: Add Border to the right side (xlEdgeRight) of a large number of co
- Using a UDF within SUMPRODUCT
- Re: selecting more than one cell
- Re: tab indexing
- Re: Initializing values in a Listbox on a Form
- Re: tab indexing
- Re: Code help - search / copy-paste
- From: Rick Rothstein \(MVP - VB\)
- Re: Cell A1 to sheet name
- From: Bill_Green via OfficeKB.com
- Re: Cell A1 to sheet name
- From: Bill_Green via OfficeKB.com
- Re: selecting more than one cell
- help! subscript out of range error when trying to return multiple values from function (as variant array)
- Joel or Anyone, help continued.
- Re: Initializing values in a Listbox on a Form
- Re: How to read settings from xlDialogPrint
- Re: Colors Palette ActiveX
- Re: selecting more than one cell
- From: Rick Rothstein \(MVP - VB\)
- Re: Cell A1 to sheet name
- saveAsPDF powerpoint from excel (Office 2007)
- selecting more than one cell
- Re: Library Not Registered
- Re: Cell A1 to sheet name
- From: Rick Rothstein \(MVP - VB\)
- Re: Countif array
- From: Rick Rothstein \(MVP - VB\)
- Userform Combobox Excel 2003
- Initializing values in a Listbox on a Form
- Cell A1 to sheet name
- From: Bill_Green via OfficeKB.com
- RE: Code help - search / copy-paste
- How to read settings from xlDialogPrint
- Re: Sort breaks when columns are move around
- Re: Assign and clear value to unlocked cells in a protected sheet
- Re: One item in alt+Tab dialog per Excel Instance
- Re: Function procedure too long
- RE: Cell Selection in Macro
- Re: MatchLast function
- Re: Delete Consecutive Rows if counta(row #) is =
- Re: Sub to compile data from col A in many identical sheets
- Delete Consecutive Rows if counta(row #) is =
- Re: MatchLast function
- Re: MatchLast function
- Re: MatchLast function
- Re: MatchLast function
- Re: MatchLast function
- Sort breaks when columns are move around
- RE: stuck at a loop
- RE: use macro to copy formula with value and not formula without v
- Filter - Just like Access
- RE: Scenario Manager question
- RE: Help with calling an Excel program in a Excel cell
- RE: Help with calling an Excel program in a Excel cell
- Help with calling an Excel program in a Excel cell
- RE: How to delete QueryTable in VSTO?
- From: "Jialiang Ge [MSFT]"
- Re: COPY/PASTE to body of email the format of Excell cell
- Re: CopyPicture on a Shapes range
- Re: UserForm_Initialize is not recognized??
- Re: Function procedure too long
- Excel 2007, I write macros in 2003 is 2007 similar for VBA? Pros and cons please
- Re: SUM does report correctly
- SUM does report correctly
- Re: Function procedure too long
- Re: compile error with Mid() function
- Re: Saving changes to Excel file when using VSTO
- From: "Jialiang Ge [MSFT]"
- Re: API for a user to select a folder?
- RE: use macro to copy formula with value and not formula without v
- Re: Pie Chart
- Re: Function procedure too long
- Re: Pie Chart
- RE: Copy selected macro(s) to a different workbook
- Re: Clear Row
- Re: Function procedure too long
- Re: Stopping Outlook alerts from Excel when emailing
- Re: Pie Chart
- Clear Row
- Re: UserForm_Initialize is not recognized??
- Excel Charting with Pivote Table Data
- Function procedure too long
- RE: Pie Chart
- Re: UserForm_Initialize is not recognized??
- Re: UserForm_Initialize is not recognized??
- RE: Creating further drop down lists after a selection from a list
- Re: Multipage error
- Re: UserForm_Initialize is not recognized??
- Pie Chart
- Re: Sub to compile data from col A in many identical sheets
- Re: Collection of Ranges and Arrays
- Sub to compile data from col A in many identical sheets
- Re: Collection of Ranges and Arrays
- Re: UserForm_Initialize is not recognized??
- Re: protecting multiple sheets
- Re: UserForm_Initialize is not recognized??
- Re: UserForm_Initialize is not recognized??
- From: Rick Rothstein \(MVP - VB\)
- Re: UserForm_Initialize is not recognized??
- Re: SetFocus back to textbox after exiting
- Re: protecting multiple sheets
- Re: UserForm_Initialize is not recognized??
- From: Rick Rothstein \(MVP - VB\)
- Re: UserForm_Initialize is not recognized??
- Re: SetFocus back to textbox after exiting
- Re: Need help with a formula
- Re: SetFocus back to textbox after exiting
- Re: SetFocus back to textbox after exiting
- Re: Trace errant formula to stop annoying message
- Re: Need help with a formula
- Re: Trace errant formula to stop annoying message
- Re: Need help with a formula
- Re: Need help with a formula
- Re: Need help with a formula
- Re: Need help with a formula
- Re: Need help with a formula
- Re: SetFocus back to textbox after exiting
- Re: Collection of Ranges and Arrays
- Re: Need help with a formula
- Re: Need help with a formula
- Re: Automatically resest variable values = 0 after runtime
- From: Rick Rothstein \(MVP - VB\)
- RE: LOG FILE RECORDING USERS TIME
- Re: resetting a listbox after a macro
- From: Rick Rothstein \(MVP - VB\)
- Re: COPY/PASTE to body of email the format of Excell cell
- COPY/PASTE to body of email the format of Excell cell
- RE: SetFocus back to textbox after exiting
- Re: Function to read text file; find string; delete same before import
- Re: Select Non Contigouos Ranges
- Re: Color Cell
- Re: Color Cell
- From: Rick Rothstein \(MVP - VB\)
- Color Cell
- Re: Vlookup and Type Mismatch
- RE: LOG FILE RECORDING USERS TIME
- Re: Repeat
- RE: LOG FILE RECORDING USERS TIME
- Collection of Ranges and Arrays
- Re: VBA and Excell - really need you help
- From: Rick Rothstein \(MVP - VB\)
- resetting a listbox after a macro
- Re: Vlookup and Type Mismatch
- Re: Select Non Contigouos Ranges
- Re: find a "." then
- From: Rick Rothstein \(MVP - VB\)
- Vlookup and Type Mismatch
- RE: Getting Data from Web - where the URL is the value of the active c
- Re: VBA and Excell - really need you help
- From: Rick Rothstein \(MVP - VB\)
- Re: find a "." then
- Re: Test for Folder Path. if it doesn't exist, Create it
- Re: find a "." then
- Re: Calendar Object in Visual Basic
- Re: find a "." then
- From: Rick Rothstein \(MVP - VB\)
- Re: Select Non Contigouos Ranges
- From: Rick Rothstein \(MVP - VB\)
- Re: inputbox
- From: Rick Rothstein \(MVP - VB\)
- RE: find a "." then
- Calendar Object in Visual Basic
- Re: VBA and Excell - really need you help
- Re: Select Non Contigouos Ranges
- Re: Select Non Contigouos Ranges
- From: Rick Rothstein \(MVP - VB\)
- Re: Select Non Contigouos Ranges
- Re: Select Non Contigouos Ranges
- From: Rick Rothstein \(MVP - VB\)
- RE: Select Non Contigouos Ranges
- Re: Select Non Contigouos Ranges
- Re: vlookup to a table on a website
- Re: .ShortCutText in menus in 2007
- Re: Test for Folder Path. if it doesn't exist, Create it
- RE: Delete range of Worksheets
- RE: Delete range of Worksheets
- RE: Delete range of Worksheets
- RE: Open a .csv file, parse text and display on more than one shee
- Re: Input from ComboBox
- Re: Search & Replace macro
- Re: vlookup to a table on a website
- Delete range of Worksheets
- Re: find files and open db
- Re: Test for Folder Path. if it doesn't exist, Create it
- Input from ComboBox
- Re: vlookup to a table on a website
- Re: HELP=>VB 'File Already Open' ERROR (run-time 55)
- Re: find files and open db
- Re: find files and open db
- Re: Repeating the same routine
- Re: VBA Project to the Specific Computer
- Re: find files and open db
- Re: inputbox
- Repeating the same routine
- Re: Repeat
- Re: xl2007 speed issues
- Re: timer
- Re: HELP=>VB 'File Already Open' ERROR (run-time 55)
- Re: vlookup to a table on a website
- Re: find files and open db
- HELP=>VB 'File Already Open' ERROR (run-time 55)
- Re: find files and open db
- Re: inputbox
- inputbox
- Re: Data Entry for 50 Rows only
- Re: VBA and Excell - really need you help
- Re: Function to read text file; find string; delete same before import
- RE: How can I reduce repetative code
- .ShortCutText in menus in 2007
- Re: Managing list using dates!
- From: HammerJoe@xxxxxxxxx
- Re: Managing list using dates!
- From: HammerJoe@xxxxxxxxx
- Re: 1004 Error with Range/Array
- RE: Managing list using dates!
- Re: Calendar question
- Re: find files and open db
- Re: find files and open db
- Managing list using dates!
- From: HammerJoe@xxxxxxxxx
- Re: Rowsource from another workbook
- Re: CDO mailing from Excel
- RE: List help
- From: lonnierudd via OfficeKB.com
- RE: Repeat
- Re: Getting Data from Web - where the URL is the value of the active c
- RE: List help
- From: lonnierudd via OfficeKB.com
- Re: VBA and Excell - really need you help
- From: Rick Rothstein \(MVP - VB\)
- Re: VBA and Excell - really need you help
- Re: find files and open db
- Re: VBA and Excell - really need you help
- RE: Getting Data from Web - where the URL is the value of the active c
- Re: Excel crashes when I add VBA code programatically
- Re: Locking Macros
- Re: find files and open db
- Calendar question
- Re: VBA Project to the Specific Computer
- RE: Pop up
- Re: Find Macro
- From: Rick Rothstein \(MVP - VB\)
- Re: VBA Project to the Specific Computer
- Re: VBA Project to the Specific Computer
- Re: current IE window using VBA
- Re: Find Macro
- Re: find files and open db
- Re: Object Variable error
- Re: VBA Project to the Specific Computer
- Re: VBA and Excell - really need you help
- RE: Excel2007; workbooks.count is not counting all open workbooks
- Re: current IE window using VBA
- RE: Excel2007; workbooks.count is not counting all open workbooks
- List help
- From: lonnierudd via OfficeKB.com
- Re: VBA Project to the Specific Computer
- Re: Object Variable error
- RE: Pop up
- Re: Extract top 5 elements from table
- RE: Pop up
- Re: Locking Macros
- Re: Object Variable error
- RE: Pop up
- Re: Function to read text file; find string; delete same before import
- Re: Function to read text file; find string; delete same before import
- RE: Pop up
- Re: last used row.
- Re: Find Macro
- From: Rick Rothstein \(MVP - VB\)
- Re: VBA Project to the Specific Computer
- RE: Pop up
- Re: Object Variable error
- Re: Object Variable error
- Re: VBA and Excell - really need you help
- From: Rick Rothstein \(MVP - VB\)
- Re: Function to read text file; find string; delete same before import
- From: Rick Rothstein \(MVP - VB\)
- Re: VBA Project to the Specific Computer
- Re: Function to read text file; find string; delete same before import
- Re: VBA and Excell - really need you help
- From: Rick Rothstein \(MVP - VB\)
- Re: Function to read text file; find string; delete same before import
- RE: VBA code for Chart with x and y axis
- Error Copying File or Folder message when copying file to CD
- Re: VBA and Excell - really need you help
- VBA Project to the Specific Computer
- Re: number of lines and characters in a text file
- RE: refresh a folder
- RE: save as macro for same file name
- Re: number of lines and characters in a text file
- Re: Assign and clear value to unlocked cells in a protected sheet
- Re: Function to read text file; find string; delete same before import
- From: Rick Rothstein \(MVP - VB\)
- Re: last used row.
- Re: Function to read text file; find string; delete same before import
- From: Rick Rothstein \(MVP - VB\)
- Re: Hiding / locking access to VBA code
- Re: Extract top 5 elements from table
- Re: Function to read text file; find string; delete same before import
- Re: Function to read text file; find string; delete same before import
- Re: Workbook code to Module Code
- Re: last used row.
- number of lines and characters in a text file
- Re: Function to read text file; find string; delete same before import
- From: Rick Rothstein \(MVP - VB\)
- Re: Function to read text file; find string; delete same before import
- From: Rick Rothstein \(MVP - VB\)
- Re: Function to read text file; find string; delete same before import
- Re: Extract top 5 elements from table
- Extract top 5 elements from table
- Re: Function to read text file; find string; delete same before import
- How to followhyperlink to a folder with a minus sign in the name
- Re: Assign and clear value to unlocked cells in a protected sheet
- Re: Workbook code to Module Code
- Re: Function to read text file; find string; delete same before import
- RE: save as macro for same file name
- RE: save as macro for same file name
- last used row.
- RE: Workbook code to Module Code
- Re: Locking Macros
- Workbook code to Module Code
- Data Entry for 50 Rows only
- Re: Object Variable error
- Re: Object Variable error
- Re: compile error with Mid() function
- Re: Object Variable error
- Re: Formula to reference another sheet using a string in a cell
- RE: how to transfer data from one workbook to another with VB
- Re: detect empty rows or columns
- Re: add new rows
- Re: detect empty rows or columns
- RE: how to transfer data from one workbook to another with VB
- Re: Object Variable error
- RE: Object Variable error
- Re: compile error with Mid() function
- From: Rick Rothstein \(MVP - VB\)
- Object Variable error
- Re: Accessing Remote registry in Excel
- Re: Locking Macros
- Re: Assign and clear value to unlocked cells in a protected sheet
- Re: Transposing data into new format
- Re: Create Named Ranges (Headers) - then using range name in formu
- Re: Return to active cell after sort
- Re: compile error with Mid() function
- Re: Function to read text file; find string; delete same before import
- Re: Create Named Ranges (Headers) - then using range name in formu
- Re: Save As
- Re: Function to read text file; find string; delete same before import
- Re: Setting Cursor Active in Cell via VB Script
- Re: Create Named Ranges (Headers) - then using range name in formula
- Re: compile error with Mid() function
- Re: Function to read text file; find string; delete same before import
- Re: Return to active cell after sort
- Re: Function to read text file; find string; delete same before import
- Re: Function to read text file; find string; delete same before import
- Re: Accessing Remote registry in Excel
- Re: Function to read text file; find string; delete same before import
- From: Rick Rothstein \(MVP - VB\)
- Re: Function to read text file; find string; delete same before import
- Re: Accessing Remote registry in Excel
- Re: Save As
- Re: Function to read text file; find string; delete same before import
- Return to active cell after sort
- Re: Accessing Remote registry in Excel
- Re: Function to read text file; find string; delete same before import
- Re: Create Named Ranges (Headers) - then using range name in formu
- Re: Create Named Ranges (Headers) - then using range name in formu
- RE: Extend values of a chart series
- Re: Accessing Remote registry in Excel
- Re: Accessing Remote registry in Excel
- Re: Function to read text file; find string; delete same before import
- Re: Function to read text file; find string; delete same before import
- Re: VLOOKUP - when source empty, get "0". Change to complete emtpy?
- Re: Is there a way to auto convert a time stamps to Eastern Standa
- Re: Solver -Macro
- RE: Function to read text file; find string; delete same before import
- Re: Macro for Removing Characters
- Re: VLOOKUP - when source empty, get "0". Change to complete emtp
- RE: stuck at a loop
- RE: Extend values of a chart series
- Function to read text file; find string; delete same before import
- Re: compile error with Mid() function
- RE: Extend values of a chart series
- Re: Create Named Ranges (Headers) - then using range name in formu
- VLOOKUP - when source empty, get "0". Change to complete emtpy?
- From: StargateFanNotAtHome
- Re: Saving data in pull down lists?
- Re: Check for unnecessary Public variable declarations and duplicate Set statements
- Re: Help with this marco
- From: Rick Rothstein \(MVP - VB\)
- Re: 'Run' return value
- RE: Developing Macros
- Accessing Remote registry in Excel
- Re: stuck with my code !!
- Re: Saving changes to Excel file when using VSTO
- Re: Locking Macros
- RE: Extend values of a chart series
- Re: One item in alt+Tab dialog per Excel Instance
- Re: Help with Cut-Delete-Paste to other sheet
- Re: MatchLast function
- Re: MatchLast function
- Re: MatchLast function
- From: Rick Rothstein \(MVP - VB\)
- Re: MatchLast function
- Re: Create Named Ranges (Headers) - then using range name in formu
- MatchLast function
- Re: Sequential numbering for forms
- Re: ADODB Problem with transferring data from Excel to Access
- RE: Extend values of a chart series
- Re: Solver -Macro
- Re: Help with this marco
- Re: Extend values of a chart series
- RE: Extend values of a chart series
- Re: Is there a way to auto convert a time stamps to Eastern Standa
- From: Rick Rothstein \(MVP - VB\)
- Re: Create Named Ranges (Headers) - then using range name in formula
- RE: stuck at a loop
- Re: Is there a way to auto convert a time stamps to Eastern Standa
- Re: Sequential numbering for forms
- Re: detect empty rows or columns
- RE: Copy rows where cells contain red and black font.
- RE: stuck at a loop
- RE: Adding a counter to a variable name
- RE: Extend values of a chart series
- RE: Extend values of a chart series
- RE: stuck at a loop
- Re: Advice needed on autocalculation
- RE: how to transfer data from one workbook to another with VB
- Re: Is there a way to auto convert a time stamps to Eastern Standa
- From: Rick Rothstein \(MVP - VB\)
- One item in alt+Tab dialog per Excel Instance
- Re: VBA and Excell - really need you help
- From: Rick Rothstein \(MVP - VB\)
- RE: Why am I getting run-time error '3256' when Excel workbook is
- RE: API for a user to select a folder?
- Re: Print Non-Contiguous Ranges From User Input on All Worksheets
- Re: VBA and Excell - really need you help
- Re: Copy & Paste Named Range Contents
- Re: detect empty rows or columns
- Re: Inserting Bold text into a cell
- From: Rick Rothstein \(MVP - VB\)
- RE: with, end with
- API for a user to select a folder?
- RE: Why am I getting run-time error '3256' when Excel workbook is
- Re: with, end with
- Re: Print Non-Contiguous Ranges From User Input on All Worksheets
- ADODB Problem with transferring data from Excel to Access
- Re: VBA and Excell - really need you help
- Re: Print Non-Contiguous Ranges From User Input on All Worksheets
- RE: Select only columns
- Re: Multiple Criteria for CountIF
- RE: Print Non-Contiguous Ranges From User Input on All Worksheets
- Re: Select only columns
- From: Rick Rothstein \(MVP - VB\)
- Re: Inserting Bold text into a cell
- RE: Why am I getting run-time error '3256' when Excel workbook is shar
- Re: Multiple Criteria for CountIF
- RE: HELP!
- Re: Close Shell
- From: Rick Rothstein \(MVP - VB\)
- RE: stuck at a loop
- Re: Copy & Paste Named Range Contents
- From: Rick Rothstein \(MVP - VB\)
- RE: Macro to put data below data in a and b from columns c and d
- Re: VBA and Excell – really need you help
- From: Rick Rothstein \(MVP - VB\)
- Close Shell
- Re: Copy & Paste Named Range Contents
- Print Non-Contiguous Ranges From User Input on All Worksheets
- Re: Multiple Criteria for CountIF
- Re: Multiple Criteria for CountIF
- Re: Multiple Criteria for CountIF
- Re: Signing Code
- Select only columns
- RE: Macro to put data below data in a and b from columns c and d
- RE: Macro to put data below data in a and b from columns c and d
- Re: macro comparing two different lists
- stuck at a loop
- Re: Help with excel 2003 formula
- Re: macro comparing two different lists
- RE: Macro to put data below data in a and b from columns c and d
- Re: Copy & Paste Named Range Contents
- From: Rick Rothstein \(MVP - VB\)
- Re: macro comparing two different lists
- Help with excel 2003 formula
- Re: Copy & Paste Named Range Contents
- Re: Asking user to continue?
- From: StargateFanNotAtHome
- Re: Asking user to continue?
- From: StargateFanNotAtHome
- Re: Copy & Paste Named Range Contents
- From: Rick Rothstein \(MVP - VB\)
- Re: Macro for Removing Characters
- From: Rick Rothstein \(MVP - VB\)
- RE: multiple rows need distinct value and adjacent row
- Re: Stopping Outlook alerts from Excel when emailing
- Re: Copy & Paste Named Range Contents
- Re: Print Macro Function
- Re: Save As
- Re: Print Macro Function
- From: dustinbrearton via OfficeKB.com
- Re: Why am I getting run-time error '3265
- Re: Save As
- From: dustinbrearton via OfficeKB.com
- Re: how to test if an object is dimensioned
- Re: VBA and Excell - really need you help
- Why am I getting run-time error '3256' when Excel workbook is shar
- Re: Macro for Removing Characters
- Re: macro comparing two different lists
- Print Macro Function
- Re: Chart Dynamic Range within a Set Range
- From: Carrie_Loos via OfficeKB.com
- Re: Getting text string into userform
- Re: Getting text string into userform
- Re: Hide non-contiguous cells
- Re: Is there a way to auto convert a time stamps to Eastern Standa
- Re: VBA and Excell - really need you help
- Re: Copy & Paste Named Range Contents
- From: Rick Rothstein \(MVP - VB\)
- Re: Macro for Removing Characters
- Re: Macro for Removing Characters
- From: Rick Rothstein \(MVP - VB\)
- RE: Help with writing macro
- Re: Extracting Data out of a string
- From: Rick Rothstein \(MVP - VB\)
- VBA and Excell – really need you help
- RE: multiple rows need distinct value and adjacent row
- Re: string and numeric
- From: Rick Rothstein \(MVP - VB\)
- RE: Problem when Combo box has linked cell as a number
- RE: Copy rows where cells contain red and black font.
- Re: how to open visio file by Excel VBA
- Re: Extracting Data out of a string
- From: Rick Rothstein \(MVP - VB\)
- Re: Summing a dynamic range between two points
- Copy rows where cells contain red and black font.
- Re: Proper way to create new macro
- Re: Proper way to create new macro
- Re: current IE window using VBA
- Re: Search & Replace macro
- Re: ComboBox
- From: lonnierudd via OfficeKB.com
- Re: Extracting Data out of a string
- RE: Help with writing macro
- Save As
- Re: macro comparing two different lists
- Re: ComboBox
- RE: Help with writing macro
- Last improvement in my project
- Re: Access Key
- Re: Problem when Combo box has linked cell as a number
- Re: How to Cancel the Protect of Excel with VB and save it with a new password again
- ComboBox
- From: lonnierudd via OfficeKB.com
- Re: Which is more efficient?
- Re: Autofilter show all
- RE: Developing Macros
- webbrowser object causes crash on sheet change
- RE: Proper way to create new macro
- Re: Really need some help - Creating a table without manually typi
- Re: string and numeric
- RE: Copy selected macro(s) to a different workbook
- Re: Extracting Data out of a string
- RE: Macro to copy current worksheet to pre-defined wookbook
- Re: Adjustment to count cells (in range code)
- RE: Macro to copy current worksheet to pre-defined wookbook
- Re: Autofilter show all
- Adjustment to count cells (in range code)
- RE: string and numeric
- Proper way to create new macro
- Re: Saving changes to Excel file when using VSTO
- Re: Dynamic range generator
- RE: Problem when Combo box has linked cell as a number
- Dynamic range generator
- Re: string and numeric
- RE: SetFocus back to textbox after exiting
- Re: string and numeric
- RE: SetFocus back to textbox after exiting
- Re: Returning values from OnAction
- RE: SetFocus back to textbox after exiting
- Re: Autofilter show all
- Re: Returning values from OnAction
- Re: how to open visio file by Excel VBA
- Re: compile error
- Re: Conditional Cell Lock
- Re: compile error
- Re: compile error
- RE: Streamlining my code
- Re: compile error
- Re: compile error
- Re: compile error
- Re: Extracting Data out of a string
- From: Rick Rothstein \(MVP - VB\)
- Re: compile error
- Re: compile error
- how to open visio file by Excel VBA
- Conditional Cell Lock
- Re: compile error
- How to Cancel the Protect of Excel with VB and save it with a new password again
- Re: CDO mailing from Excel
- Re: CDO mailing from Excel
- Re: Which is more efficient?
- Re: Extracting Data out of a string
- Developing Macros
- Re: Which is more efficient?
- Re: Which is more efficient?
- Re: Which is more efficient?
- Re: Returning values from OnAction
- Re: Which is more efficient?
- Re: Extracting Data out of a string
- Hide non-contiguous cells
- From: lonnierudd via OfficeKB.com
- Re: Setting range using vlookup
- Which is more efficient?
- Re: Summing a dynamic range between two points
- RE: Make all variable values in a Array equal to 0
- Streamlining my code
- How to Expose SeriesCollection?
- Re: Asking user to continue?
- From: Rick Rothstein \(MVP - VB\)
- Re: Really need some help - Creating a table without manually typing i
- RE: Subscript out of range error
- RE: Run-time error '9' - doesn't occur when unallocated array is W
- Re: Can you set up an automated counter in excel...
- Re: how to test if an object is dimensioned
- Re: CDO mailing from Excel
- Re: Macro to hide empty worksheets
- Re: Getting text string into userform
- Can you set up an automated counter in excel...
- Re: Getting text string into userform
- RE: Asking user to continue?
- RE: how to test if an object is dimensioned
- how to test if an object is dimensioned
- Macro to hide empty worksheets
- Asking user to continue?
- From: StargateFanNotAtHome
- Re: Getting text string into userform
- RE: Trying to get a macro to run when cell selection changes.
- Re: Named Range Collection
- Re: Check for unnecessary Public variable declarations and duplicate S
- Re: Getting text string into userform
