Dear,
Subu you can't delete addins permanently using tools menu. If you want to
remove it permanently goto bellow address:
C:\Documents and Settings\*Your User name*\Application Data\Microsoft\AddIns
In addins folder delete the addin you want to remove.
NOTE: You cannot delete inbuilt addins fr
hi
just wanted to ask how t make an addin and make it visible in excel 2007
and also can i use macro as add in or i have to create function to put as
add in
like a make a proper macro how can i put it as add in
Thanks all
Regards
Ashish
--~--~-~--~~~---~--~~
Hi Subu
This link can help you with
Step 1 - http://www.excelitems.com/2009/03/access-search-engines-on-browser.html
--
Thanks & Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.com
(Developer
Hi Subu,
1. Close all excel applications.
2. Go to this folder - "C:\Documents and Settings\
\Application Data\Microsoft\AddIns"
3. Delete the file(add-in) from here.
4. Re-open Excel and check.
Note: Replace with the username you're logged in.
e.g. if you login to system using administrator ac
Hi Folks
I have used an add-in on one of my sheets ... and now wish to remove
that
This is what I have done : Double click the add in sent here, opened
it on an active work book, saved the work book with the add in
This is what I see : Tools -> Add ins -> shows the name of this add in
This is
Hi,
I haven't tested this, but I think you need:
Range("data") = "=vlookup(R[-1]C,[" & CarrierGrid & "]OAK!L:R,7,False)"
ie, use square brackets instead of '
Regards - Dave
> Date: Tue, 8 Sep 2009 07:26:00 -0700
> Subject: $$Excel-Macros$$ Variable Workbook name used in range formula
>
Excel gurus,
Is there a precise formula to calculate the row height (in points or
pixels) from the font size?
Here are my specifics:
* Screen resolution is 96dpi
* Default font is Verdana 8pt
* Verdana font has an ascent of 1005 and a descent of -209 (total span
is 1214; 1.214em?)
With this in
i need to ask one question what if keys are alpha numaric
Regards
Santosh Bahuguna
On Sat, Sep 5, 2009 at 7:50 PM, Dilip Pandey wrote:
> Hi Madhur,
>
> Attached is the solution to your query along with the explanation. Thanks
>
> --
> DILIP KUMAR PANDEY
>MBA-HR,B COM(Hons.),BCA
> Mobile: +
Hi Prashant,Unfortunately, excel can show you first 100 unique entries only
in auto filter (It is hard coded in Excel)
Workaround can be pivot table.
On Tue, Sep 8, 2009 at 11:56 AM, Prashant Pednekar wrote:
> Dear all
>
> Thanks for the knowlege enrichment of excel by you all...
>
> I am faci
Follow below steps:
1. *Select table where blank cells exist.*
2. *Press "F5"*
3. *Click on "Special" and then "Blanks".*
4. *Enter "0" and press "Ctrl"+"Enter" simultaneously.*
U r done.
On Tue, Sep 8, 2009 at 3:10 PM, Ankur Satija wrote:
> How to put zero ('0') in Blank
Hi Sandeep,
I couldn't find any macro in the file.
Please check
On Tue, Sep 8, 2009 at 6:47 PM, Sandeep wrote:
> Hi Ashish,
> Check the result.
>
> Regards
> Sandeep
>
> - Original Message -
> *From:* Ashish Jain <26may.1...@gmail.com>
> *To:* excel-macros@googlegroups.com
>
I think you're missing the square brackets "[]".
I used:
Range("data") = _
"=VLOOKUP(RC[-1],'[" & CarrierGrid & "]OAK'!C1:C5,5,FALSE)"
and it worked great.
(try recording a macro where you insert the formula, then
replace the file name with the "& variable &" syntax.
Just leave the
Enter the following formula in cell J7 and copy it down:
=INDEX($C$6:$G$6,MATCH(I7,C7:G7,0))
Norman
On Tue, Sep 8, 2009 at 2:46 AM, gyanesh jain wrote:
>
> Hi friends,
> I have some Query related with Lookup. its in attachment.
>
> can any provide the solution?
>
> --
> Thanks,
> Gyanesh Jain,
I am currently creating an excel based estimating software and have
hit a brick wall.
Two-Fold Problem:
My current database format utilizes drop down items under each
estimate sub-item.
First I want to be able to, once an item is selected, have another
line automatically copy and paste the origi
Dear folks
Thanks for the help so far...
I wish to know if the following can be automated using VBA ?
Step 1 : I have a list of URL listed in a column. I wish to download
the contents of each of these pages one by one, i.e. without me
clicking on each URL...or cutting and pasting the sameon
Hi,
i've got the following problem :
We use excel files with many sheets, each containing a single pivot
table.
All tables on the different sheets (but same file) have the same
filters ( filtering years ) but different views.
If i have to change a filter ( eg. add a new year ) this only affects
a
Amazing.just amazing what is available here & the help from the
Gurus
Thanks !!
best regards
Subu
On Sep 8, 5:09 pm, "Mudassar Ramzan" wrote:
> Use attached Adds-On
>
> Regards,
>
> Mudassar Ramzan
>
> - Original Message -
> From: "Subu"
> To: "MS EXCEL AND VBA MACROS"
> Sent: M
Hello all, new to group! I will contribute as I am able, but to
start, I am really hoping someone can help me with a problem.
I have a named workbook as follows:
CarrierGrid = Range("O" & CStr(R)) & " " & Range("Control!B4").Value &
".xls"
This is giving me CarrierGrid as "HDMU 08.31.xls", whi
Hi Ashish,
Check the result.
Regards
Sandeep
- Original Message -
From: Ashish Jain
To: excel-macros@googlegroups.com
Sent: Sunday, September 06, 2009 10:06 AM
Subject: $$Excel-Macros$$ Puzzle #1 - Generate the Sample Pattern (VBA)
Hi All,
This is challenge for all exc
hi friends, when i m trying to access my webservice from excel using
soap toolkit by providing it the WSDL it is not able to locate the
webservice. Any idea why ? I am getting this issue.
thanks for the help in advance.
Note : I have a license Vista OS and a license Student license MSexcel
2003
Hi,
In excel 2003 the filter will show only the first 1000 results hence you
are not able to view data beyond 1000(but custom filters will work), where
as this problem will not be there in excel 2007,
Regards
Sathish Jalendran
From: excel-macros@googlegroups.com [mailto:excel-mac...@g
Dear Prasad,
Please try asap utility , its free add in to excel - link is
http://www.asap-utilities.com/download-asap-utilities.php
you should be done with it. Reply do u still face a problem
Regards,
Prashant
From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegrou
How to put zero ('0') in Blank Cells scattered in a table?
> -
> Ankur Satija, Consultant
>
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(V
Hi Lynn
You have the answer in your question.
You could use the function INDEX(array,row_number,[Column_num]), to
get the row_number and column number you could use the function Match
(lookup_value,lookup_array,match_type) where for match_type 0 = Exact
Match, 1 = Less than, -1 = Greater than.
Hi,
See if attached gives you what you need.
Regards - Dave.
From: gyanjai...@gmail.com
Date: Tue, 8 Sep 2009 12:16:25 +0530
Subject: $$Excel-Macros$$ Lookup Query
To: excel-macros@googlegroups.com
Hi friends,
I have some Query related with Lookup. its in attachment.
can any provide the soluti
Hi Prashanth
This could be the problem because on Worksheet "Book Master (2)" you
are using a custom filter which is "equals 3264".
Try is greater than OR
is greater than or equal to
This should resolve the issue. :)
Ewan
--~--~-~--~~~---~--~~
-
hi,
how do i match columnA in spreadsheetA with columnB in spreadsheetB to
find the value in columnD of spreadsheetB ?
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1.
Dear Ashish
There will be no problem with this.It will clear all emails.
On Mon, Sep 7, 2009 at 4:20 PM, ashish koul wrote:
> sorry i forget to ask u
>
> this that email can end with.net or .org. or.in etc.
>
> Thanks
>
> ashish
>
>
>
> >
>
--~--~-~--~~~---~--~
Hi friends,
I have some Query related with Lookup. its in attachment.
can any provide the solution?
--
Thanks,
Gyanesh Jain, BE, MBA (Finance)
+91 98868 68488
Please Save a tree...please don't print this e-mail unless you really need
to
--~--~-~--~~~---~--~~
29 matches
Mail list logo
