VBA - Setting Range without activating worksheet

[vityata]

Hello people!
I have the following piece of code, that gets error 400:

public sub TestMe
Dim range_for_analysis      As Range
 'tbl_master.Activate
Set range_for_analysis = tbl_master.Range(Cells(current_row, STARTING_FROM_COLUMN), Cells(current_row, calendar_cols + COLUMNS_NOT_TOUCHED))
end sub

However, if I uncomment the third line, it works perfectly. Any ideas how to make it work, without using the activation of the spreadsheet?

 

[minimaster]

The cells object is missing its reference..

Try this..

Public Sub TestMe()
   Dim range_for_analysis As Range
   With tbl_master
      Set range_for_analysis = .Range(.Cells(current_row, STARTING_FROM_COLUMN), .Cells(current_row, calendar_cols + COLUMNS_NOT_TOUCHED))
   End With
End Sub

 

[vityata]

@minimaster -> Good job! I have already starting to live with the idea that I should leave it with the ugly activation
I would have probably never thought of adding tbl_master to the cells.