|
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, |
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, |
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, |
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, |
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, |
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, |
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, |
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, |
| All times are GMT +1. The time now is 03:11 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com