Refer in macro to cell

  • Thread starter Przemek Wrzesiñski
  • Start date
P

Przemek Wrzesiñski

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
 
P

Przemek Wrzesiñski

Dnia Sat, 26 Apr 2008 18:43:41 +0200, niejaki Przemek Wrzesiñski w odezwie
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
Click to expand...

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

Przemek
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Macro to Combine Data from Multiple Sheets with Cell References 4
Pass worksheet to macro as a parameter 1
Named Range maker code 9
Dynamic Offset from an Application.Goto cell = Date or Time 10
Clean this select case code up a bit. 2
Relative and absolute references in Macros 2
Excel Typed text appears in wrong cell 0
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7

Top