macro

C

Christopher Brooks

Hello,

Why does this code hang on Range("A1:D205").Select
? I got it by running a macro.


Set WB = Workbooks.Open(fileName:=FName)
WB.Activate
Range("A1:D205").Select

Thanks.

-cnb
 
G

Guest

Try adding 'Activesheet." before range

The code should be Activesheet.Range("A1:D205").select
 
E

Earl Kiosterud

Christopher,

Some possibilities"

Since no sheet is specified, whichever sheet was active when workbook FName
was last saved is the sheet that will be used. If it's a chart sheet, the
Select will fail.

There may be a scroll range set that's inside the range of A1:D205
 
Top