Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Advertisements:










Reminder: Past Due Date


I want to create an Excel file, which would create alerts/reminders based on dates specified in certain cells. I want to create a database of various events (for ex. Invested in XYZ stock at $10 per share) and put a date in one of the column of each record. I want excel to remind me to take a look at that record after, say, 30 days.


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Is Date Past X Weeks From Current Date
How would I write an if statement that checks to see if the date entered is two weeks past?

View Replies!   View Related
If Functions And Date :: When Something Is Past Due
I am trying to create a function that will tell me when something is past due.

I have a excel document for my office's accounts payable, it has a master sheet where all of the companies that we pay are listed, and they are linked so that you can click on the name and it will take you right to the page to see a more detailed breakdown.

I am trying to figure out how to make something on the master page to tell me when something is due, even if it just makes an X when it is past due.

There are about 73 worksheets in this document and each worksheet contains many dates.

Is this even possible for me to do something like this? If not does anyone have any suggestions?

View Replies!   View Related
Send Email When Date Past
I have a workbook that records incoming mail and each of these mail need to be responded to. I like to have a macro that can automatically send a standard notification email when certain condition are met.

In this workbook the date of receipt of mail is in Col. D and date of Reply in Col. E.

If Col E is blank or 30 days later than Col. D a standard email is sent to the email account of the person in Col. F. Col. F shows the email address only.

View Replies!   View Related
Strikethrough Code To Activate When End Date Is Past
I have this code below, which someone from this forum kindly kindly gave to me for my Worksheet code. What it does is check the value in a dropdown list in column I and if it says "Cancelled" then strikethrough columns A-K of that row.

What I wanted to know is this, in cell N2 has the formula to show todays date. In column D9 onwards is an end date. How can I amend the code below so that it also checks to see if the date in Column D9 onwards is greater than N2 and if so strikethrough columns A-K in that row?

Would it be in the form of an OR statement in the code below?

View Replies!   View Related
View Customers Past Due Date With Other Criteria
I need a macro that will find a row on "Sheet4" that has the word "YES" in column "K" and then varify that there is a balance owed (<$0.00) in column "N" of that same row. If there is a balance owed I need the macro to copy the data from that row into a specific place on "Sheet2" (Column "C" to E10 on the new sheet, D to E11, Q to E12, R to M12, S to T12, G to Y26, H to AF29, M to AF30, N to AF32, and lastly the current date to AC10) then Copy that sheet to a new workbook then rename the copied sheet the the Value of "E10" on that sheet and then clear the data on "Sheet2" so that only the information that was on the sheet before the data transfer is left, If there is no balance owed then it continues down column "K" on it's own to check the next one until it reaches the end of the data in "sheet4" (which is row 2111).

My goal is to be able to use this Macro to sift through a list of customers and to find ones that are past due on their bill (Based of of Column "K" which states that Yes the Bill is past due, and then variefies that it hasn't already been paid by checking the Balance Due Column "N") and then transfers their customer information to an invoice and then moves the invoice to a New workbook (So as to not clutter up my already to large Customer workbook)

This is the code that I have been playing with but i'm getting stuck on how exactlly to do this so i'm sure theres a lot in there that doesn't make any sense.

Sub FindandCopyRows()
Dim Data As Variant
Dim DataFound() As Variant
Dim iValue As Integer
Dim j As Long
Dim i As Integer

View Replies!   View Related
Lock / Protect Rows Past Due Date
I have a workbook list of activities that I am hoping will visualise the scheduling of routine maintenance tasks in my engineering department. The date of the most recent check is entered in row 6 and the interval in row 5. Hence the number 7 denotes a weekly check. The conditional format is such that the reds indicate that a check needs to be carried out. If the check is done on the scheduled day then a "Y" is entered into the square. This will then turn the square green. If "Y" is entered on any other day then the square turns orange to indicate the check is done, if not on time. The red squares do not change colour unless a yes is entered. This is designed to show the history of checks and give us the opportunity to show compliance to routines. What I need to do is lock the rows that have passed the current date, to prevent unscupulous modification. Thus the macro would look down column A and if the date is less than today() would lock the row. I have truncated the file as much as I can. A nice to have would be the facility for an adminstrator to go in (perhaps password protected) to make changes if necessary.

View Replies!   View Related
Color Cells Past Current Date Plus X Days
I currently have a sheet that shows monthly tasks and their due dates. There is also a control that when clicked, resets the due date to the following month of the same day.

What I would like to do is setup some type of reminder such as either flash the due date cell if possible or change the fill color. It should do this when the system date is = to or 4 days before the due date.

The only way I can see doing this is using VBA, which I do not know very well.

View Replies!   View Related
Highlighting Birthdays (inc Birth Year) Past Today's Date
I have a list of birthdays (in date-month-year format) and simply want to highlight them if the date and month are past today's date.

View Replies!   View Related
IF And AND; Add A Line To The Code So Date Picked By The User Needs To Be Both Weekday And Not A Day In The Past
See attcahed code. I need to add a line to the code so date picked by the user needs to be both weekday and not a day in the past.

e.i today : 20/06/2006

if user pick a date before today or a weekend date pivot table does not update.

Private Sub MonthView1_DateClick(ByVal DateClicked As Date)
Application. ScreenUpdating = False
If Weekday(MonthView1.Value, vbMonday) < 6 Then
With PivotTables("PivotTable1")
.PivotFields("DATE").CurrentPage = Format(MonthView1.Value, "dd/mm/yyyy")
End With
End If
Application.ScreenUpdating = True
End Sub

View Replies!   View Related
Pop-up Reminder
Macro that automatically runs a task when the workbook is opened. I want it to keep track and monitor the due date so that a Pop-up Reminder can be triggered. By the way, is it possible to display a image as well? Pls take a look at my attachment for better understanding.

View Replies!   View Related
Reminder For Over Due Dates
I have a task follow-up sheet that I have made for my manager, where I need I have a column to set the date when the item is entered or the date the item was discussed in meeting, etc. Then I have an additional column with "due date", here I select the date that the task needs to be completed or the date when I should be getting feedback.

What I would like is to have a pop-up that opens and tells me which tasks are due today. This could happen as perhaps a check everytime that I open my Excel file.

I realize that a conditional formatting can be used, to change the color and highligh items that are due, but I really want a pop-up, this will really make my life easier and communication to my manager easier as well. Plus my manager could use this file without me present. Allowing for less meetings to discuss list.

I have uploaded the sheet that I have so far.

View Replies!   View Related
Reminder Worksheet
I have got a workbook were I register our personnel.
In one sheet I have listed all our personnel and the dates their contracts expire.

Now this is what I am looking for:

Between 15 days and zero daysbefore someone's contract expires I want a pop-up telling me so. The person's name has to be in the pop-up.

I already got this
Private Sub Workbook_Open()
Dim c As Range
For Each c In Range("E2:E126")
If c > -15 And c < 0 Then MsgBox c.Offset(, -3), vbOKOnly + vbInformation, "LET OP! Einddatum contract nadert!"
Next
End Sub

I want the pop-up only when I open the workbook(not everytime I change something in the workbook)

In the workbook are more sheets, the code I have only works with one sheet.

View Replies!   View Related
Reminder On Every Other Friday
Every other Friday, I need to submit my biweekly work hour sheet to manager. For example, as 12/21/2007 is Friday and pay day, I need to submit my sheet. Next time is two weeks later, 1/4/08, and on.
12/21/07 is the first event.

I want to create a conditional format, or workbook events, or worksheet events to remind me on that Friday when I open that book or activate that sheet.

View Replies!   View Related
Automatically Run A Reminder
Our company has a delivery schedule, based on Excel 2003, WinXP. Is it possible to set up reminders (for next scheduled deliveries in a future?

View Replies!   View Related
Pop Up Reminder Listing Cell Then Go To It On Yes
Column B on worksheet3 has a list of dates on it. Column C states set reminder. Column D states how many days before reminder i.e. 3, 7, 10, 14. If the reminder is set to on. Can VBA code be run when the Workbook (or worksheet) that checks this criteria then a pops up is displayed outlining the event (say Cell A)?

Also is it then possible to have on the pop up - Go to this event (i.e. row of data?)

View Replies!   View Related
Reminder When Closing A Workbook
I have 4 employees who at the end of their shifts have to email me an excel workbook. The issue is that some of them are forgetful and after placing numerous post-it notes on their monitors one particular employees just forgets.

What i want to do if possible is that when the workbook gets closed, a pop-up window shows up on their screen reminding them to send the workbook. Even better would be if their was a button that they could click that would email the workbook as an attachment in the pop-up box.


View Replies!   View Related
Automaticaly Show Pop-Up Reminder
i would like to know if Excel offers a feature whereby reminders for instance to call a client will pop up when you open a particular file? I am not referring to the comments tags that one can insert. I am looking for a type of pop up screen function ?

View Replies!   View Related
Reminder Statements Written In The Message Box
creating a MSG box to be placed at the start of the code, i need the following reminder statements written in the message box. If the answers to all statements is Yes then proceed running the code.

1. Is the value date in Sheet Summary Correct?
2. Is the workbook free of errors, check sheet "Errors"
3. Are all the graphs up to date?

Sub Save_File()
Application.ScreenUpdating = False
Sheets(Array("SUMMARY")).Copy
With ActiveWorkbook
.Sheets("SUMMARY").Cells.Copy
.Sheets("SUMMARY").Cells(1).PasteSpecial xlPasteValues
.SaveAs Filename:="S:Recsdata ReportingRec StatsSummary Stats" & Format(Date, "yyyy\MMM") & _
"Stat Summary_" & Format(Date, "dd-mm-yy") & ".xls"
.Close False
End With
Application.ScreenUpdating = True
End Sub

View Replies!   View Related
Figure Out How To Do An If For The Over 30,60,90 Past Due
Here is what my table is im working with. The tite "todays date starts in Cell A1 and B1 is =Today().

I need to figure out how to do an if for the over 30,60,90 past due. Here the logic I need to figure out:

in the Over 30 column, the logic of the statement is as follows: If the difference between today's date and the date of the invoice is greater than 30 and equal to or less than 60, the amount goes into this column.(over 30 E3) To get the amount(the ammount in C3) into the Current column, the difference between the two dates must be less than 30. To get into the over 90 column, the difference between the two dates must be greater than 90. You can figure out the over sixty column. And this needs to be copied to the remaining colums

Today’s date: =TODAY() Shop Invoice Date Invoice Amount Current Over 30 Over 60 Over 90 Ludwig's Landromat =TODAY()-72 $432.78 Willie's Washing =TODAY()-107 $565.11 Wash It Here =TODAY()-80 $308.47 Spiffy Wash and Dry =TODAY()-58 $725.37 Water Soap & Hot Air =TODAY()-30 $427.95 Wash it & Dry it =TODAY()-90 $603.91 Acme Wash & Dry =TODAY()-60 $332.35 Totals

View Replies!   View Related
Flag Past Due Dates
to set a conditional format and include a function code in it as well?

I want a spreadsheet to change the color/font of a cell/column based on a comparison of a "start date" cell and a "due date" cell. This is to automate the process of highlighting items that have gone past the due date in the second cell. I was trying to do this by looking at the "now()" function and comparing it to the due date.

View Replies!   View Related
Past Days Calculation
I would like to calculate how many days past since the special Cell have been filled with data.

For exampl:

If Cell A1 filled with the data in Cell B1 I need to show the day number, if I close the file and open it next day it will show number 1 as a one day past.


View Replies!   View Related
Calcualting Past Due From Dates
I want to take a date (ex. May 25, 08 is in cell A2) and calculate 30 days (A2+30)June 24, 08(A6) and what i am trying to due is calculate if it is past due.

I used the if command but it does not seem to be calcualting the date plus thirty, it is only taking the date that is listed. (ex. instead of calculating =IF("A2+30"

View Replies!   View Related
Average For The Past X Days
I want to keep track of housekeeping attendants' average productivity of rooms cleaned per day/shift for the last 10 days worked.

I need a formula which will give me an average of the 10 most recent cells with a value (0 should be counted).

I also want to have each month in a separate tab, and for the formula described above to average between two tabs should the 10 days cross-over.

View Replies!   View Related
Due Dates To Days Past Due
I am trying to create a spread sheet in excel that will show a number of days past due counting from the due dates. see the attached xls file for details.

View Replies!   View Related
Copy And Past Only If The Cell Is As Stated
I have information across 5 cells what I want to say is if P3 is not equal 00/01/1900

Then copy and paste values of P3,Q3,R3,S3,T3 in a new sheet in cells P3,Q3,R3,S3,T3.


View Replies!   View Related
Calculate Time Past Sunset
I'm trying to calculate the total time past an arbitrary time. If my start time is 17:00 and end time is 21:00 and I select a 19:00 as sunset time, How do I calculate the time past 19:00.

the formula I been using, a2-a1, but that calculates the total time between 17:00 -21:00.


View Replies!   View Related
Calendar Control Vba Not To Go Past One Year
I have the following code in my calendar initialize: ....

View Replies!   View Related
Lock Past Rows As I Trigger A New One To Appear
This (unprotects the sheet first, then) unhids rows (starting at row 1500, until it reaches row 4). Now my most current vexation- How do I lock/protect the past rows?
Say a co-worker enters information in row 1500 and walks away. The next co-worker inserts a new row (which would be row 1499) to place data in there, how can I get row 1500 to lock (or become protected) as the new row (which in this case 1499) would become unhidden?
It would be very important that the information in the previous rows remain locked so that nobody can change any client information (unless they had supervisory/administration access).

If it is not possible to protect or lock the whole row, it would also work if I could just lock one of the cells in the previous row.

I am using the following
Sub Row_Unhiding()
'
' Row_Unhiding Macro
' Macro recorded 2/12/2009 by gr8_big_geek
'
' Keyboard Shortcut: Ctrl+i
'
ActiveSheet.Unprotect Password:="secret"
R = 1500
Do Until Rows(R).Hidden = True
R = R - 1
If R < 4 Then
MsgBox "No more rows to add!", vbCritical, "Error"
Exit Sub
End If
Loop
Rows(R).Hidden = False
ActiveSheet.Protect Password:="secret"
End Sub


View Replies!   View Related
Counting Hours Before And Past 6 O' Clock
In cells B8 and C8 an in- and out-time are given, in E8 the time in between.
Now I'd like to calculate the number of hours before 6 o'clock and the number of hours past 6 o'clock.

The formulas I came up with work great in the first example, but fail in the second, because the start day is on another day.

View Replies!   View Related
Summing Values For Past 24 Hours
Several times per day, I have an excursion of a value over a specified limit. The excursions are measured in seconds. I am interested in a way to sum the number of seconds accumulated in a rolling 24 hour period. Is there an easy way to do this?

Example:

Time One 20 seconds
Time Two 35 seconds
Time Three 82 seconds
etc.

If time one and time two are within 24 hours of each other, the sum I would want is 55. This is in Excel 2007. a portion of the data is attached.

View Replies!   View Related
Calculate Total Hours Past 24
Is there a method to calculate the total number of hours in excel. In my attached file, the excel treat the 24 hours as time and recalculate from 0 hour.

View Replies!   View Related
How To Past A Range Of Data To One Single Cell
i have my data in coloumn G. and i am trying to create a macro to copy all the data in coloumn G:G to cell K1. i am doing this so i cand simply extract some data to other cells useing the search formula.

View Replies!   View Related
Function To Count Multiple Past Due Dates
I need a formula that can count items that are past due by up to 30 days, 60, or 90 days. I'd guess the total of all 3 values should = the total past due.

I have the total past due as =COUNTIF(A!I$1:I$278, "<=" & TODAY() )

View Replies!   View Related
Hlookup To Skip Past First Found 'lookup_value'
I'm using the following formula "=HLOOKUP($B$4,Arg!$D$10:$DA$50,5,FALSE)" With Cell $B$4 as the 'Lookup_value' I wish to pull the second instance of the 'lookup_vlaue' not the first from within the 'Table_Array'. Later on I'd like to skip to the 3rd column/instance etc. It's not practical for me to change the size of the 'Table_array'

View Replies!   View Related
Highlight Cell If X Days Past Today
I want to take a timestamp and make a condition. that condition would be if that timestamp is greater then 30 days from entered then highlight that cell field. Can some one shed some light on how they would be written.

EXample ( todays date) 30days later

View Replies!   View Related
Dynamic Range To Look Past Blank Cells
I am having the same problem as this thread Dynamic Ranges with blank cells.

I've recently been pointed in the direction of dynamic ranges (named ranges that use OFFSET and COUNTA to expand to cover the whole of a list, even if the number of rows used is frequently changed).

They seem to have a big drawback, in that the range will not go to the bottom of the list if the list has blank cells in (because the COUNTA for the column of interest does not equal the number of rows in the list).

A typical named range might look like this:

=OFFSET(Sheet1!$A$2,0,0,COUNTA(Sheet1!$A$2:$A$25),1)

I tried to post in it but it's too old.

I have been to the link posted in that thread about advanced dynamic named ranges but inserting a row with numbers in it and then hiding it is not suitable for me as i deal with other peoples spreadsheets so need to always be working with the Active Sheet.

View Replies!   View Related
Track & Record Dates, Past And Actual
I am creating a tracker to record, incoming, latest date of reply needed and actual date of reply. So I have column A= received, Column B = need to reply by, Column C = replied on. What I want in A is today’s date which is easy enough with ctrl+; is there a way of having it set that as soon as the cell is clicked on that date is activated and until then it remains empty?

What I have in B is A# + 20 this adds 20 days to the date entered in column A, again is there any way to have it set that this automatically activates when cells in column A are active and not until then, as if I enter that code in the cell and nothing is showing in cell A it gives a date of the 20/01/2008.

In C I have tried a couple of codes and they have not worked so what I would like is a code that when A and B are active it generates a countdown for days left to reply and if this countdown reaches zero then the whole line is flagged up in red as late. Lastly, is there a code that I can use that will automatically correspond with the A, B or C columns and match them with the same number cell in the other columns, sorry this isn’t so easy to explain but what I have to do at the moment is type in B is =A1+20 , A2+20, A3+20 and so on rather than just typing in A……+20 for column B to know it needs to associate itself with the same number cell in column A regardless what number it is.

View Replies!   View Related
How Do I Get Past A Delete, Cancel Button During A Macro Loop?
I would choose to select the delete button. I've created a new worksheet within a workbook, insert text and formatting, and copied to a specific place in the active worksheet. Everything works well except 1. there is a LOT of coding because I recorded the macro and 2. the delete message pops up for every files the macro manipulates. I have to click "delete" about 60 times throughout this macro and would love to be able to let it click its own delete button!

View Replies!   View Related
Ensure Selection Row Deletion Doesn't Extend Past Certain Row
I have a delete button on a protected sheet to allow a user to delete selected rows (unprotects, deletes, protects again...).

I need to add a check to make sure they do not delete any row greater than 152. How can I check if a row greater than 152 is in their range of selected rows?

View Replies!   View Related
Find The Maximun Number For The Past N Periods In A Range Of Cells
(1) I want to find the maximun number for the past n periods in a range of cells, but I want to be able to vary n by changing the number of periods in one cell at the top of the sheet, i.e. if i enter 10 in cell A1 the function will return the max number for 10 periods over a certein range, if I change the figure to 20, then the max number for 20 periods will be returned!

(2) I have a column (lets say column c) which will return a number of values if my criteria are met and 0 if not, I want a function in another column which will replace the 0 with the next non 0 figure in column c, the gaps between the non 0 figures can vary. I feel it involves looping in some form, and writing a new function, but I am not sure.

View Replies!   View Related
Copy/past Rows From Sheet1 To Sheet2 But Only If - Automate Process?
I have two sheets: Sheet1 - linked from external file, new data coming daily.
Sheet2 - I need to copy/past Rows from Sheet1 to Sheet2 but only if B-cells are not empty. How can I automate the process?

View Replies!   View Related
Function/formula To Copy/past Multiple Data Rows In Excel Worksheet
I am trying to find a way to copy and paste multiple non concurrent rows of data from one spreadsheet to another.

Ex: I have a large worksheet with approx 20,000 rows of data. I need to copy
and paste every 100th row to a new worksheet.

I think this might be possible by setting up a formula and linking worksheets,
but I'm not exactly sure how to do it.

View Replies!   View Related
Macro For A Formula To Divide One Cell By Another And Past It In A Third Cell.
I am trying to write a macro where I divide the value of one cell by that of a second cell, multiply it by 500 and then to paste the outcome of the formula to a third cell. This is what I wrote

View Replies!   View Related
Cannot Set Column Width Past Column 148
I have a spreadsheet with 198 columns built by VBA procedures. Columns 7 thru 198 contain monthly data, i.e., columns 7 thru 18 contain data for the months of year 1, columns 19 thru 30 contain data for the months of year 2, ...., columns 187 thru 198 contain data for the months of year 16.

I need to set the ColumnWidth for columns 7 thru 198 to 4. I've never had a problem setting ColumnWidth before as I do this (among other things) for a living for the past 8 months. I've tried multiple methods, i.e., Range, Range-by-Range, Column-by-Column, and each one fails at column 149.

View Replies!   View Related
Compute The FuTure Date When Start Date,Lead Date,Weekly Offs,Leaves And Holidays
First and foremost I would like to congragulate you on this wondeful piece of code in the below link...

The query was to get a future date excluding Fridays and Holidays...

http://www.excelforum.com/excel-work...rkingdays.html

I have a similar query and therefore I pasted this link...

I actually wanted to get a future date using a Dynamic two day off as my the offs keep on changing as well as incorporate Holidays and Leaves if any..

Now Holidays would be official Public Holidays and
Leaves would be taken by the employee..

The code needs to pick the Leaves + Holidays and different offs maybe even more than 2 offs...


View Replies!   View Related
Sort Table In Date Order But With The Date Nearest To Today's Date At The Top
I have data going in to a small table which has some empty rows as that data is not yet available... My problem is, I need to sort this table in date order but with the date nearest to today's date at the top...

The sort function puts oldest at the top or oldest at the bottom which is no good for what I need...

I use xl 2003.

View Replies!   View Related
Date Range: Reference A Single Date And Output Date Ranges
I need to create formulas that reference a single date and output date ranges. The objective is to have a person input a Monday date in any given month and receive a four weeks out worth of dates and ranges. For example: In a lone cell, the person inputs 10/13/08. Automatically, the sheet produces the next full week range: October 19 – October 25 in a single cell and also produces a cell for each date. Example: Sunday 19, Monday 20, Tuesday 21, etc…. It should look like:

Monday Date:
10/13/08
October 19 – October 25
Sunday 19
Monday 20
Tuesday 21
Wednesday 22
Thursday 23
Friday 24
Saturday 25

and then repeat for three more weeks. I thought I had it figured out until the month changed. The dates continued in October instead of adding a month. This report will be ran weekly, so simply adding a +1MONTH to some cells will not benefit me as I’ll have to change the formula every week. I want the formula to compute the data without any manipulation over the next several years. The only change will be the Monday date.

View Replies!   View Related
Fixed Date: Lock The Date To The Initial Date
i would like to use the formula "now()" to establish a date in a document. is it possible to lock this date to the initial date? (so when the document is created the date won't change the next day)

View Replies!   View Related
IF Date Formula: IF Formula, That States If A Date Is More Than A Month After The Date In The Cell Then It Is Timely
I need an IF formula, that states if a date is more than a month after the date in the cell then it is timely and if it isn't then it is not timely. For example the date in A1 is 12/11/05, if the cell is A2 is 13/12/05 (or any date after that) then A3 should read Not Timely, if A2 is 12/12/05 (or any date before that, including a date before the date in A1) then A3 should read Timely. Is there any way to do this?? At the moment I am having to go through manually and put in either Timely or Not Timely.

View Replies!   View Related
Compare Date: Compare The Date From The User Input And The Date Listed
I need to compare the date from the user input and the date listed on excel. How can I compare it? Is it correct? lngCmp = Val( Cells(I, 31))

Dim lngBegin As Long, lngEnd As Long, lngCmp As Date, lngResults As Long
lngBegin = 9 'beggining of data
lngEnd = 232 'end of data
lngCmp = InputBox("Please enter the date", "Begining of the week")

Lngcmp1 = DateAdd("d", 1, lngCmp)
lngCmp2 = DateAdd("d", 2, lngCmp)
lngCmp3 = DateAdd("d", 3, lngCmp)
lngCmp4 = DateAdd("d", 4, lngCmp)
lngCmp5 = DateAdd("d", 5, lngCmp)

'lngCmp1 = lngCmp + 1
'lngCmp2 = lngCmp + 2
'lngCmp3 = lngCmp + 3
'lngCmp4 = lngCmp + 4
'lngCmp5 = lngCmp + 5
lngResults = 0
lngResults1 = 0
lngResults2 = 0..................................

View Replies!   View Related
Copyright © 2005-08 www.BigResource.com, All rights reserved