Got a Problem

G

gbell3587

Board Regular

Joined

Jan 30, 2011

Messages

117

• Apr 27, 2011

• #2

What do you mean, can you post code or be a bit more specific please?

 

Upvote 0

C

ChuckDrago

Active Member

Joined

Sep 7, 2007

Messages

470

Office Version

1. 2010

Platform

1. Windows

• Apr 27, 2011

• #3

A variable named USC (Dimensioned as String) and then assigned the value "Southern Cal" works to perfection. Can you clarify your problem?

 

Upvote 0

R

richardeelou

New Member

Joined

Apr 27, 2011

Messages

6

• Apr 27, 2011

• #4

gbell3587 said:

What do you mean, can you post code or be a bit more specific please?

Click to expand...

example: a50=USC Sheet2.b16=Southern Cal
a50=Sheet2.b16

 

Upvote 0

R

richardeelou

New Member

Joined

Apr 27, 2011

Messages

6

• Apr 27, 2011

• #5

ChuckDrago said:

A variable named USC (Dimensioned as String) and then assigned the value "Southern Cal" works to perfection. Can you clarify your problem?

Click to expand...

example: a50=USC Sheet2.b16=Southern Cal
a50=Sheet2.b16

 

Upvote 0

R

richardeelou

New Member

Joined

Apr 27, 2011

Messages

6

• Apr 27, 2011

• #6

gbell3587 said:

What do you mean, can you post code or be a bit more specific please?

Click to expand...

example: a50=USC Sheet2.b16=Southern Cal
a50=Sheet2.b16

 

Upvote 0

jeffreybrown

Well-known Member

Joined

Jul 28, 2004

Messages

5,152

• Apr 27, 2011

• #7

If you are using 2007 then you can not use USC as a named range because it is a column.

 

Upvote 0

jeffreybrown

Well-known Member

Joined

Jul 28, 2004

Messages

5,152

• Apr 27, 2011

• #8

I'm sorry but I was wrong on this. I should have said you can't use something like USC1 since it is a column/cell.

When you enter the named range it should be:
Name: USC
Refer to: ="Southern Cal"

This works for me. Does this help?

 

Upvote 0

R

richardeelou

New Member

Joined

Apr 27, 2011

Messages

6

• Apr 27, 2011

• #9

Southern California 13 930 6.96% 71.54 4.63%

USC 53.5 49 87.60% 35 -3.34%

i'm dealing with data from various sources, and i want to combine the data

i want excel to recognize that when a cell is =southern california, it is also equal to USC

 

Upvote 0

jeffreybrown

Well-known Member

Joined

Jul 28, 2004

Messages

5,152

• Apr 28, 2011

• #10

I'm afraid I don't follow this very well. Look at the signature block and use the HTML maker to provide a screen shot of what you have and what result you desire.

 

Upvote 0