Hi,
I have just started VBA for the first time in Excel 2007.
I have spent 2-3 hours trying to write text to a cell and I do not understand why it is not working. I have reduced the operation to the simplest form that I can find, now using the following code:
Public Sub FundTransfer()
Dim textout As String
textout = "test"
Range("H388").Select
ActiveSheet.Cells(1, 1) = textout
End Sub
When I execute this operation, no errors are generated. The program indeeds selects the proper cell, but no text is written. It just stays as a white blank cell with no action taken. I have tried numerous variations all with the same result. I can get the text to display with a MsgBox command, but not with the above code.
Can anyone help me with the errors of my ways? Thank you very much.
Clifford E Carnicom
cec102@usa.com
(also, I tried a search function on this topic within this forum, but web page came back as an error page with no result. I am a new member here).
Bookmarks