Dim a value???, PROBLEM SOLVED

[elgringo56]

I have no idea what I am doing. I have the entry Dim stTo As String at the start of a macro, then down in the macro I have a line that says stTo = "XXXXXXXX". What I want to do is have the string that I want stTo to be in a cell (lets say A1) and then in the instruction stTo =, have what is in that cell be stTo. does this make sense?
This message was edited by elgringo56 on 2002-10-15 09:10

 

[Derek]

Hi there

Does this help you? Type something in A1 and run this macro code. stTo will pick up your entry from A1 and, in this example, put it in B4

Dim stTO As String
stTO = Range("A1").Value

Range("B4").Value = stTO
End Sub

regards
Derek

 

[elgringo56]

Once again my stupidity shows thru. I had tried that, but it has been a long time since I tried any codeing and I forgot the quotes on the range. Thanks heaps