--
Hi LavPrasad,
Here is the solution to your query:
http://www.excelitems.com/2009/02/count-5-consecutive-zeroes.html
Regards
Ashish Jain
Analyst and Demand-Co-ordinator, CSC Australia
Microsoft Office Specialist
Technical
--
Hi,
Here is the solution to your query:
http://www.excelitems.com/2009/02/show-first-day-of-current-week.html
Regards
Ashish Jain
Analyst and Demand-Co-ordinator, CSC Australia
Microsoft
, downloads and problem solutions: visit --
http://www.excelitems.com
Regards
Ashish Jain
Analyst and Demand-Co-ordinator, CSC Australia
Microsoft Certified Application (Excel) Specialist
Technical Trainer - Excel and VBA
Author
Regards
Ashish Jain
Analyst and Demand-Co-ordinator, CSC Australia
Microsoft Certified Application (Excel) Specialist
Technical Trainer - Excel and VBA
Author - www.excelitems.com
0-40-48-43
Regards
Ashish Jain
Analyst and Demand-Co-ordinator, CSC Australia
Microsoft Certified Application (Excel) Specialist
Technical Trainer - Excel and VBA
Author - www.excelitems.com
0-40-48-43
and problem solutions: visit --
http://www.excelitems.com
Regards
*Ashish **Jain*
Analyst and Demand-Co-ordinator, CSC Australia
Microsoft Certified Application (Excel) Specialist
Technical Trainer - Excel and VBA
Author
:R100C4,4)*
For more tips, tricks, downloads and problem solutions: visit --
http://www.excelitems.com
Regards
*Ashish **Jain*
Analyst and Demand-Co-ordinator, CSC Australia
Microsoft Certified Application (Excel) Specialist
of Column D from 3rd Row to Last Row.
For more tips, tricks, downloads and problem solutions: visit --
http://www.excelitems.com
Regards
*Ashish **Jain*
Analyst and Demand-Co-ordinator, CSC Australia
Microsoft Certified Application
, downloads and problem solutions: visit --
http://www.excelitems.com
Regards
*Ashish **Jain*
Analyst and Demand-Co-ordinator, CSC Australia
Microsoft Certified Application (Excel) Specialist
Technical Trainer - Excel and VBA
Author
://www.excelitems.com
Regards
*Ashish **Jain*
Analyst and Demand-Co-ordinator, CSC Australia
Microsoft Certified Application (Excel) Specialist
Technical Trainer - Excel and VBA
Author - www.excelitems.com
0-40-48-43
Hi Angus,
Try this
=IF(OR(H3=TRUE,B2B3),TRUE,FALSE)
For more tips, tricks, downloads and problem solutions: visit --
http://www.excelitems.com
Regards
*Ashish **Jain*
Analyst and Demand-Co-ordinator, CSC Australia
Regards
*Ashish **Jain*
Analyst and Demand-Co-ordinator, CSC Australia
Microsoft Certified Application (Excel) Specialist
Technical Trainer - Excel and VBA
Author - www.excelitems.com
0-40-48-43
://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---
://www.excelitems.com
Regards
*Ashish **Jain*
Analyst and Demand-Co-ordinator, CSC Australia
Microsoft Certified Application (Excel) Specialist
Technical Trainer - Excel and VBA
Author - www.excelitems.com
0-40-48-43
...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---
macro
close all the unnecessary applications on the PC.
For more tips, tricks, downloads and problem solutions: visit --
http://www.excelitems.com
Regards
*Ashish **Jain*
Analyst and Demand-Co-ordinator, CSC Australia
files
(Compatible to Excel 2000/2003 and 2007 version).
I've uploaded them on www.excelitems.com.
Here is the Download Link :-- http://www.excelitems.com/2008/09/downloads.html
Please do reply, if this was helpful to you.
Regards
Ashish Jain
and problem solutions: visit --
http://www.excelitems.com
Regards
*Ashish **Jain*
Analyst and Demand-Co-ordinator, CSC Australia
Microsoft Certified Application (Excel) Specialist
Technical Trainer - Excel and VBA
Author
Regards
*Ashish **Jain*
Analyst, CSC Australia
Microsoft Certified Application (Excel) Specialist
Technical Trainer - Excel and VBA
Author - www.excelitems.com
+91--40-48-43
Hi Friends,
Quite Amazing - No feedbacks !!
For more tips, tricks, downloads and problem solutions: visit --
http://www.excelitems.com
Regards
*Ashish **Jain*
Analyst, CSC Australia
Microsoft Certified Application (Excel
it prompts you and try to use it
on a system where internet is working.
Thanks and Regards
Ashish Jain
On Mar 10, 2:30 pm, zaki l zaki...@gmail.com wrote:
i downloaded the file but it showed some error and it was not gettin
refreshed.
On Tue, Mar 10, 2009 at 9:46 AM, Ashish Jain 26may.1
Regards
*Ashish **Jain*
Analyst, CSC
Microsoft Certified Application (Excel) Specialist
Technical Trainer - Excel and VBA
Author -www.excelitems.com
+91--40-48-43
Hi Kanwal,
Sorry for being late. Here is your Solution attached with the mail.
It was more easy than before. By putting HLookup, you're half done already.
Do tell us, if more help needed.
Thanks and Regards
Ashish Jain
For more tips, tricks, downloads and problem solutions: visit --
http
://www.excelitems.com
Regards
*Ashish **Jain*
Analyst, CSC Australia
Microsoft Certified Application (Excel) Specialist
Technical Trainer - Excel and VBA
Author - www.excelitems.com
+91--40-48-43
.
As of now, I can't commit exact date but my commitment of gift will be
fulfilled very soon.
With Sorry
Ashish Jain
Group Manager
---
On Wed, Mar 18, 2009 at 7:05 PM, Ajay Varshney
ajayvarshney21...@gmail.comwrote
For more tips, tricks, downloads and problem solutions: visit --
http://www.excelitems.com
Regards
*Ashish **Jain*
Analyst, CSC Australia
Microsoft Certified Application (Excel) Specialist
Technical Trainer - Excel and VBA
Author
For more tips, tricks, downloads and problem solutions: visit --
http://www.excelitems.com
Regards
*Ashish **Jain*
Analyst, CSC Australia
Microsoft Certified Application
, downloads and problem solutions: visit --
http://www.excelitems.com
Regards
*Ashish **Jain*
Analyst, CSC Australia
Microsoft Certified Application (Excel) Specialist
Technical Trainer - Excel and VBA
Author - www.excelitems.com
: visit --
http://www.excelitems.com
Regards
*Ashish **Jain*
Analyst, CSC Australia
Microsoft Certified Application (Excel) Specialist
Technical Trainer - Excel and VBA
Author - www.excelitems.com
+91--40-48-43
*Ashish **Jain*
Analyst, CSC Australia
Microsoft Certified Application (Excel) Specialist
Technical Trainer - Excel and VBA
Author - www.excelitems.com
+91--40-48-43
*Ashish **Jain*
Analyst, CSC Australia
Microsoft Certified Application (Excel) Specialist
Technical Trainer - Excel and VBA
Author - www.excelitems.com
+91--40-48-43
Hi Harry,
Its m !!
Yhoo !!
Let's Rock on!!
For more tips, tricks, downloads and problem solutions: visit --
http://www.excelitems.com
Regards
*Ashish **Jain*
Analyst, CSC Australia
Microsoft Certified
.
Regards
Ashish Jain
Group Manager
On Mar 19, 12:27 pm, pravin mehta mehtapravin@gmail.com wrote:
unsubscribe
On Wed, Mar 18, 2009 at 10:16 PM, Balachander S sba...@gmail.com wrote:
Can some body in the group tell me how to solve this problem
I Have a worksheet that updates some rates from
--
http://www.excelitems.com
Regards
*Ashish **Jain*
Analyst, CSC Australia
Microsoft Certified Application (Excel) Specialist
Technical Trainer - Excel and VBA
Author - www.excelitems.com
+91--40-48-43
--
http://www.excelitems.com
Regards
*Ashish **Jain*
Analyst, CSC Australia
Microsoft Certified Application (Excel) Specialist
Technical Trainer - Excel and VBA
Author - www.excelitems.com
+91--40-48-43
://www.excelitems.com/2009/03/change-picture-or-image-location.html
3. Copy Excel Worksheets to MS
Wordhttp://www.excelitems.com/2009/03/copy-excel-worksheets-to-microsoft-word.html
--
Regards
Ashish Jain
Dave Bonallack
67 Ashish Jain
63 Tom_Jeffries
59 Nihar
57 Andy (Aindril)
55 Ajay Varshney
44 Ajit Navre (AmatuerVB)
42 Harmeet (Harry)
39 Paul Schreiner
Note: This step has been taken on the basis of their performance and
every member is thankful to them
Regards
*Ashish **Jain*
Analyst, CSC Australia
Microsoft Certified Application (Excel) Specialist
Technical Trainer - Excel and VBA
Author - www.excelitems.com
+91--40-48-43
.
.
.
.
.
.
For more tips, tricks, downloads and problem solutions: visit --
http://www.excelitems.com
Regards
*Ashish **Jain*
Analyst, CSC Australia
Microsoft Certified Application (Excel) Specialist
Technical Trainer - Excel and VBA
://www.excelitems.com
Regards
*Ashish **Jain*
Analyst, CSC Australia
Microsoft Certified Application (Excel) Specialist
Technical Trainer - Excel and VBA
Author - www.excelitems.com
+91--40-48-43
End If
End Sub
.
.
.
.
.
For more tips, tricks, downloads and problem solutions: visit --
http://www.excelitems.com
Regards
*Ashish **Jain*
Analyst, CSC Australia
Microsoft Certified Application (Excel) Specialist
Technical
solutions: visit --
http://www.excelitems.com
Regards
*Ashish **Jain*
Analyst, CSC Australia
Microsoft Certified Application (Excel) Specialist
Technical Trainer - Excel and VBA
Author - www.excelitems.com
+91--40-48-43
MVP Program, click here
- http://mvp.support.microsoft.com/
Thanks and Regards
Ashish Jain
Group Manager
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel
and you'll be able to see that. Make
sure Headings are enabled, If you can't see headings, please Goto View
-- Check Headings.
Enjoy and Thanks again Mudassar:)
Regards
Ashish Jain
On Mar 30, 2:01 am, zheng yu vincent2...@gmail.com wrote:
Hi Mudassar,
while I am looking at Drill bit
it has been called. Remember, a function always returns a
value but a subroutine may or may not. A subroutine can call a
function but a function don't call sub-routines.
Regards
Ashish Jain
On Mar 30, 1:25 am, LookingForExcelHelp ahar...@gmail.com wrote:
Rodney,
Thanks for the help, but I'd like
Hi vitovla,
Use Exit keyword to break a process. You can use it to come out of
Subroutine or a Loop.
Its possible combinations are:
Exit Do
Exit For
Exit Sub
Regards
Ashish Jain
On Apr 4, 9:12 pm, vitovla slbcr...@gmail.com wrote:
Hello,
I'm developing an application to download the data
Hi Vincent
It seems more like sharing information - and we dnt find any other way
to do this at runtime. If you've plz share with us.
Regards
Ashish Jain
On Apr 2, 6:09 pm, Yu vincent2...@gmail.com wrote:
Hi Dear all,
I have this puzzle for a long time. I often program UserForm
*Ashish **Jain*
Analyst, CSC
Microsoft Certified Application (Excel) Specialist
Excel and VBA Trainer
Author - www.excelitems.com
+91--40-48-43
Regards
*Ashish **Jain*
Analyst, CSC
Microsoft Certified Application (Excel) Specialist
Excel and VBA Trainer
Author - www.excelitems.com
+91--40-48-43
solutions: visit --
http://www.excelitems.com
Regards
*Ashish **Jain*
Analyst, CSC
Microsoft Certified Application (Excel) Specialist
Excel and VBA Trainer
Author - www.excelitems.com
+91--40-48-43
...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---
@ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---
in the vba macro.
For more tips, tricks, downloads and problem solutions: visit --
http://www.excelitems.com
Regards
*Ashish **Jain*
Analyst, CSC
Microsoft Certified Application (Excel) Specialist
Excel and VBA Trainer
Author
Hi Laxmikant
Yes, this is possible. Using VBA you can fill forms on internet, even
if it's https.
For more tips, tricks, downloads and problem solutions: visit --
http://www.excelitems.com
Regards
*Ashish **Jain*
Analyst
Hi Abdul,
To prepare for MCAS Exam Preparation, you may go through Microsoft
published books and articles. Try sample exams, you may find them on
search engines. Fee Structure is flat $50.
For running offers and discounts, please visit
http://www.prometric.com/microsoft
Regards
Ashish Jain
.
Regards
Ashish Jain
www.excelitems.com
Developer of OpenXL
On Apr 27, 1:36 pm, Sachin Shukla sachina...@gmail.com wrote:
Dear All,
I want to learn VBA in excel. Please help me.
Thanks
Sachin Shukla
Hi Jayesh,
Here is a good reference on How to use Lookup methods?
http://www.excelitems.com/2009/03/how-to-use-vlookup-function.html
Regards
Ashish Jain
www.excelitems.com
Developer of OpenXL
On Apr 25, 2:37 pm, Jayesh
Hi Satish,
Try Merge Worksheets command. It's located in Sheet Utils --
Merge Worksheets of Open XL addin available free on
http://www.excelitems.com
Regards
Ashish Jain
www.excelitems.com
Developer of OpenXL
On Apr 23, 4
for Open XL (2003 users).
New features/bug fixes/support will be available with Open XL 1.0.0.0
(2007 and onwards) only.
Enjoy !!
Regards
Ashish Jain
www.excelitems.com
Developer of Open XL
---
On Apr 28, 11:02 am, Jitendra Kumar
with certain limitations.
Regards
Ashish Jain
www.excelitems.com
Developer of Open XL
---
On Apr 28, 11:48 am, Ankur Satija ankursat...@gmail.com wrote:
One problem using Open XL...
Once any function
/videos.html
Regards
Ashish Jain
www.excelitems.com
Developer of Open XL
--
On Apr 28, 4:14 pm, satish satishpag...@gmail.com wrote:
Dear Friends,
I downloaded the zip folder and double clicked on setup file
system?
4. Are you running Windows XP or above on your system?
5. Do you use Office 2007 and above?
Regards
Ashish Jain
www.excelitems.com
Developer of Open XL
---
On Apr 28, 7:00 pm, Upendra Singh upendrasinghsen
Hi
Try this link - http://26may.1984.googlepages.com/OpenXLBeta1.0.0.0.zip
Regards
Ashish Jain
www.excelitems.com
Developer of Open XL
--
On Apr 28, 3:45 pm, iactnow yuk.s...@gmail.com wrote:
I have tried to download
Hi,
Try wsheet.Hpagebreaks.Count and Wsheet.VPageBreaks.Count.
and wsheet.HPageBreaks(Page Count).Location.Row
Regards
Ashish Jain
www.excelitems.com
Developer of OpenXL
---
On Apr 28, 9:24 am, vivek jain vivek.j
settings.
You're done. That's it.
Regards
Ashish Jain
www.excelitems.com
Developer of Open XL
On Apr 30, 10:52 am, Punj rkp...@gmail.com wrote:
I want protect cell in first line only
I want if i overwrite this black cells, it does not change.
and changes in below all cells can be made.
help
://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---
.
-
Regards
Ashish Jain
http://www.excelitems.com
http://www.openexcel.com
*Developer of Open XL*
-
On Jun 6, 11:51 am, spazlon spaz...@gmail.com wrote:
Hello,
I am looking for a personal finance spreadsheet. I tried making one of
my
ThisWorkbook.Path \ myDep.Value .xls
CWbk.SaveAs C:\destination\ myDep.Value .xls
CWbk.Close False
Set CWbk = Nothing
Next
End Sub
-
Regards
Ashish Jain
http://www.excelitems.com
http://www.openexcel.com
*Developer of Open XL
, you'll better
understand the above 2 points. Try with different expressions to
really learn this.
-
Regards
Ashish Jain
http://www.excelitems.com
http://www.openexcel.com
*Developer of Open XL*
-
On Jun 6, 3:11
Hi Harish,
There can be a macro written based on your requirements using
Worksheet_Change event. But there is no inbuilt feature to accomplish
the same. For drop-down you can use Data -- Validation feature of MS
Excel.
-
Regards
Ashish Jain
http
Hi Dean,
This has nothing to do with excel. Either clear your Internet explorer
(or of the browser you're using) or permanently set its cache size to
0KB.
-
Regards
Ashish Jain
http://www.excelitems.com
http://www.openexcel.com
*Developer of Open XL
Hi Kamlesh,
Check the files section of this group.
http://groups.google.com/group/excel-macros/files
-
Regards
Ashish Jain
http://www.excelitems.com
http://www.openexcel.com
*Developer of Open XL*
-
On Jun
to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---
)
-
Regards
Ashish Jain
http://www.excelitems.com
http://www.openexcel.com
*Developer of Open XL*
-
On Jun 8, 6:34 pm, steef83 stee...@gmail.com wrote:
Hi,
I need to make an asset list where the serial number is attached to an
asset number of the company.
I need to do
Hi Mahesh,
The Group is not for providing start-to-end solutions. Try solving the
problem and we all are here to technically assist you whenever and
wherever you're stuck. I charge for solving such queries, since these
eat time.
-
Regards
Ashish Jain
http
--
Regards
Ashish Jain
(91) -40-48-43
Excel VBA - http://www.excelitems.com
Open XL - http://www.openexcel.com
World Stock Markets - http://www.moneydust.com
Foreign Languages - http://www.oddtongue.com
Powerpoint Presentations - http://www.slidesbox.com
Motivational Videos - http
.
--
Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.com
(Developer of OpenXL)
http://www.openexcel.com
Excel,VBA,VSTO Trainer
+91..40.48.43
Hi Ashish,
Try this formula - I just used trim function to solve your issue.
=INDEX(B$2:D$4,MATCH(TRIM(B10),A$2:A$4,0),MATCH(A10,B$1:D$1,0))
--
Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http
/excel/HP051992911033.aspx
--
Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.com
(Developer of OpenXL)
http://www.openexcel.com
Excel,VBA,VSTO Trainer
+91..40.48.43
Hi Prashant,
Try OPEN XL - http://www.openexcel.com
It's commercial/personal use is free.
--
Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.com
(Developer of OpenXL)
http://www.openexcel.com
Hi All,
This is challenge for all excel users. Solve these puzzles and sharpen your
excel acumen. So, here goes the first puzzle of Excel Macros Google Group
in attached file.
--
Regards
Ashish Jain
(Excel Macros - Google
Hi Harmeet,
That's fantastic. and good that you protected the code. I want
everyone to try, so that their logic and vba skills can be sharpened.
Well Done Harry.
--
Regards
Ashish Jain
(Excel Macros - Google Group Manager
Hi Ashish,
Try OpenXL - http://www.openexcel.com
--
Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.com
(Developer of OpenXL)
http://www.openexcel.com
Excel,VBA,VSTO Trainer
/675fbe8fd61f2699#675fbe8fd61f2699
--
Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.com
(Developer of OpenXL)
http://www.openexcel.com
Excel,VBA,VSTO Trainer
Ph. No. - 0x25402CF2B
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
SetCopyRange = Wks.Range(strAddress)
End Function
--
Thanks Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.com
(Developer of OpenXL)
http://www.openexcel.com
Excel,VBA,VSTO Trainer
Ph
Hi Ron,
Please login using ur palas...@gmail.com id. and attach your file in
the mail and then finally, send this mail to excel-
mac...@googlegroups.com and 26may.1...@gmail.com
--
Thanks Regards
Ashish Jain
(Excel Macros
represented superb intellect. Well Done Sandeep and
Bruno !
--
Thanks Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.com
(Developer of OpenXL)
http://www.openexcel.com
Excel,VBA,VSTO Trainer
Ph
Hi Aamir
Please check out - Hope it helps !
http://www.excelitems.com/2009/09/difference-between-sumif-and-sumifs.html
--
Thanks Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.com
--
Thanks Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http://www.excelitems.com
(Developer of OpenXL)
http://www.openexcel.com
Excel,VBA,VSTO Trainer
Ph. No. - 0x25402CF2B
- Office Utils.xla
2. Macro Name - Generate_Invoice
So, you'll write in the macro window - 'Office Utils.xla'!
Generate_Invoice and press enter (or click on options to assign some
keystroke).
--
Thanks Regards
Ashish Jain
Hi Mohit,
Please visit -
http://www.excelitems.com/2009/09/export-excel-2007-charts-to-powerpoint.html
or check the VBA Code in attached file.
--
Thanks Regards
Ashish Jain
(Excel Macros - Google Group Manager)
http
step.
@Bruno,
Like always, you've done very well and fantastic. Your solutions are
very impressive and an honour for this group.
@All Group Members,
Future puzzles will judge your excel acumen unlike your logic as in
the previous puzzles. So, be ready and keep enjoying.
Thanks Regards
Ashish Jain
Hi Mike,
You cannot use Event Methods like Open, Activate, Select etc in Custom
Functions.
Regards
Ashish Jain
Microsoft Certified Application Specialist (Excel)
http://www.excelitems.com
http://www.openexcel.com
__
On May 28, 9:11 pm, Mike Ratcliffe mich
worksheet.
ActiveWindow.ScrollColumn = 1
'Scroll to the first row of activated worksheet.
ActiveWindow.ScrollRow = 1
'Error Handling OFF
On Error GoTo 0
End Sub
Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft
Hi Hemant,
This group is to help MS Excel Office applications users in their
day-to-day issues to raise their self-esteem with technology usage. We
encourage you to proceed with the first step and we'll help you rest :)
Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified
Hi Chris
Due to the security reasons, this is not possible neither through VBA
nor VSTO.
Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com
On Oct 20, 7:06 pm
Hi Chris
Due to the security reasons, this is not possible through VBA/VSTO.
Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft Certified Professional)
http://www.excelitems.com
http://www.openexcel.com
On Oct 20, 7:06 pm, ChrisDixon
.
v. In case of 2007/2010
Review -- Protect Sheet
v. In case of Office XP/2003
Tools -- Protection -- Protect Sheet
vi. and give password -- that's it :)
Regards
Ashish Jain
McKinsey India Knowledge Center
(Microsoft Certified Application Specialist)
(Microsoft
Hi Simon,
Application.DisplayAlerts = False still works !
It works in all versions of excels i.e.2003, 2007 2010.
Take Care of these points:
1. Use new event macro - Private Sub Workbook_Open()
2. Enable the Macros(Right below Formula Bar) whenever you open the
workbook.
Regards
Ashish
1 - 100 of 121 matches
Mail list logo