Yeah this is very useful siten quick tooo
--
--
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 @
Sub bubblesort()
Dim i As Integer, j As Integer, n As Integer, temp As Single
n = Selection.Rows.Count
For j = n To 3 Step -1
For i = 1 To j - 1
If Selection.Cells(i, 1) Selection.Cells(i + 1, 1) Then
temp = Selection.Cells(i, 1)
Selection.Cells(i,
Many thanks Danielresult is perfect. One more querry is posted.
Please help.
On Jun 15, 2:40 pm, Daniel dcolarde...@free.fr wrote:
Maybe this file ?
Daniel
-Message d'origine-
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Nemi Gandhi
Dear Members,
i need the formula please..
--
Nemi Gandhi
98204 92963
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our
recruiter id mee...@s3ci.com
or call @ 0- 8447733049
Hi,
This is regarding an urgent opening for Reporting Analyst, with one of our
reputed client.
Client: United Health Group
Location: Gurgaon
• Ensures that informational needs of our client and internal customers are
met by designing and
See attached file.
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Nemi Gandhi
Envoyé : jeudi 16 juin 2011 13:02
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ querry-3
Dear Members,
i need the formula please..
--
There is a Custom Toolbars Button available for the Quick Access
Toolbar. This button has drop-down capability, so I assume
commands can be added to this button.
Can anyone point me to an example of how this button can be used - my
web searches have pinpointed no results.
--
Dear Friends,
Can any one please help me in *how to learn Excel-VBA* through some
tutorial materials as i am CA Final student.
-
Yours,
Hari.
--
--
Some important links for excel users:
1. Follow us on
Your code is working fine...Can you elaborate what do you want to do,
exactly?
On Jun 16, 3:11 pm, airen airen1...@gmail.com wrote:
Sub bubblesort()
Dim i As Integer, j As Integer, n As Integer, temp As Single
n = Selection.Rows.Count
For j = n To 3 Step -1
For i = 1 To j - 1
Thank you for your help but quite simply, no! It's saving a file as
UTF8 which is a specific encoding format, supporting more characters
than other formats. Excel does not natively support UTF8 despite it
being widely used. This code will allow you to do that, which I've
now tidied up and
Dear Excel Teachers,
I need a formula to give me the decimal hours between two dates. I have
attached a sample.
Thanking you in advance for your on-going help and wisdom.
John
--
--
Some important links for excel
Dear John,
Please try it..
=IFERROR(ROUND(VALUE(HOUR(D18)+(MINUTE(D18)/60)),1),)
--
Thanks regards,
Noorain Ansari
On Thu, Jun 16, 2011 at 8:05 PM, John A. Smith johnasmit...@gmail.comwrote:
Dear Excel Teachers,
I need a formula to give me the decimal hours between two
Dear Hari,
Just watch the below link video's you may get Some of basics in Excel VBA
http://www.teachmsoffice.com/list-of-tutorials.php?src=tegb
Best Regards,
Venkat
On Thu, Jun 16, 2011 at 8:35 PM, Hari harisha.prabha...@gmail.com wrote:
Dear Friends,
Can any one please help me in
hi friend
my suggestion: www.excel-vba-easy.com. this site best for beginning vba
learners
thanksbest regards
XL tutor
gsha technologies
ameerpet,annapurna block, aditya enclave ,hyd
#317(third floor)
On Wed, Jun 15, 2011 at 7:12 PM, Shaik Waheed waheedb...@gmail.com wrote:
Dear Experts,
Hi Skanda,
you can do one thing, first select the numbers and then go to
Format Format cells number tab custom 0
In case any query, please feel free to contact.
Thanks Regards,
Manish Singh Bankoti
On Fri, Jun 17, 2011 at 3:46 AM, Skanda skanda.pokkun...@gmail.com wrote:
Hi,
Hi Dave,
Good Morning.
Thanks .
Regards
Kannan V
9941077703
onechennaiproperty.com
On Thu, Jun 16, 2011 at 2:06 PM, Dave Bonallack
davebonall...@hotmail.comwrote:
Hi Kannan,
Have a look at the attached
Regards - Dave
--
Date: Thu, 16 Jun 2011
Put '000745689002346789
On Fri, 17 Jun 2011 08:08:15 +0530 wrote
Hi,� How to add zeros in front of a value with varying lengths so that the
length of the column is 9?for instance a column policy id has values with
varying lengths as follows:�
Policyid:�7456892346789��so i need to transform
add ' sign before the policy id '00078999...
check the attachment
On Fri, Jun 17, 2011 at 9:07 AM, nehal sejpal nehal_c...@rediffmail.comwrote:
Put '000745689002346789
On Fri, 17 Jun 2011 08:08:15 +0530 wrote
Hi,� How to add zeros in front of a value with varying lengths so that the
Hi Skanda,
Assuming the data provided by you is in Column A, use following formula:-
=REPT(0,9-LEN(A2))A2
Sample worksheet is attached herewith.
Let me know if this helps.
Best Regards,
DILIPandey
On 6/17/11, Skanda skanda.pokkun...@gmail.com wrote:
Hi,
How to add zeros in front of a
Hi,
I would suggest to follow Microsoft online tutorials help OR Google
for Excel-VBA tutorial for beginners.
Best Regards,
DILIPandey
On 6/15/11, Shaik Waheed waheedb...@gmail.com wrote:
Dear Experts,
As I am beginner in VBA, please suggest me any institute in Hyderabad or any
best
check out the linkS below
http://akoul.wordpress.com/2011/05/28/excel-video-tutorials/
http://akoul.wordpress.com/2011/05/27/excel-blogs-and-websites-learn-excel-online/
On Fri, Jun 17, 2011 at 11:24 AM, Dilip Pandey dilipan...@gmail.com wrote:
Hi,
I would suggest to follow Microsoft
21 matches
Mail list logo
