://exceldailytip.blogspot.com
Any comments would be highly appreciated.
Please share these tips with your friends and associates. You
are one of the 2700 members around the world.
If you have any tips,please share it in the group.
Thanks Best Regards,
Ayush Jain
Group Manager
I need your help. Do you know how to clear the clipboard of MS Word
2003 through VBA Code?
If you have any idea, do let me know please.
I have tried this code : Application.CommandBars
(Clipboard).FindControl(ID:=3634).Execute
But it through an error.
Thanks.
Ayush Jain
Any other nominations for moderator of this group ?
Thanks.
On Feb 7, 11:50 am, Ayush jainayus...@gmail.com wrote:
Last date of submitting nomination is 15th February.
***
On Feb 7, 10:11 am, Ayush jainayus...@gmail.com
to:
http://exceldailytip.blogspot.com
Any comments would be highly appreciated.
Please share these tips with your friends and associates. You
are one of the 3800 members around the world.
If you have any tips,please share it in the group.
Thanks Best Regards,
Ayush Jain
Group Manager
://exceldailytip.blogspot.com
Any comments would be highly appreciated.
Please share these tips with your friends and associates. You
are one of the 3800 members around the world.
If you have any tips,please share it in the group.
Thanks Best Regards,
Ayush Jain
Group Manager
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
-
-~--~~~~--~~--~--~---
at http://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
, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
-
-~--~~~~--~~--~--~---
!!
All Cheers to U.
Regards,
Ayush Jain
Ashish Jain
Knowledge Shared is Power
“In today's environment, hoarding knowledge ultimately erodes your
power. If you know something very important, the way to get power is
by actually sharing
with excel
5) Any trick to do some task in small time.
Thank you so much !!! Looking forward for the more tips from you !!!
Best regards,
Ayush Jain
Group Owner
Hello All,
Today is last day to submit excel tips for week # 24 competition.
Please submit and have a cance of winning the competition.
It was great learning today.
Thanks and best regards,
Ayush Jain
know if you need any clarifications.
Let me begin by submitting the first tip for this week competition.
---
Name : Ayush Jain
Subject : Format all
wonderful prizes.
KEEP POSTING
Thanks and best regards,
Ayush Jain
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free
!
Thanks and best regards,
Ayush Jain
--~--~-~--~~~---~--~~
-
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
http
.
---
Name : Ayush Jain
Subject : Two workbooks side by side
Detail : If you just want to have the two workbooks side-by-side, use
the Window--Arrange command and select Vertical. If you want
submit your tip
in the thread mentioned below:
http://groups.google.com/group/excel-macros/browse_thread/thread/c1abf04a7349f3c1#
Please participate and win wonderful prizes.
KEEP POSTING
Thanks and best regards,
Ayush Jain
Hi Dave,
Good Observation !!! I liked it !!!
Best regards,
Ayush Jain
On Jul 7, 9:33 am, Dave dave_greg...@yahoo.com wrote:
Excel's serial number for 7/6/09 is 40,000.
Since Excel maintained consistency with Lotus 123 by treating the year
1900 as a leap year when it wasn't, the actual
. Learn VBA Macros at http://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
#
Keep Posting !!!
Thank you so much.
Best regards,
Ayush Jain
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins
Dear Anand,
You can find all the tips at www.exceldailytip.blogspot.com. I will
update this blog soon with the tips submitted in the competition.
Hope it helps
Best regards,
Ayush Jain
On Jul 10, 1:44 pm, anandydr anand...@gmail.com wrote:
Dear Ayush,
Could you please provide
.
---
Name : Ayush Jain
Subject : Convert rows to columns viceversa
Detail : You can convert rows to columns (and columns to rows) by
highlighting the cells you want to switch around, clicking on Edit,
Copy, selecting a new cell and then going to Edit
in the thread mentioned below:
http://groups.google.com/group/excel-macros/browse_thread/thread/3298b7deb4d52b2f#
Please participate and win wonderful prizes.
KEEP POSTING
Thanks and best regards,
Ayush Jain
of energy...
You suggestions are most welcome again.
All Cheers to U...
Regards,
Ayush Jain
[Group Owner]
--~--~-~--~~~---~--~~
--
Some important links for excel users:
1. Excel and VBA
and position the workbook windows as you want them to appear
the next
time you use the workbooks.
3. On the File menu, click Save Workspace.
4. In the File name box, enter a name for the workspace file.
The workspace file has an extension (*.xlw)
Best regards,
Ayush Jain
[Group Owner
welcome your suggestions to make this group bigger and more
useful.
Let me know if you have any queries.
Once again...a Big Cheers to all members...
Keep Posting !!
Best regards,
Ayush Jain
[Group Owner]
P.S. Visit www.discussexcel.com and let us know if you find any issues
in accessing the same
Hi All,
Best wishes for a Bright and Sparkling Diwali. Hope the festive season
brings in happiness and prosperity galore to your lives.
Best regards,
Ayush Jain[Group Owner
It worksThanks for the info..
Best regards,
Ayush Jain
On Oct 16, 9:47 pm, Hemant hemantbales...@gmail.com wrote:
Thank you so much Michael :)
I am going to test it now!
On Oct 15, 2:55 pm, Michael michael.holn...@googlemail.com wrote:
Why does no one seem to use the [A1] notation
is required.
Best regards,
Ayush Jain
[Group Owner and Manager]
On Nov 14, 1:52 pm, Abhishek Jain abhishek@gmail.com wrote:
Hi folks,
I have this cell where the values filled can be - 0 or 1 or 2 or 3. I want
to set a custom format for excel to show -
Poor for 0
Average for 1
Good for 2
send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com
HELP US GROW !!
We reach over 6,500 subscribers worldwide and receive many nice notes about the
learning and support from the group. Our goal is to have 10,000 subscribers by
the end of 2009. Let friends
Dear Experts,
Can someone help Punit on his request ?
Thank you!
BR,
Ayush
On Dec 11, 2:45 pm, punit poddar p2pod...@gmail.com wrote:
Guys, pls help
-- Forwarded message --
From: punit poddar p2pod...@gmail.com
Date: Dec 10, 2009 12:29 PM
Subject: VBA Code for Locking
it for
you.
Best regards,
Ayush Jain
On Dec 22, 10:55 pm, Andre Gobet andre.go...@sesamnet.ch wrote:
Hello
I've a list in Excel of about 1000 e-mail adresses from our internal
Database. Now i want to extract from this list only the domain names
to put in to our Spam Filter for Whitelisting
of this group.
If you are new to Twitter, Please sign up at www.twitter.com and
follow people to stay in touch.
Any queries, Please write to me @ jainayus...@gmail.com
Keep Posting
Thank you,
Ayush Jain
Group Owner
--
--
Some
tips, please share with group members. Thanks.
Best regards,
Ayush Jain
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA
Hi Shilpa,
There is no need of Macro for this...Just drag the formula for 50k
lines and it will automatically change the refernce.
Use autofill it should work..
Let us know if you have doubts.
Best regards,
Ayush Jain
On Jan 24, 9:27 pm, Shilpa Rao shilpa...@gmail.com wrote:
Hi Team
regards,
Ayush Jain
Group Owner
On Jan 25, 11:12 am, ankur ankurpande...@gmail.com wrote:
thanks ayush
i also wanted a code to refresh pivot table like this
On 25/01/2010, ayush jain jainayus...@gmail.com wrote:
San,
Try Now .
Best regards,
Ayush Jain
On Mon, Jan 25, 2010 at 9:54 AM
between Excel and
other programs
that use dates. As it stands, this bug really causes very few problems
because most users do not use dates before March 1, 1900.
Best regards,
Ayush Jain[Group Owner]
--
--
Some important
in column A
lLastRow = .Cells(.Rows.Count, 1).End(xlUp).Row
Set rngToCheck = .Range(.Cells(1, 1), .Cells(lLastRow, 1))
End With
With rngToCheck
.AutoFilter Field:=1, Criteria1:=*here*, Operator:=xlFilterValues
End With
Application.ScreenUpdating = True
End Sub
Best Regards,
Ayush Jain.
[Group Owner
you so much.
-Ayush Jain
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Excel and VBA Tutorials(Video and Text), Free add-ins
Thanks Ashish. I agree with you.
The group members should not share any paid material or Password
cracker in this group. Please adhere the same going forward.
Any violation may lead to termination of membership from the group.
Best regards,
Ayush Jain
Group Owner.
On Feb 10, 12:38 pm, Ashish
Hi Chethan,
Excel is used at most of the places so as VBA. You may apply in
Finance, BPOs, etc.
Let us know if any further assistance is required by us.
Thanks.
Best regards,
Ayush Jain
On Feb 10, 3:56 pm, chethan Bhadravathi chethan...@gmail.com wrote:
Hi Everybody,
i want to know which
,12,CM,AJ)
Any Help ?
The compounding of three sumif like = sumif(.) + sumif() +
sumif() is not I am looking for.
Thanks for advising.
Best regards,
Ayush Jain
--
--
Some important links for excel users
THANKS Aindril. But In Sumifs function it is not possible to have two
criteria(of = sign) on same range.
Any example would help.
The formula =sumifs(A:A,B:B,=12,B:B,=C) does not seems to be
working.
Regards,
Ayush Jain
On Feb 11, 8:37 am, Aindril De aind...@gmail.com wrote:
Hi Ayush,
If you
Dear Sachin,
You can use the Mid Function to extract a particular letters from a
cell. Here is an example:
=MID(A1,4,9)
Let me know if any further assistance is required.
Best Regards,
Ayush Jain
On Feb 13, 4:49 pm, sachinp1...@googlemail.com
sachinp1...@googlemail.com wrote:
Hello Group
Hi Niraj,
It is developed by Ashish Jain...Please contact him at 26may.
1...@gmail.com
Thanks and Best regards,
Ayush Jain
On Feb 13, 8:09 pm, Niraj Kothari nirajskoth...@gmail.com wrote:
Dear Ayush,
I have downloaded this file from your group and i want to use to get live
stock market
Hi Keith,
Would you please send the Excel file where the changes are required ?
Best regards,
Ayush Jain
On Feb 15, 7:41 am, Keith dkb...@gmail.com wrote:
I consider myself a self-taught novice user of VBA for Excel. I took
on a project at work and developed this VBA code with the help
Hi Markkim,
Would you please send the sample file containing this data?
Best regards,
Ayush Jain
On Feb 26, 6:18 am, Markkim mark@gmail.com wrote:
Hi
I have been trying to make these but have failed. ^ ^;;
I’d like to create a macro
A21 has a word called ‘Date’
And somewhere down
of excel also. Anything about excel that you
knowanything
Sharing just increases the knowledge.
Keep Posting...
Best regards,
Ayush Jain
Group Owner
--
--
Some important links for excel users:
1. Follow us
. I loved it.
Best regards,
Ayush Jain
Group Owner.
On Mar 18, 7:28 pm, draco664 draco...@hotmail.com wrote:
Personally, whenever I start a new job, or install a new version of
Excel, the first thing I do is record the following macro.
Sub CopyPasteSpecialValues
Hi,
Did you try Exit for in FOR loop where the condition is met and
further looping is not required.
Give it a try...It should help.
Best regards,
Ayush Jain
On Mar 19, 7:00 am, scubagirl jill.brya...@gmail.com wrote:
I have a fairly large VBA project for work - it runs a Monte Carlo
Hi Harpreet,
Its a good suggestion to have new subject title with a keyword TIP.
Dear Group,
Please share the tips and tricks in a new email message with the TIP
keyword. It really helps.
Best regards,
Ayush Jain
On Mar 24, 8:35 am, Harpreet Singh Gujral harpreetguj...@gmail.com
wrote:
Hi
more than 500 users to make this
group spam free
Best regards,
Ayush Jain
On Apr 3, 9:49 am, pavi pavithra catchpavit...@gmail.com wrote:
Hi All,
It was great to see that the group has completed 3 yrs and my heartful thanx
to all those guys who shared their thoughts and ideas about excel here
I am posting the first idea :-
1) There should be an inbuilt feature of converting number into words.
2) Vlookup searches only in leftmost column of range, why not
rightmost or middle column ?
Now its your turn :)
On Apr 11, 10:59 am, Ayush jainayus...@gmail.com wrote:
Dear members,
Most
Hi Vinod,
It is very simple. Just select the 1st range and apply the filter and
same for 2nd range.
Please let me know if you have more questions.
Best regards,
Ayush Jain
Group Manager
On Apr 11, 10:16 am, vinod rao vinod.ma...@gmail.com wrote:
Hi Vikas,
How did you do this?.
Regards
Vin
and it will automatically apply filter to
those selected ranges.
I hope it helps. Please let me know if you have further doubts.
Best regards,
Ayush Jain
Group Manager
On Apr 11, 11:35 am, vinod rao vinod.ma...@gmail.com wrote:
Hi Ayush,
I could put filter to one selected range and later when i want to put to
other
Thank you Dave fro your inputs.
This is good workaround and weird too. But difficult for those who
have only XL 2003. isn't it ?
Best regards,
Ayush Jain
Group Manager
On Apr 11, 12:41 pm, Dave Bonallack davebonall...@hotmail.com wrote:
Hi Ayush,
There is a sort of a workaround.
If you have
know if any further assistance is required.
Best regards,
Ayush Jain
Group Manager
On Apr 14, 4:37 pm, rf1234 rf1234 rfhyd1...@gmail.com wrote:
Hello Dear,
You can simply read the range,Just use this attached excel Sheet.
Hope it Will Help
Happy To Help
:)
On Wed, Apr 14, 2010 at 4:56 PM
, Dave and
Dilip Pandey for taking this group to next level.
I am proud to be part of this group. If you have any suggestions,
please do not hesitate to share with the group.
Keep Posting !!
Best regards,
Ayush Jain
Group Manager
On Apr 16, 7:51 pm, Suryaprasad suryaprasad...@gmail.com wrote
think it is available.The only thing is it does not red-underlines the
miss-spelled words as MS Word does.
Abhishek
On Mon, Apr 12, 2010 at 11:54 AM, Anand Desai a4an...@gmail.com wrote:
Ayush,
Spellcheck the way available in MS Word.. my be useful.. I m not sure any
facility
Dear group members,
I have added two more Shortcuts in the Secret shortcut of excel
ebook. You can download the ebook from the link http://bit.ly/aX6x3a
Please let me know if you know more such keyboard Shortcuts. I will
include them in next version.
Thank You.
Best regards,
Ayush Jain
. They are not copyrighted at all :)
I hope you understand the same. Any such message again could lead to
termination from the group membership.
Keep Posting.
Best regards,
Ayush Jain
Group Owner
--
--
Some important links for excel users
make a difference in
group
Keep posting !!
Best regards,
Ayush Jain
Group Manager
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
the mails i receive from the group..
I have cheked the first option in ques no 8, as there was no other
option, if someone is not visiting other communities
Harry
On May 31, 10:53 am, Stuart Redmann dertop...@web.de wrote:
On 30 Mai, 17:55, ayush jain jainayus...@gmail.com wrote:
Dear
Dear group,
The survey has received very few hits till date. Please spare a minute
to share your feedback.
It will definitely help us to take this group to next level.
Looking forward to your active participation.
Thank you so much
Best regards,
Ayush Jain
Group Manager
On May 30, 8:55 pm
Hi Nikhil,
Use Pivot tables to get this done...Let us know if any further help is
required.
Best regards,
Ayush Jain
On Jun 11, 1:09 am, Nikhil Shah nikhil201...@gmail.com wrote:
Hi Friends,
Here I am posting Query, pl help.
Name Amt
Bill 1,000
Gopal 1,500
Bill
for your reference. :-
http://www.surveymonkey.com/s/L8BTDNQ
Thanks and Best Regards,
Ayush Jain
Group Manager
On Jun 2, 8:03 am, Ayush jainayus...@gmail.com wrote:
Dear group,
The survey has received very few hits till date. Please spare a minute
to share your feedback.
It will definitely help
4. Under Personalized Menus and Toolbars, click Always show full
menus
5. Click Close
Full menus always look the same, which makes it easier to find what
you’re looking for and is a much better option for new users.
Best regards,
Ayush Jain
On Jun 26, 6:41 pm, kamlesh jain kjain1...@gmail.com
Dear Magan,
It would be easier to help if you can provide some sample data in
excel sheet.
This problem can easily be solved by using vlookup, index, match
functions of excel.
Also, A macro can be written to automate this completely.
Hope it helps.
Best Regards,
Ayush Jain
On Jun 28, 7:39 am
Hi Neil,
Thank you for sharing the useful file.
Best Regards,
Ayush Jain
Group Manager.
On Jul 3, 9:41 pm, neil johnson neil.jh...@googlemail.com wrote:
Hi Everyone,
This is ppt of vlookup . I am very lucky , I am the member of this team. I
am sending attached PPT .
Thanks and Regards
Hi ,
You may also refer to below link to extract numbers from the cell :
http://office.microsoft.com/en-us/excel-help/extracting-numbers-from-alphanumeric-strings-HA001154901.aspx
To attach a file you can send an email to excel-
mac...@googlegroups.com by attaching a file.
Best Regards,
Ayush
the values in running range.
Example:-
A2 cell will refer to range A2:A2 for counting
A3 cell will refer to range A2:A3 for counting
A4 cell will refer to range A2:A4 for counting
and so on...
I hope this helps.
Best regards,
Ayush Jain
Group Manager.
On Jul 5, 7:52 pm, Ankit Agarwal ankit.a
Hi Dilip,
You always make me feel proud by your dedication towards the group.
Hats off to your knowledge and skills.
We all are your fan and look forward for your long association with
the group.
Best Regards,
Ayush Jain
Group Manager.
On Jul 14, 10:30 am, Mathan mathan4s...@gmail.com wrote
:) ) .
We wish you all the best for your assignments and expect long
association with the group.
Thank you Dave :)
I have published the name of monthly top poster on Home Page...
Keep posting !!
Regards,
Ayush Jain
Group Manager
P.S. If you have any feedback for group, please fill the survey
form
Hi Guyzz,
Come on ..Please participate in this
If you dont respond, It means that you dont love excel.
Express yourself !!
Thanks to those who responded quickly :)
-Ayush Jain
Group Manager
On Aug 29, 1:26 am, Vinod N nvino...@gmail.com wrote:
Excel makes life simple
if A C is given
Calculate C if A B is given
You have to provide excel formula only...no VBA allowed
Regards,
Ayush Jain
Group Manager
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips
This initiative will help to increase the reach of this group to the
people who are not aware about this group.
Let me know if you have any questions, concern or feedback.
Thank you
Regards,
Ayush Jain
--
--
Some
to this group.
Best regards,
Ayush Jain
Microsoft MVP
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http
. They both have high willingness to help others
with excellent knowledge of Excel.
Thanks a tonne on behalf of whole group.
Keep posting !
Best regards,
Ayush Jain
Microsoft MVP
--
--
Some important links for excel
.
It was not possible without their valuable feedback and support in
running these initiatives.
last but not least to Microsoft for recognizing me.
I will try my best to bring more resources and make you awesome in
Excel.
Thanks Best regards,
Ayush Jain
Microsoft MVP
:- STMicroelectronics
Location :- Greater Noida
Job Type :- Contractual.
Please let me know if somebody known to you is interested.
Send me the resume at jainayus...@gmail.com.
Thanks.
Best regards,
Ayush Jain
Group Manager
/160307843985936
Thanks.
Regards,
Ayush Jain
discussexcel.com
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group
Hi Paul,
We just love to hear these inspiring words from you...These are
absolutely great wordsYou are not only excel expert but an
inspiring mentor as well.
Keep guiding us.
Thanks.
Ayush Jain
On Nov 1, 8:34 pm, Paul Schreiner schreiner_p...@att.net wrote:
I've always said:
What good
spirit of our composite culture. It also heralds the approach of
winter and the beginning of the sowing season.
I wish that all of you be blessed with joy, prosperity, health,
wealth, harmony, peace, happiness and lights in your life.
Take Care,
Ayush Jain
what are you waiting for...Download it now..
Thanks.
Best regards,
Ayush Jain
Microsoft MVP 2010
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com
!!
Best Regards,
Ayush Jain
Microsoft MVP 2010
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http
://www.masterofmacros.com/affiliates/idevaffiliate.php?id=101
I encourage you to visit the link and have a look at the program
details. Feel free to get ask me any questions you have
Thank you,
Ayush Jain
Microsoft MVP 2010
.
The MMEARLYBIRD 30% off coupon expires on Nov 24, 23:59 Eastern Time,
Please take advantage of this last chance.
Feel free to ask questions and give feedback about the program.
Thanks.
Best Regards,
Ayush Jain
Group Manager.
On Nov 19, 10:25 pm, ayush jain jainayus...@gmail.com wrote:
Dear group
- USA
Take advantage of opportunities!
This $40 discount will be gone in just two hours
Enroll today!
Please be aware of the coupon field on the cart and to apply it to get
the discount, and to not proceed until they see the price was modified
in the cart.
Enjoy!
AYUSH JAIN
MICROSOFT MVP 2010
P.S
.
I appreciate your spirit of helping people from your wonderful
Knowledge. Keep it up.
Best Regards,
Ayush Jain
Microsoft MVP
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks
in excel
5) Select a macro from Assign Macro window
6) Click OK.
I hope it helps. Please let us know if any further assistance is
required.
Keep Posting!
Best Regards,
Ayush Jain
Group Manager
Microsoft MVP 2010
p.s. You have not mentioned a subject Title as well. Please keep these
things in mind
of information on VBProject object model.
http://www.cpearson.com/excel/vbe.aspx
I hope it helps. Please let me know if you are able to find solution
from any other source.
Good Luck!
Keep Posting.
Best Regards,
Ayush Jain
Group Manager
Microsoft MVP 2010
P.S. Please use appropriate subject title
Submit your VOTE , IDEA @ http://goo.gl/mod/psLh
Thanks.
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @
in ThisWorkbook object
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
If Sheets(1).Range(A1) = Then
MsgBox Please fill the value in Cell A1
Cancel = True
End If
End Sub
Hope it helps. Let us know of any further assistance is required.
Best Regards,
Ayush Jain
.
*“Ideas are the beginning points of all fortunes.”*
Thanks and Best Regards,
Ayush Jain
Microsoft MVP
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com
Hi Kemas,
It is referring to second filter of the Active sheet. It is not necessary to
be the second column of the sheet.
Let us know if you have any further questions.
Thanks.
Best Regards,
Ayush
--
--
Some
Dear Upendra,
Well, if your code is working fine to query excel fileYou can use
Select distinct * from [RECEIVE$] to pull distinct data from the column.
Not sure if it will help you. Write back in case you need something else.
Best Regards,
Ayush Jain
Microsoft MVP
, There is layout options
5) Select Back to Front in Page order: field.
6) Click ok and print the page.
I have enclosed a snapshot of the same for your reference. Do give a try and
let me know if it helps you.
Feel free to write back to us if you have further questions.
Best Regards,
Ayush Jain
Microsoft
reverse_sheet_order()
Dim TotalSheets As Integer
TotalSheets = ActiveWorkbook.Sheets.Count
For i = 1 To TotalSheets
Sheets(TotalSheets).Move before:=Sheets(i)
Next
End Sub*
Please give it a try and let me know if it helps you.
Best Regards,
Ayush Jain
Microsoft MVP
knowledge of excel. Keep it up.
Thanks a tonne on behalf of whole group.
Keep posting !
Best regards,
Ayush Jain
Microsoft MVP
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks
his
recognition.
Dear Dilip, Many Many congratulations, Keep it up.
I am very proud of you to be part of this group. I wish your long
association with this group.
Best Regards,
Ayush Jain
Microsoft MVP-2010
HI Nihal,
Dont use www.
Just write discussexcel.com and you will be redirected to this discussion
forum.
Thanks.
Best Regards,
Ayush Jain
Microsoft MVP
--
--
Some important links for excel users:
1. Follow
1 - 100 of 333 matches
Mail list logo