referring current cell in excel

[yoky]

How can I refer to the value in current cell
(where the cursor is) in a macro?

[Cakkie]

You can use the ActiveCell property of the Application Object

Application.ActiveCell




Tom Cannaerts
slisse@planetinternet.be

Programming today is a race between software engineers striving to build bigger and better idiot-proof programs, and the universe trying to produce bigger and better idiots. So far, the universe is winning -- Rich Cook