Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.04 seconds.

  1. Replies
    5
    Views
    62

    Re: =if(condition,,)

    Hi,
    =if(E2>50,True,False)
  2. Replies
    10
    Views
    362

    Re: Step through a Macro

    Hi,
    when you need to hold down the FN key then it means you are on your laptop stepping through your code and that is normal that you need to use the FN key to be able switch to F8 key.
    You should...
  3. Re: Index, Offset, Index... I'm getting crazy

    Hi,
    perhabs this link will help you.

    https://www.ablebits.com/office-addins-blog/2014/05/02/fill-blanks-excel/

    you can do this kind of operation in both columns like Column(C) and Column(D)...
  4. Replies
    3
    Views
    170

    Re: Cut & Paste VBA

    Hi and welcome to the board,

    dim i as long
    dim strText as string
    dim lngRow as long
    dim bolTrue as boolean

    the "dim" statement means you declare a variable in your code it must be in your...
  5. different approach to vlookup function vba

    Hi again,

    sorry guys to be a pain about this issue.



    Sub myLookUp()
    Dim lngLR As Long
    Dim i As Long
    Dim rngHoli As Range
  6. Re: Conditional Formating with VLookup and Holidays for different Countries

    Hi Marcelo,

    I will try that thanks again!

    A.
  7. Re: Conditional Formating with VLookup and Holidays for different Countries

    Hi,
    I will try that too thanks.
    But as it is a larger project with vba I would love to have it working within vba.
  8. Conditional Formating with VLookup and Holidays for different Countries

    Hi guys,

    I got in my workbook two named ranges for two countries and there holidays.

    A conditional formating I was able to create in my workbook but I would like to have it more dynamic and...
  9. Re: Filling dates from start Date to End date

    Thanks guys,
    for your input and different approaches for the code ..
    I would of been happy to be able to worked one out of myself gg .-)
  10. Re: Filling dates from start Date to End date

    Thanks Rick and footoo and ofcourse GirishDhruva too!!

    Learned again more about it!

    Cheers
  11. Re: Filling dates from start Date to End date

    Hi,
    thanks for your reply.

    this is what i got now..


    Sub FillDates()
    Dim datStart As Date
    Dim datEnd As Date
    Dim row As Long
  12. Filling dates from start Date to End date

    Hi guys,

    I am not able to get this simple code running..


    Sub FillDates()
    Dim datStart As Date
    Dim datEnd As Date
    Dim row As Long
  13. Replies
    2
    Views
    91

    Re: Start Loop in "A2"

    Hi Rick,

    yes it works fine!
    I tried with Cells(Day(d)1 ,1)=d
    before...

    hmm never stop learning :)
  14. Replies
    2
    Views
    91

    Start Loop in "A2"

    Hi guys,

    I got this code from a a gast user of a different forum. "Volker"

    I did modify it a little but seam not be able to get the loop started at "A2" rather then "A1".


    Sub...
  15. Replies
    7
    Views
    170

    Re: Time into formula

    Thanks you too :)
  16. Replies
    7
    Views
    170

    Re: Time into formula

    Hi,
    thanks-- I got it with your help!
    =if(A1="Break";Time(16;30;0);B1+C1/60*24)
    not sure in english but it works :-)
  17. Replies
    7
    Views
    170

    Re: Time into formula

    Hi,
    no unfortunatelly that is not working either I did try that already ..(
  18. Replies
    14
    Views
    458

    Re: Help please - how to hide a macro button

    Hi,
    Me.btnExport.visible = false or = true

    depands on how you have set it in the properties of the command buttin in the userform.

    You can set the userform Buttin to visible true or false in...
  19. Replies
    7
    Views
    170

    Time into formula

    Hi guys,

    can someone tell me how to I need to change this function so I can enter a Time wenn the Cell has a certain value.

    =if("A1"="Break";16,5;B1/C1)

    it is german so that is why the";" is...
  20. Replies
    2
    Views
    136

    Re: Convert to Long Integer in Loop

    Hi thanks Bosan42,

    I do the import with access and yes via code.. it's just a TransferSpreadsheet Code


    Sub ImportExcelSpreadsheet(FileName As String, TableName As String)
    On Error GoTo...
  21. Replies
    2
    Views
    136

    Convert to Long Integer in Loop

    Hi guys,

    as I am importing an Excel Worksheet into my access database I need some assistance to convert a column in Excel to a longInteger Field in Access.


    Sub FillAllCellsWithLongInteger()
    ...
  22. Re: Amend VBA code to refer to another sheet

    Hello,
    I am not sure if I understand you correctly.. but if you like to refer to another worksheet within the workbook you need a different event not the change event of the worksheet.
    Create a sub...
  23. Replies
    2
    Views
    137

    Re: Copy and paste above found row

    Hi Tony,

    many thanks to you it works fantastic!
  24. Replies
    2
    Views
    137

    Copy and paste above found row

    Hi guys,

    I like to copy an entire row and paste that row above found row if condition is met.

    this is what I got so far but how do I need to ad the paste line into that code?



    Sub...
  25. Re: Tracking several phase of several manufactured products

    Hallo,

    my Idea would be useing access instead of excel for this kind of tasks.

    HTH
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4