Selecting range in another workbook

[telesien]

This should normally work and I guess the problem would be with the "activecell" syntax, which creates problems since I refer to another workbook.

Any idea how to fix this so it works? Googled several questions, but didn't find this specific problem. It keeps returning '1004' error, Method 'Range' of object'_Wokrsheet' failed

Thanks

Dim WS as Worksheet
Dim DataRange as Range

Set WS = Workbook(name).Sheets(name)
Set DataRange = Range(Range("A2"), ActiveCell.SpecialCells(xlLastCell))

DataRange. select

 

[louisH]

Hi,

Can you try this ?

Dim WS as Worksheet
Dim DataRange as Range

Set WS = Workbook(name).Sheets(name)
Set DataRange = WS.Range(WS.Range("A2"), WS.Range("A2").SpecialCells(xlCellTypeLastCell))

DataRange.Select

No need to use ActiveCell since SpecialCells(xlCellTypeLastCell) always returns the last cell used in the sheet.

 

[telesien]

Hi,

Can you try this ?

Dim WS as Worksheet
Dim DataRange as Range

Set WS = Workbook(name).Sheets(name)
Set DataRange = WS.Range(WS.Range("A2"), WS.Range("A2").SpecialCells(xlCellTypeLastCell))

DataRange.Select

No need to use ActiveCell since SpecialCells(xlCellTypeLastCell) always returns the last cell used in the sheet.

Thanks, this did work. I am pretty sure I tried it as well, but I must have made some other mistake there, because it didn't