Forum Discussion

WittyGuy55's avatar
WittyGuy55
Copper Contributor
May 31, 2023
Solved

EXCEL ITEM

How do I pass a cell's value from an EXCEL spreadsheet to a macro for testing?  
excel
  • HansVogelaar's avatar
    HansVogelaar
    May 31, 2023

    WittyGuy55 

        Dim v As Variant
    v = Worksheets("Sheet1").Range("D3").Value
    ' do something with v
HansVogelaar's avatar
HansVogelaar
MVP
May 31, 2023

WittyGuy55 

    Dim v As Variant
    v = Worksheets("Sheet1").Range("D3").Value
    ' do something with v
WittyGuy55's avatar
WittyGuy55
Copper Contributor
Jun 01, 2023
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.

Resources