namerange

Hi all, <tbody> Manufacturing line Type1 Type2 PPA New product PPA ELH Basic PPA Old product ELH Advanced ELH </tbody> I am trying to create dependant dropdown lists so that based on Manufacturing line, Type1 and Type2 are possible to be selected. So if I select PPA New product...

Hello and thanks in advance and I will provide feedback to any assistance on solutions. I'm trying to name range a large amount of cells and would like to use a VBA loop to do it. I am naming a column of cells from (20, 3) to (20, 69). That's 50 cells in column C starting on the 20th row and...

I want to in same workbook. The name range is called ReportCopy and the range formula is a dynamic =OFFSET('C_Register'!$H$1,,,COUNTA('C Register'!$H:$H),6) The Macro I am trying to us is: ' ' Sheets("C_Register").Select Range("ReportCopy"). Selection.Copy Sheets("Report").Select...

Would like to automatically alphabetize named ranges on one of my sheets.. I have about 20 columns all defined name ranges, The data it pulls is text, specifically its peoples names. I want these columns to alphabetize automatically. Vb code I would assume. HALP! Need this for my valet...

I have the code below which works ok if name range if found but if name range is not found then it is giving error.. Please help. Thanks Pedie;) Sub test21() Dim r As String Sheets("Sheet1").Select If Range(r) Is Nothing Then MsgBox "Name missing..." Exit Sub Else...