Search:

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

Page 1 of 6 1 2 3 4

Search: Search took 0.51 seconds.

  1. Re: Run Time Error '13': Type Mismatch on time calculation

    You are welcome - glad we could help.
  2. Replies
    5
    Views
    92

    Re: VBA IF THEN with 2 conditions

    Bad syntax. Change this bit:

    If D.Value = Value.Interior.Color = vbGreen

    to this:

    If D.Interior.Color = vbGreen
  3. Replies
    4
    Views
    114

    Re: How to combine two table information?

    You are welcome - thanks for the reply.

    For EUR use same formula but change the ranges to adhere to the position of the raw data in the two tables.
  4. Thread: =IF Help

    by JoeMo
    Replies
    9
    Views
    170

    Re: =IF Help

    One possibility is that A5 and B4 look like they are the same but one or both have some extra spaces. In any empty cell enter: =EXACT(A5,B4)
    If that returns False try: =EXACT(TRIM(A5),TRIM(B4))
    ...
  5. Re: Found last used column from Row 2, need value in row 1

    You are welcome - thanks for the reply.
  6. Replies
    4
    Views
    114

    Re: How to combine two table information?

    You need to extend the ranges in the formula below to cover all 12 months. Here B9:E9 hold s the exchange rates for US to CAD.
    Sheet10


    <colgroup><col style="font-weight:bold; width:30px; ...
  7. Re: Found last used column from Row 2, need value in row 1

    The value in row 1 of "this column", assuming that's LastColumn is: Cells(1,LastColumn).Value
  8. Thread: Macro Help

    by JoeMo
    Replies
    2
    Views
    46

    Re: Macro Help

    Untested - may need some tweaking for path separator and spacing within the file name.


    Sub Filesplit()
    Dim sh As Worksheet, fName As String
    fName = InputBox("Enter file name prefix")
    If fName...
  9. Re: Copy data from worksheet and paste in same worksheet but at different range

    You are welcome - thanks for the reply.
  10. Replies
    3
    Views
    63

    Re: Changing time format

    Oops, it is. I was focused on transforming a number to text rather than the exact format requested. :banghead:
  11. Re: Sumproduct Isnumber Search is returning same result for different values

    Then replace the ISNUMBER(SEARCH ...) with this:

    ($H$11:$H$23733=2)
  12. Replies
    3
    Views
    63

    Re: Changing time format

    <b>Sheet9</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff; padding-left:2pt; padding-right:2pt; ">...
  13. Re: Sumproduct Isnumber Search is returning same result for different values

    If there are spaces on either side of the 2 (or 7) change your search to:

    SEARCH(" 2 ",...)
  14. Re: Copy data from worksheet and paste in same worksheet but at different range

    This is a duplicate post.
  15. Re: Copy data from worksheet and paste in same worksheet but at different range

    Assuming your sheet tabs are in ascending order:


    Sub EOD()
    Dim i As Long
    For i = 4 To ThisWorkbook.Worksheets.Count
    With Sheets(i)
    .Range("B11:G150").Copy
    ...
  16. Re: Run Time Error '13': Type Mismatch on time calculation

    I think the red highlighted line will produce a type mismatch error as well. Replace with:

    NextTime = Now + TimeSerial(0,58,0)
  17. Replies
    4
    Views
    105

    Re: VBA hide last two rows in a table

    You are welcome - thanks for the reply.
  18. Re: Make macro work with upper case and lower case

    try:

    If Target.Column = 3 And UCase(Target.Value) = "ARRIVED" Then


    and similarly for the "DEPARTED" line
  19. Replies
    4
    Views
    105

    Re: VBA hide last two rows in a table

    Try this - change the table name to match the name of your table:


    Sub HideLastAndTotalRows()
    Dim LO As ListObject
    Set LO = ActiveSheet.ListObjects("Table1") ' change table name to suit
    With...
  20. Re: Keeping the "0" as the start of a string of numbers

    This returns a text string, not a number:
    <b>Sheet2</b><br /><br /><table border="1" cellspacing="0" cellpadding="0" style="font-family:Calibri,Arial; font-size:11pt; background-color:#ffffff;...
  21. Replies
    5
    Views
    151

    Re: Whole circle bearing calculation with vba

    You are welcome - thanks for the reply.
  22. Replies
    5
    Views
    151

    Re: Whole circle bearing calculation with vba

    Can't help you with the answer produced,nor the validity of the equation you posted for whole circle bearing, but the method of calculation using VBA is what I wanted to convey.
  23. Re: Using Excel Filter to Search for text containing a comma & displaying all records that contain one

    You are welcome. That's a lot of terms to add. Would you be open to a VBA solution?
  24. Re: Error message when opening an Excel workbook

    You are welcome - thanks for the reply.
  25. Re: Using Excel Filter to Search for text containing a comma & displaying all records that contain one

    Maybe a formula solution would be easier. Copy the formula in B2 down to cover all email addresses in col A.
    <b>Sheet2</b><br /><br /><table border="1" cellspacing="0" cellpadding="0"...
Results 1 to 25 of 150
Page 1 of 6 1 2 3 4