Thanks
On Wed, Jan 9, 2013 at 2:41 PM, Rajan_Verma wrote:
>
> Dim Shp As Shapes
> Set Shp = Sheet1.Shapes
>
> shp object will have all shapes reference with in sheet1, you can use
> shp(1) to color the first shape
>
> Rajan
>
>
> On Tuesday, 8 January 2013 21:38:13 UTC-7, Amol J wrote:
>>
>> Tha
I like your answer Rajan. :)
regards
prince
On Wednesday, January 9, 2013 2:41:18 PM UTC+5:30, Rajan_Verma wrote:
>
>
> Dim Shp As Shapes
> Set Shp = Sheet1.Shapes
>
> shp object will have all shapes reference with in sheet1, you can use
> shp(1) to color the first shape
>
> Rajan
>
>
> On T
Dim Shp As Shapes
Set Shp = Sheet1.Shapes
shp object will have all shapes reference with in sheet1, you can use
shp(1) to color the first shape
Rajan
On Tuesday, 8 January 2013 21:38:13 UTC-7, Amol J wrote:
>
> Thanks Divaker
>
> Regards
> Amol
>
> On Tue, Jan 8, 2013 at 6:46 PM, Divake
Thanks Divaker
Regards
Amol
On Tue, Jan 8, 2013 at 6:46 PM, Divaker Pandey wrote:
>
> PFA
>
>
> On Tue, Jan 8, 2013 at 1:40 PM, Amol J wrote:
>
>> Hi Experts,
>>
>> I need help
>>
>> I have multiple shapes in sheet so i want color only one shapes in that
>> perticular sheet. So I created a fun
PFA
On Tue, Jan 8, 2013 at 1:40 PM, Amol J wrote:
> Hi Experts,
>
> I need help
>
> I have multiple shapes in sheet so i want color only one shapes in that
> perticular sheet. So I created a function which Change the color of
> provided set of shapes.
>
> I want know how to pass array of shapes
Hi Experts,
I need help
I have multiple shapes in sheet so i want color only one shapes in that
perticular sheet. So I created a function which Change the color of
provided set of shapes.
I want know how to pass array of shapes to function.
Please help me to solve this problem
Thanks
Amol
--
