Re: Refer in macro to cell

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Dnia Sat, 26 Apr 2008 18:43:41 +0200, niejaki Przemek Wrzesiński w odezwie
<news:1f7q2afrctz6a.dlg@xxxxxxxxxxxxxx> nabazgrał:

Hi,

I have following problem. I've created macro to make some calculations (and
simplify sheets) and I want to refer in this macro to other cell via
offset. How can I refer to cell well I've inputed this function, so I could
use Offset method.

TIA,

Przemek

I answer for others. Application.Caller solved my problems.

Przemek
.

Relevant Pages

  • Re: Help with referencing variable range
    ... The macro is to do the ... >> matches the value found in the cell that is 2 columns to left of object ... >> reference with one that rng is Set to. ... >> offset from the active cell. ...
    (microsoft.public.excel.programming)
  • RE: select cell by variable name
    ... Forgetting about auto-updating the macro, is there any way to select a cell ... When I insert a row after I have recorded a macro, ... What is the correct way to refer to variable names in visual basic? ...
    (microsoft.public.excel.misc)
  • Refer in macro to cell
    ... I've created macro to make some calculations (and ... How can I refer to cell well I've inputed this function, ... use Offset method. ...
    (microsoft.public.excel.programming)
  • Sequential numbers in a formula?
    ... I have a few formulas (OFFSET & MATCH) which are the same (with relative references chanfing accordingly) and occupy cells B2:B500. ... In each formula one of the function arguments refers to a single cell in the ... Can I somehow refer to a sequentially increasing number ...
    (microsoft.public.excel)
  • Automatically go to a cell when opening sheet
    ... guess I figured out a macro that always goes to the cell I need to ... right clicked the sheet I wanted the ... macro in, and used code below. ... ' Scrolls to that offset and makes it top, ...
    (microsoft.public.excel.programming)