# Search:

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

Page 1 of 5 1

1. ## Thread: Loop filter multiple criteria different columns

by amitcohen
Replies
0
Views
191

### 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...

by amitcohen
Replies
3
Views
2,472

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

What I'm looking for is more like: Userform generator

by amitcohen
Replies
3
Views
2,472

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. ## Thread: Count groups of cells is a range

by amitcohen
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. ## Thread: Count groups of cells is a range

by amitcohen
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. ## Thread: Count groups of cells is a range

by amitcohen
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. ## Thread: Count groups of cells is a range

by amitcohen
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. ## Thread: Looping through sheets, loop inside a loop

by amitcohen
Replies
8
Views
350

### 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. ## Thread: Looping through sheets, loop inside a loop

by amitcohen
Replies
8
Views
350

### 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. ## Thread: Looping through sheets, loop inside a loop

by amitcohen
Replies
8
Views
350

### 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. ## Thread: Looping through sheets, loop inside a loop

by amitcohen
Replies
8
Views
350

### 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. ## Thread: User-defined type not defined when sending email using Excel.

by amitcohen
Replies
4
Views
12,831

### 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. ## Thread: User-defined type not defined when sending email using Excel.

by amitcohen
Replies
4
Views
12,831

### 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. ## Thread: User-defined type not defined when sending email using Excel.

by amitcohen
Replies
4
Views
12,831

### 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. ## Thread: Cut out rows based on wildcard criteria

by amitcohen
Replies
4
Views
300

### Re: Cut out rows based on wildcard criteria

VoG,
Thanks you so much for the help

Its perfect.

Amit
16. ## Thread: Cut out rows based on wildcard criteria

by amitcohen
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. ## Thread: Cut out rows based on wildcard criteria

by amitcohen
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. ## Thread: Help with vbNewLine for Email to Loop through values in Column A

by amitcohen
Replies
8
Views
691

### Re: Help with vbNewLine for Email to Loop through values in Column A

Hi
This one is perfect!!

Problem solved :)
Thank you.

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

by amitcohen
Replies
8
Views
691

### 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. ## Thread: Help with vbNewLine for Email to Loop through values in Column A

by amitcohen
Replies
8
Views
691

### 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. ## Thread: Help with vbNewLine for Email to Loop through values in Column A

by amitcohen
Replies
8
Views
691

### 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. ## Thread: Replace text in a txt files

by amitcohen
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. ## Thread: Replace text in a txt files

by amitcohen
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. ## Thread: Replace text in a txt files

by amitcohen
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. ## Thread: Replace text in a txt files

by amitcohen
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