Access Sheet Using Code Name Quick Fix

Modifies a Workbook.Worksheets or Workbook.Sheets call accessing a sheet of ThisWorkbook that exists at compile-time.

This quick-fix is available for the SheetAccessedUsingString inspection

Applicability

This quick-fix can be applied as a single operation at the following scopes:
  • Procedure
  • Module
  • Project

Examples

Rubberduck.CodeAnalysis.QuickFixes.Concrete.AccessSheetUsingCodeNameQuickFix.cs (Prerelease-v2.5.9.6294)

 Edit this page