date:20101226

RE: $$Excel-Macros$$ Regarding Code

2010-12-26 Thread Daniel

Hi,

Use a unused column to put your items (here, I use column G) :

 

Selection.AutoFilter

Set rg = [G1].Resize(Application.CountA([G:G]))

arr = Application.Transpose(rg)

ActiveSheet.Range("$A$1:$E$500").AutoFilter Field:=2, Criteria1:=arr,
Operator:=xlFilterValues

Rows("2:2").Select

Range(Selection, Selection.End(xlDown)).Select

Selection.Delete Shift:=xlUp

Selection.AutoFilter

 

Regards.

Daniel

De : excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] De
la part de vebhav jain
Envoyé : jeudi 23 décembre 2010 15:50
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Regarding Code

 

Hi All,

 

Please can you help me in updating the below code marked in a red color,
where data keep varies, so want to have common code.


 Selection.AutoFilter 
ActiveSheet.Range("$A$1:$E$500").AutoFilter Field:=2, Criteria1:=Array(
_ 
"Account", "As of", "E", "T", "TBR/F", "="),
Operator:=xlFilterValues 
Rows("2:2").Select 
Range(Selection, Selection.End(xlDown)).Select 
Selection.Delete Shift:=xlUp 
Selection.AutoFilter

 

Regards

Vebhav Jain

-- 

--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall
 &ref=ts

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Cut and Paste Multiple Column Range Data into One Column

2010-12-26 Thread Financeguy

Hi,

I'm trying to select one range at a time for each individual column
within a single worksheet.  I have range data in approximately 150
columns on the worksheet that I would like to sort individually
(ascending order), then cut, and finally paste into the last row of
Column A.

For example, if I had data on a sheet, like A1:A13000, B1:B1453,
C1:C1232...and so on... till say CC1:CC1535I'd like to cut
each rangeB1:B14535, and paste it below A13000.and so on..

It is cumbersome to do it manually, and I would love some VBA code
that could help me with accomplish this.

Many thanks in advance,

Finance guy

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Formula required to find the highest & lowest values in each month

2010-12-26 Thread Rajesh K R

Hi experts

Wish you happy new year

I have worksheet like this
Column A - Date
Column B - Amt
Column C - Name of Month
Column D - For highest value of each month
Column E - For lowest value of each month
Pls check the attached file & tell me
what is the formula for finding the highest & lowest value.

Regards
Rajesh Kainikkara

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts


higest & lowest.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ excel-macros : Get Agents Name under Team Leader

2010-12-26 Thread Sundarvelan N

Hi Rohan,

Thanks for your reply, but i dont want to edit my original excel file. I
need to get the agents name under corresponding TL names like wise TL names
under manager name.

Thanks,
Sundarvelan
9600160150

On Fri, Dec 24, 2010 at 3:43 PM, Rohan Young  wrote:

> Hi,
>
> Please find the solved attached file as required by you
>
> for any clarification feel free to contact
>
> ROHAN
> 9818247278, 8860567680
>
>
> On Thu, Dec 23, 2010 at 3:42 PM, Sundarvelan N  wrote:
>
>> Hi Group,
>>
>> I need macro int this scenario.
>>
>> Please help in this scenario. I need to get Agents names under respective
>> Teamleaders name. likewise i need to team leaders name under each respective
>> Managers name.
>>
>> --
>> Thanks
>> N.Sundarvelan
>> 9600160150
>>
>>  --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>>
>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>  --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



-- 
Thanks
N.Sundarvelan
9600160150

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ Re: Automation of copy paste exercise

2010-12-26 Thread Umar Abeer

Dear All,

I am presently updating a month P&L column using links to a trial balance
every month. So for the month of Jan, I will paste  the trial balance and
Jan P&L will populate itself. For the month of Feb, I will copy the links in
the Jan column in the next column and will change Jan column to values. For
March, the same routine is repeated.

I would appreciate if somebody can tell me how to automate this exercise?

Regards,
U Abeer

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Re: Lock the Object

2010-12-26 Thread hanumant shinde

simply select E12:J22 cells lock them then protect sheet using password so 
nobody can unprotect it. see the attached file n let me know if it works for u.






From: Chandra Shekar 
To: excel-macros@googlegroups.com
Sent: Thu, 23 December, 2010 3:48:40 PM
Subject: Re: $$Excel-Macros$$ Re: Lock the Object


Hello,
 
Thank you for ur reply. If we right click mouse on the object we can edit the 
object. Please check it out.


On Wed, Dec 22, 2010 at 8:06 PM, JsinSk  wrote:

I believe you just need to set the locked object on your item (already
>done in your sheet), and then put protection on the sheet. (Tools|
>Protection|Protect Sheet)
>
>On Dec 22, 7:08 am, Chandra Shekar 
>wrote:
>> Hello,
>>
>> How to lock the object? User should not edit the object or delete the
>> object.
>>
>> Please find attached file.
>>
>> Thanks
>>
>> Chandra Shekar
>>
>>  Object_Lock.xls
>> 25KViewDownload
>
>--
>--
>
>Some important links for excel users:
>1. Follow us on TWITTER for tips tricks and links : 
>http://twitter.com/exceldailytip
>2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>3. Excel tutorials at http://www.excel-macros.blogspot.com
>4. Learn VBA Macros at http://www.quickvba.blogspot.com
>5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
>To post to this group, send email to excel-macros@googlegroups.com
>
><><><><><><><><><><><><><><><><><><><><><><>
>Like our page on facebook , Just follow below link
>http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--

Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

To post to this group, send email to excel-macros@googlegroups.com
 
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts


Object_Lock.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Is it a Challenge!!!!!

2010-12-26 Thread Deepak Rawat

Hi Daniel

I really appreciate your cooperation for this problem.
Special thanx to you

Regards,
Deepak Rawat

On Fri, Dec 24, 2010 at 7:07 PM, Daniel  wrote:

>  Hi,
>
> Have a look at the attached file. Deafault is current date and time. But,
> if you change the date with the calendar control, you have nowhere to select
> time.
>
> Regards.
>
> Daniel
>
>
>
> *De :* excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
> *De la part de* Deepak Rawat
> *Envoyé :* jeudi 23 décembre 2010 12:24
>
> *À :* excel-macros@googlegroups.com
> *Objet :* Re: $$Excel-Macros$$ Is it a Challenge!
>
>
>
> Hi
>
> i didnt mean to hurt anybody!!
>
>
> Thanx Daniel for ur friendly support!!!
>
> One thing i also want in this file that the calender should take current
> date & time by itself.
>
>
>
> Thanx
>
> Deepak
>
> On Fri, Dec 17, 2010 at 10:27 AM, Deepak Rawat 
> wrote:
>
> Hi i have posted this problem two times but got no reply
>
> Is it a challenge!!!
>
> Dear All
>
>
>
> I am designing a user form but new to this, so i need help on prgramming.
> The logic i am mentioning here as under:
>
>
>
> Threre are 2 comboBoxes, one calender, and amount file.
>
> What i want
>
> 1. Which date i would select that should show in Label4
>
> 2. First i would select an Type from ComboBox1("cboType")
>
> 3. Then there should items should come in second ComboBox("cboItem")
>
> 4. Then user will fill the amount and then enter
>
> 5. Finally all the data should be entered in the excel sheet as i press
> Enter
>
>
>
> For Example I would select in first ComboBox("cboType) "Milk" then there
> should come automatically some items like "Full Cream Milk", "Poly Pack" in
> the in second combobox("cboItem")
>
>
>
> and finally all the data should be entered in the excel sheet as the user
> press Enter
>
> File is attached!!
>
>
>
> Regards,
>
> Deepak Rawat
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://tw

Re: $$Excel-Macros$$ Formula required to find the highest & lowest values in each month

2010-12-26 Thread ashish koul

check the attachment
On Sun, Dec 26, 2010 at 3:15 PM, Rajesh K R wrote:

> Hi experts
>
> Wish you happy new year
>
> I have worksheet like this
> Column A - Date
> Column B - Amt
> Column C - Name of Month
> Column D - For highest value of each month
> Column E - For lowest value of each month
> Pls check the attached file & tell me
> what is the formula for finding the highest & lowest value.
>
> Regards
> Rajesh Kainikkara
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts


higest_&_lowest(1).xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Formula required to find the highest & lowest values in each month

2010-12-26 Thread Rajesh K R

Hi Ashish

Thank u very much, for ur fast & perfect answer

Regards
Rajesh Kainikkara

On 12/26/10, ashish koul  wrote:
> check the attachment
> On Sun, Dec 26, 2010 at 3:15 PM, Rajesh K R
> wrote:
>
>> Hi experts
>>
>> Wish you happy new year
>>
>> I have worksheet like this
>> Column A - Date
>> Column B - Amt
>> Column C - Name of Month
>> Column D - For highest value of each month
>> Column E - For lowest value of each month
>> Pls check the attached file & tell me
>> what is the formula for finding the highest & lowest value.
>>
>> Regards
>> Rajesh Kainikkara
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>>
>
>
>
> --
> *Regards*
> * *
> *Ashish Koul*
> *akoul*.*blogspot*.com 
> *akoul*.wordpress.com 
> My Linkedin Profile 
>
>
> P Before printing, think about the environment.
>
> --
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

Re: $$Excel-Macros$$ Re: Automation of copy paste exercise

2010-12-26 Thread in . vaibhav

Hi

Send attachment

Sent on my BlackBerry® from Vodafone

-Original Message-
From: Umar Abeer 
Sender: excel-macros@googlegroups.com
Date: Sun, 26 Dec 2010 10:56:20 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Automation of copy paste exercise

Dear All,

I am presently updating a month P&L column using links to a trial balance
every month. So for the month of Jan, I will paste  the trial balance and
Jan P&L will populate itself. For the month of Feb, I will copy the links in
the Jan column in the next column and will change Jan column to values. For
March, the same routine is repeated.

I would appreciate if somebody can tell me how to automate this exercise?

Regards,
U Abeer

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

$$Excel-Macros$$ 17 ways to Optimize VBA Code for FASTER Macros

2010-12-26 Thread OpenExcel.com

17 ways to Optimize VBA Code for FASTER 
Macros
Here is a summary of the article:
1. Analyze the Logic  2. Turn off 
ScreenUpdating
3. Turn off 'Automatic Calculations'   4. Disable Events
5. Hide Page breaks   6. Use 'WITH' 
statement
7. Use vbNullString instead of "" 8. Release memory 
of Object variables
9. Reduce the number of lines using colon(:) 10. Prefer constants
11. Avoid Unnecessary Copy and Paste   12. Clear the Clipboard 
after Paste
13. Avoid 'Macro Recorder' style code.   14. Use 'For Each' than 
'Indexed For'
15. Use 'Early Binding' rather 'Late Binding' 16. Avoid using 
Variant
17. Use Worksheet Functions wherever applicable

*Do read full article to understand the logic behind 
them.*




___
Thanks & Regards 
Ashish Jain 
(Microsoft Certified Application Specialist) 
(Microsoft Certified Professional) 
http://www.excelitems.com 
http://www.openexcel.com 
___ 

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts

RE: $$Excel-Macros$$ Regarding Code

$$Excel-Macros$$ Cut and Paste Multiple Column Range Data into One Column

$$Excel-Macros$$ Formula required to find the highest & lowest values in each month

Re: $$Excel-Macros$$ excel-macros : Get Agents Name under Team Leader

$$Excel-Macros$$ Re: Automation of copy paste exercise

Re: $$Excel-Macros$$ Re: Lock the Object

Re: $$Excel-Macros$$ Is it a Challenge!!!!!

Re: $$Excel-Macros$$ Formula required to find the highest & lowest values in each month

Re: $$Excel-Macros$$ Formula required to find the highest & lowest values in each month

Re: $$Excel-Macros$$ Re: Automation of copy paste exercise

$$Excel-Macros$$ 17 ways to Optimize VBA Code for FASTER Macros

11 matches

Site Navigation

Mail list logo

Footer information