Display contents of cell in macro

's Computer Specifications

in macro have code:
01=Range("a3").value

What code will display value captured in o1?

cell a3 can contained "Product:" or number 4

thanks
rleonard

's Computer Specifications

One way:

MsgBox o1

In article <#(E-Mail Removed)>,
"Robert E. Leonard Sr" <(E-Mail Removed)> wrote:

> in macro have code:
> 01=Range("a3").value
>
> What code will display value captured in o1?
>
> cell a3 can contained "Product:" or number 4
>
> thanks
> rleonard

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
'IF' Macro to insert cell contents to alternate cell if cell not e	Gryndar	Microsoft Excel Worksheet Functions	6	20th Dec 2008 05:02 PM
display contents of cell if adjacent cell equals	Travis	Microsoft Excel Worksheet Functions	1	7th Jun 2008 02:34 PM
Macro to clear range contents when cell contents are changed by us	=?Utf-8?B?U3RldmUgRQ==?=	Microsoft Excel Programming	12	22nd Feb 2007 09:09 PM
Display contents of cell in another cell as part of text string?	mschmidt@carolina.rr.com	Microsoft Excel New Users	3	8th Jul 2006 07:44 PM
Macro to remove contents of cell and move all other contents up one row	adw223	Microsoft Excel Misc	1	1st Jul 2005 03:57 PM