Rename New Worksheet

Excel Vba Question:

I kindly ask for help, ive a problem to rename new worksheet using excel vba function. In sheet1 i have a list, i need to create a new worksheet in a workbook and rename it with the value of cell which i se..... Read The Solution..

Copy from Worksheet

Excel Vba Question:

Im having problem when i want to copy a worksheet using excel vba macro function, having the name of a worksheet in cell A1, I would like to extract
non-contiguous data from the sheet of that name and..... Read The Solution..

Delete Worksheet

Excel Vba Question:

I have a excel vba macro that sometimes create a separate sheet entitled “MC TABLE” depending on the data, will . I also have a second excel vba Macro within the same program that will delete an..... Read The Solution..

Change Worksheet Tab Colors

Excel Vba Question:

I’m using the following code to clear or change worksheet tab colors from a worksheet tab but unfortunately i am getting an error “Subscript out of range” error:
Sheets(”aaaDe..... Read The Solution..

Clearing Data From Worksheet

Excel Vba Question:

I want to know whether its possible to press a cell or button on the worksheet to clear all entered data in the entire worksheet?
I have a worksheet in workbook that users enter several data in differ..... Read The Solution..

Next Page »

• Archives

  • October 2009
  • September 2009
  • August 2009
  • July 2009
  • June 2009
  • May 2009
  • April 2009
  • March 2009

• Categories

  • Excel Vba
  • Excel Tips
  • Excel Formulas
  • Excel Date Functions
  • Excel Spreadsheet
  • Excel Worksheet
  • Excel Miscellaneous

• Partners

  • Search Xls
  • Xls Files

• Latest Excel Tips

  • Search-Engine-Excel.Com - The Helpful One for You
  • Switch Minutes to Seconds in Excel
  • Excel Polynomial Trendline
  • Sending Multiple Personalized Email from Excel
  • Excel Sumif Multiple Criteria
  • Remove Hyperlinks in Excel
  • Copy Entire Rows to Another Spreadsheet Based on Cell Criteria
  • Streamlining Macro Created by Macros Recorder
  • Copying Cells Which Include Conditional Formatting in Worksheet
  • How to Draw Lines on User Form

• Most Viewed Excel Tips

  • How to Divide a Number With “Less Than” Sign? - 29,641 views
  • Macro VBA to Remove Characters in String of Text - 20,144 views
  • Date Calculation Start Date Minus Year, Month and Days - 18,941 views
  • Copy Entire Rows to Another Spreadsheet Based on Cell Criteria - 17,403 views
  • Combine Multiple Workbooks Overcome 255 Char Limit - 14,006 views
  • Insert Introduce Time Delay in Macro Vba - 13,916 views
  • Protect Range of Rows and Columns in Worksheet with Macro - 13,536 views

• Best Excel Tips

  • Calling Macro Visual Basic Procedures of a Different Project (5.00 out of 5)
  • How to Remove Excel Vba Macro Button (5.00 out of 5)
  • Delete Worksheet (5.00 out of 5)
  • Copy from Worksheet (5.00 out of 5)
  • How to Calculate 6 Working Days Between Two Dates (5.00 out of 5)
  • Remove Hyperlinks in Excel (5.00 out of 5)
  • Unprotect Worksheet Password (5.00 out of 5)

• Excel Tags

  Excel Vba vba excel xcel vba vba xcel Excel Tips Excel Formulas excel formula xcel formulas xcel tips excel vba add worksheet excel vba create new workbook excel worksheet formulas xcel formula Excel Worksheet microsoft excel tips excel vba date functions excel date function Excel Spreadsheet excel vba active worksheet excel vba worksheet change excel vba worksheet name excel vba worksheet_change excel vba delete worksheet excel vba select worksheet excel vba clear worksheet excel vba copy worksheet excel vba macro add new worksheet how to add new worksheet excel miscellanous