Search Results - VBForums

Search:

Type: Posts; User: Jrocket

Search: Search took 0.02 seconds.

  1. Replies
    2
    Views
    312

    Parsing Out Data

    i am trying to remove a certain string from long text. Basically I only want the 10 alphanumeric characters after the 2nd "ID:"....see after first code my fix...

    I have got it spliced down, but...
  2. Replies
    1
    Views
    570

    Counts with Multiple Filters

    Can this be written in a more concise manner? What is shown being part of a much larger code.


    Sub Test()


    Dim wksht As Worksheet
    Dim icell As Long, LastRow As Long

    'code for Blue Sheet
  3. Re: Prevent drop down list from moving when column deleted.

    I controlled this with a conditional statement, which worked out well.
  4. Re: Prevent drop down list from moving when column deleted.

    Yes it will be in the correct position after columns are deleted, but not everyone will do it the same. I for instance delete the columns on a separate spreadsheet then paste into the working tab.
    ...
  5. [RESOLVED] Prevent drop down list from moving when column deleted.

    I have a spreadsheet that has a few drop down lists. The problem I will encounter is when data is pasted onto a tab, said data will fill columns A-J, columns A & B will be deleted, thus the last...
  6. [RESOLVED] Prevent drop down list from moving when column deleted.

    I have a spreadsheet that has a few drop down lists. The problem I will encounter is when data is pasted onto a tab, said data will fill columns A-J, columns A & B will be deleted, thus the last...
  7. Re: Filename no extension, left of the first "_"

    ActiveCell.FormulaR1C1 = Left(ActiveWorkbook.name, InStr(ActiveWorkbook.name, "_") - 1) & " " & Format(Now(), "mm/yyyy")


    Posting my own solution.
  8. [RESOLVED] Filename no extension, left of the first "_"

    I am trying to return a portion of a filename.

    This is what I have written:

    ActiveCell.FormulaR1C1 = ActiveWorkbook.name & " " & Format(Now(), "mm/yyyy")

    My filenames come through like...
  9. [RESOLVED] Filename no extension, left of first "_"

    I am trying to return a portion of a filename.

    This is what I have written:

    ActiveCell.FormulaR1C1 = ActiveWorkbook.name & " " & Format(Now(), "mm/yyyy")

    My filenames come through like...
  10. Replies
    3
    Views
    617

    Re: Excel VBA - Does Sheet Exist

    Disregard, I have discovered the error of my ways.
  11. Replies
    3
    Views
    617

    Re: Excel VBA - Does Sheet Exist

    I meant the 'Else' portion
  12. Replies
    3
    Views
    617

    Does Sheet Exist

    I have the attached code that is giving me trouble; this is part of a much larger macro. It will execute one part of the If/Then, depending on if I use an = or > sign. I want the macro to look for a...
Results 1 to 12 of 13



Featured


Click Here to Expand Forum to Full Width

Survey posted by VBForums.