Dear Amit,
Please find full fath of Personal Macro File..
1. C:\Program Files\Microsoft Office\Office12\XLSTART
2. Press Alt+F11, Go to File-Import Option to Transfer Macro file.
Thanks regards,
Noorain Ansari
On Tue, Aug 16, 2011 at 11:13 AM, Amit Desai (MERU) amit.de...@merucabs.com
*Hi Amit,*
*
*
*See the below path*
*
*
*C:\Documents and Settings\vcc7328\Application
Data\Microsoft\Excel\XLSTART\PERSONAL.XLSB*
*
*
*Login ID:vcc7328*
*
*
*For 2007 2010...*
*Best Regards,*
*Venkat *
*Chennai*
*
*
On Tue, Aug 16, 2011 at 11:33 AM, NOORAIN ANSARI
This one helped thanks...
Best Regards,
Amit Desai
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Venkat CV
Sent: Tuesday, August 16, 2011 11:41 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Export of Personal Macro Book
Hi Amit,
Congrats to my lovely friend.. Hey Rajan... carry on your
social work dude.
On Aug 5, 11:08 pm, Manish pansari.man...@gmail.com wrote:
CongratulationsRajan... :)
-
Manish
On Aug 5, 9:37 pm, neil johnson neil.jh...@googlemail.com wrote:
CongratulationRajan.
On
Hello to Excel Experts and other users of this group.
I've been looking everywhere about how to put several criteria in
different cell ranges in:
DSUM(database, field, criteria).
I have a very large database and using Dsum and I am using different
different criteria in different different
Welcome
On Tue, Aug 16, 2011 at 11:55 AM, Amit Desai (MERU) amit.de...@merucabs.com
wrote:
This one helped thanks…
** **
Best Regards,
Amit Desai
** **
** **
*From:* excel-macros@googlegroups.com [mailto:
excel-macros@googlegroups.com] *On Behalf Of *Venkat CV
hi chandar
i tried it its working fine also ur code is password protected .can u
unlock it and send it again
On Tue, Aug 16, 2011 at 12:43 PM, Chandra Shekar
chandrashekarb@gmail.com wrote:
Hi Ashish,
Please find attached file and kindly do the needful. Thanks in advance.
On Tue,
*Hi Sharma,*
*
*
*See if Helps*
*
*
*http://www.mrexcel.com/forum/showthread.php?t=58539*http://www.mrexcel.com/forum/showthread.php?t=58539
On Tue, Aug 16, 2011 at 12:53 PM, B Sharma sharma@gmail.com wrote:
Hello to Excel Experts and other users of this group.
I've been looking
Dear Daniel
Very very thanks for kind help
There is some problem at following line
For j = 3 To myTable.Columns(i).Cells.Count
Run Time ERROR 5992
Can not access indivsual columns in this collection because the table has
mixed cell width
Please Help
Shrinivas
On Sat, Aug 13, 2011 at 4:10 PM,
Can you please send the word document which provoked the error (the one
which is opened) ? apparently, there are some merged cells in it.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Shrinivas Shevde
Envoyé : mardi 16 août 2011
Hi all Experts,
I have a little doubt but may be challanging.
I have enclosed my file. plz refer this and give me solution.
awaiting your reply
yours
sajid memon
--
--
Dear All,
Still waiting a solution for below issue...
I have created several pivot tables want to update the data source
range for all the pivot tables all together. (We do have option as refresh
all for applying the preset pivot criteria in all pivots.)
Best Regards,
Amit Desai
Assistant
- Original message
From:Crome Search shailend...@cromesearch.com
Date: 16 Aug 11 17:04:36
Subject: Urgent Opening with Visteon ( MNC ) for Chennai Location
To:
For Internal Use of Employer (Please don't delete or modify while replying
to this email)Monster Resume ID: 33564079
Dear Sir,
Sir I have a query that by using this macro file I am able to merge
different files into single excel but after merging the data is not under
single column heading, Pls. suggest how can I merge files having similar
column headers in all files, so that I can easily sort data as per my
Name your shape “LockShape” and use this assigned to a button or another shape
Sub HideUnhideLockShape()
Shapes(LockShape).Visible = Not _
Shapes(LockShape).Visible
End Sub
From: SAJID MEMON
Sent: Tuesday, August 16, 2011 5:33 AM
To: Excel Group
Subject: $$Excel-Macros$$ AutoHide
Hi all
Your source files should all be structured the same. If not, you will have to
program. Attach samples
From: vikas gupta
Sent: Tuesday, August 16, 2011 6:55 AM
To: excel-macros@googlegroups.com
Cc: pankaj chawla ; tech_pankajcha...@rediffmail.com
Subject: Fwd: FW: $$Excel-Macros$$ Workbooks
- Original message
From:Ma Foi Management Consultants Ltd. paramita.b...@mafoirandstad.com
Date: 16 Aug 11 17:41:48
Subject: WFM-opening at kolkata
To:
For Internal Use of Employer (Please don't delete or modify while replying
to this email)Monster Resume ID: 33564079
I can help email me at excelvba...@gmail.com
On Tue, Aug 16, 2011 at 6:55 AM, vikas gupta vikas.63...@gmail.com wrote:
Dear Sir,
Sir I have a query that by using this macro file I am able to merge
different files into single excel but after merging the data is not under
single column
I can do this email me at excelvba...@gmail.com
On Tue, Aug 16, 2011 at 6:00 AM, Amit Desai (MERU)
amit.de...@merucabs.comwrote:
Dear All,
** **
Still waiting a solution for below issue…
** **
I have created several pivot tables want to update the data source
range for all
Folks, please give me a hint about table attached. I'd like to find a way to
extract exact and wished value from table but of course regarding
pre-existing required conditions.
For instance, if someone choose diameter 40, left diameter 10 and delta 60
excel should get in some empty cell the
I would restructure your table to make it simpler but this works.
From: x x
Sent: Tuesday, August 16, 2011 7:31 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Table - extract some data
Folks, please give me a hint about table attached. I'd like to find a way to
extract exact
Please provide me UDF functino for below requirement
example:)
if the cell value is 4 then including active cell next 4 cell in a row
should be higleted with color.
ex
if
a1 is 4 then a1 ,b1 ,c 1, d 1, f 1 should be higleted.
Thansk,
Rakesh.
--
I can do this email me at excelvba...@gmail.com
On Tue, Aug 16, 2011 at 11:02 AM, ICWAI Help icwai.answ...@gmail.comwrote:
Please provide me UDF functino for below requirement
example:)
if the cell value is 4 then including active cell next 4 cell in a row
should be higleted with color.
I did this VERY recently in another formum. Was it you?
Right click sheet tabview codeinsert this
Private Sub Worksheet_Change(ByVal Target As Range)
Dim tr As Long
tr = Target.Row
Rows(tr).Borders(xlEdgeBottom).LineStyle = xlNone
If Target.Column 1 Or Not IsNumeric(Target) Or _
Hey Harsh,
Please find the below link
http://office.microsoft.com/en-us/templates/CT010144671.aspx
On Tue, Aug 16, 2011 at 1:37 PM, harsh shah harshsha...@gmail.com wrote:
dear all,
anybody having phone book software in excel ??
i.e. name contact details phone numbers up to 3 or 4
Very good venkat..
On Tue, Aug 16, 2011 at 5:03 PM, Venkat CV venkat1@gmail.com wrote:
Hi Sajid,
Look AttachedSee if it helps...
Best Regards,
Venkat
Chennai
On Tue, Aug 16, 2011 at 4:03 PM, SAJID MEMON sajidwi...@hotmail.com wrote:
Hi all Experts,
I have a
hey Vikas,
try to use batch file
open notepad...paste below code then save as
copy.bat
Copy *Comman file name*.xls output.xls
exit
On Tue, Aug 16, 2011 at 5:25 PM, vikas gupta vikas.63...@gmail.com wrote:
Dear Sir,
Sir I have a query that by
Hey Sharma,
Please find the attachment
On Tue, Aug 16, 2011 at 12:53 PM, B Sharma sharma@gmail.com wrote:
Hello to Excel Experts and other users of this group.
I've been looking everywhere about how to put several criteria in
different cell ranges in:
DSUM(database, field,
Please find the attached file and give me the solution :)
if the perticuler cell value is 4 then next 4 coloumn cells in same row
shoudl be highleted .
On Tue, Aug 16, 2011 at 11:42 PM, dguillett1 dguille...@gmail.com wrote:
I did this VERY recently in another formum. Was it you?
Right click
hey All,
please look into the attachment and say how to use table function with array
(table is a function or what ?)
cell F11 = {=TABLE(,E2)} what is this
..
--
ok, got it,
thnx
On Wed, Aug 17, 2011 at 5:16 AM, XLS S xlst...@gmail.com wrote:
hey All,
please look into the attachment and say how to use table function with array
(table is a function or what ?)
cell F11 = {=TABLE(,E2)} what is this
On 8/16/11, Excel VBASQL excelvba...@gmail.com wrote:
I can do this email me at excelvba...@gmail.com
On Tue, Aug 16, 2011 at 11:02 AM, ICWAI Help icwai.answ...@gmail.comwrote:
Please provide me UDF functino for below requirement
example:)
if the cell value is 4 then including active cell
Hi,
Is there any way to defined a user defined formula in excel which will
work like default functions e.g. Sum, Average etc.
Suppose I want to insert a formula to solve the equation y=ax+b
So I will just give the value of a, b and x so it will return the
required value of Y and this function
Hi
See if it helps, I have used name range with Range intersection ,
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of dguillett1
Sent: Tuesday, August 16, 2011 8:08 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Table - extract some
34 matches
Mail list logo