Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VB code for column fill matching weekends
This will be easy for a VB coder: I have a row with calender dates across
about 100 days (cells E:DV). I want the colums representing weekends to be autofilled and remain unaffected by subsequent conditional formatting (or vb code). Then (this is the subsequent part) rows below must be filled between date ranges obtained from cells from columns, say C and D. Columns C being a start date and D an end date. Note I have used the WORKDAY FUNCTION to identify weekends through numbers 1 - 7, if that would help) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fill in columns by matching a value on another sheet | Excel Discussion (Misc queries) | |||
Auto Fill days of the month (not including weekends) | Excel Worksheet Functions | |||
can I auto fill zip code column when city is typed | Excel Worksheet Functions | |||
Removing a matching code from another cell | Excel Worksheet Functions | |||
code to identify matching text | Excel Programming |