| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Jump to "Defined name" range!
Hi,
I need help on how to jump to a "defined name" cell using vba. Please help!! Lets say that a defined name cell is "COST" fo cell A10, how could I write a code to select that cell based on the defined name ? Thanks Tim, |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Jump to "Defined name" range!
Range("COST").Select
HTH Die_Another_Day wrote: Hi, I need help on how to jump to a "defined name" cell using vba. Please help!! Lets say that a defined name cell is "COST" fo cell A10, how could I write a code to select that cell based on the defined name ? Thanks Tim, |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Jump to "Defined name" range!
application.Goto range("COST")
-- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) wrote in message ps.com... Hi, I need help on how to jump to a "defined name" cell using vba. Please help!! Lets say that a defined name cell is "COST" fo cell A10, how could I write a code to select that cell based on the defined name ? Thanks Tim, |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Jump to "Defined name" range!
just like if it wasn't named
Sub gotomynamedcells() Range("mynamedcell").Select End Sub -- Don Guillett SalesAid Software wrote in message ps.com... Hi, I need help on how to jump to a "defined name" cell using vba. Please help!! Lets say that a defined name cell is "COST" fo cell A10, how could I write a code to select that cell based on the defined name ? Thanks Tim, |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Jump to "Defined name" range!
Try that from another sheet.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Don Guillett" wrote in message ... just like if it wasn't named Sub gotomynamedcells() Range("mynamedcell").Select End Sub -- Don Guillett SalesAid Software wrote in message ps.com... Hi, I need help on how to jump to a "defined name" cell using vba. Please help!! Lets say that a defined name cell is "COST" fo cell A10, how could I write a code to select that cell based on the defined name ? Thanks Tim, |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Jump to "Defined name" range!
Bob, how would you access a named ranget from another workbook?
Die_Another_Day Bob Phillips wrote: Try that from another sheet. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Don Guillett" wrote in message ... just like if it wasn't named Sub gotomynamedcells() Range("mynamedcell").Select End Sub -- Don Guillett SalesAid Software wrote in message ps.com... Hi, I need help on how to jump to a "defined name" cell using vba. Please help!! Lets say that a defined name cell is "COST" fo cell A10, how could I write a code to select that cell based on the defined name ? Thanks Tim, |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Jump to "Defined name" range!
Don't think you can in one move, need to select the other workbook, the
Goto. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Die_Another_Day" wrote in message ps.com... Bob, how would you access a named ranget from another workbook? Die_Another_Day Bob Phillips wrote: Try that from another sheet. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Don Guillett" wrote in message ... just like if it wasn't named Sub gotomynamedcells() Range("mynamedcell").Select End Sub -- Don Guillett SalesAid Software wrote in message ps.com... Hi, I need help on how to jump to a "defined name" cell using vba. Please help!! Lets say that a defined name cell is "COST" fo cell A10, how could I write a code to select that cell based on the defined name ? Thanks Tim, |
|
#8
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Jump to "Defined name" range!
I screwed around and got this to work:
Application.Goto Workbooks("Book1.xls").Sheets(1).Range("Test") Die_Another_Day Bob Phillips wrote: Don't think you can in one move, need to select the other workbook, the Goto. -- HTH Bob Phillips (replace xxxx in the email address with gmail if mailing direct) "Die_Another_Day" wrote in message ps.com... Bob, how would you access a named ranget from another workbook? Die_Another_Day Bob Phillips wrote: Try that from another sheet. -- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Don Guillett" wrote in message ... just like if it wasn't named Sub gotomynamedcells() Range("mynamedcell").Select End Sub -- Don Guillett SalesAid Software wrote in message ps.com... Hi, I need help on how to jump to a "defined name" cell using vba. Please help!! Lets say that a defined name cell is "COST" fo cell A10, how could I write a code to select that cell based on the defined name ? Thanks Tim, |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel Message "user defined type not defined" | Excel Discussion (Misc queries) | |||
| "User-defined type not defined" error when trying to send e-mail | Excel Programming | |||
| use variable in Workbooks("book1").Worksheets("sheet1").Range("a1" | Excel Programming | |||
| "Application-defined or object-defined error" while printing excel report | Excel Programming | |||
Hybrid Mode
