Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.01 seconds.

  1. Replies
    0
    Views
    76

    converting a table using a set of rules

    Hi,
    I need some help with converting a table to another table depending on a few rules, using VBA. I want to see the daily increase in the new table.

    I will try to post some VBA code soon ( i...
  2. Re: Determining the Amount of days in each month in a week that crosses Months

    Let's say you would have the date 9/28/2015 in cell A1:
    1. put this formula in B1, which will show the remaining days of that week in September:
    =DAY(DATE(YEAR(A1);MONTH(A1)+1;1)-1)-DAY(A1)+1...
  3. Re: VBA form that creates a new sheet within the Excel-document, containing the form-input

    if you create a new sheet, it's a totally new sheet without any formatting.
    What you could do is record a macro and copy your empty pre-formatted sheet - instead of just creating a new sheet - and...
  4. Replies
    3
    Views
    165

    Re: Concatenate column A using a seperator

    Sub ConcatenateColumnAtoE2()

    Dim cRows As Long
    Dim result As String

    With ActiveSheet
    cRows = .Cells(Rows.Count, "A").End(xlUp).Row
    result = .Cells(1, 1).Text
    For I = 2 To...
  5. Replies
    2
    Views
    224

    Re: Can I retrieve the column values?

    Hi,

    As i can see on the picture you table ends in column R, so we will put the formula(output) on column S. It's not an easy formula as we will use array-formula's, but you can use evaluate...
  6. Thread: Lookup

    by Dendro
    Replies
    8
    Views
    342

    Re: Lookup

    filter table on the column you want and remove 0 costs
  7. Re: For-Next loop is not working correctly (while sending mail via Thunderbird from Excel)

    Could you enter a Msgbox within your for loop showing the y value? and see what the results are? This to see whether the y value is actually incrementing, and by how much?
  8. Thread: Lookup

    by Dendro
    Replies
    8
    Views
    342

    Re: Lookup

    Ok, so now you want out of this a table with Creative-jobs, another with artwork-jobs and another with management-jobs? Like this?

    <tbody>
    Creative jobs-id

    Cost



    1234
  9. Re: For-Next loop is not working correctly (while sending mail via Thunderbird from Excel)

    i think shell command line should change, take a look at the syntax here:
    Open and Close File with VBA Shell - wellsr.com
  10. Thread: Lookup

    by Dendro
    Replies
    8
    Views
    342

    Re: Lookup

    invent some data for like 5 rows
  11. Replies
    1
    Views
    114

    Re: Access Excel Behind Open UserForm

    Make sure the 'ShowModal' property of the userform is set to false
  12. Thread: Lookup

    by Dendro
    Replies
    8
    Views
    342

    Re: Lookup

    Could you give an example of your data in a table?
  13. Re: For-Next loop is not working correctly (while sending mail via Thunderbird from Excel)

    The problem is that I'm not that familiar with the Shell-command. But what i do see is that you are overwriting the strCommand each time which looks like it should be of type String if I look at...
  14. Replies
    5
    Views
    689

    Re: Worksheet Change Event

    Hi,

    Use this in the worksheet macro to trigger on on a change in the sheet:

    <code>Private Sub Worksheet_Change(ByVal Target As Range)</code>
    Next use this code to only trigger when E7 is...
  15. Replies
    3
    Views
    422

    Re: remove special characters

    Don't post the same question twice, thank you. Here is the link to the other thread:
    http://www.mrexcel.com/forum/excel-questions/890253-remove-space-header.html#post4294870
  16. Replies
    3
    Views
    366

    Re: Remove space in header

    I don't see the need to do it in vba, but here you go:


    Cells.Replace What:=" ", Replacement:=" ", LookAt:=xlPart, SearchOrder _
    :=xlByRows, MatchCase:=False, SearchFormat:=False,...
  17. Re: For-Next loop is not working correctly (while sending mail via Thunderbird from Excel)

    I'm seeing some possible problems in your code
    :

    <code>Option Explicit
    Sub SendMailThunder_Click()
    Dim strEmpfaenger1 As String
    Dim strBetr As String
    Dim strBody As String
    Dim...
  18. Re: VBA form that creates a new sheet within the Excel-document, containing the form-input

    Yes, it's all possible within excel and i might suggest using MS acces if the data is merely used to store it in a database without much calculation.

    How do you do this in excel?
    in short:...
  19. Replies
    3
    Views
    422

    Re: remove special characters

    If it's only this or a few characters, use ctrl+H, replace all
  20. Replies
    3
    Views
    366

    Re: Remove space in header

    CTRL+H
    replace 2 spaces by 1
  21. Re: copy multiple cells with absolute reference help

    Sorry for double posting, but i wanted to clear that up first. To add the sheet to the cell reference, adjust the INDIRECT formula into

    =INDIRECT(CONCATENATE("'Sheet1'!";ADDRESS(...)))
  22. Re: copy multiple cells with absolute reference help

    You are not supposed to put anything in ROW(), if it's empty it will give the row-number of the cell where the row()-formula resides. We need this to know if the formula is in an even or uneven...
  23. Re: manually inputted number reverts to previous input upon entery

    press Alt+F11 and see if there is a macro assigned to the sheet
  24. Re: Worksheet ranges> vba arrays, what mistake am I making?

    I'm not sure but could you try with making a variable of type range and assigning the named range that variable using 'Set'. After that assign the variable to the array.
    This is what i mean:

    Dim...
  25. Re: how to copy paste bank data from a pdf in a coherent form

    I'm afraid Kyle123 is right, and i would suggest searching some good pdf-converters. However, you will still need to adjust the result with some macro's
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4