$$Excel-Macros$$ Fwd: Immediate Joinee required for VBA,EXCELand MACROS in Gurgaon Location

[Deepak Rai]

-- Forwarded message --
From: ysofia 
Date: Tue, Nov 27, 2012 at 2:41 PM
Subject: Immediate Joinee required for VBA,EXCELand MACROS in Gurgaon
Location
To: daksh1...@gmail.com


*Dear Candidate,*

This is *Sofia* from *Magna InfoTech*.

We have an urgent requirement for* VBA, Macros, and Excel *

* *

*You* will be a *Permanent Employee* for *Magna InfoTech* & will be
deployed at *our client, **Gurgaon*

* *

*Skill: VBA, Macros, and Excel*

*Experience: min 2+yrs*

*Work Location: **Gurgaon*


If you are interested send across your updated CV along with following
details:

1. Updated CV:
2. Total Exp:
3. Relevant Exp:
4. Current CTC:
5. Expected CTC:
6. Notice period:
7. DOB:
8. Contact No:
9. Alternative No:
10.Location:

** **


I would appreciate if you could refer few of your friends, who are looking
out for a change,



Please ignore the mail if you are not interested in this opening.

*About Magna Infotech *

Magna InfoTech is a premier provider of IT services to clients worldwide.
An associate company of asset based $1 billion Nagarjuna group of companies.
*Magna Infotech is an ISO 9001:2000 certified company that offers unique
solution to build, integrate and* manage IT systems across a broad spectrum
of industry by using a combination of on-site, off-shore methodology.
*It has offices in USA (Danbury, CT) and India including its own state of
the art development center in Hyderabad.*
We follow onsite-offshore methodology and provide services to end-clients
like Toshiba, Saint Gobain, Pitney Bowels, Lucent Technologies and Wipro
Technologies.
We are strategically positioned to cater the requirements of various
clients in IT domain. 

We are the primary SSP (Software Service Provider) to our clients like IBM,
HP, Accenture, and iFlex, CSC, Patni and Oracle Corp.

*More than 4813+ employees are working under the payrolls of Magna
Infotech. *

*Presently associated with 165 active clients.
*

For client testimonials please visit www.magna.in

*Thanks & Regards
Sofia Yasmeen |IT staffing| Magna Infotech Pvt Ltd| Tel: (040)
39179113|09346062227 **yso...@magna.in* *
**www.magna.in*<http://www.magna.in/>
*|*

** **



-- 
*Deepak Rai*
SAS BASE CERTIFIED Programmer
Mobile: 9873415255

-- 
Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To post to this group, send email to excel-macros@googlegroups.com.
To unsubscribe from this group, send email to 
excel-macros+unsubscr...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros?hl=en.

Re: $$Excel-Macros$$ Problem regarding sum

[Deepak Rai]

Hi Santanu,

Please find the solved file. Hope this is what you are looking for. :)

Regards,
Deepak Rai

On Fri, Dec 17, 2010 at 1:42 AM, Rahul Kamal Gandhi
wrote:

> Sir,
>
> As per my interpretation your output is in Attached file.
>
>
> Regards, Rahul Gandhi
> +91-9711772297
>
>
>
>  On Thu, Dec 16, 2010 at 11:06 PM, santanu_ca wrote:
>
>> I want to Add two digit or multiply as this way.
>>
>> Column A   Column B
>>  Rs. 5.00Rs. 10.00  =   Can I sum two cells by formula ?
>>  Rs. 5.00Rs. 10.00  =   Can I multiply Two Cells by
>> formula ?
>>
>>
>> --
>>
>> --
>> 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
>



-- 
Regards,
Deepak Rai

-- 
--
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


Santanu_CA - Sum & Multiply - Solved (Deepak Rai).xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Need ans for 3 que

[Deepak Rai]

Hi Rohan,

This is really nice.

Regards,
Deepak Rai

On Fri, Dec 17, 2010 at 9:49 AM, Rohan Young  wrote:

> Hi Hanumant,
>
> Just hit Ctrl+F go to option and in look in set the criteria on Values u
> will get that
>
> bye for now
>
> Deepak (ROHAN)
> 9818247278
>
>
> On Thu, Dec 16, 2010 at 3:45 PM, hanumant shinde 
> wrote:
>
>> hey guys,
>>
>> need some help here.
>>
>> 1. how can i get to know if a specific cell has formula or normal value?
>>
>> 2. can we unzip folder or file using excel maco?
>>
>> 3. if a specific cell has formula whose value is lets say "shinde" how can
>> i
>> find it.
>>
>> i.e lets say A1 has value as "shinde"(its not fomula its normal string)
>> B1=A1 (its a formula)
>> now i want to find shinde in col B but its formula so i cant find it even
>> by
>> Ctrl + F
>> so what shud b the code to find "shinde" in col B.
>>
>> thanks
>> hanumant
>>
>>
>>
>> --
>>
>> --
>> 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
>



-- 
Regards,
Deepak Rai

-- 
--
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$$ Rectify this Error

[Deepak Rai]

Hi,

You can also use name range for "*Source Data*" Parameter. I usually prefer
to use this in my reporting if all my input and output data are in same
workbook.

Regards,
Deepak Rai

On Sat, Dec 18, 2010 at 1:35 AM, Daniel  wrote:

>  Hi,
>
> Change the pivottable name eg. PivotTable2.
>
> Regards.
>
> Daniel
>
>
>
> *De :* excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
> *De la part de* vebhav jain
> *Envoyé :* mardi 14 décembre 2010 13:34
> *À :* excel-macros@googlegroups.com
> *Objet :* $$Excel-Macros$$ Rectify this Error
>
>
>
> Hi All,
>
>
>
>
>
> I have recorded the below coding, when i try to ran this macro and it is
> showing error. The data keep varies on and please help me to rectify the
> error.
>
>
>
>
>
> ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
> "GCF Directors rpt!R1C1:R6090C7", Version:=xlPivotTableVersion10).
> _
> CreatePivotTable TableDestination:="Sheet1!R3C1",
> TableName:="PivotTable1" _
> , DefaultVersion:=xlPivotTableVersion10
>
>
>
> Thanks,
>
> 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
>



-- 
Regards,
Deepak Rai

-- 
--
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$$ cumulative sum in pivot table

[Deepak Rai]

Hi Alisha,

It would be really helpful if you can share a dump file.

Regards,
Deepak Rai

On Tue, Dec 7, 2010 at 4:06 PM, alisha malhotra  wrote:

> Hi Group,
>
> I have one pivot table. In that  I want to show the cumulative sum.
> e.g.
> Qtr1 sale:- 10 units
> Qtr2 sale:- 20 units
> Qtr3 sale:- 10 units
> Qtr4 sale:- 30 units
> now i want to show the sale of qtr1 and qtr2 i.e. 30 units after  qtr2 and
> similarly after qtr3 cumulative sum of qtr1,2 and 3 i.e. 40 units  and so
> on.
>
> How can I do this? Can anyone help me please?
>
> Thanks & Regards,
> Alisha malhotra
>
> --
>
> --
> 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,
Deepak Rai

-- 
--
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$$ Need help on dynamic list

[Deepak Rai]

Hi,

 Please find the attached solution. In sheet one I have two validation
lists, which is taking data from Sheet2. Sheet2 has named ranges.
 Hope this will help you. With the help of Named Range and Indirect formula
you can do this very easily.

Regards,
Deepak Rai

On Wed, Dec 8, 2010 at 7:33 PM, sharath sambrani <
sharath.c.sambr...@gmail.com> wrote:

> Hi,
>
> I have two columns A and B.
>
> column A contains list of tasks and column B contains sub-tasks
> against each primary task.
>
> i would like to have two drop down cells in column C and D.
>
> whenever i select an option in the dropdown in cell C1, the list in D1
> should show only the sub-tasks that belong to the respective primary
> task.
>
> eg: in the attached spreadsheet, if i select "Admin / Reporting" in
> the list, in the other cell only the following sub-tasks should
> reflect:
>
> follow-up and reminder mails for Onhold/Offline/PCR records
> Metrics reports (for SKAs and above)
> Workplan preparation (for SKAs and above)
> Logistics for training (for Training SKA)
> Updating time entry reports
> Updating project tracker (for SKAs and above)
> Monitoring Service Desk (for SKAs and above)
> query resolution time b/w QA and KA
> query resolution time b/w KA and SKA
> Monitoring quals mailbox
> Updating KL tracker (for docs KL team)
>
> i hope this request is clear.
>
> let me know if you have any questions.
>
> your help is much appreciated.
>
> sharath
>
> --
>
> --
> 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,
Deepak Rai

-- 
--
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


Indirect Formula Explaination.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ How to make Macro Faster Pls Suggest...

[Deepak Rai]

Hi Girish,

I was just going through your attached VBA code. I have observed that in
many places your VBA code is using excel formulas. As per my experience the
more you will use excel formula in your spreadsheet it will slow the
performance of your spreadsheet. You can turn the automatic calculation
feature off by the following code :

Private Sub Workbook_Open()
Application.Calculation = xlCalculationManual
End Sub

Hope this will help you.

Regards,
Deepak Rai



On Thu, Nov 25, 2010 at 6:45 PM, girish kumar
wrote:

> Dear Experts,
>
> I have attached one VBA Code which we are using regularly
> for huge data it is running very slow
>
> is there any way to make it faster
>
> Pls Suggest
>
> Thanks in advance
>
> Girish
>
>
> --
> Warm Regards,
>
> *Girish Sherigar*
>
> *(¨`·.·´¨) *
> *`·.¸(¨`·.·´¨)* *Keep*
> *(¨`·.·´¨)¸.·´ Smiling!*
> *`·.¸.·´*
>
> --
>
> --
> 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,
Deepak Rai

-- 
--
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$$ sum duplicate value

[Deepak Rai]

Hi,

I will also suggest to use sumif function for this purpose.

Regards,
Deepak Rai

On Sun, Nov 14, 2010 at 2:51 PM, ratu elissa wrote:

> use SUMIF Formula
>
>
> On Sun, Nov 14, 2010 at 2:25 PM, bhavya khanna wrote:
>
>> Hi Everyone.
>>
>> Can someone explain I have data in sheet 1 The columns Name and Production
>> .  Now I want to fetch data in sheet 2  . I use vlookup on the basis of Name
>> and fetch the production . But I have a problem. In the Name Columns There
>> is Duplicate of A but production is different. So Can you tell me please how
>> can we sum that value. Please find the attache sheet.
>>
>> --
>>
>> --
>> 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
>



-- 
Regards,
Deepak Rai

-- 
--
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$$ Problem with Identify WorkSheet

[Deepak Rai]

Hi Krupesh,

I have written below code for you. Its working fine, you can customize it as
per your need. Hope this will help you.

Sub Find_Sheet()
Dim sh As Worksheet
Dim sTemp As String
sTemp = InputBox("Please enter the sheet name to find:")
For Each sh In ActiveWorkbook.Sheets
If sh.Name = sTemp Then
MsgBox "Sheet already exist"
MsgBox sh.Name
Exit Sub
End If

Next sh
MsgBox "Sheet doesn't exist"
ActiveWorkbook.Sheets.Add
ActiveSheet.Name = sTemp
End Sub

Regards,
Deepak Rai

On Sun, Nov 14, 2010 at 2:17 PM, Krupesh Bhansali  wrote:

> Hi Friends
>  I have written following Macro to Add worksheet if it is not Exists in the
> work book , but it is not working as it is not recognized Sheet is exits and
> it always add one more work sheet.
>
> Please help
>
> Regards
> krupesh
>
>
> Option Explicit
> Private Function SheetExist(Sname As String, Optional Wbname As String) As
> Boolean
> Dim WS As Worksheet
> Dim Wb As Workbook
> On Error Resume Next
> If Len(Wbname) > 0 Then
> Set Wb = Workbooks(Wbname)
> If Wb Is Nothing Then Exit Function ' Exit if workbook is not open
> Else
> Set Wb = ActiveWorkbook
> End If
> Set WS = Wb.Sheet(Sname)
> SheetExist = Not (WS Is Nothing)
> End Function
>
> Sub Checkforsheet()
> ShtExists = SheetExist("Sheet1")  'Calling Function from the above
> If ShtExists Then
> MsgBox " Worksheetis there"
> Else
>   ActiveWorkbook.Sheets.Add
> End If
> End Sub
>
> --
>
> --
> 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,
Deepak Rai

-- 
--
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$$ how to know the content of a text box of user form

[Deepak Rai]

Hi Hiren,

Suppose I have a veriable called Fname now I have to get this
variable's value from a Texbox in a user control. Lets take this Text Box
name as Textbox1 now I will use
Fname = Textbox1.value to populate my Fname variable with the value present
in the Text Box. Textbox1.value is the answer of your question. :)
Hope this example will help you.

Regards,
Deepak

On Thu, Nov 11, 2010 at 8:52 PM, Hiren Sheth  wrote:

>  Hi,
>
>
>
> Please let me know how to obtain the content of a text box of user form?
>
>
>
> Thanks
>
> Hiren
> This message is for the named person's use only. It may contain
> confidential, proprietary or legally privileged information. No
> confidentiality or privilege is waived or lost by any mis-transmission. If
> you receive this message in error, please immediately
> delete it and all copies of it from your system, destroy any hard copies of
> it and notify the sender. You must not, directly or
> indirectly, use, disclose, distribute, print, or copy any part of this
> message if you are not the intended recipient.
> Viteos Capital Market Services Ltd.and any of its subsidiaries each reserve
> the right to monitor all e-mail communications through
> its networks. Any views expressed in this message are those of the
> individual sender, except where the message states otherwise and
> the sender is authorized to state them to be the views of any such entity
>
> --
>
> --
> 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,
Deepak Rai

-- 
--
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$$ Importing data into excel

[Deepak Rai]

Hi Peter,

Sure soon I will send you that consolidation macro.

Regards,
Deepak Rai

On Mon, Oct 4, 2010 at 11:08 PM, Peter Konijn  wrote:

> Hi,
>
> It works, thanks a lot for your support.
>
> I am still curious for the macro of Deepak Rai.
>
>
>
> Regards Peter
>
> 2010/10/3 P.VIJAYKUMAR 
>
> Dear Peter,
>>
>> You can Import Data From Data Menu.In DATA Menu Go to Get External Data,
>> then select Existing Connections,then you will get a dialog box,in that
>> select browse for more then select the file you need to import, then press
>> ok. Then you will get a query about what sheets of the workbook you need to
>> import and where you need to import .Once you specify your requirements you
>> can have your data imported according to your needs.I am Attaching the file
>> in which i have impoterd the data of Data One sheet to Import_and_Calc.xlsx.
>>
>>
>>
>>
>>
>>
>> Regards,
>> VijayKumar
>>
>>
>> --
>>
>> --
>> 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
>



-- 
Regards,
Deepak Rai

-- 
--
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$$ Ayush Jain – Microsoft MVP 20 10

[Deepak Rai]

Hi Ayush,

Congratulations buddy... Keep up the good work. :)

Regards,
Deepak Rai

On Sun, Oct 3, 2010 at 3:47 PM, Ayush  wrote:

> Dear Group,
>
> I am proud to announce that I am awarded Microsoft Most Valuable
> Professional MVP on October 01, 2010 for providing technical expertise
> in Excel technical communities for past one year.
>
>
> http://blogs.technet.com/b/southasiamvp/archive/2010/10/01/new-mvps-announced-october-2010.aspx
>
> This is a prestigious award from Microsoft given every Quarter to the
> people who share their deep knowledge, real-world experience, and
> impartial, objective feedback to help people enhance the way they use
> technology.
>
> My deep thanks to each group member for all your support and
> contribution to this group.
>
> Best regards,
> Ayush Jain
> Microsoft MVP
>
> --
>
> --
> 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,
Deepak Rai

-- 
--
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$$ Importing data into excel

[Deepak Rai]

Peter,

I have this macro I will customize it as per your need & will soon share the
same with you.

Regards,
Deepak Rai

On Fri, Oct 1, 2010 at 11:35 PM, Deepak Rai  wrote:

> Hi Peter,
>
> For this you need to have a common folder where you can store all your Data
> files after that through VBA macro you can consolidate all those N numbers
> of Data files into a consolidated excel file. You would not able to do this
> by manual approach.
>
> Regards,
> Deepak Rai
>
>   On Fri, Oct 1, 2010 at 5:57 PM, Peter Konijn wrote:
>
>> Dear Vijay,
>>
>> In the DATA menu of Excel I have options for Web, Text, Acess, and other
>> source, I do not have a button for excel-files.
>>
>> I already tried several option in the menupath but I couldn't let it work
>> .
>> In the attachment an example. In practice there are several 100's of
>> datafiles. The problem I have is that the real file "Import_and_Calc" is
>> under construction and is changed frequently. For that reason I want to have
>> separate Data-files and one file "Import and Calculate" were I can do
>> calculations,which depend on the data in the datafiles.
>>
>>
>> Kind regards
>>
>> Peter
>>
>> 2010/10/1 P.VIJAYKUMAR 
>>
>> Hi,
>>>
>>> You Can import Data from Web ,Other Excel sheets ,Text, etc by using  Get
>>> External Data in The DATA MENU of Excel.
>>>
>>>
>>> Regards,
>>> Vijay Kumar
>>>
>>>
>>>
>>> --
>>>
>>> --
>>> 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
>>
>
>
>
> --
> Regards,
> Deepak Rai
>
>


-- 
Regards,
Deepak Rai

-- 
--
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$$ Importing data into excel

[Deepak Rai]

Hi Peter,

For this you need to have a common folder where you can store all your Data
files after that through VBA macro you can consolidate all those N numbers
of Data files into a consolidated excel file. You would not able to do this
by manual approach.

Regards,
Deepak Rai

On Fri, Oct 1, 2010 at 5:57 PM, Peter Konijn  wrote:

> Dear Vijay,
>
> In the DATA menu of Excel I have options for Web, Text, Acess, and other
> source, I do not have a button for excel-files.
>
> I already tried several option in the menupath but I couldn't let it work
> .
> In the attachment an example. In practice there are several 100's of
> datafiles. The problem I have is that the real file "Import_and_Calc" is
> under construction and is changed frequently. For that reason I want to have
> separate Data-files and one file "Import and Calculate" were I can do
> calculations,which depend on the data in the datafiles.
>
>
> Kind regards
>
> Peter
>
> 2010/10/1 P.VIJAYKUMAR 
>
> Hi,
>>
>> You Can import Data from Web ,Other Excel sheets ,Text, etc by using  Get
>> External Data in The DATA MENU of Excel.
>>
>>
>> Regards,
>> Vijay Kumar
>>
>>
>>
>> --
>>
>> --
>> 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
>



-- 
Regards,
Deepak Rai

-- 
--
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$$ Urgent Querry

[Deepak Rai]

Hi Pankaj,

In your case the attached formula can also help.

Regards,
Deepak Rai

On Thu, Sep 30, 2010 at 8:58 PM, Venkat  wrote:

> Dear Pankaj,
>
> Look attached resolved formula
>
> Best Regards,
>
> Venkat
>   On Thu, Sep 30, 2010 at 6:28 PM, Pankaj Kumar 
> wrote:
>
>>
>> Hi, All Experts,
>>
>> Its Urgent
>> -- I need u r help i have two column in excelsheet Data1 & Data 2 we have
>> to match both data if its Match show "Match" or not Match shows "Mismatch"
>> in next coloum,,,Pls provide me formulas
>>
>> I have attached my excelsheet
>>  *Warm Regards
>> Pankaj kumar
>> M: 9899816107
>> e-mail: rajputpanka...@gmail.com
>>rajputpank...@yahoo.in*
>> *   rajputpankaj1...@rediffmail.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
>>
>
> --
>
> --
> 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,
Deepak Rai

-- 
--
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


Solved by Deepak.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$

[Deepak Rai]

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
>>>
>>
>>
>>
>> --
>>
>> Ramkesh
>> 9990260398
>>
>> --
>>
>> --
>> 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
>>
>
>
>
> --
>
> Ramkesh
> 9990260398
>
> --
>
> --
> 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
>



-- 
Regards,
Deepak Rai

-- 
--
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$$ Need help list box

[Deepak Rai]

Hi,

You can use Data Validation for this. Search Google or Excel Help you will
get to know about this.

Regards,
Deepak

On Sun, Sep 26, 2010 at 8:49 PM, Idhrees Mohamed wrote:

>  Dear Team,
>
> I need help with attached file. In this one column "Relay type", we select
> any one item (need list box), its display all the corresponding details with
> the title.
> Thanks in Advance.
> --
> Regards,
>
> Mohamed Idhrees. S.
>
> --
>
> --
> 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,
Deepak Rai

-- 
--
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$$ Time calculation

[Deepak Rai]

Hi,

Yes =TEXT((C3-B3);"[h]:mm")  format is working. Find the attached.

Regards,
Daksh

On Sat, Sep 25, 2010 at 8:22 PM, عمر  wrote:

>  Use this
>
> =TEXT((C3-B3);"[h]:mm")
>
> It is working
>
>
>
> *From:* excel-macros@googlegroups.com [mailto:
> excel-mac...@googlegroups.com] *On Behalf Of *Pankaj Kumar
> *Sent:* Saturday, September 25, 2010 4:33 PM
> *To:* excel-macros
> *Subject:* $$Excel-Macros$$ Time calculation
>
>
>
> Hi, Experts
>
>
>
> I have a problem my worksheet is attched , i have to calculated total
> working hrs, pls help me
>
> --
>
> *Warm Regards**
> Pankaj kumar
> M: 9899816107
> e-mail: rajputpanka...@gmail.com
>rajputpank...@yahoo.in*
>
> *   rajputpankaj1...@rediffmail.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
>
> --
>
> --
> 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,
Deepak Rai

-- 
--
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


working-hours-between-2-dates-data(1)(1).xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ How can me make dynamic range in vba

[Deepak Rai]

Hi Neil,

You can use name range for this, for example Range("Test1").select here
Test1 is a name range. Hope this will help you.

Regards,
Deepak

On Sat, Sep 11, 2010 at 2:13 PM, neil johnson wrote:

> Hi Everyone,
>
> How can we make dynamic range in excel vba. Please explain it . How can we
> fetch date in *user form by using dynamic rage in excel* *in vba coding *.
> Please solve this problem .
>
>
> Thanks and Regards
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 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 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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 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$$ Date series

[Deepak Rai]

Hi All,


Really nice logics. Keep the good work.

Regards,
Deepak

2010/9/6 सुधीर इंगळे 

>  Dear Kalyan
> Kindly check the attach file
> I think it solve your query
>
>  Regards,
> Sudhir Ingale
>
>
>  On Mon, Sep 6, 2010 at 8:47 AM, Kal xcel  wrote:
>
>> Dear experts,
>>
>> I am sending a file where I need to show a series of dates after giving
>> start date & end date.
>>
>> File is attached .
>>
>> Thanks in advance.
>>
>> Kalyan
>>
>> --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 7000 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 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 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 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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 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$$ Date series

[Deepak Rai]

Hi Kalyan,

Please find the attached solved file. Hope this will help.

Regards,
Deepak
On Mon, Sep 6, 2010 at 1:17 PM, Kal xcel  wrote:

> Dear experts,
>
> I am sending a file where I need to show a series of dates after giving
> start date & end date.
>
> File is attached .
>
> Thanks in advance.
>
> Kalyan
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 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 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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 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


Series of Date(1) (Solved by Deepak).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Conditional Formating

[Deepak Rai]

Hi Pankaj,

On internet you can find lots of learning stuffs on conditional formatting
with good examples. On you tube as well there are some good video's on
conditional formatting. Hope this will help.

Regards,
Deepak

On Mon, Sep 6, 2010 at 12:43 PM, C.G.Kumar wrote:

> Follow the link;
>
>
> 1.http://www.homeandlearn.co.uk/excel2007/excel2007s6p2.html
>  2.
> http://www.free-training-tutorial.com/conditional-formatting.html
>
>
>
>
>
> On Mon, Sep 6, 2010 at 8:36 AM, Pankaj Kumar wrote:
>
>>  Hi all,
>>
>> i am new in msexcel wanted to learned use of conditional formating,
>> cananyone helped me to learned conditional formatting ,,,for a brief example
>>
>> --
>>  *Warm Regards
>> Pankaj kumar
>> M: 9899816107
>> e-mail: rajputpanka...@gmail.com
>>rajputpank...@yahoo.in*
>> *   rajputpankaj1...@rediffmail.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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 7000 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 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 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 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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 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$$ Urgent help....

[Deepak Rai]

Hi Ankit,

Please find the attached solved file. Column highlighted with yello color
has the solution as requested.

Thanks,
Deepak

On Mon, Jul 5, 2010 at 5:59 PM, Ankit Chandna wrote:

> Hi,
>
>
> hi to all ..i need a help PFA and help me to get reqired result.
>
> Regards,
> Ankit
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 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 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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 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


help..(1)_Solved by Deepak.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Open Excel File

[Deepak Rai]

Hi Jonas,

Can u share the code so that I can find the solution for you ?

Regards,

Deepak
daksh1...@gmail.com

On Tue, Jun 8, 2010 at 1:32 AM, Jonas  wrote:

> I have code that exports a query from Access to Excel.  At times I am
> unable to open the Excel file that I created.  When I double click on
> the file from Windows Explorer, the file flashes on the screen very
> quickly and goes away.  If I go to the task manager and end
> "Excel.exe," I will then be able to open the file.
>
> What am I doing incorrectly when I export the Excel file?
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 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 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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 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$$ Need help on CONCATENATE and SUM function

[Deepak Rai]

Hi,

You can modify your formula as =CONCATENATE("FY09-Q4",CHAR(10),"
(",TEXT(SUM(A2:A4),"0,000"),")") .

Regards,

Deepak

On Tue, Jun 8, 2010 at 8:31 PM, Sharath Sambrani <
sharath.c.sambr...@gmail.com> wrote:

> thanks Paul,
>
> it worked amazingly!
>
> :)
>
>   On Tue, Jun 8, 2010 at 8:19 PM, Paul Schreiner 
> wrote:
>
>>  the =Text() function diplays numbers in different formats.
>>
>> replace your Round() function with:
>>
>> text(round(sum(a2:a4),0),"#,###")
>>
>> =CONCATENATE("FY09-Q4",CHAR(10),"
>> (",TEXT(ROUND(SUM(A2:A4),0),"#,###"),")")
>>
>> curiously enough,
>> you SHOULD be able to use:
>>
>> ="FY09-Q4" & CHAR(10) & " (" & TEXT(ROUND(SUM(A2:A4),0),"#,###") & ")"
>>
>> but for some reason, it doesn't "evaluate" the char(10) properly...
>>
>> interesting...
>>
>> Paul
>>
>>  --
>> *From:* sharath sambrani 
>>
>> *To:* MS EXCEL AND VBA MACROS 
>> *Sent:* Tue, June 8, 2010 7:22:00 AM
>> *Subject:* $$Excel-Macros$$ Need help on CONCATENATE and SUM function
>>
>> Hi,
>>
>> i am trying to use sum function in concatenate function. i want to
>> concatenate 'text' + 'sum of a range' + 'text'
>>
>> i want to use this in a column heading, say cell A1.
>>
>> cells A2, A3 and A4 has number values.
>>
>> in cell i want to display as:
>>
>> FY09-Q4
>> (4,464)
>>
>> FY10 should be displayed in the first line and (4,464) which is the
>> sum of A2:A4. however when i use the following formula:
>> =CONCATENATE("FY09-Q4",CHAR(10)," (",ROUND(SUM(A2:A4),0),")")
>>
>> it displays as follows:
>>
>> FY09-Q4
>> (4464)
>>
>> i need the comma after 1000th digit to be displayed.
>>
>> does anyone have idea how to deal with this?
>>
>> thank you in advance.
>>
>> sharath
>>
>> --
>>
>> --
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 7000 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 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 7000 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 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 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 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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 subscribers worldwide and receive many nice notes

Re: $$Excel-Macros$$ trying to delete cells that match search criteria

[Deepak Rai]

Hi,

Give me a sample file I will solve this for you.

Regards,

Deepak

On Tue, Jun 8, 2010 at 8:35 PM, molinari  wrote:

> I have a list of reports to be printed out Monday - Friday, where each
> worksheet is Monday, Tuesday, Wednesday, Thursday, or Friday. I made
> another worksheet to list reports that we no longer need (by their
> report number). I want the macro to go through the worksheet and
> delete the rows that correspond to these reports, but I'm getting
> stuck at the find step: it keeps giving me this error about "Object or
> variable with block variable not set".
>
> How do I fix this? (then afterwards, how do I tell it to delete the
> rows where it found something, but not delete the row its on if it
> finds nothing?)
>
> Sub Macro5()
> '
> ' Macro5 Macro
> ' Macro recorded 6/8/2010 by David J. Heinrich
>
> Dim y As Byte
> Sheets("Reports Not Needed").Select
> y = xlLastRow   ' y = numbers of rows
>
> Dim ReportsNotNeeded() As Variant
> ReportsNotNeeded = Range(Cells(2, 2), Cells(y, 2)).Value
>
> Dim ws As Worksheet
> Dim x As Byte
>
> For Each ws In Worksheets
>Sheets(ws.Name).Select
>For x = 1 To y - 1
>
>Range("B3:B1391").Select
>Selection.Find( _
>What:=ReportsNotNeeded(x, 1), _
>After:=Range("B3"), _
>LookIn:=xlValues, _
>LookAt:=xlWhole, _
>SearchOrder:=xlByColumns, _
>SearchDirection:=xlNext, _
>MatchCase:=False, _
>SearchFormat:=False).Activate
>
>Next x
>
> Next ws
>
> End Sub
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 7000 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 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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 7000 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$$ Using an "if" formula in data validation

[Deepak Rai]

Hi,

Plz share a sample file.

Regards,

Deepak

On Sat, May 1, 2010 at 3:23 AM, LJWarren  wrote:

> I have 5 major categories defined, and depending on which category is
> chosen, up to 20 sub-categories. How do I embed an "if" statement into
> my data validation? Thank you.
>
> --
>
> --
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 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 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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 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$$ duplicating data

[Deepak Rai]

Hi,

You can use cell referencing for this. Please share a sample file for more
help on this.

Regards,

Deepak

On Thu, Apr 1, 2010 at 8:43 PM, Lynn  wrote:

> I have 2 excel worksheets, both are in different formats. Both will
> contain the same data but spread across different parts of the
> worksheets.
>
> if I have filled in the data for 1 worksheet, how can i automate this
> data to be filled into the other worksheet?
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 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
>
> To unsubscribe, reply using "remove me" as the subject.
>



-- 
Thanks,

Deepak Rai

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 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$$ "Excel 2007 Power Programming with VBA" by John Walkenbach.

[Deepak Rai]

Hi Vikash,

Want help you want on Access ?

Regards,

Deepak

On Sat, Mar 27, 2010 at 10:38 AM, Vikas Chouhan  wrote:

> hi
>
> Dear all please help in access urgent plsss
>
>
>
>
>
>
>
> --
> One Team One Dream One Goal
>
> Warm Regards,
> Vikas Chauhan
> E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
> 9911868518,
> "We can't Spell S_ccess without U"
>
> Life is Very beautiful !!!
> ¨`•.•´¨) Always
> `•.¸(¨`•.•´¨) Keep
> (¨`•.•´¨)¸.•´ Smiling!
> `•.¸.•´.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 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
>
> To unsubscribe from this group, send email to excel-macros+
> unsubscribegooglegroups.com or reply to this email with the words "REMOVE
> ME" as the subject.
>



-- 
Thanks,

Deepak Rai

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 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

To unsubscribe from this group, send email to 
excel-macros+unsubscribegooglegroups.com or reply to this email with the words 
"REMOVE ME" as the subject.

Re: $$Excel-Macros$$ CONVERT chk it

[Deepak Rai]

Hi Nice one its working fine in 2007. :)

On Tue, Mar 16, 2010 at 6:00 PM, Jai  wrote:

>
> Dear Sir,
>
>
> This is not work properly
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> On Tue, Mar 16, 2010 at 5:13 PM, Vikas Chouhan wrote:
>
>> Hi,
>>
>>
>> Dear ,
>>
>>
>> open attachment and follow instruction
>>
>>
>> *Press Alt+t+m+v and after that press f5 and enter
>>
>> *
>> On Tue, Mar 16, 2010 at 2:13 PM, Jai  wrote:
>>
>>>
>>> Hello All,
>>>
>>> Please Tell me That,
>>>
>>> Can we convert number to Text In Ms Word -2007,
>>>
>>> For Example  2000  (Number)
>>>
>>> Two  thousand  (Text)
>>>
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our Facebook Group @
>>> http://www.facebook.com/group.php?gid=287779555678
>>> 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
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> HELP US GROW !!
>>>
>>> We reach over 6,800 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
>>>
>>
>>
>>
>> --
>> One Team One Dream One Goal
>>
>> Warm Regards,
>> Vikas Chauhan
>> E-Mail :- vikask...@gmail.com,vikask...@rediffmail.com,
>> 9911868518,
>> "We can't Spell S_ccess without U"
>>
>> Life is Very beautiful !!!
>> ¨`•.•´¨) Always
>> `•.¸(¨`•.•´¨) Keep
>> (¨`•.•´¨)¸.•´ Smiling!
>> `•.¸.•´.
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 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
>>
>
>
>
> --
> Thanks For Mail.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 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
>



-- 
Thanks,

Deepak Rai

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 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: Fwd: $$Excel-Macros$$ Named Ranges

[Deepak Rai]

Hi Harpreet Gujral,

Below is the solution for your query. I have used range B1:B10 for name
"Deepak" in the below code. You can customize the syntax as per your
requirement.

Range("B1:B10").Select
ActiveWorkbook.Names.Add Name:="Deepak", RefersTo:=Range("B1:B10")

Hope this is what you are looking for. Please revert in case it doesn't
work.

Thanks,

Deepak Rai

On Thu, Feb 25, 2010 at 2:58 PM, Harpreet Gujral
wrote:

> The idea is to name the range and then use it within the macro for ease of
> referencing.
>
>
> ActiveWorkbook.Names.Add Name:="Ctr1", RefersToR1C1:=_Strshtname &
> "R1C1:R2C3"
>
> I am talking about 'referstoR1C1'. For this we have to give range in terms
> of R1C1 reference style. Can we name a range in the other reference style.
> The problem is it is easy to reference cell A1 by saying A1 in the formula
> than R1C1.
>
> Please suggest.
>
> Harpreet
>
> Sent on my BlackBerry® from Vodafone Essar
> --
> *From: *rf1234 rf1234 
> *Date: *Thu, 25 Feb 2010 12:28:08 +0530
> *To: *
> *Cc: *
> *Subject: *Fwd: $$Excel-Macros$$ Named Ranges
>
> Dear Harpreet R1C1 is used to declare or use formula file
> using macro.
> i think if you want to run any formula or function u can directly write in
> excel formula window (fx) or in macro difining R1C1.
>
>
> I hope it will help.
>
>
>
> On Thu, Feb 25, 2010 at 11:18 AM, Harpreet Gujral <
> harpreetguj...@gmail.com> wrote:
>
>> Thanks for your advice.
>>
>> I think we deviated a bit from the topic.
>> I m looking for a alternative referencing technique used in the macro code
>> that I have pasted in my email. The problem is that the code uses R1C1
>> referencing style.can we change it?
>>
>> The solution provided is good to use if we don't want to give a specific
>> name to the range in question.
>>
>> Regards
>>
>> Harpreet Gujral
>>
>> Sent on my BlackBerry® from Vodafone Essar
>> --
>> *From: *rf1234 rf1234 
>> *Date: *Thu, 25 Feb 2010 10:58:18 +0530
>> *To: *
>> *Cc: *
>> *Subject: *Re: $$Excel-Macros$$ Named Ranges
>>
>> 'Named ranges are a great capability provided by Excel. You can define all
>> sorts of named ranges in a workbook,
>> ' but how do you access them when creating macros? This tip explains the
>> different ways you can access those ranges.
>> '(This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel
>> 2003, and Excel 2007.)
>>
>>
>>
>>
>>
>> ''''''''''''''''''''I HAVE USE TWO RANGE A1:D5 & A6:D10 TO SHOW RAND
>> FUNCTION USE.
>> Option Explicit
>> Sub Random()
>> Dim myRange1 As Range
>> 'Dim myRange2 As Range
>> Set myRange1 = Worksheets("Sheet1").Range("A1:D5")
>> myRange1.Formula = "=RAND()"
>> myRange1.Font.Bold = True
>> myRange1.Font.Color = vbBlue
>> Set myRange1 = Worksheets("Sheet1").Range("A6:D10")
>> myRange1.Formula = "=RAND()"
>> myRange1.Font.Bold = True
>> myRange1.Font.Color = vbYellow
>> End Sub
>>
>>
>> '''''''''''HOPE IT WILL WORK NOW
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>>
>> On Thu, Feb 25, 2010 at 9:06 AM, Harpreet Singh Gujral <
>> harpreetguj...@gmail.com> wrote:
>>
>>> Hi Group,
>>>
>>> In order to name ranges i use the following code:
>>>
>>> ActiveWorkbook.Names.Add Name:="Ctr1", RefersToR1C1:=_
>>> Strshtname & "R1C1:R2C3"
>>>
>>> It uses R1C1 referrencing, can we use the other referrencing for this
>>> code
>>>
>>> Thanks
>>>
>>> Harpreet Gujral
>>>
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our Facebook Group @
>>> http://www.facebook.com/group.php?gid=287779555678
>>> 3. Excel tutorials at http

Re: $$Excel-Macros$$ Cell referencing by formula

[Deepak Rai]

Hi Christopher Luka,

This is really great. For my understanding can you please explain this
offset function step by step so that I can also understand your logic.

Thanks,

Deepak

On Tue, Feb 23, 2010 at 10:09 AM, Maitre Bart wrote:

>
>
> On Feb 20, 12:05 pm, Christopher Luka 
> wrote:
> > Here's an example with one way to do it.  Let me know if the formula is
> too
> > complex & I'll walk you thru it.
> > [...]
>
> Interesting! It looks like what I need. I will give a try on my
> spreadsheet.
> Thank you both for your offers.
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 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
>



-- 
Thanks,

Deepak Rai

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 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$$ formula for showing multiple of a no.

[Deepak Rai]

ER for tips tricks and links :
> > http://twitter.com/exceldailytip
> > 2. Join our Facebook Group @
> > http://www.facebook.com/group.php?gid=287779555678
> > 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
> >
> > <><><><><><><><><><><><><><><><><><><><><><>
> > HELP US GROW !!
> >
> > We reach over 6,800 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 on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 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
>



-- 
Thanks,

Deepak Rai

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 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$$ Variable Formula Reference

[Deepak Rai]

Hi,

Another easier way of Cell Referencing is that Place "=" sign then click the
source cell in any sheet to set a reference of this source cell.

Thanks,

On Sat, Feb 20, 2010 at 1:56 PM, Christopher Luka <
christopher.l...@gmail.com> wrote:

> If I'm not mistaken, what you're looking for is a *formula* that will
> dynamically grab the value from Sheet1!A2 for Sheet2, Sheet1!A3 for Sheet3,
> Sheet1!A4 for Sheet4, etc.  If so, then the attached file should work for
> you.  Note that this formula VERY MUCH depends on the fact that the
> worksheet name tells us something about the worksheet's POSITION.  If you
> change the worksheet names from "Sheet2", "Sheet3", etc., this solution will
> break.
>
> The formula you're looking for is this one:
>
> =INDIRECT("Sheet1!A"&SUBSTITUTE(RIGHT(CELL("filename",A1)
> ,LEN(CELL("filename",A1))-FIND("]",CELL("filename",A1))),"Sheet",""))
>
> You'll notice the part highlighted in red.  This does the work of giving us
> a string with the name of the worksheet in it.  After that, it's just a
> matter of using some text manipulating functions to construct the address we
> want from Sheet1, and then use INDIRECT to access the value in that cell.
>  I'd recommend looking up the CELL & INDIRECT functions in the Excel help if
> you need more information.
>
> Cheers,
> Chris
>
> On Wed, Feb 17, 2010 at 12:00 PM, Branden Durst  wrote:
>
>> Okay, so I am in the process of creating a very large excel file and
>> was hoping for a quick way to do something, but my intermediate skills
>> aren't able to figure out the solution.
>>
>> Here is the situation, I am referencing cells off my first worksheet
>> in subsequent worksheets.  For each new sheet passed the first sheet,
>> I'd like add one to the row for the cell reference. So in other words,
>> On sheet two I'd like a cell to be referenced to sheet 1 cell A2, on
>> sheet 3 I'd like a cell to be referenced to sheet 1 cell A3 and so
>> on.  Any ideas?
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our Facebook Group @
>> http://www.facebook.com/group.php?gid=287779555678
>> 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
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> HELP US GROW !!
>>
>> We reach over 6,800 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 on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our Facebook Group @
> http://www.facebook.com/group.php?gid=287779555678
> 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
>
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,800 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
>



-- 
Thanks,

Deepak Rai

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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

<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 6,800 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$$ Relative references

[Deepak Rai]

Hi Shiv,

ActiveCell.Offset(1, 0).Range("A1").Select , moves one cell down to the
current cell. Complete syntax is ActiveCell.Offset(rowno,
columnno).Range("A1").Select , for example if u want to move one column from
active cell then u can use
ActiveCell.Offset(0, 1).Range("A1").Select.

I hope this help u in understanding offset method of active cell.




On Mon, Feb 8, 2010 at 9:54 PM, madhu nair  wrote:

>  hi shiv,
>
> it does nothing apart from moving one cell down from A1
>
>   On Mon, Feb 8, 2010 at 6:57 PM, Shiv Goel  wrote:
>
>> Hi friends
>>
>> Please tell me the this code meaning
>>
>>
>>
>> Sub SelectRelative()
>> ActiveCell.Offset(1, 0).Range("A1").Select
>> End Sub
>>
>>
>> What is the meaning of this color line
>>
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on 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,700 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
>>
>
>
>
> --
> Thanks,
>
> Madhu Nair
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on 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,700 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
>



-- 
Thanks,

Deepak Rai

-- 
--
Some important links for excel users:
1. Follow us on 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,700 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$$ Dataform applied to a database not starting in Row 1

[Deepak Rai]

Hi Philip,

Please share an example with attachment. So that we can find a workaround on
it. I am a Data Analyst I did lots of projects on Database programming,
might be after looking your example I can provide a good solution of your
problem.

Thanks,

Deepak

On Mon, Feb 1, 2010 at 5:23 PM, Philip  wrote:

> I have two databases in a worksheet, the second's headers are on Row
> 40.  On highlighting the second's headers and data, the Dataform
> correctly picks up the related fields.
>
> However, when running VBA code, the dataform defaults to the fields of
> the first database in Row 1.
>
> A workaround this problem?
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on 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,700 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
>



-- 
Thanks,

Deepak Rai

-- 
--
Some important links for excel users:
1. Follow us on 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,700 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 Countif across workbook??

[Deepak Rai]

Hi All,

I want to use countif across the workbook. In workbook-1 I have the criteria
& I am using countif in it, in workbook-2 I have the range. When I am using
countif in workbook-1 it is working only when the workbook-2 is opened, when
I close the workbook-2 its not working.
Please suggest any advice or alternative formula for the same. I want to do
it by formula only not by VBA.

-- 
Thanks,

Deepak Rai

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. 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 or
Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by 
the end of 2009. 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 Protect Access Database from the Users ?

[Deepak Rai]

Hi Daniel,

This is what I was looking at. Its working fine. Thank you soo much for your
kind help. Fantastic solution.


Regards.

Deepak Rai

On Thu, Dec 10, 2009 at 5:38 PM, Daniel  wrote:

>  Hello.
>
>
>
> For instance :
>
>
>
> ConnectString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & BDD &
> ";"
>
> ConnectString = ConnectString & "Jet OLEDB:Database Password=" &
> "yourpassword"
>
> cn.Open ConnectString
>
>
>
> Daniel
>
>
>
> *De :* excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
> *De la part de* Deepak Rai
> *Envoyé :* jeudi 10 décembre 2009 00:16
> *À :* MS EXCEL AND VBA MACROS
> *Objet :* $$Excel-Macros$$ How to Protect Access Database from the Users ?
>
>
>
> Hi All,
>
>
>
> I have created a Tool using Excel , Access & VBA. My both Excel GUI file &
> Access database is in the same folder. I want that user should not be able
> to open this Access Database. I need help in VBA part how to open a Access
> password protected database in excel. I am using ADO for database
> connectivity with Excel. I am using Office 2007.
>
> Any help will be highly helpful for me.
>
>
> --
> Thanks,
>
> Deepak Rai
>
> --
>
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. 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 or
> Ashish Jain @ 26may.1...@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. Our goal is to have 10,000
> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. 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 or
> Ashish Jain @ 26may.1...@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. Our goal is to have 10,000
> subscribers by the end of 2009. Let friends and co-workers know they can
> subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
Thanks,

Deepak Rai

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. 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 or
Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ How to Protect Access Database from the Users ?

[Deepak Rai]

Hi All,

I have created a Tool using Excel , Access & VBA. My both Excel GUI file &
Access database is in the same folder. I want that user should not be able
to open this Access Database. I need help in VBA part how to open a Access
password protected database in excel. I am using ADO for database
connectivity with Excel. I am using Office 2007.
Any help will be highly helpful for me.

-- 
Thanks,

Deepak Rai

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. 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 or
Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Re: Add brwose button to MS Excel to retrieve data from MS Access 2007

[Deepak Rai]

 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 or
> > Ashish Jain @ 26may.1...@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. Our goal is to have 10,000
> subscribers by the end of 2009. Let friends and co-workers know they can
> subscribe to group athttp://groups.google.com/group/excel-macros/subscribe
>
> --
>
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. 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 or
> Ashish Jain @ 26may.1...@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. Our goal is to have 10,000
> subscribers by the end of 2009. Let friends and co-workers know they can
> subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
Thanks,

Deepak Rai

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. 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 or
Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Re: Add brwose button to MS Excel to retrieve data from MS Access 2007

[Deepak Rai]

Hi,

I am also agree with that. If u want to manipulate Excel by getting data
from Access, U need to be clear about your needs or expectation. For example
I have just created a Staff Database Tool in Excel, which retrives its data
from Access Database. I can help u with codes, if it helps.

Regards,

Deepak Rai

On Mon, Dec 7, 2009 at 6:44 PM, Paul Schreiner wrote:

>  I suspect you'll be waiting quite a while.
> adding a "browse button" is quite confusing.
> You might as well say: "I'd like to add a "take the dog for a walk" button"
> Because you can't do that with Access either.
>
> the problem is that YOU know what you mean by "browse"
> but no one else does.
>
> What we can GUESS from your question is that:
> A) You have an MS-Access2007 database.
> B) You have an Excel 2007 workbook.
> C) You'd like to GET data from the Ms-Access database
>INTO the Excel2007 file.
> D) You want a button to do it.
>
> Now, what do you need help with?
> Writing a macro to retrieve data from MS-Access?
> Defining which data elements to retrieve?
> Or assigning the macro you already have to a button?
>
> Or do you just want to take the dog for a walk and start over when you get
> back?
> (just kidding)
>
> Paul
>
>  --
> *From:* Chanti-Hyderabad 
> *To:* MS EXCEL AND VBA MACROS 
> *Sent:* Mon, December 7, 2009 5:11:04 AM
> *Subject:* $$Excel-Macros$$ Re: Add brwose button to MS Excel to retrieve
> data from MS Access 2007
>
> Hi Gurus,
>
> Awaiting for your help..Thanks
>
> On Dec 1, 5:23 pm, Chanti-Hyderabad  wrote:
> > Hi Excel Gurus,
> >
> > Hope this new post find you all well.
> >
> > I would like to add a 'Browse button' (command button) to my excel
> > 2007 file, which should pull the data from MS Access 2007.
> >
> > I hope its a bit confusing request, please do let me know if you need
> > any further clarification.
> >
> > Regards---
>
> --
>
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. 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 or
> Ashish Jain @ 26may.1...@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. Our goal is to have 10,000
> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. 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 or
> Ashish Jain @ 26may.1...@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. Our goal is to have 10,000
> subscribers by the end of 2009. Let friends and co-workers know they can
> subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
Thanks,

Deepak Rai

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. 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 or
Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Time Values in a variable

[Deepak Rai]

Hi,

You can use custom fromat to get that 09:00:00.

Regards,

Deepak Rai

On Tue, Dec 1, 2009 at 8:10 AM, Toddy  wrote:

> I am trying to capture the time in a variable that I am using to
> populate as text into an email via Lotus Notes from Excel and VBA.
>
> When VBA picks up the value from the worksheet, it shows as it's
> decimal value. I then multiply the value to get a
> time i.e. 0.375 *24 = 9.  But I want this to be shown as 9:00.
>
> Below is part of the code I am using:
>
> Dim MonDate, MonStart, MonFin, MonStore, TueDate, TueStart, TueFin,
> TueStore, WedDate, WedStart, WedFin, WedStore, ThuDate, ThuStart,
> ThuFin, ThuStore, FriDate, FriStart, FriFin, FriStore, WklyHrs, Name,
> Count
>
>Count = 5
>
>Sheets("Temp Weekly Roster").Select
>
>Name = Cells(Count, 5)
>
>MonDate = Range("G2").Value
>MonStart = Cells(Count, 8) * 24
>MonFin = Cells(Count, 9) * 24
>MonStore = Cells(Count, 7)
>
> --
>
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. 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 or
> Ashish Jain @ 26may.1...@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. Our goal is to have 10,000
> subscribers by the end of 2009. Let friends and co-workers know they can
> subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe




-- 
Thanks,

Deepak Rai

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. 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 or
Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Run-time error '1004': PasteSpecial method of Range class failed

[Deepak Rai]

Hi,

Please try this code, Hope this will help.
Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False

Regards,

Deepak Rai

On Tue, Dec 1, 2009 at 10:03 AM, Dave Bonallack
wrote:

> Hi,
> Try doing it manually with the macro recorder on, then look at the syntax.
> Dave.
>
> > Date: Mon, 30 Nov 2009 10:05:31 -0800
> > Subject: $$Excel-Macros$$ Run-time error '1004': PasteSpecial method of
> Range class failed
> > From: jon.wester...@gmail.com
> > To: excel-macros@googlegroups.com
>
> >
> > This is something that seems pretty simple, I am trying to paste
> > values into a workbook using a macro:
> >
> > Range("A1").Select
> > Selection.PasteSpecial Paste:=xlPasteValues
> >
> > I start out by manually copying a range of cells in a separate
> > workbook and clicking a form button to paste the values. Each time I
> > do this I get "Run-time error '1004': PasteSpecial method of Range
> > class failed"
> >
> > The cells a am copying range from columns A-N and the total number of
> > rows varies. I have also tried:
> >
> > Range("A1:N11").Select
> > Selection.PasteSpecial Paste:=xlPasteValues
> >
> > with no luck.
> >
> > --
> >
> --
> > Some important links for excel users:
> > 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> > 2. Excel tutorials at http://www.excel-macros.blogspot.com
> > 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> > 4. 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 or
> > Ashish Jain @ 26may.1...@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. Our goal is to have 10,000
> subscribers by the end of 2009. Let friends and co-workers know they can
> subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> --
> Check out The Great Australian Pay Check now Want to know what your boss
> is paid? <http://clk.atdmt.com/NMN/go/157639755/direct/01/>
>
> --
>
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. 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 or
> Ashish Jain @ 26may.1...@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. Our goal is to have 10,000
> subscribers by the end of 2009. Let friends and co-workers know they can
> subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
Thanks,

Deepak Rai

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. 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 or
Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ use of macros

[Deepak Rai]

Hi Gaurav,

We can use Macros & VBA for a vast uses. I am working as a Data Analyst so I
use macros & VBA a lot to automate my tasks so that I can save time.
One more thing macros & VBA are also use for accurate data. It is useful
for repeat tasks
.
On Tue, Dec 1, 2009 at 9:36 AM, gaurav rustagi wrote:

> Can any body explain use of macros in an excel sheet.
>
> explain in details
>
> thanks in advance
>
> --
> CA Gaurav Rustagi
> Assistant Manager-Finance
>
> The Bristol Hotel
> Adjacent to DLF Qutab Enclave,
> Phase I, Gurgaon-122002
> Haryana
>
> Mobile   93 13 19 82 81
> Tel0124  2356030, 435
> Fax   0124  2357834
> Website  www.thebristolhotel.com
>
> --
>
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. 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 or
> Ashish Jain @ 26may.1...@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. Our goal is to have 10,000
> subscribers by the end of 2009. Let friends and co-workers know they can
> subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe




-- 
Thanks,

Deepak Rai

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. 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 or
Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ Urgent help on simple macro

[Deepak Rai]

Hi,

Thanks if my solution helped u, for this problem I need detailed
explanation of your problem.

Regards,

Deepak Rai



On Tue, Nov 17, 2009 at 8:56 PM, vinod rao  wrote:

> Thanks Andy. Plz help me on other file about deleting columns
>
>
> On Tue, Nov 17, 2009 at 8:46 PM, Aindril De  wrote:
>
>> Hi VR,
>>
>> Please use the following code:
>>
>> Sub TispPAT()
>> 'Macro created by Aindril De(Andy)
>> 'Shortcut Ctrl + Shift + p
>> Dim CurCell As Object
>> Dim i As Integer
>> i = 4
>> For Each CurCell In Range("B4:B11")
>> Range("B" & i).Activate
>>If ActiveCell.Value = "Tisp" And ActiveCell.Offset(0,
>> 3).Value = "Core" Then ActiveCell.Value = "PAT"
>> i = i + 1
>> Next
>> End Sub
>> Please let us know if you need any further help. I am also attaching the
>> Excel sheet with the Macro.
>>
>> Regards,
>> Andy
>>   On Tue, Nov 17, 2009 at 8:15 PM, vinod rao wrote:
>>
>>> Hello Team,
>>>
>>> I need a macro to change Column B from Tisp to PAT if the Column D is
>>> Core
>>>
>>> Regards,
>>> VR
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>>> http://www.excelitems.com
>>> 2. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
>>> 4. 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 or
>>> Ashish Jain @ 26may.1...@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. Our goal is to have 10,000
>>> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
>> http://www.excelitems.com
>> 2. Excel tutorials at http://www.excel-macros.blogspot.com
>> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
>> 4. 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 or
>> Ashish Jain @ 26may.1...@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. Our goal is to have 10,000
>> subscribers by the end of 2009. 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. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. 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 or
> Ashish Jain @ 26may.1...@gmail.com
> <><><><><><><><><><><><><><><><><><><><><><>
> HELP US GROW !!
>
> We reach over 6,500 

Re: $$Excel-Macros$$ Urgent help on simple macro

[Deepak Rai]

Hi,

As per my understanding I have attached a solution of it. Please find the
attached file.

Regards,

Deepak Rai

On Tue, Nov 17, 2009 at 6:45 PM, vinod rao  wrote:

> Hello Team,
>
> I need a macro to change Column B from Tisp to PAT if the Column D is Core
>
> Regards,
> VR
>
> --
>
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. 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 or
> Ashish Jain @ 26may.1...@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. Our goal is to have 10,000
> subscribers by the end of 2009. Let friends and co-workers know they can
> subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe




-- 
Thanks,

Deepak Rai

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. 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 or
Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Test10(1).xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Leave Tracker

[Deepak Rai]

Hi Nayan,

Please find the enclosed sample tracker. You can customize as per your need.


Regards,

Deepak Rai

On Thu, Nov 12, 2009 at 7:56 PM, Nayan K Lodaya  wrote:

>  Hello Anyone ,
>
> Please can you send / share leave tracker file you have for your
> organisation…as I am looking for my team which consits of around 250
> employees.
>
> *Regards,*
> *Nayan K Lodaya* | IBOD Inter Entity Swaps | *J.P. Morgan* | 9th Floor ,
> A-wing, Prism Towers, Malad(W), Mumbai | T: GDP : 308 0525 | *
> nayan.k.lod...@jpmorgan.com* | *jpmorgan.com*
>
>
>
>
> This email is confidential and subject to important disclaimers and
> conditions including on offers for the purchase or sale of securities,
> accuracy and completeness of information, viruses, confidentiality, legal
> privilege, and legal entity disclaimers, available at
> http://www.jpmorgan.com/pages/disclosures/email.
>
> --
>
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. 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 or
> Ashish Jain @ 26may.1...@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. Our goal is to have 10,000
> subscribers by the end of 2009. Let friends and co-workers know they can
> subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe




-- 
Thanks,

Deepak Rai

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. 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 or
Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Sample Leave Tracker.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ text and date in one cell

[Deepak Rai]

Hi,

U can use =C3 & " " & TEXT(D3,"mmm-yy").

Regards,

Deepak Rai

On Thu, Nov 12, 2009 at 7:36 PM, Nayan K Lodaya  wrote:

>  =CONCATENATE(C3," ",TEXT(D3,"mmm-yy"))
>
> Hope this helps
>
>
>
> *From:* Prashanth Banneni [mailto:praba...@gmail.com]
> *Sent:* 12 November 2009 18:37
>
> *To:* excel-macros@googlegroups.com; dilipan...@gmail.com
> *Subject:* $$Excel-Macros$$ text and date in one cell
>
>
>
> Hi All,
>
>
>
> Can you help me how to get the desired output from the attached sheet.
>
>
>
> Many thanks in advance
>
>
>
> Best
>
> Prashanth
>
> --
>
> --
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. 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 or
> Ashish Jain @ 26may.1...@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. Our goal is to have 10,000
> subscribers by the end of 2009. Let friends and co-workers know they can
> subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>
> This email is confidential and subject to important disclaimers and
> conditions including on offers for the purchase or sale of securities,
> accuracy and completeness of information, viruses, confidentiality, legal
> privilege, and legal entity disclaimers, available at
> http://www.jpmorgan.com/pages/disclosures/email.
>
> --
>
> --
>
> Some important links for excel users:
> 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
> http://www.excelitems.com
> 2. Excel tutorials at http://www.excel-macros.blogspot.com
> 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
> 4. 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 or
> Ashish Jain @ 26may.1...@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. Our goal is to have 10,000
> subscribers by the end of 2009. Let friends and co-workers know they can
> subscribe to group at
> http://groups.google.com/group/excel-macros/subscribe
>



-- 
Thanks,

Deepak Rai

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. 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 or
Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

$$Excel-Macros$$ Re: Excel VBA dynamically fill ComboBox?

[Deepak Rai]

Hi,

I am attaching a file which is based on the same logic. U can use the same
logic for your requirement.
Hope this will help u.


Regards,

Deepak Rai

On Tue, Nov 10, 2009 at 12:11 PM, RolfJ  wrote:

>
> Assuming that your country column is column A, place the following
> code into the VBA section of the form containing your three ComboBoxes
> (referred to as cmbBoxCountry, cmbBoxState and cmbBoxProduct) and give
> it a try:
>
> Private Sub cmbBoxCountry_Change()
>Call UpdateComboBox("B", cmbBoxState, cmbBoxCountry)
> End Sub
>
> Private Sub cmbBoxState_Change()
>Call UpdateComboBox("C", cmbBoxProduct, cmbBoxState)
> End Sub
>
> Private Sub UserForm_Activate()
>Call UpdateComboBox("A", cmbBoxCountry)
> End Sub
>
> Private Sub UpdateComboBox(sourceCol As String, ByRef c As
> MSForms.ComboBox, Optional cRef As MSForms.ComboBox)
>c.Clear
>Dim r As Range
>Set r = Range(Range(sourceCol & 2), Range(sourceCol &
> Rows.Count).End(xlUp))
>Dim rCell As Range
>If cRef Is Nothing Then
>For Each rCell In r.Cells
>If Not IsInComboBox(rCell.Value, c) Then c.AddItem
> (rCell.Value)
>Next rCell
>Else
>For Each rCell In r.Cells
>If rCell.Offset(, -1).Value = cRef Then
>If Not IsInComboBox(rCell.Value, c) Then c.AddItem
> (rCell.Value)
>End If
>Next rCell
>End If
>If c.ListCount > 0 Then c.ListIndex = 0
> End Sub
> Private Function IsInComboBox(s As String, c As MSForms.ComboBox) As
> Boolean
>Dim i As Integer
>For i = 0 To c.ListCount - 1
>If c.List(i) = s Then
>IsInComboBox = True
>Exit Function
>End If
>Next i
>IsInComboBox = False
> End Function
>
> Hope this helped,
> Rolf Jaeger
> SoarentComputing
> http://soarentcomputing.com/SoarentComputing/ExcelSolutions.htm
>
>
> On Nov 8, 7:47 am, Meimei  wrote:
> > Hello,
> >
> > I have a question on using VBA to programme several ComboBoxes whose
> > items are dynamically filled?
> > I have a worksheet containing country names, states, and product, such
> > as
> > CountryState Product
> > 1  US   MA  Banana
> > 2  US   MA  Orange
> > 3  US   WV  Apple
> > 4  US   WV  Apple
> > 5  US   CA  Banana
> > 6  Canada   Quebec  Orange
> > 7  Canada   Quebec  Orange
> > 8  Canada   Albert  Apple
> > 9  Canada   Albert  Banana
> >
> > I want to the 1st ComboBox to read the list of country names and
> > filled by the unique country names, in this, I have two country names,
> > US and Canada. After the 1st ComboBox is selected, I want the 2nd
> > ComboBox to be dynamically filled with the appropriate state/province
> > names, i.e., if the user chooses US, then the 2nd ComboBox only have
> > the choices of MA, WV, and CA. Similarly for the 3rd ComboBox, if the
> > user chooses US and then WV, the 3rd ComboBox should list Apple.
> >
> > So I figure that the code should dynamically search for unique country
> > names, state names, and product names, and also be able to link the
> > appropriate list of states to country, and appropriate list of product
> > to state or provinces. But I don't have a clear idea how to do this.
> > Can someone help me with some sample codes?
> >
> > Thanks a lot!
> >
>


-- 
Thanks,

Deepak Rai

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. 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 or
Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



Concatenate(1).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Re: Conditional sum problem ( first ns and equal to certain values)

[Deepak Rai]

Hi Dilip,

Just wanted to know your formula in detail, I tried this formula also
=SUMPRODUCT(($A$1:$A$11=$E$1)*($B$1:$B$11>0)*($B$1:$B$11)) , which is giving
me the same result. I passed two criteria first is A1:A11 = E1 & second one
is value greater then 0. Please explain for my knowledge please.

Regards,

Deepak

On Sat, Nov 7, 2009 at 6:53 PM, Deepak Rai  wrote:

> Hi,
>
> Please find the enclosed attachment, hope this will help.
>
> Regards,
>
> Deepak
>
>   On Fri, Nov 6, 2009 at 9:35 PM, Tony from Work wrote:
>
>>
>> Hello!
>> Given 2 unsorted columns I'm trying to find a formula that gives me
>> the sum of the first 3 values greater than  zero and equal to a
>> certain label, for example:
>>
>> D 2
>> B 3
>> A 1
>> B 2
>> C 3
>> A -1
>> A 0
>> A 3
>> C 2
>> A 2
>> A 5
>>
>> I have to find the sum only of the first 3 A that are greater than
>> zero; in this case the result is 6.
>>
>> Many thanks for your time,
>>
>> Tony
>>
>>
>>
>>
>> >>
>>


-- 
Thanks,

Deepak Rai

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. 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 or
Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Conditional sum problem ( first ns and equal to certain values)

[Deepak Rai]

Hi,

Please find the enclosed attachment, hope this will help.

Regards,

Deepak

On Fri, Nov 6, 2009 at 9:35 PM, Tony from Work  wrote:

>
> Hello!
> Given 2 unsorted columns I'm trying to find a formula that gives me
> the sum of the first 3 values greater than  zero and equal to a
> certain label, for example:
>
> D 2
> B 3
> A 1
> B 2
> C 3
> A -1
> A 0
> A 3
> C 2
> A 2
> A 5
>
> I have to find the sum only of the first 3 A that are greater than
> zero; in this case the result is 6.
>
> Many thanks for your time,
>
> Tony
>
>
>
>
>
> >
>


-- 
Thanks,

Deepak Rai

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. 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 or
Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



Answer.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Re: Need help regarding entering date

[Deepak Rai]

Hi Pooja,

I would suggest to use custom category in the format cells window. In the
Type: option please type "HH:MM:SS" & apply this on the selected cell. Now
whenever u will change the time it will come in HH:MM:SS format.

Regards,

Deepak Rai
On Sun, Nov 1, 2009 at 12:03 AM, Pooja Sharma wrote:

> Hi All,
>
> In excel 2003, I want to add time in  HH:MM:SS format and I tried it by
> changing the format cell with Time in that format but whenever I use the
> shortcut for entering time in the Cells, it doesn't show the change of
> seconds. The shortcut I use for Time is Ctrl + Shift + ; keys.
> If there is any other possibility then please guide me the way.
>
> --
> Best Regards
> Pooja Sharma
>
> >
>


-- 
Thanks,

Deepak Rai

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. 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 or
Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Need a function or formula

[Deepak Rai]

Hi Pooja,

Please find the enclosed file with the solution.

Regards,

Deepak Rai

On Sat, Oct 31, 2009 at 9:25 PM, Pooja Sharma wrote:

> Hi All,
>
> I need your help in extracting some words (having defined format) from one
> cell in another cell. Attached is a sheet where I have mentioned the case
> and the solution I require.
>
> Hope you will help me.
>
> Best Regards
> Pooja Sharma
> *******
>
> >
>


-- 
Thanks,

Deepak Rai

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. 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 or
Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



Required Solution on the Data(1).xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Need Urgent Help (While Statement)

[Deepak Rai]

Hi,

Why don't you use Select Case instead of IF statement ?

Regards,

Deepak Rai

On Mon, Oct 26, 2009 at 10:47 AM, Anish Shrivastava wrote:

> Hello Experts..
>
> I m using While and Wend statement in my code and it has got more than 100
> if conditions. when I run the macro it says "WEND WITHOUT WHILE", it's
> buggin my head...and I don know wht's wrong. Could anyone of you please help
> me...
>
> Sample code...
>
> Sub dept()
> i = 1
> z = Cells(Rows.Count, "B").End(xlUp).Row
> While i <= z
> If Cells(i, 2).Value Like "*FINANCE*" Then
> Cells(i, 4) = "FINANCE / ACCOUNTING"
> Else
> If Cells(i, 2).Value Like "*ACCOUNTS*" Then
> Cells(i, 4) = "FINANACE / ACCOUNTING"
> Else
> If Cells(i, 2).Value Like "*SALES*" Then
> Cells(i, 4) = "SALES"
> *(IN BETWEEN THR R MORE THAN 100 IF CONDITIONS LIKE THIS)*
> endif
> endif
> endif
> i=i+1
> wend
> end sub
>
> -best
> ANISH
>
> >
>


-- 
Thanks,

Deepak Rai

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. 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 or
Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Insert file path and name into cell

[Deepak Rai]

Hi Hemant,

 Nice logic. It will also be very helpful.

Regards,

Deepak Rai

On Thu, Oct 22, 2009 at 7:41 PM, Deepak Rai  wrote:

> Hi JP,
>
> Please find the below VBA code for the solution of your problem. Hope this
> will help you.
>
> Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target
> As Range)
>
> a = ActiveCell.Address
> For i = 1 To 10
> On Error Resume Next
> If a = ("$A$") & i Then
>
> If Range("A" & i).Value < 1 Then
> m = Application.GetOpenFilename
> If m = 0 Then
> Exit Sub
> End If
> Workbooks("Test.xls").Sheets("Sheet1").Range("A" & i).Value = m
> End If
> End If
> Next i
> End Sub
>
>
> On Thu, Oct 22, 2009 at 3:41 AM, jp  wrote:
>
>>
>> I would like to be able to select a cell in a worksheet and then run a
>> macro to open a dialogue box to browse through folders and files on my
>> computer, select a file, and insert that file path and name into the
>> active cell.  Can someone please help me to do this?  Any help would
>> be greatly appreciated!
>>
>> JP
>>
>> >>
>>


-- 
Thanks,

Deepak Rai

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. 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 or
Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Insert file path and name into cell

[Deepak Rai]

Hi JP,

Please find the below VBA code for the solution of your problem. Hope this
will help you.

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target
As Range)

a = ActiveCell.Address
For i = 1 To 10
On Error Resume Next
If a = ("$A$") & i Then

If Range("A" & i).Value < 1 Then
m = Application.GetOpenFilename
If m = 0 Then
Exit Sub
End If
Workbooks("Test.xls").Sheets("Sheet1").Range("A" & i).Value = m
End If
End If
Next i
End Sub


On Thu, Oct 22, 2009 at 3:41 AM, jp  wrote:

>
> I would like to be able to select a cell in a worksheet and then run a
> macro to open a dialogue box to browse through folders and files on my
> computer, select a file, and insert that file path and name into the
> active cell.  Can someone please help me to do this?  Any help would
> be greatly appreciated!
>
> JP
>
> >
>


-- 
Thanks,

Deepak Rai

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. 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 or
Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Need help on Concatenate & Indirect combination

[Deepak Rai]

Hi,

 

I need your help on the attached sample sheet. I have used the concatenate &
indirect combination logic to get the desire comments as outcome , but my
problem is that I have 300 rows  & 30 sheets in a workbook with this logic ,
it is increasing the size of my file as I have a total of 30 sheets with
same logic .   I need it in every sheet. If there is any other alternative
or solution please help me.

 

Regards,

Deepak Rai


--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. 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 or
Ashish Jain @ 26may.1...@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. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



Concatenate.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$$Excel-Macros$$ Re: Best Tip (Excel POP up Calendar

[Deepak Rai]

On Tue, Aug 11, 2009 at 2:08 AM, Deepak Rai  wrote:

> Hi,
>
> In the Developer Tools click on More Controls & then select Calender
> Control 12.0.
> Please follow the below steps to get the Calender Control:
>
> 1. Right Click on Menu Bar
> 2. Select "Customize Quick Access Toolbar.."
> 3. Select Customize option
> 4. In the Choose commands from drop down
> 5. Select Developer Tab
> 6. Select Insert Controls option
> 7. Don't forget to select the option "Show Quick Access Toolbar below the
> Ribbon"
>
> Hope this will help you.
>
> Regards,
>
> Deepak Rai
>
>
>
> On Mon, Aug 10, 2009 at 1:38 PM, Iqbal Shaikh wrote:
>
>> Hi ALL.
>>
>> How to use this calender in XL 2007.
>>
>>
>>
>>
>> Iqbal Shaikh
>>
>>
>>   On 8/7/09, Ayushj  wrote:
>>>
>>>
>>> Hi Shafiq,
>>>
>>> This is the awesome tip. Appreciate your knowledge. :)
>>> regards,
>>> Ayush Jain
>>>
>>> On Aug 7, 3:48 pm, shafiq online  wrote:
>>> > Dear All,
>>> >
>>> > Here is a tip for pop up calendar in Excel. You can display a clander
>>> in a excel sheet and enter date in a cell by slecting the appropriate date.
>>> Steps are given below;
>>> >
>>> > 1. Open excel work book.
>>> >
>>> > 2. go to wiew>Toolbars>Controll Toolbox
>>> >
>>> > 3. Now u can see a toolbox window in the sheet. Go to last button (more
>>> controll) and clink on it. Here u can see a list of controls, click on
>>> Calendar control 11.0
>>> >
>>> > 4. Adjust the clander in the sheet where you required to be diplayed
>>> this.
>>> >
>>> > 5. Important steps. Double click on calender or right click, then view
>>> code following code will diplay
>>> >
>>> > Private Sub Calendar1_Click()
>>> >
>>> > End Sub
>>> >
>>> > 6. Enter following lind between 1st and last line
>>> >
>>> >         ActiveCell.Value = Calendar1.Value
>>> >
>>> > 7. Your code will look like this
>>> >
>>> >  Private Sub Calendar1_Click()
>>> > ActiveCell.Value = Calendar1.Value
>>> > End Sub
>>> >
>>> > 8. Get out of VBA and go to excel sheet and use the calender.
>>> >
>>> > Regards,
>>> >
>>> > _
>>> > Share your memories online with anyone you want.
>>> http://www.microsoft.com/middleeast/windows/windowslive/products/phot...
>>> >>>
>>>
>
>
> --
> Thanks,
>
> Deepak Rai
>



-- 
Thanks,

Deepak Rai

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. 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 or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Please Help Me!!!

[Deepak Rai]

Hi Anil,

Please find the attached sheet with answer of your query.

Regards,

Deepak Rai

On Mon, Aug 10, 2009 at 12:07 PM, Sandeep  wrote:

>  I Need to calculate the range as per the criteria mentioned in attached
> file please help me.
>
> >
>
>


-- 
Thanks,

Deepak Rai

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. 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 or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---



Anil(1).xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Best Tip (Excel POP up Calendar

[Deepak Rai]

Hi,

In the Developer Tools click on More Controls & then select Calender Control
12.0.
Please follow the below steps to get the Calender Control:

1. Right Click on Menu Bar
2. Select "Customize Quick Access Toolbar.."
3. Select Customize option
4. In the Choose commands from drop down
5. Select Developer Tab
6. Select Insert Controls option
7. Don't forget to select the option "Show Quick Access Toolbar below the
Ribbon"

Hope this will help you.

Regards,

Deepak Rai



On Mon, Aug 10, 2009 at 1:38 PM, Iqbal Shaikh  wrote:

> Hi ALL.
>
> How to use this calender in XL 2007.
>
>
>
>
> Iqbal Shaikh
>
>
>   On 8/7/09, Ayushj  wrote:
>>
>>
>> Hi Shafiq,
>>
>> This is the awesome tip. Appreciate your knowledge. :)
>> regards,
>> Ayush Jain
>>
>> On Aug 7, 3:48 pm, shafiq online  wrote:
>> > Dear All,
>> >
>> > Here is a tip for pop up calendar in Excel. You can display a clander in
>> a excel sheet and enter date in a cell by slecting the appropriate date.
>> Steps are given below;
>> >
>> > 1. Open excel work book.
>> >
>> > 2. go to wiew>Toolbars>Controll Toolbox
>> >
>> > 3. Now u can see a toolbox window in the sheet. Go to last button (more
>> controll) and clink on it. Here u can see a list of controls, click on
>> Calendar control 11.0
>> >
>> > 4. Adjust the clander in the sheet where you required to be diplayed
>> this.
>> >
>> > 5. Important steps. Double click on calender or right click, then view
>> code following code will diplay
>> >
>> > Private Sub Calendar1_Click()
>> >
>> > End Sub
>> >
>> > 6. Enter following lind between 1st and last line
>> >
>> > ActiveCell.Value = Calendar1.Value
>> >
>> > 7. Your code will look like this
>> >
>> >  Private Sub Calendar1_Click()
>> > ActiveCell.Value = Calendar1.Value
>> > End Sub
>> >
>> > 8. Get out of VBA and go to excel sheet and use the calender.
>> >
>> > Regards,
>> >
>> > _
>> > Share your memories online with anyone you want.
>> http://www.microsoft.com/middleeast/windows/windowslive/products/phot...
>> >>
>>


-- 
Thanks,

Deepak Rai

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. 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 or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ urgent - How to calculate sum of only positive numbers

[Deepak Rai]

Hi Ashish,
 
Press CTRL+ENTER in the cell because this is an array formula.
 
Regards,
 
Deepak Rai
 
Sirjee
 
One additional help required on ur solved work sheet regarding the problem
by Anilji. Noticed what i feel is strange behaviour.
 
I use Excel2007. Your formula with {=SUM(IF(E4:E8>0,E4:E8,""))} work fine
but the moment i click to edit on the cell where this formula is entered,
the {} (brackets) disappear even if i dont make any changes and I get an
error on this formula.Copy pasting this formula works fine.
 
Any idea why this could be?
 
Thanks
-- 
Ashish
 
"The older we get, the more we needs people around us who knew us when we
were young" -- Unknown
 
 
On 8/7/09, Dilip Pandey  wrote:
> 
> Hi Anil,
> Solved sheet is attached with this email.  Thanks
> --
> DILIP KUMAR PANDEY
>   MBA-HR,B COM(Hons.),BCA
> Mobile: +91 9810929744
> dilipan...@gmail.com
> dilipan...@yahoo.com
> New Delhi - 110062
> 
> On Fri, Aug 7, 2009 at 2:10 PM, ANIL NAIR  wrote:
> 
>> 
>> excel sheet is attached
>> 
>> -- Forwarded message --
>> From: ANIL NAIR 
>> Date: 7 Aug 2009 14:09
>> Subject: urgent - How to calculate sum of only positive numbers
>> To: excel-macros@googlegroups.com
>> 
>> Hi
>> 
>> URGENT HELP
>> 
>> I want to calculate the sum of only postive numbers in a row of both
>> postive and negative numbers. excel sheet is attached
>> 
>> PLS TREAT THIS AS URGENT
>> 
>> regds
>> anil nair
>> 
>> 
>> 
> 
> 
> 
> >
> 
> 
 

 


--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. 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 or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: how to hide #N/A

[Deepak Rai]

Hi Harris,

You can also use =IFERROR(A1,0) where A1 = #N/A.

Regards,

Deepak Rai

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of Andre Dreyer
Sent: Friday, August 07, 2009 1:48 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Re: how to hide #N/A


Hi Harris,

One could also write the formula to be;

=if(isna(A1),0,A1)

A1 is the reference of your Formula, so it could be anything from a
sum to a lookup and so on.

Thanks
Andre

On Aug 6, 8:31 am, harris a  wrote:
> Hello,
>
> In case a formula is returning “#N/A” then is there a way by which the
> output of the formula could be made blank or zero. please help.
>
> regards, Harris



--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. 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 or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: urgent - How to calculate sum of only positive numbers

[Deepak Rai]

Hi Anil,

 

Use this formula for calculating the positive value only in a row:

 

=SUMIF(B1:D1,">0",B1:D1)

 

Where B1 = 30 , C2= -20 & D2 = 60.

 

Hope this will help you.

 

Regards,

 

Deepak Rai

 

From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com]
On Behalf Of ANIL NAIR
Sent: Friday, August 07, 2009 2:09 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ urgent - How to calculate sum of only positive
numbers

 

Hi 

 

URGENT HELP

 

I want to calculate the sum of only postive numbers in a row of both postive
and negative numbers. excel sheet is attached

 

PLS TREAT THIS AS URGENT

 

regds

anil nair

 




--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. 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 or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---

$$Excel-Macros$$ Re: Shapes in Form

[Deepak Rai]

Hi,

If you can please provide a sample file of the same, it will help us to find
the solution.

Regrds,
Deepak

On Wed, Aug 5, 2009 at 1:56 AM, Tim  wrote:

>
> Hello all,
>   I'm attempting to have a window pop up when the user clicks a
> command button on the sheet.  The hurdle I have come to is drawing on
> the form.  I have dimensions on the sheet that I want to feed into the
> "pop-up" for this sketch.
>
> What am I missing?  I can't get any shape commands to work in the
> form.  All I have gotten so far is shapes on the spreadsheet, but
> these can be moved around by the user after the macro has run.
>
> Thanks in advance.
>
> >
>


-- 
Thanks,

Deepak Rai

--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. 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 or
Ashish Jain @ 26may.1...@gmail.com
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!

We reach over 5,200 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe
-~--~~~~--~~--~--~---