Visual Basic, need help in simple program, very simple

Spawn
#1 / 3

need help in simple program, very simple

I need to write simple macro in excel, it would take range of cells, and
fill them with next days of week/month, begining from actual date. Help i
dont know how to fill next cells with that type of data.... I am just
begining to program so please write as easiest as you can. thnx

Fri, 04 Mar 2005 02:38:39 GMT

Pawe
#2 / 3

need help in simple program, very simple

Quote:

> I need to write simple macro in excel, it would take range of cells, and
> fill them with next days of week/month, begining from actual date. Help i
> dont know how to fill next cells with that type of data.... I am just
> begining to program so please write as easiest as you can. thnx

Try this macro:
Range("F4:F18").Select ' F4:F18 -
range of cells to fill
Selection.NumberFormat = "m/d/yyyy" ' format of date
Range("F4").Select ' first cell
ActiveCell.FormulaR1C1 = "=NOW()" ' get now() function (actual
date)
Range("F4:F18").Select ' repeat selection
Selection.DataSeries Rowcol:=xlColumns, Type:=xlChronological, Date:= _
xlDay, Step:=1, Trend:=False ' fill with days

PawelT

Fri, 04 Mar 2005 19:00:30 GMT

Charles A. Burg
#3 / 3

need help in simple program, very simple

Quote:

> I need to write simple macro in excel, it would take range of cells, and
> fill them with next days of week/month, begining from actual date. Help i
> dont know how to fill next cells with that type of data.... I am just
> begining to program so please write as easiest as you can. thnx

Just use the macro recorder. While recording a macro, press CTRL + ; (that's
control and semicolon) to insert the date in the current cell. Then use
autofill to fill as many cells as you want. Then open the VB editor and
modify your code as desired.

HTH,

Charles

Sat, 05 Mar 2005 06:45:47 GMT