Whats wrong with this code ?

[wmbb]

I get an error using the code below....

DbaseArray = ThisWorkbook.Sheets("test").Range("A1:K100")

leaving out the first part ThisWorkbook.Sheets("test"). the code is correct ??!!
But I need to point to that specific sheet...

Am I missing something ?

The Sheet "test" does exist !

 

[strongm]

What error do you get?

 

[wmbb]

Type mismatch (error 13)

 

[wmbb]

Using the code below does also work but I'm wondering whats wrong with the first code...

ThisWorkbook.Sheets("test").Select
DbaseArray = Range("A1:K100")

 

[combo]

I have no problems with your initial code, even for hidden sheet.Is DbaseArray dimmed? As variant?


combo

 

[wmbb]

Yes it is...

I get this error on 3 different systems now in office 2016

It seems that the combination sheets("test") with .range causes the problem...??

 

[wmbb]

Very strange ....
If I use the code below it also works

Dim ws As Worksheet
    Set ws = ThisWorkbook.Sheets("test")
    DbaseArray = ws.Range("A1:K100")

Very strange...