Cell Value

[Greg Franke]

Simple question.

I need to get that value in a specific cell. Can someone show me an example?

Thanks!

 

[Bob Phillips]

var1=Range("A1").Value

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[mark]

dim stVariable

stVariable = range("a1").value