On Sat, 2/25/17, mintaspriggs via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
To: excel-macros@googlegroups.com
Date: Saturday, February 25, 2017, 8:51 AM
On Sat, 2/25/17, margaretatolliver via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
To: excel-macros@googlegroups.com
Date: Saturday, February 25, 2017, 5:37 AM
On Sat, 2/25/17, silvers.r via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
To: excel-macros@googlegroups.com
Date: Saturday, February 25, 2017, 1:19 AM
On Fri, 2/24/17, martinez.david533 via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
To: excel-macros@googlegroups.com
Date: Friday, February 24, 2017, 11:16 PM
On Fri, 2/24/17, silvers.r via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
To: excel-macros@googlegroups.com
Date: Friday, February 24, 2017, 6:07 PM
On Fri, 2/24/17, karleenbiggs via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
To: excel-macros@googlegroups.com
Date: Friday, February 24, 2017, 1:02 PM
On Fri, 2/24/17, margaretatolliver via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
To: excel-macros@googlegroups.com
Date: Friday, February 24, 2017, 11:57 AM
On Fri, 2/24/17, storeythomas725 via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
To: excel-macros@googlegroups.com
Date: Friday, February 24, 2017, 11:44 AM
On Fri, 2/24/17, keisha.fry via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
To: excel-macros@googlegroups.com
Date: Friday, February 24, 2017, 9:21 AM
On Fri, 2/24/17, mintaspriggs via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
To: excel-macros@googlegroups.com
Date: Friday, February 24, 2017, 3:56 AM
On Fri, 2/24/17, silvers.r via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
To: excel-macros@googlegroups.com
Date: Friday, February 24, 2017, 12:59 AM
On Thu, 2/23/17, storeythomas725 via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
To: excel-macros@googlegroups.com
Date: Thursday, February 23, 2017, 8:50 PM
On Thu, 2/23/17, martinez.david533 via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
To: excel-macros@googlegroups.com
Date: Thursday, February 23, 2017, 2:56 PM
On Thu, 2/23/17, silvers.r via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
To: excel-macros@googlegroups.com
Date: Thursday, February 23, 2017, 7:11 AM
On Wed, 2/22/17, keisha.fry via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
To: excel-macros@googlegroups.com
Date: Wednesday, February 22, 2017, 6:21 PM
On Wed, 2/22/17, georgemartin812 via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
To: excel-macros@googlegroups.com
Date: Wednesday, February 22, 2017, 11:52 AM
On Wed, 2/22/17, hopkinsruben865 via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
To: excel-macros@googlegroups.com
Date: Wednesday, February 22, 2017, 10:38 AM
On Wed, 2/22/17, spainy via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
To: excel-macros@googlegroups.com
Date: Wednesday, February 22, 2017, 9:46 AM
On Wed, 2/22/17, silvers.r via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
To: excel-macros@googlegroups.com
Date: Wednesday, February 22, 2017, 7:40 AM
On Wed, 2/22/17, julienneschindler via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
To: excel-macros@googlegroups.com
Date: Wednesday, February 22, 2017, 12:07 AM
On Tue, 2/21/17, libertystringer via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
To: excel-macros@googlegroups.com
Date: Tuesday, February 21, 2017, 4:01 PM
On Tue, 2/21/17, Emamuddin Shah wrote:
Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
To: "MS EXCEL AND VBA MACROS"
Cc: schreiner_p...@att.net
Date: Tuesday, February 21, 2017, 3:11 PM
Dear
Paul,
hope yo
Dear Paul,
hope you have got change to go through the attached files.
---Emam
On Monday, February 6, 2017 at 10:01:43 AM UTC+5:30, Emamuddin Shah wrote:
>
> Hi Paul,
>
> Hope you have received my email.
>
> Regards
> Emam
>
> On Wednesday, February 1, 2017 at 12:52:28 PM UTC+5:30, Emamuddin Shah
Hi Paul,
Hope you have received my email.
Regards
Emam
On Wednesday, February 1, 2017 at 12:52:28 PM UTC+5:30, Emamuddin Shah
wrote:
>
> Dear Paul,
>
> i will share my both excel sheets, so that you can check where iam wrong
> and correct it, since the document is confidential i cant share her
Dear Paul,
i will share my both excel sheets, so that you can check where iam wrong
and correct it, since the document is confidential i cant share here, plz
provide your email id.
regards
Emam
On Thursday, October 20, 2016 at 7:04:17 PM UTC+5:30, Paul Schreiner wrote:
>
> Mr. Emamuddin,
>
> I
Mr. Emamuddin,
I'm looking through your code and have encountered some issues.
First, your sample file is only one sheet,with a Header in row 1 and 2 rows of
data in 24 columns (A:X)
In your code, you use:
sc = Sheets.CountWhich, of course sets the variable "sc" equal to the total
number of sheet
there are x rows more than 100 in that i want to update 50 rows or 20 rows
whatever.
iam able to get row details in array, but those details are not getting
updated on next workbook
i have attached exscel sheet format which iam using, there is 1 more
similar file with coloumns shuffeled
please
I'm trying to follow.There are easier ways to load the array from the cell
values, but I'll get to that later.
But:You said that you have 50 rows. that means that with:lr =
Activecell.Cells(.Rows.count, "A").End(xlUp).Row + 1
lr (last row) = 51you set:size = 100So, for your loop:For b = lr - (siz
ITS NOT UPDATED ALL 50 STRINGS ROW DETAILS.
IT IS UPDATING ONLY FIRST MATCHED STRING ROW.
On Tuesday, October 18, 2016 at 6:13:56 PM UTC+5:30, Emamuddin Shah wrote:
>
> Hello
>
> Iam trying to Loop so that it matched a string and then fills cells in
> that row.
> say i have 50 strings to be matc
here is complete Code.
Sub Update_auto()
Application.ScreenUpdating = False
Dim sc, lri, sar, lr, cm, b, i, c, size As Integer
Dim cold(), cmail(), stat1(), stat2(), ccdate(), ctime() As Variant
sc = Sheets.count
sar = Selection.Row
size = 100
ReDim cold(size), cmail(size), stat1(size), stat
30 matches
Mail list logo
