Hi ,Just to show a different way of working …
I dislike the concept of direct cell referencing (A1 etc) so I use Names and, as I prefer not to over-use relative referencing, I tend to use array formulae.
I am not even that impressed by the ROW() function because it only returns a location relative to the sheet; something I never have the slightest interest in. I would prefer
= ROW(reference, relativeTo)
which would make it far easier to apply an index to a range.
Hi Peter, That discussion was raised in your last challenge thread.Where was it that the UserVoice request for =SEQ(n) was discussed?
Well, that is a first for me. I do not think I have ever programmed a workbook formula from the immediate window before!Another option is to work with sufficiently large static arrays that may be easily defined from the immediate window