Can not write string to a cell
 

Hello everybody,

I want to do a really simple thing and just can't accomplish it.
I just want to write a string into a cell using VBA.

A simplified version of the vba code looks like this:

Sub Testing()
Application.Volatile
'Cells(1,2).Item="Geht nicht"
Range("A1").Value="Geht auch nicht"
End Sub

If I step through it in Debug mode, it terminates when executing th
Cells... or Range... line.

Looking at the simplicity, it has got to be some fundamental principl
that I don't get. :(
I appreciate your help!

Werne

--
Message posted from http://www.ExcelForum.com

Can not write string to a cell
 

There doesn't seem to be any problem with your code. It works perfectl
fine when i tried it.

- Manges

--
Message posted from http://www.ExcelForum.com

Can not write string to a cell
 

Hi Mangesh,

thanks for trying it!
I could confirm it meanwhile. I don't know what was causing the troubl
earlier.

Werne

--
Message posted from http://www.ExcelForum.com