Noorin Sir
Please send send VBA Ebook 2007(O'Rellay) on your email ID
exceller...@gmail.com
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advic
Hi Noorain,
Please send to my mail id
Regards,
Santhosh
On 5/30/12, vijayKumar wrote:
> Hi Noorain,
>
> Please send me the files at
> midearfam...@gmail.com
>
> Regards
> Vijay
>
> On Wed, May 30, 2012 at 11:27 AM, ashwani agnihotri <
> ashwani.agniho...@gmail.com> wrote:
>
>> Hi Noorain,
>>
>
Hi Noorain,
Please send me the files at midearfam...@gmail.com
Regards
Vijay
On Wed, May 30, 2012 at 11:27 AM, ashwani agnihotri <
ashwani.agniho...@gmail.com> wrote:
> Hi Noorain,
>
> plz send me the files at ashwani.agniho...@gmail.com
>
> thanks...
>
>
> On Wed, May 30, 2012 at 10:48 AM, An
Hi Noorain,
plz send me the files at ashwani.agniho...@gmail.com
thanks...
On Wed, May 30, 2012 at 10:48 AM, Anirban Roy wrote:
>
> Noorain Bhai,
>
> Please send it to me, I'll be thankful to you.
>
> With Best Regards
> Anirban
>
> --
> FORUM RULES (986+ members already BANNED for violation
Noorain Bhai,
Please send it to me, I'll be thankful to you.
With Best Regards
Anirban
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice w
It is showing without manual extaction.
What do u want specify in brief
Regards,
Gawli Anil
On Wed, May 30, 2012 at 5:36 AM, pawel lupinski wrote:
> Dear All,
>
> I have a problem with adjusting graph, if you can look inside the file and
> advice I'll be appreciated.
>
> Regards,
>
> Pawel
Sir, i dont have any tool for breaking password. If you have any set up you
can let me know, or else, Please share the file without password. thank you
Rajan Sir.
Thanks & Regards,
*Deba Ranjan P*
On Tue, May 29, 2012 at 6:05 PM, Rajan_Verma wrote:
> ** **
>
> Sorry I forget that passw
Noorain Sir,
Can you please send me the file too in my mail ID, the file that you share
with Mangesh.
mail:- drdeva...@gmail.com
Thanks & Regards,
*Deba Ranjan P*
On Wed, May 30, 2012 at 8:25 AM, NOORAIN ANSARI wrote:
> Hi Joseph,aruna,lupinskip and anjali,
>
> I have send VBA Ebook
Hi Joseph,aruna,lupinskip and anjali,
I have send VBA Ebook 2007(O'Rellay) on your email ID.
Pls check and confirm.
--
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.excelmacroworld.blogspot.com
>
>
> FORUM RULES (986+ members already BANNED for violation)
>>>
>>> 1) Use co
Hi Noorain
Please send the files
thanks
Pawel
From: Aruna jayaram
To: excel-macros@googlegroups.com
Sent: Tuesday, May 29, 2012 8:29 PM
Subject: Re: $$Excel-Macros$$ MACRO
Hi Noorain
Please send the files for excel 2007.
thanks
On Tue, May 29, 2012 a
I would recommend that the defined name be flexible to include
additions/deletions.
=OFFSET(Data!$C$3,1,0,MATCH("zzz",Data!D:$C)-3,1)
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Bé Trần Văn
Sent: Tuesday, May 29, 2012 2:50 PM
To: excel-macros@googlegroups.com
Hi Noorain
Please send the files for excel 2007.
thanks
On Tue, May 29, 2012 at 3:31 PM, NOORAIN ANSARI wrote:
> Dear Sagar,
>
> Please find attached study material of Basic Macro and follow excel-macro
> group on regular basis.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari
Hi
Can you pls send the files for excel 2007.
On Tue, May 29, 2012 at 3:31 PM, NOORAIN ANSARI wrote:
> Dear Sagar,
>
> Please find attached study material of Basic Macro and follow excel-macro
> group on regular basis.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainansari.com
> www.
Please send it to me at josephcam...@yahoo.com
Thanks,
Joseph
Sent on my BlackBerry® from Vodafone
-Original Message-
From: NOORAIN ANSARI
Sender: excel-macros@googlegroups.com
Date: Tue, 29 May 2012 18:26:24
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ MAC
Hey Sam
Thanks a lot for the prompt clarifications. Hope to use it soon. -:)
Thanks
Ashish Pradhan
On 30-05-2012 00:23, Sam Mathai Chacko wrote:
Ashish,
Yes this can be used for Windows 7. The only reason I thought Windows
7 users may not find it too useful is because Windows 7 start menu
Ashish,
Yes this can be used for Windows 7. The only reason I thought Windows 7
users may not find it too useful is because Windows 7 start menu already
has similar features which helps in quickly opening recent files.
No I haven't added a feature to delete history. For the time being, I think
I
Hello Sam
Haven't yet installed this tool. I use Windows 7 (and I believe this
wouldnt be applicable for windows 7). Have seen the screenshot. Looks
good but have a couple of perhaps stupid questions.
1. Can this file history be cleared ?
2. Can this be un-installed ? (Which leads me to the
See the attached file, Just Type the domain Name and Hit enter
In worksheet Module
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row = 5 And Target.Column = 2 Then
Application.EnableEvents = True
Call Extract
Application.EnableEvents = True
Hi Rajan,
Please find the sheet consists of sample data on sheet2.
Thanks
ManGesh
On Tue, May 29, 2012 at 9:25 PM, Rajan_Verma wrote:
> Can u explain with data?
>
> ** **
>
> * *
>
> *Regards*
>
> *Rajan verma*
>
> *+91 7838100659 [IM-Gtalk]*
>
> ** **
>
> *From:* excel-macros@googleg
Hey
Thanks Don and CoRe for the prompt replies. Am going ahead with the
multiple installations. Hope all goes well. :-)
Thanks
Ashish Pradhan
On 29-05-2012 20:25, dguillett1 wrote:
Just install in a directory OTHER than the previous verion. ie:
MyExcel2010
Don Guillett
Microsoft MVP Exce
Can u explain with data?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Mangesh Dayne
Sent: 29 May 2012 7:32
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need help for Domain Codes
Smitha,
Using developer tab Insert Combo box from Activex controls.
Then right click on the combo box, select properties. Now write the
source opposit to "Listfillrange". It works
Thanks,
Naresh V
On Tue, May 29, 2012 at 10:04 AM, Bé Trần Văn wrote:
>
>
> 2012/5/29 Mangesh Dayne
Just install in a directory OTHER than the previous verion. ie: MyExcel2010
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: Ashish Pradhan
Sent: Tuesday, May 29, 2012 9:16 AM
To: Excel Macros
Subject: $$Excel-Macros$$ Multiple Versions of Excel
Hello
I currently
Hello Ashish,
I had installed 2003/2007 excel versions and i haven't meet any crashes ,
now i have excel 2007 ver. and access 2003 ver.
to have both version installed on your machine , you need to change folder
destination.
On Tuesday, May 29, 2012 5:16:40 PM UTC+3, Ashish wrote:
>
Hello
I currently have installed Excel 2003 on my machine. However would also
like to install 2010 now. If I change the default destination path, will
it create any problems? Will I be easily able to open any excel file
without any "Version Clash issues"
I understand that very recently, som
Hi Friends,
I need your help for Domain Codes search for file.
Please find the attached sheet.
With regards,
MAnGesh
--
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, C
Noorain bhai,
Dhanyawad Kya kahu... Agar dhanyawad ki hi bat hai to hamesha yahi dil se
kahta rahunga...
"U R SIMPLY OXYGEN OF THIS GROUP DEAR"
with regards,
MangEsh.
On Tue, May 29, 2012 at 6:35 PM, Rajan_Verma wrote:
> *I just study Excel 2003 Power programming with VBA by J-Walk when I
> s
Only gets the numbers left of text
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
From: vijayajith VA
Sent: Tuesday, May 29, 2012 8:19 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to collect only numeric value from a
particular cell
Hi,
You
The link provided below has a lot to do with the CALL function which is not
supported in latest versions of Excel. If you want to learn about XLM
functions (Excel4), try this link which has an in-depth explanation of the
GET.DOCUMENT and GET.CELL functions
http://www.excelfox.com/forum/f13/excel-m
But it's not giving correct answer
See the attached sheet
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of vijayajith VA
Sent: 29 May 2012 6:49
To: excel-macros@googlegroups.com
Subject: Re: $$Exce
Great J
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of vijayajith VA
Sent: 29 May 2012 6:49
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ How to collect only numeric value from a
pa
It's a best way what you are doing.
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Amit Desai (MERU)
Sent: 29 May 2012 3:30
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Convert .xls fi
I just study Excel 2003 Power programming with VBA by J-Walk when I started
to learn VBA
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of SAGAR KASANGOTTUWAR
Sent: 29 May 2012 2:28
To: excel-macros@goo
Dear Mangesh,
File is heavy so, I have send u on your email ID
Please check.
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Tue, May 29, 2012 at 6:11 PM, Mangesh Dayne wrote:
> Hi Noorain,
>
> Send same for Excel 07 Please.
>
> Thanks
>
> MAnGesh
Try this:
=SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUT
E(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1,1,""),2,""),3,""),4,""),5,""),6,""),7,
""),8,""),9,""),0,"")
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-
Hi Noorain,
Send same for Excel 07 Please.
Thanks
MAnGesh
On Tue, May 29, 2012 at 3:31 PM, NOORAIN ANSARI wrote:
> Dear Sagar,
>
> Please find attached study material of Basic Macro and follow excel-macro
> group on regular basis.
>
>
> --
> Thanks & regards,
> Noorain Ansari
> www.noorainans
Good Logic, DON Sir
*If Not Mid(rng, i, 1) Like "[!0-9]" Then*
On Tue, May 29, 2012 at 6:08 PM, dguillett1 wrote:
> Use this simpler function in a REGULAR module for only numbers. For
> only text simply remove the NOT
> It will work with all strings such as
>12abc34de56fgh78ijk9
>
> Functi
Use this simpler function in a REGULAR module for only numbers. For only text
simply remove the NOT
It will work with all strings such as
12abc34de56fgh78ijk9
Function ONSAS(rng As Range)
Dim i As LONG
For i = 1 To Len(rng)
If Not Mid(rng, i, 1) Like "[!0-9]" Then
ONSAS = ONSAS & Mid
Sorry I forget that password L if you have any tool to break the password
will be good for you J
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Deba Ranjan
Sent: 29 May 2012 10:11
To: excel-macro
If Name of Range is "rngRange" then
Sub AddRowinNameRange()
Range("rngRange ").Resize(Range("rngRange ").Rows.Count + 1).Name = "
rngRange "
End Sub
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Beh
2012/5/29 Anil Gawli
> Goto file option and select customize ribbon and click on choose
> commands from.
> Then select All tabs and transfer Develper tab to customize ribbon.
> Then goto insert combo box
> Regards,
> Gawli Anil
>
>
> On Tue, May 29, 2012 at 1:41 PM, Smitha S R wrote:
>
>> Hi a
Dear Sir,
I have go through the below mentioned link. but i can not understand.
Would you
please explain why we need to use the *=Get.cell(24,indirect("RC[-1]",))
function? Another how to use the formula in other sheet.
regds,
sanjib
*
On Tue, May 29, 2012 at 3:26 PM, NOORAIN ANSARI wrote:
Dear Danial,
Best Resource of Excel4 Function is :
*http://www.cpearson.com/excel/Call.htm*
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Tue, May 29, 2012 at 3:35 PM, danial mansoor wrote:
> how can we get excel 4 functions?any resource?
>
>
Dear Amit,
Please See attached sheet, I hope your requirement is this one otherwise
revert.
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Tue, May 29, 2012 at 12:48 PM, Amit Gandhi wrote:
> Thanks Noorain
>
> But i need something else. Let me cl
how can we get excel 4 functions?any resource?
Date: Tue, 29 May 2012 15:31:25 +0530
Subject: Re: $$Excel-Macros$$ MACRO
From: noorain.ans...@gmail.com
To: excel-macros@googlegroups.com
Dear Sagar,
Please find attached study material of Basic Macro and follow excel-macro
group on regular ba
Hi Masters,
How to convert .xls file to .xlsx?
I have xls file of size of say 42 MB, but once i open it do save as to .xlsx it
gets saved with size of say 4 or 5 MB. Is there any shorter way to save it as
.xlsx without opening the file?
Best Regards,
Amit
Dis
Dear Pavan,
Please share a sample workbook with group.
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Tue, May 29, 2012 at 3:23 PM, Pavan Chowdary
wrote:
> Hi Guys,
>
> This is pavan. here i need som info that is it possible to replace fill in
>
Dear Sanjib,
Please check below link..*
*Hope it will help you to use Get.Cell Function.
*
http://www.sulprobil.com/html/get_cell.html*
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Tue, May 29, 2012 at 3:23 PM, Sanjib Chatterjee <
chatterjee.kol
Check mails of this group.
It has been already answered some days before.
ManGesh
On Tue, May 29, 2012 at 1:36 PM, Smitha S R wrote:
> Hi,
>
> I have a drop down list which is created using menu 'data validation'.
>
> Is it possible to get the items in the first line in the drop down while
>
Dear Nooranin Ansari,
This is working fine. But would you explain the below mentioned formula.
You have mentioned the formula outside the date zone even. If i want to
use the formula
in another sheets how to use it?
Waiting for you reply.
Regards,
Sanjib
On Tue, May 29, 2012 at 3:08 PM, N
Dear Pavan,
Please use..
Sub Close_excelApplication()
Application.Quit
End Sub
--
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Tue, May 29, 2012 at 3:18 PM, Pavan Chowdary
wrote:
> Hi,
>
> This is pavan.
> Here i had a doubt. is there any vba co
Hi Guys,
This is pavan. here i need som info that is it possible to replace fill in
a cell with another specified fill through macro. here one problem is we
don't know which cells we have to replace. the range is not fixed. macro
have to seerch entire workbook and replace existing know fill wit
Dear Mansoor,
Please check below link..
*http://www.sulprobil.com/html/get_cell.html*
Thanks & regards,
Noorain Ansari
www.noorainansari.com
www.excelmacroworld.blogspot.com
On Tue, May 29, 2012 at 3:10 PM, danial mansoor wrote:
>
> how do u know abt this get function?wat it does?and plz let m
Hi Smitha,
MS Excel: Creating a combo box in Excel 2003/XP/2000/97
--
Question: I'm trying to create pull down boxes in Excel 2003/XP/2000/97
with selections to highlight and fill in the cell. How do I do that?
Answer: To create a combo box in Excel, the first thing
how do u know abt this get function?wat it does?and plz let me know how can we
know abt these functions.?
Date: Tue, 29 May 2012 15:08:34 +0530
Subject: Re: $$Excel-Macros$$ regarding font color based condition
From: noorain.ans...@gmail.com
To: excel-macros@googlegroups.com
Dear Sanjib,
Ple
Hi Smitha,
Use data validation from Excel.
MAngesH
On Tue, May 29, 2012 at 2:01 PM, Smitha S R wrote:
> How we can place a combo box in excel work sheet?
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Pleas
Dear All,
I want to learn MACRO's from basic so kindly give me some material for the
same.
Thanks & Regards,
K SAGAR
--
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, C
On Tue, May 29, 2012 at 12:55 PM, Ahmed Honest wrote:
> Dear Amit,
>
> Use the Drop Down list options which is available in the Data Validation.
> I hope you know it. If not just google how to create drop down list you
> shall get the desired that you are looking for.
>
> Or revert to the group t
Goto file option and select customize ribbon and click on choose commands
from.
Then select All tabs and transfer Develper tab to customize ribbon.
Then goto insert combo box
Regards,
Gawli Anil
On Tue, May 29, 2012 at 1:41 PM, Smitha S R wrote:
> Hi anil,
>
> How you placed the combo box in E
How we can place a combo box in excel work sheet?
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
quick attention or may not b
Hi anil,
How you placed the combo box in Excel?
On Fri, May 25, 2012 at 1:27 PM, Smitha S R wrote:
> Is this possible in dropdown list as you have prepared using combo box?
>
>
> On Tue, May 22, 2012 at 10:05 AM, Anil Gawli wrote:
>
>> your attached file is corrupted and cannot be opned?
>>
Hi,
I have a drop down list which is created using menu 'data validation'.
Is it possible to get the items in the first line in the drop down while
start entering the letters of the items.
Eg: Item Pen, pencils, Notepad is there in my drop down list, if I start
entering P itself Pen and pencils
Dear Amit,
Use the Drop Down list options which is available in the Data Validation. I
hope you know it. If not just google how to create drop down list you shall
get the desired that you are looking for.
Or revert to the group to help you out with this.
Thanks,
On Tue, May 29, 2012 at 10:18
Thanks Noorain
But i need something else. Let me clarify more. I am attaching revised
excel file.
I have some BL numbers in 2nd sheet "BL_list" and I want to enter Invoice
details (INV#, INV DATE, INV AMT) against some B/L#s. I want to choose B/L#
in each cell C5, C6, C7 ... from available li
Lakshman ( & Deba ) - Rajan posted an excellent formula for extracting all
the numbers already.
Make sure to enter his formula with ctrl-shift-enter (it's an array
formula). It is for Excel 2007+ only because it uses the IFERROR function.
Here is a version modified slightly to work in olde
65 matches
Mail list logo
