Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Dave Peterson wrote: Are you bothered by the dialog you get that asks you where that non-existent sheet is? The formulas I had in place returned the REF# error because the sheets were not yet created. I was bothered by that error, but also by the fact that when the sheet was actually added, the formula's reference to that sheet would change to REF# as well. However, like I said above.... that last formula seemed to work out for me. Thanx. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Search one worksheet to pull data into another worksheet | Excel Worksheet Functions | |||
Search and calculate formula | Excel Worksheet Functions | |||
VBA Code to search and calculate. | Excel Programming | |||
Formula to retrieve range of dates from a worksheet to calculate d | Excel Worksheet Functions | |||
Create a search Field within a worksheet to search command buttons | Excel Programming |