> **Rubberduck version information** Version 2.5.2.6039 OS: Microsoft Windows NT 10.0.22000.0, x64 Host Product: Microsoft Office x64 Host Version: 16.0.14729.20260 Host Executable: WINWORD.EXE
**Description** Enumeration members passed to methods are giving a False Code Inspection of 'Unassigned variable'
I Have the below code which formats a sheet. There are multiple sheets in this workbook so i only want to take actions on the first one. However if i have any sheet other than the first activated such as the second the code throws a 1004 error. I am not sure why as i am specifying and defining th...
The inspection results toolwindow is providing a link to the Implicit ActiveSheet Reference page, which includes a detailed explanation of the reasoning, as well as code examples that do and examples don't produce these inspection results; note how the "no results" example is pretty much exactly JNevil's answer below. — Mathieu Guindon3 mins ago
Hi Guys. I have a test which is giving a pass in VBA but a fail in twinbasic (and I think twinbasic is correct). Rubberduck assert.sequenceequals says 10,20,30,40 is the same as 40,30,20,10. Is this down to a difference in how the ducky does the assessment.
@QuackExchange This question on code review now has a bounty on it. I just want some to answer so that I can accept and answer and remove a zombie without deleting the question. @MathieuGuindon ?
@MathieuGuindon I think that's just user being blind. The Cells vs. .Cells is quite very subtle and if you are not familiar, it might be easy to mistake it as calling a function from a module rather than calling a member of some object.
VBA Rubberducking
VBA Rubberducking