Cell to Show "Continued" only if > Page 1

Any way to create a cell formula that will show "Continued" ONLY if its
appearing on a page greater than page 1? There is only a single worksheet
with multiple pages.

I'd prefer NOT to use Header/Footer

Steve

--

Hi Steve

you could do this with row numbers

for example, if you're getting 30 rows to a sheet then you could have a
formula in a column like
=IF(MOD(ROW(),31)=0,"continued","")

which will only put the word "continued" on rows 31, 62, 93 etc

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Steve Klenner" <steve_klenner@bsbcom.com> wrote in message
news:eGQDAuISFHA.1392@TK2MSFTNGP10.phx.gbl...
> Any way to create a cell formula that will show "Continued" ONLY if its
> appearing on a page greater than page 1? There is only a single worksheet
> with multiple pages.
>
> I'd prefer NOT to use Header/Footer
>
> Steve
>
> --
>
>