SOLVED

EXCEL ITEM

Copper Contributor

How do I pass a cell's value from an EXCEL spreadsheet to a macro for testing?

 

3 Replies
best response confirmed by VI_Migration (Silver Contributor)
Solution

@WittyGuy55 

    Dim v As Variant
    v = Worksheets("Sheet1").Range("D3").Value
    ' do something with v
Thanks, Hans. I had some trouble getting this to work, but finally figured it out. I’m amazed at how powerful EXCEL can be. I’m 81 and constantly learning new uses for it. Thanks again, David Hill.

@WittyGuy55 

Congratulations, well done!

1 best response

Accepted Solutions
best response confirmed by VI_Migration (Silver Contributor)
Solution

@WittyGuy55 

    Dim v As Variant
    v = Worksheets("Sheet1").Range("D3").Value
    ' do something with v

View solution in original post