How do I embed an OFFSET function in a SERIES function on MS EXCEL?

Question

Using a formula, I'm trying to create a graph based on data from other sheets.  For this, I will need to put an OFFSET function in my range rather than directly stating the cell reference.  However, whenevr I try to do this, it gives me an error.

Is there a way to bypass this error and somehow get an offset equation to be put into a series function?

C Masters · Accepted Answer

I'm not quite sure what you need the OFFSET for but it will not work without at least 3 arguments

$F$6:OFFSET(F7, -1)   only has 2 of the 3 arguments complete which may be why you are getting an error

OFFSET(reference,rows,cols)

hope that helps get you unstuck

doreen · Answer

here ought to offer you the final unused cellular in row a million and place the date in that cellular. dim startcell as selection set startcell = selection("IV1").end(xltoleft).offset(0,a million) startcell.value = Date

How do I embed an OFFSET function in a SERIES function on MS EXCEL?

Related Questions

Trending Questions