VBA defining range only works on selected sheets

I am trying to get the following code to work:

Sub testingthecell()

Dim cell As Range, cell2 As Range

Set cell = Worksheets("Sheet2").Range(Range("B8"), Range("B8").End(xlDown))
Set cell2 = Worksheets("BACKUP").Range(Range("L19"), Range("L19").End(xlDown))
ReDim EUrownum(cell.count)
ReDim ukrownum(cell2.count)

End Sub

I have also tried to refer to the Workbooks("name"). before the rest of this but for some reason to run it I first have to be on sheet 2 and then it will highlight cell2 with an error and then I have to move onto the BACKUP sheet and run to get cell2 to obtain a value. Does anyone know what is wrong here?

You need to qualify all the ranges. try

Please Login or Register  to view this content.

Hi !

Set cell = .Range("B8", .[B8].End(xlDown)) …