Pete
07-31-2008, 08:40 AM
Hi
how would i make this macro run for the following worksheet "Pricing Supply" "Pricing Demand" and Allocation (Vol)...
and once the macro has run return back to cell row199 column F
Sub Name_Ranges() Range(Selection, Selection.End(xlToRight)).Select Range("E6:EC65536").Select Selection.CreateNames Top:=False, Left:=True, Bottom:=False, Right:= _ FalseEnd Sub
how would i make this macro run for the following worksheet "Pricing Supply" "Pricing Demand" and Allocation (Vol)...
and once the macro has run return back to cell row199 column F
Sub Name_Ranges() Range(Selection, Selection.End(xlToRight)).Select Range("E6:EC65536").Select Selection.CreateNames Top:=False, Left:=True, Bottom:=False, Right:= _ FalseEnd Sub