Search:

Type: Posts; User: nachiketdp; Keyword(s):

Page 1 of 3 1 2 3

Search: Search took 0.01 seconds.

  1. Replies
    0
    Views
    11,672

    Study Group in India

    Dear participants from India,

    Greetings to you and hope you had a great 69th Republic Day celebration yesterday! As we all know, clearing different levels of ModelOff is very challenging and...
  2. Re: List view column headers not appearing - despite view = lvwReport

    I got the solution. I simply removed the list view lying on my user form and re-inserted a new one. Gave it the same name, Search_Result and voila! It started working! How silly! Anyways, thank you...
  3. List view column headers not appearing - despite view = lvwReport

    Dear All,

    I created a listview (Search_Master) in one project. I copied it to another project. However, in that project, it is not showing the listview column headers. It is surprising because...
  4. Re: How to run a macro at a particular time, then re-run it at specified interval and end it at a particular time?

    Hi ParamRay,

    I have one question. I developed my code but I am getting the output twice. In other words, the macro runs twice. I am puzzles as to how this happens. Can you please guide me?


    ...
  5. Re: How to run a macro at a particular time, then re-run it at specified interval and end it at a particular time?

    Just one query. How should I trigger the startSchedule macro? Should I put it in workbook_open event? Or will it work automatically?
  6. Re: How to run a macro at a particular time, then re-run it at specified interval and end it at a particular time?

    Brilliant! This was exactly what I wanted! Thank you very much, ParamRay!
  7. How to be FASTTTT while working out the solutions during the ModelOff competition?

    Dear All,

    I will be attempting the ModelOff competition in its 2017 edition. I have attempted it in the past as well. I have observed (like you all!) that one has to be really really quick while...
  8. How to run a macro at a particular time, then re-run it at specified interval and end it at a particular time?

    Dear All,

    I wish to run an excel macro at a particular time, say 7:00 am and would like to run it at a specified interval, say every hour till a particular time, say 5:00 PM. What could be the...
  9. Replies
    4
    Views
    201

    Re: Multiple users for excel workbook

    Sorry for the late reply, I was tied up in some year ending processes (In India, our financial year ends on 31st March). I appreciate all your inputs, I am now developing the work as discussed...
  10. Replies
    4
    Views
    201

    Re: Multiple users for excel workbook

    Thank you very much, Mr Mahoney! Yes, I was also thinking along the same lines as I did lot of googling and have come to the conclusion that I cannot have a single workbook holding the data as well...
  11. Replies
    4
    Views
    201

    Multiple users for excel workbook

    Dear All,

    I am using Excel 2010 in my office. I have developed an excel file for maintaining data related to sale of inventory and receipt of moneys from debtors. I want multiple users in my...
  12. Re: VBA code to automatically load relevant switchboard based upon the user

    Thanks GinaWhipp for your kind reply! Will explore this solution and will revert, in case there are issues... Thanks once more!
  13. VBA code to automatically load relevant switchboard based upon the user

    Dear all,

    I'm using MS Access 2010. I've created a file wherein I've created a form for a user login with password. I've created different switchboards for different users. I also have a users...
  14. Replies
    8
    Views
    1,187

    Re: IF function to find depriciation

    i guess there is no need to use the if funtion, jus use the foll formula in cell B1(or 1st row of any column and drag it down)

    =100000*(row()/15)

    if the initial investment/useful life is a...
  15. Replies
    2
    Views
    385

    Re: Expiring a Workbook

    I have one doubt..if the computer system date is manipulated then these codes will not be effective to prohibit a client from using a macro utility beyond its expiry date..

    can we make a macro to...
  16. Replies
    3
    Views
    452

    Hi Erik, Yeah looping is always an...

    Hi Erik,
    Yeah looping is always an alternative(which, in fact, what i have used in my macro). But it definitely will be much faster to find it once and for all, across all worksheets, that was my...
  17. Replies
    3
    Views
    452

    find within workbook using macro

    Hi,
    I wanted to encode finding a particular string within the whole workbook. I tried to record it using macro recorder but I didn't get the desired code i.e. whatever code I got finds it only...
  18. Replies
    9
    Views
    952

    Make a column for concatenate of bmajor/bminor...

    Make a column for concatenate of bmajor/bminor and the date. now put the criteria as the concatenated value of bmajor/bminor and the date.

    HTH,
    Regards,
    Nachiket Pendharkar
  19. Replies
    3
    Views
    320

    @Norie Should I mail you the file? Please mail...

    @Norie
    Should I mail you the file? Please mail me your email id so that I can send you the file and you can see what I am trying to say.

    @QuietRiot
    Which site are you referring to? Where do you...
  20. Replies
    3
    Views
    320

    Extracting value from a link box

    Hi,
    I have an excel file which has a link box in a particular cell. Now I am writing a macro which requires the value displayed by this link box. The problem is that the value as displayed by the...
  21. Hi Venkat, Thanks for your reply. Actually the...

    Hi Venkat,
    Thanks for your reply. Actually the problem was that some of my worksheet names were containing hyphens in between
    (eg RA-563!$A$1:$IA$35). So may be excel was considering '563' alone...
  22. Getting #REF! on using indirect function

    Hi all,
    I have a workbook which has a sheet namely "Working". This sheet has in its Column G ranges referring to several other worksheets in the same workbook eg(ABCD!$A$1:$IA$35).
    In...
  23. Replies
    4
    Views
    793

    Hi Aladin, The indirect function...

    Hi Aladin,
    The indirect function works just superbly !!! You indeed have a magic lamp for me !!!

    Thanks a million !!!!

    Regards,
    Nachiket Pendharkar.
  24. Replies
    4
    Views
    793

    Hi Aladin, I tried this formula in...

    Hi Aladin,
    I tried this formula in cell H2

    =HLOOKUP(E2,C2,DAY('DR 2'!$D$4)+1,0)

    Cell C2 contains I4:I50. Rest all arguements are working fine only table array is giving me...
  25. Replies
    4
    Views
    793

    Hlookup table array problem

    Hi all,
    I have got a worksheet whose Column C contains diffferent cell ranges. Column H contains an hlookup throughout. Now for all Column H entries, I am trying to enter the arguement "table array"...
Results 1 to 25 of 55
Page 1 of 3 1 2 3