Can not write string to a cell

  • Thread starter Thread starter wmauss
  • Start date Start date
W

wmauss

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
 
There doesn't seem to be any problem with your code. It works perfectl
fine when i tried it.

- Manges
 
Hi Mangesh,

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

Werne
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top