a_moore
asked on
Excel 2000 - How Do you call a sub routine in a different worksheets?
This one has me stumped, how can one call a sub routine that is sitting in a different worksheet in the same workbook? e.g I am currently running a macro in my "main" worksheet and I want to call a sub routine that is sitting in my "sub" worksheet.
Tried the following but it did not work:
Call Sheets("CCS_Export").Expor tTabFile
Tried the following but it did not work:
Call Sheets("CCS_Export").Expor
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Opps :) Knew I had left something out. Suppose that what happens when you have not programmed for quite some time. tx
you could try
sheet1.ExportTabFile
where sheet1 is the object name in the vb editor not the sheet tab name
HAGD:O)Bruintje