Hi all,

I have a question on the ExtendFormulaeToUsedRows.

After I added this Add-in function, it always prompt an error message stating ....[Select method of Worksheet class failed]........

The worksheet is the first worksheet named Sheet1 which is exactly the the name I entered into Destination sheet.

Does anyone know why is that? I seem to get this error a lot.

Thanks,

Keen