Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Workbooks("Master.xls").Worksheets("UpdatedList"). Cells(rw, 2).FormulaR1C1 =
"='[" & FileName & "]PointCount'!R2C5" The above is my line of code that inserts a formula into a cell in my Master.xls workbook the formula links to a value in the worksheet called PointCount from multiple different workbooks. the problem is that if the program encounters a workbook that does not have a worksheet named "PointCount" I get a pop up FileNotFound window asking me to browse to the file that has the worksheet "PointCount" I do not want it to do this. Is there a way to have my macro skip over these files or suppres the "File Not Found" Pop up from poping up ? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Module & Popup dialog | Excel Discussion (Misc queries) | |||
"File Not Found" dialog box | Excel Programming | |||
Creating Custom Dialog Boxex (Popup) | Excel Discussion (Misc queries) | |||
Popup login dialog | Excel Programming | |||
Disable "File Not Found" dialog box | Excel Programming |