Skip to content

Member 'Range' implicitly references 'ActiveSheet': should be "Application" #5970

Open
@SystemsModelling

Description

@SystemsModelling

Rubberduck version information

Version 2.5.2.5906
OS: Microsoft Windows NT 10.0.19042.0, x64
Host Product: Microsoft Office x86
Host Version: 16.0.15028.20160
Host Executable: EXCEL.EXE

Description
A Code Inspection Warning is Member 'Range' implicitly references 'ActiveSheet
It should be Application because the argument may include a reference to a different sheet.

To Reproduce

sAddress="Sheet1!A1:B4"
? range(saddress).Count
 8 
? activesheet.name
Sheet2
? activesheet.range(saddress).Count
Error 1004

Metadata

Metadata

Assignees

No one assigned

    Labels

    difficulty-01-ducklingIssue where no particularly involved knowledge of the internal API is needed.edge-caseMarks a bug as an edge case that would be nice to fix, but that likely doesn't affect normal use.feature-inspectionsgood first issueWant to contribute? That's a good place to start!up-for-grabsUse this label in conjunction with a difficulty level label, e.g. difficulty-02-duckyuser-documentationThis issue relates to feature documentation that is exposed by Rubberduck or on the website / wiki

    Type

    No type

    Projects

    No projects

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions