| |||||||
| Register | FAQ | Members List | Calendar | Arcade | Search | Today's Posts | Mark Forums Read |
| Random Nonsense! A general discussion on all earthly and heavenly things. |
 |
| | LinkBack | Thread Tools | Rate Thread |
10th December, 2001, 07:57 PM
| |||
| |||
| VBA and Excel Just a quick question. I want to assign the contents of a cell to a variable. The code i have is: variablename = Range("Cellreference").Value When i step through the code the variable holds the value within the procedure where it is assigned but as soon as the next procedure is called it returns to its default value of 0. I've declared the variable globally so why won't it hold onto the value? Have I missed something obvious?
__________________      |
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Rate This Thread | |
| |
Similar Threads | ||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Excel vulnerable to zero-day attack | Gizmo | Data Security | 0 | 6th February, 2007 09:17 AM |
| Excel % Comparison | skool h8r | Random Nonsense! | 1 | 9th January, 2007 10:29 AM |
| Quick Excel help needed | Lazgoat | Random Nonsense! | 6 | 9th July, 2006 06:49 AM |
| INSANE: Excel Currency Formatter Issue! (Im Stumped) | Con | OS, Software, Firmware, and BIOS | 5 | 5th February, 2003 07:26 AM |
