Simple VB question

Draupnir

Im relatively new to VB and especially new to using VB in conjunction with Excel.

Heres a real newbie question:

Can someone explain to me, maybe even give me a little code snippet, to write a string value into a cell in an excel worksheet please?

Took me two minutes to figure out how to read from Excel but for the life of me cant get it to write to a worksheet. Its become a blur of .Cells and .Range!!

pickarooney

If I understand you correctly, you have a string variable whose value you want to copy into a particular cell? The way I'd do it is create a DataObject

Dim MyDataObj As New DataObject
Dim MyString As String

MyString = "some stuff"

MyDataObj.SetText MyString
MyDataObj.PutInClipboard

Range("A1").Select

Selection.Paste

Any use to you?

Draupnir

in the end it wasnt quite so complex. it turned out i was just having a bit of a brain fart. thanks for the help man.

RicardoSmith

Record a macro and look at the code it produces. Very handy if you get a duh moment.