assign a value to a named variable of a spread sheet

**ceussk** · 01-20-2013, 11:22 AM

Hello All:

I am a 1 day old newbie on the forum ...so advance apologies if I do not follow the norms ....will bide by the rules soon ...
Have a spreadsheet 'sheet 2' in which I have a named variable "num_1". I was looking for VBA code to assign the value from cell (say "A3") on 'sheet 1' to the named variable "num_2" on sheet 2 while maintaining the integrity of the named variable.

I use the following code but this erases the named variable "num_1" completely from 'sheet 2'
Sheets("sheet 2").Names("num_1").Value = Sheets("sheet 1").Range("A3").value

Thank you!

**mike7952** · 01-20-2013, 11:26 AM

Try this

Please Login or Register  to view this content.

**ceussk** · 01-21-2013, 08:16 AM

Thanks Mike!
That worked...

**Teddytim** · 10-14-2013, 08:22 AM

Mike, this problem is similar to one I am having only I have the possibility of the value passed from A3 as being a blank with a blank being an accepable value.
aka when the field is a blank it means the country is the default or USA. So blank happens a lot.
Unfortunately it causes the code recieving this answer to die.
It's an SQL query. Any thoughts?

**Fotis1991** · 10-14-2013, 08:29 AM

Teddytim

I would like to ask for you to take a look to forum rules. There you'll find anything you need as per example how to use code tags(rule 3) or to don't . Don't post a question in the thread of another member(rule 2).

I also put a link of your thread in case that someone is interest.

http://www.excelforum.com/excel-prog...-if-blank.html