LinkBack URL
About LinkBacks
Dear pro,
I got this script from internet & modify it with my 10% knowledge of VB.
However, it cant run
It show me "Invalid or unqualified reference"
Can someone help me?
Please Login or Register to view this content.
Dear pro,
I got this script from internet & modify it with my 10% knowledge of VB.
However, it cant run
It show me "Invalid or unqualified reference"
Can someone help me?
Please Login or Register to view this content.
delete the extra . infront of "cells"Please Login or Register to view this content.
you do not have a with statement before hand (nor do you need it by the looks of it)
ps with this bit
i think the bottom bit should be display not sendPlease Login or Register to view this content.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Thank humdingaling for your help. Its running now.
However, it prompt me error after running.
May I know which feel to modify no of day to send out email?Please Login or Register to view this content.
TIA
Thank humdingaling for your help. Its running now.Originally Posted by humdingaling
delete the extra . infront of "cells"Please Login or Register to view this content.
you do not have a with statement before hand (nor do you need it by the looks of it)
ps with this bit
i think the bottom bit should be display not sendPlease Login or Register to view this content.
However, it prompt me error after running.
[Select Code] copy to clipboard
May I know which feel to modify no of day to send out email?Please Login or Register to view this content.
TIA
holy smokes this was ages ago
as it has been working fine for so long
can only imagine you have changed the format of the spreadsheet
ie row 6 is not longer where it starts or column 20 is no longer a date?
Re: changing date
todate - date <=34 would be what you need changedPlease Login or Register to view this content.
todate = field
date = today
so if you want to change trigger point change the number
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks