VBA .XLAM and Regular worksheet

[bobo999]

Hi there,

I have built a custom .xlam file that I"m using as an excel add-in.

I'd like to write some VBA code which takes ranges from any random worksheet (into an array), and get a range from the xlam (into array).

I can't seem to figure out what combination of This.Worksheet and Active.Worksheet I should use.

Thanks.

 

[bobo999]

I believe this is the solution. You don't have to "activate" the worksheet you want, and then work in it. You can just reference it in each line call you make. Maybe it's not the most efficient way, but it does seem to work.

checkarray = Workbooks("Your.xlam").Sheets("Sheet1").Range("A2:A578").Value

ActiveWorkbook.Activate ' this gets you back to the active worksheet, from where you called the code.