Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
defining names in a macro
With the below coding and example of my spreadsheet
Dim myRangeD As Range, myRangeF As Range, myRangeC As Range, myRangeE As Range, _ myRangeH As Range, myRangeG As Range Worksheets("sheet1").Activate Set myRangeD = Worksheets("Sheet1").Range("duplex") Set myRangeF = Worksheets("Sheet1").Range("color") Set myRangeC = Worksheets("Sheet1").Range("simplex") Set myRangeE = Worksheets("sheet1").Range("b_w") Set myRangeH = Worksheets("Sheet1").Range("price") Set myRangeG = Worksheets("Sheet1").Range("of_sheets") If myRangeD.Text = "X" And myRangeF.Text = "X" Then myRangeH = (myRangeG * 2 * 0.045) End If If myRangeC.Text = "X" And myRangeF.Text = "X" Then myRangeH = (myRangeG * 1 * 0.045) End If If myRangeD.Text = "X" And myRangeE.Text = "X" Then myRangeH = (myRangeG * 2 * 0.008) End If If myRangeC.Text = "X" And myRangeE.Text = "X" Then myRangeH = (myRangeG * 1 * 0.008) End If End Sub Job Machine Simplex Duplex B/W Color # of Sheets Price 79815 6500 X X 2965 $237.20 79700 C500 X X 420 $37.80 79718 6500 X X 25 $0.10 Each column has a defined name which highlights the whole column. My question is why does my macro only work if I change this line to be Set myRangeD = Worksheets("Sheet1").Range("D3") and not the name |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with defining names | Excel Worksheet Functions | |||
Defining Regions with Names | Excel Discussion (Misc queries) | |||
Excel 2007 defining names (areas) | Excel Worksheet Functions | |||
Defining Names in Excel | Excel Worksheet Functions | |||
Defining non worksheet specific names... | Excel Worksheet Functions |