Results 1 to 2 of 2
  1. #1
    Lounger
    Join Date
    Aug 2001
    Location
    Perth,(aka middle of nowhere), Western Australia, Australia
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    caller address - worksheet? (2000 / VBA)

    I have a very large multi-sheet workbook that performs a whole range of calculations across long series of values, and also x-y tables, using user defined functions largely built around the use of OFFSET. The problem I have is that currently the code is such that when I recalc (F9), the offsets are calculated relative to the active cell and therefore the calculations in the second sheet are wrong if the active cell is in sheet 1 etc and vice versa. <img src=/S/brickwall.gif border=0 alt=brickwall width=25 height=15>

    I don't think that simply looping through the worksheets in the code and recalcing would work as the only one that would be correct would be the last one. <img src=/S/question.gif border=0 alt=question width=15 height=15>

    I can (& do) determine the caller address in terms of cell ref (e.g. B3) using application.caller.address.
    I was thinking that if I can also get the worksheet of the calling cell then I could use this in the code to get an absolute address.

    Does anyone know whether this is possible thru application.caller.address or can suggest another way?

  2. #2
    Lounger
    Join Date
    Aug 2001
    Location
    Perth,(aka middle of nowhere), Western Australia, Australia
    Posts
    30
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: caller address - worksheet? (2000 / VBA)

    Thanks to anyone who looked at this - I think I have a solution - tried before but didn't get it quite right.

    Application.Caller.Parent.Name

Posting Permissions

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