Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Programming / January 2006

Tip: Looking for answers? Try searching our database.

Read cell value with a macro

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
jbuthmann - 25 Jan 2006 02:15 GMT
I tried to record a macro to read the cell value of the active cell.
The macro recorded the actual value of the cell I had selected at the
time.  So if I select a different cell and run the macro it still reads
the same constant value as when I recorded it the first time.  Example:
ActiveCell.FormulaR1C1 = "212"

I want it to read the value of the cell I have selected as a variable
and not a constant.  I have looked through the help files but I must
not be asking the right questions.  Can anybody set me straight?

Signature

jbuthmann

Norman Jones - 25 Jan 2006 02:26 GMT
Hi J,

Try:

       ActiveCell.value

---
Regards,
Norman

> I tried to record a macro to read the cell value of the active cell.
> The macro recorded the actual value of the cell I had selected at the
[quoted text clipped - 5 lines]
> and not a constant.  I have looked through the help files but I must
> not be asking the right questions.  Can anybody set me straight?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.