Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old September 23rd 08, 05:53 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2008
Posts: 2
Default Named Identity

Hi,

I'm not sure how to ask this, but here goes.

I need a means to mark a worksheet with a Name that will mark it for
future use.
I need a way to Identify a WS programattically so I can print it. I'm
working on a project where some WS's, when you click on Insert-Define-Name
have this context:
for Example: The Name is RetirementSht and in the next Column 'RetirementCF'
& it Refers to ="CF". I just can't find a way to create a Named Identity
like that. I attmepted to use the Create option, label option & Define option
to no avail.

Please help if you can

  #2   Report Post  
Old September 23rd 08, 06:02 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,058
Default Named Identity

Create a worksheet variable
initialize it
Use it

Sub qwerty()
Dim special As Worksheet
Set special = Sheets("Sheet2")
special.Select
End Sub
--
Gary''s Student - gsnu200805


"MyronJames" wrote:

Hi,

I'm not sure how to ask this, but here goes.

I need a means to mark a worksheet with a Name that will mark it for
future use.
I need a way to Identify a WS programattically so I can print it. I'm
working on a project where some WS's, when you click on Insert-Define-Name
have this context:
for Example: The Name is RetirementSht and in the next Column 'RetirementCF'
& it Refers to ="CF". I just can't find a way to create a Named Identity
like that. I attmepted to use the Create option, label option & Define option
to no avail.

Please help if you can

  #3   Report Post  
Old September 23rd 08, 07:18 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2008
Posts: 2
Default Named Identity

Thanx Gary,

You see I don't know how to do thisor I'm just misunderstanding your
instructions)

Create a worksheet variable
initialize it
Use it

And what I didn't mention before is the name of the WS can change. We're
using a WS template with over 10WS and populate it with data for various
puposes, but with similar data. If that makes sense. In fact I have one part
of the program where I create several WS based upon what Stock Symbol is
represented from one of the WS's on the template. I didn't create this but
I'm working on it & have made some real progress & learned alot about Xcel.
but sometimes I hit things that just baffle me. Here's some code that my
friend suggested, but I didn't know where to use it.

Sub AddWSName()
Dim ws As Worksheet
Dim sName As String
Dim sValue As String

Set ws = ActiveSheet
sName = "NewName"
sValue = "=TRUE"
sValue = "=123"
sValue = "=""ABC"""
ws.Names.Add Name:=sName, RefersToR1C1:=sValue
End Sub

As you can see by the code it assumes I already know what WS I need to
name, but that's just the point I need to have it PreNamed, Selected, & then
Activate it then populate it with data, make it visible just long enough to
print it.

I really wish I could send a picture of what I was attempting to discrib
before.

Dave

"Gary''s Student" wrote:

Create a worksheet variable
initialize it
Use it

Sub qwerty()
Dim special As Worksheet
Set special = Sheets("Sheet2")
special.Select
End Sub
--
Gary''s Student - gsnu200805


"MyronJames" wrote:

Hi,

I'm not sure how to ask this, but here goes.

I need a means to mark a worksheet with a Name that will mark it for
future use.
I need a way to Identify a WS programattically so I can print it. I'm
working on a project where some WS's, when you click on Insert-Define-Name
have this context:
for Example: The Name is RetirementSht and in the next Column 'RetirementCF'
& it Refers to ="CF". I just can't find a way to create a Named Identity
like that. I attmepted to use the Create option, label option & Define option
to no avail.

Please help if you can



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Identity Specification tcb Excel Programming 1 March 24th 08 01:09 PM
Excel DCOM Identity Peter Excel Programming 0 November 20th 07 08:00 PM
Identity on Database Fields NormaD Excel Programming 1 June 20th 07 04:37 PM
User identity Tine Excel Programming 1 August 9th 06 02:47 PM
Do anyone know to validating rule for checking the Hong Kong Identity Card no new.microsoft.com Excel Programming 1 November 29th 05 08:29 AM


All times are GMT +1. The time now is 07:18 AM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017