[RESOLVED] Get Cell value using cell address

[JJJCR_FOX]

hi guys, how to get the cell value given a particular cell address like: $A$29
Thanks.

[rack]

If you are using VBA in Microsoft Excel then the following will store the value of the cell. You will need to place this in a Sub, either in the weeksheet, or a new Module.

Dim myValue as string
myValue=Range("$A$29").Value

To learn more about Excel VBA, the easiest way is to record a macro, and just start doing things in excel. Excel will create code for you, that you can review later to understand how to perform certain tasks/steps/functions.

• Macro's are located at: Tools > Macro.
• To record one select "Record New Macro"
• Make sure you Stop recording when you are done.
• To easily access the recorded macro Hit Alt+F11 to open the VB-Editor.

If you meant as a formula rather than VBA Code, simply reference the cell with =

 =$A$29

[JJJCR_FOX]

thanks.. rack