-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Query for Code
Also, based on your statement:in the summary sheet we want to see total of all
centres based on the month of selection which is a respective start date
implies that, if you have 30 centres:let's say 10 started in May, 10 started
-
From: gargee singh garge...@hotmail.com
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Tuesday, July 28, 2015 1:05 AM
Subject: RE: $$Excel-Macros$$ Query for Code
!--#yiv8905106271 .yiv8905106271hmmessage
P{margin:0px;padding:0px;}#yiv8905106271
you can.” - John Wesley
-
From: gargee singh garge...@hotmail.com
To: excel-macros@googlegroups.com excel-macros@googlegroups.com
Sent: Tuesday, July 28, 2015 1:05 AM
Subject: RE: $$Excel-Macros$$ Query for Code
!--#yiv8905106271
So, you're saying that if you select May 1, 2016 on the Summary Sheet,only the
column for May 1, 2016 on the Summary sheet (column G) will be populated?and
it will be a sum of all sheets in which the first column matches the date
selected?In your example, even though sheets A and C have a
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Query for Code
So, you're saying that if you select May 1, 2016 on the Summary Sheet,only the
column for May 1, 2016 on the Summary sheet (column G) will be populated?and
it will be a sum of all sheets in which the first column matches
Replace .addattachment rngAttach1.Value with
If Dir(rngAttach1.Value) Then
.addattachment rngAttach1.Value
End If
Cheers!!
On Tue, Mar 24, 2015 at 9:05 AM, Ashish Bhalara ashishbhalar...@gmail.com
wrote:
When value of path is null, function by default set 0 in cell F2, so I
tried below
Before adding att check if attachment exists or not, if its null then you
will get error...
Cheers!!
On Mon, Mar 23, 2015 at 5:00 PM, Ashish Bhalara ashishbhalar...@gmail.com
wrote:
Dear experts,
See the attached file of email sending from excel. Normally mail send
successfully to all
When value of path is null, function by default set 0 in cell F2, so I
tried below code to avoid error on path not written in cell. but though
same error is occur, pls do something in coding.
If ws.Range(F2) Chr(48) Then
.addattachment rngAttach1.Value
End If
On Mon,
