Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to test for a specific text string and write value to another | Excel Worksheet Functions | |||
Can I write an infinite amount in a cell with expanding the cell? | Excel Discussion (Misc queries) | |||
How can i write a vba code to get string or integer "C15" from $c$15? | Excel Programming | |||
Create a formula into a String then assign string to a cell | Excel Programming | |||
Question: Cell formula or macro to write result of one cell to another cell | Excel Programming |