Hi,
For inserting a new sheet:
Sheets.Add
Renaming it:
Activesheet.Name = "Test1"
For the pivot can give the details exactly what error are you getting.
Manish
From: excel-macros@googlegroups.com [mailto:[EMAIL PROTECTED]
On Behalf Of deepa bharti
Sent: Monday, October 13, 200
Hi Deepa,
I had done several macros for creating pivots through a macro. Guess, I can
help in this. To insert new worksheets, put "worksheets.add" in ur code, &
worksheets.name =" xxx" to set the names
Sharad
On 10/13/08, deepa bharti <[EMAIL PROTECTED]> wrote:
>
> Hi,
> i know this would be a
My Pleasure,
By Pressing CTRL+SHIFT+ENTER, we create an array formula. And one of the
restrictions of the array formula is, it can not work on an entire row, or
column.
I would urge you to analyze this formula and any other formula with
Tools->Formula Auditing->Evaluate Formula. And you will see t
Hi,
i know this would be a very basic question but I need to get create a pivot
through a macro but I am facing soem debugging issue .
can anyone help me with that.
Also I would like to know the command for inseting a new worksheet in an
workbook and renaming it.
Thanks
--~--~-~--~~--
Dear All,
Its any one taught me test of significance & how to apply this in FMCG data
with example files.
Its a need of the hour.
Regards
Akash sheeba
Rama Arcade,
Delhi
On Fri, Oct 10, 2008 at 1:15 PM, Ajay Varshney
<[EMAIL PROTECTED]>wrote:
> your query resolved in the attached file.
>
> R