On 2002-05-09 18:31, Jay Petrulis wrote:
On 2002-05-09 17:00, elgringo56 wrote:
Nate, I live down in mexico and have no books or anything, but am trying to learn this. Could you tell me what the [] means in that one oppsoed to (). I kind of understand the formula here except for those symbols. Thanks again.....ElGringo
Hi ElGringo,
The brackets around the number are technically a shortcut way to use the Evaluate statement in VBA (although it is more limited than the full Evaluate).
In this case, it is also a shorter way to say Range(your cell).value.
[a1].value = "'=" & [a1].value
is equivalent to
Range("a1").value = "'=" & Range("a1").value
I personally do not prefer this method, but it definitely is clean to see in code.
Don't worry about the books. If you can, pick up one of John Walkenbach's Power Programming books and get a feel for VBA coding. If you stay around here, your knowledge will soon surpass John's writing in all but the more advanced chapters.
If you can't get a book, by all means learn from the newsgroups. Ask questions and answer fi you can. If you are wrong, somebody will surely tell you -- and almost always in a nice way.
Bye,
Jay