I am fresher to computer. I just have added a macro in Excel Addin in a
separate module. I am getting error No. 13, while running this. I want
to use this in all file. Kindly help me
Sub TEXTFILE()
Application.DisplayAlerts = False
Application.ScreenUpdating = False
On Error GoTo
*Can anybody solve this problem.*
On Mon, Dec 3, 2012 at 10:04 AM, Pravin Gunjal isk1...@gmail.com wrote:
*Hello,*
*Can anybody help me to get the solution. Thanks.*
*
*
*Regards / Pravin
*
-- Forwarded message --
From: Pravin Gunjal isk1...@gmail.com
Date: Sat, Dec 1,
PFA workbook for sample design to copy files from one directory to another.
Please help me to get the same.
--
Thanks Regards,
Ganesh
--
Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread
Dear Group,
Please find attached sample sheet, where vlookup is working on duplicate
Data.
Kindly suggest, how can we make it more dynamic.
--
With Regards,
Noorain Ansari
http://
http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com
http://
Noorain,
In what way do you wish to make it more dynamic?
How do you use this?
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as
below is the solution if i understood your requirement correctly
=IFERROR(INDEX(G$5:G$11,SMALL(IF(F$5:F$11=I$5,ROW(F$5:F$11),),ROW()-4)-4),)
with CSE
pfa
On Tue, Dec 4, 2012 at 6:19 PM, Paul Schreiner schreiner_p...@att.netwrote:
Noorain,
In what way do you wish to make it more dynamic?
I'm sorry to say that I've never heard of an application that can do as you ask.
I would think it would be very difficult to interpret the macros.
yes, the macro can record that you selected a cell.
But it unless you've named the range that you're selecting,
the macro doesn't know what the cell
Thanks Viper for your nice solution,
Generally we do it through Index, but we want to do it through Vlookup and
it should work like Index, Pls suggest.
*Aside to Paul Sir* : we want to make red colored part as dynamic in below
mentioned formula
Even though this forum provides a TREMEDOUS service
and makes getting assistance convenient.
I've many times expressed that the use of the written word
actually makes providing this type of help more DIFFICULT!
When asking for help, we tend to forget that what WE see on the screen
isn't seen
can i please get access to the quiz questions again? thanks!
On Saturday, November 10, 2012 1:13:08 PM UTC+1, Ayush Jain wrote:
Hello everyone,
Here is another quiz for you to test VBA basics. There are 10 multiple
choice questions in the quiz and should not take more than 5 minutes to
Hearty Congratulation Paul..
With the help of expertise. I started teaching Basic Excel to my friends
Thanks
Manjunath
From: Ayush Jain jainayus...@gmail.com
Sender: excel-macros@googlegroups.com
Date: Mon, 3 Dec 2012 23:58:06 +0530
To:
Hey
dats good news Manjunath..
Keep sharing
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Manjunath Narayanappa manjunath.narayana...@aon.co.uk
Sender: excel-macros@googlegroups.com
Date: Tue, 4 Dec 2012 15:07:17
To:
Hi,
Pls help me solve my query.
Pls find the file attached.
Thanks,
Kenil
--
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,
Hi Noorain Sir,
Below mentioned your requirement and find the attachment.
=IFERROR(VLOOKUP($I$5,INDIRECT(FSMALL(IF($F$5:$F$11=$I$5,ROW($F$5:$F$11)),ROW(A1)):$G$11),2,0),)
*Regards,*
*
*
*Excel Beginner*
*
*
On Tue, Dec 4, 2012 at 6:04 PM, NOORAIN ANSARI
Hi -
I have a spreadsheet in which I have the following formula for statistical
testing, =IF(L7=$S$2,CHAR(233),IF(L7=-$S$2,CHAR(234),)). It displays an
up arrow if the first IF statement is true and an down arrow if the second
IF statement is true. I would like the arrow displayed to be
Hi Paul,
thanks a lot for your detailed explanation
From: Paul Schreiner schreiner_p...@att.net
To: excel-macros@googlegroups.com
Sent: Friday, 30 November 2012 7:48 PM
Subject: Re: $$Excel-Macros$$ Scraping data from image
Here's the long version of
hearty congratulations Paul. i would like to know your blog link if you post
the blogs.
your knowledge is tremendous.
From: Ayush Jain jainayus...@gmail.com
To: excel-macros excel-macros@googlegroups.com
Sent: Monday, 3 December 2012 11:58 PM
Subject:
You need to create two conditional formats, one for the up arrow and one
for the down arrow.
In Excel 2010:
For the up arrow:
Select the range starting on cell L7
Go to Home - Conditional Formatting - New Rule - Use a formula to
determine which cells to format
Write =L7=$S$2 on the 'Format
Thanks Mr. Paul
No need to say Sorry. You helped me a lot. This macro is running perfectly
now.
Thanks a lot once again.
Regards
Amit
On Tue, Dec 4, 2012 at 6:04 PM, Paul Schreiner schreiner_p...@att.netwrote:
Amit,
Sorry,
Since I didn't know how large your data set would end up being,
*Really a very good information. *
*Thanks,*
*
*
*Regards / Pravin.*
-- Forwarded message --
From: Paul Schreiner schreiner_p...@att.net
Date: Fri, Nov 30, 2012 at 7:48 PM
Subject: Re: $$Excel-Macros$$ Scraping data from image
To: excel-macros@googlegroups.com
--
Join official
Congrats Paul
On Wed, Dec 5, 2012 at 2:08 AM, hanumant shinde arsfan2...@yahoo.co.inwrote:
hearty congratulations Paul. i would like to know your blog link if you
post the blogs.
your knowledge is tremendous.
--
*From:* Ayush Jain jainayus...@gmail.com
*To:*
Hi Anoop,
that was easy, however if you click on + of the outline, that does not
work when the sheet is protected. This is the problem and i need to make
that work with your help.
regards,
Zeeshan
On Wed, Dec 5, 2012 at 10:47 AM, Anoop K Sharma aks.sharm...@gmail.comwrote:
Hi Zeeshan,
22 matches
Mail list logo