macro run-time error

  1. F

    Find sheet macro help

    I have a macro that will find a sheet in my workbook. It works great the first time it runs , If I put in a name of a sheet that is not in my workbook it sayes "no record found for (fName) try again" I hit try again and it works but if it doesent find the sheet name the second time I get a Run...
  2. T

    Error running Macro when sheet is protected

    I am getting an error when I protect a worksheet and save it. Upon re-opening the worksheet, I try to use the cells that are being formatted by a macro, but I get the following error... Run-time error '1004': Unable to set the NumberFormat property of the Range Class. If I open the...

Some videos you may like

This Week's Hot Topics