Filling Series of columns with Dates

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Markus Scheible (anonymous_at_discussions.microsoft.com)
Date: 02/03/05 

Date: Thu, 3 Feb 2005 07:22:50 -0800

Hi Bill,

>P1 going to the right, I need to automatically fill the
dates based on todays
>date for 90 days. Then I change the orientation of those
90 cells to -90
>degrees.
>.
>

in other words: you want the days starting at P1 and
continuing in P2, P3 a.s.o.? Do you mean that by "change
orientation to -90 degrees"? This could go easier like
follows:

For i = 1 To 90
Range("P" & i).Formula = "=today()+" & (i - 1)
Next i

Best

Markus

Relevant Pages

  • Re: Reply to Wolf
    ... probably thinking of the so called "simple cells" of the primary visual ... Orientation and Direction Selectivity. ... selectivity is to measure the spike rate of a single cell in response ...
    (comp.ai.philosophy)
  • Re: Reply to Wolf
    ... cells in macaque visual cortex. ... orientation tuning, retinal eccentricity, and cell type. ... Spatial-frequency organization in primate striate cortex. ... Orientation and Direction Selectivity. ...
    (comp.ai.philosophy)
  • Re: Aligning Gridlines at 45 degrees (Orientation)
    ... The text in the cells must be aligned to 45 degress in order to get slanted ... borders. ... You cannot change the orientation of the cell itself, ... The first row is a higher level group of attributes in which each ...
    (microsoft.public.excel.newusers)
  • Re: Aligning Gridlines at 45 degrees (Orientation)
    ... borders. ... You cannot change the orientation of the cell itself, ... The first row is a higher level group of attributes in which each ... that the outer boundaries of the cells in the first row align with the 45 ...
    (microsoft.public.excel.newusers)
  • RE: How do I rotate text in a word document
    ... You can change the text orientation in drawing objects, such as text boxes, ... shapes and callouts, or in table cells so that the text is displayed ...
    (microsoft.public.word.docmanagement)