Posted to microsoft.public.excel.programming

Brian Vallelunga Brian Vallelunga is offline

external usenet poster

Posts: 2

Newbie VBA questions

Thanks for this. It really helps.

Brian

Tom Ogilvy wrote:
Dim currentWeekSunday As Date
Dim i as Long
currentWeekSunday = DateValue("10/3/2004")
for i = 0 to 6
With ActiveSheet.Range("E6").Offset(i,0)
.Value = currentWeekSunday
.Numberformat = "dddd m/d"
End With
Next

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Newbie Questions	KS	Excel Discussion (Misc queries)	3	June 18th 09 06:13 PM
Newbie Questions ?	Robert11[_3_]	New Users to Excel	2	February 5th 09 04:12 PM
Newbie questions on spreadsheet	WayneC	Excel Worksheet Functions	5	December 22nd 04 02:42 AM
newbie questions	Eric	Excel Worksheet Functions	1	December 14th 04 04:39 PM
Newbie - two questions	Bill Burke	Excel Programming	4	April 7th 04 09:38 AM

All times are GMT +1. The time now is 01:06 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us