Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reading a cell content and using it later
I have a reference cell, myRef. How can I :
1. Read its content which is either a text or a number? 2. Use this value elsewhere later? Thanks for any suggestions. Tom |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reading a cell content and using it later
Dim V as Variant
V=myRef.Value -- Gary''s Student - gsnu2007a "Tom" wrote: I have a reference cell, myRef. How can I : 1. Read its content which is either a text or a number? 2. Use this value elsewhere later? Thanks for any suggestions. Tom |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reading a cell content and using it later
Thanks! Much appreciate your help.
"Gary''s Student" wrote in message ... Dim V as Variant V=myRef.Value -- Gary''s Student - gsnu2007a "Tom" wrote: I have a reference cell, myRef. How can I : 1. Read its content which is either a text or a number? 2. Use this value elsewhere later? Thanks for any suggestions. Tom |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
When content of a cell changes, content of another deletes | Excel Programming | |||
IE automation, Frames content reading problem, excel 2003 and 2007 | Excel Programming | |||
Creating a text string by reading content in multiple cells | Excel Worksheet Functions | |||
Formula reading formula instead of cell content | Excel Worksheet Functions | |||
Reading content of array formula | Excel Programming |