*Dear Noorain*
*
*
*Pl inform how to and where to use this code..*
*Thank you.*
*
*
*Pravin.
*
On Thu, Nov 1, 2012 at 11:04 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote:
Dear Pravin,
Please try
Sub delete_alternative_sheet()
Dim i As Integer
On Error Resume Next
For i = 2 To
Dear Gurus,
I have a file which has the values like 6 - 11
7 - 20
2 - 27
which is automatically changing to date format but it should display the
same 6 - 11
7 - 20
2 - 27
Thanks
N.Sundarvelan
9600160150
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
Dear Pravin,
Please press Alt+F11 and goto Insert-module and paste code
and press F5 to execute macro.
Hope it will useful for you.
On Thu, Nov 1, 2012 at 11:40 AM, Pravin Gunjal isk1...@gmail.com wrote:
*Dear Noorain*
*
*
*Pl inform how to and where to use this code..*
*Thank you.*
*
Dear Sundar,
Please convert cell as Text
Select required cell and press ctrl+1 and change format of cell as text.
On Thu, Nov 1, 2012 at 11:52 AM, Sundarvelan N nsund...@gmail.com wrote:
Dear Gurus,
I have a file which has the values like 6 - 11
7 - 20
2 - 27
which is automatically
*Hello,*
*Can somebody help me out on this issue *
*Thanks in advance.*
*
*
*Regards*
*Pravin Gunjal.
*
-- Forwarded message --
From: Pravin Gunjal isk1...@gmail.com
Date: Tue, Oct 30, 2012 at 6:58 PM
Subject: VBA enabled sheet doesn't allow to protect
To:
Dear Noorain Sir,
Can you ammend your code that when we run macro, a message box appear and
ask for select the sheets which you want to delete and we will select the
multiple sheet which we want to delete.
Aamir Shahzad
On Thu, Nov 1, 2012 at 11:34 AM, Pravin Gunjal isk1...@gmail.com wrote:
Hello Satendra
Thanks for the help. One more thing I want to know If I want to do this
from other file and process how can I put this formula in the sheet.
Once again thanks
On Wednesday, October 31, 2012 1:29:03 PM UTC+5:30, Satendra kumar wrote:
Hi,
Find Another solution i think this is
*It would be better...
*
-- Forwarded message --
From: Aamir Shahzad aamirshahza...@gmail.com
Date: Thu, Nov 1, 2012 at 12:13 PM
Subject: Re: $$Excel-Macros$$ How to delete alternate sheets faster
To: excel-macros@googlegroups.com
Dear Noorain Sir,
Can you ammend your code
Dear Vijay
File is not working
Regards
Shrinivas
On Tue, Oct 30, 2012 at 6:31 PM, Vijay Kr. Aggarwal
vjaggarwal2...@gmail.com wrote:
Hi Shrini,
First sheet:- Raw Data
Second Sheet :- Criteria is given in this sheet.
third sheet :- Final output would be pasted here by using criteria
That's not going to work out well.
Let's say you have 11 sheets
the Sheets() array looks like:
Sheets(1).Name = One
Sheets(2).Name = Two
Sheets(3).Name = Three
Sheets(4).Name = Four
Sheets(5).Name = Five
Sheets(6).Name = Six
Sheets(7).Name = Seven
Sheets(8).Name = Eight
I tried it and it worked fine.
However, I didn't spend the time to create a bunch
of drop-down menus. I just used some data I already had.
Maybe the problem is with copying the selected values of the drop-downs.
perhaps if you posted your file? (or an edited version)
Otherwise, we could spend
Dear Pravin,
Use the solution which suit your need and meets your requirement. But my
solution will be something like this :
By holding Ctrl Key and by using Mouse click select the sheets you wish to
delete. Once the selection of sheets is done --- right click and choose
delete --- this will
Another way would be to create an array of sheet names and the delete it
accordingly.
So even if you go with a positive Step, it would still work.
Based on the suggestions above, you can come up with the loop... however,
in the end, the array should be passed like this
Yeah, Sam..
I thought about that.
But he said he had 43 sheets!
(OK, he's only deleting 21)
That's kind of a cumbersome array to manage,
although I'm sure it could be done.
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
*Hi Paul,*
*
*
*Could you please inform me the full code, so that I can apply it in the
attached file for test purpose and later on in my original file for use.*
*
*
*And thanks to all for their solutions too.*
*
*
*Regards*
*Pravin Gunjal*
-- Forwarded message --
From: Paul
Hi- Our team is currently using an Infopath form in SharePoint but looking
to move to an Access database. We would like to be able to use as a
resource request and have questions posted to the Access database. Does
anyone know if this is something that can be done in Microsoft Access- and
if
Hi,
try this, Ctrl+F, put value in Find What, Find All, Ctrl+A and then Esc
regds
On Thu, Nov 1, 2012 at 8:30 PM, karthikeyan sankaran
karthikeyansankar...@gmail.com wrote:
Hi,
How to select particular cell value within one click.I need to select
value 2 only.
without using macro ,
Hi Friends,
Can anyone please help me with the code which is used to establish the
connectivity between HP ALM and macros and also to update some fields in
ALM.
Regards
Nevin
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
Hi Partners,
DIRECT CLIENT - In person interview is needed after TELEPHONIC ROUND.
Location: Boston, MA
Duration: 6+ months
Rate: open/hr C2C
Skills Needed:
. Experience should include security policy development,
security education, network penetration testing,
Hi Partners,
DIRECT CLIENT - In person interview is needed.
Location: Boston, MA
Duration: 9+ months
Rate: Open C2C/W-2 (37.5 hrs/week)
Skills Needed:
. Minimum 3 years of project management experience in a technology
environment
. Proven track record of delivering large-scale
HI Rajan/Friends,
Thanks for your intrest in helping me.
Objective of the tool is to update all the test case results in QC from an
excel file through macros which inturn will avoid manual work.
We have around 1200 TC's for every execution and once we develop it as tool
it will reduce a
Moderator plz ban all this..
On Fri, Nov 2, 2012 at 9:52 AM, Satendra kumar satendrakuma...@gmail.comwrote:
Yes Kuldeep you are right...
On Fri, Nov 2, 2012 at 9:50 AM, Kuldeep Singh naukrikuld...@gmail.comwrote:
Hi Ankush,
It's not a job posting portal, So don't post any
22 matches
Mail list logo
