Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Tom is offline
external usenet poster
 
Posts: 20
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,058
Default 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   Report Post  
Posted to microsoft.public.excel.programming
Tom Tom is offline
external usenet poster
 
Posts: 20
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
When content of a cell changes, content of another deletes [email protected] Excel Programming 4 October 26th 07 08:17 PM
IE automation, Frames content reading problem, excel 2003 and 2007 Piotr Zaniewski Excel Programming 0 August 29th 07 02:37 PM
Creating a text string by reading content in multiple cells smaruzzi Excel Worksheet Functions 3 February 8th 07 05:12 PM
Formula reading formula instead of cell content roy.okinawa Excel Worksheet Functions 1 November 29th 05 03:20 AM
Reading content of array formula Papa Jonah Excel Programming 0 November 29th 04 06:45 PM


All times are GMT +1. The time now is 09:55 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"