nice, thanks ravinder
Thanks & Regards,
Prabhu R
On 18 March 2014 11:16, Ravinder wrote:
> pfa
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Prabhu Pinky
> *Sent:* Sunday, March 16, 2014 8:02 AM
> *To:* excel-macros@googlegroups.com
> *
pfa
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Prabhu Pinky
Sent: Sunday, March 16, 2014 8:02 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ query need help
Hi experts,
please find the attached file. my query is.
i want to
Sub TES()
Dim i As Long
Dim cl As Range
For Each cl In Sheets("Sheet1").Range("c1:c31")
If Weekday(cl.Value, vbMonday) < 6 Then
With Sheets("Sheet2").Range("XFD2").End(xlToLeft).Offset(0, 1)
.Value = cl
.NumberFormat = "DD-MMM-"
End With
End If
Next
End Sub
On Sun, Mar 16, 2014 at 8
sorry,
in sheet 1 dates will be in vertical, but in sheet 2 i want to fill in
horizontal.
Thanks & Regards,
Prabhu R
On 16 March 2014 08:02, Prabhu Pinky wrote:
> Hi experts,
>
> please find the attached file. my query is.
>
> i want to fill dates in sheet2 from sheer1. only weekdays, excep
