Search:

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

Page 1 of 5 1 2 3 4

Search: Search took 0.01 seconds.

  1. Loop filter multiple criteria different columns

    Hello Team

    I'm struggling with this one..

    Step 1) Filter MAIN Category (On field 20)
    Step 2) Then Filter SUB Category (On field 4)
    Step 3) Do the magic
    Step 4) Goto the next MAIN Category...
  2. Replies
    3
    Views
    2,472

    Re: Tool to help you build excel userform

    Hi Andrew
    I'm familiar with that one.. Its a tutorial.

    What I'm looking for is more like: Userform generator
    an application that will help you generate userform in easy/fast way
  3. Replies
    3
    Views
    2,472

    Tool to help you build excel userform

    Hi All

    Is there a web/online app or a desktop software that can help you design and build Userforms
    That can also generate the code for you?

    Hope you can give me some directions.

    Thanks,...
  4. Replies
    6
    Views
    807

    Re: Count groups of cells is a range

    Hi Ron
    It works like a charm.

    With the spirit of the Olympic games,
    You get the Gold medal. :)

    Thank you so much for your time and efforts.

    Amit Cohen.
  5. Replies
    6
    Views
    807

    Re: Count groups of cells is a range

    Hi Ron
    Just 1 more Q, if I may..

    Is there a way to keep the 'Group Size' accordingly?
    I mean instead of ascending, to keep it the right order,
    Like:


    Char Group Count Grp_01 Grp_02...
  6. Replies
    6
    Views
    807

    Re: Count groups of cells is a range

    Hi Ron

    This is just perfect!
    Thank you so much for taking your time and help with solution.

    Amit.
  7. Replies
    6
    Views
    807

    Count groups of cells is a range

    Hi Guys

    I have a row that contains the following cells
    (First cell is 'A1', last cell is 'AB1')

    X X X X X Z Z Z X X X X X X X X X X Z Z Z Z X X X X X X

    Need to find a way to:
    1. Formula...
  8. Re: Looping through sheets, loop inside a loop

    Hi CharlesChuckieCharles

    Thanks for the code.
    Now I understand it better.

    Had to modified your code a bit (It just didn't run properly)


    Dim ws As Worksheet
    Dim lSheetCt As Long
  9. Re: Looping through sheets, loop inside a loop

    Well, the idea is simple..

    I got a source sheet, name as sheets("DB")
    in column A there is a 36 cells with data ("A1:A36")

    Now comes the tricky thingy,
    I need to copy "A1", goto to "sheet3"...
  10. Re: Looping through sheets, loop inside a loop

    Hi SteveO59L

    Thanks for that,
    But I'm not sure where exactly to insert the code.. :confused:

    I try and replaced your code with the Range("A1").Copy
    but its not working..
  11. Looping through sheets, loop inside a loop

    Hi All
    I use the following macro to copy a cell from sheets("DB").Select
    and paste it to a cell in another sheet.

    Dim ws As Worksheet
    For Each ws In Worksheets
    With ws
    Select Case .Name...
  12. Re: User-defined type not defined when sending email using Excel.

    Thanks mvptomlinson
    I'll try modified the macro accordingly.

    If it help for future users who might land on this thread,
    The solution you gave, does work perfectly for the Ron de Bruin
    macro...
  13. Re: User-defined type not defined when sending email using Excel.

    Hi mvptomlinson
    I have added the 'Microsoft Outlook 12.0 Object Library'

    But now, its giving me the 'Run time error 438
    Object doesn't support this property or method.
    (VBA editor highlights...
  14. User-defined type not defined when sending email using Excel.

    Hi

    I have found this macro (http://www.slipstick.com/outlook/2010/multiple-accounts-and-the-default-account/)

    'Sub Mail_small_Text_Change_Account()
    Public Sub New_Mail()
    Dim oAccount As...
  15. Replies
    4
    Views
    300

    Re: Cut out rows based on wildcard criteria

    VoG,
    Thanks you so much for the help

    Its perfect.

    Amit
  16. Replies
    4
    Views
    300

    Re: Cut out rows based on wildcard criteria

    Thanks VoG
    This is great!! :)

    If I may ask one more Q here..
    (Or should I start new thread)

    How to re-run the macro so it will check the criteria again, this time on column B ?


    Amit
  17. Replies
    4
    Views
    300

    Cut out rows based on wildcard criteria

    Hi

    This code loop through list of criteria and move(cut) any row with a match.

    How can I use a 'wild card' here?


    Dim TheRange As Range
    Dim TheCell As Range
    Set TheRange =...
  18. Re: Help with vbNewLine for Email to Loop through values in Column A

    Hi
    This one is perfect!!

    Problem solved :)
    Thank you.

    Amit
  19. Re: Help with vbNewLine for Email to Loop through values in Column A

    Hi Michael,
    Thanks, but changing the lines didn't help.


    Have any idea how to go around it?
  20. Re: Help with vbNewLine for Email to Loop through values in Column A

    Hi Jon
    Shalom ;)
    Thank you for the quick replay.

    Well, it seems to be fine now, as VBA parse the value..
    However its Yellow highlighting the line code:

    Set olMail =...
  21. Help with vbNewLine for Email to Loop through values in Column A

    Hi
    I'm trying to create code for the Email Body that will contain more the just one row.
    I'm using the & vbNewLine & but when it come to the place where I need to refer to the cell in column A, VBA...
  22. Replies
    8
    Views
    493

    Re: Replace text in a txt files

    This is great!
    Works like a charm.
    :)

    Thank you for the help

    Amit
  23. Replies
    8
    Views
    493

    Re: Replace text in a txt files

    Hi Gavin
    Excel is only storage data for the VBA to run on txt files
    The replace text is done on a list of txt files (and not on the excel's cells)
  24. Replies
    8
    Views
    493

    Re: Replace text in a txt files

    Hi wigi
    Thanks for the replay.

    Well, funny enough I'm using this code on other macro I have, and it works just fine.

    Here is the original code:


    'Build list of files in the folder...
  25. Replies
    8
    Views
    493

    Replace text in a txt files

    Hi All
    I'm trying to build a macro the replace string (text) with another string.


    Sub Replace_Text_test()
    '1. Build list of files in the folder
    Range("B:B").Select
    Selection.ClearContents...
Results 1 to 25 of 118
Page 1 of 5 1 2 3 4