View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default How do I set up a function that skips a cell in a fill?

Maybe you could create a custom list (ToolsOptionsCustom Lists) with a
nearly blank value, say a single dot, and fill using that.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"clubbhouse" wrote in message
...
I am trying to set up a homeschool schedule and need to have a blank cell
but
contine the lessons. I used the fill handle to make the lesson increase,
but
every Friday is a day for our co-op classes. How can I make this happen
without manually going in and labeling the lessons?