Offset Alters Entire Range, Need To Offset A Single Cell

**Genus Max** · 01-26-2020, 10:04 AM

Hi, Im trying to offset the range in ValuesRange = Range("A1:A4"), but I need to just offset cell A4, atm it offsets the entire range so it looks like : A2:A5 A3:A6 etc., I just need the A4 part offset, so it looks like A1:A5, A1:A6, A1:A7 etc.,

Is there anyway to do this, without splitting the range into two variables?

Thanks.

Please Login or Register  to view this content.

**Andy Pope** · 01-26-2020, 10:35 AM

Sounds like you need resize rather than offset

This would extend the range by 1 row each time it was executed

Please Login or Register  to view this content.

**Fluff13** · 01-26-2020, 10:36 AM

How about

Please Login or Register  to view this content.

**Genus Max** · 01-26-2020, 10:36 AM

Awesome, thanks

**Fluff13** · 01-26-2020, 10:47 AM

You're welcome & thanks for the feedback

Offset Alters Entire Range, Need To Offset A Single Cell

LinkBack

Thread Tools

Rate This Thread

Display

Offset Alters Entire Range, Need To Offset A Single Cell

Re: Offset Alters Entire Range, Need To Offset A Single Cell

Re: Offset Alters Entire Range, Need To Offset A Single Cell

Re: Offset Alters Entire Range, Need To Offset A Single Cell

Re: Offset Alters Entire Range, Need To Offset A Single Cell

Thread Information

Users Browsing this Thread

Similar Threads

Expand range of offset/indirect formula to expand to entire range

How to offset previously offset-ed cell ?

Using OFFSET function to return the value from another cell with row and column offset

Offset function not capturing entire range

function similar to offset to offset the offset

Reformatting - insert formula with offset, then offset to next cell

IF and OFFSET: how to OFFSET only if cell has a value in it (follows previous post)

Bookmarks

Bookmarks

Posting Permissions