defined name

In my worksheet I have a table (RECIPES) with a list of ingredients in column A (A2:A50), a list of recipes in row 1(B1:K1), and the quantity of each ingredient required for each recipe in the range (B2:K50). On a different worksheet I created a new table (DAILYMENU) and in row A1 there is a...

Good morning folks! I am trying to rename a row of cells with incremental names. Ex. A1=Results1, A2=Results2, A3=Results3, ...., AN=ResultsN Of course, it can be done by setting names for each cell separately but it takes ages. I would like to know if this is possible to do that quickly...

I've researched through the forums and haven't found a specific answer, so my apologies in advance if I just didn't look hard enough. I want to highlight cells that contain formulas that reference a specific defined name. The purpose is to show where that define is being used, and where it's...

Hey guys, first of all thanks for the support during the whole time, i used this forum quite regularly I finally signed up because I cannot figure out how to solve a (hopefully) minor problem. I am using VBA to automatically create a bunch of defined names on a help! sheet in order to...

I am working in Xcelsius 2008 and I have created about 100 defined names. These refer to cells on Sheet2 that create ranges. I am having an issue calling the range as it gets returned as text. E.G.: I am using the following to build a range based on where the column header is found...