Dear Sagar,
Can u specify more what u want excatly.
Warm Regards,
Gawli Anil N
On Fri, Apr 26, 2013 at 11:50 AM, sagaraher sagara...@gmail.com wrote:
Hello Anil,
You have helped me last time to create different sheets mail against
given mail-id through macro. I have one more data sheet
Hi Kuldeep,
You can also use this formula.
=REPLACE(TRANSPOSE(sheetnames),1,FIND(],TRANSPOSE(sheetnames),1),)
Regards
Priti verma
On Thu, Apr 25, 2013 at 8:20 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Thanks Chaya.
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.:
HI kuldeep,
Please Ingnor previous mail That is incomplete.
Please find attachment.
On Thu, Apr 25, 2013 at 8:20 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Thanks Chaya.
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
Hi Experts,
I have a macro to compare two folders carrying Excel files and if I open
any other Excel file during the Macro Execution, the macro is getting
Stopped. Is it a normal behaviour of Excel or what can be the root cause of
this problem? Please advise me ASAP. Thanks
--
ThanksRegards,
Hello Anil,
I guess source data remained same in code
ActiveWorkbook.PivotCaches.Create(SourceType:=xlDatabase, SourceData:= _
CABS_3CYL!R1C1:R147C24,
Version:=xlPivotTableVersion14).CreatePivotTable _
TableDestination:=Part!R1C1, TableName:=PivotTable2,
DefaultVersion _
Can someone please answer?
Best Regards,
Amit Desai
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Amit Desai (MERU)
Sent: 22 April 2013 18:15
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Filter based on coulmns
Dear Friends,
In general
Hi Amar,
Please check below code for your requirement.
Public Sub cusPrintArea()
Dim myRange As String
myRange = Selection.Address
ActiveSheet.PageSetup.PrintArea = myRange
On Error Goto 1
1: Exit Sub
With ActiveSheet.PageSetup
.LeftHeader =
Your original statement is not entirely accurate.
Excel's Autofilter is techically applying a filter to ROWS based on the value
in
a COLUMN (or value of a cell in that row)
What it is actually doing is simply hiding any row that does not meet the
filter
criteria for a specific column.
What
The problem is with regard to a Windows Application Instance.
Basically, when you open more than one workbook, the Excel program opens
once,
and each workbook is open in this single instance of Excel.
That's why, in earlier versions of Excel, you had a window menu selection
that listed the
Hi Preeti,
Can we do Unprotect All also?
But system should ask the password as usual for protect unprotect.
Regards
Pravin.
On Tue, Apr 23, 2013 at 9:29 PM, priti verma pritiverma1...@gmail.comwrote:
Hi Kuldeep,
Please use the following code
Sub ProtectAll()
Dim sheet As Worksheet
Dim
Hi Experts,
I want to create sheets by given name (Via VBA). anyone please help me.
Regards,
Kuldeep Singh
Info Edge India Limited (naukri.com)
Phone.: +91-0120-4841100, Extn.: 2467, 9716615535
naukrikuld...@gmail.com || www.naukri.com
*Please* *Consider the environment. Please don't print this
Hi Pravin,
i have just add inputbox for value input and replace sheet.protect
with sheet.unprotect for Unprotect all sheets
for protect all sheets
Sub ProtectAll()
Dim sheet As Worksheet
Dim myPassword As String
myPassword = InputBox(Enter password)
For Each sheet In ActiveWorkbook.Worksheets
*Thanks will try for the same*
*
*
*Regards,*
*Pravin Gunjal.*
-- Forwarded message --
From: xlstime xlst...@gmail.com
Date: Fri, Apr 26, 2013 at 7:26 PM
Subject: Re: $$Excel-Macros$$ Protect All Sheets Via VBA
To: excel-macros@googlegroups.com
Hi Pravin,
i have just add
Hi Kuldeep,
Please find attached...need u add more sheet name just change range name
.
Enjoy
Team XLS
On Fri, Apr 26, 2013 at 7:26 PM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Hi Experts,
I want to create sheets by given name (Via VBA). anyone please help me.
I take it that the Code in your sample sheet it sheet is the Given Name you
refer to?
I would first:
record a macro in which you add a new sheet and change the name.
using this, there are several lines that you won't need:
-
Sheets(Sheet1).Select
Sheets.Add
Hi Pravin,
Yes you can do it.Please find the aatchment.
Regards
Priti verma
On Fri, Apr 26, 2013 at 7:15 PM, Pravin Gunjal isk1...@gmail.com wrote:
Hi Preeti,
Can we do Unprotect All also?
But system should ask the password as usual for protect unprotect.
Regards
Pravin.
On Tue,
Happy Friday Everybody,
hope it is allowed to throw in a question here regarding a certain behavior
in Excel that I've just never seen fixed/improved. Ayush, maybe you or
anybody else here know. Just some trivia I'd like to understand as a geek.
I can't even remember what the first version
17 matches
Mail list logo
