Top "Worksheet" questions

How to add a named sheet at the end of all Excel sheets?

I am trying to add an Excel sheet named "Temp" at the end of all existing sheets, but this code …

excel vba worksheet

Excel VBA For Each Worksheet Loop

I am working on code to basically go through each sheet in my Workbook, and then update column widths. Below …

excel vba for-loop each worksheet

Is there a macro to conditionally copy rows to another worksheet?

Is there a macro or a way to conditionally copy rows from one worksheet to another in Excel 2003? I'm pulling …

excel copy excel-2003 worksheet vba

Excel tab sheet names vs. Visual Basic sheet names

It seems that Visual Basic can not reference sheets according to user-modified sheet names. The worksheet tabs can have their …

vba excel worksheet

Reference excel worksheet by name?

I have the name of a worksheet stored as a string in a variable. How do I perform some operation …

excel vba worksheet

xlsxwriter: is there a way to open an existing worksheet in my workbook?

I'm able to open my pre-existing workbook, but I don't see any way to open pre-existing worksheets within that workbook. …

python worksheet xlsxwriter

C# - How to add an Excel Worksheet programmatically - Office XP / 2003

I am just starting to fiddle with Excel via C# to be able to automate the creation, and addition to …

c# excel com office-interop worksheet

Create Table in Excel Worksheet using VBA

I have this code below that will auto select a range. Does anyone know how I can add code to …

vba excel worksheet listobject

How to execute a function for each cell in a column and loop through all workbooks?

Here's what I have so far: Sub TrimColumnD() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets Dim c …

excel vba loops worksheet

C#: Getting the number of rows/columns with ExcelPackage

I need to read and write data from an Excel spreadsheet. Is there a method to finding out how many …

c# excel ms-office openoffice.org worksheet