Forum Discussion
EXCEL ITEM
How do I pass a cell's value from an EXCEL spreadsheet to a macro for testing?
Dim v As Variant v = Worksheets("Sheet1").Range("D3").Value ' do something with v
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.
Congratulations, well done!
