Hi Noorain,
It works. Thanks a lot for your support
On Tue, Aug 9, 2011 at 12:13 PM, NOORAIN ANSARI wrote:
> Dear Peer Mohd,
>
> Please see attached sheet
>
> On Tue, Aug 9, 2011 at 11:46 AM, Shiek Peer Mohd wrote:
>
>>
>> Hi Experts,
>>
>> I have the issues in using the multipl
See if it helps , but Scop of this macro is only only Worksheet.
Sub matchValue()
' Short CUt Key Shift + CTRL + M
Application.ScreenUpdating = False
Dim F_range As Range
Dim S_range As Range
On Error Resume Next
Set F_range = Application.InputBox("Please Select 1st Range", , , , , , ,
You need to post examples, etc.
From: Rajendra prasad yadav
Sent: Monday, August 08, 2011 1:31 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Help needed. compare two wxcel files
Hi friends,
I am not good at excel. I have a requirement now, Can some one please give the
macro t
Homework?
-Original Message-
From: XLS S
Sent: Monday, August 08, 2011 3:38 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Question
Q-1 )Can I write VBA code to protect or unprotect my VB Project?
Q-2) Why does Excel have two macro languages?
Q-3) Can I loc
Right click sheet tab>view code>insert this. Now when you put 149 in col A
col B will populate
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row < 2 Or Target.Column <> 1 Then Exit Sub
Target.Offset(, 1) = "#" & Target & " Story"
End Sub
-Original Message-
From: deej10
What do you need to do in Word that you can't do in excel?
-Original Message-
From: skyping1
Sent: Monday, August 08, 2011 12:07 PM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets
labelled 1 to X to Word.
Anyone have any ideas on this
*Hi ,*
*
*
*Look below link it may help u*
http://www.excelforum.com/excel-programming/392497-project-is-unviewable.html
http://support.microsoft.com/kb/q229499/
*Best Regards,*
*Venkat *
*Chennai*
On Tue, Aug 9, 2011 at 3:30 AM, hanumant shinde wrote:
> Hi how to make project unviewable i
*
Hi ,
Try Below see if helps else please attach some sample workbook
**="#"&A1&" "&"Story"*
*Best Regards,*
*Venkat *
*Chennai*
On Tue, Aug 9, 2011 at 12:07 AM, deej109 wrote:
> I have two adjacent columns of consecutive numbers, spaced several
> rows apart each. For example:
>
> A
check this
http://www.rondebruin.nl/notes.htm
On Mon, Aug 8, 2011 at 3:23 PM, Chandra Shekar wrote:
> Hi,
>
> Please find attached file I have code to send mail to lotus notes id. Here
> I need range from A1:E6 pasted as object as in the body of notes as shown in
> attached file.
>
> Please
Hi how to make project unviewable i.e. when we do Alt+F11 and try to expand the
code it shows below pop up.
i have a file which if i try to open shows pop up saying "project is unviewable"
i tried to send the file but i cannot attach it. i think this is 1 more
functionality.
that excel file ge
Q-1 )Can I write VBA code to protect or unprotect my VB Project?
Q-2) Why does Excel have two macro languages?
Q-3) Can I lock cells such that only specific users can modify them?
Q-4) When I enter a value, it appears with two decimal places. For
example, when I enter 123 it shows u
Hi friends,
I am not good at excel. I have a requirement now, Can some one please give
the macro to compare two worksheets in diferent workbooks and display the
differences.
Regards,
Rajendra
8147524172
--
--
Some i
I have two adjacent columns of consecutive numbers, spaced several
rows apart each. For example:
A B
149 | #149 Story
150 | #150 Story
I know how to create consecutive numbers in column A. Is there a way
to automatically populate the numbers in column B? Is there a way to
combine
I think a "One point lesson" on this add in would be highly welcome.
Thanks
On Aug 8, 10:27 am, Anil Bhange
wrote:
> Hi Rajan,
>
> Still I am not able to do with this addin, find below screen preview
> [cid:image001@01CC5605.69E40C40]
>
> Regards, Anil Bhange
> IP Phone - 512320 | Mobile -
Anyone have any ideas on this please?
On Aug 3, 9:50 pm, Kevin gray wrote:
> Please see attachments
>
> Date: Wed, 3 Aug 2011 07:48:44 +0530
> Subject: Re: $$Excel-Macros$$ Code need to Transfer Excel worksheets labelled
> 1 to X to Word.
> From: venkat1@gmail.com
> To: excel-macros@googlegr
Hi Lucky,
First you have to determine your requirement...and then you have decide
which software is convinent to perform
the Operation it's if Windows based application you may Try VB,
If web projects try in JAVA ,.NET like that...Same DB Like SQL,ORACLE,OR MS
Access..
*Best Regards,*
*Venkat *
Thank you raj for your help
On Sun, Aug 7, 2011 at 8:04 PM, Rajan_Verma wrote:
> *See this Function :*
>
> * *
>
> *if sum of any Two cell in selected Range is Equal to Given Value in
> Second Parameter of Function then Function will Return the Address of that
> Two Cells, here Flag will be T
Read this Small Book
http://devedzic.fon.rs/publications/SEKE-Handbook-2.pdf
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of lucky
Sent: Saturday, August 06, 2011 7:53 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$ Infor
See if it helps
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sundarvelan N
Sent: Monday, August 08, 2011 4:01 PM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Urgent Help Graph
Hi Friends,
I need one help.
I have 5 to 6 graphs
Hi Sundarvelan ,
Look attached it May help u...
*Best Regards,*
*Venkat *
*Chennai*
On Mon, Aug 8, 2011 at 4:01 PM, Sundarvelan N wrote:
> Hi Friends,
>
> I need one help.
>
> I have 5 to 6 graphs in a sheet. On clicking a combo box respective graph
> should pop up. Please help me.
> Thanks
See if it helps
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Venkat CV
Sent: Monday, August 08, 2011 11:37 AM
To: Google
Subject: $$Excel-Macros$$ While Using Vlookup Insted of Zero need Blanks...
Dear All,
Find attached query regarding While U
See if it helps
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Sara Lee
Sent: Monday, August 08, 2011 12:32 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ urgent macro or template r eq
i have a table in excel like below
volume
Hi Friends,
I need one help.
I have 5 to 6 graphs in a sheet. On clicking a combo box respective graph
should pop up. Please help me.
Thanks
N.Sundarvelan
9600160150
--
--
Some important links for excel users:
1. Fo
Thank You so much. It is a great start. You are gwonderful!!!. Do i have
to keep the source sheet (data) in the same file as the macro? or can i
seperate them and put them in different files but in a common folder ?
On Sun, Aug 7, 2011 at 10:29 PM, ashish koul wrote:
>
> try this
>
> we can ma
Dear Ashish,
WorkingThank you
Dear Noorain,
Ashish's formula WorkingThanks for your try.
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Mon, Aug 8, 2011 at 12:33 PM, ashish koul wrote:
> IF(NOT(ISERROR(VLOOKUP(I3,$B$3:$C$14,2,0))),IF(VLOOKUP(I3,$B$3:$C$14,2,0)="","",VLOOKUP(I3,$B
Dear Seraj,
Please don't keep in loop of excel-macros group's mail in chain mail.
This group is dedicated for only Excel,Macro and Access.
Thanks & regards,
Noorain Ansari
2011/8/7 seraj alam
>
>
>
>
> जो मुरझाये ना कभी वो कवल है दोस्ती.
> दिल के पवित्र ख्यालों की पहल है दोस्ती.
> दोस्ती दोस्
जो मुरझाये ना कभी वो कवल है दोस्ती.
दिल के पवित्र ख्यालों की पहल है दोस्ती.
दोस्ती दोस्तों के दम से निभाई जाती है,
मिले आप जैसे दोस्त तो सफल है दोस्ती.
खुदगर्ज दोस्त हो तो गन्दी नाली है दोस्ती,
सच्चे दोस्त के खातिर गंगाजल है दोस्ती.
रिश्तों में सबसे ऊँचा दर्जा है दोस्ती का,
थोड़ी शोख,थोड़ी नटखट, थोड़
Dear Venkat try it
=IF(OR(VLOOKUP(F3,$B$3:$C$14,2,0)=0,VLOOKUP(F3,$B$3:$C$14,2,0)=""),"",VLOOKUP(F3,$B$3:$C$14,2,0))
On Mon, Aug 8, 2011 at 12:22 PM, Venkat CV wrote:
> Dear Noorain,
>
> Thanks for your Try...
> The Below Formula is working for Cell is Blank...
>
> But If cell Value is 0 That's
IF(NOT(ISERROR(VLOOKUP(I3,$B$3:$C$14,2,0))),IF(VLOOKUP(I3,$B$3:$C$14,2,0)="","",VLOOKUP(I3,$B$3:$C$14,2,0)),"Not
Found")
On Mon, Aug 8, 2011 at 12:22 PM, Venkat CV wrote:
> Dear Noorain,
>
> Thanks for your Try...
> The Below Formula is working for Cell is Blank...
>
> But If cell Value is 0 Tha
Hi Venkat,
Actually I need the facility where I could able to select multiple ranges as
per my requirement, and able to generate the report based on all ranges columns.
Regards,Anil Bhange
IP Phone - 512320 | Mobile - 90290 32123
From: excel-macros@googlegroups.com [mailto:excel-macros@goog
30 matches
Mail list logo
