Range

[poiu]

Hello,

The line of code below if giving the error message "Method 'Range' of object '_Global' failed.

Set adjusted_date_cells_in_calendar = Range("FY2012!H9:H39,R9:R39,AA9:AA39,AJ9:AJ39,AS9:AS39,BB9:BB39,BK9:BK39,BT9:BT39,CL9:CL39,CU9:CU39,DD9:DD39,DM9:DM39")

I've tried with and without the word "Set" at the front but I get the same error message. (there are no hidden rows or columns)

Thanks,

Poiu

 

[VoG]

Perhaps

Set adjusted_date_cells_in_calendar = Sheets("FY2012").Range("H9:H39,R9:R39,AA9:AA39,AJ9:AJ39,AS9:AS39,BB9:BB39,BK9:BK39,BT9:BT39,CL9:CL39,CU9:CU39,DD9:DD39,DM9:DM39")

 

[poiu]

Thanks again VoG!