CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. September 16th, 2001, 07:42 AM #1
    yoky
    yoky is offline Junior Member
    Join Date
    Feb 2001
    Location
    Israel
    Posts
    13

    referring current cell in excel

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



    Reply With Quote Reply With Quote
  2. September 16th, 2001, 04:29 PM #2
    Cakkie's Avatar
    Cakkie
    Cakkie is offline Elite Member
    Join Date
    Jan 2000
    Location
    Olen, Belgium
    Posts
    2,477

    Re: referring current cell in excel

    You can use the ActiveCell property of the Application Object

    Application.ActiveCell




    Tom Cannaerts
    [email protected]

    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
    Tom Cannaerts
    email: [email protected]
    www.tom.be (dutch site)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules




Click Here to Expand Forum to Full Width

Featured