$$Excel-Macros$$ Excel change Language

2013-02-05 Thread Amol J
Hello Experts, I need your help on how to change excel language. Please help me to clear my below queris 1) I have written my vba in code in english and my excel file is going to use in Germany on german systems with german language excel application. so here is problem my some code is giving ga

Re: $$Excel-Macros$$ Passing array of shapes to udf using vba

2013-01-09 Thread Amol J
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

Re: $$Excel-Macros$$ Passing array of shapes to udf using vba

2013-01-08 Thread Amol J
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 sh

$$Excel-Macros$$ Passing array of shapes to udf using vba

2013-01-08 Thread Amol J
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 --

Re: $$Excel-Macros$$ Need help on macro Re-organize data from a 2 dimensional grid to a single dimensional grid

2012-08-21 Thread Amol J
f VBA is not enough to solve this question. Need your help. Regards, Amol j On Monday, August 20, 2012 9:31:30 PM UTC+5:30, Don Guillett wrote: > > Your first sample showed a blank col B. Try this > Sub rearranecolumnsSAS() > Dim lr As Long > Dim i As Long > Dim

$$Excel-Macros$$ Need help on macro Re-organize data from a 2 dimensional grid to a single dimensional grid

2012-08-19 Thread Amol J
following Item STATE Sales A MH 1 B MH 4 C MH 7 A GJ 2 B GJ 5 C GJ 8 A KA 3 B KA 6 C KA 9 Please help me on this problem. Thanks, Amol J -- Join official facebook page

Re: $$Excel-Macros$$ UDF - to sum range

2012-08-19 Thread Amol J
Hi Experts, I have done this using Indirect(), Can you please help with UDF. I waiting for your valuable reply Regards, Amol J On Sunday, August 19, 2012 2:46:36 PM UTC+5:30, Amol J wrote: > Hi All, > > Please help me with this problem. its related to range reference

Re: $$Excel-Macros$$ UDF - to sum range

2012-08-19 Thread Amol J
:34:34 AM UTC+5:30, David Grugeon wrote: > I think you need to fix the first part of youyr reference as in enclosed > example. > > On 18 August 2012 13:43, Amol J > wrote: > >> >> Hi NOORAIN, >> >> Thanks for your quick responce >> >> B

$$Excel-Macros$$ UDF - to sum range

2012-08-16 Thread Amol J
Hi experts, I need your help, I tried myself but unfortunatly its not working. I need UDF to sum range. 1) first my range will be B4:E4 and I am going to drag udf into columns to next range will be C5:E5, Means when I will drag my udf function it will increase in range by 1column and 1 row

$$Excel-Macros$$ UDF to sum range

2012-08-16 Thread Amol J
Hi experts, I need your help, I tried myself but unfortunatly its not working. I need UDF to sum range. 1) first my range will be B4:E4 and I am going to drag udf into columns to next range will be C5:E5, Means when I will drag my udf function it will increase in range by 1column and 1 row