make worksheet active

[TR21Mark]

I recorded a macro in Excel that I am calling from Access. However, the Macro is not working on the required worksheet.

I need to make 'qryTransfer1' the active worksheet before the range I have is selected.

I tried

qryTransfer1.Activate

But I need to add something to the procedure.

Can anyone help?

Thanks in advance

 

[andshep]

Hello,

try

Sheets("qryTransfer1").Activate

or am I being a bit simplistic?

 

[TR21Mark]

I was looking at other samples on here and saw how they were putting

sheets(1).Activate

I guess I was looking at that as 'Sheet1'


Thanks for the help