Top "Worksheet" questions

Worksheet is an Excel worksheet.

How to declare an Active Worksheet in a variable?

I'm trying to keep a variable to the currently open worksheet in VBA. So far I have Dim Active As …

excel vba worksheet
How can I use VBA to list all worksheets in a workbook within a string?

How can I use VBA to get the names of all the worksheets (or alternatively a maximum of three) within …

vba worksheet
VBA code doesn't run when cell is changed by a formula

Worksheet A has ranges of data that are collected from Worksheet B. Worksheet A has a macro that calculates if …

excel vba worksheet
VBA Worksheet change event bypass?

I am fixing a spreadsheet. The programmer made a macro for each sheet to fire when the sheet is changed. …

vba excel worksheet
Excel VB This Active Worksheet

I'm sure this is really easy but I can't find any info on it. I've got a Excel macro which …

excel worksheet vba
How can I loop through a subset of worksheets?

I know how to loop through all the worksheets in a workbook, and how to exit once I reach an …

excel vba worksheet
Copy sheet and get resulting sheet object?

Is there any easy/short way to get the worksheet object of the new sheet you get when you copy …

excel vba worksheet
Linking a whole worksheet to another in Excel

I have two workbooks that have sheets that logically should look identical. I don't want to manually maintain their identical-ness, …

excel dynamic reference worksheet
Change the background of Cells with C#

I'm developing an program using C# to manipulate an Excel document, and I'm using Microsoft.Office.Interop.Excel._Worksheet worksheet; …

c# .net excel cell worksheet
Refer to sheet using codename

I get a "type mismatch" error in this code: With Worksheets(Sheet1) '* Error here 'my code here End With …

vba excel worksheet