Hi Kris,
I don't have your code, Can you please forward?
Thanks,
Amar
On 09/02/2012, Kris wrote:
> Hi
>
> Have you tred mine ?
>
>
>
> --
> FORUM RULES (986+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need He
Hi Noorain,
I'm getting error ... Can you please try your code and check?
thanks,
Amar
On 08/02/2012, Kasireddy Amarender wrote:
> Thanks Noorain!
>
> Simple and Superb!
>
> On 08/02/2012, NOORAIN ANSARI wrote:
>> Dear Amarender,
>>
>> Please use it.
me
> Call SFile_Name
> Workbooks.Open SFileName
> End Sub
>
>
> On Wed, Feb 8, 2012 at 1:49 PM, Kasireddy Amarender
> wrote:
>
>> Hi Team,
>>
>> I would like to know if I can use the value of one procedure as input
>> to the other procedure.
>&g
Hi Team,
I would like to know if I can use the value of one procedure as input
to the other procedure.
For example:
I have a user form, it has two command buttons, the first one is
requesting for a file location(address/path) and the second does also
requesting another file location (address/pa
I vote for Noorain, yes - a superb guy with a expert thinking.
On 01/02/2012, Ayush Jain wrote:
> Hello Everyone,
>
> Noorain Ansari has been selected as 'Most Helpful Member' for the month of
> Jan'12
> He has posted 175 posts in Jan'12 and helped many people through his
> expertise. He has bee
ps.com
> Subject: RE: $$Excel-Macros$$ Excel - recording macro - help
>
> No,
> You can not record macro like this.. As noorain Explain in the example you
> can Execute any Exe File with shell Command..
>
> Rajan.
>
> -Original Message-
> From: excel-macros@goog
//excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/* <http://noorain-ansari.blogspot.com/>
>
> On Mon, Jan 30, 2012 at 11:48 AM, Kasireddy Amarender > wrote:
>
>> Hi Noorain,
>>
>> Thanks for your
Hi Noorain,
Thanks for your email.
Calc was just an example, I just wanted to know if I can see the code
... which is recorded outside the excel scope. is it possible?
Thanks,
Amar
On 30/01/2012, Kasireddy Amarender wrote:
> Dear all,
>
> My question may be strange and silly but
Dear all,
My question may be strange and silly but I thought I'll spell it
Can I record the macro outside the excel ?
For example, I'll start the macro recording and then minimize all my
applications and open calculator and then use some maths like 2+2, can
I see the code in my macro all th
oorain-ansari.blogspot.com/>
>>
>>
>> ** **
>>
>> On Thu, Jan 19, 2012 at 10:45 PM, Sourabh Salgotra
>> wrote:
>>
>> *
>> *
>> dear sir
>> plz tell me that how i can these fourmula on multiple match
>>
>> ** **
>>
>> like
>
; clr = clr + 10
> End If
> Next
> End Sub
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/* <http://noorain-ansari.blogspot.com/>
>
.
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/* <http://noorain-ansari.blogspot.com/>
>
> On Thu, Jan 19, 2012 at 2:25 PM, Kasireddy Amarender
&
Hi Experts,
I'm facing a problem in identifying duplicate names in a column.
Here is what I'm looking for.
If there are duplicates in column A i.e.
A1 = Amar
A2= Vijay
A3 = Suresh
A4 = Ravi
A5 = Amar
Then I would like to interior color A1 and A5 as they are duplicates,
I would like to use the
Hi Team,
I need your help in creating a user form.
Here is what I'm looking for.
I have some brands in Range("B1:B5") in Sheet1 and are in the order as below
Brand1
Brand2
Brand3
Brand4
Brand5
and some brands are present in sheet2 in the order different than sheet1 like
Brand5
B3
Brd2
Brand_4
Then
> MsgBox "Special Character " & spcl_chtr, vbInformation
> Else
> Exit Sub
> End If
> End Sub
>
>
> See attached sheet
>
> --
>
> Thanks & regards,
>
> Noorain Ansari
>
> <http://excelmacroworld.blogspot.com/> http://excelmacrowo
/excelmacroworld.blogspot.com/>
> *http://noorain-ansari.blogspot.com/* <http://noorain-ansari.blogspot.com/>
> On Tue, Jan 10, 2012 at 11:59 AM, Kasireddy Amarender > wrote:
>
>> Hi All,
>>
>> I would like to take your help in finding the special characters i
Hi All,
I would like to take your help in finding the special characters in a cell.
Here is the output I'm looking for.
B1 = XYZ_Apr'11
Then I should get a message box saying it has a special character (').
Similarly for all other special characters.
Here the special characters position is no
rksheet function for you
>
>
>
>
> 5
>
>
>
>
>
>
>
> 6
>
>
>
>
>
>
>
> 7
>
>
>
>
>
>
>
> 8
>
>
>
>
Hi Team,
I would like to know the options/code for performing some actions
based on the cell interior color.
for example
if cell A1 is of Green color I would like to print "Green Color" text in B1
if cell A1 is of Red color I would like to print "Red Color" text in B1
if cell A1 is of Yellow
Hi,
Can you please be more specific?
Can you give me an example of the output, like what are you expecting?
Thanks,
Amar
On 19/12/2011, Sara Lee wrote:
> i have two columns... zip code and the weights... i need to complete this
> sheet . i.e zip codes with starting from 1001 to 9 should
20 matches
Mail list logo