Re: $$Excel-Macros$$ Help required in conditional formatting

2010-01-15 Thread Dilip Pandey
Dear Manoj,

As requested, please find below the process.

Assume you want to do conditional formatting in entire row 2, if it has some
specific text i.e, (DILIpandey) in column B.
so if B2 has value as "DILIpandey", then entire row will change to Red.

Steps:-

1)  Select the entire row # 2, by clicking on the 2 with left button of
mouse.
2)  Press Alt + O + D
3)  Change "Cell Value Is" to "Formula is" by selecting the same from drop
down.
4)  Apply the followig formula in next field
=$B$2="DILIpandey"

5) click on "Format" button and select the pattern as Red color
6) click OK and you should be done.

check:=> go to each cell and you'll find the formula as =$B$2="DILIpandey",
which means if B2 is having DILIpandey, then only it will change to Red in
color.  See the dollor sign which is used to fixed the reference and will
not allow to move the reference.

If you got the logic, then you can add other conditions as well and do the
task.

Best Regards,

-- 
DILIP KUMAR PANDEY
  MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062


On Thu, Jan 14, 2010 at 10:55 AM, Manoj S Negi <
manojsnegi.uttranc...@gmail.com> wrote:

> Hi Mr. Dilip,
>
> Its working fine as I was looking.
> Kindly let me know how you have done it as the process you have described
> in the attachment, I am doing the same but not able to apply the required
> format on required row as its applying on the selected cell only.
>
>
>
> Unfeigned Regards
> Manoj S Negi
> Skype - manojsnegi
>
>
>  -- Forwarded message --
> From: Dilip Pandey 
> Date: Wed, Jan 13, 2010 at 3:08 PM
> Subject: Re: $$Excel-Macros$$ Help required in conditional formatting
> To: excel-macros@googlegroups.com
>  Cc: manojsnegi.uttranc...@gmail.com
>
>
> Hi Manoj,
>
> Solution is revised and on the next sheet tab, I have tried explaining
> about the conditional formatting logics which I had used.  Hope that will
> help you understand the solution.
>
> Let me know in case you still have some queries.
>
> Best Regards,
> --
> DILIP KUMAR PANDEY
>   MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
>
>
>   On Tue, Jan 12, 2010 at 8:46 PM, Manoj S Negi <
> manojsnegi.uttranc...@gmail.com> wrote:
>
>>
>> Adding in the same mail in bold letters
>>
>>
>> Hi Dilip,
>>
>> Thanks for your efforts but please tell me how it works as I want whenever
>> the entire column* D* will have the value *(In process or in progress)*than 
>> color of specified row (e.g.cell A2 to I2) should change as per the
>> specified color(e.g. Yellow or Red).
>>
>> *And the file you have sent me, In that file said formatting is working
>> for those two rows only not for others.*
>>
>>
>>
>> *Unfeigned Regards
>> Manoj S Negi
>> Skype - manojsnegi
>> *
>>
>>-- Forwarded message --
>> From: Dilip Pandey 
>> Date: Tue, Jan 12, 2010 at 8:13 PM
>> Subject: Re: $$Excel-Macros$$ Help required in conditional formatting
>> To: excel-macros@googlegroups.com
>>
>>
>> Dear Manoj,
>>
>> Attached file (Excel 2003) version has been solved per your requiremtn and
>> re-attached.
>>
>> Best Regards,
>> --
>> DILIP KUMAR PANDEY
>>   MBA-HR,B COM(Hons.),BCA
>> Mobile: +91 9810929744
>> dilipan...@gmail.com
>> dilipan...@yahoo.com
>> New Delhi - 110062
>>
>>
>>   On Tue, Jan 12, 2010 at 5:13 PM, Manoj S Negi <
>> manojsnegi.uttranc...@gmail.com> wrote:
>>
>>>  Hi All,
>>>
>>> Refer to the mail subject kindly help me in conditional formatting as per
>>> below mentioned condition...
>>> *
>>> "How to change the format of a particular row's format based on an
>>> particular cell's value".*
>>>
>>> Files are also attached for further reference.
>>> Right now I am using Excel 2007 therefore I have attached two version
>>> file. (Excel 2003 & Excel 2007)
>>>
>>>
>>>
>>> *Unfeigned Regards
>>> Manoj S Negi
>>> Skype - manojsnegi*
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us in TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>>> http://www.excelitems.com
>>> 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
>>> If you find any spam message in the group, please send an email to:
>>> Ayush Jain  @ jainayus...@gmail.com
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> HELP US GROW !!
>>>
>>> We reach over 6,500 subscribers worldwide and receive many nice notes
>>> about the learning and support from the group.Let friends and co-workers
>>> know they can subscribe to group at
>>> http://groups.google.com/group/excel-macros/subscribe
>>>
>>>
>>
>>
>> --

Re: $$Excel-Macros$$ Kindly help!! Sumif vba needed.

2010-01-15 Thread ankur
hi ashish

good work

Have A Nice Time & Enjoy Life

Regards:
CMA Ankur Pandey
(Someone Different)

I'm not the best but i'm not like the rest~~



On Thu, Jan 14, 2010 at 6:52 PM, kvc praveen kumar  wrote:
> Thanks Vinod.. Glad that it was helpful!!
>
> On Thu, Jan 14, 2010 at 5:51 PM, vinod rao  wrote:
>>
>> Hello Praveen,
>>
>> Excellent!!! this was really great.
>> With Regards,
>> Vin
>> On Thu, Jan 14, 2010 at 4:49 PM, kvc praveen kumar 
>> wrote:
>>>
>>> Hello Vinod,
>>>
>>> PFA the soln to fill your column c using VBA. Please let me know in case
>>> you have any queries.
>>>
>>> Regards,
>>> Praveen
>>>
>>> On Thu, Jan 14, 2010 at 1:34 PM, vinod rao  wrote:

 Hello Friends,
 Can i get a help for said query?. Thanks in advance.

 On Wed, Jan 13, 2010 at 3:13 PM, vinod rao 
 wrote:
>
> Hello Friends,
> Can i get a help for said query?. Thanks in advance.
>
> On Wed, Jan 13, 2010 at 1:18 PM, vinod rao 
> wrote:
>>
>> Hi Ankur,
>>
>> This dont work because i have 25 thousands of lines items one below
>> another and it takes long time to refresh page.
>> So better have vba programmed for getting result.
>>
>> Plz help.
>> Thanks for your quick reply.
>> Regards,
>> On Wed, Jan 13, 2010 at 11:22 AM, ankur 
>> wrote:
>>>
>>> hi Vinod
>>>
>>> I try to Slove the your Query Without The help of VBA
>>>
>>> Please Check the Attached  File ,  male me for any other clarifcation
>>>
>>> thanks
>>>
>>> On 1/12/10, vinod rao  wrote:
>>> > HI Team,
>>> >
>>> >
>>> >
>>> > I want a vba for Sum if and finding duplicate values. Plz find
>>> > attached with
>>> > highlighted columns/rows.
>>> >
>>> >
>>> >
>>> > Is this possible?
>>> >
>>> > Regards,
>>> >
>>> > Vin
>>> >
>>>
>>>
>>> --
>>> Have A Nice Time & Enjoy Life
>>>
>>> Regards:
>>> CMA Ankur Pandey
>>> (Someone Different)
>>>
>>> I'm not the best but i'm not like the rest~~
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us in TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>>> http://www.excelitems.com
>>> 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
>>> If you find any spam message in the group, please send an email to:
>>> Ayush Jain  @ jainayus...@gmail.com
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> HELP US GROW !!
>>>
>>> We reach over 6,500 subscribers worldwide and receive many nice notes
>>> about the learning and support from the group.Let friends and co-workers
>>> know they can subscribe to group at
>>> http://groups.google.com/group/excel-macros/subscribe
>>>
>>
>


 --

 --
 Some important links for excel users:
 1. Follow us in TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
 http://www.excelitems.com
 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
 If you find any spam message in the group, please send an email to:
 Ayush Jain  @ jainayus...@gmail.com
 <><><><><><><><><><><><><><><><><><><><><><>
 HELP US GROW !!

 We reach over 6,500 subscribers worldwide and receive many nice notes
 about the learning and support from the group.Let friends and co-workers
 know they can subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe

>>>
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us in TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>>> http://www.excelitems.com
>>> 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
>>> If you find any spam message in the group, please send

$$Excel-Macros$$ Help required

2010-01-15 Thread Abhijit Vipat
Dear Friends,
 
I want to draw line chart for the attached data. The data is for Apr 2008 to 
March 2009.
 
Pls provide the help.

 
Regards, 
 
Abhijit Vipat
9004318922


  -- 
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Chart of Yield.xls
Description: Binary data


$$Excel-Macros$$ VBA to get Cursor Position automatically

2010-01-15 Thread prabhat.shrivasta...@gmail.com
Plaese help me to get the marco to get cursor position automatically
in defined cells.
-- 
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


$$Excel-Macros$$ looping by timeing

2010-01-15 Thread memonkavi
sir
how can stop  a loop by time in excel vb code
-- 
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Re: $$Excel-Macros$$ Help required

2010-01-15 Thread Dilip Pandey
Dear Abhi,

Your source data is not aligned properly.  For working with charts, you need
to have data in structured manner.  See if you can work with source data and
remove extra rows/columns in between.

Best Regards,
-- 
DILIP KUMAR PANDEY
  MBA-HR,B COM(Hons.),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 110062


On Fri, Jan 15, 2010 at 1:38 PM, Abhijit Vipat  wrote:

>   Dear Friends,
>
> I want to draw line chart for the attached data. The data is for Apr 2008
> to March 2009.
>
> Pls provide the help.
>
>
> *Regards,*
>
> *Abhijit Vipat*
> *9004318922*
>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us in TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 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
> If you find any spam message in the group, please send an email to:
> Ayush Jain  @ jainayus...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
>
-- 
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


$$Excel-Macros$$ Urgent: Consolidate CSV and have a Unique Identifier

2010-01-15 Thread Amitabh Bose

Hi All,

 

I would be grateful if you guide me to how I could consolidate .csv files and 
be able to separate or distinguish between the rows by the different files 
being consolidated.

 

Eg. .csv File 1:

 

Column A

1

1

1

 

.csv File 2:

Column A

2

2

2

 

Consolidated .csv

1   File1

1   File1

1   File1

2   File2

2   File2

2   File2

 

Your help would be appreciated.

 

Thanks,

 

Amitabh

 
  
_
Do you have a story that started on Hotmail? Tell us now
http://clk.atdmt.com/UKM/go/195013117/direct/01/-- 
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


$$Excel-Macros$$ how to use fillcolor for an condition

2010-01-15 Thread Ashok Renga
when a>100 ,i need fill the box with green color


similarly when a<100,i need to fill the box with red colour



can anyhelp on thisss



thanks
ashok
-- 
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Re: $$Excel-Macros$$ how to use fillcolor for an condition

2010-01-15 Thread Harmeet Singh
Attached file would help...

Thanks & Regards,

Harmeet Singh

Sent via BlackBerry Wireless


On Fri, Jan 15, 2010 at 3:06 PM, Ashok Renga wrote:

>
>
>
> when a>100 ,i need fill the box with green color
>
>
> similarly when a<100,i need to fill the box with red colour
>
>
>
> can anyhelp on thisss
>
>
>
> thanks
> ashok
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us in TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 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
> If you find any spam message in the group, please send an email to:
> Ayush Jain  @ jainayus...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
>
-- 
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


eg.xls
Description: MS-Excel spreadsheet


$$Excel-Macros$$ HELP needed for macro

2010-01-15 Thread aju chacko
HI VBA GURUS,
  I know excel pretty well,But my knowledge in VBA
is big zero.I have two excel work sheets (SAP & PHY),both are arranged as
table & *one common field (MATERIAL)  *available in both sheets ,what I
required* is a macro* that brings *quantity* from w.sheet PHY
against *unrestricted* in w.sheet SAP for the same *material*.Similarly if a
MATERIAL is not available in w.sheet *SAP*,but in w.sheet *PHY* that also
should come in consolidated worksheet.The difference of these two fields ( *
unrestricted-**quantity) *should appear in field DIFF.Please see the
attached file which shows the example.KINDLY HELP,Now I am doing this
manually with vlookup function.

AJU V CHACKO
-- 
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


SAP.XLS
Description: MS-Excel spreadsheet


$$Excel-Macros$$ Help with Hyperion Addin!!!!

2010-01-15 Thread Harpreet Singh Gujral
Hi,

I have a Hyperion Addin installed in my system, To give a background
about the system. Hyperion is a financial management software. Its Add-
in helps the users to retrieve data of particular accounts on the
excelsheet according to parameters set.

Problem:

The Add-in is like a menu on the Tollbar, just similar to the file
menu we have. There is a refresh button on this toolbar, which
refreshes the worsheet[According to the parameters pre-set on the
sheet].

I have designed a loop which changes the parameters on the worksheet,
once the loop is complete. And Sendkeys method has been used to
refresh the sheet to view the data. The actual problem lies here. The
refresh button takes some time to pull the data on the sheet. Can we
have something to pause the loop for a while, and to resume the loop
once the data has completly downloaded?

I have used the Wait method, but that doesnt work!

The code is as follows:


Sub TotalSolutionFullsheet()


Dim Entity As Range
Dim CountNo As Variant

Dim RngEntNo As Range

Set RngEntNo = Range("rngEntityNo")


For Each CountNo In RngEntNo

'This line helps to input the new parameter
Range("RngTargetCell").Value = CountNo


Call testrefresh

ActiveWindow.SelectedSheets.PrintOut Collate _
:=True

Next

End Sub

Sub testrefresh()

Application.SendKeys "%yr", True

End Sub



If i input the parameters manually, i can successfully run the
testrefresh macro, it helps me retrieve the data. But if i run the
loop, it will not let the macro to hold down till the time data gets
downloaded in the cells.

Please advice

Thanks

Harpreet Gujral
-- 
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe


Re: $$Excel-Macros$$ how to use fillcolor for an condition

2010-01-15 Thread manan joshi
its quite simple use the conditional format.

On Fri, Jan 15, 2010 at 10:29 PM, Harmeet Singh wrote:

> Attached file would help...
>
> Thanks & Regards,
>
> Harmeet Singh
>
> Sent via BlackBerry Wireless
>
>
> On Fri, Jan 15, 2010 at 3:06 PM, Ashok Renga wrote:
>
>>
>>
>>
>> when a>100 ,i need fill the box with green color
>>
>>
>> similarly when a<100,i need to fill the box with red colour
>>
>>
>>
>> can anyhelp on thisss
>>
>>
>>
>> thanks
>> ashok
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us in TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> http://www.excelitems.com
>> 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
>> If you find any spam message in the group, please send an email to:
>> Ayush Jain  @ jainayus...@gmail.com
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,500 subscribers worldwide and receive many nice notes
>> about the learning and support from the group.Let friends and co-workers
>> know they can subscribe to group at
>> http://groups.google.com/group/excel-macros/subscribe
>>
>>
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us in TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 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
> If you find any spam message in the group, please send an email to:
> Ayush Jain  @ jainayus...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 subscribers worldwide and receive many nice notes about
> the learning and support from the group.Let friends and co-workers know they
> can subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
>
-- 
--
Some important links for excel users:
1. Follow us in TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
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
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group.Let friends and co-workers know they can 
subscribe to group at http://groups.google.com/group/excel-macros/subscribe