Hi, Please find the shortcuts you are looking for...Alt+H+AL for Left
Alignments, Alt+H+AC for Center Alignments, & Alt+H+AR for Right Alignments
Regards...Shreedar
On 30-Jul-2012, at 8:57 AM, "Anjali ." wrote:
> Hi Group,
> Can any one please help me to know how to align left, right and cente
Dear Group,
Use the following links to download, MS Office 2013 64 Bit & 32 Bit - 60
days trial version:
http://kat.ph/microsoft-office-professional-2013-with-serial-t6517550.html
http://kat.ph/microsoft-office-preview-2013-standalone-installer-x86-tejasnair-t6513972.html
http://www.hacktrix.co
Hi Ashish,
You won't face any version clash issue after installing Office 2010.
Installing process will offer you to keep your previous version of Office.
However the Outlook will be upgraded.
Regards,
Anoop
On Mon, Jul 30, 2012 at 1:43 AM, David Grugeon wrote:
> What do you mean by "sharing"
Hi Group,
Can any one please help me to know how to align left, right and center in a
cell in excel file through shortcut key.
Thanks & Regards,
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need
What do you mean by "sharing"? Do you mean you want someone to support you
illegally installing a copy of office you do not have a licence for? That
is theft.
On Wednesday, 30 May 2012, Ashish Pradhan wrote:
>
> Hey
>
> Thanks Don and CoRe for the prompt replies. Am going ahead with the
> multipl
ya u r rite,i though abt trace dependant and add watch feature but it takes
lots of time,any short cut?
> Date: Sun, 29 Jul 2012 07:45:48 +0530
> Subject: Re: $$Excel-Macros$$ watch help
> From: samde...@gmail.com
> To: excel-macros@googlegroups.com
>
> by effect you mean how other sheets are
hi
why do u want to use vba . simple make the dynamic range and add it to the
source of pivot whenever u will add or delete the data in source sheet it
will automatically get updated
try the attachment
visit to know more abt
http://www.contextures.com/xlPivot01.html
On Sun, Jul 29, 201
Hi,
I have recorded th macro for creating pivot table with pivot chart for the
1st time and running for 2nd time gives me an error - Run time error 5
Please help in changing the *vba* code as shows in Sheet("Summary") with 1
click button to go.
Request everyone to pls have this resolved asap.
Hi David,
Thank you for the file...it looks exactly what I'm after!!!
Many thanks for all your help!
Kevin
>
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Pr
Dear fellow members,
My name is Aju v chacko (41),I am
working in MRF TYRES,Kottayam,Kerala as SAP coordinator.I have moderate
knowledge in excel macros & I received great help from this community.My
main hobby is reading & I have created a RECONCILIATION TOOL i
What do you mean by Genuine ?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of rao
Sent: 29 July 2012 7:36
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Multiple Versions of Excel
Hey, Do u have the genuine Excel 2010?? if yes, Do you mine sharing this.
Cheers,
Prabhakar
On Tue, May 29, 2012 at 10:09 PM, Ashish Pradhan wrote:
>
> Hey
>
> Thanks Don and CoRe for the prompt replies. Am going ahead with the
> multiple installations. Hope all goes well. :-)
>
> Thanks
>
> As
variable rng used as obj.. revised
Sub T()
Dim rngCluster As Range
Dim rng As Range
Set rngCluster = Application.Union(Range("A1:C3"), Range("D5:E10"))
For Each rng In rngCluster.Areas
MsgBox rng.Address
Next rng
End Sub
On Sun, Jul 29, 2012 at 5:05 PM, Sam Math
Prince,
I missed the part about selecting to contiguous cell groups. And come to
think of it, it doesn't necessarily have to be non-empty.
Try this
Sub T()
Dim rngCluster As Range
Dim rng As Range
Set rngCluster = Application.Union(Range("A1:C3"), Range("D5:E10"))
MsgBox rngClu
Hi Vikram,
The Workday() function return the next working day after the specified no
of days it excludes the weekends and the days you have specified as the
holidays.
for example if i write: =WORKDAY(DATEVALUE("11/1/2012"),10) the will return
11/15/2012 because there will be weekends on 3,4 an
Hi Sam,
Thanks for the reply,
I did the same as you have mentioned in your post i created a range A1:E9
in which i inserted data from A1:C3 and then D5:E9 and i wrote
Sheet1.range(A1:E9).Areas(1).Address but it returned $A$1:$E$9 as address
and in case of Sheet1.range(A1:E9).Areas(1).count it
Hi David... Once again thanks for your response, but no workbook attached,
so I cant test your code!!!
Please could you resend?
>
>
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, For
Hi David... Once again thanks for your response, but no workbook attached,
so I cant test your code!!!
Please could you resend?
On Sunday, July 29, 2012 11:27:01 AM UTC+1, skyping1 wrote:
>
>
>
> On Thursday, July 26, 2012 6:57:03 PM UTC+1, skyping1 wrote:
>>
>> Need your help once again!!!
>>
>
On Thursday, July 26, 2012 6:57:03 PM UTC+1, skyping1 wrote:
>
> Need your help once again!!!
>
> A previous project needs to be updated and I simply cannot my head around
> it.
>
> I have a workbook that currently comprises of 5 worksheets, 3 of which are
> relating to my problem and are hidde
H,
Please help regarding how to implement workdays formula.
--
Regards,
Vikram Ahuja
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice wi
20 matches
Mail list logo
