Thanks all, it worked.
Regards
On Sun, Jul 3, 2011 at 11:54 PM, STDEV(i) wrote:
> please try:
> =
> Sub ExpiryWarning()
> Dim dTable As Range, t As String
>Dim R As Long, N As Long, *I As Date*
>
>Set dTable = Cells(1).CurrentRegion
>N = dTable.Rows.Count
>
>For R = 2
pls declare "I as Long" then try
On Sun, Jul 3, 2011 at 8:41 PM, Rajan_Verma wrote:
> *Please fill up this format with Some Example data so that we can help *
>
> * *
>
> * *
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-macros@googlegroups.com] *On Behalf Of *Mahreen Ellahi
> *
Hey thanks it worked. Perfect solution
Mahreen
On Sun, Jun 19, 2011 at 11:59 AM, STDEV(i) wrote:
> please check this vba code, hope it helps..
>
> -Standard Module
>
> Sub ExpiryWarning()
> ' siti Vi // Jakarta, 19 Jan 2011
> '
> Dim dTable As Range, t A
please check this vba code, hope it helps..
-Standard Module
Sub ExpiryWarning()
' siti Vi // Jakarta, 19 Jan 2011
'
Dim dTable As Range, t As String
Dim R As Long, N As Long, I As Integer
Set dTable = Cells(1).CurrentRegion
N = dTable.Rows.Count
