ExcelBanter - Excel macro error when opened in internet browser

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Excel macro error when opened in internet browser (https://www.excelbanter.com/excel-programming/295601-re-excel-macro-error-when-opened-internet-browser.html)

Dee

Excel macro error when opened in internet browser

Hello Alec

Try setting the Worksheet in question to be the ActiveWorksheet. Do this

NameOfWorksheet.Activat

then call your WorksheetFunctio

Your Worksheet name may be an Object or ThisWorkbook.Worksheets("NameOfWorksheet"

Dee

All times are GMT +1. The time now is 10:18 AM.