Populating Specific Cells Using VBA
Posted
by Daniel
on Super User
See other posts from Super User
or by Daniel
Published on 2010-04-21T14:46:28Z
Indexed on
2010/04/21
14:53 UTC
Read the original article
Hit count: 397
I am using VBA to pull from a SQL table and it automatically populates cell E14. Not sure why it's that cell, but is there a way to specify which cell it pulls the data into?
Here's what I have right now:
strSQL = "SELECT distinct Source FROM dbo.Simulations WHERE SimulationID = 5
© Super User or respective owner