ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How to get the value of (https://www.excelbanter.com/excel-programming/447425-how-get-value.html)

Bakar

How to get the value of
 
Hi everyone
Writing macro instead of getting the value of a cell i get tge cell refrerence
example
Cell C1 on sheet1 has a formula result of 1000
Cell C1 is selected in the macro
When i run the macro I gat answer C1 instead of the value that is 1000

Can someone help please \

Thnxs

Bakar

jack_n_bub

Quote:

Originally Posted by Bakar (Post 1606498)
Hi everyone
Writing macro instead of getting the value of a cell i get tge cell refrerence
example
Cell C1 on sheet1 has a formula result of 1000
Cell C1 is selected in the macro
When i run the macro I gat answer C1 instead of the value that is 1000

Can someone help please \

Thnxs

Bakar

Hi,

Can you share the code that you are executing in the macro.
Prashant


All times are GMT +1. The time now is 11:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com