Highline Excel Class 03: Names, Cell References, Formula Inputs

I am working with files with defined range names. These name ranges refer to
on cell only. I want to change all formulae in the file: change range name
back to cell reference (so I can delete the range names).

E.g. cell $A$42 is called range "ip_con" - there is a formula in cell b99
that says "=ip_con +200". I want the formula to say "=$A$42+200".
Obviously, there are a lot of these references, so looking them by manually
is NOT an option.

Any help would be appreciated!!!!

Hello,

I'm trying to find out the class name for an Excel Userform.

When I say class name I mean things like XLMAIN etc


Thanks

I am attempting to re-work an existing worksheet that contains cells that have been "named". Does anyone know how to change or delete a name once entered into the "Name Box"? When I attempt to write over the names, I receive and error message regarding references. Thank you.

I have two sheets in my workbook. Sheet1 is able to see all cell references in both Sheet1 and Sheet2. The Sheet2 is only able to see references to cells contained on Sheet2.

How can I make the cell references visible to both sheets?

Thanks

I want to use a vlookup formula that will reference a cell that contains the name of the tab the vlookup should reference. How do I do this?

For example, I have tabs A, B, and C. I want to put the names of A, B, and C in three difference cells and reference the vlookup to these cells. I tried the indirect formula inside of vlookup, but that didn't seem to work. Any ideas?

I have a summary sheet which has a listing of all 75 worksheets within the workbook.
On each worksheet, I have a number, which is in the same location on each sheet (K2).
I want to use a formula to look at the value in column "A" (which is the name of the worksheet), and put the data in K2 from the worksheet it is referring to into column "B".

Sounds simple, but I've been banging my head against the wall for 3 hours trying to figure it out....

Hi,

I am using the formula below and others like it to extract certain data from
a single workbook into several different workbooks. I have multiple sets of
information that are all on different sheets, but the workbook name and cell
location remain the same.

Instead of changing the "345KV CANIFF STEPHENS" portion of my formula 20
times per new workbook, I would like to be able to use a formula that would
get the sheet name from cell A1. How can I do this?

='[345KV AND 120KV FOR ITC UPDATED 11-7-03.xls]345KV CANIFF STEPHENS'!$N5

I would also like to know if there is a way to list all of the sheet names
on one sheet.

Thanks,

Reed

Hello,

I have an old workbook that has one sheet (say 'Sheet2') with formulas referencing cells in another sheet (say 'Sheet1'). Recently, the Sheet1 has had the data in its cells defined into names, so now I would like Sheet2 to use those names instead of cell references in the formulas.

When I try to Apply Names, however, I get the following error popup:

Microsoft Office Excel cannot find any references to replace.

I don't get this error message if I Apply Names to formulas in Sheet1. Is this a limitation in Excel that Apply Names will only work in the same worksheet as where the named cells are located? How do I get around this?


Best regards,

g

Hi,

I have a workbook with a macro that copies my template sheet, inserts
it as a new sheet at the end of all the sheets, and renames the new
sheet to Week x+1, one higher than the sheet before.

I have several cells that refer to the previous sheet, using INDIRECT
and PrevSheet:
Function PrevSheet()
'=INDIRECT("'"&PrevSheet()&"'!D48")
On Error GoTo EndFunction
Application.Volatile True
PrevSheet = Application.Caller.Worksheet.Previous.Name
Exit Function
EndFunction:
With Application.Caller.Parent.Parent.Worksheets
PrevSheet = .Item(.Count).Name
End With
End Function

The problem with this is that I add rows to my sheets, which means that
the information I'm targeting is no longer in D48, and the INDIRECT
reference doesn't change.

I was wondering if, on my template sheet, I can replace
=INDIRECT("'"&PrevSheet()&"'!D48") with =?D48 and then have a macro
search out the name of the previous sheet, and replace all the ? on my
new sheet with that name. So after the macro has run, the cell in
question will now read ='Week 24 2006'!D54 (or equivalent). Hopefully,
that reference will then change as I add rows to the sheet called Week
24 2006.

Any suggestions?

Thanks for any help you can give,
Helen

Hi everybody,

I need to retrieve a list with all names i defined with their cell references in order to check them if they were referenced correctly by avoiding each time using the toolbar (insert>names>define) clicking each name separately takes too much time .Is that possible?

Thank you much for your support .