I have a spreadsheet with columns A through AD and have about 1000 rows on
my report. I need to run the report every month and send an email to anyone
that has a greater than or equal to 6 in Column "W". If column "W" is
greater than or equal to 6, then click a "send emails" button with an
at
The property TopLeftCell in itself is of type range. The code above can be
shorter.
Sub test()
Dim shp As Shape
For Each shp In ActiveSheet.Shapes
MsgBox shp.TopLeftCell.Address
Next
End Sub
Regards,
Sam Mathai Chacko
On Tue, Nov 19, 2013 at 2:22 PM, Chandra Shekar <
chandrashekarb@gmai
See this..
http://www.addictivetips.com/windows-tips/enable-all-macros-in-excel-2010/
http://office.microsoft.com/en-us/excel-help/enable-or-disable-macros-in-office-files-HA010354316.aspx
regards
Basole
Em sábado, 16 de novembro de 2013 11h09min57s UTC-2, sharad escreveu:
>
> The attach file
i have done that also .! & some of the images are attached as an attachment
and against them there is a red cross in the email body, and some images
are attached in the email body.
On Tue, Nov 19, 2013 at 2:22 PM, wrote:
> You need to attach the images as well
> Sent on my BlackBerry® from Vo
You need to attach the images as well
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Farrukh Shaikh
Sender: excel-macros@googlegroups.com
Date: Tue, 19 Nov 2013 13:10:50
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Stuck in attaching multiple
Hello,
Thank you very much.
Regards,
Chandru
On Mon, Nov 18, 2013 at 11:45 PM, ashish koul wrote:
> Sub test()
> Dim shp As Shape
>
> For Each shp In ActiveSheet.Shapes
> MsgBox Cells(shp.TopLeftCell.Row, shp.TopLeftCell.Column).Address
> Next
>
>
>
> End Sub
>
>
>
> On Mon, Nov 18, 2013
Thanks ashish koul, i tried and its working now but in a slightly
different way .! here is the line :
uuu = Mid(sImgPath, InStrRev(sImgPath, "\") + 1)
HTML = HTML + ""
.HTMLbody HTML
But now the images in the body are shown as red cross rather then the whole
image.
suggestions are anxiously awai
