Recent content by Dinesh121

Attaching the file for reference.

Hi All, I have a named range as datavalidation in one cell and in another range I have the same named range. I would like to change the second data validation based on first one. Eg: In Cell A1 I have first data validation and in B2 i have second data validation. Both of them have same...

Hi Gaurang, Fixed.See attached file for reference. -Dinesh

Hi Gaurang, You have to change the date format to 23/08/2014 Thanks, Dinesh

Hi Gaurang, We cannot add CC to a task item. I am not sure.To change the TAT change the due date as below .ReminderTime = wsht.Cells(counter, 3).Value .DueDate = wsht.Cells(counter, 3).Value -Dinesh

Hi Gaurang, No Problem . Glad to help you. Have a good day . -Dinesh

Hi Gaurang, Finally its working after a week's time. Sending multiple remainders is not possible if we do manually so we cannot implement the same using vba. Thanks, Dinesh

Hi Gaurang, Can you test the below code . It is the same as I originally posted I have added a extra line (Const olTaskItem = 3). Let me know if it works and if you want to change the due and remainder dates. Sub SendRemainders() Dim wbk As Excel.Workbook Dim wsht As Excel.Worksheet Set wbk...

Hi Gaurag, Can you type OutLookMailItem. and see whether it has assign property? type after Set OutLookMailItem = OutlookApp.CreateItem(olTaskItem) -Dinesh

Hi Gaurang, Can you post the error description. Thanks, Dinesh

Hi Gaurang, yes you can change the code to target date by referring to that cell. On the debug error I tested the code in my computer it works well. Which version of Outlook do you have? and also can you post the error description.you can get the error description by typing err.description in...

Thanks a ton Hui the code worked well.

Forgot to add Paste the below code in the workbook Sub SendRemainders() Dim wbk As Excel.Workbook Dim wsht As Excel.Worksheet Set wbk = ThisWorkbook Set wsht = wbk.ActiveSheet Dim OutlookApp As Object Dim OutLookMailItem As Object Dim counter As Long Set...

Hi, Please use this formula in range C5 to C16. =$F$3+RIGHT(D5,FIND("+",D5,1)-1) Thanks, Dinesh

Hi All, I need help in getting the selected items from a pivot table report filter. I have Country field in my report filter and I have multiple selections . I want to get through code what are the selections made by user. I am attaching a screenshot for reference.