Thanks Noorain,
For the help, will have a look at it.
Regards
Sreejith
Date: Fri, 30 Mar 2012 20:24:33 +0530
Subject: Re: $$Excel-Macros$$ == Need help on the sheet
From: noorain.ans...@gmail.com
To: excel-macros@googlegroups.com
Dear Sreejit,
Please use it..
=OFFSET(INDEX(Detailed!$A$
Hi
There are many examples available on the net. here is one of them.
http://www.excelfox.com/forum/f12/dependent-data-validation-using-only-formulas-111/
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please He
Pls update my requirement.i want to display items with the headings in the
second combo box with the criteria based on first combobox.
For example
Col A (COMBO BOX 1) COL B (COMBO BOX 2)
ASIA ASIA HEADING
AUSTRALIA
hi group,
i would like to know how to populate a combobox based on another combobox
on userform.
thanks a lot.
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Pro
2012/3/31 NOORAIN ANSARI
> Very useful link Ashish, Thanks to sharing with group
>
>
> On Fri, Mar 30, 2012 at 9:37 PM, ashish koul wrote:
>
>> http://www.rondebruin.nl/ribbon.htm#Examples
>>
>>
>>
>>
>> On Fri, Mar 30, 2012 at 9:33 PM, Divaker Pandey wrote:
>>
>>>
>>>
>>> On Fri, Mar 30, 2012 at
Genius and Thanks Maries exactly what I wanted
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Maries
Sender: excel-macros@googlegroups.com
Date: Sat, 31 Mar 2012 09:13:04
To: hilary lomotey;
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: finos
Sent: Saturday, March 31, 2012 12:53 PM
To: excel-macros@googlegroups.com
Cc: dguille...@gmail.com
Subject: sumproduct.xlsx
Thanks for ur
Thanks Don & Mahesh
On Sat, Mar 31, 2012 at 11:44 PM, dguillett1 wrote:
> Copy/paste this into a module in an file saved as .xlsM
>
> Sub deleterowsif()
> For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1
> If Len(Application.Trim(Cells(i, 2))) < 1 _
>Or Cells(i, 1) = Cells(1, 1) Th
Copy/paste this into a module in an file saved as .xlsM
Sub deleterowsif()
For i = Cells(Rows.Count, 1).End(xlUp).Row To 2 Step -1
If Len(Application.Trim(Cells(i, 2))) < 1 _
Or Cells(i, 1) = Cells(1, 1) Then Rows(i).Delete
Next i
End Sub
Don Guillett
Microsoft MVP Excel
SalesAid Software
dgu
Thanks a lot got it...
On Sat, Mar 31, 2012 at 11:19 PM, Sam Mathai Chacko wrote:
> Errr... not sure what you meant by that. Like I said, it just means that
> all range of cells in Column D that are blank gets collected (set) in that
> range variable.
>
> Sam
>
>
> On Sat, Mar 31, 2012 at 11:11 P
Errr... not sure what you meant by that. Like I said, it just means that
all range of cells in Column D that are blank gets collected (set) in that
range variable.
Sam
On Sat, Mar 31, 2012 at 11:11 PM, vijayajith VA wrote:
>
> Thanks sam
>
> means same range suppose a1(blank cell) wil
Thanks sam
means same range suppose a1(blank cell) will search for a1 in other
workbook & get filled rite...
On Sat, Mar 31, 2012 at 10:43 PM, Sam Mathai Chacko wrote:
> It means that all blank cells from Column D are being set to that range
> variable
>
> Regards,
> Sam Mathai Chack
It means that all blank cells from Column D are being set to that range
variable
Regards,
Sam Mathai Chacko
On Sat, Mar 31, 2012 at 10:38 PM, vijayajith VA wrote:
> Hi,
>
> Set sourcerange = Columns("D").SpecialCells(xlCellTypeBlanks)
>
> Can any one explain above code?
> what does it mean?
>
Send your file to ME
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: finu kodokodan
Sent: Saturday, March 31, 2012 7:46 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ vlookup with more than one value
dear \mr don,
thanks for ur reply . but at
dear \mr don,
thanks for ur reply . but at lease one time to take the value . its not
working
On Sat, Mar 31, 2012 at 4:27 PM, dguillett1 wrote:
> =IF(COUNTIF($A$1:$A1,A11)>1,"",SUMPRODUCT(($A$1:$A$4=A11)*($B$1:$B$4)))
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@
Thanks Maries and Sam. Both the formula are working fine!!
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Sam Mathai Chacko
Sender: excel-macros@googlegroups.com
Date: Sat, 31 Mar 2012 13:24:18
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$E
=IF(COUNTIF($A$1:$A1,A11)>1,"",SUMPRODUCT(($A$1:$A$4=A11)*($B$1:$B$4)))
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: finu kodokodan
Sent: Saturday, March 31, 2012 4:21 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ vlookup with more than one
Hi,
Very sorry repeating the mail, iam unable to find the code to copy at my
original file.
Message run-time error 1004
Method onkey of object_application failed.
Thanks in advance
--
*Thanks & Regards,*
**
*Muralidhar E.*
On Sat, Mar 31, 2012 at 3:20 PM, Abhishek Jain wrote:
> There was
There was no code in this one under "ThisWorkbook" object. I have sent the
updated file which is working fine on your personal ID.
HTH
> On Sat, Mar 31, 2012 at 3:09 PM, muralidhar e wrote:
>
>>
>> Hi Abhishek,
>> Find the attached file, and the passward for macro is 151176.
>>
>> Thanks in ad
**please find the attachment . i am facing the problem for the repetation
On Fri, Mar 30, 2012 at 7:09 PM, dguillett1 wrote:
> Show AFTER examples and why
>
> Don Guillett
> Microsoft MVP Excel
> SalesAid Software
> dguille...@gmail.com
>
> *From:* rajeyssh
> *Sent:* Friday, March 30, 2012 6
I tested those and working fine even after closing and reopening the
workbook. Can you share your sample file which is giving problem?
On Sat, Mar 31, 2012 at 2:22 PM, muralidhar e wrote:
> Hi Abhishek,
>
> Its working fine, but when iam closed the file and reopen it is not
> working.
>
> Thanks
Hi Abhishek,
Its working fine, but when iam closed the file and reopen it is not working.
Thanks in Advance.
On Sat, Mar 31, 2012 at 1:29 PM, Abhishek Jain wrote:
> Dear Muralidhar,
>
> To my knowledge, there is not a direct way to disable a shortcut without
> using VBA. If you are still i
Thanks Maries. Will revert with feedback. Thanks
Sent from my BlackBerry® smartphone from Airtel Ghana
-Original Message-
From: Maries
Sender: excel-macros@googlegroups.com
Date: Sat, 31 Mar 2012 09:13:04
To: hilary lomotey;
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macro
Dear Muralidhar,
To my knowledge, there is not a direct way to disable a shortcut without
using VBA. If you are still interested, read on.
To disable, we can use this line - Application.OnKey "^d", ""
To enable it again - Application.OnKey "^d"
Now to make them work them unattended we can use as
I'd keep it short like this
Sub SheetAd()
Dim l As Long
For l = 1 To 100
Sheets("Sheet1").Copy , ActiveSheet
Next
End Sub
REgards
Sam Mathai Chacko
On Sat, Mar 31, 2012 at 1:11 PM, Asa Rossoff wrote:
> Sorry, Sandeep, I did not immediately see that you needed copies of anot
Thanks maries! I will check and send you the feed back.
Sandeep Chhajer.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Maries
Sender: excel-macros@googlegroups.com
Date: Sat, 31 Mar 2012 10:51:58
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$
Try this,
Sub Sheet1Multiplecopy()
Application.ScreenUpdating = False
Application.DisplayAlerts = False
For i = 1 To 100
Sheets("Sheet1").Copy After:=Sheets(i)
ActiveSheet.Name = i
Next
Application.ScreenUpdating = True
Application.DisplayAlerts = True
End Sub
On Sat, Mar 31, 2012 at 11:4
Sorry, Sandeep, I did not immediately see that you needed copies of another
sheet. Maries has you.
Asa
-Original Message-
From: Asa Rossoff [mailto:a...@lovetour.info]
Sent: Saturday, March 31, 2012 12:40 AM
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Macro for 100
I am out of the office until 16/04/2012.
Any queries please contact x54455
Note: This is an automated response to your message "$$Excel-Macros$$
Digest for excel-macros@googlegroups.com - 15 Messages in 10 Topics" sent
on 31/3/2012 12:54:40 AM.
This is the only notification you will receive
Hi Sandeep,
sheets.Add count:=100
Check help for additional options.
Asa
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of chhajersand...@gmail.com
Sent: Friday, March 30, 2012 11:11 PM
To: excel-macros@googlegroups.com
Subject: $$
30 matches
Mail list logo
