Search:

Type: Posts; User: InderpalHothi

Search: Search took 0.01 seconds.

  1. dynamic min formulae (column changes)

    All,

    Following formula gives me an application defined or object defined error:

    ActiveCell.FormulaR1C1 = "=min(R" & rowr & "C" & week2locform & ":R" & rowr & "C)"

    whereby rowr = 2 (will not...
  2. Replies
    0
    Views
    1,743

    Matrix maths help required!!!

    Can someone please help with the attached document?

    With regards to the attached document, the cell highlighted in yellow,has the following formula:
    ...
  3. Replies
    2
    Views
    1,003

    Re: simple vba function

    thanks, will give this a try and mark resolved if it works...
  4. Replies
    2
    Views
    1,003

    [RESOLVED] simple vba function

    Hi guys,

    i am fine with sub routines, first time i am trying a function.


    Function Value1(ByRef p As Range, ByRef d As Range) As Variant


    If p.Value = "" Then p.Value = 0
  5. Re: Run time error - problems with my vba?

    Object required error.

    FileLoc range has been set to the exact file path.

    If I combine the whole thing in one subroutine as such:

    Public Sub Declarations()

    Dim wb As Workbook
    Dim wbS As...
  6. [RESOLVED] Run time error - problems with my vba?

    Guys,

    Don't know what is going on with this code - is there a problem with my vba?


    Public Sub Declarations()

    Dim wb As Workbook
    Dim wbS As Workbook
  7. Re: Autogeneration of an email dependant on time criteria

    cheers, problem sorted.

    Used :

    If Utime>dTime and Dtime>Ltime

    etc
  8. Re: Autogeneration of an email dependant on time criteria

    *update above*
  9. [RESOLVED] Autogeneration of an email dependant on time criteria

    Hi guys,

    I have set up a windows scheduler even to open a specific file every friday at 9.30am.

    I now would like to set up a workbook_open event which generates an email when the scheduler...
  10. [RESOLVED] Dynamic Autofill Range (Both start and end variable)

    Hi guys

    I have calcualted the first and last rows being used in a sheet.

    FirstRow and LastRow are variables which will change frequently.


    I now need to autofill a formula i have to cover...
  11. Re: Opening files with a wildcard

    Cheers guys
  12. [RESOLVED] Opening files with a wildcard

    Hi guys,

    I need some help with a macro that opens files with a variable file name (want to copy data from).
    The file always has the same first part of its name, but a different stamp based on...
  13. Re: Something weird is happening in excel (VBA)

    vbfbryce - no problem on this one, dno whats going on then. Thanks for your help again!

    westconn1 - thanks aswell, duly noted re the 'or' point
  14. Re: Something weird is happening in excel (VBA)

    yeh, there are duplicate values in column E, but it seems to be only taking one instance.
    This is fine, I was just wondering why it was doing this
  15. [RESOLVED] Something weird is happening in excel (VBA)

    Hi guys,

    Got this code below where ws1/2/3 etc makes reference to my worksheet. All stuff is defined.



    Dim i As Long

    Dim RwCount1 As Long
  16. Re: Excel (looping, netting macro)

    cheers dude, works now.
  17. Re: Excel (looping, netting macro)

    same problems still exists!
  18. Re: Excel (looping, netting macro)

    Vbfbryce,

    The code you post is great and has given me a lot of insight, but for some reason in the excel example you posted it only cuts he first two rows out and doesnt go on to check the values...
  19. Re: Excel (looping, netting macro)

    thanks mate
  20. Re: Excel (looping, netting macro)

    Example sheet attached
  21. Re: Excel (looping, netting macro)

    Vbfbyce,

    Thanks for your response.

    To clarify:

    Imagine i have a spreadsheet filled with values on a type of financial product. Column F in the instance above contains the name and date...
  22. [RESOLVED] Excel (looping, netting macro)

    Hi guys,

    I had previously posted on this forum to try and get some help with the following problem but I didnt really get any meaningful help... I have refined the code but I would greatly...
  23. Re: Excel (Delete if certain criteria are met)

    Cheers.

    The thing I am struggling with is cutting the range of rows which meets the criteria
  24. Re: Excel (Delete if certain criteria are met)

    Yes sorry- cut the entire rows that meet this criteria and paste in another sheet
  25. Re: Excel (Delete if certain criteria are met)

    Unfortunately I have not got very far so far, this is what i have...many thanks for your help btw


    Dim ISIN1 As Variant
    Dim Dte As Variant
    Dim NetAmount As Variant
    Dim FirstRow As Long
    Dim...
  26. Re: Excel (Delete if certain criteria are met)

    Seenu,

    I am running Excel 2007 so I am guessing VBA?
  27. Excel (Delete if certain criteria are met)

    Hi Guys,

    I am a newbie to VB and would like some help re a Sub I am trying to create if possible in excel. The aim is:

    -Check the values of column E

    -If any two or more rows have the same...
Results 1 to 27 of 27



Click Here to Expand Forum to Full Width