Display offset address

**Jaeger** · 02-27-2014, 07:40 AM

Hi All,

I'm trying to display in a cell the address of a cell 3 columns to the left (0,-3), but I need to do this for a range of cells. I was ideally looking for a formula to just place in a cell, but I can't seem to do this, alternatively a vba code would be fine. At the moment I have:

Please Login or Register  to view this content.

I get an error saying object required.

Any help would be appreciated.

**Olly** · 02-27-2014, 07:46 AM

try:

Formula:

Please Login or Register  to view this content.

Using code:

Please Login or Register  to view this content.

**Jaeger** · 02-27-2014, 07:50 AM

That'll do. Thanks!

Display offset address

LinkBack

Thread Tools

Rate This Thread

Display

Display offset address

Re: Display offset address

Re: Display offset address

Thread Information

Users Browsing this Thread

Similar Threads

Offset, Address & Match

[SOLVED] ???? =offset(ADDRESS(ROW(),COLUMN()),1,1,1,1)

Bookmarks

Bookmarks

Posting Permissions